Certificate of Professional Development

Microsoft Excel Advanced

Programme structure:

Excel 2016 Part 2 – Analyzing Data with Logical and Lookup Functions
You will learn how to analyze data by using text, logical, lookup, date and financial functions.

Excel 2016 Part 2 – Enhancing Workbooks
In this course, you will learn how to customize workbooks, manage themes and, create and use templates. Protecting files and preparing a workbook for multiple audiences will also be covered.

Excel 2016 Part 2 – Organizing Worksheet Data with Tables
This course covers how to create and modify tables, sort and filter data, use subtotal features, and work with database functions.

Excel 2016 Part 2 – Creating Advanced Formulas
In this course, you will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Excel 2016 Part 2 – Inserting Graphics
You will learn how to insert, modify, layer and group graphical objects. We will also take a look at how to incorporate SmartArt into workbooks.

Excel 2016 Part 2 – Analyzing Data with PivotTables, Slicers, and PivotCharts
Creating a PivotTable, filtering data using slicers and, analyzing data using PivotCharts will be covered in this course.

Excel 2016 Part 2 – Visualizing Data with Charts
You will learn how to create charts, as well as how to modify and format existing charts. They will also learn how to create a trendline and advanced charts.

Register Now

CPD Registration Form
First
Last
We need 1 valid ID for maintaining your student records.