Excel Training Courses

Excel Essential and Formulas

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

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.

Prerequisites

• None. Beginner course

Excel Functions Including Pivot Tables

This course is designed for students who already have foundational 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.

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Prerequisites

• It is reccommended you first complete: Excel Essential and Formulas
• Or have significant experience using Excel

Automating Excel with Macros and Analysis Tools

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

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.

Prerequisites

• It is reccommended you first complete: Excel Essential and Formulas
• Or have significant experience using Excel

VBA with Microsoft 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.
• Write VBA code to create VBA subroutines and functions.
• Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

Prerequisites

• It is reccommended you have significant experience using Excel