info@excelwithwayne.com

Excel With Wayne

Menu
Courses
Menu
main-courses ,

Complete Microsoft Excel Training Course

View Course details
Wayne Winston · July 13, 2015

Course Content

Expand All
Excel Formula Essentials: Dynamic Models, Forecasting & Data Analysis 43 Topics
Expand
Lesson Content
0% Complete 0/43 Steps
From Manual to Automatic: Excel Formula Essentials for Efficiency
Excel Tutorial: Forecast Customer Trends with Churn Rates
Build Dynamic Spreadsheets for Real-World Scenarios
Production Planning with Excel: Using MIN and INT Functions
Master the LARGE Function and Score Like a Pro
Economic Insights with Excel: Learn to Compute the Gini Index
Master Excel Functions to Build Custom Tables
Explore Currency Valuation with Simple Formulas
Modeling Supply and Demand in Excel: A Hands-On Guide
Visualizing Total and Variable Costs Using Excel
Retirement Planning with Excel: Calculate Your Savings Growth
Learn to Balance Resources Using Excel Tools
Understand Loan Payments with Simple Excel Tools
Depreciation Methods in Excel: Straight Line, Units, and Sum of Digits
Excel Tutorial: Analyze Customer Patterns with the Gravity Model
Modeling the Butterfly Effect and Fibonacci Sequence in Excel
Master Pricing Strategies with Excel
Understand Financial Variances: Volume, Mix, and Price
Learn VLOOKUP and Simplify Your Spreadsheets
Mastering HLOOKUP in Excel: Simplify Horizontal Data Retrieval
Excel Pricing Hacks: Lookup Product Prices Based on Dates
Master VLOOKUP Across Worksheets: Combine Data Effortlessly
Automating Vertical Lookups Across Multiple Columns in Excel
Master the INDEX Function: Simplify Data Retrieval in Excel
How to Use INDEX to Retrieve and Sum Rows or Columns in Excel
Mastering the MATCH Function in Excel: Find Data with Precision
Master Two-Way Lookups with MATCH and INDEX
Master Advanced Lookups with INDEX, MATCH, and LARGE
Retrieve the Latest Dates Dynamically
How to Calculate Cost-of-Living Adjusted Salaries Using VLOOKUP
Master Currency Exchange Using INDEX and MATCH
How to Model Population Growth
Master the CHOOSE Function and Declutter Your Spreadsheets
Simplify Complex Calculations with VLOOKUP
Math is Fun: Exploring Beautiful Results
Understanding the Rule of 72: A Simple Guide to Doubling Your Money
Convert PDF Data to Excel: A Simple, Free Method
Use Excel to Illustrate an Amazing Math Proposition
Explaining Google’s PageRank Algorithm
XLOOKUP Explained: The Ultimate Replacement for VLOOKUP and HLOOKUP
How to Use XLOOKUP’s Match Modes for Advanced Lookups
XLOOKUP vs. INDEX MATCH: The Easy Way to Do Two-Way Lookups
XLOOKUP in Action: Summing Dynamic Ranges with Ease
Excel Date & Time Functions: Workday Planning, Scheduling & Financial Modeling 27 Topics
Expand
Lesson Content
0% Complete 0/27 Steps
Excel Conditional Counting & Summation: Unlock Powerful Data Insights 24 Topics
Expand
Lesson Content
0% Complete 0/24 Steps
Unlocking the Power of Pivot Tables: Summarization, Trends & Data-Driven Decisions 31 Topics
Expand
Lesson Content
0% Complete 0/31 Steps
How to Master Pivot Tables (Even If You’re a Beginner)
Master PivotTables: Find Your Best Customers and Analyze Revenue Trends
How to Use Text Filters in Pivot Tables for Smarter Data Analysis
Pivot Table Grouping: A Smarter Way to Summarize Data
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
How to Fix Calculation Errors in Pivot Tables Using Solve Order
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
Breaking Down Elections with Pivot Tables: Why Votes Don’t Always Equal Seats
The Science of Attraction: How Pivot Tables Reveal Dating Trends
Simpson’s Paradox: Why Averages Can Be Misleading – Pivot Tables in Action
Pivot Tables, SUMIFS, and VLOOKUP – A Real-World Business Case Study
Mastering Pivot Tables: Breaking Down Voter Demographics Instantly
How to Set Default PivotTable Settings and Save Time
Mastering Slicers: Filter Multiple PivotTables with One Click
How to Apply Conditional Formatting in PivotTables for Instant Insights
Fixing Unrecognized Dates in PivotTables: A Simple Trick
Mastering PivotTables: Analyzing Bitcoin Returns by Year and Month
The Secret to Summarizing Data Faster Using PivotTable Calculated Fields
The Secret to Tracking Customer Satisfaction with PivotTables
How to Move a PivotTable Without Breaking Your Report
Mastering Solver: The Key to Cost Reduction & Smart Business Strategies 27 Topics
Expand
Lesson Content
0% Complete 0/27 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
What Do You Need to Score? Using Solver to Predict Final Grades
Finding a Fair Deal: The Win-Win Solution with Solver
From Basic to Brilliant: How to Make Charts That Tell a Story 32 Topics
Expand
Lesson Content
0% Complete 0/32 Steps
Optimizing Data Visualization: Using Combo Charts for Better Comparisons
How to Handle Missing Data in Charts for Better Visualization
Optimizing Chart Display: Choosing to Show or Hide Filtered Data
Enhancing Charts: Adding Images to Column Graphs
How to Add Data Labels to Charts for Better Readability
How to Add Data Tables Below Charts for Clearer Summaries
Best Practices for Labeling Charts Without Manual Workarounds
Tracking Performance Trends with Up & Down Arrows
Visualizing Inventory & Cash Balances Using Band Charts
Visualizing Actual vs. Target Revenue Using a Thermometer Chart
Make Your Chart Titles and Labels Update When Data Changes
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
Gantt Charts Made Simple: Track Projects with Ease
How to Create a Dynamic Histogram That Updates Instantly
How to Make Charts That Automatically Sort Data by Rank
Stop Using Just One Color! Make Your Charts More Insightful
How to Create a Waterfall Chart for Financial Analysis
Create a Self-Updating Chart That Filters Data Instantly
How to Create a Pareto Chart to Identify Key Issues
Mastering Vertical Lines in Charts for Events and Milestones
How to Create a Radar Chart for Performance Analysis
How to Create a Bubble Chart for Business Insights
Mastering Sparklines: The Small Charts That Make a Big Impact
Mastering Win-Loss Sparklines: The Best Way to Summarize Wins and Losses
Stop Using Boring Bar Graphs! Add Pictures to Charts
How to Stack Pictures in a Column Chart for Better Data Visualization
Mastering Dual-Axis Charts: Compare Different Scales in One Graph
Visualizing Small Categories in Pie Charts with a Bar Chart Breakout
Optimizing Chart Readability: Excluding Unnecessary Data from Graphs
Mastering Sales Reporting: Highlighting High & Low Sales Months in Charts
Excel Solver for Business Optimization: Smarter Decisions, Better Outcomes 24 Topics
Expand
Lesson Content
0% Complete 0/24 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
Stop Employee Scheduling Conflicts—Use Solver for Workforce Optimization
Stop Guessing! Use Solver to Find the Correct Answer in Logic Problems
Stop Wasting Space—Use Solver to Optimize Facility Layouts
The Ultimate Guide to Using Solver for Logic Optimization
How to Solve the Pi Day Puzzle Using Excel Solver
Mastering AI Basics: Predicting Outcomes with Neural Networks
How to Train a Neural Network in Excel Using Solver
Supply Chain & Inventory Optimization: Solver Strategies for Cost Efficiency 48 Topics
Expand
Lesson Content
0% Complete 0/48 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
Stop Overspending—Use Excel to Minimize Shipping Costs
Stop Overspending—Use Excel to Optimize Work Assignments
Mastering Network Optimization: Finding the Quickest Path with Solver
Stop Overspending—Use Excel to Optimize Warehouse Shipments
How to Minimize Costs in a Multi-Node Logistics Network with Solver
Mastering Supply Chain: Optimizing Warehouse Placement with Solver
Mastering Supply Chain: Finding the Best Locations for Two Warehouses
Mastering Geographic Data: Finding City-to-City Distances
How to Optimize Warehouse Locations for Global Shipments
Mastering Workforce Allocation: Assigning Employees to Departments Efficiently
Mastering Workforce Allocation: Optimizing Job Assignments with Solver
Mastering Production Planning: Using Solver to Minimize Downtime
Stop Wasting Miles—Use Solver to Optimize Travel Routes
Mastering Delivery Optimization: Finding the Best Route with Solver
How to Solve the Vehicle Routing Problem with Time Windows
Stop Production Delays—Optimize Job Sequences
Mastering Toyota’s Goal Chasing Algorithm for Production Scheduling
Stop Long Lines—Improve Service Efficiency
Mastering Inventory Management: Understanding Inventory Turns
Mastering Capacity Optimization: Find and Fix Bottlenecks
How to Model Risk and Uncertainty
Mastering Random Number Generation for Simulations
Mastering Monte Carlo: Simulating Uncertain Business Scenarios
Using Monte Carlo Simulation to Forecast Demand and Business Risk
Mastering Monte Carlo: Optimizing Inventory Orders
Stop Wasting Space—Use Solver to Optimize Facility Layouts
How to Optimize Warehouse Locations Using Excel’s Solver
Warehouse Optimization: Placing Facilities Where They Matter Most
How to Find the Minimum Number of Warehouses for Maximum Coverage
How to Optimize Warehouse Locations When Capacity is Limited
Choosing the Right Supplier with Weighted Decision Models
How to Balance Expansion Costs with Growing Demand
Why Capacity Expansion Costs More Than You Expect
How to Optimize an Assembly Line Using Excel’s Solver
How to Optimize Flexible Capacity Decisions Using Excel Solver
Using Data Tables to Predict Project Delays
How to Identify and Eliminate Bottlenecks in Your Process
How to Reduce Supply Chain Variability Using Smarter Forecasting
How to Estimate Demand When You Run Out of Stock

About Instructor

Wayne Winston

13 Courses

Preview this Course
+685 enrolled
Not Enrolled
Take this Course
$397.00

Course Includes

  • 38 Lessons
  • 635 Topics
  • 1 Quiz
  • Course Certificate

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.

CONTACT INFO

Copyright © 2025 | Excel With Wayne
Facebook-f Twitter Linkedin-in

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

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.

Report

You have already reported this .