We will hold your hand and teach you to use Excel & Pivot Tables to carry out analysis and reporting with ease, then we will show you how to regain 50% of your time spent in Excel with VBA and Macros skills… Almost Overnight
If you work as an Analyst, Accountant, Controller, Project Manager, Management Consultant, PMOor other Corporate Professional then you are spending at least 40% of your work time in Excel Our training will teach you everything you need to effectively do your key analysis and reporting work within Excel and then automate it with VBA & Power Query to win lots of your time back
• Master Key Excel Features: Conditional Formatting, Filtering, Validation& many more
• Build powerful models such as resource models for budgeting, Actuals/Forecasts etc
• Beginner to Advanced Excel formulas: IF, VLOOKUP, INDEX/MATCH, Array Formulas etc
• Seamlessly summarise your data with Pivot Tables
• Introduction to Power Query & PowerPivot
• Learn VBA, automate your work and save hours of time on reporting and analysis
• Learn to connect Excel to PowerPoint & Word for advanced automation
• Access to Powerful Tools & Templates for Reporting, Finance & Project Management
Advanced Excel, Pivot Tables, Excel Dashboards, VBA, Macros, Power Query, PowerPivot, SQL Server, Business Intelligence, Power BI, Career Progression
Start instantly and learn at your own schedule
This training is appropriate for anyone who is getting started to more experienced users of Excel, VBA, Power Query, PowerPivot, Power BI, SQL Server etc.
Suggested 3-5 hours/week
*Download to any device
You will get 12 months ofunrivalled levels of support and guidance throughout this Training: Lesson discussions, Email responses and tailor made video responses where needed.
You can request Certificates for particular courses on completion and share them in the Certifications section of your Linkedin profile
There is no other Excel course like this on this out there. You will learn directly from a professional who has used Excel to further his career from junior to senior levels. This is not a study of everything that Excel has to offer, in fact you will learn how most of Excel’s functions are distracting and with the instructors experience you will learn only the best Excel formulas, functions and tools you need to carry out great work.
For some people that work with Excel, Pivot Tables present a great opportunity to seamlessly deal with Data analysis and reporting. The training has been created by our founder in conjunction with highly experienced corporate analysts who use Pivot Tables on a daily basis in a corporate environment and at just over two hours you will be using this training immediately.
You will rapidly learn the skill of VBA before delving into the power of Automation which will save significant amounts of time from your analysis and reporting work. You will even learn to automate from Excel to PowerPoint & Word. Finally, you will get access to some of the best reports, tools & templates built by the course creator throughout his career working in big global companies.
Sample Lesson on the topic of Conditional Formatting
Fix data in Power Query then make a Pivot Table
Here is a sample introductory VBA lesson to get started
Here’s what some of our students have to say about our Excel Training course
“I applied many of the skills I learnt 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!”
“This course is excellent. The Skills I have developed 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.”
“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 Save clarified core missing pieces. For me this has been a real game changer and a catalyst.”
“I can honestly say that your Excel course was the best investment I have made in my career. From learning a few advanced techniques and applying them where needed I have added a great weapon to my arsenal with regards to getting new contracts. In the 2 years since I purchased your course my income has increased 92% and with more experience it is only going to jump up even higher! Thanks for the help and support and I wish you well!”
“Even in the preliminary module, I still found little tips that I didn’t know about – I knew this was the right course for me, and settled in for the ride.100% recommended – as your promotional material says, this is a no-brainer for every PMO (but don’t tell too many people, or I’ll lose my advantage!!)”
“Courses like this should be required by all as most people have no excel or Microsoft based training. This course is at a level that provokes or inspires. You can take something you have learned and apply to real life accounting or business scenarios based on the fact that your examples are real life and not 3 sales people selling apples and oranges (Such as the use of text functions, the & formula for a unique reference – invaluable in my new business)”
Watch Kiran talk about how the course helped her land her promotion as a Senior Financial Analyst
Watch Vas going into detail on how this course helped him land a role as a Supply Chain Analyst for a major corporation
Watch Marcel Thompson talk about how our course improved his Excel skills so he could better operate as a distiller in a Gin company
“I did get promoted to Data Analyst just recently and once I get myself settled will be using a lot of what I learned in your course. I found the VBA especially useful; well really, all of it was very useful. It has gotten me thinking about better ways to manage the data and reports that I am building… now I just need the time to actually build the reports in a way that will save me time. :) I would recommend the course to anyone that wants to really learn what Excel can do. It was worth every penny.”
“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. I also really liked the PowerPoint lesson and the Marketing Your Skills lesson. This course is the complete package, I would recommend this course 100% because it goes above and beyond the call of developing a skillset that can be taken anywhere but also a mindset and direction as well”
“As an accountant, I worked with excel all day and have always been interested in getting more out of it. Having become involved with a new start-up business and sold my practice, I decided to do a detailed course in Excel in Dublin – It was very good with good insight into dashboards, index and match use and an intro to VBA. Having been aware of basic macro’s I was not happy with the VBA side of the course as it was left hanging and was of no use to me as the examples were not business related and did not inspire. It was this frustration that lead me to your course – I cannot remember how I found it but I took a free trial and thought that you examples were enough to invest given the price-point. I am yet to complete the course but would highly recommend it and have done so already. I have used the material in real life, especially the use of text functions. I have also used code having got some familiarity with”
“Sorry I didn’t get back to you earlier but I needed to collect all data before collating and I managed to do this only this week. It worked! Thank you once again, I think I still need more practice but your coding has made life much more simple”
“Completed up to the PowerPoint chapters on the VBA course – I wanted to fully get my head around VBA in Excel before I move onto PowerPoint (hopefully soon). Again, really good stuff, it’s so great having a tangible tool like VBA to open doors for me. Once again, thanks so much mate.”
“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 is an Excel & VBA Student)”
No worries, the start and finish is all down to you. We will stay in touch by email to occasionally remind you but we get it, life gets in the way and the great thing is the platform tracks where you last finished and how much you have completed so far, so it’s easy to pick up again.
I love talking about support, its where we shine since our company values are all rooted in student success! We are professionals so we give the most pragmatic and practical advice knowing how your Excel skills/work/analysis will impact your team and company. You can ask us via the learning platform, e-mail us directly and we can arrange some skype/phone time (it’s part of your package).
However this is not just support it goes in to the realm of consulting since most of our video support for actual excel files/analysis/dashboards that students are working on!
Yes, the purchase entitles you to download and keep the videos and worksheets for life, however this is available after 30 days or if you want it earlier than it will invalidate your right for a refund, so please ensure you are happy the training is for you before you request access to downloads.
Yes, we do, we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the course isn’t right for you and we will happily refund. Note, as per the above once you download the material, refunding is invalidated thereafter.
Yes, this is quite common since we focus on helping actual corporate employees. However, this needs to be done with a corporate credit/debit card. We don’t accept transfer/remittances.
Yes, we do this for companies or small groups of people, please get in touch at firstname.lastname@example.org letting us know how many people you are looking to train and we will get you sorted.
For the right people Pivot Tables should not be ignored
From my 15+ years of using Excel in major organisations, my rule of thumb is that if you are regularly working with mid-sized data sets (more than 5000 rows x 15-20 columns) then you should strongly consider Pivot Tables to summarise your data.