Excel Pro Tips: Visualization

COURSE DESCRIPTION: The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs. This course is all about bringing data to LIFE, using some of Excel’s most powerful visualization tools. We aren’t[…]

Read More »

Excel Pro Tips: Productivity

COURSE DESCRIPTION: The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs. In this course, the name of the game is productivity. We’ll cover a range of topics to help you[…]

Read More »

Excel Power Query, Power Pivot, & DAX

COURSE DESCRIPTION: It’s time to introduce Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re serious about business intelligence, these are essential skills to master. This course takes a project-based approach, and is designed to guide you through the entire BI[…]

Read More »

Excel Pivot Tables & Charts

COURSE DESCRIPTION: Pivot Tables are absolutely essential tools for data exploration in Excel, allowing you to instantly sort, filter, and analyze your data while keeping your source tables intact. Consider this course a master class in PivotTables and Pivot Charts. I’ll show you when, why, and how to use core[…]

Read More »

Excel Formulas & Functions

COURSE DESCRIPTION: This course is all about using formulas & functions to transform basic Excel worksheets into dynamic and powerful analytics tools. We’ll cover 75+ core functions, using hands-on demos designed to showcase why they are important and how they can be applied in a variety of ways. This isn’t[…]

Read More »

Excel Charts & Graphs

COURSE DESCRIPTION: Excel is an incredibly powerful data visualization platform for those willing to think beyond rows, columns, and primitive pie charts — and we’re here to prove it. This course provides a deep, comprehensive review of Excel’s latest data visualization tools and techniques. We’ll discuss when, why, and how[…]

Read More »

Power BI Desktop

COURSE DESCRIPTION: Microsoft Power BI is quickly becoming one of the world’s most powerful self-service business intelligence platforms, as well as an absolutely essential tool for today’s top data professionals. This course is your hands-on, project-based guide to mastering Power BI Desktop. We’ll follow a clear, systematic progression through the[…]

Read More »