Curriculum
Course:
Excel For Data Analyst
Login
Curriculum
Excel For Data Analyst
Section 1.1 Course Overview
0/12
1.1.0 Excel and the Microsoft Office Suite
2 min
1.1.1 The Microsoft Office Suite
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Video lesson
1.1.2 Introduction to Microsoft Excel
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
1.1.3 Excel Tasks Overview
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
1.2.0 Course Features
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 min
1.2.1 Introduction to the Course
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
1.2.2 Course Overview
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
1.2.3 Course Objectives
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
1.2.4 Tips for Mac Users
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
1.2.5 Using the Simulated Labs
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
1.2.6 Keyboard Shortcuts in Labs
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
1.2.7 Tips for Chromebook Users
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
Section 2.1 Common office features
0/32
2.1.0 Getting Started with Office
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
2.1.1 Introduction to Office Applications
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2:20 mins
2.1.2 Microsoft Office Versions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
2.1.3 Learning Office Applications
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
2.1.4 The Ribbon
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
2.1.5 Beyond the Ribbon
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
2.1.6 Backstage View Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
2.1.7 Common Office Application Features
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
2.1.8 Desktop vs. Web Applications
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
2.1.9 Skills Lab: Get Started with Office
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
2.1.10 Challenge Lab: Get Started with Office
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
2.2.0 Customizing Views and Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
2.2.1 Document Views
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
2.2.2 Customization Toolbars and Ribbons
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Video lesson
2.2.3 Customization Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
2.2.4 Skills Lab: Customize Views and Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
2.3.0 Printing Files
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 minutes
Section 2.3.1 Printing Options in Office Applications
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
2.4.0 Navigating Files
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
2.4.1 Navigating Through a Word Document
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
2.4.2 Navigating Through an Excel Workbook
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
2.4.3 Navigation Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
2.5.0 Working with Objects
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 minutes
2.5.1 Formatting Images
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
2.5.2 Formatting Shapes
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
2.5.3 Object Formatting Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 mins
Section 2.6.0 Using office collaboration Features
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
2.6.1 Track Changes and Comments
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
2.6.2 Combining Revisions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
2.6.3 Distributing Files
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
2.6.4 Collaboration Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 minutes
2.6.7 Collaboration Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
Section 3.1 Creating and Managing Workbooks
0/26
Section 3.1.0 Creating and Managing Workbooks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 minutes
3.1.1 Spreadsheet Basics
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
3.1.2 Worhsheet Management
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 min
3.1.3 Templates and Themes
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
3.1.4 External Data
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
3.1.5 Workbook Management Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 minutes
3.1.8 Workbook Management Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
3.2.0 Organizing and Entering Data
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
3.2.1 Deleting and Clearing Cells
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
3.2.2 Copy and Paste Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
3.2.3 Large Data Sets
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
3.2.4 Data Entry Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 minutes
3.2.7 Data Entry Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
3.3.0 Changing Properties and Printing Worksheets
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
3.3.1 Data Protection
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
3.3.2 Data Validation
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
3.3.3 Excel Printing Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Video lesson
3.3.4 Worksheet Printing Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
3.3.7 Worksheet Printing Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
3.4.0 Formatting Cells
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
3.4.1 Number Formats
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
3.4.2 Cell Formats
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
3.4.3 Cell Styles and Colors
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
3.4.4 Cell Borders
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Video lesson
3.4.5 Cell Formatting Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
15 minutes
3.4.8 Cell Formatting Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
Section 4.1 Entering Simple Formulas
0/21
Section 4.1 Entering Simple Formulas
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
4.1.1 Formulas and Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
4.1.2 AutoFill Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
4.1.3 Add and Average
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
4.1.4 More Number Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
4.1.5 Text Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
4.1.6 Concatenating in Excel
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
4.1.7.0 Formula Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 minutes
4.1.7.1 Formula Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 minutes
4.1.7.2 Formula Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 minutes
4.1.10 Formula Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
4.2 Using Advanced Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
4.2.1 Relative and Absolute References
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
4.2.2 Advanced Cell References
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
4.2.3 Named Cells and Ranges
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
4.2.4 The IF Function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
4.2.5 Logical Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
4.2.6 Excel Error Messages
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
4.2.7 Spill Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
4.2.8 Advanced Function Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
4.2.11 Advanced Function Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
Section 5.1 Displaying Data in Charts
0/12
Section 5.1 Displaying Data in Charts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
5.1.1 Chart Formatting
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
5.1.2 Chart Types
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
5.1.3 Chart Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 minutes
5.1.6 Chart Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
5.2 Organizing Data in Tables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
5.2.1 Conditional Formatting
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2:35 mins
5.2.2 Excel Tables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
5.2.3 Table Customization
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
5.2.4 Using Formulas in Tables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
5.2.5 Excel Table Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 minutes
5.2.8 Excel Table Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
Section 6.1 Excel Live Projects
0/5
Section 6.1 Excel Live Projects
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
6.1.1 How to Use Excel Live Projects
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
6.1.2.0 Installing the Optional Task Guide in Excel
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 minutes
6.1.2.1 Installing the Optional Task Guide in Excel
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 minutes
6.1.3 Additional Tips for Excel Live Projects
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
Section 7.1 Preparing for MOS Associate Certification
0/16
Section 7.1 Preparing for MOS Associate Certification
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 mins
7.1.1 Preparing for the MOS Exams
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
7.1.2 Performing Unfamiliar Tasks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 mins
7.1.3 Which MOS Exam to Take?
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
7.1.4 Using TestOut MOS Practice Exams
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
7.1.5 Excel (Microsoft 365 Apps) Exam Objectives
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
7.1.6 Excel Associate 2019 Exam Objectives
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
7.1.7 Taking an MOS Exam
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
1 min
Section 7.2 Domain Domain Practice Labs: Excel Associate 365 (MO-210)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
20 mins
Section 7.3 Practice Exams: Excel Associate 365 (MO-210)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
7.3.1 Microsoft Excel Associate Practice - Form A
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
50 mins
7.3.2 Microsoft Excel Associate Practice - Form B
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
50 mins
Section 7.4 Domain Practice Labs: Excel Associate 2019 (MO-200)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
50 mins
Section 7.5 Practice Exams: Excel Associate 2019 (MO-200)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
7.5.1 Microsoft Excel Associate Practice - Form A
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
50 mins
7.5.2 Microsoft Excel Associate Practice - Form B
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
50 mins
Section 8.1 Managing Workbooks
0/11
Section 8.1 Managing Workbooks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
8.1.1 Configuring AutoSave and AutoRecover
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
8.1.2 Referencing Data in Other Workbooks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
8.1.3 Configuring and Using Language-Specific Features
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
8.1.4 Manage Workbooks Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
15 mins
8.1.7 Manage Workbooks Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
8.2 Preparing Workbooks for Collaboration
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 minutes
8.2.1 Protecting Cell Ranges, Worksheets, and Workbooks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
8.2.2 Configuring Formula Calculation Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
8.2.3 Prepare Workbooks for Collaboration Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
20 mins
8.2.6 Prepare Workbooks for Collaboration Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
Section 9.1 Filling Cells Based on Existing Data
0/18
Section 9.1 Filling Cells Based on Existing Data
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
9.1.1 Flash Fill and Advanced Fill Series Options
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
9.1.2 Fill Cells Based on Existing Data Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
9.1.5 Fill Cells Based on Existing Data Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
Section 9.2 Formatting and Validating Data
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
9.2.1 Custom Number Formats
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
9.2.2 Configuring Data Validation
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
9.2.3 Using Outlines to Create Groups and Subtotals
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
9.2.4 Removing Duplicate Records
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
9.2.5 Format and Validate Data Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
20 mins
9.2.8 Format and Validate Data Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
Section 9.3 Advanced Conditional Formatting and Filtering
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
9.3.1 Boolean Operators
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
9.3.2 Using Boolean Logic in Excel
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
9 mins
9.3.3 Custom Conditional Formatting Rules
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
9.3.4 Conditional Formatting Rules That Use Formulas
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
9.3.5 Apply Advanced Conditional Formatting and Filtering Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
20 mins
9.3.8 Apply Advanced Conditional Formatting and Filtering Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
Section 10.1 Advanced Formulas and Macros
0/37
Section 10.1 Performing Logical Operations in Formulas
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
10.1.1 Logical Functions and Nested Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
10.1.2 Logical Operations with Mathematical Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 mins
10.1.3 The LET Function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
10.1.4 Perform Logical Operations in Formulas Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
10.1.7 Perform Logical Operations in Formulas Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
Section 10.2 Looking Up Data by Using Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
10.2.1 The VLOOKUP and HLOOKUP Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.2.2 The MATCH and INDEX Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.2.3 The XLOOKUP Function
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
10.2.4 Look Up Data by Using Functions Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
10.2.7 Look Up Data by Using Functions Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
Section 10.3 Using Advanced Date and Time Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 minutes
10.3.1 Date and Time Functions
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
10.3.2 Use Advanced Date and Time Functions Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.3.5 Use Advanced Date and Time Functions Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
Section 10.4 Performing Data Analysis
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
10.4.1 Summarizing Data from Multiple Ranges
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
10.4.2 Performing What-If Analysis
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
10.4.3 Filtering and Sorting with Dynamic Arrays
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.4.4 Common Financial Terminology
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.4.5 Calculating Finacial Data
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
10.4.6 Perform Data Analysis Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
10.4.9 Peform data Analysis Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
Section 10.5 Troubleshooting Formulas
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
10.5.1 Tracing Precedents and Dependents
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
10.5.2 The Watch Window
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2:25 mins
10.5.3 Errors and Error Checking
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
10.5.4 Evaluating Formulas
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
10.5.5 Troubleshoot Formulas Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
10.5.6 Troubleshoot Formulas Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
10.6 Creating and Modifying Simple Macros
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
10.6.1 Recording and Running Simple Macros
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.6.2 Enabling and Disabling Macros
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
10.6.3 Copying Macros Between Workbooks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
10.6.4 Create and Modify Simple Macros Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
10.6.7 Create and Modify Simple Macros Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
Section 11.1 Advanced and Charts and Tables
0/17
Section 11.1 Creating and Modifying Advanced Charts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
11.1.1 Selecting Advanced Chart Types
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
11.1.2 Advanced Chart Formatting
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
7 mins
11.1.3 Dual Axis Charts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
11.1.4 Create and Modify Advanced Charts Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
11.1.7 Create and Modify Advanced Charts Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
Section 11.2 Creating and Modifying PivotTables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
11.2.1 Introduction to PivotTables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
11.2.2 Advanced PivotTable Features
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
11.2.3 Calculated Fields in PivotTables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
11.2.4 Create and Modify PivotTables Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
11.2.7 Create and Modify PivotTables Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
Section 11.3 Creating and Modifying PivotCharts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
2 mins
11.3.1 Creating and Manipulating PivotCharts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
11.3.2 Drilling Down into PivotChart Details
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
11.3.3 Create and Modify PivotCharts Facts
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
4 mins
11.3.6 Create and Modify PivotCharts Tips
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
Section 12.1 Preparing for MOS Expert Certification
0/13
Section 12.1 Preparing for MOS Expert Certification
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
12.1.1 Preparing for the MOS Exams
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
12.1.2 Performing Unfamiliar Tasks
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
8 mins
12.1.3 Which MOS Exam to Take?
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
12.1.4 Using TestOut MOS Practice Exams
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
12.1.5 Excel Expert (Microsoft 365 Apps) Exam Objectives
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
12.1.6 Excel Expert Associate 2019 Exam Objectives
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
12.1.7 Taking an MOS Exam
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
12.2 Domain Practice Labs: Excel Expert 365 (MO-211)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
12.3 Practice Exams: Excel Expert 365 (MO-211)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
12.4 Domain Practice Labs: Excel Expert 2019 (MO-201)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
20 mins
Section 12.5 Practice Exams: Excel Expert 2019 (MO-201)
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
12.5.3 Supermarket sales
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
0/13
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
5 mins
A.1.1 Pro Exam Objectives
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
6 mins
A.1.2 Pro Exam Objectives by Course Section
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
10 mins
A.1.3 How to take the Pro Exam
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
A.1.4 Pro Exam FAQs
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
1 min
Section A.2 TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
A.2.1 Pro Domain 1: Workbooks and Worksheets
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Assignment
A.2.2 Pro Domain 2: Formatting and Data
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Assignment
A.2.3 Pro Domain 3: Functions, Formulas, and Macros
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Assignment
A.2.4 Pro Domain 4: Charts and Tables
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Assignment
Section A.3 TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
3 mins
A.3.1 Certification Practice Exam - Form A
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Assignment
A.3.2 Certification Practice Exam - Form B
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Assignment
Glossary
0/1
Glossary
This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text lesson
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
Delete file
Are you sure you want to delete this file?
Cancel
Delete
I agree with storage and handling of my data by this website.
Privacy Policy
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Confirmation link sent
Please follow the instructions sent to your email address
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?
Acquire Centre