1. A
Simple Workbook
1. Creating A New
Workbook
2. Entering Data In A
Workbook
3. Saving A New
Workbook
4. Opening A Saved
Workbook
5. Creating An Input
Range
6. Saving Your Work
7. Essential
Formatting
8. Column Best Fit
9. Closing A Workbook
10. A Simple Workbook
Quick Reference
2.
Selecting Ranges
1. Selecting
Contiguous Ranges
2. Selecting
Non-Contiguous Ranges
3. Using Special
Selection Techniques
4. Selecting Larger
Ranges
5. Range Calculations
6. Selecting Ranges
Quick Reference
3.
Formulas
1. Understanding
Formulas
2. Formulas That Add
3. The Sum Function
4. Formulas That
Subtract
5. Formulas That
Multiply And Divide
6. Referential
Formulas
7. What If Formulas
8. More Complex
Formulas
9. Formula Error
Checking
10. Common Error
Messages
11. Formulas Quick
Reference
4.
Copying And Filling
1. Understanding
Copying In Excel
2. Using Fill For
Quick Copying
3. Copying From One
Cell To Another
4. Copying From One
Cell To Multiple Cells
5. Copying From Many
Cells To Many Cells
6. Copying Relative
Formulas
7. Copying To A
Non-Contiguous Range |
5.
Working With Functions
1. Functions
2. Typing A Sum
Function
3. Summing
Non-Contiguous Ranges
4. Calculating An
Average
5. The Maximum
Function
6. The Minimum
Function
7. Working With
Functions Quick Reference
6.
Working With Workbooks
1. The Open Dialog
Box
2. Opening A Workbook
3. Closing A Workbook
4. Opening Multiple
Workbooks
5. Working With
Multiple Workbooks
6. Opening Recently
Used Workbooks
7. Compare Workbooks
Side By Side
8. Working With
Workbooks Quick Reference
7.
Working With Worksheets
1. Copying A
Worksheet
2. Renaming
Worksheets
3. Moving Worksheets
4. Inserting And
Deleting Worksheets
5. Grouping
Worksheets
6. Colour Coded
Worksheet Tabs
7. Working With
Worksheets Quick Reference
8.
Adjusting A Worksheet
1. Inserting Cells
2. Deleting Cells
3. Inserting Columns
4. Inserting Rows
5. Deleting Rows And
Columns
6. Resizing Columns
7. Resizing Rows
8. Hiding Grid Lines
9. Adjusting A
Worksheet Quick Reference |
9.
Viewing Worksheets
1. Freezing Columns
And Rows
2. Splitting Windows
3. Using Zoom
4. Hiding Rows And
Columns
5. Viewing Worksheets
Quick Reference
10.
Formatting Cells
1. Using The Font
Tools
2. Using The
Alignment Tools
3. Using The Number
Tools
4. The Format Cells
Dialog Box
5. Formatting Fonts
Using The Menu
6. Superscript,
Subscript And Strikethrough
7. Changing
Horizontal Alignment
8. Centering Across A
Selection
9. Wrapping Text
10. Changing Text
Orientation
11. Changing Vertical
Alignment
12. Formatting Dates
13. Formatting Numbers
14. Formatting Currency
15. Creating Custom
Formats
16. Borders And Shading
17. Clearing Cell
Formats
18. Formatting Cells
Quick Reference
11.
Printing
1. Print Preview
2. Simple Printing
3. Previewing Large
Worksheets
4. Page Orientation
5. Scaling To Fit
6. Printing To
Multiple Pages
7. Creating Page
Headers And Footers
8. Formatting Headers
And Footers
9. Printing Formulas
10. Printing Quick
Reference. |
