As a result:
This course is only available as a private booking for an individual or group.
Our private courses can run online, in-person at your offices or at one of our training centres.
Please contact us for full details.
Payment Of Invoices
For bookings from established businesses, we do not require payment at the point of booking.
We will send you an invoice which you can submit to your accounts payable system.
Purchase Orders
If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.
PAYMENT METHODS:
You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.
We accept payment either via direct bank transfer or card
Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.
Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.
For complete beginners, this course covers all the basics of Excel in one day.
For complete beginners, this course covers all the basics of Excel in one day.
CPD certified
Navigating Excel & workbooks
Inputting data & using dates
Cell referencing & formulas
Using fonts, colours & borders
Printing & formatting your sheet
This one day course will develop your Excel skills showing you how to use more advanced features and become a faster Excel user.
This one day course will develop your Excel skills showing you how to use more advanced features and become a faster Excel user.
CPD certified
Creating & formatting charts
Using conditional formatting
Intermediate-level formulas
Creating & filtering data tables
Linking data between spreadsheets
Our 2 day CPD-certified combined Excel course is the fastest way to go from complete beginner to confident Excel user.
Save £55 when you book our Introduction and Intermediate Excel courses at the same time.
See above for the detailed syllabus’s of these courses.
Our 2 day CPD-certified combined Excel course is the fastest way to go from complete beginner to confident Excel user.
Save £55 when you book our Introduction and Intermediate Excel courses at the same time.
See above for the detailed syllabus’s of these courses.
Book now
Become a poweruser mastering Excel’s most powerful tools & functions.
Become a poweruser mastering Excel’s most powerful tools & functions.
Using logical functions
VLOOKUP, HLOOKUP & INDEX
Creating & editing Pivot Tables
Importing & exporting data
Automating with macros
Using Solver & data controls
Take complete control of Excel using VBA to create your own code and procedures on this 2 day course.
Take complete control of Excel using VBA to create your own code and procedures on this 2 day course.
The object model & key concepts
Programming techniques
Procedures & user-defined functions
Custom forms including controls
Starting procedures automatically
Handling errors
Learn to use Excel’s Power Tools for business intelligence and data analysis on this 2 day course.
Learn to use Excel’s Power Tools for business intelligence and data analysis on this 2 day course.
Power Tools: Query, Pivot & Maps
Importing data
Transforming & preparing data
Data models, measures, fields
Slicers, Pivot Charts & visualisation
Introduction to Power BI
We run a full schedule of remote courses over Zoom.
We also deliver private courses over Teams, if requested.
All our courses (classroom & online) run from 9.30 am to roughly 4.30 pm, with 15-minute breaks mid-morning and mid-afternoon, and a longer break for lunch.
However you attend, our friendly trainers offer a relaxed, supportive learning environment, and you will also receive:
✔ A full-colour manual which covers everything in the course.
✔ Your course exercises so that you can practice at home.
✔ A Certificate of Attendance.
Our training centres are fully air-conditioned, and we provide refreshments and biscuits throughout the day.
We also provide all attendees on our course with certificates.
Please come wearing whatever you are most comfortable in, we do not have a dress code for our training courses.
Our public Excel courses use Windows computers not Macs.
This is not an issue if you use Excel for Mac as the differences are very small.
It is helpful for us to know that you are an Excel for Mac user tough, so please let us know when booking.
All our delegates receive digital course materials, including practice exercises where appropriate.
We also offer unlimited support for 6 months.
Simply email us your question in as much detail as possible and the trainer will come back to you as soon as they are able to.
Yes, in addition to our scheduled courses, we regularly organise private courses for groups and individuals both at our training centres and their offices.
Our private online Excel courses can be run using either Zoom or Microsoft Teams.
No, Excel is still very widely used. Some newer tools are carrying out some functions that used to be carried out in Excel but no tools are replacing Excel.
Excel works particularly well with Teams.
Excel Tab in Teams: You can pin important spreadsheets in a Teams channel, allowing team members to view and edit Excel files directly within Teams without switching apps.
Co-authoring in Teams: Multiple users can edit the same Excel file simultaneously, with real-time updates. This is ideal for collaborative budgeting or project planning – and increases productivity in the whole office.
Excel Live in Teams meetings: Presenters can share interactive Excel workbooks which participants can scroll, filter, and interact with, without taking control of the screen.
Power Automate workflows: Automate Excel updates in Teams, such as posting daily reports, inventory updates, or financial summaries to a channel.
Loop components (limited integration): While you can’t embed full live Excel tables in Teams chat, Loop tables allow collaborative data editing within a Teams message, though with limited formatting.
Data visualisation sharing: Charts, PivotTables, and conditional formatting work well when shared in Teams, improving data-driven discussions during meetings.
It also works with other Cloud-based tools, however not quite as efficiently.
OneDrive and SharePoint allow real-time co-authoring, so that teams can work on the same spreadsheet simultaneously. It also works very well with Microsoft Teams.
Google Workspace can automatically convert Excel files to Sheets and vice versa.
Project management tools like Asana allow data transfer into / from Excel using CSV files. Two-way synchronisation requires add-ins.
Excel and Google Sheets are similar, but have different strengths and weaknesses.
Excel is best for advanced data analysis, large datasets, and automation with VBA (Visual Basic for Applications). It is best for financial modelling and reporting, and far more widely used in corporate environments.
Google Sheets is cloud-based, making it great for real-time collaboration (although Excel is catching up fast) but lacks advanced features like Power Query and VBA.
Excel, Power BI and Tableau are all excellent tools but designed for different tasks.
Excel is a general use tool and best for data analysis, reporting, and financial modelling.
Power BI is a more specialist tool. It is best for creating interactive dashboards, real-time data visualisation, and large-scale data processing. It integrates well with databases.
Similarly, Tableau is designed for large-scale data processing, advanced data visualisation and storytelling. It also offers powerful drag-and-drop analytics.
Many businesses use Excel alongside Power BI or Tableau for a complete business intelligence workflow. Excel is great for data preparation, while Power BI and Tableau provide deeper insights, visualisation and automation.
Download full course details
