Excel Beginners training course – details below
Excel Intermediate training course – details below
Excel Advanced training course – details below
Excel Tips and Tricks – details below
Excel Bespoke training course – details below
Excel Power Query training course – details below
Excel design and consultancy services – details below
Excel Skills assessment – details below
We love training and we love helping you and your colleagues become more efficient when using Excel. That’s why our biggest tip when using Excel is to please, please STOP RIGHT CLICKING. It’s a huge waste of time and we’ll explain why during our courses. The penny drops thereafter.
Take a look below at what we can offer, if you don’t see what you are looking for we would love to have a chat with you and plan your course accordingly
From beginner to advance and everything in between we have a course to fit your exact requirements. It could be a standard course that fits your needs or something more bespoke. You may even want to assess your workforce skill set before deciding. Whatever it may be we are here to help you, guide you and train you to increase productivity with Excel
We are one of the only training providers in the UK who provide video courseware after every Excel course at no extra cost. Our videos will see you and your staffs Excel skills soar.
An overview of the course content is below, for further details please get in touch and we can send you the full course outlines
Excel Beginners course
Getting To Know Microsoft Excel
How to create a new Excel workbook Saving a new workbook
Working with Workbooks to a server, to One Drive, to Sharepoint or to Teams
Working with multple cells in Excel – aka Ranges
How to create Excel Formulas
How to use excel Functions
How to Copy Data in Excel
How to format Fonts in Excel
How to align cells in Excel
How to format rows and columns in excel
How to format numbers in excel
How to print an excel spreadsheet
How to create charts in excel
Excel Intermediate course
Working with mulitple Excel workbooks simultaneously
How to work on multiple excel worksheet simultaneously
How to Fill data using Smart Tags
Excel Formulas recap
How to use Excel tables to filter and analyse data
How to use a $ in Excel formulas
How to use Excel Logical functions including IF, SUMIF, COUNTIF
How to use Excel Lookup functions including XLOOKUP
How to use Excel Conditional formatting
How to create Excel Pivot tables
An introduction to Power Query
Excel Advanced course
Setting excel options
How to use Excel Custom views
Using The Excel Camera
How to use Excel arrays formulas UNIQUE, FILTER, XLOOUP, SORT & XMATCH
How to use VSTACK, HSTACK, SQUENCE, CHOOSECOLS, CHOSSEROWS, DROP, TAKE, TEXTSPLIT, TEXTBEOFRE, TEXTAFTER, TOCOL, TOROW, WRAPCOLS, & WRAPROWS
How to set up and use Excel data validation
How to set up and use Excel data validation dynamically
Grouping and outlining in excel
Advanced Pivot table analysis
Summarising data using Excel subtotals
Protecting Data in excel
An introduction to Power Query
Recorded Excel Macros
Automating Excel tasks
How to set up and use the Excel Scenario Manager
Excel bespoke course
If you have specific skills your colleagues need to learn then talk to us and we can create a course specifically for you
Excel Design and Consultancy
Do you have old Excel spreadsheets that cause continual problems
Excel Spreadsheet with Macros that have stopped working
Require Excel spreadsheets to be updated to use latest formulas and functions
Need to design new Excel spreadsheets
We can help with any issues or design requirements you have with Excel
Excel Power Query
If you clean data, combne data or regularly undertake repeattive tasks in Excel this course is a must
Excel Tips and Tricks
Combine multiple worksbooks in to one
Combine multiple tables in to one
How to recover unsaved Excel workbooks (even if you select “don’t save”)
How to recover an Excel workbook when you click “don’t save”
How to Quickly check Excel workbooks for Hidden rows & columns, hidden worksheets, Comments, meta data, links, active filters, headers and footers, timelines or invisible content.
Excel shortcuts to save workbooks
Excel shortcut toadd up columns of numbers
Excel shortcut to add today’s date to a cell
Check if your workbook is compatible with older versions of Excel
How to Hide formulas Excel
How to hide Excel cell contents
How to use Excel tables and slicers
How to Include the name of the day of the week and date in the same Excel cell
How to set up quick typing in excel – aka autocorrect
Increase all numbers by 10% in Excel without using a formula
Copy data from Rows to columns or columns to rows in Excel
Copy and paste data retaining custom column widths from one Excel sheet to another
Use Excel Copy and paste to create a formula
Check for features not supported by earlier versions of excel
Set up hyperlinks to navigate around an Excel workbook
Using excel without a mouse or touchpad
Quickly Find cells with formulas in Excel
And more
Excel Skills assessment
If you;re unsure what level you or your colleagues are at and therefore teh best course to suit their needs you can complete our excel skills analysis questionnaire, have a chat with us and then we can advise the best course.
Online learning portal
Anyone attending our Excel courses will receive three months free subscription to our online learning portal
Contact us about Project
It’s always easier to contact us via email rather than phone. We’re out training most days of the week