What is Excel? And why would I use a spreadsheet?

Most of us understand that word processing software makes it much easier to create documents such as letters, forms, invitations, greeting cards and anything that contains text. Well – Excel does the same thing for us – making it easier to work lists, figures, numbers for list management, budget, statistics, data – anytime any type of calculation needs to be done. Although Excel spreadsheets/worksheets used to be used primarily for accounting and other analytical information where calculations needed to be made easily; but many of us find them a wonderful resource for list and other data management.

Like so many software application programs, Excel opens with a blank document – but in Excel that blank document is a blank worksheet, which is actually a grid of rows and columns.

In Excel, the rows of you spreadsheet/worksheet are serially numbered 1,2,3 .... and the columns are serially lettered A,B,C..... This numbering enables each space or cell to have its unique address; thus D15 represents the cell in the 4th column and the 15th row.

In Excel, using the ‘=’ sign, simple mathematical equations or formula can be used and sums, differences, products etc. calculated. Thus typing say, ‘=23+56’ in any cell will give the result of 79. The same work can be done by typing in the numbers 23 in cell A1, 56 in A2 and ‘=A1+A2’ in cell A3 and in fact what you have done is create a “formula”

Using a formula with cell references allows us to change the value in either cell A1 or A2 to get the revised result. This has significant advantages when using a complex formula or the same formula across multiple cells. The more recent your version of Excel, the easier it is to create and/or use formulas included in the software command list.

So many of the basic commands that we use all the time in Word Processing whether you use Microsoft Word Pad, Word or Word Perfect, such as Open, Save, Copy, Paste, Find, Replace Undo, Redo, Center, Left, Right etc.. are also available and work the same in Excel, Excel also offers a variety of basic commands that are designed to work with spreadsheets – whether you are managing a list of data or one with numbers and some of those are Paste Special, Filter, Sort, Wrap Text, Autofill, and Freeze panes.

And with the newer versions - Excel 2003, 2007 and 2010 - each new version adds more and more "templates" so that we don't have to recreate the wheel - so whether you are creating a budget for the holidays, a special event, your vacation or next years income & expenses - or various lists for managing data - there are hundreds of templates to choose from with the formulas already built in...

So whether you are trying to create a basic budget or want a way to quickly and easily maintain you all of your contact lists in one document – Excel is the answer.. So give it a try... it's easier than you think and can be used for so many things..

Excel 2010 - Create an "Auto Fill List" Office 2010

EXCEL 2010 - HOW TO CREATE/ADD YOUR OWN CUSTOMIZED “AUTO FILL LIST” (this has changed a little since earlier versions of Excel)

If you have a list/header row already typed on a spreadsheet – skip this step

“Type your list either in the first row or the first column” of an Excel spreadsheet

• Highlight this customized list that you want to add to the Auto Fill Master list
• Now, go to the File Tab & choose “Options”
• In the Options list – in the left column, Choose Advanced
• Bring the scroll bar on the right down almost to the bottom.. until you see the button “EDIT CUSTOM LIST” (to the right of “create lists for the use in sort 7 fill sequences”)
• That Opens the Edit Custom List Dialog Box – toward the bottom right, left click in the button Import
• Now you will see your list in the right column-“List Entries” and in the left list “Custom Lists” – Click OK

Notes:

• If you have a list in another program (word, word perfect, email, etc) – simply highlight and copy the list in that program, open the Edit Custom List Dialog Box, right click and choose paste – the list will not be in the “List Entries” and when you add it – it will be added with the commas after each word/phrase.
• To change this list in the future (add or remove titles), come back to this dialog box, left click on the custom list on the left side that you want to change – the list will appear in the “List Entries” on the right – make the change and then click on ADD, then click OK
• You can only change “custom lists” you’ve created, not ones that came with your software..

Excel – what do the “auto’s” mean

When you are working in Excel – there are several “auto” functions and they can be confusing as to how and why they are different.. Hopefully this will help…

AutoFill – creates and/or completes a series of values in an Excel spreadsheet – for example you can type January at the top of a column, and if you then drag the + auto handle from the bottom right corner of the cell that January is typed in across the rows to the right of January, Excel will now “auto-fill” February, March, April etc and continue on…

AutoFormat – adds chosen attributes to your spreadsheets, such as font styles and sizes, borders and even ranges of numerical styles – so highlight the table or area you want to format and when you choose format, auto format various styles, colors etc will appear – choose the one you like and Excel will now format that portion of the table or spreadsheet that you have highlighted – don’t like what you’ve chosen – change it

AutoSum – this adds up a column or several columns or a row of figures in a spreadsheet. This is the icon for Auto Sum “S” – So if you put your cursor in a cell at the end of a row or column (or you can highlight the range of cells” and then click on this icon on the toolbar – once you have clicked on the icon, press enter on your keyboard and Excel will calculate the total for the selected range (By the way the keyboard shortcut for this that does the same thing is: Alt + =)