Microsoft Excel – Advanced Excel Tricks that Impress

سرفصل های دوره

The Secret Excel Magic Tricks used by the Power Users

1 - Introduction

1 -Introduction and What to Expect

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

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

3 -The Unsung Hero of Excel for Cleaning Messy Data

4 -Edit Multiple Sheets at the Same Time with Ease

5 -5 Reasons your Excel Formulas are not Calculating

6 -TOP SECRET - How to Make Sheets VERY Hidden

7 -My Favourite Excel Shortcuts

8 - HOMEWORK Section 2.html

3 - Using Wildcards with Formulas

1 -Using Wildcards with VLOOKUP

2 -Using wildcards with COUNTIF and SUMIF

3 -Validate that Text is a Specific Number of Characters

4 - HOMEWORK Section 3.html

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

1 -The Definitive Guide to the SUMPRODUCT Function

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

2 -an introduction to the sumproduct function.zip

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

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

5 -Example 4 - Sum the Top 3 Values

6 -Example 5 - Two Way Lookup Formula with SUMPRODUCT

7 - HOMEWORK Section 4.html

5 - Advanced PivotTable Tricks

1 -Two Reasons your PivotTable Counts instead of Sums

2 -You Must Do this One Thing

3 -Grouping Dates and Times

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

5 -Going Beyond the Sum - 3 More PivotTable Calculations

6 -Calculating the Difference to Previous YearsMonthsWeeks

7 -Create your own Calculated Fields

8 -Using Conditional Formatting with PivotTables

9 -Show Top Ten Results

10 -Five Useful PivotTable Settings

11 -The Power of Slicers

12 -7 Slicer Settings you Will Want to Change

13 - HOMEWORK Section 5.html

6 - The Hidden Power of the MOD Function

1 -An Introduction to the MOD Function

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

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

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

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

6 - HOMEWORK Section 6.html

7 - The Magic of the INDIRECT Function

1 -Example 1 - INDIRECT with Named Ranges

2 -Example 2 - Referencing other Sheets with INDIRECT

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

4 -Example 4 - INDIRECT with VLOOKUP

5 -Example 5 - Create Dependent Drop Down Lists

6 - HOMEWORK Section 7.html

8 - The Incredible INDEX Function

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

2 -Example 2 - Create a Picture Lookup

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

4 -Example 4 - Create a Dynamic Named Range

5 -Example 5 - Sum the Last 6 Values Only

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

7 - HOMEWORK Section 8.html

9 - COUNTIF Function - A Mega Useful Excel Function

1 -Using Cell Values with COUNTIF

2 -Count Values Between Two Dates

3 -Prevent Duplicates in a Range

4 -Compare Two Lists to Identify Missing Items

5 -VLOOKUP for the Last Match in a List

6 -Uniquely Rank Items

7 - HOMEWORK Section 9.html

10 - Introducing Custom Number Formatting

1 -Combine Text and Numbers in a Cell

2 -Show the Weekday of a Date

3 -Keep the Leading Zeroes of a Value

3 -custom-number-format-characters.pdf

4 -Display Negative Values in Red

5 -Show Zero Values as Blank Cells

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

1 -Display Symbols using Custom Formatting to Show Change

2 -Conditional Colour with Custom Formatting

2 -excel-color-index.zip

3 -Setting Thresholds for your Custom Formatting

4 - HOMEWORK Section 11.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy