| Microsoft Excel 2008 Basic
1.0 Exploring Excel
1.1 Exploring the Excel Program Window
1.2 The Office Button
1.3 The Quick Access Toolbar
1.4 Displaying Tabs
1.5 Using Worksheets and Workbooks
1.6 Entering Data in Excel
1.7 Deleting and Replacing Entries
1.8 Saving
1.9 Opening and Closing Workbooks
1.10 Exiting from Excel
2.0 Viewing, and Printing Worksheets
2.1 Views of Excel
2.2 Selecting
2.3 Working with Cut, Copy, and Paste
2.4 Clearing Cell Contents and Formats
2.5 Working with AutoFill
2.6 Printing
3.0 Using Formulas and Functions
3.1 Formula Basics
3.2 Creating Formulas
3.3 Formula Cell References
3.4 Moving and Copying Formulas
3.5 Showing Formulas
4.0 Formatting Worksheet Data
4.1 Formatting Numbers
4.2 Aligning (vertical, rotating)
4.3 Indenting
4.4 Merging and Splitting Cells
4.5 Borders and Fill Colors
4.6 Using AutoCorrect
4.7 Spell Check
5.0 Changing Columns Rows and Cells
5.1 Inserting and Deleting
5.2 Changing Columns and Row Sizes
5.3 Hiding
6.0 Creating Charts
6.1 Creating Column and Bar Charts
6.2 Creating Pie Charts
6.3 Editing Charts
6.4 Changing Chart Types
6.5 Deleting Charts
Microsoft Excel 2008 Advanced
1.0 Using Templates
1.1 Creating Templates
1.2 Customizing Templates
2.0 Worksheet Techniques
2.1 Freezing Columns and Rows
2.2 Page Layout View
2.3 Copying and Moving Sheets
2.4 Headers and Footers
2.5 Continuing Titles
2.6 Page Breaks
2.7 Inserting and Deleting sheets
2.8 Changing the Default Number
3.0 Using Tables and Outlines
3.1 Creating a Table
3.2 Sorting Data
3.3 Filtering Data
3.4 Using Outlines
3.5 Displaying Subtotals
4.0 Advanced Formulas and Functions
4.1 Linking Formulas
4.2 Using Ranges
4.3 Using Names
4.4 If Function
4.5 PMT Function
4.6 Hlookup
4.7 Vlookup
5.0 Protection
5.1 Protecting Workbooks
5.2 Protecting Worksheets
6.0 PivotTables and PivotCharts
7.0 Data Validation |
