| Chapter 1 How to create a simple worksheet in Excel |
- Starting up Excel
- Navigating in Excel
- Entering information in Excel
|
| Chapter 2 Creating simple formulas |
- Opening a worksheet
- Creating a formula
- Practice
|
| Chapter 3 Using AutoSum and other basic formatting options |
- Basic formatting options
- Practice
- Deleting Columns and Rows
- Using the Autoformat Option
|
| Chapter 4 Utilizing more formatting options |
- Another way to open Excel
- Entering two line headings
- Other formatting options
- Practice
|
| Chapter 5 More formatting options |
- Printing a worksheet
- Practice
- Renaming a sheet/li>
- Creating a custom footer
|
| Chapter 6 Reorganizing your worksheet |
- Practice
- Practice
- How to move cells
- How to copy cells
- How to copy rows
- How to copy columns
- Practice
|
| Chapter 7 Formatting numbers and adjusting margins |
- How to format numbers
- Changing font color
- How to change the background color
- Practice
- Practice
- How to change margins
|
| Chapter 8 More formatting techniques |
- Practice
- Using the same invoice format for several clients
- Practice
- Creating an embedded chart using the Chart Wizard
- How to increase the column width
- Practice
|
| Chapter 9 Working with multiple worksheets I |
- How to create a series of text
- Practice
- More on Arithmetic Operators
- Practice
- Introduction to functions
- Practice
- More on formatting
- How to create a 3D chart
|
| Chapter 10 Getting excited about your skills I |
|
| Chapter 11 Getting excited about your skills II |
|
| Chapter 12 Getting excited about your skills III |
|
| Chapter 13 Getting excited about your skills IV |
|
| Chapter 14 Using the Drawing Toolbar |
- Using the Drawing Toolbar
- Practice
|
| Chapter 15 Working with multiple worksheets II |
|
|
| Chapter 16 Working with multiple worksheets III |
- Adding worksheets to a workbook
- Practice
- How to link worksheets
- Practice
|
| Chapter 17 Creating a custom footer |
- How to create a custom footer
- Practice
- Practice
|
| Chapter 18 Practice |
| Chapter 19 Testing you skills |
| Chapter 20 Final Test |