Beginner To Advanced Excel Course
Find out how our students are gaining an unfair advantage at work with our Online Excel Expert Course
- Have you struggled to build effective reports and dashboards?
- Or agonised over what you need to know about pivot tables?
- Perhaps, you’ve gone crazy trying to figure out how exactly to analyse your data to any kind of meaningful depth?
- Maybe, you’ve thrown your hands up in the air with an air of resignation because of not really knowing what the VLOOKUP is and when you should use it?
Or if you've felt held back over a number of other Excel tasks you’ve thought are way beyond you, then please read on as I have developed an Excel course that will simplify all these things and have you producing work in Excel that will get you noticed by your line manager, colleagues and the executives in your company.
This is the only Excel course on the market purpose built to transform the Excel skills of corporate professionals or aspiring professionals including analysts, accountants, controllers, pmo’s, project managers, management consultants and other corporate professionals.
If that includes you then read on to find out how this course will transform your Excel skills.
Introducing Beginner To Advanced Excel Training
Access to our very best training and support, spanning over 9 hours of focused video lessons, articles and practice files on Excel.
What do you get in this Excel Training?
- 68 Video Lessons (with subtitles)in Excel 2016 (can use with Excel 2007 onwards)
- Download videos to your device and watch offline
- Excel files with exercises that help you to learn the lessons with ease
- 12 months of support from Excel experts with a corporate background
- 30 minutes skype contact with a highly experienced professional as a mentor
- Track your progress and take your own notes
- 30-day money back guarantee
- Get a certificate of completion that you can display on LinkedIn
Course Details
(Click arrows to the right for course details)
-
1
-
Module 1 Introduction
-
Module 1 Practice Workbook
-
1. The 80:20 principle
-
2. Introduction to Excel for Professionals
-
3. Performance of Excel
-
4. Long Boring Lists
-
5. Long Boring Lists: Monthly Data
-
Small, Mid and Large Data Sets
-
6. Locking Down Cells
-
7. Finding Information: VLOOKUP
-
8. Finding Information: INDEX & MATCH
-
OPTIONAL: Excel Tables & Slicers
-
-
2
-
Module 2 Introduction
-
Module 2 Practice Workbook
-
1. Finding Information: Limit Formulas
-
2. Getting Advanced with Lookup formulas
-
3. Finding Information: putting it all together
-
4. Rule building with IF
-
5. Advanced Logic Building
-
-
3
-
Module 3 Introduction
-
Module 3 Practice Workbook
-
1. Working with Text
-
2. Text Functions: PROPER, TRIM & CLEAN
-
3. Text Functions: LEN & SEARCH
-
4. Text Functions: LEFT, MID, RIGHT
-
Flash Fill
-
5. Text functions: Advanced Text analysis by building formulas
-
6. Text functions: Creating email addresses with SUBSTITUTE and ‘&’
-
7. Text functions: Creating character and word count limits
-
8. Advanced Text, Logic and Lookups: Creating a resourcing model
-
-
4
-
Module 4 Introduction
-
Module 4 Practice Workbook
-
1. Introduction to Summarising
-
2. Counting
-
3. Summing
-
3a. Summing – Circular References explanation
-
4. SUBTOTAL function
-
5. Analysis walkthrough with Summing and Counting
-
6. What are Pivot tables and why they are overrated
-
7. Advanced List Analysis: Understanding Array Formulas
-
OPTIONAL: Introduction to Array Formulas
-
OPTIONAL: Array Formulas for Multiple Criteria
-
Mastering Multiple Occurrences
-
OPTIONAL: Array Formulas for Multiple Occurrences
-
7a. Array formulas rows vs Index range
-
8. Advanced Modelling with Array Formula Lookups
-
9. Dashboard and Reporting Practice for Professionals
-
10. Advanced Conditional Formatting: Using Formulas
-
11. Advanced Conditional Formatting: Beyond Highlighting
-
-
5
-
Module 5 Introduction
-
Module 5 Practice Workbook
-
1. Resource Analysis: Good practice for managing data
-
2. Dynamic Charts
-
3. Charting Actual vs Forecast
-
4. Segmenting for deeper MI
-
5. Meaningful Resource Analysis
-
Outro: Goodbye and Next Steps
-
How you will get an unrivalled Excel Training Experience
Our goal is simple, we want to transform your Excel skills. So far, we have done this for over 1000 professionals in two ways:
1. You will learn our proprietary 4:3 Excel framework
We don't teach you Excel the way other courses do.
Our course has been created by professionals who have spent decades solving hundreds of Excel related problems in dozens of global companies
From solving hundreds of Excel problems, we have seen that every business scenario needing Excel can be boiled down to three types problems and there are four possible ways to solve them aka the 4:3 Excel framework.
The three types of Excel problems are
Storing or tracking data: Such as financial data like journal entries, accounting data like accruals, project data such as milestones or status updates, employee data, timesheets, holiday tracking, etc
Data Analysis: whether ad-hoc analysis or building models for ongoing analysis. Think profit and loss analysis, project timeline analysis, variance analysis, resource forecasting, staff rotas, etc
Providing data insights: Building tables, reports and dashboards is the biggest opportunity you must make your mark with various audiences and there is no room for error.
There are four approaches that will solve these problems
Finding specific information: We want to extract and pinpoint the exact information we need from lists of data. We will use basic and sophisticated Lookup techniques to do so.
Using logic to manipulate information: The foundation of analysis is the ability to put rules around data and make sure it does what we need it to do
Manipulate text data: With so much data at work being text based such as product codes, employee data, project information, the importance of handling text data cannot be stated enough
Effective data summary: Many people think summary simply means charts and tables, it’s so much more than that. This is where we learn when to use the right technique at the right time to produce effective outputs
It’s within this framework that we will teach you the best way to use formulas, charts, conditional formatting, pivot tables, shortcuts and other functions.
No longer will you be scrambling for random tips, ninja tricks and shortcuts. You can say goodbye to googling for answers to Excel questions after everyone else has gone home because your report is due in the morning.
This framework is a strategic Excel system that will guide you in your work and will have you producing outstanding quality analysis and reporting in a quick time frame.
2. You will get unrivalled levels of support for 12 months
Where most courses let you down is precisely where we shine.
Our support is truly world class because all of our support staff have all previously worked in global companies, they are not trainers by profession so the guidance and advice is the most highly qualified professional advice.
This is very important because Excel can be quite daunting and poor teaching and advice can make things worse.
Discussions, emails and video responses to your Excel Course questions
We support you with written and video responses. Yes. If we feel a written response doesn't do you justice, we will create a video just for you!
But regardless of the format you can be rest assured knowing that the advice will not be fluffy or vague, it will always be in the context of solving business problems with Excel. So not only will your Excel skills improve but you will become a more effective professional in the process.
Skype guidance
Beyond what we teach, if you want hands on guidance on Excel related work problems like a challenging report, troublesome analysis or anything else then we offer all our students 30 minutes of Skype time within the course. This can be used anytime within 12 months of registering.
Who is behind this Excel Training course?
|
Our Excel Course instructor, Sohail Anwar, is a Londoner who has spent over 12 years working on major projects in global investment banks going from junior to senior roles in the process. Strong Excel skills played a huge role in helping Sohail get promoted along the way. |
Our Excel Course Manager Sheila McLean, originally from Glasgow, Scotland has spent over 15 years working on major projects in global companies in Banking, Energy and Retail. As a PMO she has extensive experience of using Excel for project management. |
What does the course look like from the inside?
As soon as you sign up you will get access to our e-learning platform containing all the lessons, files and support areas.
Some of the companies our students have worked at
Here’s what some of our students have to say about our Excel Training course
Here are some of the success stories our students share with us
“The course is excellent. The skills I have developed during the 6 weeks have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.” A. Saleem, PMO Manager, London
“If you saw the type of excel work being produced in my workplace you would be floored - or I'm sure you have seen through your career. I'm one of those that knew the underlying power of excel but had thought the time and energy to fully learn was lost at this point in my career (I'm not so early in my career), and I could just get by as a lot of PMs are doing/have been doing with various excel hacks and weird work flow tricks (as I believe you mentioned, many consider it just a "spreadsheet"). You would laugh at a recent pivot table work-flow that was handed to me for a simple excel task - I changed that immediately after your training.” – Brian, Project Manager, USA
“Sohail’s courses have provided me with the guidance and traction to hugely grow my earnings – in fact trebled my income over the past few weeks upon completion. This was due to the fact there’s a formula that for me clarified core missing pieces. Most importantly, Sohail’s courses helped me revise and reassess how I presented myself to my intended audience (the selling course), and gave me the tools I needed to make the difference (the excel course). For me this has been a real game changer and a catalyst. Don’t hesitate to do both parts of the course”. – James Barton-Ginger, Project Manager, New Zealand
"I applied many of the skills I learned through your excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!" – Kiran, Financial Analyst, Canada
Here is a video of Kiran talking about her progress with the training:
FAQ
-
How much time do I need to dedicate to this course?
The more the better, if you can do 30 minutes a day, your imrpvements will be very noticable very quickly. However the lessons range form 1 minute to 30 minutes in length so you can just tackle one a day if it fits in your schedule.
-
How long for my skills to get better?
You will begin to improve immediately. The course is designed to make you take action with our real world examples and recommendations of what to apply in your own work
-
Can I claim the cost of the training back?
Absolutely. However please agree this with your employer before signing up and we can either take a payment form your corporate credit card or issue you an invoice to claim back the cost form your employer.
-
I don’t have a clue about Excel and fear I might be in over my head if I take the course.
You don’t have to know anything about Excel to enrol in the course. My job is to take you by the hand and walk you through what you need to know. And, at the same time, have it be a professional, pleasurable and fun experience for you. But please don’t take the course if you have no use for it, if there’s no purpose for you to use what you learn. It’s then you’ll feel you in over your head because you have no end goal for learning the material. You’ll only be wasting your own precious time. I’ve found some students have expressed the same concerns about not knowing a thing about Excel, yet most have found that they were painting a big Excel monster picture in their minds about it all and when they started right at the beginning and had a clear mind about the road ahead, everything made clear sense to them.
-
I’m concerned I might fall behind with the course materials and so it would be a waste of my money to continue with the course.
You can never fall behind if you follow the course materials. All video lessons have already been recorded for you so you don’t have to worry and panic that you have to attend a live session at a particular time each week.. Often our students go cold for months only to return when they get a chance and when they are back we are waiting to support them.
-
I just freeze whenever I hear the words datasets, vlookup, pivot tables, dashboards, can your course help me eradicate this way of thinking?
If you mean can my beginner to advanced to Excel Expert Training help you to not freeze up when you think of or hear the words datasets, VLOOKUP, pivot tables, dashboards… well… only you can be the judge of that by testing the course out. But I think you first need to ask yourself why it is you want to be learning about it all in the first place - because if you’re so anti or fearful of learning this material, it suggests to me that it’s something that you simply don’t want to do. Why do something you’re dead against doing?
-
Why should I pay for an Excel Training course that I can get cheaper elsewhere?
A £10 course will get you £10 results. If you base your purchase solely on price, then you can skip the idea of paying anything at all because you can go straight to Google or YouTube and get all the free Excel videos and instruction materials you want. BUT be warned 'Free' will always cost you more greatly in the long term. First of all we invest heavily in supporting you so you can transform, secondly what Google or YouTube don't give you is a good curriculum in a structured way. Where does my curriculum come from? Well, that is the best part of the course. The fact that I am teaching you! I have spent over a decade in the biggest and best global organisations. I learned Excel on world class multi-million-pound projects. Not in my mother's basement like many so-called experts. So my curriculum is all about what works in the real world. That's why my students don't just get Excel Skills, but they also get promotions and Salary Increases.
-
I’m not sure how to let my current employers know about my newly improved Excel Skills, what do you suggest is the best way to do that?
The best way isn’t to tell them. The best way is to demonstrate what you know. And you do that by taking on a project where your new skills will come into play. If in the past you’ve struggled with analysing large amounts of data, have been intimidated by advanced things like using Pivot tables or using formulas like VLOOKUP, if you’ve not at all felt comfortable building reports, dashboards and carrying out the necessary analysis... if all that has been a throbbing professional migraine for you in the past, take on and complete a project by incorporating those Excel elements and pretty soon you’ll have your employers, your boss, other colleagues you work with, wide eyed and incredulous. And that’ll be your stepping stone to the good times ahead for you.