Certificate in Microsoft Excel 365

Module 1 - Microsoft Excel – Core (3 Hrs)
1. Entering Data in Microsoft Excel Worksheets

• Entering Text
• Using AutoComplete
• Entering Numbers and Dates
• Using the Fill Handle
• Quick Analysis

2. 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 and Absolute Cell References

3. Working with Rows and Columns

• Inserting Rows and Columns
• Deleting Rows and Columns
• Setting Row Height and Column Width
• Hiding and Un-hiding Rows and Columns
• Freezing Panes

4. Data / Time Functions
5. Text Functions
6. Finalizing Microsoft Excel Worksheets

• Setting Margins
• Setting Page Orientation
• Setting the Print Area
• Print Scaling (Fit Sheet on One Page)
• Headers and Footers

Module 2 - Microsoft Excel - Advanced (3 Hrs)
1. Applying Conditional Formatting

• Highlight Cell Rule
• Top / Bottom Rule
• Data Bar
• Color Scale
• Icon Sets

2. Using Pivot Tables

• Creating Pivot Tables
• Preparing Your Data
• Inserting a Pivot Table
• Inserting Pivot Charts
• More Pivot Table Functionality
• Automatic Time Grouping
• Inserting Slicers
• Multi-select Slicer

3. Data Tools

• Data Validation
• Flash Fill

4. Protecting Worksheets and Workbooks

• Password Protecting a Workbook
• Password Protecting a Worksheet
• Password Protecting Ranges in a Worksheet
• Tracking Changes
• Accepting or Rejecting Changes

5. Summarize Functions
6. Lookup Functions
7. IF Functions