From Manual to Automatic: Formula Essentials for Efficiency (8:51)
Discover essential techniques, from calculating totals to locking cell references with dollar signs, for more efficient and accurate spreadsheets.

Forecast Customer Trends with Churn Rates (8:22)
This tutorial walks you through using formulas to simulate real-world customer growth scenarios, track trends, and predict long-term outcomes.

Build Dynamic Spreadsheets for Real-World Scenarios (5:02)
Learn how to create a dynamic model, using functions like AVERAGE and RANDBETWEEN to calculate weighted values that update automatically with changes.

Production Planning: Using MIN and INT Functions (3:58)
This video demonstrates step-by-step how to optimize production outputs by setting up dynamic formulas and leveraging Excel’s MIN and INT functions.

Real-World Excel Skills: Diving Scores Explained (2:53)
Explore Excel’s power in real-world applications by calculating Olympic diving scores using functions like LARGE and SUM to analyze data efficiently.

Economic Insights: Learn to Compute the Gini Index (9:45)
Learn how to compute the Gini Index, a key measure of income inequality. This tutorial covers advanced functions like SUMPRODUCT and order of operations for building accurate models.

Master Excel Functions to Build Custom Tables (4:39)
This video demonstrates how to use basic formulas like ROUND to calculate BMI and transform data into actionable custom charts.

Explore Currency Valuation with Simple Formulas (8:11)
Learn how to calculate the Big Mac Index and analyze whether global currencies are overvalued or undervalued compared to the US dollar.

Modeling Supply and Demand: A Hands-On Guide (7:36)
Learn how to model supply and demand curves, calculate equilibrium prices and quantities, and visualize the impact of external factors like taxes with dynamic charts.

Visualizing Total and Variable Costs Using Charts (5:17)
Learn how to calculate and graph cost curves, including total, variable, and marginal costs, to better understand production efficiency and decision-making.

Retirement Planning: Calculate Your Savings Growth(5:38)
Learn how to model your retirement savings, calculate monthly returns, and track how consistent contributions grow into significant wealth over time.

Learn to Balance Resources Using Excel Tools (3:22)
This video shows you how to build a simple yet powerful Excel model to analyze populations (of fish) and visualize the impact of different harvesting strategies.

Understand Loan Payments with Simple Excel Tools (4:30)
Learn how to create an amortization schedule that calculates monthly payments, splits interest and principal, and tracks the loan balance over time.

Depreciation Methods: Straight Line, Units, and Sum of Digits (7:43)
Discover how to use Excel to calculate asset depreciation with practical examples of straight-line, units of production, and accelerated methods.

Analyze Customer Patterns with the Gravity Model (7:45)
Learn how to use the Gravity Model to predict store traffic based on store size and travel times, a tool used by major retailers like Walmart and Target.

Modeling the Butterfly Effect and Fibonacci Sequence (5:29)
Discover how small changes in initial conditions lead to dramatic results with the Butterfly Effect, and explore the beauty of Fibonacci numbers converging to the Golden Ratio—all in Excel.

Master Pricing Strategies (6:48)
This tutorial walks you through dynamic formulas to explore price elasticity, optimize product pricing, and predict sales volumes and profits.

Understand Financial Variances: Volume, Mix, and Price (7:17)
This tutorial demonstrates how to analyze financial variances, using formulas to calculate the impact of sales volume, product mix, and pricing changes on profitability.

Learn VLOOKUP and Simplify Your Spreadsheets (10:03)
Learn how to use the VLOOKUP function to retrieve data quickly and accurately, with practical examples for tax rates and product prices.

Mastering HLOOKUP: Simplify Horizontal Data Retrieval (3:03)
Learn how to use the HLOOKUP function to retrieve data horizontally from row-based datasets with real-world examples like sales and employee records.

Pricing Hacks: Lookup Product Prices Based on Dates (3:48)
Learn how to use VLOOKUP with approximate matches to automate product pricing based on date ranges. Perfect for seasonal pricing, promotions, and historical cost tracking.

Master VLOOKUP Across Worksheets: Combine Data Effortlessly (3:27)
Learn how to use VLOOKUP to combine data from multiple worksheets, streamlining your workflow and saving time on manual data management.

Automating Vertical Lookups Across Multiple Columns (3:15)
This tutorial covers automating vertical lookups across multiple columns, teaching you how to use helper cells and formula automation for efficient data management.

Master the INDEX Function: Simplify Data Retrieval (2:58)
Learn how to use Excel’s powerful INDEX function to retrieve specific data from tables or arrays, with real-world examples like finding the distance between cities.

How to Use INDEX to Retrieve and Sum Rows or Columns (4:04)
Explore the advanced capabilities of the INDEX function, including retrieving rows or columns dynamically and combining it with SUM for real-world applications.

Mastering the MATCH Function: Find Data with Precision (6:53)
Learn how to use the MATCH function to locate data quickly and efficiently, with examples covering exact matches, approximate matches, and partial lookups using wildcards.

Master Two-Way Lookups with MATCH and INDEX (5:00)
Learn how to combine the MATCH and INDEX functions to perform powerful two-way lookups, perfect for retrieving specific data from large tables.

Master Advanced Lookups with INDEX, MATCH, and LARGE (4:11)
This tutorial shows how to combine INDEX, MATCH, and LARGE to dynamically analyze data, providing powerful insights into ranked lists and datasets.

Retrieve the Latest Dates Dynamically (4:45)
Learn how to use the MATCH and INDEX functions to dynamically retrieve the most recent sale date before or equal to a specified date, even in large datasets.

How to Calculate Cost-of-Living Adjusted Salaries Using VLOOKUP (2:40)
Learn how to use VLOOKUP to calculate cost-of-living-adjusted salaries and compare earnings across different states dynamically and efficiently.

Master Currency Exchange Using INDEX and MATCH (4:30)
Learn how to build a dynamic currency converter using INDEX and MATCH functions, enabling real-time conversions between any two currencies in your dataset.

How to Model Population Growth (6:49)
Learn how to forecast the future age distribution of the US population, leveraging powerful functions like VLOOKUP and advanced modeling techniques.

Master the CHOOSE Function and Declutter Your Spreadsheets (6:46)
Learn how to master Excel’s CHOOSE function, a powerful alternative to VLOOKUP and INDEX-MATCH, to simplify your formulas and declutter your spreadsheets.

Simplify Complex Calculations with VLOOKUP (7:07)
Learn how to use VLOOKUP to calculate federal income taxes by breaking down tax brackets and automating complex calculations.

Math is Fun: Exploring Beautiful Results (4:11)
Explore three stunning mathematical principles, including the sum of cubes, odd numbers, and multiplication tables, and see how math and formulas come to life.

Understanding the Rule of 72: A Simple Guide to Doubling Your Money (3:52)
Learn how to use Excel to illustrate the Rule of 72, a powerful tool for estimating how long it takes to double your money based on annual growth rates.

Convert PDF Data to Excel: A Simple, Free Method (2:18)
Learn how to extract tables from PDF files and transfer them into Excel effortlessly using Word—no expensive software required.

Use Excel to Illustrate an Amazing Math Proposition (2:12)
Explore how Excel can test a fascinating math rule: multiplying 4 consecutive integers, adding 1, and always finding an odd perfect square.

Explaining Google’s PageRank Algorithm (4:52)
Explore the basics of Google’s PageRank algorithm and learn how to simulate its ranking process step by step.

XLOOKUP Explained: The Ultimate Replacement for VLOOKUP and HLOOKUP (6:36)
Learn how to use Excel’s XLOOKUP function to perform fast, flexible data lookups and replace outdated tools like VLOOKUP and HLOOKUP.

How to Use XLOOKUP’s Match Modes for Advanced Lookups (4:01)
Discover how to use XLOOKUP’s match modes (-1, +1, and 0) to perform advanced lookups, assign grades, and retrieve multiple columns of data effortlessly.

XLOOKUP vs. INDEX MATCH: The Easy Way to Do Two-Way Lookups (1:56)
Master Excel’s XLOOKUP function to perform two-way lookups effortlessly, saving time and reducing complexity compared to INDEX/MATCH.

XLOOKUP in Action: Summing Dynamic Ranges with Ease (2:13)
Learn how to use Excel’s XLOOKUP function to define dynamic ranges and perform calculations like sums, averages, and more.

Range Names Explained: Make Formulas More Understandable (4:16)
Discover how range names simplify your Excel formulas by making them more readable and easier to manage.

Step-by-Step Guide to Create and Manage Range Names (5:00)
This video explains how to assign meaningful names to cells or ranges using Excel’s Create Name from Selection feature.

How to Use Excel’s F3 Trick for Range Names (3:25)
Learn how to use Excel’s F3 key to paste range names into formulas, making your data management faster and more intuitive.

How to Reference Entire Rows and Columns in Formulas (2:45)
This video demonstrates how to use range names to calculate averages and other metrics for entire rows or columns.

How to Apply Range Names to Existing Formulas (3:24)
Learn how to apply range names to existing formulas, making them easier to read and manage.

Workbook vs. Worksheet Range Names: What You Need to Know (2:35)
Learn the difference between workbook and worksheet-level range names, and discover how to use them for smarter formulas.

Advanced Range Name Techniques You Need to Know (4:09)
Discover how dynamic range names can make your formulas easier to read, reduce errors, and improve collaboration.

How to Use Implicit Intersection for Data Lookups (2:04)
Learn how to use Implicit Intersection to retrieve data dynamically by combining row and column names, simplifying your formulas.

Using Range Names for Dynamic Lookup Formulas (1:53)
Learn how to use range names to simplify lookup formulas, eliminate dollar signs, and improve formula clarity and efficiency.

How to Clean and Organize Data with Text Functions (9:51)
Learn how to use Excel’s powerful text functions—like Trim, Left, Right, Mid, and Concatenate—to clean, split, and organize your data effortlessly.

Mastering Text Functions: Split and Organize Data (6:27)
Learn how to use Excel’s Find Function and Text to Columns to split and organize messy datasets, improving clarity and efficiency.

Visualize Data Using the REPT Function (2:22)
Learn how to use Excel’s REPT function to create quick and simple text-based histograms, perfect for survey results or ratings.

Master Data Cleaning with Clean and Substitute Functions (8:45)
This video demonstrates how to fix invisible character issues with the Clean and Substitute functions, ensuring your data is usable for analysis.

Mastering Flash Fill: The AI-Powered Tool (2:24)
Discover how to use Excel’s Flash Fill feature to automate repetitive text tasks like splitting names, formatting emails, and extracting numeric data.

How to Use Ctrl + E for Reliable Flash Fill Results (1:10)
Learn how to use Excel’s Ctrl + E shortcut to fix Flash Fill errors, ensuring fast and accurate data cleanup and splitting.

Master Text Extraction with FIND and SUBSTITUTE (4:56)
Learn how to extract the last word from any cell using the FIND, SUBSTITUTE, and RIGHT functions, perfect for large datasets.

How to Perform Two-Column Lookups with VLOOKUP and Text Functions (2:17)
Learn how to perform two-column lookups using concatenation and VLOOKUP, perfect for retrieving data based on multiple criteria.

How to Use SUBSTITUTE and RIGHT for Fast Data Reformatting (2:57)
This video demonstrates how to automate data cleanup and reformatting tasks with SUBSTITUTE, RIGHT, and other text functions.

Master Unicode Characters and Hyperlinks for Smarter Spreadsheets (2:37)
Discover how to use Excel’s Unicode and Hyperlink functions to unlock over 120,000 characters for math, languages, and interactive spreadsheets.

Master Text Functions for Fast List Creation (2:47)
This video demonstrates how to use text functions like CONCATENATE and TEXTJOIN to quickly create and compile lists.

Mastering the TEXT Function: Dates, Numbers, and More (6:18)
Learn how to use Excel’s TEXT function to format dates, numbers, and concatenate clean, professional data outputs.

Rounding Numbers for Cleaner Calculations (9:29)
Discover how to master rounding functions for accurate, professional-looking data, whether for financial models or engineering calculations.

Preserving Leading Zeros and Special Formats (2:26)
This video demonstrates how to preserve leading zeros and apply special formats to ensure zip codes, phone numbers, and more are displayed correctly.

