Excel Training Courses

Excel Essential and Formulas

This course is intended for those who wish to gain a foundation and understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.

Excel Functions Including Pivot Tables and Lookups

Designed for students who already have foundation knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Automating Excel with Macros and Analysis Tools

This course is for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.

VBA with Microsoft® Excel®

In this course, you will develop and deploy VBA modules to solve business problems. You will:

Programming and Data Wrangling with VBA and Excel

In this course, you will develop and deploy VBA modules to solve business problems. You will:

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
• Write VBA code to create a custom worksheet function.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
• Control how and when macros run.
• Develop UserForm objects to create custom dialog boxes and windows.
• Use VBA to read and write data from local files and cloud services.
• Use VBA to clean and transform data.
• Run programs and commands outside of Excel and share VBA projects with other users.

Excel for Office 365 - Data Analysis with PivotTables

In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data.

You will:

• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze data by using PivotTables.
• Work with PivotCharts.

Data Analysis and Visualization with Microsoft Excel

In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

• Perform data analysis fundamentals.
• Visualize data with Excel.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Present visual insights with dashboards in Excel.
• Create geospatial visualization with Excel.
• Perform statistical analysis.
• Get and transform data.
• Model and analyze data with Power Pivot.
• Present insights with reports.