Mastering Excel 2019 – Intermediate

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

Tags:

Tutorial Bar
Logo