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.

(YOURS WHEN YOU JOIN THE OFFICE LEGENDS ACADEMY)
Office Legends Logo

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.

What Excel Mastery looks like

Office Mastery   |  Office Mastery Digital Academy
Copyright © Two Rivers Software Training. All Rights Reserved Privacy Terms Contact
Like us on facebook Watch us on YouTube Connect with Jason on LinkedIn
Office Mastery