uCertify

Microsoft Excel 2021

(WB-MSEXCEL.AD1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date and Time Functions
  • Topic E: Work with Text Functions
2

Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
3

Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
4

Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
5

Using PivotTables and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers
A

Appendix B: Financial Functions

B

Appendix C: Working with Graphical Objects

  • Topic A: Insert Graphical Objects
  • Topic B: Modify Graphical Objects
  • Topic C: Work with SmartArt
8

Working with Multiple Worksheets and Workbooks

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
9

Sharing and Protecting Workbooks

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
10

Automating Workbook Functionality

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
11

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • Topic A: Use Lookup Functions
  • Topic B: Use Dynamic Arrays and Dynamic Array Functions
  • Topic C: Trace Cells
  • Topic D: Watch and Evaluate Formulas
12

Forecasting Data

  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecast Data Trends
13

Creating Sparklines and Mapping Data

  • Topic A: Create Sparklines
  • Topic B: Map Data
C

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

D

Appendix B: Cube Functions

E

Appendix C: Importing and Exporting Data

  • Topic A: Import and Export Data
F

Appendix D: Internationalizing Workbooks

  • Topic A: Internationalize Workbooks
G

Appendix E: Working with Power Pivot

  • Topic A: Work with Power Pivot
H

Appendix F: Advanced Customization Options

  • Topic A: Customize Advanced Options
I

Appendix G: Working with Forms and Controls

  • Topic A: Work with Forms and Controls
J

Appendix H: Using Array Formulas

  • Topic A: Use Array Formulas

1

Working with Functions

  • Creating Named Ranges
  • Editing Range Names
  • Using an Existing Range in a Function
  • Using the Formula AutoComplete Method to Enter Range Names
  • Using the TODAY Function
  • Calculating the Years of Service for Each Employee
  • Adding the Arguments for the IF Portion of the Nested Function
  • Calculating the 1 Percent Goal Bonus for Employees
  • Using the NETWORKDAYS Function
  • Extracting the Building Code from the Combined Field
  • Extracting the Floor Code from the Combined Field
  • Concatenating the Names in a Single Field
2

Working with Lists

  • Filtering the Data for all Employees
  • Creating a Custom Filter
  • Using Database Functions
3

Analyzing Data

  • Converting the Data into a Table
  • Applying a Quick Style to a Table
  • Adding New Entries to a Table
4

Visualizing Data with Charts

  • Creating a Clustered Column Chart
  • Changing the Labels of the Line Chart
  • Changing the Chart Type
  • Creating the Combo Chart
  • Adding the Trendline
  • Saving a Chart as a Template
5

Using PivotTables and PivotCharts

  • Adding Fields to the PivotTable
  • Building the PivotTable Report
  • Sorting the Values
  • Modifying the Formatting of the PivotTable Report
  • Modifying the PivotTable Report
  • Inserting a Timeline
6

Working with Multiple Worksheets and Workbooks

  • Creating Links
  • Creating External Links
  • Creating a 3-D Formula
  • Consolidating Data
7

Sharing and Protecting Workbooks

  • Fixing the Missing Alternative Text Error by Using the Accessibility Checker
  • Exporting the Workbook in the PDF File Format
  • Hiding the Worksheet
  • Enabling Worksheet Protection
  • Hiding the Formulas
8

Automating Workbook Functionality

  • Enabling and Configuring the Settings for Data Validation
  • Checking the Worksheet For Errors In Formulas
  • Finding and Fixing Invalid Data Entries
  • Saving the Workbook as a Macro-Enabled Workbook
9

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • Using the HLOOKUP Function
  • Using the INDEX Function
  • Using the MATCH Function
  • Using the FILTER Function
  • Using the SEQUENCE Function
  • Using the SORT Function
  • Using the LET Function
  • Using the XLOOKUP Function
  • Using the TRANSPOSE Function
  • Using the VLOOKUP Function
  • Using the UNIQUE Function
  • Using the XMATCH Function
10

Forecasting Data

  • Creating a Two-Variable Data Table
  • Creating a Forecast Sheet
11

Creating Sparklines and Mapping Data

  • Creating Sparklines

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Microsoft Excel 2021

$139.99

Buy Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More