Microsoft Excel Coaching

Microsoft Excel Courses

Excel Coaching Courses
Excel Essentials

In the Excel Foundation Training Course the student will learn all the essentials in Excel, from Formatting, Cells, Data and Numbes to working with Rows and Columns. Gain ground level understanding of Formulas and Functions that will hold you in good stead, in creating more complex calculations in the future. This course is a must not only for newbies to Excel, but even for those who have been using this Amazing Application.

This course has no prerequisites other than basic computer usage skills.

By the End of this coaching course, the participant will have a good understanding of Excel Foundation skills, inclusive of:

  • Entering and Editing Data.
  • Formatting Cells and Data, inclusive of Number Formats.
  • Create Formulas from Scratch.
  • Using SUM, AVERAGE, MAX & MIN Functions
  • Using Absolute References
  • Create and Use Charts
  • Windows View Features
  • Printing and Layout
Excel Intermediate

In the Excel intermediate training the student will be able to gain skills in such areas as filtering data, creating and using tables. Also the use of advanced formatting tools and conditional formatting. This course will also focus on more complex functions inclusive of VLOOKUP and IF. The student will also expand on their knowledge of Charts by understanding additional features and by the use of more complex data sets.

It is advisable that participants have a working understanding of Excel. This will include creating and using basic functions such as the SUM function.

  • Using Sorting & Filtering Tools
  • Use common worksheet functions
  • Complex formulas and functions (IF, VLOOKUP...)
  • create and defined names in a workbook
  • Conditional formatting
  • Using Data Validation to control Data
  • Using What-if Analysis Tools
  • Create and work with tables
  • Use advanced features to enhance charts
  • Using Charts for More Complex Data Sets
Excel Advanced

In this course the participant will learn advanced Excel features such as working with nested functions, consolidation of data & Data Linking across worksheets and workbooks. The participant will also learn how to secure cells and workbook structure. This course includes Understanding and Using Pivot Tables and Charts, and an introduction to Excel Macros.

This course is designed for those who are versatile with Excel, and would like to use more powerful features of Excel to meet extended work requirements.

  • Protect information in worksheets and workbooks
  • Use data linking across worksheets and workbooks
  • Using Group and Outline Tools
  • Using Subtotals to Summarize Data
  • Working with Data Consolidation
  • Create and Use a Pivot Tables
  • Use Pivot Table Tools to Enhance Analysis Outcomes.
  • Create and Use a PivotChart
  • Use advanced filters to analyse data
  • Share Workbooks with other users
  • Introduction to Excel Macros
Excel Formulas and Functions

This is an elective subjects course, specialising in understanding and using a wide range of Excel Functions. Included in this course are Lookup, Logical and Text Functions as well as a range of others.

This course is designed for those who are versatile with Excel, and would like to use more powerful features of Excel to meet extended work requirements.

  • Logical functions (IF, AND, OR etc...)
  • Lookup and Reference functions ( VLOOKUP, HLOOKUP, INDEX, MATCH etc...)
  • Maths functions (SUMIF, SUMPRODUCT etc..)
  • Statistical functions (AVERAGE, AVERAGEIF,COUNTIF ect...)
  • Financial functions (PV, FV, PMT etc..)
  • Date and Time functions (NOW, TIME, DATEVALUE etc...)
  • Text functions (LEFT, RIGHT, MID, FIND etc...)
  • Information functions (ISBLANK, ISNA, ISNUMBER etc...)
Excel Data Tools and Dashboards

This course is designed to introduce Excel Power Users to Analysis and Visualization tools in Excel. The first part of the course focuses on Pivot Tables and Pivots Charts, Functions to assist with Analysis and the use of Conditional Formatting to Highlight and Measure Data.

The course then covers Get and Transform from other Data Sources using Power Query. Understanding and Using Power Pivot. An introduction to Powerview and helps those entering the world of Business Intelligence to expand on to Power BI as an option for Data Visualization this course provides a firm foundation in Business Intelligence Tools.

This course is designed for those who are versatile with Excel, and would like to use more powerful features of Excel to meet extended work requirements.

  • Functions for Data Analysis
  • What-If Analysis
  • Analysis Toolpak
  • Conditional Formatting Techniques
  • Create & Use Pivot Tables
  • Create and Use Pivot Charts
  • Using Slicers
  • Get and Transform Using Power Query
  • Understanding Power Pivot
  • Using Power Pivot with Large Data Sets
  • Using Powerview to Visualize Data
  • Installing and Using Power BI
  • Creating Visualizations in Power BI
  • Dashboards & Reports
Excel Visual Basic for Applications (VBA)

This course is a programming course to automate tasks in Excel, using the Visual Basic Language. From creating recorded Macros, to understanding and Using VBA to create sophisticated Macros for use in every aspect of Excel. This course covers coding fundamentals including Procedures, Variables, Decision making and Loops. If you want to extend the reach of Excel this course is a must.

This course is designed for those who are versatile with Excel, and would like to use more powerful features of Excel to meet extended work requirements.

  • Recording and Using Macros
  • Editing Macros
  • Visual Basic Editor
  • Understanding VBA Concepts
  • Coding Conventions
  • Excel Object Model
  • Procedures
  • Functions
  • Variables
  • Decision Making
  • Loops
  • Forms
  • Error Handling
  • Customizing the Ribbon

Included with Course:

Learning Online

For More Information:

Business Apps
Microsoft Excel
Microsoft Project
Microsoft Visio
Microsoft Access
Microsoft Word
Microsoft PowerPoint
Microsoft Publisher
Microsoft Outlook
Analysis and Tech
Microsoft Power Bi
Google Data Studio
Microsoft Power Pivot
Microsoft Power Automate
Microsoft Power Apps
Microsoft VBA
Microsoft Sharepoint
Additional
Training Files
Flexi-Blog
Submit a Review
Helpdesk Request
Learning Portal
Whats New