Chat with us, powered by LiveChat
Free Lessons Assess Learn Verify Improvement

Excel 2019 Basic

Complete Course to Display Score

Excel Fundamentals demo

Understand the Excel Screen

Understand the Excel Screen

Click To Try Not Started Not Started Not Started
Create Workbooks

How to create blank & template-based workbooks in Excel

Not Started Not Started Not Started
Navigate Worksheets

How to Navigate Worksheets in Excel

Not Started Not Started Not Started
Open Workbooks

How to Open Workbooks in Excel

Not Started Not Started Not Started
Save Workbooks

How to Save Workbooks in Excel

Not Started Not Started Not Started
AutoRecover

How to AutoRecover Excel Files

Not Started Not Started Not Started
The Quick Access Toolbar

How to Use The Quick Access Toolbar in Excel

Not Started Not Started Not Started
Print

How to Print in Excel

Not Started Not Started Not Started
Help

How to Get Help in Excel

Not Started Not Started Not Started
Close and Exit

How to Close and Exit from Excel

Not Started Not Started Not Started

Edit a Workbook lock Subscribe to unlock

Select Cells and Ranges

How to Select Cells and Ranges in Excel

Edit Cell Data

How to Edit Cell Data in Excel

Cut, Copy, and Paste

How to Cut, Copy, and Paste in Excel

Undo, Redo, Repeat

How to Use Undo, Redo, Repeat Commands in Excel

More Pasting Options

How to Use Special Paste Options in Excel

Insert and Move Cells

How to Insert and Move Cells in Excel

Delete Cells

How to Delete Cells in Excel

Check Spelling

Learn how you use Excel's spell check to proof your worksheets for spelling errors.

Find and Replace Text

How to Use Find and Replace in Excel

Hide Columns and Rows

How to Hide Columns and Rows in Excel

Document Properties

How to View and Edit Document Properties in Excel

Basic Formulas lock Subscribe to unlock

Formula Basics

How to Create Basic Formulas in Excel

AutoFill

How to Use AutoFill in Excel

Sums and Averages

How to Use Sum and Average Formulas in Excel

MIN and MAX

How to Use MIN and MAX Functions in Microsoft Excel

COUNT

How to Use the COUNT Function in Excel

Basic Formatting lock Subscribe to unlock

Format Text

How to Apply Formatting to Text in Excel

Align and Merge Cells

How to Align and Merge Cells in Excel

Format Numbers and Dates

How to Format Numbers and Dates in Excel

Borders and Background Colors

How to Add Cell Borders and Background Colors in Excel

Copy Formatting

How to Copy Formatting in Excel

Row Heights and Column Widths

How to Adjust Row Heights and Column Widths in Excel

Insert Objects lock Subscribe to unlock

Images

How to Insert Images in Excel

Shapes

How to Insert and Format Shapes in Excel

Hyperlinks

How to Insert Hyperlinks in Excel

Object Properties and Alt Text

How to Adjust Object Properties and Alt Text in Excel

Manage Worksheets lock Subscribe to unlock

View Worksheets

How to Change Worksheet Views in Excel

Multiple Windows

How to Work with Multiple Windows in Excel

Move and Copy Worksheets

How to Move and Copy Worksheets in Excel

Insert, Rename, and Delete Worksheets

How to Insert, Rename, and Delete Worksheets in Excel

Freeze Rows and Columns

How to Freeze Rows and Columns in Excel

Hide Worksheets and Gridlines

How to Hide Worksheets and Gridlines in Excel

Excel 2019 Intermediate

Complete Course to Display Score

Charts lock Subscribe to unlock

Create Charts

How to Create Charts in Excel

Not Started Not Started Not Started
Move and Resize

How to Move and Resize a Chart in Excel

Not Started Not Started Not Started
Chart Types

How to Change Chart Types in Excel

Not Started Not Started Not Started
Layout and Style

How to Apply Chart Layouts and Styles in Excel

Not Started Not Started Not Started
Titles and Legends

How to Customize Chart Titles and Legends in Excel

Not Started Not Started Not Started
Gridlines, Labels, and Data Tables

How to Display Chart Gridlines, Labels, and Data Tables in Excel

Not Started Not Started Not Started
Chart Elements

How to Format Chart Data in Excel

Not Started Not Started Not Started
Modify Chart Data

How to Modify Chart Data in Excel

Not Started Not Started Not Started
Filter Charts

How to Filter Charts in Excel

Not Started Not Started Not Started
Trendlines

How to Add Trendlines in Excel

Not Started Not Started Not Started
Dual-Axis Charts

How to Create Dual-Axis Charts in Excel

Not Started Not Started Not Started
Chart Templates

How to Create Chart Templates in Excel

Not Started Not Started Not Started
Sparklines

How to Add Sparklines in Excel

Not Started Not Started Not Started

Print and Distribute lock Subscribe to unlock

Page Size and Scale

How to Adjust Page Size and Scale in Excel

Print Area and Page Breaks

How to Set Print Area and Page Breaks in Excel

Print Titles, Gridlines, and Headings

How to Print Titles, Gridlines, and Headings in Excel

Headers and Footers

How to Add Headers and Footers in Excel

Margins and Orientation

How to Adjust Margins and Orientation in Excel

Inspect for Issues

How to Inspect for Issues in Excel

Intermediate Formulas lock Subscribe to unlock

Reference External Worksheets

How to Reference External Worksheets in Excel

Absolute and Relative References

How to use Absolute and Relative References in Excel

Order of Operations

Order of Operations in Excel

Cell and Range Names

How to Add Cell and Range Names in Excel

Insert Functions

