Advanced Excel and Analytics Course

Sample Lessons Sample Lesson

Advanced Range Name & Lookup Techniques for Smarter Formulas 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Advanced Range Name Techniques You Need to Know

How to Use Implicit Intersection for Data Lookups

Mastering Data Cleaning & Formatting: Essential Functions & Shortcuts 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Master Data Cleaning with Clean and Substitute Functions

Mastering Flash Fill: The AI-Powered Tool

How to Use Ctrl + E for Reliable Flash Fill Results

Mastering the TEXT Function: Dates, Numbers, and More

Excel Logical Functions & Auditing: Fix Errors, Automate Decisions & Optimize Data 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Master Spreadsheet Analysis with Excel’s Audit Functions

How to Resolve Circular References Using Excel’s Iterative Tools

Transform Complex Tables into Manageable Rows

Fix Errors with IFERROR and Aggregate Functions

Creating Dynamic Sales Incentive Models

Business Optimization with Sensitivity Analysis: Data Tables, Goal Seek & Scenario Planning 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Optimize Revenue and Profit with Sensitivity Analysis

Two-Way Data Tables: The Ultimate Tool for Business Decision-Making

Optimize Mortgage Planning with Financial Functions

Find the Exact Growth Rate Needed to Hit Revenue Goals

How to Use Goal Seek for Loan & Investment Analysis

Use Excel to See How Price & Costs Affect Profitability in Real Time

Advanced Summarization & Data Analysis Techniques 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

Summing Data the Smart Way: Handling Duplicates

Mastering Subtotals: How to Summarize Data Instantly

How to Combine & Summarize Data from Multiple Workbooks

How to Use Database Functions for Advanced Filtering & Summarization

Discover How to Apply Logical Conditions to Summarize Data Effectively

Extracting Specific Data from Large Tables Using the DGET Function

Mastering the Advanced Filter: Extract & Summarize Data

The Secret to Summing & Counting Only Non-Blank Data

Applying Conditional Counts & Sums to Spot Anomalies in Data

Mastering Advanced Lookups: Finding Any Occurrence of a Value in Data

How to Analyze Sports Data & Improve Strategy

Advanced Conditional Formatting & Smart Data Validation 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

How to Use Excel’s Conditional Formatting Formula Option for Smart Analysis

Master Conditional Formatting with Advanced Formula Tricks

Advanced Data Validation: Keep Your Spreadsheets Clean and Accurate

Master Data Validation: Automatically Find and Highlight Invalid Entries

Use Excel to Compare Lists and Highlight New Data

Master Conditional Formatting: Data Bars, Color Scales & Icons

Automatically Format Data Based on Multiple Criteria

Dynamic Excel Workflows: Multi-Sheet Formulas, Tables & Auto-Updates 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

How to Set Up Multiple Worksheets with One Click

How to Use 3D Formulas to Summarize Data Across Multiple Worksheets

Excel’s Paste Special Tricks That Will Change How You Work

How to Use Tables for Auto-Updating Formulas & Formatting

Stop Updating Graph Ranges Manually—Use This Trick!

How to Use Table Slicers for Instant Data Filtering

Mastering Tables: The Secret to Dynamic, Self-Updating Data

The Secret to Accurate Summing When Using Slicers

Why Your Conditional Formatting Isn’t Updating—And How to Fix It

How to Copy Formulas Across a Table Without Errors

Advanced Pivot Table Techniques: Filters, Formulas & Data Models 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

How to Use Value Field Settings and Show Values As in Pivot Tables

Stop Doing Manual Math! Use Calculated Fields in Pivot Tables

How to Use Slicers and Filters in Pivot Tables for Better Analysis

Mastering GETPIVOTDATA: The Key to Smarter Reporting

Mastering Calculated Items: A Smarter Way to Summarize Data

Master Pivot Table Timelines: The Best Way to Filter Data by Date

Pivot Tables for Surveys: How to Summarize and Visualize Responses

The Fastest Way to Combine Multiple Datasets in a Pivot Table

Pivot Table Trick: Create Multiple Reports with One Click

How to Use Excel’s Data Model to Connect Multiple Tables in Pivot Tables

Using Pivot Tables for Advanced Data Analysis

Mastering Sports Analytics: Pivot Tables for NBA Data

The Secret to Finding Patterns in data with Pivot Tables

Pivot Tables, SUMIFS, and VLOOKUP – A Real-World Business Case Study

Data Analysis Essentials: Histograms, Ranking & Decision-Making 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Mastering Histograms: A Step-by-Step Guide

