Kindly help me!

  • Thread starter Thread starter Vikrama Sanjeeva
  • Start date Start date
V

Vikrama Sanjeeva

Hi,
I am a perfect newbie in MS Excel. I am using Microsoft Excel 2003.
I have lots of BILLS in form of paper in an *unorganized manner. Now I
want to make Five columns,

1: Date.
2: Amount.
3: Currency.
4: Company.
5: Description.

After these columns are created, I will start entering data. Now I
want this data to be sort on "monthly basis". Like BILLS are arranged
on month basis.
But problem is that, I don't even "know how to create a column"?
"How to name a Column?" and "How to sort data on mothy basis".
This is simple task, but kindly let me know as soon as
possible, as this is a task assigned by my BOSS.


Bye,
Viki.


Note: My job is a Java programming and not enering data and making
excel sheets. But unfortunately, some employers never cares about
these differences. I really love to make this task possible by writing
Java program, but he wants in MS Excel 2003.
 
Hi Viki

i would strongly suggest that you try and get on a 1-2 day hands-on
introductory excel course as this will give you a good grasp of the basics
but failing that ...

open up excel
it will open with a new "workbook"
down the bottom of the page you should see something like
sheet1 sheet2 sheet3
these are known as "worksheets" a workbook can hold as many of these as you
need

each worksheet consists of 256 columns (named A to IV) and 65536 rows (named
1 to 65,536) , the intersection of these two things is called a cell - each
cell has a reference - the column letter & the row number .. so the top
leftmost cell is A1 .. make sure you are on sheet1 (it should be a different
colour on the tabs - where the sheet1 sheet2 sheet3 names are - you can
rename these by double clicking on them and then pressing enter when you've
finished giving them a name)

So click in A1 type the word Date, press enter
click in B1 type Amount press enter
put Currency in C1, Company in D1 & Description in E1

select from A1:E1 (that means click in A1, hold down your left mouse button
and drag to E1) ... when we're talking about a group of cells (called a
range) we use the above notation (first cell : last cell) now click on the B
icon on your toolbar they should now be bold
so now on row 2 you can enter the bills by clicking in the column, typing
the information & pressing enter

just some notes - when entering dates they must be entered using either a /
or a -
e.g dd/mm/yy (or mm/dd/yy) or dd-mm-yy (or mm-dd-yy) which ever is relevant
for your region

when you've entered a couple of lines - don't forget to save the file
somewhere so you can find it again later (file / save - choose a location &
give it a name)

Hope this gets you started
Cheers
JulieD
 
Columns are already made

In Row 1 enter in your Headings as you listed below

Put your cursor in Cell A2 - go to Window, Freeze Pane
This will allow you to keep the top row showing no matter what

In Cell A3, enter first date of first bill
continue on until you finish data entry

To sort, select all cells, Data, Sort, Click you do have a header row, sort by
date

I would inform your boss, that he/she would be much better off 1) hiring a
bookkeeper/accountant to keep the bills in order or 2) a data entry clerk who
would need much less $$$ than a Java Programmer


You will want to read Excel help and look at getting "Excel for Dummies" (Not
calling you a dummy but it is an excellent way for a layman to learn Excel)


: Hi,
: I am a perfect newbie in MS Excel. I am using Microsoft Excel 2003.
: I have lots of BILLS in form of paper in an *unorganized manner. Now I
: want to make Five columns,
:
: 1: Date.
: 2: Amount.
: 3: Currency.
: 4: Company.
: 5: Description.
:
: After these columns are created, I will start entering data. Now I
: want this data to be sort on "monthly basis". Like BILLS are arranged
: on month basis.
: But problem is that, I don't even "know how to create a column"?
: "How to name a Column?" and "How to sort data on mothy basis".
: This is simple task, but kindly let me know as soon as
: possible, as this is a task assigned by my BOSS.
:
:
: Bye,
: Viki.
:
:
: Note: My job is a Java programming and not enering data and making
: excel sheets. But unfortunately, some employers never cares about
: these differences. I really love to make this task possible by writing
: Java program, but he wants in MS Excel 2003.
 
You need to make a simple table. Start by typing your column name
across in row 1 of a worksheet (this names your columns), then typ
your data underneath in row 2 down. Don't forget to make a backu
workbook copy occasionally.

Don't be tempted to use separate worksheets. Make extra columns if yo
need to put more detail.

You will then be able to use Pivot Tables and other Excel functions t
analyse the data into whatever format you want. See Excel Help menu.

There is a range of tools you can use contained in the "Data" menu
With a simple table, if you make sure that you have selected a cel
within the table Excel will figure out what range to use. Then just tr
them out.

Make new messages for any further queries. Good luck
 
Back
Top