uCertify

Microsoft Excel 2021

(TOC-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

Getting Started with Excel 2021

  • Topic A: Navigate the Excel User Interface
  • Topic B: Use Excel Commands
  • Topic C: Create and Save a Basic Workbook 
  • Topic D: Enter Cell Data 
  • Topic E: Use Excel Help 
2

Performing Calculations

  • Topic A: Create Worksheet Formulas 
  • Topic B: Insert Functions 
  • Topic C: Reuse Formulas and Functions
3

Modifying a Worksheet

  • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows 
  • Topic B: Search for and Replace Data 
  • Topic C: Use Proofing and Research Tools 
4

Formatting a Worksheet

  • Topic A: Apply Text Formats 
  • Topic B: Apply Number Formats
  • Topic C: Align Cell Contents 
  • Topic D: Apply Styles and Themes
  • Topic E: Apply Basic Conditional Formatting
  • Topic F: Create and Use Templates 
5

Printing Workbooks

  • Topic A: Preview and Print a Workbook 
  • Topic B: Set Up the Page Layout 
  • Topic C: Configure Headers and Footers 
6

Managing Workbooks

  • Topic A: Manage Worksheets 
  • Topic B: Manage Workbook and Worksheet Views 
  • Topic C: Manage Workbook Properties
A

Appendix B: Adding Borders and Colors to Worksheets

  • Topic A: Add Borders and Colors to Worksheets 
B

Appendix C: Basic Excel Customization

  • Appendix Introduction 
  • Topic A: Customize General Options and the Excel UI 
9

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
10

Working with Lists

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

Analyzing Data

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

Visualizing Data with Charts

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

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
C

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

D

Appendix B: Financial Functions

E

Appendix C: Working with Graphical Objects

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

Working with Multiple Worksheets and Workbooks

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

Sharing and Protecting Workbooks

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

Automating Workbook Functionality

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

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
21

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
22

Creating Sparklines and Mapping Data

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

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

G

Appendix B: Cube Functions

H

Appendix C: Importing and Exporting Data

  • Topic A: Import and Export Data
I

Appendix D: Internationalizing Workbooks

  • Topic A: Internationalize Workbooks
J

Appendix E: Working with Power Pivot

  • Topic A: Work with Power Pivot
K

Appendix F: Advanced Customization Options

  • Topic A: Customize Advanced Options
L

Appendix G: Working with Forms and Controls

  • Topic A: Work with Forms and Controls
M

Appendix H: Using Array Formulas

  • Topic A: Use Array Formulas

1

Getting Started with Excel 2021

  • Exporting Ribbon Customizations as a File
  • Adding and Replacing Data in a Cell
  • Creating and Saving a Workbook
  • Copying and Pasting the Data
2

Performing Calculations

  • Creating Worksheet Formulas
  • Determining the Minimum Value
  • Determining the Maximum Value
  • Reusing Formulas
  • Calculating the Sum
  • Calculating the Average
3

Modifying a Worksheet

  • Hiding the Columns
  • Deleting a Column
  • Inserting a Cell Range
  • Deleting a Row
  • Hiding the Rows
  • Adjusting the Columns
4

Formatting a Worksheet

  • Adding a Hyperlink
  • Applying Fill Color
  • Adding Borders
  • Trimming the Decimal Places
  • Adding the Date to a Worksheet
  • Creating a Template
5

Printing Workbooks

  • Adding the Page Number to the Worksheet
6

Managing Workbooks

  • Deleting a Worksheet
  • Hiding a Worksheet
  • Adding a New Worksheet
  • Adding Color to the Worksheet Tab
  • Making a Copy of the Worksheet
  • Freezing the Top Row
7

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
8

Working with Lists

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

Analyzing Data

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

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
11

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
12

Working with Multiple Worksheets and Workbooks

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

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
14

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
15

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
16

Forecasting Data

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

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

Related Courses

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