How to Fix VLOOKUP Errors Caused by Invisible Characters (4:02)
Learn how to fix VLOOKUP errors caused by invisible characters using Excel’s Flash Fill and FIND functions in this step-by-step video.

Mastering Date Functions: From TODAY to NETWORKDAYS (10:51)
Discover how date functions simplify calculations for workdays, deadlines, and schedules with powerful tools like WORKDAY and NETWORKDAYS.

Use DATEDIF for Accurate Time and Date Analysis (1:43)
Learn how to use Excel’s hidden DATEDIF function to calculate exact years, months, and days between two dates for accurate time management.

How to Insert Static Dates and Times (1:19)
Learn how to insert static dates and times using simple keyboard shortcuts, perfect for tracking spreadsheet creation times.

Use EOMONTH and EDATE for Accurate Date Management (2:39)
Learn how to use Excel’s EOMONTH and EDATE functions for dynamic date calculations, perfect for managing end-of-month dates and monthly adjustments.

Identify the Week of the Year with WEEKNUM (3:14)
Learn how to use Excel’s WEEKNUM function to calculate the week of the year for any date and customize week definitions.

How to Use the TIME Function for Precision Calculations (2:33)
Learn how Excel handles time as fractions of a day and master functions like TIME, HOUR, MINUTE, and SECOND to calculate and extract time components.

How to Calculate Time Intervals with TIMEVALUE (4:33)
Learn how to use Excel’s TIMEVALUE function and calculate time differences, including handling intervals across days, with practical examples.

Managing Hours, Minutes, and Time Formats (3:11)
Learn how to add hours, sum durations, and create time sequences while solving common formatting issues.

Build and Edit Custom Lists for Speedy Workflows (2:34)
Learn how to create custom lists to automate repetitive tasks, like filling in US cities or standard data entries, for faster workflows.

Find Holiday Dates Dynamically Using WEEKDAY and INDEX (3:24)
Learn how to calculate holidays using WEEKDAY, MATCH, and INDEX functions for dynamic date calculations.

Master Financial Decision-Making with NPV (7:22)
Learn how to calculate Net Present Value (NPV) to evaluate investments and compare cash flows, using functions like NPV and discount rates.

Mastering XNPV: Smarter Investment Calculations (5:13)
Learn how to use Excel’s XNPV function to calculate Net Present Value for non-periodic cash flows and compare it with NPV.

Compare Investments Using the IRR Function (8:15)
Learn how to calculate Internal Rate of Return (IRR) and understand its importance in evaluating investments and projects.

Calculate MIRR for Investments with Different Borrowing and Reinvestment Rates (2:44)
Learn how to calculate Modified Internal Rate of Return (MIRR) and understand why it’s better than IRR for investments with varying rates.

Evaluate Investments Like a Pro with XIRR and MIRR (5:27)
Learn how to use Excel’s XIRR and MIRR functions to calculate returns for irregular cash flows and account for borrowing and reinvestment rates.

Retirement Planning Made Easy with Excel’s PV and FV Formulas (6:56)
Learn how to use Excel’s Present Value (PV) and Future Value (FV) functions to plan investments, calculate savings, and analyze annuities effectively.

Mastering Loan Analysis with Excel’s Financial Functions (9:48)
This video demonstrates how to use Excel’s financial functions to analyze mortgage payments, create amortization schedules, and plan loans effectively.

Mastering FVSCHEDULE: Calculate Future Value with Changing Rates (1:05) Learn how to use Excel’s FVSCHEDULE function to calculate future value for investments with varying annual interest rates.

Mastering Loan Period and Rate Calculations (6:44)
This video demonstrates how to analyze loans using Excel’s RATE and NPER functions, perfect for mortgage and personal finance management.

How to Use Excel’s PMT Function to Analyze Annual Loan Payments (2:36)
Master Excel’s PMT function to understand loan payments, percentages, and how rates and terms impact annual costs.

Mastering Bond Valuation with Excel Financial Tools (3:14)
This video demonstrates how to simplify bond pricing using Excel’s financial functions, perfect for finance professionals and personal investors.

Simplify Mortgage Payments and Expenses (3:16)
Learn how to use Excel’s PMT and PV functions to calculate mortgage payments, APR, and the total cost of borrowing, including points and fees.

Mastering Asset Depreciation with Excel’s Financial Tools (3:13)
Learn how to use Excel’s SLN, SYD, and DDB functions to calculate depreciation for assets quickly and accurately.

Simplify Financial Growth and Compounding Using Excel Functions (8:57)
Learn how to solve compound interest problems, from future value and present value to effective annual rates and continuous compounding.

Solve Complex Financial Problems Effortlessly (4:49)
Learn how to solve advanced financial problems, including growing annuities, present value, and future value calculations.

Learn to Manage Adjustable Rate Mortgages (2:55)
Learn how to use Excel’s PMT function to analyze adjustable rate mortgages (ARMs), calculate payments, and track principal contributions.

How to Use Excel’s Workday Function for Project Scheduling (2:19)
Learn how to use Excel’s Workday function to schedule project activities by working backward from deadlines, accounting for workdays and weekends.

Master Spreadsheet Analysis with Excel’s Audit Functions (6:07)
This video explains how Excel’s Trace Dependents and Trace Precedents functions help you manage and understand large spreadsheets.

How to Resolve Circular References Using Excel’s Iterative Tools (7:23)
Learn how to resolve circular references by enabling iterative calculations, automating updates, and managing complex formulas.

Unlock the Power of Conditional Logic with Excel’s IF Functions (7:26)
Learn how to use Excel’s IF statements to automate decisions, calculate costs, and solve real-world problems with ease.

How to Use MOD and IF Statements to Solve Real-Life Problems (4:51)
Learn how to use Excel’s MOD and IF functions to automate decisions, solve logical problems, and create dynamic formulas with ease.

Summarizing Yearly Data with Conditional Logic (1:43)
Learn how to automate annual revenue calculations from quarterly data using IF statements, keeping your summaries clean and dynamic.

Master Product Sales Projections with IF Statements (8:21)
Learn how to use IF statements to model product sales lifecycles, forecast growth, and analyze financial outcomes.

Transform Complex Tables into Manageable Rows (6:30)
This video explores how to transform multi-dimensional tables into simple rows with logical and lookup formulas.

Fix Errors with IFERROR and Aggregate Functions (5:26)
This video explains how to use the IFERROR and Aggregate functions to handle errors, automate cleanup, and improve your calculations.

Master Data Transformation with IFERROR and Nested IFs (6:35)
Master the IF and IFERROR functions to simplify complex data transformations and streamline your analysis process.

How to Use ISERROR and IF to Adjust Data Dynamically (3:28)
This video shows how ISERROR and FIND functions can help manage messy data and automate adjustments.

Streamline Data Validation Using MOD and Logical Functions (4:22)
This video demonstrates how to combine Excel’s MOD, MID, and IF functions to create a dynamic workflow for validating check numbers.

How to Determine if a Stock is Overvalued: A Microsoft Case Study (7:39)
Explore financial modeling through a real-world case study of Microsoft’s stock price. Learn NPV, XNPV, WACC, and IF functions step-by-step.

Transform Row-Based Datasets with Excel Functions (3:49)
Learn how to clean up messy datasets and organize name, address, and ZIP data into single rows using advanced Excel functions like MOD, ROW, and CONCATENATE.

Mastering Complex Commission Calculations (6:37)
Unlock the power of Excel’s nested IF statements to calculate sales commissions accurately. Perfect for handling dynamic commission plans with ease.

Creating Dynamic Sales Incentive Models (6:25)
Transform your sales data with Excel! Learn how to use advanced formulas to reward accurate forecasting and high performance.

Using IF Statements to Simplify Investment Strategies (4:26)
Learn how to model investment strategies using Excel’s IF statements. This tutorial covers call and put option payouts, combining them for profit/loss insights.

IF Functions for Real-World Scenarios (7:08)
Learn to solve real-world challenges with Excel’s IF functions, including calculating insurance premiums, modeling profits, and planning salary growth.

Decode Messages with Excel’s Advanced Functions (6:06)
Learn to create and decode Caesar’s Shift Cipher, mastering IF, VLOOKUP, and ASCII logic along the way.

Learn to Encrypt Messages Using Excel’s Rail Fence Cipher (6:06)
Learn how to use Excel to encode and decode messages with the Rail Fence Cipher, applying formulas like MID, ISODD, and CONCATENATE.

Identify Trends and Streaks in Sports Data (1:43)
This video demonstrates how to use conditional formulas to find the longest winning streak in a dataset, perfect for sports and performance tracking.

How Excel’s IF, MATCH, and MOD Functions Help Solve Math Puzzles (3:07)
This video demonstrates how Excel can be used to explore mathematical patterns by analyzing the Ducci Sequence with logical formulas.

Using Excel to Compute and Explore Rational Number Sequences (3:25)
This video explores how Excel can generate rational number sequences using recursive logic and formulas like INDEX and IF.

Health Data Meets Excel: Using Advanced Formulas to Calculate Longevity (6:32)
This video explores how Excel can predict years lost from life expectancy using a scientifically-backed formula and advanced functions.

Mastering IFERROR: The Key to Fixing Broken Formulas (2:01)
Learn how to use IF and IFERROR to prevent Excel formulas from breaking and return clean, meaningful results instead of error messages

Master the Inquire Add-In: Find Links, Errors & Formatting Issues (1:56)
Learn how to install and use the Inquire Add-In to compare workbooks, track changes, and analyze dependencies.

Find Hidden Differences Between Excel Files in Seconds (2:09)
Learn how to use Excel’s Inquire Add-In to compare workbooks, track changes, and highlight formula modifications instantly.

Discover Every Formula, Named Range, and Data Link in Your Workbook (2:12)
Learn how to use Excel’s Inquire Add-In to analyze workbooks, find linked data sources, and track every formula in seconds.

Find Hidden Connections Between Workbooks with Inquire (1:08)
Discover how the Inquire Add-In helps you audit external links, track file modifications, and troubleshoot data connections between workbooks.

Find Hidden Connections Between Worksheets with Inquire (1:14)
Learn how to use Excel’s Inquire Add-In to track worksheet relationships, find linked data sources, and analyze dependencies.

Master Cell Relationship Analysis Using Excel’s Inquire Tool (2:04)
This video shows how the Inquire Add-In helps you trace cell relationships, navigate formulas, and troubleshoot errors.

How to Fix Performance Issues with Excel’s Inquire Tool (2:03)
Learn how to use Excel’s Inquire Add-In to clean up excess formatting and optimize your workbook for better performance.

Optimize Revenue and Profit with Sensitivity Analysis (10:29)
Learn how to use Excel’s one-way data tables for sensitivity analysis, helping you evaluate how pricing changes impact revenue, costs, and profit.

Two-Way Data Tables: The Ultimate Tool for Business Decision-Making (8:23)
Learn how to use Excel’s two-way data tables to analyze the impact of pricing and unit costs on profitability, helping you make better business decisions.

Optimize Mortgage Planning with Financial Functions (5:51)
Learn how to use Excel’s PMT function and two-way data tables to analyze mortgage payments based on interest rates and loan terms.

Mastering Customer Retention and Value Analysis (11:36)
Learn how to use Excel’s data tables to calculate Customer Lifetime Value (CLV) and analyze how retention and discount rates impact business profitability.

Find the Exact Growth Rate Needed to Hit Revenue Goals (5:28)
Learn how to use Excel’s Goal Seek feature to calculate the exact input needed to reach a target outcome in business scenarios.

How to Use Goal Seek for Loan & Investment Analysis (6:42)
Learn how to use Excel’s Goal Seek tool to calculate loan interest rates and find the break-even discount rate for investment decisions.

Compare Business Scenarios Using Goal Seek & Data Tables (2:30)
Learn how to use Excel’s Goal Seek tool to calculate breakeven sales and time, helping you make better business decisions.

Scenario Planning: Forecasting Business Outcomes (6:39)
Learn how to use Excel’s Scenario Manager to compare best, worst, and most likely business cases and optimize decision-making.

