"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.
Excel 365, 2019, 2016 and others.
Select a level below for details or
click here to contact us
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
Microsoft Excel training courses from beginner to expert level are delivered in Dundee, Aberdeen, Edinburgh, Stirling, Glasgow, Fife, London, Aberdeenshire, Angus, Perth and locations across the country.
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
Microsoft Excel training courses from beginner to expert level are delivered in Dundee, Aberdeen, Edinburgh, Stirling, Glasgow, Fife, London, Aberdeenshire, Angus, Perth and locations across the country.
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
- 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 Dundee, Aberdeen, Edinburgh, Stirling, Glasgow, Fife, London, Aberdeenshire, Angus, Perth and locations across the country.
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.
Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in Aberdeen, Glasgow, London, Perth Edinburgh, Stirling, Dundee, Angus, Fife and most locations across the country.
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.
Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in Aberdeen, Glasgow, London, Perth Edinburgh, Stirling, Dundee, Angus, Fife and most locations across the country.
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
Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in Aberdeen, Glasgow, London, Perth Edinburgh, Stirling, Dundee, Angus, Fife and most locations across the country.
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.
Microsoft Excel training courses from beginner to expert level are delivered by industry-leading instructors in Aberdeen, Glasgow, London, Perth Edinburgh, Stirling, Dundee, Angus, Fife and most locations across the country.
Microsoft Excel 2019,
365, 2016 and 2013 training courses from beginner to expert level delivered by industry leading instructors
onsite in
Dundee,
Aberdeen,
Edinburgh,
Stirling,
Angus,
Perth,
Glasgow,
Fife,
London,
Aberdeenshire 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.
- learn about the new functions in
Excel 365 and explore creative ways to use them:
FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function
Also new in Excel 365:
Create a diagram in Excel 365 with the Visio Data Visualizer add-in
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.
We 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.
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.
Our
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.
New Functions for Excel 365:
FILTER function
RANDARRAY function
SEQUENCE function
SINGLE function
SORT function
SORTBY function
UNIQUE function
Also new in Excel 365: Create a diagram in Excel 365 with the Visio Data Visualizer add-in
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
Create a diagram in Excel 365 with the Visio Data Visualizer add-in
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