Video Contents Index

Part 1. Basic Introduction

1. What's new in 2007 2. The Ribbon Menu 3. The Office Button 5. Keyboard Shortcuts

Part 2: First Excel File

1. Creating Excel Files 2. Cells, Rows and Columns 3. Entering Data 4. Saving Files

Part 3: Working with Worksheets

1. Add, Delete and Rename 2. Tab Colors 3. Split Windows/Freeze Panes 4. Hide and Unhide 5. Protect and Un-Protect 6. Working with Shapes

Part 4: Cell Formats and Options

1. Height and Width of Rows & Columns 2. Types of data 3. Align and Indent 4. Font Options 5. Hyperlinks 6. Context Menu 7. Insert, Delete and move columns, rows & Cells 8. Cut, Copy and Paste 9. Paste Special 10. Clipboard 11. Cell Borders 12. Merge Cells 13. Wrap Text

Part 5: More on Formatting

1. Conditional Formatting 2. Data Validation 3. Naming Ranges 4. Special Characters 5. Format Painter

Part 6: Formulas and Functions

1. Relative and Absolute Cell References 2. Other Sheets references 3. Functions 4. Function Examples

Part 7: Dealing with Data

1. Importing Data2. Text to Columns3. Duplicate Data4. Sort & Filter Data

Part 8: Finalizing the Workbook

1. Check Spellings 2. Cell Comments 3. Hide Worksheets 4. Find and Replace 5. Lock and Unlock Cells

Part 9: Printing Your Workbook

1. Print Ranges2. Margins3. Shrink to Fit4. Header/Footer5. Page Breaks

Part 10: Charts and Labels

Part 11: Pivot Tables

1. Build 2. Options