Excel Online Course

HomeExcel Online Course
support@exceltrainingandcourses.com
+44 (0)20 3290 2687 ( Mon – Fri 9.00 – 17.00 UK Time )

“We take a different approach with our online Excel Training…”


Excel Expert

Let me help you take your Excel Skills from Beginner to Advanced so you can make an impact at work

Attention: Analysts, Accountants, Controllers, Project Managers, Management Consultants, PMOs & Other High Value Professionals;

  • 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 worried yourself silly 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 for you and raise your Excel skills.

Who am I and why you should consider me as a teacher?


Sohail Anwar

Hi, my name is Sohail Anwar, born, lived and developed my career in London, England and before I tell you all about my Zero to Excel Expert course, let me tell you that Excel has been the most prominent skill that has allowed me to add value to the global organisations I’ve worked at and establish a strong reputation as consultant.


Excel Projects with companies

Without these Excel skills, there’s no question I’d be struggling in the marketplace, only given tasks and roles that frankly, anyone could do.

Fast forward to today and I focus my efforts exclusively helping professionals to improve their Excel Skills (Analysts, Accountants, Controllers, Project Management Professionals, PMO’s, Management Consultants… and many others working in the Financial services, Pharmaceuticals, Energy, Retail and Government Sectors) 

Using my years of experience and understanding the skills that work in the real world, I specifically and deliberately make it a point to discard what you don’t need to know and so I only focus on that 20-30% of Excel that you actually do need to know if you want to create a noticeable impact in your organisation.

“I’m Only Going to Teach You The Key Excel Components You Need to Know That’ll Make All The Difference In Turning You Into a More Efficient & Valuable Professional”

So what can you expect to learn in this Online Excel Training Course? 

For a period of six energetic and engaging weeks, you and I will go through a structured Excel training curriculum.

It’s an Excel curriculum I’ve assembled based on the hands on success I’ve personally had in my 10+ years in various senior roles for a number of blue chip companies. (What that means is my trainings and teachings aren’t simply a regurgitation of material you can find all over the Internet, they are very specific to real problems in real project scenarios)

The course is broken down into the following Modules (click on each to see the lesson topics)

Module 1: FROM COMPLETE BEGINNER TO INTERMEDIATE

This is a Prerequisite module and if you’re a complete beginner, this module will get you comfortable with Excel, and move you towards an Intermediate level of understanding.

#NameVideo Length (minutes)
1Navigating around Excel2.17
2Entering Information2.58
3Navigating without the Mouse2.53
4Basic Formatting4.19
5Dragging & Autofill4.14
6Copy & Paste4.52
7Clearing cells2.26
8Inserting & Deleting3.36
9Date Basics4.12
10Introduction to Formulas1.51
11Introduction to Formulas: Part 24.22
12Introduction to Formulas: Autosum2.25
13More on Worksheets6.36
14More Borders4.51
15Printing considerations6.31
16Conditional Formatting8.32
17Charts9.43
18Autofilter6.04
19Sorting Data2.16
20Introduction to Text Data3.57
21Named Ranges2.42
22Data Validation5.27
23Advanced Data Formatting5.25

Module 2: INTRO TO 80:20 EXCEL AND FINDING THE RIGHT INFORMATION

After the introductory material we delve in to Finding Information from data which is where the journey of being a great ‘Excel’ Professional really begins. In order to do value adding problem solving, you first need to have complete command over how you find data. I cover everything from Lookups to the advanced Array formulas. We will build on this in subsequent Modules.

#NameVideo Length (minutes)
1Applying the 80:20 principle to Excel9.14
2Introduction to Excel for professionals7.59
3Performance of Excel4.37
4Long boring lists7.12
5Long boring lists: Monthly Data11.39
6Locking down cells6.13
7Finding Information: VLOOKUP19.46
8Finding Information: INDEX & MATCH20.2

Module 3: ADVANCED LOOKUPS RULE BUILDING TO CREATE WORLD CLASS SOLUTIONS

We delve deeper in to looking up information and then seamlessly cover treating Information with rules to make it do what you want it to do. We will learn the best methods of building logic to manipulate your data for analysis. Apart from the powerful skills you will learn there will be some very powerful ideas taught around strategies to build your solutions. These are strategies that I have learned from solving problems in the ‘real world’.

#NameVideo Length (minutes)
1Finding Information: Limit formulas14.48
2Getting Advanced with Lookup formulas15.4
3Finding Information: putting it all together17.5
4Rule building with IF13.38
5More advanced logic building17.37

Module 4: DEALING WITH NON-NUMERICAL DATA

At this point your skills will be very advanced but for many professionals manipulating text information is crucial. We deal with codes, names and all manner of text data on a daily basis. Your skills need to be up to the challenge of being able to deal with such data. This module will teach you EVERYTHING you need to know in order to do that. The last lesson is an incredibly powerful one that combines lookup, logic and text to develop a resourcing model, something that I used in previous roles.

#NameVideo Length (minutes)
1Working with Text5.33
2Text Functions: PROPER, TRIM & CLEAN5.31
3Text Functions: LEN & SEARCH7.18
4Text Functions: LEFT, MID, RIGHT2.23
5Text functions: Advanced Text analysis by building formulas19.56
6Text functions: Creating email addresses to build distribution lists6.17
7Text functions: Creating character and word count limits6.43
8Advanced Text, Logic and Lookups: Creating a resourcing model29.06

Module 5: MASTERING THE ART OF SUMMARISING YOUR WORK

Summarisation is the ‘end game’ for much of the work you will do as a professional, all eyes will be here. So I spend a significant amount of time on this topic! Where I bring together everything we have learned and build on it even further. At the end of this module, we delve even further in to advanced topic of Array Formulas and I break down how to approach tricky situations when summarising so they become simple to implement.

#NameVideo Length (minutes)
1Introduction to summarising2.32
2Counting13.52
3Summing14.01
4SUBTOTAL function4.48
5Analysis walkthrough with summing and counting5.58
6Everything you need to know about Pivot Tables in under 15 minutes14.48
7Advanced list analysis: understanding Array formulas11.58
8Advanced Modelling with Array formula lookups10
9Dashboard and reporting practice for professionals12.52
10Advanced Conditional formatting: Using formulas21.12
11Advanced Conditional formatting: Beyond Highlighting11.27

Week 6: DEEPER INTO BUILDING WORLD CLASS REPORTS AND SOLUTIONS

In the final Week, I walk you through some powerful Excel solutions I have built in the various projects and Banks I have worked in during my career. The ideas are universal for many roles and all sectors. I highly encourage you to learn, steal and call your own! Take the credit. You have my permission. Frankly this week is the worth the price of the course many times over

#NameVideo Length (minutes)
1Resource Analysis: Good practice for managing data15.25
2Dynamic Charts15.36
3Charting Actual vs Forecast7.33
4Segmenting for deeper MI6.41
5Meaningful Resource Analysis8.55

Just some of the companies where my students have worked…


Companies Logo

What is included in the course?

  • 60 Video Lessons Delivered Online in 6 Modules (Play, Pause & Rewind)
  • Download all lessons and keep for life
  • Downloadable Workbooks to guide you in every lesson
  • Support from myself and our dedicated Course Manager Sheila
  • Access to my Private Facebook group where you can interact with students
  • 30 Day Money Back Guarantee

What happens when you sign up?

The video below explains exactly what happens when you sign up and start training

Each week for a period of six weeks, you’ll receive a special email from me containing a Video lesson of the week. They Video lessons are pre-recorded so you don’t have worry about attending a ‘live’ session.

“Can I claim the cost of the training back?”

If you want to claim the cost of the course back from your employer, I can give you a certification. Now if that’s the route you want to take, please get agreement from your employer to say they’ll sponsor your training before you invest in my Excel Training Course.

“What kind of Support will I get?”

I’m glad you asked! This is where the course shines! Our primary way to respond to your learning questions are within the lesson comments and by email. I answer many questions myself but we support you in 3 ways:

Course Manager

Allow me to introduce Sheila!


Sheila

Not only is Sheila an Excel genius but she is a very experienced Project Manager having worked in big organisations, so her responses and advice is also in the context of making you a better professional.

Questions Answered in Video Format

Now, it’s not just Sheila, but I also spend a lot of time answering student questions and sometimes I answer them in the form of Videos!

Facebook Community

If that was’t enough, you are invited to join our closed Facebook community where you will find other professionals in the same boat as you. I show up frequently to answer questions and motivate you.


Join Facebook Community

Real World Guidance

As I mentioned already, it’s my guidance and mentorship that sets this course apart and with that I give very practical and real world advice that is not generic. The goal is always to make you a better professional and I have the background, knowledge, career trajectory to best guide you. Here’s an example of me getting a student to focus on skill learning without getting bogged down by unproductive perfection.


Excel Course

Investing in my ZERO TO EXCEL EXPERT Training is only £119

100% SECURE CHECKOUT

How do you know this is the right Course for you?

If you’re unsure as to whether Zero To Excel Expert training course is for you, the following will let you know, especially if you find yourself nodding and agreeing to more than just one thing mentioned:

You feel a bit uncomfortable creating reports for top management and senior executives

Deep down you feel a bit ignorant about Excel and what it can help you do

You sometimes feel a bit like a fraud because you’re a qualified professional but yet, you don’t have good or even basic Excel skills in place

You feel like you spend far too much time on things like analysis, month end reports and reconciliations than you should.

You can’t help but think how much better your future, how much more you would achieve in your career, if only you had better Excel skills.

You feel you’re too old to learn these essential Excel skills, though believe that if you had the right teacher or trainer, you’d get the confidence you need to push through and learn what you need to learn.

You’re currently on probation at work and know if you get some solid Excel skills in order to improve the way you work in your team in terms of reporting and other finance processes, you’ll be as good as guaranteed the job.

You’ve been jumping from You Tube to Google, to this course over here and that course over there, yet… you’re more disjointed and confused than ever in knowing what the core Excel components are that you need to master so you can be more proficient in your job.

You’ve been out of the workplace and want to equip yourself with a set of solid Excel skills to make you more marketable and in demand when you return.


You want to increase your skills database because you feel there’ll be a structural shake-up in your organisation where they’ll be letting go those people they see who aren’t valuable contributors to the organisation as others may be.

You feel your current Excel knowledge isn’t as helpful or useful as you thought it would be so you’re now looking for a practical upgrade.

One of your colleagues has great Excel skills and you feel left behind, worried that you’re just not as productive

You’ve got that consistent nagging voice gnawing away at you inside that says that you’ve been stuck in the same role for far too long and so finally you’re now looking for that boost in confidence that comes with acquiring a new set of Excel skills so you can apply for newer fresher roles with a bigger salary.

Maybe after reading the above you’re now taking a new serious look at your future and your job prospects… so much so that you’re now ready to invest and not waste a single moment more of your precious time.

100% SECURE CHECKOUT

Tracy Wainman

Really enjoying your teaching style, quick and to-the-point! WHO has time for all the fluff? Thank you!” *

Wow, blown away! This has been structurally put together. I was carried along from the onset. There has been NO regrets so far. This is turning out to be the BEST training I have come across. If this is only week 0, one can only imagine what lies ahead.” *
Olumide Olu-Agunbiade

Thank you, this has been great so far. The last few videos were INVALUABLE. I’m very pleased and eagerly looking forward to the next session! ” *
Andre Goodman

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

Hear how my course helped my student, Kiran, gain a promotion!

Your Iron Clad, 100% No Risk Money Back Guarantee


100% Guarantee

I do however know that if you don’t love the Zero to Excel Expert Training programme… if you don’t find that you’ve gained more practical knowledge and insights in the first few video lessons than what you’ve learned before, and, in turn, it doesn’t have you excited, motivated and energised… so much so that you want to practice what you’ve learned… over and over again… then… you’re absolutely entitled to ask for your money back, all 100% of it.

You see, I’ve put so much energy and effort into the Zero to Excel Expert course that I only want you to invest in it if you’re really committed to change your current scenario.

First of all just to let you know that you are a genius!! Thanks for teaching me all this stuff and sharing all your years of professional experience. I´m really learning!” *

Laura, Financial Controller

Some words from one of my students, Project Management Professional, Paul Inyang, Nigeria:

