Look, I get it. You’re great at your job. You’re smart and resourceful. But Excel is huge and can be overwhelming. You’ve nailed the basics but you know there’s so much more, and you’re not sure where to begin.
Here’s what I learned after 20+ years training everyone from janitors to CEOs: You don’t need another boring course. You simply need good direction and practical advice that resonates with where you’re at in your journey, from someone who’s been there.
So I’m doing something crazy . . .
Excel Mastery
Your one-stop-shop for creating professional spreadsheets and reports using powerful formulas, automations and an array of tools that will push you well ahead of the crowd. Take a peek behind the curtain and discover what the pro’s use to get results fast.
What’s covered in Excel Mastery?
Click a module below to show/hide the contents
MODULE 1: TABLE MAGIC
- Time to discard the old-school way of creating and formatting tables and adopt the modern approach. Prepare to be shocked and surprised.
- Meet some old friends called Sort, Filter & Subtotal and discover some new and flexible ways to use them to your advantage.
- Meet some new friends called Sparklines and Flash Fill.
MODULE 2: BUILD THE ENGINE: FORMULAS & FUNCTIONS
- Excel has over 500 formula functions. This module contains a good collection of the most useful ones with plenty of demos and examples to practise on.
- Break the code on formulas and functions to achieve anything.
- Creating powerful formula combos.
- Construct logic, rounding, lookup, date, time, text, math, database and financial functions to generate, manipulate and analyse data.
- Absolute vs relative cell referencing – why, when and how to use each option and how to go beyond the basics.
- Naming cells – why it is a game changer.
MODULE 3: UNLOCK THE SECRETS TO AMAZING CHARTS
- Learn how to create 17 different types of chart.
- Manipulate and format charts like a pro.
- Explore the most important chart options.
MODULE 4: THAT’S SOME SERIOUS STYLE MAN! WHY YOU ABSOLUTELY SHOULD JUDGE A BOOK BY ITS COVER
- Go beyond basic formatting with with styles (for consistency & easy maintenance).
- How to use the same styles across multiple workbooks.
- Conditional Formatting: Unleash the magic and versatility of selectively formatting.
MODULE 5: VALIDATING YOUR DATA TO KEEP THE RIFF RAFF OUT
- Basic validation: numbers, dates and time within a range or that text is a certain length.
- Drop-down lists that offer preset options to reduce input errors
- Vital tips on how to manage lots of lists.
- Validation formulas – go next level and check for almost anything.
MODULE 6: THE PLAYBOOK FOR CREATING PIVOT TABLES & PIVOT CHARTS
- Consolidate, analyse, summarise & simplify your data with pivot tables.
- Tips on how to prepare your data and get the most from the pivot tools.
- 3 ways to filter and 3 ways to group pivot data.
- Drill down, break up and calculating new fields and items.
- Function & format, design & configuration, settings & report layouts.
- The low-down on pivot tables vs pivot charts.
MODULE 7: WHAT IF? ANALYSIS TOOLS
- Unlock this powerful suite of tools to help you prepare for different situations and eliminate the guesswork.
- Goal seek: Set the final answer and ask Excel to get you there.
- Solver: Ask Excel to calculate the best possible combination in order to get to a set answer while working within set constraints
- Data variable table: Get Excel to build out a reference table really quickly
- Scenarios: Store preset snapshots of data and snap back to them any time
MODULE 8: THE INSIDE SCOOP (TRICKS OF THE TRADE)
- The little-known tool that lets you quickly consolidate data from various sources.
Uncover the secrets behind Paste Special. - Protect your work from accidental or deliberate changes (at cell, worksheet and workbook level).
- Create templates for you or others to use many times over.
- Save your preferred worksheet layout as a custom view.
- Collaborate as a team or give yourself reminders using comments.
- Link internally within your workbook or externally to other files, websites or a pre-addressed email
- Design responsive forms using an array of tools such as command buttons, combo boxes, list boxes, check (tick) boxes, option (radio) buttons, option groups and spinners.
- Automate repetitive tasks using macros
Here’s Where It Get’s Crazy!
You came to learn Excel.
But you’ll be leaving with my entire $3,000+ Microsoft 365 Vault
Yes! When you join today you’ll not only get Excel Mastery (value $497) but you also get instant access to everything shown below (click any image for details):
Essential skills fast
(value $297)
Professional docs in minutes
(value $397)
Perfect numbering first time
(value $99)
Master the basics
(value $297)
Presentations that wow
(value $297)
Visual design gems
(value $197)
Beginners bootcamp
(value $397)
Manage email like a pro
(value $297)
Marketing materials made easy
(value $297)
Total Value $3,072
Access to All 10 Courses
[ Limited offer ]
Monthly
$35
Cancel Any Time
- Try it out.
- Instant 24x7x365 access to hundreds of actionable videos and PDF guides
- 20% off 1-on-1 consulting
Pricing is in USD
Why Am I Giving Everything Away For Pennies On The Dollar?
Simple: I’ve shifted my focus to providing high-end private 1-on-1 services for individuals and groups.
This is my “legacy library”. There is absolutely nothing inferior about the training. It’s not outdated – in fact most of the content is evergreen and still incredibly valuable. There won’t be any more updates and I’ve removed the community forums but you’re still getting the same high-quality, premium content that used to cost $297+ per course, jam-packed with shortcuts you’ll actually use and dependable, proven advice – just without the high price tag.
Pick what you want, when you want. Like a streaming service. Quick, snappy videos. Downloadable pdf guides. No fluff or long intros.
Go from zero to 100 without wasting a moment.
Think of it like buying a luxury car that’s 2 years old. Same premium engineering, fraction of the price.
For less than your monthly coffee budget, you get my absolute best advice. My secret sauce. The things that matter. The things that work. Strategies from 20+ years in the trenches. I pull from a deep well of knowledge but keep everything simple, to give you the best chance of success.
What Others Are Saying
It’s incredible. I never knew all this was possible. The course has really opened my eyes and given me a fresh perspective. The videos are clear they have helped me tremendously.
I work on complex legal documents and as a temp, you’re sometimes left to find information on your own. I’ve learned far more from you than anything I’ve found in books or online. The lessons are SO clear. I think my manager will be very surprised to see the improvement in my skills.
Awesome. Thanks for some great training. The content was explained simply and effectively. Great visual and hands-on approach really helped me to remember everything
I really appreciated the time and tolerance taken for a beginner like myself. Jason is very good at explaining computer terms. The videos were delivered simply and professionally and the training notes are first class.
Word Styles and automatic multilevel numbering are both harder than quantum mechanics. And you have made simple. Thank you!!!
Thanks a million. I have gone on courses, I have paid people to teach me and I still couldn’t get it. Your videos are crystal clear and now I can’t remember why I found it so difficult!
REALLY helpful. I’m a Wordsmith who works on academic documents for postgrad students. The structure and formatting is often messed up beyond belief. This course goes way deeper than anything else I’ve found and is invaluable!
Fantastic tutorials, really easy to follow! I learnt more about styles in the few minutes watching your video than 20 years of reading Word help. Thanks.
I can only copy what everyone else has commented. Awesome!! I’ve been working at this for weeks and the multilevel numbering video in particular answered a ton of questions and demystified what shouldn’t even be this complex. Many thanks.
I can’t believe it. I have been looking everywhere for a course like this. It has been a revelation. Can’t wait to watch the rest. Would have saved me a gazillion hours had I found this earlier!
Super videos, easy to follow and very helpful. Thank you!!!! Love from India
It was really user friendly. I’m a visual learner and I love that I can do this in the comfort of my own home. Doing the courses exercises as I go and having to think and work out things for myself has really helped.
Excellent, really clear and well explained.
Very well put together, informative and easy to follow. It answered all my questions. Thanks so much!
I have seen many tutorials on different topics. This is an EXCELLENT course run by a highly knowledgeable, easy going teacher!! Thank you for the hard work you put into creating the course!
Excellent teaching! Took too long to find this. No waffle, just easy, clear instructions. Thank you!
Great course and well taught. This has opened up a lot of possibilities. A small but powerful program that will improve my design processes.
You made it so simple. After wasting a whole day watching YouTube videos on this and getting more confused it’s such a relief to finally get the answers I needed.
Call me weird but I really enjoyed this course. I found it very easy to follow, user friendly and super practical. I can’t tell you how much easier it is than reading a book! Thank you
Excellent! Thank you for getting straight to the point 🙂 It is so easy to listen to. I found the exact information I was looking for.
Excellent teaching! I regret not finding these awesome videos sooner. I have started to cull a huge backlog of emails thanks to the tips I learned. You are really good at getting to the crux of the matter. Appreciate that very much. Good job and keep it up.
Very helpful thank you! It is amazing how fast I am understanding it. After watching your videos I don’t know why it was so difficult! Thank you for your guidance.
The course is very good for beginners and you covered a lot without invoking brain strain!
With the videos, examples and useful study guide, I have already started using some of these new skills each day. I feel much more confident now.
Such useful videos, succinct and stacked with useful tips and info. I am definitely spreading the word among my friends.
Microsoft 365 Vault
Get Started Within 5 Minutes
Monthly
$35
Cancel Any Time
- Try it out.
- Instant 24x7x365 access to all training – hundreds of actionable videos and PDF guides
- 20% off private 1-on-1 consulting
Total Value: USD $3,072
Accelerate your knowledge and start using Excel like the Pro’s
for less cost than half a tank of fuel
Get instant access to powerful Excel resources that actually work
Right now is your sliding-doors moment. You’re right here, so before you think about clicking another browser tab or get distracted by something on your phone, do your future-self a favour and
CLICK ONE OF THE GREEN BUTTONS ABOVE before this offer disappears forever.
See you on the inside.
Would you prefer more personal 1-on-1 help?
My advice is simple, straight-forward and easy to implement. In fact, all the techniques I share with you, I use.
For more personal help, I offer 1-on-1 consulting for complex projects or accelerated learning. Please reach out.