Table of Contents
Microsoft Excel 365
Lesson I – The Screen Views
Step 1: Create a New Folder
Step 2: Open the Microsoft Excel Program
Step 3: The Screen View and Ribbon in Microsoft
Step 4: The Ribbon
Step 5: Name Box and Formula Bar
Step 6: Status Bar, Zoom, and Page Views
Step 7: Horizontal and Vertical Scroll Bars
Step 8: Selecting Cells, Columns, and Rows
Step 9: Cells
Step 10: Columns
Step 11: Rows
Step 12: Sheet Tabs
Lesson II - Create an Excel Workbook
Step 13: Save an Excel Workbook
Step 14: Format Cells
Step 15: Borders
Step 16: Fill Color
Step 17: Change Alignment of Text
Step 18: Format the Text
Step 19: Add the Date and Time
Step 20: AutoFill
Step 21: Insert Clip Art and Picture from File
Step 22: Add Data to Cells
Step 23: Format Painter
Step 24: Freeze Panes
Step 25: Hide and Unhide Columns
Step 26: AutoSum
Step 27: Arithmetic Operators
Step 28: Share Cell Information
Step 29: AutoFill Formulas and Copy Data to Adjacent Cells
Step 30: Format Numbers
Step 31: AutoCorrect
Step 32: Page Layout View and Page Break Preview
Step 33: Print Preview, Set Print Area, and Print
Step 34: Exit, Open, and Close Excel
Step 35: Backup Excel
Lesson III - Formulas and Functions, and Protect Worksheet
Step 36: Formula Auditing
Step 37: Insert Function Dialog Box
Step 38: FV Future Value Function
Step 39: Goal Seek
Step 40: Find the Average
Step 41: Share Worksheet Information
Step 42: Absolute and Relative References
Step 43: Create a Pie Chart
Step 44: Data Validation
Step 45: Conditional Formatting
Step 46: Add a Comment
Step 47: Password Protect a Worksheet and Workbook
Lesson VI Working with Worksheets and Sorting Records
Step 48: Add Filters to a Worksheet
Step 49: Convert Text to Columns
Step 50: Convert Worksheet to a Table
Step 51: Creating Subtotals
Step 52: Sort and Filter in a Pivot Table
Step 53: Update Pivot Table Report
Step 54: Pivot Chart
Lesson V Templates and Help
Step 55: Templates and Help
Step 56: Help
Step 57: Exit Program