If you’ve agonised over what exactly you need to know about pivot tables… if you’ve struggled to build effective reports and dashboards… if you’ve gone crazy trying to figure out how exactly to analyse your data to any kind of meaningful depth… if 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.
Hi, my name is Sohail Anwar, born, lived and worked in London, England and before I tell you all about my Zero to Excel Expert course, let me tell you that learning Excel has been the number one tool that’s helped me personally go from earning £27k in my first analyst job in a small government company, to now where I earn £100K+ working in big Investment Banks in the City.
Let me repeat, 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 there are thousands, tens of thousands of professionals (Analysts, Accountants, Controllers, Project Management Professionals, PMO’s, Management Consultants… and many others working in the Financial services, Pharmaceuticals, Energy, Retail and Government Sectors) living all over the world who use my Excel based materials, who have invested in my trainings, who have downloaded my publications, who have subscribed to my newsletters.
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”
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.)
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.
|#||Name||Video Length (minutes)|
|1||Navigating around Excel||2.17|
|3||Navigating without the Mouse||2.53|
|5||Dragging & Autofill||4.14|
|6||Copy & Paste||4.52|
|8||Inserting & Deleting||3.36|
|10||Introduction to Formulas||1.51|
|11||Introduction to Formulas: Part 2||4.22|
|12||Introduction to Formulas: Autosum||2.25|
|13||More on Worksheets||6.36|
|20||Introduction to Text Data||3.57|
|23||Advanced Data Formatting||5.25|
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.
|#||Name||Video Length (minutes)|
|1||Applying the 80:20 principle to Excel||9.14|
|2||Introduction to Excel for professionals||7.59|
|3||Performance of Excel||4.37|
|4||Long boring lists||7.12|
|5||Long boring lists: Monthly Data||11.39|
|6||Locking down cells||6.13|
|7||Finding Information: VLOOKUP||19.46|
|8||Finding Information: INDEX & MATCH||20.2|
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’.
|#||Name||Video Length (minutes)|
|1||Finding Information: Limit formulas||14.48|
|2||Getting Advanced with Lookup formulas||15.4|
|3||Finding Information: putting it all together||17.5|
|4||Rule building with IF||13.38|
|5||More advanced logic building||17.37|
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.
|#||Name||Video Length (minutes)|
|1||Working with Text||5.33|
|2||Text Functions: PROPER, TRIM & CLEAN||5.31|
|3||Text Functions: LEN & SEARCH||7.18|
|4||Text Functions: LEFT, MID, RIGHT||2.23|
|5||Text functions: Advanced Text analysis by building formulas||19.56|
|6||Text functions: Creating email addresses to build distribution lists||6.17|
|7||Text functions: Creating character and word count limits||6.43|
|8||Advanced Text, Logic and Lookups: Creating a resourcing model||29.06|
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.
|#||Name||Video Length (minutes)|
|1||Introduction to summarising||2.32|
|5||Analysis walkthrough with summing and counting||5.58|
|6||Everything you need to know about Pivot Tables in under 15 minutes||14.48|
|7||Advanced list analysis: understanding Array formulas||11.58|
|8||Advanced Modelling with Array formula lookups||10|
|9||Dashboard and reporting practice for professionals||12.52|
|10||Advanced Conditional formatting: Using formulas||21.12|
|11||Advanced Conditional formatting: Beyond Highlighting||11.27|
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
|#||Name||Video Length (minutes)|
|1||Resource Analysis: Good practice for managing data||15.25|
|3||Charting Actual vs Forecast||7.33|
|4||Segmenting for deeper MI||6.41|
|5||Meaningful Resource Analysis||8.55|
Just some of the companies where my students have worked...
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.
Also 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 the Zero to Excel Expert Training Course. Of course, if they choose not to sponsor you, that should give you all the incentive and motivation to pay for the course yourself and for you to quickly use your newly acquired Excel skills to get yourself a better, higher paid position.
I'm glad you asked! This is where the course shines!
Allow me to introduce Sheila!
Sheila is our course manager, she will look after every aspect of your training: from making sure that you are looked after during registration to answering your technical Excel questions.
Not only is Sheila an Excel genius but she is a very experienced Project Manager having worked in big organisations, so her advice is also in the context of making you a better professional.
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!
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.
You simply sign up for a mere £1 and after 7 days you will be automatically billed for the remaining £118. If you don't feel ready to continue then simply email us before the end of day 7 and we'll cancel immediately without charging you, no questions asked.
If you’re unsure as to whether this Beginner to Beyond Excel 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.
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.
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!
I applied many of the skills i learn 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!
Hear how my course helped my student, Kiran Arain, gain a promotion!
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!!
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!
A video testimonial from my student, Vasileios Plessas who recently received a job offer after purchasing one of my courses
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.
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.
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.
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.
If you mean can my Beginner to Beyond Excel 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?
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’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.
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.
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.
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.