Mastering Excel 2019 – Intermediate

ToIT

0 (0)

Duration

5h 2m

Students

Level

Intermediate

Last Updated

December 16, 2024

Overview
Curriculum
Reviews

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were

If you learn to use Excel 2019 or Excel 365, you will start to see how useful it is in your life—from formatting your grocery list to calculating complex ROI values. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer, Kathy Jones, walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.

6 Sections
53 Lessons
5h 2m Duration

Expand All

Working with Functions

20 Lessons

Introduction
Using Named Ranges, Part 1
Using Named Ranges, Part 2
Using Named Ranges, Part 3
Working with Date Functions, Part 1
Working with Date Functions, Part 2
Working with Date Functions, Part 3
Working with Time Functions
Working with Logical Functions
Working with Conditional Functions
Multiple Criteria Functions
Using Nested Functions
Using Nested Functions
Working with Text Functions, Part 1
Working with Text Functions, Part 2
Working with Text Functions, Part 3
Working with Text Functions, Part 4
Working with Math Functions
Sorting Data, Part 1
Sorting Data, Part 2

Working with Lists

7 Lessons

Filtering Data, Part 1
Filtering Data, Part 2
Filtering Data, Part 3
Querying with Database Functions
Using the Subtotal Function
Using the Subtotal Feature
Creating Tables

Analyzing Data

6 Lessons

Modifying Table Styles
Summarizing Data in Tables
Using the Quick Analysis Shortcut
Customizing Conditional Formatting
Using Formulas with Conditional Formatting
Creating Charts

Visualizing Data with Charts

8 Lessons

Using Chart Types
Changing Chart Data Source
Adding Chart Elements
Formatting a Chart
Using Advanced Chart Features
Applying Trendlines
Creating a Chart Template
Inserting Graphics

Inserting Graphics

3 Lessons

Modifying Graphics, Part 1
Modifying Graphics, Part 2
Creating a PivotTable

Using PivotTables and Pivot Charts

9 Lessons

Summarizing Data in a PivotTable
Grouping Data in a PivotTable
Formatting a PivotTable
Selecting and Moving PivotTables
Changing PivotTable Options
Adding Calculated Fields
Presenting Data with PivotCharts
Using Slicers
Using Timeline Slicers

0

0 Ratings

5 Star 0%

4 Star 0%

3 Star 0%

2 Star 0%

1 Star 0%

Reviews

Free

Start Course

Course Includes

Working with named ranges
Inserting functions
Using advanced sorting and filtering techniques
Inserting Tables
Applying advanced Conditional Formatting
Inserting charts and graphics
Applying advanced charting tools
Working with Pivot Tables, Pivot Charts, Slicers, and Timelines