Microsoft Excel - Advanced Excel Tricks that Impress

Microsoft Excel - Advanced Excel Tricks that Impress
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 6h 34m | 1.03 GB
Instructor: Alan Murray

The Secret Excel Magic Tricks used by the Power Users

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

Requirements

A basic knowledge of Excel
You are able to write basic formulas
The course is taught in Excel 2016, but the tricks will work in any version of Excel unless stated

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.

Who this course is for:

You want to improve your current Excel skills and learn advanced tricks
You want to learn Excels most powerful functions and understand why they are so awesome
You'd like to create stunning charts to visualize data effectively
You want to learn some neat tricks to work quickly and efficiently in Excel

More Info