• MS Access
  • MS Word

Mastering Excel 2019 – Intermediate

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

Target Audience: People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data. By the end of this course, you will be able to take your spreadsheets to the next level and use many Excel 2019 or Excel 365 features to be more efficient in analyzing your data.

Instructor: Kathy Jones

Objectives:
• Create and use named ranges
• Insert functions into spreadsheets including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
• Sort and filter column data
• Create and modify tables, and apply advanced Conditional Formatting
• Create and modify charts and graphics
• Apply advanced charting tools
• Create a Pivot Table to group and summarize data
• Apply advanced Pivot Table features, create a Pivot Chart, and filter data using Slicers and Timelines

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were
When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to use links, Lookup functions, Data Validation, Macros, data tables, and more.

This is our most requested training course!

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.

Topics covered include:
• 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

High-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Course Length

Lessons : 53
Seat Time : 5 Hours 5 Minutes

Lessons Include:

Working with Functions
Introduction (1:47)
Using Named Ranges, Part 1 (5:16)
Using Named Ranges, Part 2 (5:32)
Using Named Ranges, Part 3 (5:10)
Working with Date Functions, Part 1 (9:15)
Working with Date Functions, Part 2 (4:38)
Working with Date Functions, Part 3 (3:41)
Working with Time Functions (5:50)
Working with Logical Functions (9:03)
Working with Conditional Functions (8:16)
Multiple Criteria Functions (5:23)
Using IFS and SWITCH Functions (5:57)
Using Nested Functions (6:21)
Working with Text Functions, Part 1 (4:22)
Working with Text Functions, Part 2 (4:55)
Working with Text Functions, Part 3 (3:49)
Working with Text Functions, Part 4 (8:56)
Working with Math Functions (7:55)
Working with Lists
Sorting Data, Part 1 (5:31)
Sorting Data, Part 2 (6:00)
Filtering Data, Part 1 (5:25)
Filtering Data, Part 2 (8:06)
Filtering Data, Part 3 (8:28)
Querying with Database Functions (7:16)
Using the Subtotal Function (4:43)
Using the Subtotal Feature (7:09)
Analyzing Data
Creating Tables (6:45)
Modifying Table Styles (7:10)
Summarizing Data in Tables (1:56)
Using the Quick Analysis Shortcut (4:35)
Customizing Conditional Formatting (6:07)
Using Formulas with Conditional Formatting (6:17)
Visualizing Data with Charts
Creating Charts (5:48)
Using Chart Types (2:30)
Changing Chart Data Source (6:46)
Adding Chart Elements (10:19)
Formatting a Chart (5:23)
Using Advanced Chart Features (4:44)
Applying Trendlines (4:36)
Creating a Chart Template (3:31)
Inserting Graphics
Inserting Graphics (9:15)
Modifying Graphics, Part 1 (12:38)
Modifying Graphics, Part 2
Using PivotTables and Pivot Charts
Creating a PivotTable (12:14)
Summarizing Data in a PivotTable (8:38)
Grouping Data in a PivotTable (6:33)
Formatting a PivotTable (7:42)
Selecting and Moving PivotTables (3:15)
Changing PivotTable Options (8:38)
Adding Calculated Fields (2:03)
Presenting Data with PivotCharts (4:29)
Using Slicers (7:45)
Using Timeline Slicers (1:51)

Trusted by Aspiring IT Professionals, Corporations and
Government agencies for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!