Excel Pivot Macros Bundle2019-02-26T02:05:34+00:00

EXCEL GURU: ALL OUR EXCEL, PIVOT TABLES & VBA TRAINING

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

SIGN UP

ABOUT THIS TRAINING

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

SKILLS YOU WILL LEARN

• 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

WHAT YOU GET IN THIS TRAINING

Advanced Excel, Pivot Tables, Excel Dashboards, VBA, Macros, Power Query, PowerPivot, SQL Server, Business Intelligence, Power BI, Career Progression

100% online courses

Start instantly and learn at your own schedule

Beginner to Advanced Level

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.

Approx. 3+ months to complete

Suggested 3-5 hours/week

Downloadable

*Download to any device

Support

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.

Certification

You can request Certificates for particular courses on completion and share them in the Certifications section of your Linkedin profile

BEGINNER TO ADVANCED EXCEL

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.

LEARN MORE

ULTIMATE PIVOT TABLES

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.

LEARN MORE

VBA FOR PROFESSIONALS

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.

LEARN MORE

SAMPLE TRAINING VIDEOS

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

Join Now And Start Learning!

SIGN UP

$491

$397

SAVE OVER 23%

Here’s what some of our students have to say about our Excel Training course

Kiran Arain

Senior Financial Analyst, Canada

“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!”

A. Saleem

Investment Banking PMO, London

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

James Barton-Ginger

PMO Manager, London

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

Fabio

PMO Analyst in Banking, UK

“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!”

Tony.S

PMO Consultant, UK

“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!!)”

Barry

Accountant, Ireland

“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

Dawn Anderson

Data Analyst, US

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

Mike Doubek

Project Manager, US

“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”

Barry

Accountant, Ireland

“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”

Sara

Business Controller, China

“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”

Martin

Accountant, London

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

Laura M

Financial controller, Barcelona

“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)”

Frequently Asked Questions

The material itself is around 30 hours, with every second carefully crafted and included, however takes a significant amount of time to absorb the material. As a minimum I recommend students spend around 3 to 5 hours a week or 30 minutes a day to keep momentum going. At that pace you can expect to be done in 8-12 weeks, however most students are constantly revisiting material as should you.

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

We are most famous for our video responses to students! If you are working on something challenging, get in touch and we will make a video to really get you unstuck. We find video is the best medium for teaching Excel skills and so it’s a huge part of our support.
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 support@earnandexcel.com letting us know how many people you are looking to train and we will get you sorted.

Yes, we do and it can be displayed on LinkedIn. But know this, a certificate is not nearly as useful as your ability to effectively discuss your Excel skills on your CV/Resume and in an interview. We do have another course on that. In fact, here’s what we’ll do, if you sign up to this course and forward your receipt to us, requesting our ‘Excel Your Career: CV’s/Interviews, we will give you free access to that powerful training!

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.