Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
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.
Learn how to use Basic Filters to quickly isolate key data points, such as transactions by salesperson, product type, or region.
Mastering Number Filters: Refine Your Data Analysis (1:36)
Learn how to use Number Filters to quickly isolate rows that meet specific conditions, such as “greater than” or “between ranges.
How to Filter for Top 10, Top 5%, and More in Excel Instantly (1:19)
Discover how to filter data by top 10, top 30, top 5%, and bottom 5% for better insights.
Master Date Filters to Analyze Data by Timeframes (1:25)
Master Date Filters to focus on the exact time periods you need, whether it’s a year, quarter, or specific month range
Find Specific Names or Strings Using Text Filters (1:09)
Discover how to use Text Filters to streamline data searches and find entries that match your specific needs in seconds.
Master Color Filters for Better Data Organization (1:42)
Learn how to use Filter by Color feature to sort and analyze data based on cell or font colors, making it easy to organize your spreadsheets visually.
Combining Text and Color Filters for Advanced Data Analysis (2:24)
This video demonstrates how to filter data by combining text criteria, cell colors, and helper columns to streamline complex analyses.
Sorting Techniques: Organize and Prioritize Your Data (3:14)
Learn how to master sorting, including sorting alphabetically, numerically, and by multiple criteria like names, products, and dates.
Sorting Techniques: Master Sorting by Cell and Font Colors (1:37)
Learn how to sort data by cell and font colors, prioritizing information visually and organizing your spreadsheets efficiently.
Master Reverse Sorting for Perfect Organization (1:32)
Discover advanced sorting techniques, including how to reverse the order of criteria like dates, units, and names for efficient data management.
Case-Sensitive Sorting Explained: Techniques You Need (1:07)
This video explains how to enable and use case-sensitive sorting to distinguish between uppercase and lowercase data.
Organize Your Data Smarter with Custom List Sorting (2:13)
This video demonstrates how to use custom list feature to sort data by months, days, or personalized sequences for better organization.
How to Create and Use Custom Lists for Sorting (1:38)
Learn how to create and use custom lists to sort data in a unique order, perfect for tailored data organization.
Organize Your Data with Horizontal Sorting (1:53)
Learn how to sort rows horizontally, perfect for transposed datasets and organizing data across columns.
How to Remove Duplicates: Find Unique Values Fast (3:04)
Learn how to use Excel’s Remove Duplicates feature to clean your data, find unique values, and ensure accuracy across single or multiple columns.
Filtering Made Easy: Dynamic Selection Filters (1:29)
Learn how to use Excel’s Filtering by Selection feature to dynamically refine your data and gain quick insights.
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.
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.
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.
Filtering Explained: Isolate and Analyze Your Data (2:51)
Learn how to use Basic Filters to quickly isolate key data points, such as transactions by salesperson, product type, or region.
Mastering Number Filters: Refine Your Data Analysis (1:36)
Learn how to use Number Filters to quickly isolate rows that meet specific conditions, such as “greater than” or “between ranges.
How to Filter for Top 10, Top 5%, and More in Excel Instantly (1:19)
Discover how to filter data by top 10, top 30, top 5%, and bottom 5% for better insights.
Master Date Filters to Analyze Data by Timeframes (1:25)
Master Date Filters to focus on the exact time periods you need, whether it’s a year, quarter, or specific month range
Find Specific Names or Strings Using Text Filters (1:09)
Discover how to use Text Filters to streamline data searches and find entries that match your specific needs in seconds.
Master Color Filters for Better Data Organization (1:42)
Learn how to use Filter by Color feature to sort and analyze data based on cell or font colors, making it easy to organize your spreadsheets visually.
Combining Text and Color Filters for Advanced Data Analysis (2:24)
This video demonstrates how to filter data by combining text criteria, cell colors, and helper columns to streamline complex analyses.
Sorting Techniques: Organize and Prioritize Your Data (3:14)
Learn how to master sorting, including sorting alphabetically, numerically, and by multiple criteria like names, products, and dates.
Sorting Techniques: Master Sorting by Cell and Font Colors (1:37)
Learn how to sort data by cell and font colors, prioritizing information visually and organizing your spreadsheets efficiently.
Master Reverse Sorting for Perfect Organization (1:32)
Discover advanced sorting techniques, including how to reverse the order of criteria like dates, units, and names for efficient data management.
Case-Sensitive Sorting Explained: Techniques You Need (1:07)
This video explains how to enable and use case-sensitive sorting to distinguish between uppercase and lowercase data.
Organize Your Data Smarter with Custom List Sorting (2:13)
This video demonstrates how to use custom list feature to sort data by months, days, or personalized sequences for better organization.
How to Create and Use Custom Lists for Sorting (1:38)
Learn how to create and use custom lists to sort data in a unique order, perfect for tailored data organization.
Organize Your Data with Horizontal Sorting (1:53)
Learn how to sort rows horizontally, perfect for transposed datasets and organizing data across columns.
How to Remove Duplicates: Find Unique Values Fast (3:04)
Learn how to use Excel’s Remove Duplicates feature to clean your data, find unique values, and ensure accuracy across single or multiple columns.
Filtering Made Easy: Dynamic Selection Filters (1:29)
Learn how to use Excel’s Filtering by Selection feature to dynamically refine your data and gain quick insights.
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.
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
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.
Find out how store placement affects book sales with this ANOVA tutorial. (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.
Using OFFSET to Automate Reports and Dynamic Calculations (3:39)
Find out how to use OFFSET with SUM, AVERAGE, and other functions for smarter calculations.
Mastering OFFSET: Solving the VLOOKUP Left-Hand Limitation (4:37)
Discover why the OFFSET function is the best alternative to VLOOKUP for backward lookups.
How to Use OFFSET for Dynamic Cost Calculations (6:38)
Learn how to use the OFFSET function to dynamically sum costs based on changing data.
Excel’s OFFSET Function: A Smarter Way to Handle Financial Data (5:44)
Master the OFFSET function to dynamically sum expenses without manual selection.
How to Automate Financial Reporting with OFFSET (4:39)
Find out how OFFSET ensures your reports always display the latest data without manual updates.
Mastering OFFSET: The Best Way to Automate Data Ranges (5:21)
Learn how to use the OFFSET function to create dynamic ranges that update automatically.
How to Use OFFSET and INDIRECT for Dynamic Sales Charts (4:50)
Learn how to use the OFFSET function to create charts that update automatically as new data is added.
How to Automate Multi-Sheet Reports Using INDIRECT (6:32)
Discover why INDIRECT and CONCATENATE work together for automated multi-sheet reporting.
How to Automate Multi-Sheet Reports (5:08)
Discover why INDIRECT and ADDRESS work together for structured, automated reporting.
Mastering INDIRECT: Fixing Common Issues with Spaces in Worksheet Names (2:30)
Learn how to use the INDIRECT function to reference sheets with spaces without errors.
How to Use INDIRECT and ADDRESS for Dynamic Conditional Formatting (5:39)
Find out how INDIRECT and ADDRESS ensures your conditional formatting updates dynamically.
How to Use INDIRECT to Dynamically Reference Named Ranges (3:06)
Discover why INDIRECT allows text-based named ranges to function correctly in formulas.
How to Extract All Worksheet Names Dynamically (4:48)
Learn how to use Excel’s GET.WORKBOOK and INDIRECT functions to retrieve all worksheet names dynamically.
Mastering INDIRECT and OFFSET: The Key to Smart Drop-Down Menus (7:26)
Master the INDIRECT function to make drop-downs automatically adjust to selections.
How to Use INDIRECT to Consolidate Stock Return Data (7:02)
Learn how to use INDIRECT in Excel to retrieve stock return data dynamically.
How to Use OFFSET and INDIRECT for Income Distribution Analysis (4:52)
Find out how OFFSET ensures your income analysis updates dynamically.
How to Use Excel to Predict Wealth Inequality Across Populations (6:06)
Find out how businesses and policymakers use the Gini Index to understand economic trends.
How to Use Excel to Analyze Election Fairness & Districting (6:55)
Use data to evaluate whether districts give equal voting power to all citizens.
The Vegas Gambler’s Excel Trick for Predicting Team Scores (4:53)
In this video we show how to find the average points scored by an NBA team during their last 5 games.
The Truth About Technical Analysis: Does It Really Predict Market Moves? (13:13)
Discover whether buying when a stock crosses above its moving average actually works.
Eliminating Volatile Functions: A Smarter Way to StructureFormulas (6:30)
Discover why OFFSET is volatile and how replacing it with INDEX speeds up calculations.
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.
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.
How to Optimize Pricing & Maintain Profitability with Excel Solver (10:42)
Discover how price changes impact demand and how to maintain profitability.
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.
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.
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.
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.
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 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.
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.
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:32)
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.
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.
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.
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.
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.
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.
This comprehensive course delves into Monte Carlo Simulation using the powerful Palisade @RISK Add-In, covering over 60 essential topics.
Monte Carlo Simulation: A Beginner’s Guide Using @Risk
Learn how Monte Carlo simulation can optimize business decisions using @Risk.
How to Model Uncertainty with the Normal Distribution in Monte Carlo
Discover how probability density functions and standard deviations affect forecasting.
Monte Carlo Simulation: Using RISKSTATISTICAL Functions
Learn how to use RISKSTATISTICAL functions to extract mean and standard deviation from Monte Carlo simulations.
How Tornado & Spider Plots Help Identify Business Risks
Discover how @Risk helps forecast sales growth, decline, and profitability.
How to Model Market Share & Uncertain Distributions with Monte Carlo
Discover how to simulate uncertain market share data with Monte Carlo.
How to Predict Market Trends with the RISKCUMUL Function in @Risk
Understand why cumulative distributions provide a more intuitive approach to probability modeling.
Why Companies Like Eli Lilly & Chevron Use RISKTRIGEN for Forecasting
Learn how to model uncertain outcomes using the RISKTRIGEN function in Monte Carlo simulation.
Using @Risk to Analyze NPV & Risk in Capital Budgeting
Understand how Monte Carlo simulation estimates NPV and risk in capital budgeting
Using Monte Carlo to Evaluate Oil Drilling Investment Decisions
Discover how @Risk models drilling costs, oil price fluctuations, and extraction uncertainty.
How to Model Investment Risk Using Scenario-Based Monte Carlo Simulation
Learn how scenario-based Monte Carlo simulation helps businesses evaluate capital investments.
How Monte Carlo Simulation Improves Option Pricing Models
Learn why simply plugging in expected values doesn’t work for option pricing.
How to Model Business Acquisitions Using Monte Carlo Simulation
Discover how future discounted cash flows determine if an investment is worthwhile.
How to Find the Right Growth Rate for Your Investment Using Monte Carlo
Learn how to use @Risk’s Goal Seek feature to find the right terminal growth rate for an investment.
Stop Guessing NBA Odds—Use Excel to Simulate Thousands of Games
Learn how to use Monte Carlo simulations to estimate NBA Finals win probabilities.
Monte Carlo Simulation: Modeling Dice Rolls and Casino Probabilities
See how to build a probability model for craps and apply similar logic to other casino games.
Will You Ever Return? Simulating the Drunkard’s Walk
Discover why a drunkard always returns home in 1D and 2D but has only a 34% chance in 3D.
What Are the Odds? Using Monte Carlo to Find Birthday Matches
Understand why a room of just 23 people has a 50% chance of a shared birthday.
Monte Carlo Simulation: Finding Your Best Partner with Probability
Understand why the best candidate is found 37% of the time using a simple mathematical rule.
How to Shuffle a Deck and Calculate Poker Odds
Learn how to use Monte Carlo simulations to estimate the probabilities of poker hands.
Monte Carlo Simulation for Competitive Bidding: Maximize Your Profits
Learn how to use Monte Carlo simulations to determine the optimal bid in competitive situations.
How to Use Risk Optimizer for Smarter Business Decisions
Discover how to set constraints, analyze uncertainty, and optimize business decisions with Risk Optimizer.
How to Use Risk Optimizer to Maximize Profit Under Uncertain Demand
Learn how to use Monte Carlo simulations and Risk Optimizer to determine the best order quantities under uncertain demand.
How to Use Risk Optimizer to Minimize Staffing Shortages
Explore how Excel’s Risk Optimizer helps hospitals create optimal shift schedules while managing risk.
Bid Optimization: Finding the Perfect Price with RISKOPTIMIZER
Master Monte Carlo simulations to model competitor pricing and optimize bidding strategies.
How to Use Monte Carlo Simulation for Critical Decision-Making
Master Excel’s probability modeling techniques to balance risk and success in high-stakes scenarios.
Monte Carlo Simulations: Optimizing Job Sequencing Under Uncertainty
Learn how to use Monte Carlo simulations to determine the optimal job sequence under uncertain durations.
Capital Budgeting: Choosing the Best Portfolio of Projects
Learn how to use Monte Carlo simulations to optimize project selection under budget constraints.
How to Simulate Correlated Risks & Forecasting Errors
Master Excel’s probability modeling tools to analyze dependent risks and forecasting errors.
Portfolio Analysis: Modeling Daily Correlated Stock Movements
Use Monte Carlo simulations to track portfolio volatility and stock co-movement.
Portfolio Optimization: Generating Investment Forecasts
Learn how to generate thousands of investment scenarios using Monte Carlo simulations.
How to Use Value at Risk & Sharpe Ratio for Portfolio Optimization
Master Excel’s probability modeling tools to balance risk and return in investment portfolios.
How to Use Stress Testing & Downside Risk for Smarter Investing
Discover how stress testing and downside risk adjustments improve portfolio resilience.
How to Control Portfolio Risk with Beta & Conditional Value at Risk (VAR)
Learn how to use Monte Carlo simulations to optimize portfolios by controlling Beta and Conditional Value at Risk (VAR).
How to Fit a Distribution to Real-World Data
Learn how to use Excel’s distribution fitting to find the best random variable model for your data.
Monte Carlo Simulations: Fitting a Continuous Random Variable to Data
Learn how to fit a continuous probability distribution to real-world data using Monte Carlo simulations.
How to Optimize Bidding Strategies & Avoid Overpaying
Learn how to use Monte Carlo simulations to determine the optimal bid and avoid the winner’s curse.
How to Price Call & Put Options Using the Black-Scholes Model
Explore how Excel’s financial modeling tools can be used for options pricing and risk assessment.
How to Forecast Future Stock Prices with Monte Carlo Simulations
Learn how to use lognormal distributions and Monte Carlo simulations to model stock prices.
How to Analyze Option Strategies Using Monte Carlo Simulations
Master Excel’s probability modeling tools to analyze risk, reward, and expected returns for different options trades.
How to Model Decision-Making Under Uncertainty Using Utility Theory
Learn how utility theory explains decision-making under uncertainty and risk aversion.
Portfolio Optimization with Exponential Utility: Balancing Risk & Return
Learn how to estimate a person’s utility function and apply it to decision-making.
Investment Strategy: Optimizing Asset Allocation with Expected Utility
Master Excel’s probability modeling tools to balance risk and return in investment decisions.
Project Planning: Estimating Completion Times with @RISK
Learn how to use Monte Carlo simulations to estimate uncertain project completion times.
How to Identify Critical Activities in Project Management
Learn how to use Monte Carlo simulations to calculate the probability that a project activity is critical.
How to Use Resampling to Compare Two Data Sets Without Assumptions
Learn how resampling can be used as a simple, assumption-free alternative to traditional statistical tests.
Using Monte Carlo Simulations to Determine Drug Effectiveness
Learn how Monte Carlo simulations help determine whether a new cancer drug is more effective than the current treatment
Statistical Analysis: Evaluating the Fairness of the Vietnam War Draft Lottery
Learn how Monte Carlo simulations help determine whether the 1970 draft lottery was truly random.
Financial Modeling: Analyzing Stock Betas with Monte Carlo
Learn how Monte Carlo simulations can determine the probability that a stock has the highest or lowest beta.
How to Avoid Losing Money in Bidding Wars Using Monte Carlo Simulations
Learn how Monte Carlo simulations reveal the risks of bidding with asymmetric information.
How to Use Excel to Prove a Surprising Coin Toss Probability
Learn how Monte Carlo simulations reveal why certain coin toss sequences are more likely to appear first.
How to Detect Financial Fraud Using Statistical Analysis
Learn how Monte Carlo simulations could have exposed Bernie Madoff’s fraudulent returns.
How Fortune 500 Companies Minimize Foreign Exchange Risk
Master Excel’s risk modeling tools to ensure currency fluctuations don’t hurt financial targets.
How to Avoid Overstocking & Stockouts Using Monte Carlo
Discover how to use risk modeling to determine the best order quantities for seasonal items.
How to Optimize Retail Reordering Decisions Using Monte Carlo
Learn how Monte Carlo simulations help retailers decide when and how much to reorder inventory.
How to Maximize Retail & Manufacturer Profits Using Risk Analysis
Discover how to balance profit margins for manufacturers and retailers using strategic ordering.
Financial Modeling: Buyback Pricing & Wholesale Optimization
Learn how to use Monte Carlo simulation to optimize buyback contracts and maximize supply chain profits.
Financial Modeling: Revenue Sharing & Wholesale Pricing
Master Excel’s Monte Carlo tools to set optimal wholesale prices and revenue-sharing fractions for better financial outcomes.
How to Maximize Supply Chain Profits Using Risk Modeling
Discover how Monte Carlo simulations can maximize total supply chain profitability through pricing and order quantity strategies.
How to Value Path-Dependent Options Using Monte Carlo Simulation
Master Monte Carlo simulation techniques for pricing complex derivatives in financial modeling.
How to Price Options Using Risk-Neutral Monte Carlo Simulation
Discover how stock price modeling and discounted cash flow analysis help determine option values.
How to Model a Ponzi Scheme: The Bernie Madoff Case Study (8:31)
Learn how Bernie Madoff’s Ponzi scheme worked and why it collapsed in 2008.
Bernie Madoff’s Alleged Strategy: How the Split-Strike Scheme Fooled Investors (7:09)
Learn how Bernie Madoff convinced investors with a strategy that seemed low-risk but was mathematically impossible.
From Population Data to Fraud Detection: Benford’s Law Explained (6:04)
Explore Excel techniques for applying Benford’s Law to fraud detection and big data analysis.
Why Benford’s Law Works: The Math Behind Real-World Numbers (3:35)
How to Use Excel to Simulate Benford’s Law in Action.
How Benford’s Law Exposed Bernie Madoff’s Fraudulent Returns (8:33)
Understand why real-world numbers follow Benford’s Law—and why Madoff’s didn’t.
Data Science: Why Madoff’s Returns Were Too Good to Be True (5:35)Discover why Madoff’s Sharpe Ratio was an impossible red flag for savvy investors.
How to Use Excel to Measure Income Inequality & Wealth Distribution (8:20)
Explore Excel techniques for visualizing income distribution and global inequality rankings.
Data Analytics: Predicting Demand & Stock Market Sensitivity (12:57)
Learn how to estimate demand curves and calculate stock beta using Excel’s regression tools.
R-Squared, Correlation & Regression to the Mean: What They Really Mean (15:05)
Explore Excel techniques for calculating correlation, standard error, and predictive accuracy.
Understanding the Power Curve & Elasticity: Analyzing Non-Linear Demand (7:36)
Learn how power curves model price elasticity and why demand isn’t always linear.
Intergenerational Mobility: Can Kids Really Do Better Than Their Parents? (8:14)
Explore Excel techniques for comparing parent and child income levels across generations.
From Poverty to Prosperity: The Data Behind Economic Mobility (6:47)
Learn how rank-rank mobility and intergenerational elasticity measure economic opportunity.
Mastering Wealth Mobility: Understanding Quintiles & The Gatsby Curve (6:31)
Learn how the quintile approach measures intergenerational mobility and wealth persistence.
Mastering Regression Analysis: How Economic Status Predicts Student Achievement (9:41)
Learn how free lunch percentage predicts school test scores using Excel’s regression tools.
Evaluating Teachers with Test Scores: Does It Really Work? (5:42)
Learn how test scores are used to evaluate teachers and why the data may be misleading.
Data Analytics in Excel: Comparing Teacher Evaluation Methods (3:54)
Learn how the Simple Gain and Constant Growth models evaluate teacher performance.
From Admissions Data to Business Decisions: Understanding Simpson’s Paradox (8:26)
Learn how Simpson’s Paradox can lead to misleading conclusions in data analysis.
Three Fascinating Paradoxes in Analytics: When Data Defies Expectations (4:43)
Learn how three common paradoxes—waiting time, speed averaging, and load factor—affect real-world decision-making.
Mastering Basketball Analytics: How Advanced Metrics Evaluate NBA Greats (12:02)
Learn how analytics measures player value and why Carmelo Anthony’s Hall of Fame case isn’t so simple.
From Fielding Percentage to Ultimate Zone Rating: Understanding Baseball Defense Metrics (10:29)
Learn why traditional fielding metrics like fielding percentage misrepresent defensive ability.
Golf Analytics: Why “Drive for Show, Putt for Dough” Is a Myth (5:02)
Learn why putting isn’t the most important part of golf and how strokes gained analysis changes everything.
Mastering Quarterback Analytics: Why NFL Passer Rating Falls Short (6:18)
Learn how multiple regression can be used to reverse-engineer and improve the NFL QB rating system.
How to Use Excel to Evaluate Regression Models & Make Better Predictions (7:48)
Learn how to interpret regression output, from coefficients to p-values and R-squared.
Using the TREND Function: Predicting NFL QB Ratings (4:21)
Master Excel’s array formulas and the TREND function to forecast quarterback ratings.
Mastering QB Analytics: Why the NFL Passer Rating Doesn’t Make Sense (6:10)
Master Excel’s regression tools to analyze the inconsistencies in quarterback rating calculations.
A Better Way to Rank NFL Quarterbacks: Points Per Play & Advanced Metrics (4:42)
Learn why Points Per Play is a better measure of quarterback success than traditional passer rating.
From the NBA to the NFL: Which Sports Are Most Driven by Skill? (8:08)
Understand how margin of victory and team ratings help quantify the impact of skill.
Gerrymandering: How Politicians Manipulate Elections with District Maps (16:57)
Master Excel’s mapping and statistical tools to analyze the effects of district manipulation.
How a 1700s Scurvy Experiment Revolutionized Modern Medicine (12:14)
Learn how Dr. James Lind’s scurvy experiment in the 1700s pioneered evidence-based medicine.
Mastering Medical Analytics: How a 1946 Tuberculosis Trial Changed Medicine (5:08)
Learn how the 1946 streptomycin tuberculosis trial became the first major randomized controlled trial in medicine.
Data-Driven Medicine: What We’ve Learned About Hormone Therapy Since 1991 (3:49)
Learn how studies on hormone replacement therapy (HRT) evolved over time and changed medical recommendations.
Mastering Healthcare Analytics: Are Hospital Rankings Misleading? (9:38)
Learn how hospital ratings can be misleading if they don’t account for patient risk factors.
Data-Driven Healthcare: Ranking the Most Serious Health Issues (7:12)
Learn how Disability-Adjusted Life Years (DALYs) measure the true burden of different diseases.
How Different Regions of the World Experience Health Problems Differently (4:42)
Learn how Disability-Adjusted Life Years (DALYs) highlight the biggest health challenges in different world regions.
Mastering Investment Analytics: Do Mutual Fund Ratings Predict Performance? (4:26)
Learn how Morningstar rates mutual funds and whether past ratings predict future success.
Mastering Risk Analytics: Why the Sortino Ratio Beats the Sharpe Ratio (4:56)
Learn how the Sortino Ratio improves risk measurement by focusing only on downside volatility.
How to Use Excel to Analyze Mutual Fund Performance with Beta & Alpha (4:20)
Master Excel’s financial tools to analyze mutual fund performance and market correlation.
Mastering Investment Analytics: The Truth About Morningstar’s Star Ratings (3:20)
Learn why Morningstar’s star ratings don’t always predict future mutual fund performance.
How Investment Fees Impact Your Wealth (4:14)
Learn how investment fees impact long-term portfolio growth and how to model it.
NFL Betting Explained: How Vegas Always Wins (6:06)
Learn how sports betting works, including point spreads, money lines, and over/under bets.
Evaluating Forecasts: Accuracy, Bias & Prediction Errors (4:41)
Understand how forecast accuracy is assessed in business and sports predictions.
Las Vegas Betting Lines: Do They Favor Home Teams? (9:17)
Discover why Las Vegas betting lines are incredibly accurate and hard to beat.
What Makes a Great Employee? Data-Driven Hiring Insights (9:52)
Discover how hiring analytics reveal which factors truly matter in predicting employee success.
Does an Ivy League Education Really Matter? The Surprising Data (8:27)
Discover why elite universities may not add as much value as people think.
Will Your Favorite Team Be Good Next Year? The Math Says No (6:57)
Learn how regression to the mean explains why dominant sports teams rarely stay on top.
Could We Have Predicted the 2008 Crash? The Data Says Yes (10:40)
Learn how the inverted yield curve and Sahm Rule have accurately predicted past recessions.
Mastering Conditional Formatting: Using Formulas for Dynamic Insights (5:47)
Discover advanced conditional formatting techniques for tracking trends and spotting insights.
Introduction to Statistical Process Control: How to Detect Trends & Anomalies (2:59)
Discover how Statistical Process Control (SPC) identifies when a process is out of control.
The Data Behind the Housing Bubble: What We Could Have Seen Coming (6:47)
Discover how the housing-to-rent index revealed the housing market was spiraling out of control.
Can Your Purchases Reveal Personal Secrets? Target’s Predictive Analytics Explained (6:17)
Learn how Target used purchase history to predict pregnancy with logistic regression.
Predicting Customer Behavior: The Data Model Behind Target’s Pregnancy Strategy (5:32)
Learn how Target used logistic regression to predict if a woman was pregnant based on shopping habits.
Can the Apple Watch Detect AFib? Understanding Sensitivity & Specificity (9:33)
Learn how sensitivity and specificity impact the accuracy of medical tests.
Receiver Operating Characteristic (ROC) Curve Explained in Simple Terms (9:43)
Learn how the ROC curve measures medical test accuracy.
Can a Smartwatch Save Your Life? Analyzing AFib Detection with the Apple Watch (2:07)
Discover why sensitivity and specificity matter when analyzing medical wearables.
The Minneapolis Experiment: Does Adding More Police Lower Crime Rates? (5:04)
Learn how a randomized controlled trial in Minneapolis tested whether more police reduce crime.
Do Predictive Policing, CCTV, and Stop-and-Frisk Actually Reduce Crime? (7:34)
Discover why some police strategies work while others show little evidence of success.
Predicting Daily Sales: A Data-Driven Approach (7:28)
Discover how to use regression, trends, and special event factors to predict demand.
How to Set Up an Excel Spreadsheet for Accurate Demand Forecasting (7:29)
Learn how to set up an Excel spreadsheet for demand forecasting and parameter optimization.
How to Use Excel Solver to Build an Accurate Forecast Model (10:13)
Learn how to use Excel Solver to minimize forecast errors and improve predictions.
Which Variables Matter Most in Forecasting Customer Counts? (2:53)
Learn how to test which variables are most important for accurate demand forecasting.
Can We Predict Elections, Stock Prices, and Sales? The Data Says Yes (7:29)
Understand why collective intelligence often outperforms expert predictions.
How Do Political Polls Really Work? The Truth About Election Forecasts (12:14)
Learn how political polling works and why small sample sizes can predict national elections.
How Buzzfeed Predicted The Dress Would Go Viral—Using Data (9:15)
Learn how Buzzfeed used social lift metrics to predict the virality of “The Dress”.
How Google Trends Predicts Music Trends: The Case of Taylor Swift & Adele (5:23)
Discover how search data reveals peaks in music popularity and album releases.
Predicting TV Ratings with Data: The Game of Thrones Experiment (11:30)
Explore how real-time search analytics can help businesses anticipate consumer demand.
How We Proved Smoking Causes Lung Cancer—The Data Behind the Discovery (8:08)
Master probability models that showed smokers were 18 times more likely to develop lung cancer.
The Analytics Behind the Rockets’ Success: Three-Pointers & Layups (15:35)
Learn how the Houston Rockets used middle school math to optimize their shot selection.
The Analytics Behind MLB’s Shift Away from Bunts and Intentional Walks (5:14)
Master the expected run matrix that shows why bunting is often a losing play.
The Analytics Behind NFL Play Calling: Why Teams Should Pass More (8:04)
Learn why NFL teams should pass more, go for it on fourth down, and attempt more two-point conversions.
The Man Who Stopped Cholera—With Data and a Map (6:29)
Explore how public health data and mapping saved lives in 1854 and beyond.
How Bubble Charts Helped Solve the Cholera Outbreak of 1854 (4:36)
Explore how data visualization can reveal hidden insights in real-world problems.
Building a Sales Forecast Model for Retail Products (6:18)
Discover how pricing, coupons, and in-store displays impact weekly sales.
Optimizing Sales Predictions with Excel’s GRG Multistart Solver (5:38)
Learn how to use the GRG Multistart Solver to optimize complex forecasting models.
The Pareto Principle in Action: How 20% Drives 80% of Results (6:00)
Discover how the Pareto Principle explains why 20% of inputs drive 80% of results in business, finance, and society.
The Long Tail & Power Laws: Why a Few Dominate the Many (6:49)
Discover how power laws and the long tail explain book sales, website traffic, and income distribution.
Why the Rich Get Richer: The Data Behind Market Domination (8:27)
Discover how the “rich get richer” theory explains why a few websites, businesses, and networks dominate the market.
Does Where You Grow Up Shape Your Future? The Data Says Yes (6:53)
Discover how a child’s future income is influenced by the neighborhood they grow up in.
How Businesses Reduce Wait Times Using Data & Excel Models (10:08)
Discover how queuing theory explains wait times and how businesses optimize service efficiency.
Queuing Theory & Sensitivity Analysis: Making Smarter Business Decisions (5:36)
Master sensitivity analysis to optimize staffing and reduce customer wait times.
Are Roundabouts Better Than Traffic Lights? The Surprising Answer (7:34)
Learn how roundabouts compare to traffic lights using real-world data and case studies.
Do Ramp Meters Really Help? The Surprising Data on Traffic Efficiency (5:39)
Discover how ramp meters use data to prevent congestion and improve highway speeds.
How Cutting Class Sizes Impacts Test Scores, Salaries & Crime Rates (8:32)
Learn why smaller K-12 classes lead to better academic performance and lower crime rates.
Is Reducing Class Sizes a Smart Investment? The Cost-Benefit Breakdown (4:56)
Discover how cost-benefit analysis and internal rate of return (IRR) measure the impact of reducing class sizes.
A/B Testing Explained: How to Optimize Websites & Ads with Data (9:03)
See how small changes in website layout, colors, or ads can significantly impact conversions.
Portfolio Optimization: Maximizing Returns & Minimizing Risk (6:59)
Understand correlation, standard deviation, and asset diversification in portfolio management.
How to Use Excel Solver for Portfolio Optimization & Risk Management (9:07)
Explore how different assets—stocks, bonds, real estate, and gold—affect portfolio performance.
Hedge Funds Explained: How the Best Investors Beat the Market (6:56)
Understand how hedge funds balance risk by going long on undervalued stocks and shorting overvalued ones.
How Investors Use Arbitrage to Lock in Returns & Reduce Risk (7:11)
Learn how hedge funds use convertible bond arbitrage to profit in different market conditions.
Global Macro Hedge Funds & the All-Weather Portfolio Explained (6:00)
Discover how Ray Dalio’s All-Weather Portfolio is designed to perform in any economy.
How Target & Walmart Optimize Inventory Using Data (8:04)
Learn how inventory theory helps businesses optimize order quantities and reduce costs.
Optimizing Your Reorder Point: How to Avoid Stockouts & Cut Costs (5:29)
Understand the relationship between service levels, lead time, and inventory costs.
The Traveling Salesperson Problem: Finding the Shortest Route (6:14)
See how route planning applies to NBA teams, UPS, and real-world business decisions.
Solving the Traveling Salesperson Problem with Excel Solver: Finding the Shortest Path (6:04)
Discover how evolutionary algorithms help optimize travel routes efficiently.
Obama vs. Trump: The Role of Facebook, A/B Testing & Predictive Models (7:24)
Learn how political campaigns use voter data, predictive modeling, and A/B testing to target key demographics.
Predicting Outcomes with Logistic Regression & Solver (10:13)
Understand the impact of demographic variables on predictions with real-world data.
How Voting Systems Shape Elections: The Data Behind Picking a Winner (9:52)
Understand how runoff voting, plurality, and ranked choice work—and their pros and cons.
Quadratic Voting: The Future of Decision-Making? (5:29)
Learn how approval voting and quadratic voting work, and how they compare to ranked choice voting.
The Winner’s Curse: Why the Highest Bidder Usually Overpays (4:10)
Discover how the winner’s curse affects oil leases, sports contracts, and business deals.
Avoiding the Winner’s Curse: How to Make Smarter Bids (3:57)
Learn how adjusting your bid can help you avoid the winner’s curse and increase profits.
Can Data Predict Hit Songs? The Science Behind Music Analytics (8:34)
Understand how cluster analysis is used to identify hit songs before they top the charts.
The Math of Freedom: How Data Determines Who Stays in Prison (9:22)
Explore the variables—like prior arrests and age—that influence risk assessment models.
The Truth About Parole Algorithms: Bias or Data Misinterpretation? (3:36)
Discover ProPublica’s analysis of risk scores and whether racial bias plays a role.
AI in Parole Decisions: Can Machine Learning Predict Crime? (8:55)
Learn how AI and machine learning are used to predict recidivism and influence parole decisions.
How Data Revolutionized Baseball Defense: The Power of the Shift (6:42)
See how the rise of the shift led to more home runs, fewer ground balls, and a changing game.
The Data Behind NBA Greats: How Advanced Stats Changed Basketball (10:26)
Learn how advanced analytics measure a player’s impact beyond the box score.
Divorce, Disputes & Data: Using Analytics to Divide Assets Fairly (6:34)
Discover how the “win-win solution” maximizes fairness in disputes like divorce.
The Math Behind COVID-19: How the SIR Model Works (10:44)
Discover how variables like R0, beta, and gamma influence epidemic growth.
How the SEIRS Model Helps Predict Second and Third Waves of Disease (9:23)
Learn how the SEIRS model improves upon the SIR model by incorporating exposure and waning immunity.
Tracking COVID-19 Cases, Deaths & Hospitalizations Using PivotTables (11:58)
Explore how to create PivotTables that track COVID-19 cases by state, day of the week, and total trends.
Analyzing COVID-19 Trends Worldwide Using PivotTables (6:19)
Learn how to use PivotTables to compare COVID-19 cases per 100,000 people across countries.
The Impact of Late Mail-In Votes: What History Tells Us (11:13)
Understand how voter turnout, mail-in ballot processing, and state rules shape the results.
How GOP Turnout & Hispanic Voters Broke the Polling Models (1:28)
Explore why Democratic voters were more likely to answer polls due to COVID-19 mobility differences.
The Math Behind COVID-19 Vaccines: How Efficacy Is Calculated (7:29)
Learn how vaccine efficacy is calculated and what it really means for public health.