Compare Down Payments & Home Value Changes (10:03)
Learn how to use data tables to calculate return on equity (ROE) for home investments and analyze risk vs. reward.

How to Use Excel to Plan and Manage Projects More Efficiently (6:53)
This video demonstrates how sensitivity analysis helps project managers find potential delays and optimize efficiency.

How to Use Excel’s Data Tables for Smart Investment Planning (11:01)
Learn how to use Data Tables to hedge stock investments and protect your portfolio from major losses.

How Probability & Expected Value Shape Winning Strategies (9:20)
This video shows how win probability, expected value, and game theory played a role in one of the most controversial calls in NFL history.

Mastering Time-Based Data Analysis with Excel’s What-If Tools (4:50)
Explore how Excel’s automation tools help businesses, researchers, and analysts track records over long timeframes with ease.

Use Excel to See How Price & Costs Affect Profitability in Real Time (2:56)
Learn how to create a dynamic chart from a two-way data table to visually analyze how price and unit costs impact profitability.

Use Excel’s Data Tables to Optimize Your Investment Strategy (6:08)
Discover how to reduce risk and optimize returns using shorting, long positions, and market-neutral strategies.

One of Math’s Greatest Unsolved Problems—Solved in Excel? (2:36)
This video demonstrates how Excel’s logic functions and data tables can model one of the greatest unsolved problems in mathematics.

How to Calculate Bond Prices and Yields (4:47)
Learn how to use Excel’s financial functions and Data Tables to analyze the relationship between bond price and yield.

How to Create a Data Table Across Multiple Worksheets (2:41)
Learn how to overcome Excel’s Data Table limitations by linking inputs and outputs across different worksheets with a simple trick.

How to Use COUNTIF & COUNTIFS to Analyze Large Data Sets (9:09)
Discover how COUNTIF & COUNTIFS help you analyze trends, filter information, and make data-driven decisions with ease.

COUNT vs. COUNTA vs. COUNTBLANK – What’s the Difference? (2:14)
Learn how to use COUNT, COUNTA, and COUNTBLANK to summarize data and find missing values.

Excel’s Most Powerful Conditional Functions Explained (7:15)
Discover how to summarize your data in seconds using SUMIF(S) & AVERAGEIF(S) to find totals and averages based on specific conditions.

Summing Data the Smart Way: Handling Duplicates (5:22)
This video explains how data cleaning and SUMIFS can improve the accuracy of your reports, financial models, and dashboards.

Mastering Subtotals: How to Summarize Data Instantly (8:40)
This video demonstrates how subtotals allow you to create quick summaries without complex formulas.

Mastering the SUBTOTAL Function for Smarter Summarizations (3:00)
Learn how to use the SUBTOTAL function to summarize data dynamically while filtering or hiding rows.

The Secret to Dynamic Reporting: Counting Colored Cells with SUBTOTAL (1:19)
Explore how color-based analysis can improve data tracking for projects, sales, and reporting.

Sorting Subtotals: The Secret to Organizing Data Like a Pro (1:40)
This video demonstrates how to combine sorting and subtotals to create structured, easy-to-read reports.

How to Combine & Summarize Data from Multiple Workbooks (3:55)
Learn how to use Excel’s Data Consolidate feature to merge and summarize data across multiple worksheets and workbooks.

Summing Data from Different Sheets Without Pivot Tables (1:48)
Discover how Excel’s Data Consolidate tool allows you to create dynamic summaries across multiple sheets.

How to Visually Compare Reports, Teams, or Metrics (1:48)
This video explains how to merge and organize data from different sheets for clear, structured comparisons.

How to Use Database Functions for Advanced Filtering & Summarization (12:14)
Learn how to use Excel’s database functions like DSUM, DCOUNT, and DAVERAGE to summarize and filter large datasets efficiently.

Discover How to Apply Logical Conditions to Summarize Data Effectively (5:10)
Discover how to create computed criteria that adjust based on real-time conditions for better decision-making.

Extracting Specific Data from Large Tables Using the DGET Function (2:53)
Learn how to use Excel’s DGET function to retrieve specific data from a database based on multiple criteria.

Mastering the Advanced Filter: Extract & Summarize Data (3:42)
This video demonstrates how to apply a criteria range to filter data based on multiple conditions.

The Secret to Summing & Counting Only Non-Blank Data (3:18)
Discover how to sum only non-blank rows and refine your data analysis with advanced criteria.

Applying Conditional Counts & Sums to Spot Anomalies in Data (3:51)
Explore how to identify suspicious patterns in data using Excel’s powerful analytical tools.

Mastering Advanced Lookups: Finding Any Occurrence of a Value in Data (5:17)
This video explains how to retrieve any match of a value dynamically, rather than just the first occurrence.

How to Analyze Sports Data & Improve Strategy (5:22)
Explore how to use Excel’s logic functions to extract meaningful insights from sports statistics.

The Hidden Power of SUMPRODUCT for Data Analysis (6:01)
Explore how SUMPRODUCT can help Excel users filter, count, and sum data more efficiently.

Mastering SUMPRODUCT: The Easiest Way to Count Sports Wins & Losses (2:52)
Discover how to apply logical conditions to count and summarize winning records using SUMPRODUCT.

Mastering COUNTIFS & SUMIFS for Multi-Condition Data Filtering (5:04)
Learn how to apply OR logic to COUNTIFS, SUMIFS, and AVERAGEIFS for multi-condition data filtering.

The Secret to Summarizing Sales by Product & Store Using SUMIFS (5:05)
Learn how to use SUMIFS to compute total sales by product, store, and date range.

Mastering COUNTIF & COUNTIFS for Election Data Analysis (2:56)
Learn how to use COUNTIF & COUNTIFS to analyze ranked choice voting results.

How to Use Conditional Formatting to Highlight Key Insights (6:25)
Learn how to use Conditional Formatting to highlight top, bottom, and above-average data points.

How to Use Excel’s Highlight Cells Rules for Smarter Analysis (9:40)
Learn how to use Conditional Formatting’s Highlight Cells Rules to automatically detect key data points.

Highlight Trends & Insights Instantly Using Excel’s Built-In Features (11:40)
Learn how to use Data Bars, Color Scales, and Icon Sets to visually summarize data and highlight trends.

How to Use Excel’s Conditional Formatting Formula Option for Smart Analysis (7:52)
Discover how conditional formatting with formulas can enhance your data visualization and decision-making.

Master Conditional Formatting with Advanced Formula Tricks (10:10)
This video explains how to apply LARGE, SMALL, and AND functions to format cells and rows based on numerical conditions.

Excel’s Hidden Feature: Stop If True for Advanced Data Formatting (3:51)
Discover how Stop If True allows you to control how and when formatting rules are applied.

Avoid Data Entry Mistakes with Smart Excel Rules (6:04)
This video explains how to restrict values, create dropdown lists, and ensure accurate data entry using Excel’s validation tools.

Advanced Data Validation: Keep Your Spreadsheets Clean and Accurate (4:48)
Explore how to use custom validation rules to control input values and maintain data accuracy.

How to Prevent Duplicate Entries with Data Validation (3:24)
This video walks you through how to block repeated entries using COUNTIF and Data Validation.

Master Data Validation: Automatically Find and Highlight Invalid Entries (2:00)
Learn how to use Excel’s Circle Invalid Data tool to instantly find and highlight entries that don’t meet your set criteria.

Use Excel to Compare Lists and Highlight New Data (1:50)
Learn how to use Conditional Formatting and COUNTIF to highlight new data entries automatically.

Master Conditional Formatting: Data Bars, Color Scales & Icons (7:17)
Learn how to use Excel’s Conditional Formatting tools like data bars, color scales, and icons to highlight key trends in your spreadsheets.

Automatically Format Data Based on Multiple Criteria (11:13)
Discover how to apply Conditional Formatting with logical formulas to highlight key data.

Mastering Excel’s Formatting Rules for Financial Auditing (5:50)
Learn how to use Excel’s Conditional Formatting to detect fraud by identifying unusual transaction patterns and duplicate invoices.

How to Set Up Multiple Worksheets with One Click (2:11)
This video demonstrates how to automate worksheet setup by formatting multiple sheets at once, saving hours of manual work.

How to Use 3D Formulas to Summarize Data Across Multiple Worksheets (2:32)
This video demonstrates how to reference multiple worksheets in one SUM formula, saving time and reducing errors.

Automatically Sum Data Across Worksheets Based on Sheet Name (2:17)
Learn how to use wildcards in Excel’s 3D SUM formula to sum only the worksheets that match specific names automatically.

Excel’s Paste Special Tricks That Will Change How You Work (6:48)
This video walks through how to use Paste Special tricks to speed up data formatting and calculations.

How to Use Tables for Auto-Updating Formulas & Formatting (5:45)
Learn how to use Tables to automatically update formulas, formatting, and charts, making your spreadsheets more efficient.

Stop Updating Graph Ranges Manually—Use This Trick! (3:11)
Learn how to use Tables to make your charts auto-update whenever new data is added—no manual adjustments needed!

How to Use Table Slicers for Instant Data Filtering (6:57)
This video demonstrates how Excel’s table features, filters, and slicers can transform how you organize and present data.

Mastering Tables: The Secret to Dynamic, Self-Updating Data (9:04)
This video demonstrates how Excel’s Tables feature can improve your workflow by making formulas, charts, and lookups dynamic and self-updating.

The Secret to Accurate Summing When Using Slicers (3:53)
Learn how to use the AGGREGATE function to fix incorrect totals when filtering data with slicers.

Why Your Conditional Formatting Isn’t Updating—And How to Fix It (3:34)
Learn how to fix conditional formatting issues in tables and ensure your formatting updates dynamically as new data is added.

How to Copy Formulas Across a Table Without Errors (2:39)
Discover why dragging formulas sometimes fails and how to fix it.

How to Use MOD, VLOOKUP, and ROW Functions for Cryptography (5:59)
Learn how to use Excel to encrypt and decode messages with the Vigenère Cipher.

How to Filter Charts Dynamically Using Table Slicers (2:04)
Use Excel’s slicers to filter sales charts without losing data.

How to Master Pivot Tables (Even If You’re a Beginner) (9:39)
Discover how to create Pivot Tables that summarize large datasets instantly.

Master PivotTables: Find Your Best Customers and Analyze Revenue Trends (6:31)
Discover how PivotTables help businesses identify their most profitable customers and automatically update when new data is added.

How to Use Text Filters in Pivot Tables for Smarter Data Analysis (1:44)
This video covers how to apply text-based filters in pivot tables to refine your reports and focus on key insights.

Pivot Table Grouping: A Smarter Way to Summarize Data (5:34)
Learn how to use Pivot Table grouping and Pivot Charts to summarize and visualize data for faster, better decision-making.

How to Use Value Field Settings and Show Values As in Pivot Tables (5:20)
Learn how to use Value Field Settings and Show Values As in Pivot Tables to customize how data is summarized and displayed.

Stop Doing Manual Math! Use Calculated Fields in Pivot Tables (6:03)
Learn how to use Calculated Fields in Pivot Tables to create custom formulas and analyze your data more efficiently.

How to Use Slicers and Filters in Pivot Tables for Better Analysis (4:04)
Learn how to use Pivot Table filters and Slicers to quickly select, filter, and analyze data.

Mastering GETPIVOTDATA: The Key to Smarter Reporting (7:20)
Learn how to use GETPIVOTDATA to dynamically extract data from Pivot Tables and create smarter reports.

Mastering Calculated Items: A Smarter Way to Summarize Data (4:33)
Learn how to use Calculated Items in Pivot Tables to create custom formulas and analyze grouped data more efficiently.

How to Fix Calculation Errors in Pivot Tables Using Solve Order (3:45)
Learn how to use Solve Order in Pivot Tables to control how Excel calculates formulas and ensure accurate results.

Master Pivot Table Timelines: The Best Way to Filter Data by Date (2:57)
Learn how to use Pivot Table Timelines to quickly select, filter, and analyze data over specific time periods.

Pivot Tables for Surveys: How to Summarize and Visualize Responses (3:50)
Learn how to use Pivot Tables to analyze survey data, summarize responses, and create insightful reports.

