CHAR and CODE Functions Can Do Magic- Excel Tips and Tricks

Type on a Slide During a PowerPoint Slide Show

Become A Millionaire - The REDUCE Function - Select an option

Get Data From Dates with Single Excel Function or Power Query

Create a List of Workdays in Excel - Either Static or Dynamic

PRO Tip for the ISTEXT and ISNUMBER Excel Functions

List To Matrix - Pivot Tables FAIL but Functions Can DO It

The Bible of Excel - The 3 Golden Rules of Excel

GROUPBY a Range of Dates - Better Than a Pivot Table

A Slicer For The GROUPBY Function

GROUPBY Function The Basics and Beyond

Conditional Sum for Visible Rows ONLY - when SUMIF Fails

Interactive Sheet Tab Names - Hot Excel Topic

Interactive Custom Format Visualizing Data in Excel

Two Drop Lists in A Single Cell - Amazing Data Validation

Python vs Power Query or VSTACK for Combining Tables

How To Use The Scan Function in Excel

Combine Files with Inconsistent Headers No Mapping Table

Power Query Hack vs Pivot Table with Dynamic Arrays - Excel Report

Scroll Bar and Spin Button for a Dynamic Excel Chart

Stunning Visualizations with Advanced Functions and Option Buttons

Extract First and Last Records - A Symphony of Dynamic Arrays

WRAPROWS & RANDARRAY 👍 to Create Random Teams from A List of Names

Interactive Charts with Reaction Labels- Impress Your Boss

Progressive Data Bar Impress Your Audience

Intelligent Data Validation 👍 - The WOW Technique 😮

Multiply Your Dashboard Space with A Combo Box

Pivot tables From Data Types and Pictures - New in Excel

My Best 22 Pivot Tables Tips and Tricks - Master Pivot Tables

Reuse Complex Functions In Any File- AutoCorrect - No Lambda