How to Interpret Histogram Shapes for Data Analysis

Mastering Descriptive Statistics – Mean, Median, Mode & More

The Secret to Understanding Data with Mean & Standard Deviation

Ranking & Percentiles: Analyze Data Like a Pro

How to Take a Random Sample – Mastering RAND, RANK & VLOOKUP

How to Make the Best Decision Using Excel – Multi-Objective Decision Making

Predicting Business Trends: Regression, Growth Models & Forecasting 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

How to Predict Business Costs with Regression

Skip the Charts—Use Excel’s SLOPE & INTERCEPT for Regression

Why Business Growth Isn’t Linear (And How to Predict It)

The Excel Trend Curve That Will Transform Your Business Decisions

How to Use Polynomial Demand Curves for Smarter Pricing Decisions

Master the Learning Curve: Forecasting Cost Reductions

How to Find Hidden Data Patterns Using Correlation

What Is Beta? The Key to Measuring Stock Market Risk

Predicting Future Performance: How Regression to the Mean Works

How to Use Moving Averages to Smooth Out Data Trends

The Hidden Flaw in R-Squared: What Analysts Get Wrong

How to Choose the Best Trend Curve for Your Data

Advanced Regression Techniques for Smarter Business & Market Analysis 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

How to Use Multiple Regression for Better Predictions

Why Removing Outliers and Insignificant Variables Makes Forecasting Better

How to Use Dummy Variables in Regression for Smarter Predictions

How Conjoint Analysis Helps Businesses Identify Key Product Features

What Really Matters to Consumers? Ranking Product Features with Data

How to Use Regression for Value-Based Pricing

How to Detect & Model Nonlinear Effects in Multiple Regression

What Makes NBA Teams Win? The Data Behind Championships

NFL Analytics: Understanding Quarterback Performance with Regression

Maximum Likelihood Estimation: The Key to Probability Modeling

How to Optimize Discounts Using Logistic Regression

Find out how store placement affects book sales with this ANOVA tutorial.

Data-Driven Decisions: Probability Rules, Risk & Real-World Applications 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

The Addition Rule of Probability: Avoiding Common Mistakes

Mastering Probability: How to Quickly Calculate “At Least One” Events

How to Test If Two Events Are Independent Using Probability

Why Knowing One Event Changes the Probability of Another

The Power of Conditional Probability: Making Smarter Forecasts

How to Use the Law of Total Probability to Predict Outcomes

Why a Positive Test Result Doesn’t Always Mean What You Think

From Random Variables to Z-Scores: The Math Behind Smart Decisions 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Mastering Probability: What Are Random Variables and Why They Matter?

Understanding Binomial Random Variables: Real-World Examples

Binomial Random Variables: Understanding Their Statistical Properties

Why the Poisson Model Works for Customer Arrivals, Accidents, and More

Why So Many Real-World Variables Follow the Normal Distribution

How the Central Limit Theorem Helps Predict Outcomes in Business and Finance

Z-Scores Explained: How to Identify Outliers in Your Data

Excel Array Formulas: Automate, Analyze & Optimize Your Data 17 Topics

Expand

Lesson Content

0% Complete 0/17 Steps

Automate Complex Calculations with Excel’s Array Formulas

Why Ctrl + Shift + Enter is the Key to Powerful Excel Calculations

Why Array Formulas Can Replace Helper Columns

Mastering ROW, INDIRECT, and SMALL for Automated Ranking

Mastering DSUM, SUMIF, and Array Formulas for Conditional Summation

Automate Your Reports: How to Emulate SUMIFS with Array Formulas

Mastering Multi-Condition Summations Without Double-Counting

How to Create a MEDIANIF Function Using Array Formulas

Mastering Conditional Standard Deviation Calculations

Mastering Array Formulas: Computing Sales Totals Without SUMIFS

How to Count Unique Entries Without Removing Duplicates

How to Use the TRANSPOSE Function to Dynamically Convert Columns to Rows

The Easy Way to Categorize Data into Numerical Ranges

How to Use Excel for Advanced Math: Matrix Multiplication & Inversion

Mastering TREND: Predictive Analytics Made Easy

Using LINEST to Automatically Update Regression Models

Why Prime Numbers Matter—And How to Test Them

Smart Excel Functions: OFFSET & INDIRECT for Dynamic Analysis 13 Topics

Expand

Lesson Content

0% Complete 0/13 Steps

Using OFFSET to Automate Reports and Dynamic Calculations

Mastering OFFSET: Solving the VLOOKUP Left-Hand Limitation

