Lesson 1: Getting Acquainted
with Excel 2007
1.1 The interface of Excel 2007
1.2 How to customize the quick
access toolbar
1.3 The status bar
1.4 How to use help
1.5 New features of Excel 2007
Lesson 2: Basic Operation
2.1 Create a new worksheet
2.2 Perform basic operations upon
cells
2.3 Add comments
2.4 Sort your data
2.5 Use and manipulate multiple
worksheets
2.6 Split windows and freeze
panes
2.7 Protect your worksheet
2.8 Use Print Review
2.9 Save a worksheet
Lesson 3: Worksheet Format
3.1 Change fonts and font styles
3.2 Change number format settings
3.3 Adjust row height and column
width
3.4 Hide/unhide columns and cells
3.5 Change borders and shading
3.6 Use formatting
Lesson 4: Formula and Functions
4.1 Use formulas
4.2 Use array formulas
4.3 Insert functions
4.4 Use AutoSum
Lesson 5: Editing Graphics
5.1 Insert pictures
5.2 Edit pictures
5.3 Use SmartArt
5.4 Insert shapes