How to Insert Functions in Excel

CONCAT Function

How to Use the CONCAT Function in Excel

PMT and NPER Functions

How to Use the PMT Function in Excel

Display Formulas

How to Display Formulas in Excel

Date Formulas

How to Use Date Formulas in Excel

Manage Data lock Subscribe to unlock

Quick Analysis

The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.

Outline and Subtotal

How to Use the Outline and Subtotal Features in Excel

Data Validation

How to Use Data Validation Rules in Excel

Flash Fill

How to Use Flash Fill in Excel

Import and Export Data

How to Import and Export Excel Data

Tables lock Subscribe to unlock

Insert a Table

How to Insert a Table in Excel

Sort Data

How to Sort Data in Excel

Filter Data

How to Filter Data in Excel

Add Rows and Columns

How to Add Rows and Columns to Excel Tables

Table Styles

How to Apply Table Styles in Excel

Remove Duplicates

How to Remove Duplicates in Excel

Slicers

How to Use Slicers in Excel

Structured References

How to Use Structured References in Excel

Intermediate Formatting lock Subscribe to unlock

Apply Conditional Formatting

How to Apply Conditional Formatting in Excel

Apply and Remove Cell Styles

How to Apply and Remove Cell Styles in Excel

Create and Modify Cell Styles

How to Create and Modify Cell Styles in Excel

Find and Replace Formatting

How to Find and Replace Formatting in Excel

Apply a Theme

How to Apply a Theme in Excel

Collaboration lock Subscribe to unlock

Cell Comments

How to Add, Edit, and Delete Cell Comments in Excel

Share Workbooks

How to Share Workbooks in Excel

Co-author Workbooks

How to Co-author Workbooks in Excel

Version History

How to Use Version History in Excel

Protect a Worksheet

How to Protect a Worksheet in Excel

Protect Workbook Structure

How to Protect a Workbook's Structure in Excel

Password Protection

How to Add Password Protection in Excel

Excel 2019 Advanced

Complete Course to Display Score

PivotTables lock Subscribe to unlock

Create PivotTables

How to Create PivotTables in Excel

Not Started Not Started Not Started
Add Multiple PivotTable Fields

How to Add Multiple PivotTable Fields to a PivotTable in Excel

Not Started Not Started Not Started
Change a PivotTable's Calculation

How to Change a PivotTable's Calculation in Excel

Not Started Not Started Not Started
Add Calculated Fields

How to Add and Remove Calculated Fields in Excel PivotTables

Not Started Not Started Not Started
The GETPIVOTDATA Function

How to Use the GETPIVOTDATA Function in Excel

Not Started Not Started Not Started
Filter PivotTables

How to Filter PivotTables in Excel

Not Started Not Started Not Started
Timelines

How to Add a Timeline in Excel

Not Started Not Started Not Started
PivotTable Layout

Adjust a PivotTable's Layout in Excel

Not Started Not Started Not Started
Group Values

How to Group Values in Excel

Not Started Not Started Not Started
Refresh a PivotTable

How to Refresh a PivotTable in Excel

Not Started Not Started Not Started
Format a PivotTable

How to Format a PivotTable in Excel

Not Started Not Started Not Started

PivotCharts lock Subscribe to unlock

Create PivotCharts

How to Create PivotCharts in Excel

PivotChart Options

PivotChart Options in Excel

PivotChart Styles

How to Apply PivotChart Styles in Excel

Drill-Down Data

How to Drill-Down Chart Data in Excel

Troubleshoot Formulas lock Subscribe to unlock

Formula Errors

How to Fix Formula Errors in Excel

The Watch Window

How to The Watch Window in Excel

Evaluate Formulas

How to Evaluate Formulas in Excel

Advanced Formatting lock Subscribe to unlock

Customize Conditional Formatting

How to Customize Conditional Formatting in Excel

Conditional Formatting with Formulas

How to Use Conditional Formatting with Formulas in Excel

Manage Conditional Formatting

How to Manage Conditional Formatting in Excel

International Currency and Formats

How to Use International Currency and Formats in Excel

Body and Heading Options

How to Apply Body and Heading Font Options in Excel

Color Formats

How to Create and Apply Color Schemes in Excel

Custom Themes

How to Create and Apply Custom Themes in Excel

Form Controls

How to Form Controls in Excel

Save Form Templates

How to Save a Form as a Template in Excel

Advanced Formulas lock Subscribe to unlock

IF Function

How to Use the IF Function in Excel

Nested Functions

How to Insert Nested Functions in Excel

AND, OR, and NOT Functions

How to use AND, OR, and NOT Functions in Excel

SUMIF, AVERAGEIF, and COUNTIF Functions

How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel

VLOOKUP

How to Use the VLOOKUP Function in Excel

HLOOKUP

How to Use HLOOKUP in Excel

INDEX and MATCH

How to Use the INDEX and MATCH Functions in Excel

UPPER, LOWER, and PROPER

How to Use UPPER, LOWER, and PROPER Functions in Excel

RIGHT, LEFT, and MID

How to Use RIGHT, LEFT, and MID Functions in Excel

Formula Calculation Options

How to Change Formula Calculation Options in Excel

Analyze Data lock Subscribe to unlock

Goal Seek

How to Use Goal Seek in Excel

Scenario Manager

How Use to Scenario Manager in Excel

Consolidate Data

How to Consolidate Data in Excel

Macros lock Subscribe to unlock

Enable Macros

How to Enable Macros in Excel

Create Macros

How to Create Macros in Excel

Modify Macros

How to Modify Macros in Excel

Copy Macros

How to Copy Macros in Excel