How to Use OFFSET for Dynamic Cost Calculations

Excel’s OFFSET Function: A Smarter Way to Handle Financial Data

How to Automate Financial Reporting with OFFSET

Mastering OFFSET: The Best Way to Automate Data Ranges

How to Use OFFSET and INDIRECT for Dynamic Sales Charts

How to Automate Multi-Sheet Reports Using INDIRECT

How to Automate Multi-Sheet Reports

How to Use INDIRECT to Dynamically Reference Named Ranges

How to Extract All Worksheet Names Dynamically

Mastering INDIRECT and OFFSET: The Key to Smart Drop-Down Menus

How to Use INDIRECT to Consolidate Stock Return Data

Excel Solver Unlocked: Optimize Costs, Profits & Decision-Making 25 Topics

Expand

Lesson Content

0% Complete 0/25 Steps

The Power of Solver: Maximizing Profit & Efficiency

Excel Solver Explained: How Businesses Automate Decision-Making

Why Your Solver Model Fails: Understanding Optimization Errors

Minimizing Shipping Costs: Mastering the Transportation Model

Minimizing Staffing Costs: Workforce Planning with Solver

Project Selection: How to Allocate Resources for Maximum ROI

How to Optimize Your Fantasy Sports Lineup with Excel Solver

How to Optimize a Fantasy Basketball Lineup Using Excel Solver

Financial Optimization: Minimizing Payments & Maximizing Savings

How Oddsmakers Set Point Spreads (And How You Can Do It Too)

NFL Analytics: How to Predict Team Scores & Totals Using Data

How to Find the Best Price for Your Product Using Excel Solver

Optimizing Logistics: Minimizing Shipping Distances with Solver

How to Calculate Distances Between Cities Using Latitude & Longitude

How to Optimize Pricing & Maintain Profitability with Excel Solver

Optimizing Your Savings Plan: How Much Should You Save Each Year?

Ensuring Product Quality: How to Minimize Defects with Statistical Sampling

Minimizing Workforce Costs: The Assignment Problem in Solver

How to Determine the Best Shipping Routes Using Solver

How to Optimize Inventory & Production Costs Using Excel Solver

Using Solver to Minimize Travel Distance in Logistics

Optimizing Statistical Tests: Using Solver to Find the Minimum Sample Size

How to Use Excel Solver to Optimize Investment Portfolios

How to Find the Most Cost-Effective Transportation Plan with Solver

The Economics of Nutrition: Finding the Cheapest Diet

Data-Driven Forecasting: Excel Methods for Accurate Predictions 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

How to Forecast Time Series Data: Trend & Seasonality Explained

How to Forecast Sales Using the Ratio to Moving Average Method

How to Improve Forecasting Accuracy Using Recent Data

Using Winters’ Method to Improve Forecast Accuracy

Using Solver to Fine-Tune Smoothing Constants for Better Forecasting

Optimizing Forecasting Models: Initializing Trend & Seasonality with Solver

How to Implement Winters’ Exponential Smoothing for Accurate Forecasting

How to Forecast Customer Traffic Using Excel Solver

Optimizing Forecast Accuracy: Handling Outliers & Seasonal Trends

Predicting Product Demand: A Sales Forecasting Model for Software

Optimizing Sales Predictions: Using Solver for Demand Forecasting

Interactive Excel Charts: Checkboxes, Spinners & Auto-Updating Visuals 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

How to Use Checkboxes to Toggle Data Series in Charts

Stop Manually Selecting Data—Use List Boxes for Instant Chart Updates

Stop Manually Entering Data! Use Spinners for Instant Changes

Create a Self-Updating Chart That Filters Data Instantly

Mastering Sparklines: The Small Charts That Make a Big Impact

Mastering Win-Loss Sparklines: The Best Way to Summarize Wins and Losses

Visualizing Data with Power View: Maps, Motion Charts & Comparisons 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

How to Get Started with Power View for Interactive Reports

Mastering Power View: Creating Dynamic Tile Filters for Dashboards

Power View Map

How to Use Power View Multiples for Side-by-Side Chart Comparisons

Mastering Power View: Using Motion Charts to Track Data Over Time

Monte Carlo Simulations: Predicting Outcomes & Optimizing Strategies 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

Mastering Monte Carlo: Predicting Financial Outcomes

Mastering Random Number Generation for Simulations

Mastering Monte Carlo: Simulating Uncertain Business Scenarios

Using Monte Carlo Simulation to Forecast Demand and Business Risk

How to Simulate a Baseball Inning Using Monte Carlo

