Master Advanced Excel Tricks: Functions, Charts, PivotTables, Formatting, and Productivity. Elevate Your Skills Today!
Read more.Instructor
Alan is an Excel & Power BI trainer, founder of computergaga.com, 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.
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
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.
Requirements:Â
- 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:
- 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.
- 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.
- 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.
- 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.
- 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 |