The Fastest Way to Combine Multiple Datasets in a Pivot Table (5:51)
This tutorial covers how to combine data from different sheets into a single Pivot Table for better analysis.

Pivot Table Trick: Create Multiple Reports with One Click (1:09)
This tutorial covers how to quickly create separate Pivot Table reports for each category in your dataset.

How to Use Excel’s Data Model to Connect Multiple Tables in Pivot Tables (5:47)
Learn how to use Excel’s Data Model to create relationships between multiple tables and analyze data without VLOOKUP.

Using Pivot Tables for Advanced Data Analysis (8:51)
This tutorial covers how to break down sports data using Pivot Tables, from team performance to player contributions.

Mastering Sports Analytics: Pivot Tables for NBA Data (8:15)
Learn how to use Pivot Charts and Slicers to analyze NBA player stats and team performance.

The Secret to Finding Patterns in data with Pivot Tables (3:04)
Learn how to use Pivot Tables to analyze birth trends, compare C-sections vs. normal births, and find hospital patterns.

Breaking Down Elections with Pivot Tables: Why Votes Don’t Always Equal Seats (3:06)
Learn how to use Pivot Tables to analyze election results, uncover voting trends, and understand how districting impacts congressional outcomes.

The Science of Attraction: How Pivot Tables Reveal Dating Trends (3:17)
This tutorial explores dating data insights using Pivot Tables, revealing patterns in who men and women find attractive.

Simpson’s Paradox: Why Averages Can Be Misleading – Pivot Tables in Action (3:53)
This tutorial covers how aggregate statistics can be deceptive and how Pivot Tables help reveal the true story behind the data.

Pivot Tables, SUMIFS, and VLOOKUP – A Real-World Business Case Study (11:23)
Learn how to solve a real-world sales and tax problem using Pivot Tables, SUMIFS, VLOOKUP, and more.

Mastering Pivot Tables: Breaking Down Voter Demographics Instantly (4:46)
See how to filter and visualize election results using Excel’s most powerful analysis tools.

How to Set Default PivotTable Settings and Save Time (2:00)
Learn how to change your PivotTable default settings to save time and create consistent reports effortlessly.

Mastering Slicers: Filter Multiple PivotTables with One Click (2:41)
Learn how to use one slicer to filter multiple PivotTables at once, making your reports more interactive and efficient.

How to Apply Conditional Formatting in PivotTables for Instant Insights (4:43)
Learn how to apply conditional formatting in PivotTables to highlight key trends and data insights instantly.

Fixing Unrecognized Dates in PivotTables: A Simple Trick (2:55)
This video shows you how to fix unrecognized dates using functions like LEFT, RIGHT, VALUE, and DATE.

Mastering PivotTables: Analyzing Bitcoin Returns by Year and Month (3:58)
This video shows you how to break down Bitcoin price data using PivotTables for deeper insights.

The Secret to Summarizing Data Faster Using PivotTable Calculated Fields (3:43)
Learn how to use calculated fields in PivotTables to automate sales analysis and eliminate manual calculations.

The Secret to Tracking Customer Satisfaction with PivotTables (2:53)
Master PivotTable custom grouping to analyze business performance metrics like Net Promoter Score.

How to Move a PivotTable Without Breaking Your Report (1:48)
Discover two game-changing Excel features that let you format individual PivotTable cells and move PivotTables effortlessly.

Mastering Histograms: A Step-by-Step Guide (5:19)
This video walks you through building and formatting histograms using Excel’s Data Analysis Toolpak.

How to Interpret Histogram Shapes for Data Analysis (5:41)
This video walks you through common histogram distributions and how they impact real-world data interpretation.

Mastering Descriptive Statistics – Mean, Median, Mode & More (14:12)
Learn how mean, median, variance, and skewness help you summarize data effectively.

The Secret to Understanding Data with Mean & Standard Deviation (7:21)
This video covers how to calculate standard deviation and use it to interpret data distributions.

Ranking & Percentiles: Analyze Data Like a Pro (9:07)
Learn how the PERCENTILE and RANK functions help you analyze trends and performance.

How to Take a Random Sample – Mastering RAND, RANK & VLOOKUP (5:12)
Learn how the RAND, RANK, and VLOOKUP functions help create a truly random sample.

How the U.S. Decides Congressional Seats – An Excel Breakdown (5:12)
Discover how ranking and rounding impact decision-making in politics and data science.

The Data Science Behind Dating – Learn It in Excel (13:33)
This video covers how online dating sites use weighted scoring and standard deviations for matchmaking.

How to Make the Best Decision Using Excel – Multi-Objective Decision Making (3:28)
Learn how the SUMPRODUCT and RANK functions help make data-driven decisions.

Has Income Really Grown? Let’s Look at the Data in Excel (8:19)
Learn how pivot tables and descriptive statistics functions help analyze U.S. income trends.

How to Calculate Mean, Variance & Standard Deviation for Grouped Data (3:33)
Learn how to calculate mean, variance, and standard deviation for grouped data using the SUMPRODUCT function.

The Hidden Power of Histograms – Spotting Anomalies in Data (3:04)
Learn how histograms can reveal anomalies in reported data and detect potential manipulation.

How to Analyze Salaries (6:03)
Learn how histograms and box plots help analyze salaries.

How to Predict Business Costs with Regression (10:13)
Learn how to use scatter plots, trend lines, and regression analysis to predict business costs.

Skip the Charts—Use Excel’s SLOPE & INTERCEPT for Regression (3:35)
Learn how to use the SLOPE, INTERCEPT, and R² functions for regression analysis without drawing trend lines.

Why Business Growth Isn’t Linear (And How to Predict It) (13:05)
Learn how to analyze real-world examples (Cisco, Google) and uncover how to model growth trends accurately—so you can predict success and avoid market traps.

The Excel Trend Curve That Will Transform Your Business Decisions (9:16)
Discover how businesses use power curves and price elasticity to maximize sales and revenue.

How to Use Polynomial Demand Curves for Smarter Pricing Decisions (4:36)
Master Excel’s polynomial trend feature and optimize your pricing strategy.

Master the Learning Curve: Forecasting Cost Reductions (9:52)
Discover how manufacturing, tech, and defense industries leverage the learning curve to reduce costs.

How to Find Hidden Data Patterns Using Correlation (9:47)
Master correlation analysis and apply it to stock market trends, sales forecasting, and business decisions.

What Is Beta? The Key to Measuring Stock Market Risk (4:01)
Discover how high-beta and low-beta stocks react to market changes and how to find them.

Predicting Future Performance: How Regression to the Mean Works (14:31)
Discover how this statistical law helps predict future trends in sports, stocks, and business.

How to Use Moving Averages to Smooth Out Data Trends (3:13)
Moving averages explained: How to use them to track business, sales, and financial data.

The Hidden Flaw in R-Squared: What Analysts Get Wrong (5:08)
Learn why a high R-squared doesn’t always mean a good model—and what actually matters in forecasting.

How to Choose the Best Trend Curve for Your Data (3:08)
Discover why exponential, linear, and power curves give different results—and how to choose the right one.

Converting Test Scores: A Data-Driven Approach (4:35)
Master the statistical relationship between ACT and SAT scores with a simple formula.

How to Use Multiple Regression for Better Predictions (16:38)
Discover how multiple regression helps analyze and forecast business trends, sports stats, and more.

Why Removing Outliers and Insignificant Variables Makes Forecasting Better (5:55)
Use Excel’s regression tools to clean data, remove noise, and make smarter business decisions.

How to Use Dummy Variables in Regression for Smarter Predictions (14:16)
Learn how to incorporate dummy variables in regression to model seasonal and categorical effects.

How Conjoint Analysis Helps Businesses Identify Key Product Features (10:26)
Learn how conjoint analysis helps businesses determine which product features drive sales.

What Really Matters to Consumers? Ranking Product Features with Data (9:41)
Find out how companies use data-driven insights to create better products and pricing strategies.

How to Use Regression for Value-Based Pricing (3:37)
Learn how value-based pricing helps businesses determine the right price for premium features.

How to Detect & Model Nonlinear Effects in Multiple Regression (9:28)
Learn how to test for and model nonlinearities and interaction effects in regression.

What Makes NBA Teams Win? The Data Behind Championships (10:35)
Learn how Dean Oliver’s Four Factors determine NBA success and how to analyze them.

NFL Analytics: Understanding Quarterback Performance with Regression (6:09)
Learn how to use regression to predict NFL quarterback ratings with near-perfect accuracy.

Maximum Likelihood Estimation: The Key to Probability Modeling (9:02)
Learn how to use Maximum Likelihood Estimation (MLE) to determine probabilities from data.

How to Optimize Discounts Using Logistic Regression (8:54)
Discover how businesses use regression to optimize discounts and maximize revenue.

Reverse Engineering Real-World Formulas with Regression (3:53)
See how P-values help refine regression models by removing insignificant terms.

Stop Underpricing! Use Data to Find the Right Price for Your Product (5:06)
Learn how value-based pricing helps businesses determine the right price for premium features.

How to Analyze Sales Data Using One-Way ANOVA (5:01)
Find out how store placement affects book sales with this ANOVA tutorial.

Sales Performance: Do Districts or Reps Matter More? Find Out Using Regression (7:07)
Find out whether sales reps or sales districts have a bigger impact on performance.

Does Advertising Work Better at Lower Prices? Find Out Using ANOVA (7:00)
Discover how to determine whether price and advertising interact to affect sales performance.

Why Price and Advertising Don’t Always Work Separately: ANOVA with Interaction (6:20)
Learn how to use Two-Way ANOVA with Interaction to analyze whether two factors impact each other.

How to Analyze Three or More Factors Using ANOVA and Regression (3:47)
Find out how to use regression to predict performance with multiple independent variables.

Probability in Action: How Businesses and Investors Use It to Make Decisions (6:10)
Use probability theory to predict outcomes in business, investing, and everyday life.

The Addition Rule of Probability: Avoiding Common Mistakes (4:44)
Learn how to correctly apply the addition rule to calculate probabilities of combined events.

Mastering Probability: How to Quickly Calculate “At Least One” Events (8:32)
Learn how to use complementary probabilities to simplify calculations and find missing probabilities.

How to Test If Two Events Are Independent Using Probability (2:47)
Find out why independence matters in investing, risk management, and forecasting.

Why Knowing One Event Changes the Probability of Another (11:25)
Discover how to apply conditional probability to real-world decision-making.

The Power of Conditional Probability: Making Smarter Forecasts (9:34)
Find out how conditional probability helps make smarter forecasts and risk assessments.

How to Use the Law of Total Probability to Predict Outcomes (4:27)
Discover how to combine conditional probabilities to calculate total likelihoods.

Why a Positive Test Result Doesn’t Always Mean What You Think (10:37)
Discover why positive test results can be misleading and how to adjust your probabilities.

How Naïve Bayes Works: A Simple But Powerful Classification Algorithm (3:23)
Find out how businesses and AI models use Naïve Bayes for predictions.

Predicting Customer Behavior Using Naïve Bayes (4:06)
Discover how probability-based classification helps businesses predict customer behavior.

Predicting Customer Behavior with Posterior Probabilities (3:56)
Master probability concepts using a real-world example of predicting customer subscriptions.

Mastering Probability: What Are Random Variables and Why They Matter? (9:37)
Learn how random variables define probability models and uncertainty in real-world scenarios.

Understanding Binomial Random Variables: Real-World Examples (13:06)
Find out how binomial distributions help businesses predict risks and optimize performance.

Binomial Random Variables: Understanding Their Statistical Properties (3:05)
Find out how businesses use binomial variance and standard deviation for risk assessment.

How to Calculate Probabilities for Sampling Without Replacement (4:43)
Master probability models for HR surveys, fraud detection, and quality control.

How to Use the Negative Binomial Distribution for Predicting Failures Before Success (3:29)
Learn how to compute probabilities for failures before achieving a fixed number of successes.

Why the Poisson Model Works for Customer Arrivals, Accidents, and More (9:10)
Find out how businesses use Poisson models for forecasting and risk management.