I have to thank you so much again for all you’ve done for me. Just to let you know, I’m currently reviewing the entire course – it’s my goal as I want to create a fresh resume so I can get another job!” *


Paul Inyang

A video testimonial from my student, Vasileios Plessas who recently received a job offer after purchasing one of my courses


Abraham Dare

I want to take the time to appreciate you for your good work in providing these lessons. In my honest opinion this is pretty much the BEST and most concise tutorial on Excel that I have ever come across.” *

100% SECURE CHECKOUT

* Please note, your results may vary from the testimonials listed here, this course is not a magic bullet, 3 to 5 hours a week of week is the minimum commitment required from you to make progress

If you’re still undecided whether to invest in the Zero to Excel Expert Training, here are some answers to a number of questions that may be on your mind

I don’t think I’m ready for this course just now, there’s too much going on in my life.

Either you want to learn the Zero To Excel Expert skills, something that’ll make a significant and measurable difference in your life, or you don’t. Either you want to attain a level of competence and professionalism, or you don’t. If you do, you’ll not continually come up with excuses for yourself that you believe to be true. I can’t help you to be ready for the course. I can only teach and train you in how to become a super proficient Excel professional who’ll make a measurable difference in the organisation you work for, once you create the important time for this life-altering course.

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. The course has been specifically created so you will receive one video module each week. 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. If you find that you’re not able to dedicate enough time each week to complete the video lesson for that particular week, that’s perfectly okay. Please don’t be hard on yourself or think you have to rush everything in order to complete the session in time. Because everything is pre-recorded, you can attend to the next lesson, when you are ready. I could have easily give you all six weeks lessons in one go and have you go through it all yourself. By having the lessons spaced out on a weekly basis, you won’t feel overwhelmed with the lessons climbing on top of you. And if they do, all you have to do is get your calendar or diary out and schedule in the time periods YOU want to go through the lessons. That’s how you systematise your learning. That’s how you get good at getting good. It’s that easy.

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 Zero 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?

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. 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 find myself needing constant motivation and inspiration in order to help keep me on track; will your Excel training course do that for me?

I’m not a Professional motivational speaker. Yet many have told me they’ve been motivated and inspired by my information and materials. And that’s because of the way I teach and train. I can’t promise you that you’ll be inspired and motivated by my course – what I will promise you however is I can help you become an exceedingly proficient Excel exponent, within a 6-week period, even if you’re brand new to Excel. And look, if I can’t do that for you, you’ve lost nothing because you’re backed by my industry standard, 60-day, 100%, money back guarantee.

I’m in a senior position in the organisation I currently work for and I’m very aware I don’t possess the necessary Excel skills that many of my colleagues do. I’d rather you not publish my name or position on your website for your marketing purposes.

You’re not alone. I’ve dozens of people who’ve said the same things to me about keeping their details private, and that’s what I’ve done for them. And I know what it’s like to struggle with Excel because I’m constantly interacting with senior staff members and they’re all at sea when it comes to Excel. They look at me and what I can do with Excel, and they think I’m some kind of wizard. In their eyes, yes I am. The reality is I’ve learned a number of core Excel strategies and techniques and I can teach them to anyone who is open to learning about them.

I’m not sure how to let my current employers know about my newly minted 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.

I already have a basic understanding of Excel, though am worried that if I invest in your course I’ll have conflicting advice and may end up confused.

Whatever the level of your existing Excel knowledge, you can obviously use it all when the need arises. What I suggest you do is you complete the Zero to Excel Expert training and then see if there is any conflicting advice or information that shows us, which I don’t think you will find. I say that because what you’ll most likely find is you’ll now have differing, alternative, better and faster ways of solving your project’s problems. My intention with the course is to give you the most important Excel functions and strategies that’ll make the biggest difference, cause the biggest impact and have you complete your tasks more efficiently and accurately than ever before…and that too, to accomplish it all with little headache, worry or frustration. In fact, through my course, I aim to help you eliminate, eradicate and dispose of all together, any kind of professional tension you feel around Excel.

100% SECURE CHECKOUT

If you’re still not ready to commit to our training course but would like to know more about how Excel can impact your career then sign up for my report ’10 Excel Strategies That Helped My Career