free manual tutorial: Get going with Excel 2000

Get going with Excel 2000, by Palle Gronbek

60 pages

Free download of this manual/tutorial

General concepts - What is a spreadsheet? - Inserting text and numbers - Data types - Inserting formulas
Editing - Changing the contents of a cell - Deleting the contents of a cell - Undo - Column width
Simple number formatting - Simple marking - Copying cells - Summing data - Save a file
Help - The ‘Answer Wizard’ tab - Shift+F1 - Tip Wizard - Help for dialog boxes
A household budget - Permanent preferences - The budget - Insert rows - Deleting rows - Insert/delete several rows - Inserting and deleting columns - Font and font size
Filling in (series) - Creating your own lists - Numbers and formulas in our budget - Selecting formulas - Save the budget
Absolute cell references - Year total - Check your formulas
Navigation - Formatting - Excel and Windows - Toggling formats - More data
Viewing the spreadsheet - Zoom - Freeze panes - More data - Quick copying using the keys - Save - Revision - Save As
Formatting - Autoformat - Removing an Autoformat
Manual formatting - Moving data using the mouse - Moving data with the keyboard - Updating formulas
Lines and borders - Remove gridlines - Changing and removing a border - Shading and colour - Copy formats
Printing the budget - Data layout - Centering headings - Vertical layout - Create your own number formats - Naming cells
Other advantages with names - Entering formulas - Jumping to named cells - Names in ‘A household budget’
Printing - Margins - Headers and footers - Scaling the printout - Manual page breaks - Repeating headings - Print area - Fixed print area - Printing areas (name)
Customising toolbars - Charts - A chart on a new page - Updating a chart - Adjusting the format in a chart - Chart types - 3-D perspective - Save diagram - A chart on this sheet - Selecting data - Printing charts
The household budget - Working with a workbook tab - Naming tabs - Deleting a sheet - Inserting a sheet - Copying sheets - Tools - Average - Other functions - Calculating loans - Naming cells in functions. - Links - The logical function: =If() - The function’s construction - Calculations in the IF function - Messages in the IF function
Sorting & filtering data - Sorting - Filtering - User defined filters
‘Where do you want to go tomorrow?’ - Read this while the cat plays with the mouse