TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
Intermediate
Microsoft Office 2019

Mastering Excel 2019 – Intermediate

Overview
Curriculum

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. 

Curriculum

  • 6 Sections
  • 53 Lessons
  • 5h 2m Duration
Expand All
Working with Functions
20 Lessons
  1. Introduction
  2. Using Named Ranges, Part 1
  3. Using Named Ranges, Part 2
  4. Using Named Ranges, Part 3
  5. Working with Date Functions, Part 1
  6. Working with Date Functions, Part 2
  7. Working with Date Functions, Part 3
  8. Working with Time Functions
  9. Working with Logical Functions
  10. Working with Conditional Functions
  11. Multiple Criteria Functions
  12. Using Nested Functions
  13. Using Nested Functions
  14. Working with Text Functions, Part 1
  15. Working with Text Functions, Part 2
  16. Working with Text Functions, Part 3
  17. Working with Text Functions, Part 4
  18. Working with Math Functions
  19. Sorting Data, Part 1
  20. Sorting Data, Part 2
Working with Lists
7 Lessons
  1. Filtering Data, Part 1
  2. Filtering Data, Part 2
  3. Filtering Data, Part 3
  4. Querying with Database Functions
  5. Using the Subtotal Function
  6. Using the Subtotal Feature
  7. Creating Tables
Analyzing Data
6 Lessons
  1. Modifying Table Styles
  2. Summarizing Data in Tables
  3. Using the Quick Analysis Shortcut
  4. Customizing Conditional Formatting
  5. Using Formulas with Conditional Formatting
  6. Creating Charts
Visualizing Data with Charts
8 Lessons
  1. Using Chart Types
  2. Changing Chart Data Source
  3. Adding Chart Elements
  4. Formatting a Chart
  5. Using Advanced Chart Features
  6. Applying Trendlines
  7. Creating a Chart Template
  8. Inserting Graphics
Inserting Graphics
3 Lessons
  1. Modifying Graphics, Part 1
  2. Modifying Graphics, Part 2
  3. Creating a PivotTable
Using PivotTables and Pivot Charts
9 Lessons
  1. Summarizing Data in a PivotTable
  2. Grouping Data in a PivotTable
  3. Formatting a PivotTable
  4. Selecting and Moving PivotTables
  5. Changing PivotTable Options
  6. Adding Calculated Fields
  7. Presenting Data with PivotCharts
  8. Using Slicers
  9. Using Timeline Slicers

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Mastering Excel 2019 – Intermediate
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)
Choose Group(s)
Sync Group(s)
    Create a new group Go to Checkout