Updated on Jun, 2025
Language - English
good
Advanced Excel Tricks for Power Users: Boost your Skills
Unlock the full potential and Advance in Excel with Advanced Tricks and Techniques
Office Productivity,Microsoft,Excel
Lectures -79
Resources -1
Duration -6 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
2 Lectures
-
Introduction and What to Expect
-
Course Files - Download these Files First to Follow Along
Neat Tricks to Supercharge your Productivity
8 Lectures
Using Wildcards with Formulas
4 Lectures
The Awesome SUMPRODUCT Function - The Swiss Army Knife of Functions
7 Lectures
Advanced PivotTable Tricks
13 Lectures
The Hidden Power of the MOD Function
6 Lectures
The Magic of the INDIRECT Function
6 Lectures
The Incredible INDEX Function
7 Lectures
COUNTIF Function - A Mega Useful Excel Function
7 Lectures
Introducing Custom Number Formatting
5 Lectures
Advanced Custom Formatting Examples that Users did not know was Possible
4 Lectures
Advanced Chart Tricks for Dynamic Interactive Charts
10 Lectures
Instructor Details
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.
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.
Our students work
with the Best
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now