Excel training courses -
all versions and levels

Excel 365, 2019, 2016, 2013 and Excel 2010
Select a level below for details or click here to contact us

Excel Foundation
1-day course

Getting started
Spreadsheet terminology 
The Excel environment 
Navigating a worksheet 
Using a template 

Entering and editing data
Entering and editing text and values 
Entering and editing formulas 
Saving and updating workbooks 

Modifying a worksheet
Moving and copying data 
Moving, copying, and viewing formulas 
Absolute and relative references 
Inserting and deleting ranges, rows, and columns 

Functions
Entering functions 
AutoSum 
Other common functions 

Formatting
Text formatting 
Row and column formatting 
Number formatting 
Conditional formatting
Additional formatting options 

Charts
Chart basics 
Formatting charts 

Graphics
Working with pictures 
Conditional formatting with graphics 
SmartArt graphics 

Printing
Preparing to print 
Page Setup options 
Printing worksheets 

Topics covered will vary slightly depending upon the version of Excel you are using:
Excel 365
Excel 2019
Excel 2016
Excel 2013
Excel 2010
Excel 2007

click here to see for further details about this course

or click here to contact us

Contact us

 


Microsoft Excel training courses from beginner to expert level are delivered in DundeeAberdeenEdinburghStirlingGlasgowFifeLondonAberdeenshireAngusPerth and locations across the country.

See our prices

Excel Intermediate
1-day course

Managing workbooks and worksheets
Viewing large worksheets 
Printing large worksheets 
Working with multiple worksheets 
Linking worksheets with 3-D formulas 
Using multiple workbooks 
Linking workbooks 

Advanced formatting
Using special number formats 
Working with themes 
Other advanced formatting 

Outlining and subtotals
Outlining and consolidating data 
Creating subtotals 

Cell and range names
Creating and using names 
Managing names 

Data structure and tables
Sorting and filtering data 
Working with tables 

Introduction to PivotTables and PivotCharts
Creating a PivotTable 
Creating a PivotChart 

Web and sharing features
Saving workbooks as Web pages 
Using hyperlinks  

Documenting and auditing
Auditing features 
Comments in cells and workbooks 
Protection 
Workgroup collaboration 

Application settings and templates
Application settings 
Working with templates 


click here to see for further details about this course

 or click here to contact us

Topics covered will vary slightly depending upon the version of Excel you are using:
Excel 365
Excel 2019
Excel 2016
Excel 2013
Excel 2010
Excel 2007
 

Contact us

 


Microsoft Excel training courses from beginner to expert level are delivered in DundeeAberdeenEdinburghStirlingGlasgowFifeLondonAberdeenshireAngusPerth and locations across the country.

See our prices

Excel Advanced
1-day course

Advanced functions and formulas
Logical functions
Conditional functions
Financial functions
Text functions
Date and time functions
Array formulas
Calculation options 

Lookups and data tables
Using lookup functions 
Using MATCH and INDEX 
Creating data tables 

Advanced data management
Validating cell entries 
Advanced filtering 

Advanced charting
Chart formatting options 
Combination charts 
Graphical objects 

PivotTables and PivotCharts
Working with PivotTables 
Modifying PivotTable data 
Formatting PivotTables 
Using PivotCharts 
PowerPivot

Exporting and importing data
Exporting and importing text files 
Getting external data 

Analytical tools
Goal Seek 
Scenarios 
Instant data analysis

Macros and Visual Basic
Running and recording a macro 
Working with VBA code 

click here to see for further details about this course

 or click here to contact us

Topics covered will vary slightly depending upon the version of Excel you are using:
Excel 365
Excel 2019
Excel 2016
Excel 2013
Excel 2010
Excel 2007
 

Contact us

 

New Functions for Excel 365

 - learn about these functions and explore creative ways to use them:
FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function  

