Microsoft Excel Training Courses Microsoft Excel Training Courses

Which Excel course is right for you?

We have bags of experience from teaching Excel over the last 20 years and we can help you choose the most useful course for your purposes. Our Excel course are arranged into 3 groups: standard courses, business intelligence courses and VBA (macros) courses.

Excel Spreadsheets

Excel classroom training

We have a whole catalogue of Excel and VBA training courses for all levels and abilities.

Standard Excel Courses

We offer 3 standard Excel courses ranging from beginners to advanced.

Excel Introduction - 1 day

This course includes:

  • Getting Started with Microsoft Excel
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbook Contents
  • Managing Large Workbooks
  • Customizing the Excel Environment

Excel Intermediate - 1 day

This course includes:

  • Creating Advanced Formulas
  • Applying Logical and Lookup Functions
  • Organizing Worksheet Data with Tables
  • Visualizing Data with Charts
  • Using PivotTables, Slicers, and PivotCharts
  • Inserting Graphics
  • Enhancing Workbooks

Excel Advanced - 1 day

This course includes:

  • Automating Worksheet Functionality
  • Conditional Formatting
  • Auditing Worksheets
  • Analyzing and Presenting Data
  • Perform a What-If Analysis
  • Working with Multiple Workbooks
  • Importing and Exporting Excel Data

Business Intelligence Excel Courses

We offer several Business Intelligence related Excel Courses.

Excel Pivot Tables - 1 day

This course includes:

  • Pivot Table Fundamentals
  • Creating Basic Pivot Tables
  • Pivot Table Views
  • Pivot Table Calculations
  • Pivot Charts
  • Working with Data Sources
  • Automating Pivot Tables with Macros

Excel PowerPivot - 1 day

This course includes:

  • Getting started with PowerPivot
  • Adding data to PowerPivot
  • Preparing data for analysis
  • Data formatting and layout
  • PowerPivot and relationships
  • Calculations in PowerPivot
  • Creating PivotTables, Charts & Reports

Excel Dashboards - 1 day

This course includes:

  • Creating Advanced Formulas
  • Work with Forms and Controls
  • Use Lookup Functions
  • Visualizing Data with Charts
  • Create Sparklines
  • Including PivotTables and PivotCharts
  • Filter Data by Using Slicers

Excel VBA Courses

Our Excel VBA courses range from macros to programming.

Excel VBA Essentials - 2 days

This course includes:

  • Getting started with Macros
  • Visual Basic for Applications Environment
  • Introduction to Procedural Programming
  • Excel Model Object
  • Control Flow
  • Variable Declaration
  • Procedures, parameters, variables
  • Debugging
  • Error Handling
  • VBA Forms
  • Arrays and Collections

Excel VBA Introduction - 3 days

This course includes:

  • Getting Started
  • Recording a Macro
  • Working with Procedures and Functions
  • Understanding Objects
  • Using Expressions and Variables
  • Intrinsic Functions
  • Controlling Program Execution
  • Forms Properties, Events and Methods
  • Working with Controls
  • Debugging the Code
  • Handling Errors

Tailored Courses

We can design our courses to meet your needs.

  • Agree the objectives
  • Choose the topics and examples
  • Focus delivery on key aspects
Custom courses

Systematix Clients

Our Blog

Really useful Excel tricks

These really useful Excel tricks and tips can increase your productivity and save you time.

1 - Repetitive Operations

Repeat Last Action F4 or Ctrl + Y

Life is full of repetition and most of the time not only is that boring but we are not always consistent. Using function key F4 (When the mode indicator = READY) will repeat the last action with most operations in Excel. You can go on to use it indefinitely.

So if that row you just inserted that wasn’t enough – press F4
That complex cell formatting in the Format Cells dialog box that you need to repeat – press F4

Read more ...

3d Excel

Just how many sheets can we have in a workbook?

It wasn’t until 1989 that spreadsheet programs enabled more than one sheet in what is now a workbook. The initial maximum limit was 255 sheets in a workbook. The current limit is limited only by available memory. Not to be confused with the Excel Options > General > When Creating New Workbooks > Include this many sheets. This is limited to 255 sheets. You can still add more once the file is created.

Read more ...

5 Really useful Excel tricks

Excel Tricks Tips and More Goodies

This article contains 5 extra Excel Tricks Tips and more sage advice on using Microsoft Excel.

5 - Driving your Computer – Shortcuts (Excel Tricks Tips)

During our training courses it is very apparent that Delegates all have their preferred methods of driving their computer and I find it interesting just how committed Delegates are to their particular method. I am very impressed with those who have taken to learning keyboard shortcuts and use them without even giving them a second thought.

Read more ...

Microsoft Excel is the industry standard spreadsheet application. Learning how to use Excel is both an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as sales results, business profit or loss, calculate loan payments, plan a budget, or stay organized by using checklists.

If you are an employee, learning how to use Excel quickly provides value, as most jobs utilize this application. This presents more opportunities for employment and career advancement.

When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.

Excel training at Systematix includes introduction, intemediate and several more advanced courses including Excel VBA. No matter whether you're brand new to Excel or looking for advanced knowledge, we've got you covered. See the list of Excel course below and get started today!

Classic Microsoft Excel PDF Outlines

Contact Us

If you need any help finding the right course for you. We will get back to you within 1 to 2 working hours.

Please let us know your name.
Invalid Input
Please let us know your email address.
Invalid Input
Invalid Input
Invalid Input
Please let us know your message.
Invalid Input
  •     We respect your privacy.
  • No details are ever sold, hired, lent or given to any third party.