Course Introduction

1m 6s

Essential Information

2m 6s

Keyboard Shortcut Guides

Excel 2021 vs Excel for Microsoft 365

2m 55s

SANDBOX: Microsoft Excel

Launching Excel

2m 30s

Exercise - Launching Excel

The Start Screen

6m 32s

Exercise - Start Screen

Exploring the Interface

1m 25s

The Formula Bar

2m 44s

Exercise - Interface Exploration

Understanding Ribbons, Tabs and Menus

3m 51s

Exercise - Ribbons, Tabs, and Menus

Exercise - Backstage Area

Customizing the Quick Access Toolbar

4m 24s

Exercise - Quick Access Toolbar

Useful Keyboard Shortcuts

3m 21s

Exercise - Keyboard Shortcuts

Getting Help

0m 53s

Exercise - Getting Help

Quiz - Confirming Knowledge on Excel Basics

Working with Excel Templates

6m 3s

Exercise - Working with Excel Templates

Exercise - Workbooks and Worksheets

Exercise - Saving Workbooks and Worksheets

Entering and Editing Data

4m 36s

Exercise - Entering and Editing Data

Exercise - Entering and Editing Data

Quiz - Creating Your First Excel Spreadsheet

Formulas and Functions Explained

2m 41s

Exercise - Formulas and Functions

Performing Calculations with the SUM Function

5m 2s

Exercise - SUM Function

Finding the Average with the AVERAGE Function

3m 41s

Exercise - AVERAGE Function

Handling Errors in Formulas

4m 29s

Exercise - Handling Errors in Formulas

Autosum and AutoFill

3m 41s

Exercise - Autosum and AutoFill

Flash Fill

1m 33s

Exercise - Flash Fill

Quiz - Assessing Formula and Function Mastery

What are Named Ranges?

2m 47s

Exercise - Named Ranges

Creating and Managing Names Ranges

5m 43s

Exercise - Creating Named Ranges

Exercise - Managing Named Ranges

Exercise - Named Ranges Calculations

Quiz - Testing Knowledge on Named Ranges

Applying Number and Date/Time Format

6m 33s

Exercise - Number Formats

Exercise - Date and Time Formats

Formatting Cells, Rows, and Columns and Use of Format Painter

5m 38s

Exercise - Formatting Cells

Exercise - Format Painter

Quiz - Assess Understanding of Number and Cell Formatting

Working with Rows and Columns

3m 25s

Exercise - Rows and Columns

Exercise - Deleting and Clearing

Aligning Text and Numbers

5m 0s

Exercise - Text and Numbers Alignment

Applying Themes and Styles

2m 54s

Exercise - Themes and Styles

Quiz - Testing Understanding of Worksheet Formatting

Structure a List

5m 43s

Exercise - Structure a List

Exercise - Single-Level Sort

Exercise - Multi-Level Sort

Quiz - List Management Comprehension

Using Cut and Copy

5m 30s

Exercise - Cut and Copy

Paste Options

5m 34s

Exercise - Paste Options

Exercise - Clipboard

Quiz - Data Movement and Linking Knowledge Check

LOOKUP Information with VLOOKUP

4m 7s

Exercise - VLOOKUP

VLOOKUP Approximate Match

4m 54s

Exercise - Approximate Match

Error Handling Functions

3m 10s

Exercise - Error Handling

Quiz - Intermediate Formula Comprehension

Creating and Presenting Data with Charts

6m 17s

Exercise - Chart Type Selection

Exercise - Data Presentation

Exercise - Chart Formatting

Quiz - Chart Analysis and Creation

Explore All Conditional Formatting Tools

5m 49s

Exercise - Highlighting Cells

Exercise - Data Bars

Exercise - Color Scales

Exercise - Icon Sets

Quiz - Mastery of Conditional Formatting

Inserting Pictures

4m 24s

Exercise - Pictures

Inserting Shapes, Text Boxes, Icons and 3D Models

5m 30s

Exercise - Shapes and Text Boxes

Exercise - Icons and 3D Models

