Home Search Profile
TrainingHub TrainingHub

Ultimate Excel Pro 2024: Master Advanced Tricks & Formulas

Focused View

5:31:05

  • 1 -Introduction and What to Expect.mp4
    06:54
  • 2 -practise-files.zip
  • 2 - Course Files - Download these files first to follow along.html
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
    •

    More details

    Course Overview

    Unlock Excel's full potential with this power-user course covering advanced functions, productivity hacks, and professional charting techniques used by data analysts and Excel experts worldwide.

    What You'll Learn

    • Master advanced functions like SUMPRODUCT, INDIRECT and INDEX-MATCH
    • Implement time-saving tricks and professional formatting techniques
    • Create dynamic PivotTables and interactive dashboards

    Who This Is For

    • Business analysts seeking to enhance reporting skills
    • Office professionals wanting to work smarter
    • Finance professionals needing advanced Excel mastery

    Key Benefits

    • Lifetime access to practice files and 1-on-1 support
    • Learn hidden features even experienced users miss
    • Boost productivity with professional shortcuts

    Curriculum Highlights

    1. Power-user productivity tricks
    2. Advanced function mastery
    3. Professional PivotTable techniques