Mastering Monte Carlo: Estimating Shared Birthday Probabilities

Mastering Monte Carlo: Estimating Your Odds of Winning

Mastering Monte Carlo: Optimizing Inventory Orders

Mastering Monte Carlo: Optimizing Competitive Bidding Strategies

Mastering Probability: Running Poker Simulations

Monte Carlo Simulations: Predicting Championship Winners

How to Model a Risky Betting Game and Predict Your Odds

Mastering Probability: Understanding Market Volatility with Simulations

Monte Carlo Simulations for Sports: Predicting Winning Streaks

Advanced Solver Techniques: Optimize Costs, Workforce & Operations 17 Topics

Expand

Lesson Content

0% Complete 0/17 Steps

Stop Guessing! Use the Simplex LP Solver to Optimize Business Decisions

Mastering the GRG Solver: Optimizing Complex Business Models

How to Optimize Financial Models and Step Functions with Excel’s Evolutionary Solver

How to Use Excel Solver to Find the Best Warehouse Location

Mastering Multi-Warehouse Logistics: Find the Best Locations

How to Assign Workers to Jobs Optimally Using Excel Solver

Mastering Workforce Allocation: Balancing Productivity & Satisfaction

Mastering Production Planning: Using Solver to Minimize Downtime

Stop Wasting Miles—Use Solver to Optimize Travel Routes

Mastering Demand Forecasting: Measuring Price Sensitivity with Solver

Mastering Learning Curve Optimization: Predict Efficiency Gains

Mastering Storage Optimization: Packing Shelves Efficiently

Mastering Conflict-Free Scheduling: Optimize Time Slots

The Ultimate Guide to Discriminant Analysis with Excel Solver

Stop Guessing Customer Segments—Use Solver for Smarter Insights

How to Use Solver to Identify and Eliminate Bottlenecks in Any Process

Mastering Toyota’s Goal Chasing Algorithm for Production Scheduling

Advanced Excel Charts: Dynamic Histograms, Pareto, and Waterfall Visuals 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

How to Make Smarter, Auto-Updating Histograms

Stop Guessing—Use Pareto Charts to Identify Your Top Performers

Mastering Data Variability: The Power of Box and Whisker Charts

How to Visualize Data Variability Across Multiple Categories

Stop Struggling with Cash Flow Visuals—Use Waterfall Charts

Mastering Financial Breakdown: Using Waterfall Charts for Revenue & Profit

Mastering Business Data Visualization with Treemap Charts

Stop Guessing—Use Sunburst Charts to Reveal Data Relationships

Stop Struggling with Sales Reports—Use Sunburst Charts for Clear Insights

Stop Guessing—Use Treemap Charts to Analyze Food and Beverage Sales

From Recording to Automation: Mastering Macros for Smarter Workflows 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Mastering Macros: Step 1 – Adding the Developer Tab

Stop Typing—Use an Excel Macro to Insert Names Instantly

Stop Creating Fixed Macros—Make Them Work in Any Cell

Mastering Macros: Automate Cell Formatting with a Click

How to Format an Entire Column Using Macros

Mastering Macros: Stop Formulas from Changing with One Click

How to Use Macros to Automate Pivot Table Reporting

Stop Manually Formatting—Use a Macro to Apply Borders Instantly

Mastering Macros: Instantly Highlight Formulas in Any Workbook

How to Automate Sorting with a One-Click Macro

Mastering Supply Chain Optimization: Inventory, Costs & Logistics with Excel 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

Mastering Supply Chain: Using Excel Solver for Cost Optimization

Stop Overpaying—Optimize Inventory and Shortages

Stop Overpaying—Use Solver to Optimize Hiring, Firing & Production

How to Calculate the Economic Order Quantity (EOQ)

Mastering Inventory Management: The Power of Two Strategy

Mastering Supply Chain: Minimize Costs for Multi-Product Shipping

How to Optimize Inventory with Quantity Discounts

Stop Running Out of Stock—Use Excel to Optimize Reorder Points

Mastering Inventory Optimization: The Fill Rate & Reorder Point Approach

Mastering Geographic Data: Finding City-to-City Distances

How to Optimize Warehouse Locations for Global Shipments

Stop Production Delays—Optimize Job Sequences

Stop Long Lines—Improve Service Efficiency

Mastering Inventory Management: Understanding Inventory Turns

Advanced Excel and Analytics Course

Course Content

OVERVIEW

About Instructor

Wayne Winston

Course Includes

CONTACT INFO

CONTACT INFO