Officeinstructor

Generating Alphanumeric Codes with Pattern from Your Data - Single cell Report

Inverting a List Vertically OR Horizontally using INDEX, ROWS & COLUMNS

Sum By Cell Color... The Magic Comes True Without VBA

NEW in Excel- Built in Searchable Drop lists

PRO Tip for the ISTEXT and ISNUMBER Excel Functions

Top 60 Most Useful Excel Shortcuts - With Mind Mapping ► Easily Memorizing

Create a Dynamic Fillable Form in Word to Capture User Input

Translation To Any Language in Excel - Three Amazing Methods

New Feature ►Picture In A Cell - Just Released

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

Reuse Complex Functions In Any File- AutoCorrect - No Lambda

Extract Any Function Arguments in a cell... in one step

The Amazing FILTERXML One Function Multiple Tasks

Build The Logic with Eight Nested Functions to Extract Missing Invoices

Advanced Pivot Tables Tips and Little known Secrets

How To Use The Scan Function in Excel

Stunning Visualizations with Advanced Functions and Option Buttons

BYROW-ARRAYTOTEXT- FILTER Functions- An Excel Challenge

Compare Two Lists

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

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

Get Data From PDF To Excel... A NEW Power Query Option

Get A List of Any Weekday With Date Picker and Dynamic Arrays

Copy Paste Across Multiple Devices - Cloud Clipboard

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

Extract The Gender

Extract First and Last Records - A Symphony of Dynamic Arrays

Excel SUMIF amazing Examples

A Slicer For The GROUPBY Function

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

Reversing Data in 2 Directions With a Power Query Trick

Scroll Bar and Spin Button for a Dynamic Excel Chart

Create a List of Sheet Names using Power Query... With 2 ways Navigation

Check Boxes- Many Uses

Interactive Sheet Tab Names - Hot Excel Topic

GROUPBY a Range of Dates - Better Than a Pivot Table

Two Drop Lists in A Single Cell - Amazing Data Validation

Create Multiple Folders From Excel Data

Conditional Sum for Visible Rows ONLY - when SUMIF Fails

Calculate and Visualize Date Difference in a Single Function

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

The Bible of Excel - The 3 Golden Rules of Excel

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

Get Data From Dates with Single Excel Function or Power Query

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

Become A Millionaire - The REDUCE Function - Select an option

A Horizontal Line in Word Documents.mpg

GROUPBY Function The Basics and Beyond

Single Cell Report - Create Advanced Excel Functions Like A Charm

Data From picture! New in Excel

Lookup Last Non Empty Cell Value in Column or Row - Six Methods