Microsoft Excel training courses from beginner to expert level are delivered in DundeeAberdeenEdinburghStirlingGlasgowFifeLondonAberdeenshireAngusPerth and locations across the country.

 

See our prices

Excel Power User
1-day course

An Excel Power User course can cover an extensive range of topics, techniques and concepts; the following are examples and a course will be designed to meet your needs:

Advanced formulas, functions, and arrays
Text functions
Date and time functions
Information functions
Advanced Lookup, Match, Index, Offset and other functions
Array formulas

Advanced editing and formatting
Merging styles
Additional chart formatting
Tables

Analysing and sharing information
Add-ins
Solver models and reports
Analysis ToolPak
Embedding and linking

Advanced customisation
Popular and Save options
Formulas options
Automating Excel
Advanced options

Dashboards and Advanced Charts
Principles and concepts
Dynamic Charts
Data, analysis and presentation layers
Data Format
Advanced Chart Formatting and Combination Charts
Pivot Charts
Form Controls for Charts and Dashboards
New Charts available in Excel:
Funnel chart
Histogram
Pareto chart
Sunburst chart
Treemap chart
Waterfall chart
Box and whisker chart

Power Tools

Power BI
Business Intelligence. Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organisation to consume on the web and across mobile devices.

Power Pivot
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

Power View
Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting.

Power Map
Power Map is a 3D data visualization tool for Excel that provides an immersive experience for making discoveries in data that might never be seen in traditional 2D tables and charts. Power Map lets you plot geographic and temporal data visually, analyze that data in 3D, and create cinematic tours to share with others.

Power Query and Get & Transform
Power Query is known as Get & Transform from Excel 2016. Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources. With Get & Transform in Excel, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.

VBA for Excel

... a range of further topics can be covered to meet your business needs and training requirements.

Topics covered will vary slightly depending upon the version of Excel you are using:
Excel 365
Excel 2019
Excel 2016
Excel 2013
Excel 2010
Excel 2007

Click here to see further details about our Power User courses.

Contact us

See our prices

Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in AberdeenGlasgowLondonPerth EdinburghStirlingDundeeAngusFife and most locations across the country.

Power BI
1-day course

Getting started
Introducing Power BI
Using Power BI
The building blocks of Power BI
A quick look at the Power BI service
Review and what's next

Getting data
Overview of Power BI Desktop
Getting started with Power BI Desktop
Connect to data sources in Power BI Desktop
Clean and transform your data with the Query Editor
More advanced data sources and transformation
Cleaning irregularly formatted data

Modeling
Introduction to modeling your data
How to manage your data relationships
Create calculated columns
Optimising data models
Create calculated measures
Create calculated tables
Explore your time-based data

Visualisations
Introduction to visuals in Power BI
Create and customize simple visualizations
Combination charts
Slicers
Map visualizations
Matrixes and tables
Scatter charts
Waterfall and funnel charts
Gauges and single-number cards
Modify colors in charts and visuals
Shapes, text boxes, and images
Page layout and formatting
Group interactions among visualizations
Duplicate a report page
Show categories with no data
Summarization and category options
Z-order
Visual hierarchies and drill-down
R integration in Power BI Desktop

Exploring data
Introduction to the Power BI service
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Display visuals and tiles full-screen
Edit tile details and add widgets
Get more space on your dashboard
Install and configure a personal gateway

Power BI and Excel
Introduction to using Excel data in Power BI
Upload Excel data to Power BI
Import Power View and Power Pivot to Power BI
Connect OneDrive for Business to Power BI
Excel in Power BI - summary

Publishing and sharing
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export dashboards and reports
Manually republish and refresh your data
Introducing Power BI Mobile
Create groups in Power BI
Build content packs
Use content packs
Update content packs
Integrate OneDrive for Business with Power BI
Publish to web
Completion of Power BI Guided Learning

Introduction to DAX
Introduction to DAX
DAX calculation types
DAX functions
Using variables in DAX expressions
Table relationships and DAX
DAX tables and filtering

