Please ensure Javascript is enabled for purposes of website accessibility
Advanced Excel Tricks: Become An Excel Pro
0( 0 REVIEWS )
6h 27m

Master Advanced Excel Tricks: Functions, Charts, PivotTables, Formatting, and Productivity. Elevate Your Skills Today!

Read more.
Course Skill Level
Time Estimate
6h 27m


Alan is an Excel & Power BI trainer, founder of, author of multiple Excel books and Microsoft MVP. He has been helping people in Excel for over 22 years. He loves training and making peoples working lives easier.

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

Who this course is for:

  • This course is tailor-made for individuals who aspire to elevate their Excel proficiency to new heights. 
  • Whether you’re striving to refine your current Excel skills, discover the magic behind its most potent functions, or unleash your creative prowess in crafting captivating data visualizations, this course is your gateway to excellence. 
  • If you’re yearning for efficient Excel wizardry, you’ve come to the right place.

What you’ll learn: 

  • Develop a profound understanding of Excel’s most indispensable and advanced functions.
  • Craft dynamic and interactive charts that will leave your management team in awe.
  • Acquire charting techniques employed by seasoned professionals, asserting your dominance as the office charting virtuoso.
  • Implement an array of time-saving tricks that will catapult your Excel productivity to remarkable levels.
  • Revel in engaging lessons that unravel some of the most ingenious Excel secrets.


  • Before diving into this course, it’s essential to possess a basic grasp of Excel fundamentals and the ability to construct elementary formulas.

Software version used in the course:

  • The course primarily employs Excel 2016; however, rest assured that the skills and tricks you acquire here are universally applicable to any Excel version, unless explicitly stated otherwise.

In this course, you will gain proficiency in:

  1. Unveiling Excel’s Hidden Gems: Explore the crème de la crème of Excel functions, such as SUMPRODUCT, INDEX, COUNTIF, MOD, and a treasure trove of others, through a plethora of hands-on examples—over 50 of them, to be exact. These are the secret weapons that most courses overlook.
  1. Charting Mastery: Elevate your charting game by delving into advanced techniques that not only produce visually stunning charts but also make them interactive and impactful. Your charts will tell compelling stories that captivate your audience.
  1. PivotTable Wizardry: Dive deep into the inner workings of PivotTables. Learn how to wield their settings and features like a maestro, ensuring they dance to your tune and provide the precise insights you seek.
  1. Custom Formatting Brilliance: Discover the art of custom formatting, a technique that can turn your visuals into works of art. Understand why it can outshine conditional formatting and bring your data to life in ways you never imagined.
  1. Productivity Supercharging: Unearth an arsenal of mega-useful tricks that turbocharge your day-to-day Excel tasks. These are the hacks that will make you a productivity powerhouse, simplifying your work and boosting efficiency.

Join us in this course to unlock the full potential of Excel, mastering functions, charting, PivotTables, custom formatting, and productivity tricks that will set you apart in the realm of spreadsheet virtuosity.

Learn from a Renowned Expert

With over two decades of experience, I’ve had the privilege of training businesses worldwide in harnessing the full potential of Excel. My unwavering passion for Excel and extensive expertise in the field make me your ideal instructor.

Excel is My Playground

Teaching and learning Excel is not just my profession; it’s my passion. As a full-time Excel trainer and consultant, I am immersed in the Excel universe every day, empowering others to conquer its complexities.

A Proven Track Record

I founded the Computergaga blog and YouTube channel over 13 years ago, educating millions of individuals across the globe in mastering Excel and conquering real-world Excel challenges. As an Excel MVP, I’ve also authored numerous best-selling books on Excel and Power BI.

Join me on this journey, and let’s unlock the advanced Excel tricks and techniques that will set you apart in the world of data and spreadsheet wizardry.

Our Promise to You

By the end of this course, you will have learned advanced Excel tricks used by power users.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today!

Course Curriculum

