Mastering Excel 2019 – Intermediate
There are two kinds of people: Those who are masters at Excel, and those who wish they were
What you’ll learn
-
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 columns of data
-
Create and modify Tables, and apply advanced Conditional Formatting
-
Create and modify charts and graphics
-
Apply advanced charting tools
-
Create a PivotTable to group and summarize data
-
Apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines
Requirements
-
Students should have a basic knowledge of Microsoft Excel prior to taking this course
Who this course is for:
- People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data