Topics covered will vary slightly depending upon the version of Excel you are using, e.g 2007, 2010, 2013, 2016, 2019 or 365.

Click here to see further details about our Power BI courses.


Contact us



See our prices

Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in AberdeenGlasgowLondonPerth EdinburghStirlingDundeeAngusFife and most locations across the country.

Excel VBA
1-day course

Visual Basic Editor
Visual Basic for Applications
Object programming
The Object Browser

Programming basics
Data basics
Scope of variables
Scope of procedures

Control structures
Decision structures
Loop structures

Custom dialog boxes
User forms
Events

Debugging and error handling
Errors
Debugging
Error handling


See our prices

Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in AberdeenGlasgowLondonPerth EdinburghStirlingDundeeAngusFife and most locations across the country.

Contact us

Excel Bespoke courses

We design bespoke MS Excel courses, develop custom solutions, tailor courses to suit your needs and provide consultancy services at all levels.

Contact us to discuss your requirements for an Excel training course or an inhouse support and training programme that meets your staff training needs and business objectives. Our Microsoft Excel training courses, support and consultancy services are delivered in most locations across the country.

See our prices

Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in AberdeenGlasgowLondonPerth EdinburghStirlingDundeeAngusFife and most locations across the country.

Contact us

 

Onsite Excel Courses

Bespoke coursesMicrosoft Excel 2019, 365, 2016 and 2013 training courses from beginner to expert level delivered by industry leading instructors onsite in DundeeAberdeenEdinburghStirlingAngusPerthGlasgowFifeLondonAberdeenshire and at locations across the country.

Training on your premises is effective and convenient. Excel skills are acquired in a familiar environment, courses can be tailored to business needs and staff requirements and trainees can use their own files and equipment for hands-on experience. Courses can range from the basics of using Excel effectively to the latest business intelligence and analytics tools.

New Functions for Excel 365

 - learn about these functions and explore creative ways to use them:
FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function  

Prices for onsite MS Excel courses offer superb value, an expert instructor comes to you at no additional cost to you. Offsite venues also available at various locatons. Contact us for further information.

Contact us

Bespoke Excel Courses

Onsite Training CoursesWe design bespoke MS Excel courses, develop custom solutions, tailor courses to suit your needs and provide consultancy services at all levels.

We understand that people in your organisation carry out different tasks and require different skills. We will design courses for people using Excel for business analysis and projection or for those creating charts, reports and dashboards or for many of the other activities carried out in the workplace.

We will design and deliver training for the needs of your organisation and the different roles of staff members and ensure people in all roles and disciplines are expertly trained to enable them to apply expertise in ways that improves efficiency, effectiveness and productivity.  

Contact us to discuss your requirements for an Excel training course or an inhouse support and training programme that meets your staff training needs and business objectives. Our Microsoft Excel training courses are delivered in most locations across the country.

Contact us

Fast-track Excel training

Fast track Excel training sessions are highly-focussed intensive training sessions delivered in short bursts to give busy people the essential Excel skills they need in the shortest possible time.

Fast-track coursesOur fast-track Excel courses are a quick way to transfer essential skills in the shortest possible time - useful for busy staff members unable to undertake comprehensive training. Fast-track courses are suitable for a variety of purposes and can, for example, be used by busy professionals to see what's new in Excel 2019, 365 or 2016.

What's new in Excel 2016 for Windows

Excel 2016 for Windows has all the functionality and features you're used to with some added features and enhancements and the best new features from Office 2016.
Here are some of the top new and improved features for Excel 2016:
Six new chart types.

Get and transform (Query)
Excel 2016 now comes with built-in functionality that brings ease and speed to getting and transforming your data

One click forecasting
In Excel 2016, the FORECAST function has been extended to allow forecasting based on Exponential Smoothing (such as, FORECAST.ETS() …).

3D Maps
Our popular 3D geospatial visualization tool, Power Map, has been renamed and is now available to all Excel 2016 customers and is built into Excel.

