Meet Your Instructor

I'm Wyn Hopkins, your expert instructor on this transformative Excel journey. With 30+ years of experience and a passion for empowering professionals like you, I'm here to guide you through mastering Professional Excel Productivity. Join me in exploring the depths of Excel's capabilities and revolutionize the way you work with data. Let's embark on this learning adventure together!

About the Course

Unleash your Excel skills with our Professional Excel Productivity course designed for those using Excel daily at work. From Tips and Tricks to Power Query, Dynamic Arrays, Pivot Tables, Power Pivot, and analyzing massive datasets, this course equips you with the essential features to excel in Excel. Enhance your productivity and unlock new possibilities with our comprehensive curriculum. Enroll now and take your Excel proficiency to the next level!

The Warm Up... Efficiency tips

Learn valuable features and techniques to boost your efficiency in Excel.

Power Query and Dynamic Arrays

Discover how to manipulate and analyze data effectively using Power Query and Dynamic Arrays.

Data Models and Dashboards

Master the art of creating insightful reports and analyzing large datasets with Pivot Tables and Power Pivot.

Course Curriculum

8 Chapters · 61 Lessons

  1. 1

    Introduction to Excel Productivity

    1. Welcome to Professional Excel Productivity Free preview
    2. (Included in full purchase)

      Download the Exercises

    3. (Included in full purchase)

      Extract The Exercises

  2. 2

    Essential Efficiency Tips

    1. (Included in full purchase)

      Tips and Tricks Intro

    2. (Included in full purchase)

      Data Filling

    3. (Included in full purchase)

      Merging and Hiding

    4. Convert Dates Free preview
    5. (Included in full purchase)

      Tables

    6. (Included in full purchase)

      PivotTables

    7. (Included in full purchase)

      Conditional Formatting

    8. (Included in full purchase)

      AGGREGATE

    9. (Included in full purchase)

      TEXTJOIN

    10. (Included in full purchase)

      Stacked Chart Total

    11. (Included in full purchase)

      Shape Hacks

    12. (Included in full purchase)

      Default Start Up Template

    13. (Included in full purchase)

      Quiz

  3. 3

    Data Analysis with Power Query

    1. (Included in full purchase)

      Introduction to Power Query

    2. (Included in full purchase)

      Power Query Calculations

    3. (Included in full purchase)

      Split to Rows

    4. From Web ( and UNPIVOT ) Free preview
    5. (Included in full purchase)

      From Folder (and UNPIVOT)

    6. (Included in full purchase)

      Appending

    7. (Included in full purchase)

      Merging

    8. (Included in full purchase)

      Last Refresh

    9. (Included in full purchase)

      Bonus: Interact with Excel while in Power Query

    10. (Included in full purchase)

      Power Query Quiz

  4. 4

    Dynamic Array Excel

    1. (Included in full purchase)

      Dynamic Array Excel Introduction

    2. (Included in full purchase)

      FILTER

    3. SUM has Super Powers Free preview
    4. (Included in full purchase)

      TEXT functions

    5. (Included in full purchase)

      BYCOL BYROW

    6. (Included in full purchase)

      DROP and VSTACK

    7. (Included in full purchase)

      REGEX

    8. (Included in full purchase)

      GROUPBY PIVOTBY

    9. (Included in full purchase)

      LET

    10. (Included in full purchase)

      LAMBDA

    11. (Included in full purchase)

      Dynamic Array Quiz

  5. 5

    XLOOKUP

    1. XLOOKUP Basics Free preview
    2. (Included in full purchase)

      Additional XLOOKUP Features

    3. (Included in full purchase)

      XLOOKUP Practice

    4. (Included in full purchase)

      Wildcard Match

    5. (Included in full purchase)

      Multi Level Drop Down

    6. (Included in full purchase)

      Bonus: The Easiest Multi Row Multi Level dependent Dropdown

    7. (Included in full purchase)

      XLOOKUP Quiz

  6. 6

    Data Validation Lists

    1. (Included in full purchase)

      Data Validation List - Basics

    2. (Included in full purchase)

      Single Level Dependent Drop Down List

    3. (Included in full purchase)

      Multi Level Single Dependent Drop Down

    4. (Included in full purchase)

      Multi Level Multi Row Dependent Drop Down

    5. (Included in full purchase)

      Flagging Invalid Combinations

  7. 7

    The Data Model and 70 Million Lookups

    1. (Included in full purchase)

      Loading 5 million rows of data into Excel

    2. (Included in full purchase)

      Replacing 70 Million VLOOKUPS in the Data Model

    3. (Included in full purchase)

      Building a 3D Map

    4. (Included in full purchase)

      Data Model Quiz

  8. 8

    Dashboard Build

    1. Dashboard Build Free preview
    2. (Included in full purchase)

      Power Query Import

    3. (Included in full purchase)

      Pivot Chart

    4. (Included in full purchase)

      Grouping via Power Query

    5. (Included in full purchase)

      TOP 10

    6. (Included in full purchase)

      Card Visual

    7. (Included in full purchase)

      Connected Slicer

    8. (Included in full purchase)

      Dashboard Quiz

Student Reviews

Reviews of the in-person course

”
This is a fantastic course if you would like some tips and tricks to improve your daily productivity
M.Y.

Mining Finance Manager

This is a must - Excel has taken a giant leap, don't be left behind!
D.F.

 Oil and Gas Finance

100% recommend because it will change your life forever.
N.W.

Mining Finance

”
Excellent course with lots of practical examples and tips
P.H.

Oil and Gas Finance

”
So informative - picked up lots of new skills and tips.  Do it!
S.S

ECU - University Staff

Ready to Excel in Excel?

$USD Enroll now to unlock the full potential of Excel and revolutionize your data analysis skills.

$79.00

Enroll Now Free preview