Microsoft Office Excel 2016: Advanced
About the course
Objectives: You will use advanced formulas and functions, and work with various tools to analyse data in spreadsheets finding solutions to business problems. You will also organise table data and present data as charts.
Designed for: This course is meant for those desiring to gain the advanced Excel skills necessary for calculating data, using functions and formulas, filtering and sorting data, using Pivot Tables and Pivot Charts to analyse data and find solutions to business problems.
Prerequisites: Before starting this course, learners are recommended to take Microsoft Office Excel 2016: Beginner
Course Content: Creating Advanced Formulas
- Analysing Data with Logical and Lookup Functions
- Organising Worksheet Data with Tables
- Visualising Data with Charts
- Analysing Data with Pivot Tables, Slicers, and Pivot Charts
- Enhancing Workbooks