PivotTable enhancements
Here are some of the enhancements we made in Excel 2016, so that you can focus less on managing your data and more on uncovering the insights that matter.
Automatic relationship detection discovers and creates relationships among the tables.
Creating, editing and deleting custom measures can now be done directly from the PivotTable fields list

Multi-select slicer
Now you can select multiple items in an Excel slicer on a touch device.

Publish and share your analysis with Power BI
Once you’re finished preparing your data analysis, you can share it with your workgroup or clients through Power BI with just one button. Once published to Power BI, use your data models to quickly construct interactive reports and dashboards.

Quick Shape Formatting
This feature increases the number of default shape styles by introducing new styles in Excel.

Insert pictures with the correct orientation
With automatic image rotation, once you insert an image into Excel, it automatically rotates the picture to match the camera’s orientation. .

Insights into what you're working on
The Insights pane, powered by Bing, offers more than just definitions. When you select a word or phrase, right-click it, and choose Smart Lookup, the insights pane will open with definitions,

Ink Equations
Including math equations has gotten much easier. Now, you can go to Insert > Equation > Ink Equation, any time you want to include a complex math equation in your workbook. If you have a touch device, you can use your finger or a touch stylus to write math equations by hand, and Excel will convert it to text.

Simpler sharing
Choose Share on the ribbon to share your spreadsheet with others on SharePoint, OneDrive, or OneDrive for Business.

Improved version history
Now you can go to File > History to see a complete list of changes that have been made to your workbook and access earlier versions.

Data Loss Protection (DLP) in Excel
Data Loss Protection (DLP) is a high-value enterprise feature that is well loved in Outlook. We are introducing DLP in Excel to enable real time scan of content based on a set of predefined policies for the most common sensitive data types (e.g., credit card number, social security number).

New functions
Courses will covthe use of new functions such as:

TEXTJOIN
This function combines text from multiple ranges, and each item is separated by a delimiter that you specify. Learn more about TEXTJOIN here.
 
CONCAT
This new function is like CONCATENATE, but better. First of all: it's shorter and easier to type. But it also supports range references in addition to cell references. L
 
IFS
Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else "catch all" if none of the conditions are met.

SWITCH
This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the "else" is returned.
 
MAXIFS
This function returns the largest number in a range, that meets a single or multiple criteria.
 
MINIFS
This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria.

New Functions for Excel 365:

FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function  


Contact us

What Our Clients Say

  • "The course to say the least was brilliant ... fantastic tutor ... would recommend the company and tutor to anyone" - delegate feedback. We will certainly use you again for future needs.

    Group HR Manager
    International Vehicle Manufacturer
  • Great feedback about the instructor and the high quality of training ... many thanks again for providing us with a truly excellent training experience.

    Training Administrator
    Aberdeen
  • Thanks again for another course run to an excellent standard.

    Office Manager
    Glasgow
  • Please thank the trainer for his hard work last week … so excited after the training … couldn’t wait to start implementing some of the ideas/techniques

    Administration Manager
    London
  • I enjoyed the course immensely, thanks again.

    IT Project and Training Consultant
    Oil Company
  • Post course support: Thanks! Genius! Thank you so much for not only getting back to me so quickly, but for fixing the problem!

    University Department Head
    University
  • The training was fantastic, my colleagues and I really enjoyed the session and we all benefitted greatly.

    Project Coordinator
    Stirling
  • Group of Project Managers (all scientists) - MS Project 2010 - The training course was excellent.

    Vice President
    Pharmaceutical Company

enquiries and bookings made simple

Information and advice freely provided ...
... and you will not be pestered by follow-up sales calls!

Contact us for further details about our courses, prices and availability.

An experienced instructor can provide you with advice or assistance without any obligation.

Click here to email us for further information or advice  
Training designed to your requirements
Working with world-class companies and organisations to increase productivity and performance