1. Getting To Know Excel
1. Starting Excel
2. The Excel Screen
3. Using The Ribbon
4. Using KeyTip Badges
5. Minimising The Ribbon
6. Using Shortcut Menus
7. Launching Dialog Boxes
8. Customising The Quick Access
9. Toolbar
10. The Office Button
11. Using The Office Button
12. The Status Bar
13. Customising The Status Bar
14. Exiting Safely From Excel
2.
Creating A New Workbook
1. Understanding Workbooks
2. Using The Blank Workbook Template
3. Typing Text Into A Worksheet
4. The Save As Dialog Box
5. Saving A New Workbook
6. Typing Numbers Into A Worksheet
7. Typing Simple Formulas In A Worksheet
8. Easy Formulas
9. Typing Dates In A Worksheet
10. Easy Formatting
11. Checking Spelling In A Worksheet
12. Making And Saving Changes
13. Printing A Worksheet
14. Safely Closing A Workbook
3.
Working With Workbooks
1. Opening An Existing Workbook
2. Moving About A Worksheet
3. Moving About A Workbook
4. Going To A Specific Location
5. The Open Dialog Box
4.
Editing In A Workbook
1. Understanding Data Editing
2. Overwriting Cells Contents
3. Editing Longer Cell Entries
4. Editing Formulas
5. Editing Functions
6. Clearing A Cell
7. Deleting In A Worksheet
8. Undoing And Redoing Operations
5.
Formulas And Functions
1. Understanding Formulas
2. Creating Formulas That Add
3. Creating Formulas That Subtract
4. Formulas That Multiply And Divide
|
5. Understanding Functions
6. Using The SUM Function To Add
7. Summing Non-Contiguous Ranges
8. Calculating An Average
9. Finding A Maximum Value
10. Finding A Minimum Value
11. More Complex Formulas
12. What If Formulas
6.
Formula Referencing
1. Absolute Versus Relative Referencing
2. Relative Formulas
3. Problems With Relative Formulas
4. Creating Absolute References
5. Creating Mixed References
7.
Selecting Ranges
1. Understanding Ranges
2. Selecting Ranges
3. Selecting Non-Contiguous Ranges
4. Using Special Selection Techniques
5. Selecting Larger Ranges
6. Selecting Rows
7. Selecting Columns
8. Viewing Range Calculations
9. Creating An Input Range
8.
Copying Excel Data
1. Understanding Ranges
2. Selecting Ranges
3. Selecting Non-Contiguous Ranges
4. Using Special Selection Techniques
5. Selecting Larger Ranges
6. Selecting Rows
7. Selecting Columns
8. Viewing Range Calculations
9. Creating An Input Range
9.
Font Formatting
1. Understanding Font Formatting
2. Working With Live Preview
3. Changing Fonts
4. Changing Font Size
5. Growing And Shrinking Fonts
6. Making Cells Bold
7. Italicising Text
8. Underlining Text
9. Changing Font Colours
10. Changing Background Colours
11. Using The Format Painter
12. Applying Strikethrough
13. Subscripting Text
14. Superscripting Text
|
10.
Cell Alignment
1. Understanding Cell Alignment
2. Aligning Right
3. Aligning To The Centre
4. Aligning Left
5. Aligning Top
6. Aligning Bottom
7. Aligning To The Middle
8. Rotating Text
9. Indenting Cells
10. Wrapping And Merging Text
11. Merging And Centring
12. Merging Cells
13. Unmerging Cells
11.
Row And Column Formatting
1. Approximating Column Widths
2. Setting Precise Column Widths
3. Setting The Default Column Width
4. Approximating Row Height
5. Setting Precise Row Heights
6. Hiding Rows And Columns
7. Unhiding Rows And Columns
12.
Number Formatting
1. Understanding Number Formatting
2. Applying General Formatting
3. Formatting As Currency
4. Formatting Percentages
5. Formatting As Fractions
6. Formatting As Dates
7. Using The Thousands Separator
8. Increasing And Decreasing Decimals
13.
Printing
1. Understanding Printing
2. Previewing Before You Print
3. Performing A Quick Print
4. Selecting A Printer
5. Printing A Range
6. Printing An Entire Workbook
7. Specifying The Number Of Copies
8. The Print Dialog Box
14. Creating Charts
1. Understanding The Charting Process
2. Choosing The Chart Type
3. Creating A New Chart
4. Working With An Embedded Chart
5. Resizing A Chart
6. Dragging A Chart
7. Printing An Embedded Chart
8. Creating A Chart Sheet
9. Changing The Chart Type
10. Changing The Chart Layout
11. Changing The Chart Style
12. Printing A Chart Sheet
13. Embedding A Chart Into A Worksheet
14. Deleting A Chart
Concluding Remarks
|
