Extract The Gender

Automate a Data Entry Form - Dynamic Arrays & Reverse Checkbox- Part A

6 Confusing Functions Having "ROW" in Their Names - SIMPLIFIED

Calculate and Visualize Date Difference in a Single Function

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