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

Get in touch



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

Advanced Power Pivot For Microsoft Excel Training Course

Microsoft Excel Macros & VBA Training 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.

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.AccBank

“The Excel VBA and Macros course was detailed and tailored to our needs and experience. It was very informative.”

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.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.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,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.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 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 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 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

Managed to mix humour with knowledge and expertise and kept us entertained while learning.

Excel Participant

Very structured and good use of time getting through the material.

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 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.

prev next