From Customer Arrivals to Equipment Failures: Using Exponential Distributions (4:57)
Learn how to use the exponential distribution to model waiting times and event occurrences.

Why So Many Real-World Variables Follow the Normal Distribution (16:02)
Find out how businesses use the normal distribution for decision-making.

How the Central Limit Theorem Helps Predict Outcomes in Business and Finance (9:30)
Find out how businesses use the Central Limit Theorem for forecasting and decision-making.

Z-Scores Explained: How to Identify Outliers in Your Data (7:10)
Learn how to calculate Z-scores and measure how unusual a data point is.

How to Use the Weibull Model for Warranty and Maintenance Planning (3:30)
Master probability concepts with real-world examples like car batteries and factory machines.

Estimating Task Completion Times with the Beta Distribution (4:21)
Master probability concepts with real-world examples like home renovations and ERP installations.

Which Plane is Safer? Comparing Emergency Landing Risks with Probability (5:20)
Master probability concepts with real-world examples like aviation failure risks.

Automate Complex Calculations with Excel’s Array Formulas (3:01)
Discover how to perform multi-cell calculations and enhance spreadsheet automation.

Why Ctrl + Shift + Enter is the Key to Powerful Excel Calculations (4:23)
Find out how array formulas can improve financial modeling and data analysis.

Why Array Formulas Can Replace Helper Columns (3:34)
Find out how Excel tables make array formulas dynamic and auto-updating.

Mastering ROW, INDIRECT, and SMALL for Automated Ranking (4:03)
Use array formulas to speed up data analysis and improve accuracy.

Mastering DSUM, SUMIF, and Array Formulas for Conditional Summation (7:04)
Use array formulas to streamline financial modeling and business analytics.

Automate Your Reports: How to Emulate SUMIFS with Array Formulas (6:23)
Find out how to perform advanced summations without SUMIFS using array formulas.

Mastering Multi-Condition Summations Without Double-Counting (4:45)
Learn how to sum data using OR conditions without double counting.

How to Create a MEDIANIF Function Using Array Formulas (7:10)
Learn how to use array formulas to compute conditional medians.

Mastering Conditional Standard Deviation Calculations (5:29)
Find out how to apply conditional standard deviation calculations for real-world data.

Mastering Array Formulas: Computing Sales Totals Without SUMIFS (6:19)
Find out how to perform conditional multiplications and summations with SUMPRODUCT.

How to Count Unique Entries Without Removing Duplicates (2:53)
Master Excel’s array formula technique to track unique customers, names, or responses.

How to Use the TRANSPOSE Function to Dynamically Convert Columns to Rows (2:25)
How to Use the TRANSPOSE Function to Dynamically Convert Columns to Rows

The Easy Way to Categorize Data into Numerical Ranges (4:32)
Discover why using COUNTIF for data grouping is inefficient—use FREQUENCY instead.

