uCertify

Excel 2021 Beginner & Intermediate Level

(ASU-MSEXCEL.AD1) / ISBN : 979-8-90059-996-0
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

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

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