Section 1 - Introduction
Introduction And What To Expect 00:00:00
Course Files – Download These Files First To Follow Along 00:00:00
Section 2 - Neat Tricks To Supercharge Your Productivity
10 Paste Special Tricks Used By The Pros 00:00:00
Excel’s Best Kept Secret – And 3 Ways To Use It 00:00:00
The Unsung Hero Of Excel For Cleaning Messy Data 00:00:00
Edit Multiple Sheets At The Same Time With Ease 00:00:00
5 Reasons Your Excel Formulas Are Not Calculating 00:00:00
Top Secret – How To Make Sheets Very Hidden 00:00:00
My Favourite Excel Shortcuts 00:00:00
Homework: Section 2 00:00:00
Section 3 - Using Wildcards With Formulas
Using Wildcards With VLOOKUP 00:00:00
Using Wildcards With COUNTIF And SUMIF 00:00:00
Validate That Text Is A Specific Number Of Characters 00:00:00
Homework: Section 3 00:00:00
Section 4 - The Awesome Sumproduct Function - The Swiss Army Knife Of Functions
The Definitive Guide To The SUMPRODUCT Function 00:00:00
Example 1 – Count And Sum The Sales From A Specific Month 00:00:00
Example 2 – Count The Occurrences Of A Specific Word In A Range 00:00:00
Example 3 – Count The Unique Values Only In A Range 00:00:00
Example 4 – Sum The Top 3 Values 00:00:00
Example 5 – Two Way Lookup Formula With Sumproduct 00:00:00
Homework: Section 4 00:00:00
Section 5 - Advanced Pivot Table Tricks
Two Reasons Your PivotTable Counts Instead Of Sums 00:00:00
You Must Do This One Thing 00:00:00
Grouping Dates And Times 00:00:00
Using The GETPIVOTDATA Function To Pull Data From A PivotTable 00:00:00
Going Beyond The Sum – 3 More PivotTable Calculations 00:00:00
Calculating The Difference To Previous Years, Months, Weeks 00:00:00
Create Your Own Calculated Fields 00:00:00
Using Conditional Formatting With PivotTables 00:00:00
Show Top Ten Results 00:00:00
Five Useful PivotTable Settings 00:00:00
The Power Of Slicers 00:00:00
7 Slicer Settings You Will Want To Change 00:00:00
Homework: Section 5 00:00:00
Section 6 - The Hidden Power Of The MOD Function
An Introduction To The MOD Function 00:00:00
Example 1 – Extracting The Time From A Date-Time Cell 00:00:00
Example 2 – Prevent The Entry Of Odd Numbers In A Range 00:00:00
Example 3 – Calculate Total Balls Bowled From Overs In Cricket 00:00:00
Example 4 – Sum Every 3rd Row In A List 00:00:00
Homework: Section 6 00:00:00
Section 7 - The Magic Of The Indirect Function
Example 1 – INDIRECT With Named Ranges 00:00:00
Example 2 – Referencing Other Sheets With INDIRECT 00:00:00
Example 3 – Return The Last Value From A Row 00:00:00
Example 4 – INDIRECT With VLOOKUP 00:00:00
Example 5 – Create Dependent Drop Down Lists 00:00:00
Homework: Section 7 00:00:00
Section 8 - The Incredible Index Function
Example 1 – Using INDEX And MATCH For An Advanced Lookup 00:00:00
Example 2 – Create A Picture Lookup 00:00:00
Example 3 – Return The Value From The Last Row 00:00:00
Example 4 – Create A Dynamic Named Range 00:00:00
Example 5 – Sum The Last 6 Values Only 00:00:00
Example 6 – Retrieve A Range From A List Of Ranges 00:00:00
Homework: Section 8 00:00:00
Section 9 - COUNTIF Function - A Mega Useful Excel Function
Using Cell Values With COUNTIF 00:00:00
Count Values Between Two Dates 00:00:00
Prevent Duplicates In A Range 00:00:00
Compare Two Lists To Identify Missing Items 00:00:00
VLOOKUP For The Last Match In A List 00:00:00
Uniquely Rank Items 00:00:00
Homework: Section 9 00:00:00
Section 10 - Introducing Custom Number Formatting
Combine Text And Numbers In A Cell 00:00:00
Show The Weekday Of A Date 00:00:00
Keep The Leading Zeroes Of A Value 00:00:00
Display Negative Values In Red 00:00:00
Show Zero Values As Blank Cells 00:00:00
Section 11 - Advanced Custom Formatting Examples That Users Did Not Know Was Possible
Display Symbols Using Custom Formatting To Show Change 00:00:00
Conditional Colour With Custom Formatting 00:00:00
Setting Thresholds For Your Custom Formatting 00:00:00
Homework: Section 11 00:00:00
Section 12 - Advanced Chart Tricks For Dynamic Interactive Charts
The Easiest Way To Create A Dynamic Data Range 00:00:00
Drop Down Menu To Select A Chart 00:00:00
Get Creative By Building A Dynamic Chart Title 00:00:00
Highlight The Max And Min Values Differently 00:00:00
Create A Scrollable Chart 00:00:00
Use Cell Values For Data Labels To Show What You Want 00:00:00
Rolling Chart For The Last 6 Months Only 00:00:00
Visualise Targets Vs Actuals 00:00:00
Using Check Boxes To Show Or Hide Chart Data 00:00:00
Homework: Section 12 00:00:00

Join our newsletter and get your first course free!


Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?