Learn Microsoft Excel

Do everything in half the time and get results for your business. Master Spreadsheets, Formulas, VLOOKUPS, Charts, Pivot Tables,  Macros, Data Analysis.

Training for your whole team

 Can you afford to wrestle with spreadsheets and struggle to produce reports any longer? You want to be sure that your numbers are available now, reliable and up to date.

From Beginner to Experienced

Are you the kind of person who says: “I hate Excel”? Or the office Excel expert that everybody goes to? If you came to this page, chances are that you know that there are better ways to use Excel. 

  Spreadsheets   Tables  Sparklines  Formulas and Functions (vlookup, if, sumif…)  Charts  PivotTables  Macros VBA Add-ons 
Data Analysis  What-if analysis PowerPivots 
Data Modelling Conditional Formatting Scenario Manager 
Dashboards

All inclusive

  • Onsite FREE
  • Customised FREE
  • Supporting material FREE 
  • Online pre-course assessment FREE
  • Certificate of attendance FREE

Tell us about your project

Formulas

BUDGET

CHARTS

Forecast

Calculate

Automate

Excel Introduction

A solid foundation for every day spreadsheet use.

  • Basic workbook tasks
  • Entering & manipulating data
  • Preforming calculations
  • Worksheet formatting
  • The creation of charts
  • The printing of workbooks
Excel Intermediate

For the regular user who wants more out of Excel

  • Spreadsheet Design and Management
  • Formulae and Functions
  • VLOOKUPS
  • PivotTable Analysis
Excel Advanced

Become and Excel expert.

  • Data modelling techniques
  • What-if Analysis
  • Advanced PivotTables
  • Charting
Excel Macros and VBA

Automate repetitive tasks in Excel. Build your own macros and write simple Visual Basic code. 

  • Record and edit macros
  • Understand the Object Model
  • Write Visual Basic routines
  • Reuse & adapt existing code
PowerPivots for Microsoft Excel

Use Excel for Business Intelligence and Data Analysis

  • Import & query data with Power Pivot workbooks
  • Generate PivotTable and PivotChart reports
  • Create relationships between Power Pivot tables

Master spreadsheets and get ahead

Our Microsoft Excel courses are designed to take you to the next level because good Excel skills drive good business-making decisions and great Excel skills get you there quicker. Excel professionals are highly valued in the workplace. Whatever you do in the office, Excel is the most transferable skill for you and your team.

✔ Organize data in an easy-to-navigate way
✔ Use the power of formulas and functions to speed up analysis
✔ Turn piles of data into helpful charts and graphs
✔ Make forecasting predictions
✔ Automate common tasks
✔ Banish errors and common spreadsheet errors
✔ Get to the next level

Finally confident with Excel

Tell us what you need to know and we will tailor a course that’s perfect for your current skill level and what you want to achieve.

 Do more in less time

Did you, like most people, have to learn Excel on  the job? Discover Excel features and best practices that make your life easier and get your work done in half the time.

 

Choose or customise your Excel course

Customised

We tailor our courses to each participant’s current skill level and define their objectives for the training

Onsite

Do you have a group you want to train at your premises? We come to you so you

Hands-on

We include plenty of hands-on projects and exercises so you can apply your new skills straight away. You can even bring and try new techniques on your own files.
t

Support

Learning doesn’t stop at the end of the class. If you’re ever stuck with a formula, a PivotTable or any other Excel problem, once you’ve completed our course, you have access to our free support service.
Graham O.
Graham O.AccBank
“The Excel VBA and Macros course was detailed and tailored to our needs and experience. It was very informative.”
David S.
David S.Deloitte
[two_third_last]“It was well presented and was very beneficial. The detailed examples were very good as a guide to using the material.”“It was well presented and was very beneficial. The detailed examples were very good as a guide to using the material.”
Treasa H.
Treasa H.DPD
“That it was done in house so it was a lot easier to keep up with work I had that day as well as completing the course. Also that the example used was from a report that we use in customers services so this made the training very relevant.”
Michael McM.
Michael McM.Deloitte
“Very personable instructor with good knowledge of his subject. Made an effort to tailor the content ofthe course to the audience which was good.”
Heidi H,
Heidi H,Idea Online
“(…) the training was tailored and that we used my own data (…) made it more relevant and applicable.(…) I didn’t imagine that a day of excel training could be enjoyable!”
Aaron S.
Aaron S.Deloitte
“Very impressive range of material covered in such a short space of time. Covered time-saving anduseful areas that were very applicable in real life work examples. I was very impressed.”
Anthony Carroll
Anthony CarrollAstraZeneca Pfizer Healthcare
François Auerbach was extremely helpful. He is incredibly knowledgeable on all matters IT, and turned my project into a masterpiece. I heartily recommend François and would be only too happy to seek his IT expertise in the future.
Calum Maclean
Calum MacleanElectricity Supply Board
Francois Auerbach is a conscientious and very IT-savvy person who quickly mastered the details of a complex SAP rollout whilst establishing a solid reputation for being able to get all IT-related things done and also a good rapport with his colleagues. 
John Purcell
John PurcellIrish Distillers Pernod Ricard
Francois was our consultant and the creator of our first customised elearning module. He delivered a very good product to a tight deadline, I am very happy to recommend him and his work. Francois Auerbach has delivered standard and customised IT training for us (…) always to a very high standard. Top qualities: Personable, On Time, High Integrity
Excel Participant
Excel Participant
Managed to mix humour with knowledge and expertise and kept us entertained while learning.
Excel Participant
Excel Participant
Very structured and good use of time getting through the material.
Peter Brady
Peter BradyEircom PhoneWatch
I have attended a number of courses where Francois Auerbach was the lead trainer. I have always found him to have great expertise in his subject areas and a very engaging presentation style. I would have no hesitation in recommending him to potential customers. Top qualities: Personable, Expert, Creative.
Robert Burgers
Robert BurgersESB International
Francois Auerbach is a very knowledgeable, helpful and friendly teacher. If you have the courage to admit your way of formatting a report ‘might not necessarily be the best’, he’ll improve your skills. Well recommended! Top qualities: Personable, Expert, Good Value
Instructor very knowledgeable and very patient. Went over items until he was sure I could use them.
Course was very informative, I felt I was learning at the correct pace.
Excellent delivery of training by a very knowledgeable tutor.
Covered much more than I had expected. Gave me a full knowledge of the capabilities of the application.

Tell us about your project