Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Advanced Excel Tricks for Power Users: Boost your Skills

person icon Alan Murray

4.4

Advanced Excel Tricks for Power Users: Boost your Skills

Unlock the full potential and Advance in Excel with Advanced Tricks and Techniques

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Alan Murray

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -79

Resources -1

Duration -6 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Do you want to learn the advanced Excel tricks used by the power users? This course is all about learning the advanced Excel techniques you do not get taught in Excel classes provided by your organisation.

This course will give you a deep understanding of the most powerful formulas and functions in Excel, including multiple examples to demonstrate what makes them so mega AWESOME.

It also delves into advanced PivotTable, chart, and custom formatting tricks to take your skills to another planet.

Why learn from me?

  • I have been training businesses all around the world on how to get the most out of Excel for over 23 years.
  • Learning and teaching Excel is my passion. I am a full-time Excel trainer and consultant, so every day I am in the thick of the action teaching others to master Excel.
  • I set up the Computergaga blog and YouTube channel 13+ years ago where I am lucky enough to have taught millions of people across the globe to increase their skills and overcome everyday real-world Excel problems.
  • I am an Excel MVP and have published multiple best-selling books on Excel and Power BI.
  • Your journey toward learning advanced Excel tricks starts today.

Goals

  • The very best functions of Microsoft Excel including SUMPRODUCT, INDEX, COUNTIF, MOD, and more in over 50 examples that others do not teach.
  • Advanced Excel charting techniques to create interactive and visually powerful charts.
  • Deep PivotTable settings and features to have them working exactly as you need.
  • Awesome custom formatting techniques for stunning visuals and learn why it can be better than Conditional Formatting.
  • Mega useful Excel tricks you can perform with day-to-day Excel features to supercharge your productivity.

Prerequisites

  • You have a good working knowledge of Excel. You know how to use staple features such as PivotTables, and basic formulas and to create Excel charts.
  • Any version of Excel can be used. The lessons will state if a specific version of Excel is needed for that technique.
Advanced Excel Tricks for Power Users: Boost your Skills

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

2 Lectures
  • play icon Introduction and What to Expect
  • play icon Course Files - Download these Files First to Follow Along

Neat Tricks to Supercharge your Productivity

8 Lectures
Tutorialspoint

Using Wildcards with Formulas

4 Lectures
Tutorialspoint

The Awesome SUMPRODUCT Function - The Swiss Army Knife of Functions

7 Lectures
Tutorialspoint

Advanced PivotTable Tricks

13 Lectures
Tutorialspoint

The Hidden Power of the MOD Function

6 Lectures
Tutorialspoint

The Magic of the INDIRECT Function

6 Lectures
Tutorialspoint

The Incredible INDEX Function

7 Lectures
Tutorialspoint

COUNTIF Function - A Mega Useful Excel Function

7 Lectures
Tutorialspoint

Introducing Custom Number Formatting

5 Lectures
Tutorialspoint

Advanced Custom Formatting Examples that Users did not know was Possible

4 Lectures
Tutorialspoint

Advanced Chart Tricks for Dynamic Interactive Charts

10 Lectures
Tutorialspoint

Instructor Details

Alan Murray

Alan Murray

Alan Murray is a Microsoft MVP and an Excel & Power BI trainer. He has been training for over 20 years for businesses around the world.
He is the founder of the Computergaga blog and YouTube channel. It has over 650 videos and more than 45 million views. He regularly shares new Excel tips and tutorials.
He is the author of the "Advanced Excel Formulas" and "Advanced Excel Success" books, showing how to get to the next level in your Excel journey.
Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses.
Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Feedbacks

T

Teena Moras

good

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515