Microsoft Excel Training courses
Course schedule - Microsoft Excel Training Courses
Microsoft Excel Courses we offer:
Enhance your productivity and efficiency by attending our hands-on Microsoft Excel training courses
Free up your time by developing your skills, as a good working knowledge of Microsoft Excel is essential to get the most from this versatile application.
Our public Microsoft Excel training courses are delivered live online helping you structure your day and focus on learning a new skill without the need to travel. Course materials are posted to you and course joining instructions sent via email ensuring you have everything you need for a successful and engaging day.
Excel has many features, so we developed several courses to choose from or let us tailor training just for you.
From Excel training for beginners, Intermediate Excel training or Advanced Excel training being the most popular of our courses. However we also provide specialist Excel training for those that want to move on to programming with VBA, Excel Scripts or move beyond Excel Advanced with Advanced Plus. Or perhaps you’re looking to build an Excel dashboard from data sets taking advantage of advanced Pivot Table design.
A complimentary Training Needs Analysis service is available if you’re unsure of your current skills level.
Learn Microsoft Excel the easy way, with TCS Training. We give you the skills you can apply with confidence, ensuring you get the most from Excel.
If an Excel Live Online course date we’re advertising doesn’t suit you, please do ask as we may be able to run a training course on a different date.
For Group bookings at special rates and Excel training face to face – please contact us.
Most common feedback: “I wish I’d booked this course years ago!”
What makes TCS Training different from other IT Training providers?
We offer:
Hands-on IT training - engaging courses delivered by friendly and qualified trainers.
Public courses are small - up to 4 delegates only.
1 year after course support is included with all courses.
Group booking rates are available on request.
100% of participants recommend TCS Training - read live reviews
Microsoft Excel Introduction Training Course – One Day – £175
Excel training course for beginners or those who want to ensure their basic Excel skills have a solid foundation. Free up your time and learn Excel well with our one day course providing a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.
After attending this course, delegates will be able to produce spreadsheets to manage their data, use simple formulas and functions to calculate values, format any spreadsheet for emphasis and clarify and set up a spreadsheet for sharing and printing, as well as create charts to easily demonstrate values.
Our Excel training course for business users, or those who need the skills to apply in a workplace. Excel training with certification included with your other course materials and our support service available post training if needed.
Prerequisite: Delegates wishing to attend our Microsoft Excel Introduction training course should be comfortable with using a computer.
Prerequisite: Delegates wishing to attend our Microsoft Excel Introduction training course should be comfortable with using a computer.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Introduction training course outline
Basics and Formatting
Tour the Microsoft Excel Environment
Customise the Quick Access Toolbar
Enter and edit data
Adjust Column widths
Move and copy data
Use AutoFill
Format a worksheet
Copy and clear formatting
Prepare a worksheet for printing and PDF
Save a worksheet as a PDF
Learn keyboard shortcuts
Formulas and Functions
Understand and write Formulae
Learn the construction of a Function
Use the SUM function
Use AutoFill to copy a formula
Further Functions
Learn statistical Functions AVERAGE, MIN, MAX and COUNT
Calculate percentages
Learn how to use relative and absolute cell referencing
Work with Data Lists
Use Freeze Panes
Sort data
Filter Information
Charts and Graphs
Create bar, column, line and pie charts
Explore and change chart properties
Microsoft Excel Intermediate Training Course – One Day – £195
Our hands-on instructor led Microsoft Excel Intermediate course for those who have existing knowledge of the Excel fundamentals but wish to improve their skills.
A comprehensive Excel training day which provides delegates with the confidence to use some of the more advanced functions IF, VLOOKUP, XLOOKUP, alongside gaining the skills to analyse Excel data, report with Pivot Tables and protect their data.
Pre-requisite: Before attending this course, delegates must have either attended our Introduction to Microsoft Excel training course or be comfortable with those topics covered at Introduction level, especially formulas and basic functions.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Intermediate training course outline
Rounding Functions and Named Ranges
Word with Rounding functions
Create Named Ranges
Use Named Ranges with common Functions
Work with Data Lists
Sort multiple columns of data
Filter Information
Apply Validation Rules
Create Subtotals
Insert and work with Pivot Tables
Apply conditional Formatting,
Work with More Advanced Functions
Work with the IF Function
Learn the new IFS Function
Use the SUMIF Function
Apply the COUNTIF Function
Look up data with the VLOOKUP and XLOOKUP Functions
Multiple Sheets and Protection
Enter data and use Formulas across sheets
Group sheets for Input and formatting
Consolidate data on a summary sheet
Protect a worksheet
Protect cells within a worksheet
Password protect a workbook
Microsoft Excel Advanced Training Course – One Day – £225
Our Microsoft Excel Advanced training course is for those with a sound working knowledge of Microsoft Excel. Delegates who wish to upskill their Intermediate knowledge of Excel to Advanced Excel skills and use more complicated functions and features. The course will allow delegates to work with a confidence in building more complex Pivot Tables, nest functions, analyse data and build macros for automation.
If you want an Advanced Excel training course online, delivered by passionate and knowledgeable trainers then this is the course for you.
Pre-requisite: Before attending this course, delegates must have either attended our Intermediate level Excel training course, or be comfortable with those topics covered at Intermediate level.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Advanced training course outline
Work with and Nest Functions
Nest functions IF with AND / OR, IFERROR, IFNA, VLOOKUP, VLOOKUP with MATCH
Use XLOOKUP Function in a variety of ways
Utilise the IFS Function
Apply various DATE Functions
Use and nest a variety of TEXT Functions
Understand and apply the functions SWITCH, TEXTJOIN and CONCAT
Work with data
Use Flash Fill
Conditionally format whole rows with formulas
Advanced Pivot Tables
Grouping data
Work with Pivot Filters and Slicers
Create calculated fields
Use “values as”
Adjust field settings
Drill down and refreshing data
Changing the Data source
Build Pivot Charts
Macros and Excel Forms
Record a Macro
Assign a Macro to the Quick Access Toolbar
Assign a Macro to a Button
The Goal Seek Analysis Tool & Consolidation (time permitting)
Use Goal Seek
Consolidation/Questions
Note: During the course we cover many functions found in the later version of Excel.
Prerequisites: Delegates must have either attended our Microsoft Excel Intermediate training course or be comfortable with topics covered at our Intermediate level.
Microsoft Excel Data Lists & Dashboards Training Course – One day – £225
Our Microsoft Excel Data Lists & Dashboards training course for those who work with multiple columns of data in lists within Excel, either exported from another application or entered directly into Excel. Learn to confidently apply Excel data analysis to Excel data sets.
Our Data Lists and Dashboards course is suitable for anyone requiring in-depth knowledge of Pivot Tables and Pivot Charts and providing interactive Excel Dashboards for others to see summary information at a glance. You will also learn to apply specific Database Functions DSUM, DAVERAGE, DCOUNT, DMIN, DMAX and also work with the new XLOOKUP and UNIQUE function.
Prerequisite:
To attend this course delegates should be a confident Microsoft Excel user, especially in using Excel functions.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Data Lists course outline
Setting up and Entering Data
Rules to follow
Using the Data Form
Setting up Data Validation
Freeze Panes
Useful Functions
The IF, AND, IFS and OR Functions
Database Functions
VLOOKUP and XLOOKUP Function
Excel Tables
Flash Fill
Reporting Tools
Sorts and Filters
Conditional Formatting
SubTotals
Sparklines
Pivot Tables
Pivot Charts
Microsoft Excel Advanced Plus Training Course – One day – £295
Our one day Microsoft Excel Advanced Plus training course is for users who are at Advanced level but want just a bit more! The course builds on knowledge from previous levels and introduces the concepts of data modelling in Excel and the use of Microsoft Excel PowerPivot.
Prerequisite: It is recommended that delegates wishing to attend our Excel Advanced Plus course have advanced level Excel skills. The course takes on concepts working with data models and relational analysis. A good understanding of Excel is essential in order to get the most benefit from this course.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Advanced Plus course outline
PowerPivot
PowerPivot Overview
Where do I get PowerPivot from?
Connecting to a Data Source
Pasting Data into PowerPivot
Creating a Pivot Table
Creating a Pivot Chart
Converting Pivot Tables and Charts into one view
Creating Slicers
Creating a Calculated Column
Data Models
Introduction to the Data Model,
Combining Data from Two data tables
Combining Data from more than one source
Using the Diagram View
Managing relationships between tables,
Function Work
KPIs
Two way Index
Work with OFFSET
Work with SUMPRODUCT
NOTE: This course is a suggested course outline and can be tailored on request.
Microsoft Power Query Training Courses – One day – £295
Power Query is a powerful data manipulation tool. Although commonly used in Microsoft Excel, Power Query also exists in Microsoft Power BI so the skills can be used here also.
Power Query typically works by importing data, manipulating that data and places it in a spreadsheet for further processing with Microsoft Excel. Therefore data transformation is the purpose of this powerful tool.
Power Query can access databases and a range of file types including Excel, CSV, XML, JSON, PDF, SQL Server, Access, Azure Data Storage, Power BI, Web Feeds, Dataverse Tables, OData feeds and ODBC compliant databases.
Attend our Microsoft Power Query course to learn Power Query for data cleansing, reformatting, data shaping by filtering, extraction of information and manipulation of date and text fields.
Prerequisite: It is recommended that delegates wishing to attend our Microsoft Power Query course have at least Advanced level Excel skills.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Power Query course outline
Introduction:
- What is Power Query used for?
- Types of data can Power Query import
- Types of data best loaded into Power Query
Data Manipulation
- Importing data from an Excel spreadsheet
- Importing a blank worksheet
- Renaming sheets
Working in the Power Query Window
- Building queries
- Query settings
- Using the Formulas Bar
- Adjusting Query properties
- Using applied steps
- Putting Query Results back into Excel
- Checking and resolving errors
Data Transformation
- Filtering data
- Selection columns
- Splitting columns
- Removing rows
- Transposing data
- Changing Data Types
Working with Data
- Manually editing values
- Creating Totals
- Formatting dates
- Formatting text
- Conditional columns
- Appending data
- Merging queries and joins
- Creating Index columns
- Using reference numbers
- Tips for understanding your data
M Language
- Reading M for Applied Steps
- The Formula Bar
- The Advanced Editor
- M Language References
- Work with Expressions
- Identify Functions by Category
Q&A
Microsoft Excel Scripts Training Course – One day – £295
Office Scripts are effectively Macros for Excel in the cloud! Unlike Microsoft Excel desktop macros, Scripts are written in typescript and can be executed from other places like Power Automate and are very easy to share.
Our one day Microsoft Excel Scripts course gives you the confidence to write scripts and store them in OneDrive or SharePoint. You will then learn to run them in Excel Online or Desktop versions and trigger them for use using Microsoft Power Automate.
Prerequisite: You must be an experienced user of Microsoft Excel to attend this course.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Excel Scripts course outline
Introduction:
- What are Office Scripts?
- Where can I find Office Scripts?
- What are Office Scripts used for?
The Action Recorder
- How to record an Office Script
- Using an Office Script
Where are Office Scripts Stored
- The default file save location for Office Scripts
- Using SharePoint to share a script with your team
Introducing the Code Editor
- Accessing the Editor
- Using the Editor to amend an existing script
Writing an Office Script
- Create a script from scratch
- Referencing an Excel workshieet
- Referencing cells and ranges
- Using variables to store information
- What is a function?
- Creating a function
- Formatting a range
- Formatting a table
- Creating calculations in Office Scripts
Using Power Automate with Scripts
- Running an Office Script from Power Automate
Q&A
Microsoft Excel In-Person Training
If you prefer Microsoft Excel training delivered in-person, we offer training for groups of up to 10 delegates, or one to one, at your company offices or at our Reading Training Venue. More information about our Reading Training Venue.
You may also be interested in these related courses
Microsoft Power BI Courses
Our Microsoft Power BI training courses for data visualisation business intelligence and reporting. You can connect to your Excel data, as well as other data sources, then analyse and transform your data. Use Power BI to create interactive reports and dashboards in your browser which you can easily share with others.
Structured Query Language (SQL) Courses
Our SQL courses teach you coding which allows integration with Excel to enhance data management and analysis capbilities. Our Microsoft Power Query course supports SQL bringing together all the skills you need with programming for importing, filtering and transforming data from multiple sources.
Microsoft Copilot courses
Our Microsoft Copilot course will give you the skills to use Copilot for AI-powered design to enhance your productivity by providing intelligent assistance with your data. Copilot can analyse your data and generate insights, helping you understand trends and patterns. You can also use for formulas as well as use in other Microsoft 365 apps.
View all our IT Training Courses
Microsoft
Courses
Adobe
Courses
Programming
Courses
What our customers say
Why Choose TCS Training?
Expert Instructors
Our courses are led by experienced and certified trainers who are experts in their fields.
Flexible Learning Options
We offer both live online and on-site training to fit your schedule and learning preferences.
Comprehensive Course Materials
Receive detailed workbooks, reference manuals, and other resources to support your learning.
Post-Course Support
Benefit from up to a year of after-course support to help you apply what you've learned.
Customizable Training
We provide standard, tailored, or bespoke training solutions to meet your specific needs.
Group Booking Discounts
Take advantage of special rates for group bookings, whether for public or private courses.
Work with us
Want to chat to someone from our team about a training course or need something tailored for you - no problem.