Microsoft Excel Certification Training
Course Activities
- Quizzes: 21
- Assignments: 44
- Exams: 4
Part 1 - Introduction to Microsoft Excel Training
Lesson 1: Microsoft Office Basics (Quizzes: 0, Assignments: 0)
- Logging in to Microsoft 365
- Installing Applications
- Creating New Files and AutoSaving
- Protected View
- File Sharing
- File Collaboration
- Version History
- Getting Updates
- Mac Versions
Lesson 2: Creating a Microsoft Excel Workbook (Quizzes: 1, Assignments: 1)
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- View Options for the Worksheet
- Closing a Workbook
Lesson 3: The Ribbon (Quizzes: 1, Assignments: 0)
- Tabs
- Groups and Commands
- Microsoft Search Box
- Customizing the Ribbon
Lesson 4: The Backstage View (The File Menu) (Quizzes: 1, Assignments: 3)
- Introduction to the Backstage View
- Opening a Workbook
- New Workbooks and Excel Templates
- Printing Worksheets
- Personalizing Microsoft Office
Lesson 5: The Quick Access Toolbar (Quizzes: 1, Assignments: 1)
- Getting Started
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog
- Adding Ribbon Commands or Groups
Lesson 6: Entering Data in Microsoft Excel Worksheets (Quizzes: 1, Assignments: 2)
- Entering Text
- Inserting and Deleting Cells
- Inserting Hyperlinks
- Inserting WordArt
- Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
Lesson 7: Formatting Microsoft Excel Worksheets (Quizzes: 1, Assignments: 4)
- Selecting Ranges of Cells
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Adding a Watermark
- The Font Group
- The Alignment Group
- The Number Group
Lesson 8: Editing Worksheets (Quizzes: 1, Assignments: 2)
- Find
- Find and Replace
- Using the Clipboard
- Moving Columns / Rows
Lesson 9: Working with Rows and Columns (Quizzes: 1, Assignments: 1)
- Inserting and Deleting Rows, Columns, and Cells
- Transposing Rows and Columns
- Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
Lesson 10: Using Formulas in Microsoft Excel (Quizzes: 1, Assignments: 1)
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas
- Relative, Absolute, and Mixed Cell References
Lesson 11: Finalizing Microsoft Excel Worksheets (Quizzes: 1, Assignments: 1)
- Setting Margins
- Setting Page Orientation
- Setting the Print Area
- Print Scaling (Fit Sheet on One Page)
- Repeating Headings
- Headers and Footers
Introduction to Microsoft Excel Exam
Part 2 - Intermediate Microsoft Excel Training
Lesson 1: Common Functions (Quizzes: 1, Assignments: 7)
- Using Named Ranges in Formulas
- Using Formulas That Span Multiple Worksheets
- Functions: IF and IFS
- Functions: AND and OR
- Functions: NOT
- Functions: SWITCH
- Functions: COUNTIF, AVERAGEIF, and SUMIF
- Functions: PMT and NPER
- Functions: TEXTJOIN and CONCAT
- Text Functions
- Date and Time Functions
Lesson 2: Working with Lists (Quizzes: 1, Assignments: 4)
- What is a List of Data?
- Removing Duplicates from a List
- Sorting Data in a List
- Filtering Data in a List
- Adding Subtotals to a List
Lesson 3: Visualizing Your Data (Quizzes: 1, Assignments: 2)
- Chart Basics
- Tools for Editing Charts
- The Format Tool Tab
- Using the Three Chart Buttons
- The Format Task Pane
- Useful Charts
- Line and Area Charts
- Hierarchy Charts
- Statistic Charts
- Other Charts
- Combo Charts
- Using Recommended Charts
- Sparklines
- Add and Format Objects
- Working with Shapes
- Working with Icons
- Working with SmartArt
- Using the Quick Analysis Tool
Lesson 4: Working with Tables (Quizzes: 1, Assignments: 1)
- Format Data as a Table
- Table Design Tool Tab
- Formatting Individual Cells
- Selecting Table Rows and Columns
- Structured References
- Convert a Table to a Range
Lesson 5: Advanced Formatting (Quizzes: 1, Assignments: 2)
- Cell Styles
- Conditional Formatting
- Conditional Formatting: Highlight Cells Rules
- Conditional Formatting: Top/Bottom Rules
- Conditional Formatting: Data Bars, Color Scales, and Icon Sets
- Conditional Formatting: Create a New Rule
- Removing Conditional Formatting
Intermediate Microsoft Excel Exam
Part 3 - Advanced Microsoft Excel Training
Lesson 1: Using PivotTables (Quizzes: 1, Assignments: 1)
- How PivotTables Work
- Timeline Filters
- Inserting Slicers
- Grouping Data
- Calculated Fields
- PivotCharts
Lesson 2: Advanced Functions (Quizzes: 1, Assignments: 2)
- Function Syntax
- ROWS, COLUMNS, INDEX, and XMATCH
- Arrays and Array Formulas
- SORT, FILTER, and SORTBY
- Lookup Functions
- The LET Function
- The TRANSPOSE Function
Lesson 3: Auditing Workbooks (Quizzes: 1, Assignments: 1)
- Inspecting a Workbook
- Tracing Precedents and Dependents
- Watch Window
- Evaluating Formulas
- Error Checking
Lesson 4: Data Tools (Quizzes: 1, Assignments: 5)
- Importing Data from Online Source
- Converting Text to Columns
- Importing Files
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Consolidating Data
- What-If Analysis
Lesson 5: Recording and Using Macros (Quizzes: 1, Assignments: 2)
- Recording Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
Lesson 6: Working with Others (Quizzes: 1, Assignments: 1)
- Comments and Notes
- Protecting Worksheets and Workbooks
- Marking a Workbook as Final
- Other Sharing Concerns
Advanced Microsoft Excel Exam, Final Microsoft Excel Exam