Microsoft 365 Excel: Part 1 (ME55141)

Module 1: Getting Started with Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

Module 2: Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Module 3: Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Module 4: Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Module 5: Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Module 6: Managing Workbooks

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties