Microsoft Excel Basic

Duration & Format

1 Full Day (8 Hours) – Available as on-site corporate training or open workshops

Module 1: Creating a Microsoft Excel Workbook

• Starting Microsoft Excel
• Creating a Workbook
• Saving a Workbook
• The Status Bar
• Adding and Deleting Worksheets
• Copying and Moving Worksheets
• Changing the Order of Worksheets
• Splitting the Worksheet Window
• Closing a Workbook

Module 2: The Ribbon

• Tabs
• Groups
• Commands

Module 3: The Backstage View (The File Menu)

• Introduction to the Backstage View
• Opening a Workbook
• New Workbooks and Excel Templates
• Printing Worksheets

Module 4: The Quick Access Toolbar

• Adding Common Commands
• Adding Ribbon Commands or Groups

Module 5: Entering Data in Microsoft Excel Worksheets

• Entering Text
• Expand Data across Columns
• Adding and Deleting Cells
• Adding an Outline
• Adding a Hyperlink
• Add WordArt to a Worksheet
• Using AutoComplete
• Entering Numbers and Dates
• Using the Fill Handle

Module 6: Formatting Microsoft Excel Worksheets

• Hiding Worksheets
• Adding Color to Worksheet Tabs
• Adding a Watermark
• The Font Group
• The Alignment Group
• The Number Group

Module 7: Using Formulas in Microsoft Excel

• Math Operators and the Order of Operations
• Entering Formulas
• AutoSum (and Other Common Auto-Formulas)
• Copying Formulas and Functions
• Relative, Absolute, and Mixed Cell References

Module 8: Working with Rows and Columns

• Insert lesson titles in a bullet list.
• Inserting Rows and Columns
• Deleting Rows and Columns
• Transposing Rows and Columns
• Setting Row Height and Column Width
• Hiding and Unhiding Rows and Columns
• Freezing Panes

Module 9: Editing Worksheets

• Find
• Find and Replace
• Managing Comments

Module 10: Finalizing Microsoft Excel Worksheets

• Setting Margins
• Setting Page Orientation
• Setting the Print Area
• Print Scaling (Fit Sheet on One Page)
• Printing Headings on Each Page/Repeating Headers and Footers