How to Use Excel for Advanced Math: Matrix Multiplication & Inversion (5:450
Use the MMULT and MINVERSE functions to streamline statistical and financial modeling.

Mastering TREND: Predictive Analytics Made Easy (5:02)
Use the TREND function to create reliable predictions and enhance business forecasting.

Using LINEST to Automatically Update Regression Models (7:44)
Discover why LINEST is a better alternative to Excel’s built-in Data Analysis regression tool.

Why Prime Numbers Matter—And How to Test Them (7:18)
Discover how MOD, ROW, and INDIRECT functions work together to check prime numbers.

Automate Complex Calculations with Excel’s Array Formulas (3:01)
Discover how to perform multi-cell calculations and enhance spreadsheet automation.

Why Ctrl + Shift + Enter is the Key to Powerful Excel Calculations (4:23)
Find out how array formulas can improve financial modeling and data analysis.

Why Array Formulas Can Replace Helper Columns (3:34)
Find out how Excel tables make array formulas dynamic and auto-updating.

Mastering ROW, INDIRECT, and SMALL for Automated Ranking (4:03)
Use array formulas to speed up data analysis and improve accuracy.

Mastering DSUM, SUMIF, and Array Formulas for Conditional Summation (7:04)
Use array formulas to streamline financial modeling and business analytics.

Automate Your Reports: How to Emulate SUMIFS with Array Formulas (6:23)
Find out how to perform advanced summations without SUMIFS using array formulas.

Mastering Multi-Condition Summations Without Double-Counting (4:45)
Learn how to sum data using OR conditions without double counting.

How to Create a MEDIANIF Function Using Array Formulas (7:10)
Learn how to use array formulas to compute conditional medians.

Mastering Conditional Standard Deviation Calculations (5:29)
Find out how to apply conditional standard deviation calculations for real-world data.

Mastering Array Formulas: Computing Sales Totals Without SUMIFS (6:19)
Find out how to perform conditional multiplications and summations with SUMPRODUCT.

How to Count Unique Entries Without Removing Duplicates (2:53)
Master Excel’s array formula technique to track unique customers, names, or responses.

How to Use the TRANSPOSE Function to Dynamically Convert Columns to Rows (2:25)
How to Use the TRANSPOSE Function to Dynamically Convert Columns to Rows

The Easy Way to Categorize Data into Numerical Ranges (4:32)
Discover why using COUNTIF for data grouping is inefficient—use FREQUENCY instead.

How to Use Excel for Advanced Math: Matrix Multiplication & Inversion (5:450
Use the MMULT and MINVERSE functions to streamline statistical and financial modeling.

Mastering TREND: Predictive Analytics Made Easy (5:02)
Use the TREND function to create reliable predictions and enhance business forecasting.

Using LINEST to Automatically Update Regression Models (7:44)
Discover why LINEST is a better alternative to Excel’s built-in Data Analysis regression tool.

Why Prime Numbers Matter—And How to Test Them (7:18)
Discover how MOD, ROW, and INDIRECT functions work together to check prime numbers.

The Power of Solver: Maximizing Profit & Efficiency (6:37)
Discover how businesses use Solver to make smarter decisions based on real constraints.

Excel Solver Explained: How Businesses Automate Decision-Making (8:12)
Discover how businesses use Solver to make smarter production and resource allocation decisions.

Why Your Solver Model Fails: Understanding Optimization Errors (6:52)
Learn how to troubleshoot common Solver errors, including “No Feasible Solution” and “Unbounded Profit.”

Minimizing Shipping Costs: Mastering the Transportation Model (11:33)
Learn how to use Excel Solver to minimize shipping and production costs.

Minimizing Staffing Costs: Workforce Planning with Solver (7:30)
Discover how to minimize staffing costs while ensuring full shift coverage.

Project Selection: How to Allocate Resources for Maximum ROI (11:14)
Learn how to use Excel Solver to select the most profitable projects within budget constraints.

How to Optimize Your Fantasy Sports Lineup with Excel Solver (7:53)
Discover how professional fantasy sports players use data-driven strategies to build winning teams.

How to Optimize a Fantasy Basketball Lineup Using Excel Solver (17:41)
Discover how top fantasy sports players use optimization models to maximize points.

Financial Optimization: Minimizing Payments & Maximizing Savings (12:03)
Discover how Solver helps optimize personal finance decisions like investments and withdrawals.

How Oddsmakers Set Point Spreads (And How You Can Do It Too) (17:47)
Discover how mathematical models help determine which teams are truly the best.

NFL Analytics: How to Predict Team Scores & Totals Using Data (11:33)
Discover how offensive and defensive ratings impact game total projections.

How to Find the Best Price for Your Product Using Excel Solver (5:55)
Learn how to use Excel Solver to optimize product pricing and maximize profit.

Optimizing Logistics: Minimizing Shipping Distances with Solver (13:20)
Discover how mathematical optimization helps businesses reduce travel distances.

How to Calculate Distances Between Cities Using Latitude & Longitude (1:40)
Master Excel’s trigonometric functions to measure real-world distances

How to Optimize Pricing & Maintain Profitability with Excel Solver (10:42)
Discover how price changes impact demand and how to maintain profitability.

Optimizing Your Savings Plan: How Much Should You Save Each Year? (5:20)
Discover how different savings timeframes impact the percentage of income you need to save.

Ensuring Product Quality: How to Minimize Defects with Statistical Sampling (4:31)
Learn how to use Excel Solver to optimize sampling plans and ensure product quality.

Minimizing Workforce Costs: The Assignment Problem in Solver (8:31)
Master Excel’s Solver tool to allocate resources and employees for maximum efficiency.

How to Determine the Best Shipping Routes Using Solver (3:39)
Use Solver to determine whether shipping directly or through warehouses is more cost-effective.

How to Optimize Inventory & Production Costs Using Excel Solver (7:54)
Learn how to use Excel Solver to optimize production schedules and minimize inventory costs.

Using Solver to Minimize Travel Distance in Logistics (2:22)
Discover how businesses optimize transportation and logistics using network modeling.

Optimizing Statistical Tests: Using Solver to Find the Minimum Sample Size (6:38)
Master Excel’s Solver tool to calculate the smallest sample size needed for reliable results.

How to Use Excel Solver to Optimize Investment Portfolios (13:00)
Discover how professional investors balance risk and return using mathematical optimization.

How to Find the Most Cost-Effective Transportation Plan with Solver (6:26)
Master Excel’s Solver to minimize transportation costs while meeting supply chain demands.

The Economics of Nutrition: Finding the Cheapest Diet (6:05)
Learn how to use Excel Solver to optimize a low-cost diet while meeting nutritional needs.

What Do You Need to Score? Using Solver to Predict Final Grades (4:28)
Learn how to use Excel Solver to calculate the minimum score needed on your final exam.

Finding a Fair Deal: The Win-Win Solution with Solver (4:19)
Discover how companies and legal teams optimize salary, severance, and stock agreements.

How to Forecast Time Series Data: Trend & Seasonality Explained (10:52)
Find out how financial analysts and business leaders use forecasting techniques.

How to Forecast Sales Using the Ratio to Moving Average Method (8:39)
Learn how to use the Ratio to Moving Average method to predict future sales.

How to Improve Forecasting Accuracy Using Recent Data (3:43)
Discover how focusing on the last few quarters improves trend estimates and accuracy.

Using Winters’ Method to Improve Forecast Accuracy (6:32)
Learn how to use Winters’ Exponential Smoothing to improve seasonal time series forecasting.

Using Solver to Fine-Tune Smoothing Constants for Better Forecasting (6:45)
Discover how businesses optimize trend, seasonality, and smoothing constants for accurate predictions.

Optimizing Forecasting Models: Initializing Trend & Seasonality with Solver (3:34)
Discover how setting up trend, seasonality, and smoothing constants impacts forecast accuracy.

How to Implement Winters’ Exponential Smoothing for Accurate Forecasting (6:00)
Find out how businesses use Winters’ Method to optimize inventory and revenue forecasts.

How to Forecast Customer Traffic Using Excel Solver (10:42)
Learn how to use Excel Solver to forecast customer traffic based on historical data.

Optimizing Forecast Accuracy: Handling Outliers & Seasonal Trends (12:08)
Discover how holiday effects, paydays, and weather influence customer traffic predictions.

Predicting Product Demand: A Sales Forecasting Model for Software (8:29)
Discover how product launches and seasonal demand impact software sales forecasts.

How to Compare Forecast Accuracy Using the Brier Score (4:45)
Discover how to measure and compare the reliability of different forecasters using the Brier Score.

How to Use Excel’s Forecast Sheet for Automated Sales Predictions (2:46)
Learn how to use the Forecast Sheet tool to generate accurate sales forecasts.

How to Use Excel’s Forecast Functions for Sales & Revenue Predictions (2:34)
Learn how to use the Forecast.ETS function to generate accurate sales forecasts.

Optimizing Sales Predictions: Using Solver for Demand Forecasting (6:10)
Discover how pricing, competition, and product displays impact demand.

Predicting Future Search Interest with Google Trends & Excel’s Forecast Sheet (6:07)
Discover how seasonal search patterns impact forecasting accuracy.

Measuring Forecast Reliability: Comparing Predictions vs. Actual Outcomes (3:37)
Learn how to use Excel to measure forecast accuracy by comparing predicted vs. actual outcomes.

Understanding Forecast Statistics: Confidence Intervals & Error Metrics (2:45)
Use Excel to assess the impact of seasonality and trend adjustments in forecasts.

Optimizing Data Visualization: Using Combo Charts for Better Comparisons (4:27)
Discover how combining column and line charts improves data clarity.

How to Handle Missing Data in Charts for Better Visualization (2:12)
Learn how to handle missing data in charts using different visualization techniques.

Optimizing Chart Display: Choosing to Show or Hide Filtered Data (1:57)
Discover how Excel allows you to toggle between showing all data or only filtered data.

Enhancing Charts: Adding Images to Column Graphs (1:31)
Discover how inserting pictures into column graphs makes data more engaging and impactful.

How to Add Data Labels to Charts for Better Readability (1:28)
Discover how category names and values can be displayed directly on graphs.

How to Add Data Tables Below Charts for Clearer Summaries (1:05)
Learn how to display key data points below Excel charts using the Data Table feature.

Best Practices for Labeling Charts Without Manual Workarounds (2:32)
Find out how businesses use this feature to enhance presentations and reports.

Tracking Performance Trends with Up & Down Arrows (6:38)
Use Excel formulas to dynamically assign up, down, and flat arrows to data.

Visualizing Inventory & Cash Balances Using Band Charts (4:40)
Learn how to create a band chart to track inventory levels and financial data.

Visualizing Actual vs. Target Revenue Using a Thermometer Chart (3:14)
Discover how businesses use thermometer charts to compare actual vs. goal progress.

Make Your Chart Titles and Labels Update When Data Changes (6:28)
Stop manually updating chart labels—link them to formulas for real-time updates

How to Use Checkboxes to Toggle Data Series in Charts (5:01)
Learn how to use checkboxes to dynamically show or hide data in charts.

Stop Manually Selecting Data—Use List Boxes for Instant Chart Updates (5:13)
Learn how to use list boxes to dynamically update chart data.

Stop Manually Entering Data! Use Spinners for Instant Changes (7:08)
Learn how to use spinners to dynamically adjust key inputs in your models.

Gantt Charts Made Simple: Track Projects with Ease (1:31)
Learn how to create a Gantt chart to visualize project timelines and deadlines.

How to Create a Dynamic Histogram That Updates Instantly (3:31)
Learn how to use the frequency function and array formulas to build dynamic histograms.

How to Make Charts That Automatically Sort Data by Rank (3:54)
Learn how to create dynamic charts that automatically sort data from highest to lowest.

Stop Using Just One Color! Make Your Charts More Insightful (2:46)
Stop manually adjusting chart colors—use formulas to automate color changes.

How to Create a Waterfall Chart for Financial Analysis (7:18)
Learn how to create a waterfall chart to visualize cash flow and profitability.

Create a Self-Updating Chart That Filters Data Instantly (8:55)
Discover how to make charts update automatically as new data is added.

How to Create a Pareto Chart to Identify Key Issues (4:46)
Stop guessing—use Pareto charts to identify which issues matter most.

Mastering Vertical Lines in Charts for Events and Milestones (1:43)
Learn how to add a vertical line to a chart that moves with the chart automatically.

How to Create a Radar Chart for Performance Analysis (3:32)
Master radar charts to track performance and identify strengths and weaknesses.

How to Create a Bubble Chart for Business Insights (3:43)
Use bubble charts to analyze relationships between revenue growth, budget variance, and market size.

Mastering Sparklines: The Small Charts That Make a Big Impact (2:56)
Learn how to create Sparklines to track trends in a single cell.

Mastering Win-Loss Sparklines: The Best Way to Summarize Wins and Losses (3:08)
Use Win-Loss Sparklines to create clean, effective reports that summarize key trends.

Stop Using Boring Bar Graphs! Add Pictures to Charts (2:16)
Learn how to replace standard Excel column bars with images to make your charts stand out.

How to Stack Pictures in a Column Chart for Better Data Visualization (1:34)
Master Excel’s “Stack and Scale” feature to visually enhance data presentations.

Mastering Dual-Axis Charts: Compare Different Scales in One Graph (2:05)
Learn how to add a secondary X and Y axis to compare datasets with different scales.

Visualizing Small Categories in Pie Charts with a Bar Chart Breakout (2:44)
Master Excel’s advanced pie chart features to improve readability and insights.

Optimizing Chart Readability: Excluding Unnecessary Data from Graphs (1:06)
Discover how businesses refine charts by filtering out unnecessary data.

Mastering Sales Reporting: Highlighting High & Low Sales Months in Charts (2:42)
Discover how businesses use Excel to automatically track peak and low sales periods.

How to Use Keystroke Shortcuts to Format Cells Faster (5:35)
Discover Excel’s most useful keystrokes for formatting numbers, text, and borders.

Mastering Navigation: The Best Keyboard Shortcuts to Know (1:51)
Master Excel’s shortcut keys to jump to specific cells, rows, and columns instantly.

Mastering Keystrokes: Editing and Auditing Formulas Faster (3:34)
Discover the best keystroke combinations for tracing precedents, auditing formulas, and recalculating workbooks.

How to Hide, Unhide, and Navigate Excel Workbooks with Shortcuts (2:09)
Learn how to use Excel keyboard shortcuts to select cells, hide/unhide rows, and navigate worksheets.

Mastering Hyperlinks: Linking to Worksheets, Files, and Web Pages (3:32)
Learn how to create hyperlinks to navigate worksheets, files, and websites.

Mastering Hyperlinks: Linking to Websites, Worksheets, and Named Ranges (2:33)
Learn how to use the HYPERLINK function to create clickable links for websites, worksheets, and named ranges.

How to Link or Embed Excel Data in Word and PowerPoint (5:00)
Learn how to insert Excel tables and charts into Word or PowerPoint while choosing between linked or unlinked data.

Locking Formulas While Allowing Data Entry: Excel Sheet Protection (2:59)
Learn how to protect formulas while allowing users to edit input cells.

How to Use the Format Painter and F4 Key for Faster Formatting (1:22)
Master Excel’s formatting shortcuts to save time and improve efficiency.

How to Get Started with Power View for Interactive Reports (6:54)
Learn how to enable and use Power View to create interactive reports and dashboards.

Mastering Power View: Creating Dynamic Tile Filters for Dashboards (2:04)
Discover how businesses use Power View tiles to segment and analyze data effectively.

Mastering Power View: Visualizing Geographic Sales Data (1:29)
Learn how to create Power View maps to visualize sales and performance data by location.

How to Use Power View Multiples for Side-by-Side Chart Comparisons (1:53)
Learn how to create Power View multiples to compare trends across different products or categories.

Mastering Power View: Using Motion Charts to Track Data Over Time (2:59)
Use Power View movies to watch data evolve year by year with interactive controls.

Mastering Monte Carlo: Predicting Financial Outcomes (5:50)
Discover how businesses use Monte Carlo simulation to assess risk and optimize decisions.

Mastering Random Number Generation for Simulations (6:43)
Master Excel’s randomization functions to simulate financial forecasts.

Mastering Monte Carlo: Simulating Uncertain Business Scenarios (8:25)
Discover how businesses use Monte Carlo simulation to model uncertainty in decision-making.

Using Monte Carlo Simulation to Forecast Demand and Business Risk (5:57)
Use Monte Carlo techniques to generate normally distributed random numbers for forecasting.

How to Simulate a Baseball Inning Using Monte Carlo (9:52)
Discover how probability modeling can estimate the number of runs in an inning.

Mastering Monte Carlo: Estimating Shared Birthday Probabilities (7:51)
Find out how Monte Carlo simulations improve probability estimation in complex problems.

Mastering Monte Carlo: Estimating Your Odds of Winning (8:59)
Find out how Monte Carlo simulations improve probability estimation for games and finance.

Mastering Monte Carlo: Optimizing Inventory Orders (13:24)
Learn how to use Monte Carlo simulation to determine the optimal inventory order.

Mastering Monte Carlo: Optimizing Competitive Bidding Strategies (8:03)
Learn how to use Monte Carlo simulation to determine the optimal bid for maximum profit.

Mastering Probability: Running Poker Simulations (9:39)
Master Excel’s RANDBETWEEN, RANK, and COUNTIF functions for probability modeling.

Monte Carlo Simulations: Predicting Championship Winners (5:41)
Discover how to model point spreads, home-court advantage, and series outcomes dynamically.

How to Model a Risky Betting Game and Predict Your Odds (4:56)
Learn how to use Monte Carlo simulations to estimate your chances in the Gambler’s Ruin problem.

Mastering Probability: Understanding Market Volatility with Simulations (6:27)
Use Excel’s data tables and probability functions to analyze investment risks and rewards.

Monte Carlo Simulations for Sports: Predicting Winning Streaks (7:25)
Learn how to simulate a baseball team’s winning streak length using Monte Carlo analysis.

Mastering Probability: How Confidence Affects Free Throw Shooting (5:14)
Use Monte Carlo simulations to test how a player’s performance changes based on past shots.

Stop Guessing! Use the Simplex LP Solver to Optimize Business Decisions (5:25)
Master Excel’s optimization tools to maximize profits while considering constraints.

Mastering the GRG Solver: Optimizing Complex Business Models (7:44)
Stop struggling with non-linear problems—use GRG Solver to optimize them efficiently.

How to Optimize Financial Models and Step Functions with Excel’s Evolutionary Solver (4:33)
Learn how to use Excel’s Evolutionary Solver to optimize problems where GRG Solver fails.

How to Use Excel Solver to Find the Best Warehouse Location (5:25)
Learn how to use Excel Solver to find the best warehouse location and minimize shipping distances.

Mastering Multi-Warehouse Logistics: Find the Best Locations (7:19)
Learn how to use Excel Solver to find the best two warehouse locations and minimize shipping distances.

How to Assign Workers to Jobs Optimally Using Excel Solver (9:54)
Learn how to use Excel Solver to assign employees to departments based on skills and preferences.

Mastering Workforce Allocation: Balancing Productivity & Satisfaction (5:18)
Master Excel’s Evolutionary Solver to balance workforce satisfaction and performance.

Mastering Production Planning: Using Solver to Minimize Downtime (10:44)
Learn how John Deere optimized their production schedule using Excel Solver.

Stop Wasting Miles—Use Solver to Optimize Travel Routes (11:11)
Learn how to use Excel’s Solver to solve the Traveling Salesperson Problem and optimize routes.

Mastering Demand Forecasting: Measuring Price Sensitivity with Solver (5:29)
Learn how to use Excel’s Solver to estimate price elasticity and optimize pricing strategies.

Mastering Learning Curve Optimization: Predict Efficiency Gains (6:57)
Master Excel’s GRG Multi-Start Solver to optimize learning rates and production efficiency.

Mastering Storage Optimization: Packing Shelves Efficiently (4:37)
Learn how to use Excel’s Solver to solve the Bin Packing Problem and optimize storage.

Mastering Conflict-Free Scheduling: Optimize Time Slots (4:35)
Learn how to use Excel’s Solver to minimize exam conflicts and optimize scheduling.

The Ultimate Guide to Discriminant Analysis with Excel Solver (9:02)
Use Solver to optimize predictive models for business, finance, and healthcare applications.

Stop Guessing Customer Segments—Use Solver for Smarter Insights (12:49)
Use Solver to identify patterns in data, optimize decision-making, and improve business strategies.

How to Use Solver to Identify and Eliminate Bottlenecks in Any Process (6:30)
Stop relying on guesswork—use Solver to find and fix process inefficiencies.

Mastering Toyota’s Goal Chasing Algorithm for Production Scheduling (9:53)
Learn how to use Excel Solver to optimize production sequencing and minimize machine downtime.

Stop Employee Scheduling Conflicts—Use Solver for Workforce Optimization (5:38)
Learn how to use Excel’s Solver to assign shifts fairly and maximize employee satisfaction.

Stop Guessing! Use Solver to Find the Correct Answer in Logic Problems (6:03)
Learn how to use Excel’s Solver to solve complex logic puzzles with constraints.

Stop Wasting Space—Use Solver to Optimize Facility Layouts (5:37)
Use Solver to optimize workflow efficiency and space utilization in hospitals, offices, and factories.

The Ultimate Guide to Using Solver for Logic Optimization (6:11)
Learn how to use Excel Solver to solve advanced logic puzzles involving constraints and deductions.

How to Solve the Pi Day Puzzle Using Excel Solver (4:19)
Learn how to use Excel Solver to find two dates whose fractional difference approximates Pi.

Mastering AI Basics: Predicting Outcomes with Neural Networks (6:13)
Stop relying on trial-and-error—use Solver to fit AI models and make accurate predictions.

How to Train a Neural Network in Excel Using Solver (6:25)
Learn how to use Excel Solver to train a neural network and improve prediction accuracy.

Mastering Six Sigma: Understanding Process Capability (5:45)
Learn how to use Excel to analyze process capability and minimize defects in manufacturing.

Mastering Statistical Quality Control: Understanding Six Sigma Metrics (3:55)
Learn how to use Excel to analyze process capability and reduce defects using Six Sigma.

Stop Producing Defective Parts—Use Excel to Monitor Process Stability (6:45)
Discover how control limits and standard error calculations help monitor manufacturing quality.

How to Identify Out-of-Control Processes Using X-Bar Charts (4:40)
Stop process instability—use X-Bar charts to maintain consistent quality.

How to Identify Out-of-Control Variation Using R-Charts (1:56)
Learn how to use Excel to create R-Charts and monitor process variation over time.

Stop Process Instability—Use Moving Range Charts for Quality Control (3:29)
Learn how to use Excel to create Moving Range Charts and monitor process variation over time.

Mastering Statistical Quality Control: Why Overcorrection Increases Variability (4:07)
Use Deming’s principles to improve manufacturing, business decisions, and data-driven processes.

How to Balance Producer and Consumer Risk in Acceptance Sampling (5:56)
Discover how binomial probability helps determine cutoffs for quality control.

How to Minimize Producer and Consumer Risk in Acceptance Sampling (3:05)
Stop relying on outdated sampling tables—use Solver to determine the best sample size and cutoffs.

Stop Assuming Your Process Is Good—Use the Taguchi Loss Function (4:30)
Master statistical quality control by comparing production processes using loss function analysis.

Stop Leaving Money on the Table—Optimize Negotiations with Solver (7:01)
Use Excel’s Solver to ensure both parties in a negotiation get the best possible outcome.

Mastering Fair Asset Division: The Power of Nash’s Nobel-Winning Solution (3:10)
Stop relying on instinct—use mathematical optimization to create better negotiation outcomes. 

Why Maximizing POP (Proportion of Potential) Leads to Fair Negotiations (2:07)
Learn how maximizing Proportion of Potential (POP) ensures fairness in negotiations.

Stop Losing in Business Negotiations—Use Mathematical Optimization (3:59)
Learn how to use Solver to optimize negotiations between a store owner and a contractor.

Mastering Business Deals: Balancing Negotiation Power with Solver (2:32)
Use Excel to structure the fairest possible negotiation outcome in multi-factor deals.

How to Optimize Store-Contractor Negotiations Using Nash’s Solution (1:51)
Use Excel’s Solver to structure win-win business deals using Nash’s principles.

How to Ensure Fairness in Multi-Party Business Deals (4:50)
Learn how to use Solver to optimize a three-player negotiation for fair asset division.

How to Solve a Six-Player Negotiation Using Excel’s Solver (5:39)
Stop relying on intuition—use Solver to ensure fair and optimal decision-making.

The Ultimate Guide to Negotiation Strategy with Reservation Values (1:26)
Learn how to calculate reservation values to set fair minimums in negotiations.

How to Make Smarter, Auto-Updating Histograms (2:51)
Learn how to create fully dynamic histograms that update automatically.

Stop Guessing—Use Pareto Charts to Identify Your Top Performers (2:29)
Master Excel’s built-in Pareto chart to rank and prioritize your most valuable data.

Mastering Data Variability: The Power of Box and Whisker Charts (6:40)
Discover how quartiles, interquartile ranges, and whiskers help interpret data.

How to Visualize Data Variability Across Multiple Categories (4:15)
Stop using separate charts—combine data sets into a single, powerful box plot.

Stop Struggling with Cash Flow Visuals—Use Waterfall Charts (2:19)
Use Waterfall Charts to create clear, dynamic reports for financial decision-making.

Mastering Financial Breakdown: Using Waterfall Charts for Revenue & Profit (1:36)
Use Waterfall Charts to analyze business finances and present data professionally.

Mastering Business Data Visualization with Treemap Charts (2:51)
Stop struggling with complex data—use Treemap Charts for instant insights.

Stop Guessing—Use Sunburst Charts to Reveal Data Relationships (2:57)
Master Sunburst Charts to analyze relationships in datasets.

Stop Struggling with Sales Reports—Use Sunburst Charts for Clear Insights (1:19)
Master Sunburst Charts to analyze seasonal sales trends and key performance periods.

Stop Guessing—Use Treemap Charts to Analyze Food and Beverage Sales (5:07)
Discover how to use SUMIFS and tables to create dynamic, auto-updating Treemap Charts.

Mastering Sales & Fundraising Pipelines with Funnel Charts (2:08)
Use Funnel Charts to visualize prospect movement and optimize conversions.

Mastering Time-Based Data Analysis (10:18)
Learn how to analyze Uber pickup data and identify the busiest 10-hour period.

How to Categorize Uber Pickups by Hour and Day of the Week (4:47)
Discover how to format and analyze ride-sharing data using pivot tables and conditional formatting.

How to Categorize Uber Calls by Date and Hour (2:09)
Stop struggling with time-based data—use pivot tables to analyze ride patterns easily.

How to Categorize and Analyze Work Shifts Using Pivot Tables (9:42)
Master VLOOKUP, COUNTIF, and pivot tables to analyze workforce scheduling.

Mastering Data Cleanup: Updating Merged Company Names (1:54)
Learn how to update old company names with new ones using VLOOKUP and IFERROR.

Mastering MOD and IF Statements for Excel Interview Questions (4:51)
Stop struggling with logic puzzles—use Excel’s built-in formulas for instant solutions.

How to Optimize Number Sequences with Excel’s Solver Tool (4:19)
Master Excel’s Solver to balance sums across rows, columns, and diagonals.

Mastering Excel Solver for Time-Based Optimization (4:07)
Master the MOD function and GRG Solver to tackle time-based optimization problems.

Mastering SEARCH, IFERROR, and INDEX for Abbreviation Matching (5:59)
Stop manually checking abbreviations—Excel’s structured formulas make it instant.

Mastering VLOOKUP and INDEX/MATCH for Data Structuring (4:01)
Use lookup functions to clean and organize complex datasets with ease.

Stop manually searching for top performances—Excel automates it in seconds. (5:01)
Stop manually searching for top performances—use structured formulas to automate it.

How to Summarize Event Data with Sparkline Charts (2:43)
Stop struggling with historical data—use Excel’s visual tools to spot trends instantly.

Mastering MINIFS and COUNTIF for Performance Analysis (5:13)
Master statistical functions to find the best performances and participation trends.

Stop Manually Checking Scores—Excel Automates Ranking Instantly (5:34)
Discover how to count score exclusions and detect judging bias with formulas.

Stop Manually Ranking Teams—Use Excel to Sort and Analyze Performance (5:16)
Use PivotTable and slicer tools to analyze and compare Olympic relay results.

Mastering Macros: Step 1 – Adding the Developer Tab (1:38)
Learn how to enable the Developer Tab so you can start recording macros.

Stop Typing—Use an Excel Macro to Insert Names Instantly (6:14)
Stop manually typing names—use an Excel macro to insert them instantly with a shortcut.

Stop Creating Fixed Macros—Make Them Work in Any Cell (3:45)
Learn how to use relative references to make macros work anywhere in a worksheet.

Mastering Macros: Automate Cell Formatting with a Click (3:57)
Learn how to create a macro that formats cells with bold and red font.

How to Format an Entire Column Using Macros (3:04)
Master Excel’s macro recording feature to automate large-scale data formatting.

Mastering Macros: Stop Formulas from Changing with One Click (4:25)
Learn how to create a macro that instantly converts formulas to static values.

How to Use Macros to Automate Pivot Table Reporting (3:47)
Learn how to use macros to filter and highlight key customers in pivot tables automatically.

Stop Manually Formatting—Use a Macro to Apply Borders Instantly (2:27)
Learn how to create a macro that instantly applies a bold red border to selected cells.

Mastering Macros: Instantly Highlight Formulas in Any Workbook (2:37)
Stop manually searching for formulas—use an Excel macro to highlight them instantly.

How to Automate Sorting with a One-Click Macro (2:11)
Learn how to record a macro that sorts a list by last name and first name automatically.

Mastering Supply Chain: Using Excel Solver for Cost Optimization (10:45)
Learn how to use Excel Solver to optimize inventory and production scheduling while minimizing costs.

Stop Overpaying—Optimize Inventory and Shortages (3:43)
Master supply chain modeling by incorporating shortage costs and production constraints.

Stop Overpaying—Use Solver to Optimize Hiring, Firing & Production (7:11)
Learn how to use Excel Solver to minimize workforce and inventory costs in aggregate planning.

How to Calculate the Economic Order Quantity (EOQ) (5:05)
Use Excel’s data table feature to analyze the impact of different order quantities.

Mastering Inventory Management: The Power of Two Strategy (3:35)
Learn how to use power of two ordering policies to simplify inventory management while keeping costs low.

Mastering Supply Chain: Minimize Costs for Multi-Product Shipping (6:45)
Discover how to optimize supply chain logistics by combining product shipments.

How to Optimize Inventory with Quantity Discounts (6:41)
Use Excel Solver to determine the most cost-effective order quantity when bulk discounts are offered.

Stop Running Out of Stock—Use Excel to Optimize Reorder Points (4:18)
Learn how to calculate reorder points and safety stock using functions like NORM.DIST and NORM.INV.

Mastering Inventory Optimization: The Fill Rate & Reorder Point Approach (5:52)
Discover how to calculate lead-time demand, safety stock, and cycle service level.

Stop Overspending—Use Excel to Minimize Shipping Costs (11:33)
Learn how to use Solver to minimize transportation costs while meeting supply and demand.

Stop Overspending—Use Excel to Optimize Work Assignments (8:31)
Learn how to use Solver to minimize workforce costs while ensuring every task is assigned.

Mastering Network Optimization: Finding the Quickest Path with Solver (2:22)
Master logistics optimization by solving shortest route problems using network flow models.

Stop Overspending—Use Excel to Optimize Warehouse Shipments (3:39)
Use Excel Solver to calculate the cheapest way to move goods between plants, warehouses, and customers.

How to Minimize Costs in a Multi-Node Logistics Network with Solver (6:26)
Use Excel Solver to calculate the cheapest way to move goods through a distribution network.

Mastering Supply Chain: Optimizing Warehouse Placement with Solver (5:25)
Learn how to use Solver to optimize warehouse location and minimize transportation costs.

Mastering Supply Chain: Finding the Best Locations for Two Warehouses (7:19)
Use Excel Solver to find the best warehouse locations based on real-world demand data.

Mastering Geographic Data: Finding City-to-City Distances (5:48)
Learn how to use Excel to calculate distances between 100 cities using latitude and longitude data.

How to Optimize Warehouse Locations for Global Shipments (4:42)
Master warehouse placement using Excel’s Solver, INDEX, and distance formulas.

Mastering Workforce Allocation: Assigning Employees to Departments Efficiently (9:54)
Discover how to balance managerial ratings and employee preferences for better workforce planning.

Mastering Workforce Allocation: Optimizing Job Assignments with Solver (5:18)
Master job allocation using Excel’s Evolutionary Solver and INDEX functions.

Mastering Production Planning: Using Solver to Minimize Downtime (10:44)
Learn how John Deere optimized their production schedule using Excel Solver.

Stop Wasting Miles—Use Solver to Optimize Travel Routes (11:11)
Learn how to use Excel’s Solver to solve the Traveling Salesperson Problem and optimize routes.

Mastering Delivery Optimization: Finding the Best Route with Solver (5:59)
Stop inefficient deliveries—use Excel to determine the best routes while staying within truck capacity limits.

How to Solve the Vehicle Routing Problem with Time Windows (3:19)
Learn how to use Solver to optimize service and delivery routes while meeting customer time windows.

Stop Production Delays—Optimize Job Sequences (3:53)
Stop production delays—use Excel to determine the best order for completing jobs.

Mastering Toyota’s Goal Chasing Algorithm for Production Scheduling (9:53)
Learn how to use Excel Solver to optimize production sequencing and minimize machine downtime.

Stop Long Lines—Improve Service Efficiency (7:40)
Stop customer complaints—use Excel to determine the best staffing levels for faster service.

Mastering Inventory Management: Understanding Inventory Turns (1:32)
Stop holding excess inventory—use Excel to determine the best turnover rate for your business.

Mastering Capacity Optimization: Find and Fix Bottlenecks (6:30)
Use Excel Solver to analyze and optimize process flow, ensuring maximum output at minimal cost.

How to Model Risk and Uncertainty (5:50)
Master risk analysis using Monte Carlo simulation techniques for better decision-making.

Mastering Random Number Generation for Simulations (6:43)
Master randomization functions to simulate financial forecasts.

Mastering Monte Carlo: Simulating Uncertain Business Scenarios (8:25)
Discover how businesses use Monte Carlo simulation to model uncertainty in decision-making.

Using Monte Carlo Simulation to Forecast Demand and Business Risk (5:57)
Use Monte Carlo techniques to generate normally distributed random numbers for forecasting.

Mastering Monte Carlo: Optimizing Inventory Orders (13:24)
Learn how to use Monte Carlo simulation to determine the optimal inventory order.

Stop Wasting Space—Use Solver to Optimize Facility Layouts (5:37)
Use Solver to optimize workflow efficiency and space utilization in hospitals, offices, and factories.

How to Optimize Warehouse Locations Using Excel’s Solver (6:20)
Learn how Excel’s Solver can optimize warehouse locations and minimize shipping costs.

Warehouse Optimization: Placing Facilities Where They Matter Most (3:27)
Use SUMPRODUCT and IF functions to analyze shipping distances for better efficiency.

How to Find the Minimum Number of Warehouses for Maximum Coverage (2:04)
Learn how to determine the minimum number of warehouses needed to meet demand efficiently.

How to Optimize Warehouse Locations When Capacity is Limited (3:18)
Learn how to optimize warehouse locations while staying within capacity limits.

Choosing the Right Supplier with Weighted Decision Models (3:13)
Learn how Excel’s Solver can help rank and choose the best supplier objectively.

How to Balance Expansion Costs with Growing Demand (4:26)
Discover how fixed charge constraints help businesses optimize long-term growth.

Why Capacity Expansion Costs More Than You Expect (2:05)
Learn why expansion costs don’t grow linearly and how to estimate them.

How to Optimize an Assembly Line Using Excel’s Solver (4:04)
Learn how Excel’s Solver can optimize workstation assignments for maximum efficiency.

How to Optimize Flexible Capacity Decisions Using Excel Solver (4:53)
Optimize business growth by investing in the right mix of dedicated and flexible capacity.

Using Data Tables to Predict Project Delays (5:25)
Discover how delays in one task can impact an entire project schedule.

How to Identify and Eliminate Bottlenecks in Your Process (6:08)
Discover why adding capacity in the wrong place won’t improve efficiency.

How to Reduce Supply Chain Variability Using Smarter Forecasting (7:07)
Find out why centralizing information and forecasting can improve supply chain efficiency.

How to Estimate Demand When You Run Out of Stock (5:07)
Learn how to estimate true demand when your sales data is censored by stockouts.

TEXTJOIN Explained: The Best Way to Join Text (3:41)
Discover how to automatically insert separators while joining text.

How to Instantly Find the Max or Min Based on Conditions (3:22)
Use MAXIFS to find top-performing players, sales regions, or best suppliers.

How to Write Complex Logical Conditions Without Nested IFs (4:01)
Discover why IFS is a faster and cleaner way to handle multiple conditions.

The Best Way to Replace Multiple IFs Using SWITCH (4:35)
Discover why SWITCH is better than IFS and VLOOKUP for certain conditions.

Excel’s Stock Data Type: The Secret to Pulling Real-Time Financial Data (6:33)
Discover how to use Excel’s Stock Data Type for live financial data.

LAMBDA vs. VBA: The Best Way to Automate Formulas (6:15)
Learn how to create custom Excel functions using LAMBDA, no VBA required.

Power Pivot: The Best Way to Analyze Millions of Rows (5:45)
Learn how Power Pivot allows you to analyze millions of rows without slowing down Excel.

The Secret to Fast and Dynamic PivotTables with Power Pivot (5:51)
Build powerful, dynamic reports from database data using Power Pivot.

DAX Functions in Power Pivot: The Secret to Smarter Data Analysis (5:14)
Learn how DAX functions can enhance Power Pivot, making your data analysis more powerful and dynamic.

How to Count Unique Customers in Power Pivot with DISTINCTCOUNT (4:14)
Learn how to count unique customers, invoices, or transactions in Power Pivot using the DISTINCTCOUNT function.

How to Compare Forecasted vs. Actual Sales in Power Pivot (7:33)
Learn how to use Power Pivot to compare sales forecasts against actual performance.

How to Use the RELATED Function in Power Pivot to Link Data Tables (6:05)
Learn how the RELATED function in Power Pivot helps you pull data from connected tables seamlessly.

Mastering Power Pivot: Using Calculated Columns in Pivot Tables (1:52)
Learn how to use Power Pivot’s calculated columns in Pivot Tables for advanced reporting.

How to Use Calculated Measures in Power Pivot for Year-Over-Year Comparisons (5:01)
Learn how to use Power Pivot’s CALCULATE function to track profit changes over time.

Mastering KPIs in Power Pivot: Track Goals with Visual Indicators (3:29)
Learn how to create Key Performance Indicators (KPIs) in Power Pivot to track business goals.

How to Take a Random Sample in Power Pivot (Step-by-Step Guide) (3:28)
Learn how to use Power Pivot’s RAND function to generate a random sample of data.

Extracting Random Samples from Specific Time Periods in Power Pivot (2:08)
Learn how to use Power Pivot’s filtering and random sampling features to extract data from a subset of a database.

Mastering Power Pivot: Median Sales and Month-to-Date Analysis (6:56)
Discover how to calculate month-to-date and cumulative sales using Power Pivot’s DATE intelligence functions.

Mastering Power Pivot: Using DATEADD for Yearly Comparisons (4:03)
Learn how to use Power Pivot’s DATEADD function to track same-day sales from last year.

Excel’s Hidden Mapping Tool: How to Create Stunning Heat Maps (2:59)
Learn how to create a Filled Map to visualize sales and other geographic data.

How to Create a US Filled Map to Visualize Sales Data (2:32)
Master the easiest way to turn raw data into an interactive US map.

How to Build a 3D Energy Map in Visualize Power Capacity (3:02)
Learn how to create a 3D Energy Map to visualize power capacity across states.

How to Create a 3D Animated Time Map (2:15)
Learn how to create a 3D Animated Time Map to visualize trends over multiple years.

Mapping Political Data: Visualizing Election Results (2:00)
Learn how to create a US election map to visualize state-by-state results.

Visualizing Public Transit Data: NYC Subway Stations (2:03)
See how to label, adjust, and expand 3D subway maps for better insights.

Mastering Dynamic Arrays: Extract Unique Values Instantly (7:45)
Learn how to use the UNIQUE function in Excel’s Dynamic Arrays to filter and remove duplicates.

Stop Manually Updating Lists—Use UNIQUE with Tables Instead (1:41)
Learn how to use the UNIQUE function with Tables to create self-updating lists.

Sorting Data Automatically with Dynamic Arrays (3:06)
Use SORT and SORTBY to keep your data lists updated without manual sorting.

How to Use Excel Tables for Auto-Sorting Data (2:45)
Learn how to use the SORT and SORTBY functions with named ranges and tables.

Mastering Excel’s FILTER Function: The Best Way to Automate Data Retrieval (7:04)
Learn how to use the FILTER function to dynamically extract data based on conditions.

Generating Number Sequences with the SEQUENCE Function (1:13)
Master Excel’s SEQUENCE function and eliminate repetitive number entry.

Generating Random Sequences with RANDARRAY (3:06)
Learn how to use the RANDARRAY function to generate structured random numbers.

Referencing Dynamic Arrays: How to Use the #SPILL Operator (3:29)
Learn how to reference dynamic arrays in other Excel formulas using the #spill operator.

Mastering Self-Updating Dropdown Lists with UNIQUE and FILTER (3:39)
Discover how to build nested dropdowns that automatically update based on user selection.

Building Self-Updating Summary Tables Without Pivot Tables (3:51)
See how to create a revenue summary table that expands dynamically as new data is added.

Mastering STOCKHISTORY: The Easiest Way to Pull Historical Stock Data (6:46)
Discover how to pull daily, weekly, or monthly stock data directly into Excel.

How to Use Excel’s Geography Data Type to Pull City Data Instantly (2:42)
Learn how to use Excel’s Geography Data Type to pull city, state, and population data instantly.

Mastering Geography Data: Get State Leaders & Population Instantly (1:31)
Discover how to extract live state data, including area and leadership, using built-in Excel features.

The Best Way to Retrieve Dynamic Location Data with FIELDVALUE (2:00)
Discover how to pull city populations, leaders, and latitude instantly using FIELDVALUE.

Picking the Right Location: Resolving Geography Data Ambiguity (1:52)
Discover how to choose the correct state when multiple cities share the same name.

The Best Way to Fetch Live Stock Data Without External Tools (2:52)
Learn how to use Excel’s Stock Data Type to automatically retrieve live stock prices.

How to Use Excel’s Latest Data Types for Real-Time Insights (20:51)
Discover how to pull nutritional information, university data, and chemistry compounds into Excel.

How to Pull Historical Weather Data Directly into Excel (4:53)
Discover how to retrieve daily, weekly, and monthly temperature and precipitation records.

Downloading Bitcoin Prices and Volumes (5:38)
In this video we use Power Query to download Bitcoin price data and transform its appearance.

Mastering Power Query: Pull Live Bitcoin Data with One Click (5:38)
Discover how to automate Bitcoin data collection from Yahoo Finance using Power Query.

How to Download and Refresh US City Population Data (3:26)
Discover how to automate city data collection from the web using Power Query.

How to Use Power Query to Automatically Structure Sales Data (2:41)
Discover how to unpivot and transform tables for better reporting using Power Query.

Mastering Power Query: Reshaping Flat Files for Better Analysis (3:12)
Master Power Query’s pivoting and transformation tools to clean up messy datasets.

How to Add Custom Columns in Power Query with Formulas (3:37)
Discover how to apply if statements in Power Query to adjust prices based on conditions.

How to Combine Multiple Excel Tables into One with Power Query (4:41)
Use Excel’s Power Query to create a refreshable report that always includes the latest data.

Mastering Power Query: Merging All Workbooks in a Folder Automatically (3:09)
Learn how to use Power Query to automatically merge multiple Excel workbooks into one.

Mastering Power Query: Fill Down & Unpivot Data for Better Reports (3:04)
See how to reshape and structure data efficiently without manual entry using Power Query.

Mastering Power Query: Splitting Data into Rows and Columns Automatically (4:16)
Use Excel’s Power Query to automatically transform comma-separated data into structured reports.

How to Group and Summarize Data Automatically with Power Query (2:26)
Use Excel’s Power Query to create a refreshable summary report for sales data.

Mastering Power Query: Grouping Data by Multiple Columns for Instant Summaries (2:43)
Learn how to use Power Query to automatically group and summarize data across multiple columns.

How to Automatically Calculate Revenue Using Custom Columns in Power Query (2:52)
Learn how to use Power Query to create custom columns for revenue calculations.

Mastering Power Query: Converting Rows into Columns Automatically (3:55)
Learn how to use Power Query to pivot columns and restructure row-based data automatically.