Software Training
Mastering Excel 2019 – Intermediate
Course description
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 manage data, charts, and tables, and how to use powerful tools such as PivotTables, PivotCharts, Slicers, Timelines, and more.
Course Duration: 318 min
Learning 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 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