info@excelwithwayne.com

Excel With Wayne

Menu
Courses
Menu
main-courses ,

Marketing Analytics

View Course details
Wayne Winston · August 19, 2020

My Total Course Time:
My Course completion time:

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: Formula Essentials for Efficiency
Forecast Customer Trends with Churn Rates
Build Dynamic Spreadsheets for Real-World Scenarios
Production Planning: Using MIN and INT Functions
Real-World Excel Skills: Diving Scores Explained
Economic Insights: Learn to Compute the Gini Index
Master Excel Functions to Build Custom Tables
Explore Currency Valuation with Simple Formulas
Modeling Supply and Demand: A Hands-On Guide
Visualizing Total and Variable Costs Using Charts
Retirement Planning: Calculate Your Savings Growth
Learn to Balance Resources Using Excel Tools
Understand Loan Payments with Simple Excel Tools
Depreciation Methods: Straight Line, Units, and Sum of Digits
Analyze Customer Patterns with the Gravity Model
Modeling the Butterfly Effect and Fibonacci Sequence
Master Pricing Strategies
Understand Financial Variances: Volume, Mix, and Price
Learn VLOOKUP and Simplify Your Spreadsheets
Mastering HLOOKUP: Simplify Horizontal Data Retrieval
Pricing Hacks: Lookup Product Prices Based on Dates
Master VLOOKUP Across Worksheets: Combine Data Effortlessly
Automating Vertical Lookups Across Multiple Columns
Master the INDEX Function: Simplify Data Retrieval
How to Use INDEX to Retrieve and Sum Rows or Columns
Mastering the MATCH Function: 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 Conditional Counting & Summation: Unlock Powerful Data Insights 24 Topics
Expand
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
Text Filters
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
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
Stop Guessing—Use Pareto Charts to Identify Your Top Performers
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
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

About Instructor

Wayne Winston

13 Courses

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

Course Includes

  • 29 Lessons
  • 429 Topics
  • 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 .