Table of Contents Excel
Lesson I – The Screen Views
Step 1: Create a New Folder
Step 2: Open the Microsoft Excel Program
Step 3: Help
Step 4: The Title Bar
Step 5: Office Button and Excel Options
Step 6: The Quick Access Toolbar
Step 7: Close and Open a Workbook Window
Step 8: The Ribbon
Step 9: Name Box and Formula Bar
Step 10: Status Bar, Zoom, and Normal View
Step 11: Horizontal and Vertical Scroll Bars
Step 12: Cells
Step 13: Columns
Step 14: Rows
Step 15: Sheet Tabs
Lesson II - Create an Excel Workbook
Step 16: Save an Excel Workbook
Step 17: Open Folders and Files
Step 18: Format Cells
Step 19: Borders
Step 20: Fill Color
Step 21: Change Alignment of Text
Step 22: Format the Text
Step 23: Add the Date and Time
Step 24: AutoFill
Step 25: Clip Art
Step 26: Add Data to Cells
Step 27: Format Painter
Step 28: Freeze Panes
Step 29: AutoSum
Step 30: Arithmetic Operators
Step 31: Share Cell Information
Step: 32 AutoFill Formulas and Copy Data to Adjacent Cells
Step 33: Format Numbers
Step 34: AutoCorrect
Step 35: Page Layout View and Page Break Preview
Step 36: Print Preview, Set Print Area, and Print
Lesson III - Formulas and Functions
Step 37: Formula Auditing
Step 38: Insert Function
Step 39: FV Future Value Function
Step 40: Goal Seek
Step 41: Find the Average
Step 42: Share Worksheet Information
Step 43: Absolute and Relative References
Step 44: Create a Pie Chart
Step 45: Name Ranges
Step 46: Use Name Range in VLOOKUP Function
Step 47: If Function
Step 48: Edit Formulas
Step 49: Data Validation
Step 50: Conditional Formatting
Step 51: Add a Comment
Lesson IV Password Protect Excel
Step 52: Password Protect a Worksheet
Step 53: Password Protect a Workbook
Lesson VI Convert Table to Worksheet, Convert Text to Columns, Sorting,
Subtotals
Step 54: Add Filters to a Worksheet
Step 55: Convert Worksheet to a Table (formally called List)
Step 56: Convert Table back to a Worksheet
Step 57: Convert Text to Columns
Step 58: Sorting the Worksheet
Step 59: Creating Subtotals
Lesson V Pivot Table, Pivot Report, Pivot Chart, Templates, Exit Program
Step 60: Create Source Worksheet
Step 61: Create Pivot Table
Step 62 Create Pivot Table Report
Step 63 Add and Delete Data in a Pivot Table Report
Step 64: Format PivotTable Report
Step 65: Pivot Chart
Step 66: Templates
Step 67: Exit Program