Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 37 Minute(s)
Language
English
Taught by
Alan Murray
Rating
Course Overview
The Secret Excel Magic Tricks used by the Power Users
★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 100% money back guarantee ★★★★★
Full 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 class.
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.
During the course you will learn;
The very best functions of Excel including SUMPRODUCT, INDEX, COUNTIF, MOD and more in over 50 examples that others do not teach.
Advanced 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 tricks you can perform with day to day Excel features to supercharge your productivity.
Why learn from me?
I have been training business all around the world on how to get the most out of Excel for over 20 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.
You can download the files I use in the lessons to follow along and receive 1 on 1 instructor support every step of the way.
Course Content
- 10 section(s)
- 79 lecture(s)
- Section 1 Introduction
- Section 2 Neat Tricks to Supercharge your Productivity
- Section 3 Using Wildcards with Formulas
- Section 4 The Awesome SUMPRODUCT Function - The Swiss Army Knife of Functions
- Section 5 Advanced PivotTable Tricks
- Section 6 The Hidden Power of the MOD Function
- Section 7 The Magic of the INDIRECT Function
- Section 8 The Incredible INDEX Function
- Section 9 COUNTIF Function - A Mega Useful Excel Function
- Section 10 Introducing Custom Number Formatting
What You’ll Learn
- A deep understanding of the most useful and advanced functions of Excel
- Create dynamic and interactive charts to impress management
- Apply charting techniques that the pros use and be the charting boss of your office
- Apply tricks that will have you working faster, smarter and better at Excel
- Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support
- Fun and effective lessons on some of the greatest Excel tricks around
Skills covered in this course
Reviews
-
UUdemy User
Excellent stuff, exceeded my expectations. Great Work.
-
WWolfgang Ehrlich
That is a perfect course. Alan gives easy to understand explanations on how to use the formulas and which evaluations are possible with them. I have summarized his solution files in a workbook and thus have a good reference book if I have forgotten something again. The slow, accented way of speaking is also worth mentioning. This makes it easy to follow the teaching content.
-
BBhaskar Joshi
All the concepts were explained very clearly and were easy to understand and follow. The information conveyed was relevant and is really going to be handy.
-
AAndrea S.
Great course about many hidden (at least to my eyes) features that can save the day at work! Excel will never stop to amaze me. The teacher explained everything clearly and accurately! Thumbs up!
