Urgently need to upgrade your scrappy, self-taught Excel skills so you can design spreadsheets better, faster and smarter?

Discover how to create robust, well-designed spreadsheets using advanced formulas, pivot tables, macros and much more. Develop sought-after skills and become the go-to guy or gal in your office.

Gain an unfair advantage
INTRODUCING

Excel Mastery

Your one-stop-shop for quickly mastering
Microsoft Excel beyond the basics.

And it's not expensive. In fact ...

You can choose what you want to pay! For real!

Happiness guarantee

And what's more, if you complete the course, practice what you learn ...

... and after 30 days, you still feel like you have NOT raised your Excel several levels and CANNOT confidently write formulas or use tools to get the reports you need ...

... then let me know and I will gladly refund your course fee in full

I don't just sell training. I sell results. And if I fail in that task, I do not want your money!

Think about it. The worst that can happen is that you come away a little bit smarter! Realistically, you could finally get the skills and confidence-boost you're looking for and tick this item off your list. Better yet, your job prospects will expand!

How good would that feel!

What You Get

What Excel Mastery looks like

You will be assigned your own personal membership dashboard

video
LESSONS

Available 24 x 7 x 365. Learn what you need, when you need to.

 WRITTEN 
TRAINING GUIDE

Clear steps that are easy to follow, with plenty of pictures.

PRACTICE
EXERCISES

Practice & repetition. It's the best way to master anything

CERTIFICATE
OF COMPLETION  

Download or print your personal certificate of completion

MEMBER FORUMS
& ONGOING SUPPORT

Get answers to your questions + feedback, ideas and inspiration

A place to
TAKE YOUR OWN NOTES 

Write your own notes against each lesson & print them all together

Excel Mastery Course Modules

 Overview

1

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

MODULE 2: BUILD THE ENGINE: FORMULAS & FUNCTIONS

  • Excel has over 500 formula functions. This course dissects the most useful ones with plenty of demos and  examples to practise on.
  • Break the code on formulas and functions to achieve anything.
  • Multiply the formulas effect by creating powerful 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.
3

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

MODULE 4: THAT'S SOME SERIOUS STYLE MAN!
WHY YOU 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.
5

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

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

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
8

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

What are people saying about this course?

rachel
lowe

MY EYES HAVE BEEN OPENED

Thank you so much! I never knew I could do all this. It's amazing and refreshing. This course has really opened my eyes and given me a fresh perspective. I found the videos clear and concise and they really helped me a lot.

STEVE
MANSFIELD

WASTED WEEKS BEFORE  THIS

Brilliant! I have spent weeks trying to work this out. I watched a number of other training videos, however they were not very helpful at all. After watching your videos it all makes sense!. You have made my day. Thank you!

ANDREA
DUNN

HIGHLY KNOWLEDGEABLE

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!

ANDY
WINSLOW

NO TIME WASTED

Thank you for not wasting our time with a 30 minute lecture of the freaking history of Excel and all kinds of unnecessary info, like so many other ppl do. Your info is quick and easy.

ANITA
BEGG

GOT THE NEXT JOB I WENT FOR

After failing to secure a job that I thought I had in the bag, I bit the bullet and signed up. I quickly realised how much I didn't know. But I put my head down, went through the course and guess what. I got the very next job I went for! Thank you so much.

BETTINA
ST JOHN

SOLVED

Fantastic, precise and simple explanations for a number of things I have been struggling with for years. Thanks heaps.

Office Legends Academy logo | Creating Microsoft Office Legends

Get Started Today
Pay Your Own Price

(Minimum Price Only $79)

I'm on a mission to help 100,000 people become legends in Microsoft Office. And I don't want price to be a barrier. That's right. Get your hands on as many of my premium e-courses as you need for whatever you want to pay.

No catch. No strings attached.

Up until now, these powerful courses have sold for $299-$399 (and that's a steal). Most course creators put their prices UP over time, but I wanted to try something completely different. Let you choose what you want to pay. It may blow up in my face (and I may withdraw this offer without notice) but I want to create a different kind of legacy. Money does not motivate me.

So why don't I give it away for free? 

Honestly, tyre-kickers and freebie-seekers suck! 'Free' rarely attracts people who are willing to hustle and grind and put in the work to succeed. They're time wasters. I want to help people with a genuine need. Action takers who go all-in. Only you know if that's you. When you pay (even a little bit) you pay attention and you're incentivised and motivated to go through the course(s).

So now the only question is:

ARE YOU SERIOUS about mastering complex formulas and powerful Excel tools for your own self-improvement, for better job prospects or to get answers to your burning questions?

The better question is:

What is this worth to you? What would it mean to you to get to the other side? To land that dream job or promotion? To NOT have to keep asking for help? To be self-sufficient and more confident? To master a fistful of new tools that slash hours from your week?

You can't put a price on that!

Courses and bundles are available to purchase below

Premium E-Course:

Excel Mastery

REGULAR PRICE

$

399

     

Pay Your Own Price !

Pay your own price and get ...

  • Immediate 24x7x365 access
  • Learn at your own pace.
  • Everything is online
  • Teaching from MS-Certified Master Instructor
  • Straight-to-the-point, no-fluff videos
  • Easy-to-follow written guides
  • Practise exercises & working examples
  • Certificate of Completion
  • Lifetime access. No more to pay, ever.
  • Money-back satisfaction guarantee

Pay full price and also get ...

  • Downloadable training materials and videos
  • Priority support
  • Member forum
  • Discounted 1-on-1 time with Jason, the course creator if you want specific help
>