Excel Bootcamp

Build a Sankey Diagram in Excel using a Free Chart Add-in

How to calculate Multi-tier commission in Excel - Tiered Structure

How to Calculate Sales Commissions in Excel - Fully Automated!

Excel SUBSTRING Function - Extract Text Between Two Delimiters

Excel FREQUENCY Function - Build Dynamic Frequency Tables Fast!

Rank your Data in Excel using RANKFILTER function – Dynamic & Easy!

Excel Find & Replace Multiple Words - Like a Pro - Meet SUBSTITUTE ALL

Excel LAMBDA Function – WHY LAMBDA MATTERS

How to Create Random Numbers in Excel - Get unique random numbers

Excel Percentile Rank Formula using colors and Conditional Formatting

Excel List the most frequent occurrence name or number from the dataset

Dynamic Ranking Formula - Auto-Update Ranks & Filter Data in Excel

Count values across multiple ranges based on a criteria - COUNTIF multiple ranges

Calculate Longest Winning Streak in Excel - How To Model Win Loss Streaks

Find and Show Protected Cells Instantly! - Check Locked or Unlocked cells in Excel

How to Fill cell with RGB color - Excel Formula to find the cell color value - Excel Trick

Excel Trick: Filter Data Between Two Numbers – Extract Rows with Criteria

Excel Tip: Split Excel Worksheet into Multiple Worksheets Based on Column Value [Free Add-in]

Compare Multiple Columns in Excel - Find & Exact Row Matches - Excel Hack!

Lookup & Return Multiple Values in a Single Cell in Excel - The Ultimate Trick

Extract numbers from cell in Excel (First, Last, Nth, or All) FAST!

Compare Two Lists in Excel – Find Matches and Differences Easily

Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel

How to Add Leading Zeros in Excel | Formula to Keep Zeros at a Certain Length

How to SUM data between two numbers - Excel Formula

Excel Tip: How to count unique dates in Excel - Easy Formula

Change Shape Color Based on cell value - Excel Dashboard Card Layout

How to use Excel CONTAINS function – Check IF a value exists in a range

Excel IF Function: How to Check If a Cell Contains Text (Exact & Partial Match!)

How to install an Excel Add-in - Step-by-step Tutorial