Quiz - Understanding of Inserting Visual Elements

Workbook Views

2m 31s

Exercise - Workbook Views

Using Zoom in a Worksheet

1m 13s

Exercise - Zoom

Arranging Workbooks and Worksheets

3m 25s

Exercise - Workbook Arrangement

Quiz - Assessment of View and Zoom Capabilities

Explore All Layouts and Print Options

4m 8s

Exercise - Margins and Orientation

Exercise - Print Area

Exercise - Page Breaks

Exercise - Print Titles and Background

Quiz - Print Setup Knowledge Check

Checking the Workbook Before Saving

6m 12s

Exercise - Protection

Exercise - Spell Checking

Exercise - Workbook Inspection

Exercise - Saving Formats

Quiz - Finalization Process Mastery

Excel Quest: The Data Adventure

0m 0s

Case Study - Company Efficiency Analysis

Introduction

0m 37s

Overview of Content

0m 37s

Efficiency Boosters

The Golden Rules of Spreadsheet Design

2m 30s

Exercise - Design Principles

Improving Readability with Cell Styles

3m 52s

Exercise - Cell Styles

Creating Data Input

3m 16s

Exercise - Data Input

Adding Navigation Buttons

12m 27s

Exercise - Navigation Buttons

Logic Functions (AND, OR, IF)

7m 45s

Exercise - Logical Functions

Exercise - IF Function

The IF Function

6m 38s

Exercise - Nested IFs

Exercise - IFS Function

LOOKUP Information using VLOOKUP

2m 32s

Exercise - VLOOKUP (Exact Match)

Exercise - VLOOKUP (Approx Match)

Using INDEX and MATCH

7m 41s

Exercise - HLOOKUP

Exercise - INDEX and MATCH

Microsoft Excel Intermediate: Advanced Sorting and Filtering

7m 34s

Exercise - Multi-Column Sort

Exercise - Custom List Sort

Exercise - Advanced Filters

Exercise - Unique Values

Understanding How Dates are Stored in Excel

4m 30s

Exercise - Date Systems

Applying Custom Date Formats

4m 32s

Exercise - Custom Date Formats

Exercise - Date and Time Functions

Importing Data from External Sources

3m 53s

Exercise - External Data Import

Exercise - Text Data Cleaning

Cleaning Text Data, Structuring Data for Analysis

3m 37s

Exercise - Data Structuring

Creating a PivotTable

6m 12s

Exercise - PivotTable Creation

Analyzing Data with PivotTables, Slicing Data with Slicers

3m 22s

Exercise - Data Analysis

Exercise - Slicers

Creating a Pivot Chart, Formatting Pivot Charts

4m 4s

Exercise - Pivot Chart

Exercise - Pivot Chart Formatting

Integrating Slicers and Timelines, Connecting Multiple PivotTables

5m 27s

Exercise - Slicers and Timelines

Exercise - Multi-PivotTable

What is a Dashboard?, Assembling a Dashboard - Part 1 and Assembling a Dashboard - Part 2

3m 51s

Exercise - Dashboard Fundamentals

Exercise - Assembling Dashboard - Part 1

Exercise - Assembling Dashboard - Part 2

Troubleshooting Common Errors, Tracing Precedents and Formula Auditing

4m 30s

Exercise - Common Errors

Exercise - Formula Auditing

Creating Dynamic Drop-down Lists, The Other Types of Data Validation

4m 17s

Exercise - Drop-down Lists

Exercise - Advanced Data Validation

Goal Seek and the PMT Function

5m 44s

Exercise - Goal Seek

Data Tables: One-Variable and Data Tables: Two Variables

5m 22s

Exercise - One-Variable Data Tables

Exercise - Two-Variable Data Tables

Advanced Page Setup

4m 21s

Exercise - Advanced Page Setup

Customizing Headers and Footers

4m 15s

Preparing for Distribution and Protecting Your Data

4m 24s

Exercise - Distribution Preparation

Exercise - Data Protection

Excel Adventure Game

0m 0s

Metro City Budget Analysis