Microsoft Excel - Advanced Excel Tricks that Impress

Focused View

Alan Murray

5:31:05

0 View

1 - Introduction

1 -Introduction and What to Expect.mp4

06:54

2 -practise-files.zip

2 - Course Files - Download these files first to follow along.html

2 - Neat Tricks to Supercharge your Productivity

1 -10 Paste Special Tricks used by the Pros.mp4

11:35

2 -Excels Best Kept Secret - and 3 Ways to Use it.mp4

06:59

3 -The Unsung Hero of Excel for Cleaning Messy Data.mp4

11:08

4 -Edit Multiple Sheets at the Same Time with Ease.mp4

04:19

5 -5 Reasons your Excel Formulas are not Calculating.mp4

05:53

6 -TOP SECRET - How to Make Sheets VERY Hidden.mp4

04:55

7 -My Favourite Excel Shortcuts.mp4

10:34

8 - HOMEWORK Section 2.html

3 - Using Wildcards with Formulas

1 -Using Wildcards with VLOOKUP.mp4

04:05

2 -Using wildcards with COUNTIF and SUMIF.mp4

02:26

3 -Validate that Text is a Specific Number of Characters.mp4

03:51

4 - HOMEWORK Section 3.html

4 - The Awesome SUMPRODUCT Function - The Swiss Army Knife of Functions

1 -The Definitive Guide to the SUMPRODUCT Function.mp4

08:00

2 -Example 1 - Count and Sum the Sales from a Specific Month.mp4

06:22

2 -an introduction to the sumproduct function.zip

3 -Example 2 - Count the Occurrences of a Specific Word in a Range.mp4

04:18

4 -Example 3 - Count the Unique Values ONLY in a Range.mp4

03:25

5 -Example 4 - Sum the Top 3 Values.mp4

03:05

6 -Example 5 - Two Way Lookup Formula with SUMPRODUCT.mp4

04:18

7 - HOMEWORK Section 4.html

5 - Advanced PivotTable Tricks

1 -Two Reasons your PivotTable Counts instead of Sums.mp4

06:07

2 -You Must Do this One Thing.mp4

06:48

3 -Grouping Dates and Times.mp4

09:21

4 -Using the GETPIVOTDATA Function to Pull Data from a PivotTable.mp4

09:22

5 -Going Beyond the Sum - 3 More PivotTable Calculations.mp4

09:43

6 -Calculating the Difference to Previous YearsMonthsWeeks.mp4

05:16

7 -Create your own Calculated Fields.mp4

03:41

8 -Using Conditional Formatting with PivotTables.mp4

06:21

9 -Show Top Ten Results.mp4

03:20

10 -Five Useful PivotTable Settings.mp4

08:16

11 -The Power of Slicers.mp4

10:29

12 -7 Slicer Settings you Will Want to Change.mp4

08:53

13 - HOMEWORK Section 5.html

6 - The Hidden Power of the MOD Function

1 -An Introduction to the MOD Function.mp4

01:53

2 -Example 1 - Extracting the Time from a Date-Time Cell.mp4

02:21

3 -Example 2 - Prevent the Entry of Odd Numbers in a Range.mp4

02:44

4 -Example 3 - Calculate Total Balls Bowled from Overs in Cricket.mp4

03:47

5 -Example 4 - Sum Every 3rd Row in a List.mp4

06:07

6 - HOMEWORK Section 6.html

7 - The Magic of the INDIRECT Function

1 -Example 1 - INDIRECT with Named Ranges.mp4

02:49

2 -Example 2 - Referencing other Sheets with INDIRECT.mp4

04:27

3 -Example 3 - Return the Last Value from a Row.mp4

04:24

4 -Example 4 - INDIRECT with VLOOKUP.mp4

02:27

5 -Example 5 - Create Dependent Drop Down Lists.mp4

03:14

6 - HOMEWORK Section 7.html

8 - The Incredible INDEX Function

1 -Example 1 - Using INDEX and MATCH for an Advanced Lookup.mp4

11:09

2 -Example 2 - Create a Picture Lookup.mp4

08:01

3 -Example 3 - Return the Value from the Last Row.mp4

02:51

4 -Example 4 - Create a Dynamic Named Range.mp4

12:10

5 -Example 5 - Sum the Last 6 Values Only.mp4

04:43

6 -Example 6 - Retrieve a Range from a List of Ranges.mp4

05:59

7 - HOMEWORK Section 8.html

9 - COUNTIF Function - A Mega Useful Excel Function

1 -Using Cell Values with COUNTIF.mp4

04:58

2 -Count Values Between Two Dates.mp4

02:58

3 -Prevent Duplicates in a Range.mp4

04:12

4 -Compare Two Lists to Identify Missing Items.mp4

04:24

5 -VLOOKUP for the Last Match in a List.mp4

07:40

6 -Uniquely Rank Items.mp4

05:05

7 - HOMEWORK Section 9.html

10 - Introducing Custom Number Formatting

1 -Combine Text and Numbers in a Cell.mp4

03:51

2 -Show the Weekday of a Date.mp4

02:51

3 -Keep the Leading Zeroes of a Value.mp4

03:08

3 -custom-number-format-characters.pdf

4 -Display Negative Values in Red.mp4

03:28

5 -Show Zero Values as Blank Cells.mp4

02:48

11 - Advanced Custom Formatting Examples that Users did not know was Possible

1 -Display Symbols using Custom Formatting to Show Change.mp4

07:15

2 -Conditional Colour with Custom Formatting.mp4

05:24

2 -excel-color-index.zip

3 -Setting Thresholds for your Custom Formatting.mp4

04:13

4 - HOMEWORK Section 11.html

Description

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

Who is this 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

What You Need to Know?

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

More details

Description
â˜…â˜…â˜…â˜…â˜… 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.
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

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Alan Murray

Instructor's Courses

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 600 videos and more than 35 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.