Back to Course
Marketing Analytics
0% Complete
0/0 Steps
-
Basic Formulas Part One
-
Excel Formula Essentials: Dynamic Models, Forecasting & Data Analysis43 Topics
-
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
-
From Manual to Automatic: Formula Essentials for Efficiency
-
Excel Data Mastery: Filters, Sorting & Duplicate Removal for Smarter Analysis16 Topics
-
Filtering Explained: Isolate and Analyze Your Data
-
Mastering Number Filters: Refine Your Data Analysis
-
How to Filter for Top 10, Top 5%, and More in Excel Instantly
-
Master Date Filters to Analyze Data by Timeframes
-
How to Use Text Filters in Pivot Tables for Smarter Data Analysis
-
Master Color Filters for Better Data Organization
-
Combining Text and Color Filters for Advanced Data Analysis
-
Sorting Techniques: Organize and Prioritize Your Data
-
Sorting Techniques: Master Sorting by Cell and Font Colors
-
Master Reverse Sorting for Perfect Organization
-
Case-Sensitive Sorting Explained: Techniques You Need
-
Organize Your Data Smarter with Custom List Sorting
-
How to Create and Use Custom Lists for Sorting
-
Organize Your Data with Horizontal Sorting
-
How to Remove Duplicates: Find Unique Values Fast
-
Filtering Made Easy: Dynamic Selection Filters
-
Filtering Explained: Isolate and Analyze Your Data
-
Range Names Unlocked: Smarter Formulas, Lookups & Data Management9 Topics
-
Range Names Explained: Make Formulas More Understandable
-
Step-by-Step Guide to Create and Manage Range Names
-
How to Use Excel’s F3 Trick for Range Names
-
How to Reference Entire Rows and Columns in Formulas
-
How to Apply Range Names to Existing Formulas
-
Workbook vs. Worksheet Range Names: What You Need to Know
-
Advanced Range Name Techniques You Need to Know
-
How to Use Implicit Intersection for Data Lookups
-
Using Range Names for Dynamic Lookup Formulas
-
Range Names Explained: Make Formulas More Understandable
-
Data Cleaning & Text Functions: Extract, Format & Automate15 Topics
-
How to Clean and Organize Data with Text Functions
-
Mastering Text Functions: Split and Organize Data
-
How to Make Smarter, Auto-Updating Histograms
-
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
-
Master Text Extraction with FIND and SUBSTITUTE
-
How to Perform Two-Column Lookups with VLOOKUP and Text Functions
-
How to Use SUBSTITUTE and RIGHT for Fast Data Reformatting
-
Master Unicode Characters and Hyperlinks for Smarter Spreadsheets
-
Master Text Functions for Fast List Creation
-
Mastering the TEXT Function: Dates, Numbers, and More
-
Rounding Numbers for Cleaner Calculations
-
Preserving Leading Zeros and Special Formats
-
How to Fix VLOOKUP Errors Caused by Invisible Characters
-
How to Clean and Organize Data with Text Functions
-
Excel Logical Functions & Auditing: Fix Errors, Automate Decisions & Optimize Data24 Topics
-
Master Spreadsheet Analysis with Excel’s Audit Functions
-
How to Resolve Circular References Using Excel’s Iterative Tools
-
Unlock the Power of Conditional Logic with Excel’s IF Functions
-
How to Use MOD and IF Statements to Solve Real-Life Problems
-
Summarizing Yearly Data with Conditional Logic
-
Master Product Sales Projections with IF Statements
-
Transform Complex Tables into Manageable Rows
-
Fix Errors with IFERROR and Aggregate Functions
-
Master Data Transformation with IFERROR and Nested IFs
-
How to Use ISERROR and IF to Adjust Data Dynamically
-
Streamline Data Validation Using MOD and Logical Functions
-
How to Determine if a Stock is Overvalued: A Microsoft Case Study
-
Transform Row-Based Datasets with Excel Functions
-
Mastering Complex Commission Calculations
-
Creating Dynamic Sales Incentive Models
-
Using IF Statements to Simplify Investment Strategies
-
IF Functions for Real-World Scenarios
-
Decode Messages with Excel’s Advanced Functions
-
Learn to Encrypt Messages Using Excel’s Rail Fence Cipher
-
Identify Trends and Streaks in Sports Data
-
How Excel’s IF, MATCH, and MOD Functions Help Solve Math Puzzles
-
Using Excel to Compute and Explore Rational Number Sequences
-
Health Data Meets Excel: Using Advanced Formulas to Calculate Longevity
-
Mastering IFERROR: The Key to Fixing Broken Formulas
-
Master Spreadsheet Analysis with Excel’s Audit Functions
-
Business Optimization with Sensitivity Analysis: Data Tables, Goal Seek & Scenario Planning18 Topics
-
Optimize Revenue and Profit with Sensitivity Analysis
-
Two-Way Data Tables: The Ultimate Tool for Business Decision-Making
-
Optimize Mortgage Planning with Financial Functions
-
Mastering Customer Retention and Value Analysis
-
Find the Exact Growth Rate Needed to Hit Revenue Goals
-
How to Use Goal Seek for Loan & Investment Analysis
-
Compare Business Scenarios Using Goal Seek & Data Tables
-
Scenario Planning: Forecasting Business Outcomes
-
Compare Down Payments & Home Value Changes
-
How to Use Excel to Plan and Manage Projects More Efficiently
-
How to Use Excel’s Data Tables for Smart Investment Planning
-
How Probability & Expected Value Shape Winning Strategies
-
Mastering Time-Based Data Analysis with Excel’s What-If Tools
-
Use Excel to See How Price & Costs Affect Profitability in Real Time
-
Use Excel’s Data Tables to Optimize Your Investment Strategy
-
One of Math’s Greatest Unsolved Problems—Solved in Excel?
-
How to Calculate Bond Prices and Yields
-
How to Create a Data Table Across Multiple Worksheets
-
Optimize Revenue and Profit with Sensitivity Analysis
-
Excel Conditional Counting & Summation: Unlock Powerful Data Insights24 Topics
-
How to Use COUNTIF & COUNTIFS to Analyze Large Data Sets
-
COUNT vs. COUNTA vs. COUNTBLANK – What’s the Difference?
-
Excel’s Most Powerful Conditional Functions Explained
-
Summing Data the Smart Way: Handling Duplicates
-
Mastering Subtotals: How to Summarize Data Instantly
-
Mastering the SUBTOTAL Function for Smarter Summarizations
-
The Secret to Dynamic Reporting: Counting Colored Cells with SUBTOTAL
-
Sorting Subtotals: The Secret to Organizing Data Like a Pro
-
How to Combine & Summarize Data from Multiple Workbooks
-
Summing Data from Different Sheets Without Pivot Tables
-
How to Visually Compare Reports, Teams, or Metrics
-
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
-
The Hidden Power of SUMPRODUCT for Data Analysis
-
Mastering SUMPRODUCT: The Easiest Way to Count Sports Wins & Losses
-
Mastering COUNTIFS & SUMIFS for Multi-Condition Data Filtering
-
The Secret to Summarizing Sales by Product & Store Using SUMIFS
-
Mastering COUNTIF & COUNTIFS for Election Data Analysis
-
How to Use COUNTIF & COUNTIFS to Analyze Large Data Sets
-
Excel Smart Formatting: Highlight Key Trends, Detect Errors & Automate Insights14 Topics
-
How to Use Conditional Formatting to Highlight Key Insights
-
How to Use Excel’s Highlight Cells Rules for Smarter Analysis
-
Highlight Trends & Insights Instantly Using Excel’s Built-In Features
-
How to Use Excel’s Conditional Formatting Formula Option for Smart Analysis
-
Master Conditional Formatting with Advanced Formula Tricks
-
Excel’s Hidden Feature: Stop If True for Advanced Data Formatting
-
Avoid Data Entry Mistakes with Smart Excel Rules
-
Advanced Data Validation: Keep Your Spreadsheets Clean and Accurate
-
How to Prevent Duplicate Entries with Data Validation
-
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
-
Mastering Excel’s Formatting Rules for Financial Auditing
-
How to Use Conditional Formatting to Highlight Key Insights
-
Smart Excel Workflows: Multi-Sheet Formulas, Auto-Updating Charts & Tables13 Topics
-
How to Set Up Multiple Worksheets with One Click
-
How to Use 3D Formulas to Summarize Data Across Multiple Worksheets
-
Automatically Sum Data Across Worksheets Based on Sheet Name
-
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
-
How to Use MOD, VLOOKUP, and ROW Functions for Cryptography
-
How to Filter Charts Dynamically Using Table Slicers
-
How to Set Up Multiple Worksheets with One Click
-
Unlocking the Power of Pivot Tables: Summarization, Trends & Data-Driven Decisions31 Topics
-
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
-
How to Master Pivot Tables (Even If You’re a Beginner)
-
Unlocking Data Patterns: Histograms, Descriptive Statistics & Anomaly Detection13 Topics
-
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 the U.S. Decides Congressional Seats – An Excel Breakdown
-
The Data Science Behind Dating – Learn It in Excel
-
How to Make the Best Decision Using Excel – Multi-Objective Decision Making
-
Has Income Really Grown? Let’s Look at the Data in Excel
-
How to Calculate Mean, Variance & Standard Deviation for Grouped Data
-
The Hidden Power of Histograms – Spotting Anomalies in Data
-
How to Analyze Salaries
-
Mastering Histograms: A Step-by-Step Guide
-
Data-Driven Decision Making: Regression, Trend Curves & Business Forecasting13 Topics
-
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
-
Converting Test Scores: A Data-Driven Approach
-
How to Predict Business Costs with Regression
-
Predicting Success with Multiple Regression: Pricing, Sales & Market Analysis19 Topics
-
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
-
Reverse Engineering Real-World Formulas with Regression
-
Find out how store placement affects book sales with this ANOVA tutorial.
-
How to Analyze Sales Data Using One-Way ANOVA
-
Sales Performance: Do Districts or Reps Matter More? Find Out Using Regression
-
Does Advertising Work Better at Lower Prices? Find Out Using ANOVA
-
Why Price and Advertising Don’t Always Work Separately: ANOVA with Interaction
-
How to Analyze Three or More Factors Using ANOVA and Regression
-
Probability in Action: How Businesses and Investors Use It to Make Decisions
-
How to Use Multiple Regression for Better Predictions
-
Smart Data Automation: Mastering OFFSET, INDIRECT & Dynamic Calculations21 Topics
-
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
-
Mastering INDIRECT: Fixing Common Issues with Spaces in Worksheet Names
-
How to Use INDIRECT and ADDRESS for Dynamic Conditional Formatting
-
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
-
How to Use OFFSET and INDIRECT for Income Distribution Analysis
-
How to Use Excel to Predict Wealth Inequality Across Populations
-
How to Use Excel to Analyze Election Fairness & Districting
-
The Vegas Gambler’s Excel Trick for Predicting Team Scores
-
The Truth About Technical Analysis: Does It Really Predict Market Moves?
-
Eliminating Volatile Functions: A Smarter Way to StructureFormulas
-
Using OFFSET to Automate Reports and Dynamic Calculations
-
Mastering Solver: The Key to Cost Reduction & Smart Business Strategies4 Topics
-
Data-Driven Negotiation: Fair & Profitable Deals with Excel Solver9 Topics
-
Stop Leaving Money on the Table—Optimize Negotiations with Solver
-
Mastering Fair Asset Division: The Power of Nash’s Nobel-Winning Solution
-
Why Maximizing POP (Proportion of Potential) Leads to Fair Negotiations
-
Stop Losing in Business Negotiations—Use Mathematical Optimization
-
Mastering Business Deals: Balancing Negotiation Power with Solver
-
How to Optimize Store-Contractor Negotiations Using Nash’s Solution
-
How to Ensure Fairness in Multi-Party Business Deals
-
How to Solve a Six-Player Negotiation Using Excel’s Solver
-
The Ultimate Guide to Negotiation Strategy with Reservation Values
-
Stop Leaving Money on the Table—Optimize Negotiations with Solver
-
Mastering Dynamic Arrays: Automate Sorting, Filtering & Data Retrieval17 Topics
-
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
-
Automate Complex Calculations with Excel’s Array Formulas
-
Predict the Future: Excel’s Best Tools for Accurate Sales & Demand Forecasting17 Topics
-
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
-
How to Compare Forecast Accuracy Using the Brier Score
-
How to Use Excel’s Forecast Sheet for Automated Sales Predictions
-
How to Use Excel’s Forecast Functions for Sales & Revenue Predictions
-
Optimizing Sales Predictions: Using Solver for Demand Forecasting
-
Predicting Future Search Interest with Google Trends & Excel’s Forecast Sheet
-
Measuring Forecast Reliability: Comparing Predictions vs. Actual Outcomes
-
Understanding Forecast Statistics: Confidence Intervals & Error Metrics
-
How to Forecast Time Series Data: Trend & Seasonality Explained
-
From Basic to Brilliant: How to Make Charts That Tell a Story32 Topics
-
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
-
Optimizing Data Visualization: Using Combo Charts for Better Comparisons
-
Excel Solver for Business Optimization: Smarter Decisions, Better Outcomes5 Topics
-
The Ultimate Guide to Discriminant Analysis with Excel Solver
-
Stop Guessing Customer Segments—Use Solver for Smarter Insights
-
Mastering Demand Forecasting: Measuring Price Sensitivity with Solver
-
Mastering AI Basics: Predicting Outcomes with Neural Networks
-
How to Train a Neural Network in Excel Using Solver
-
The Ultimate Guide to Discriminant Analysis with Excel Solver
-
Advanced Charting in Excel: Histograms, Pareto, Waterfall & More11 Topics
-
Histograms
-
Pareto Charts
-
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
-
Mastering Sales & Fundraising Pipelines with Funnel Charts
-
Histograms
-
Advanced Excel Functions: Automating Text, Logic & Financial Data4 Topics
-
Mastering Dynamic Arrays: Automate Sorting, Filtering & Data Retrieval10 Topics
-
Mastering Dynamic Arrays: Extract Unique Values Instantly
-
Stop Manually Updating Lists—Use UNIQUE with Tables Instead
-
Sorting Data Automatically with Dynamic Arrays
-
How to Use Excel Tables for Auto-Sorting Data
-
Mastering Excel’s FILTER Function: The Best Way to Automate Data Retrieval
-
Generating Number Sequences with the SEQUENCE Function
-
Generating Random Sequences with RANDARRAY
-
Referencing Dynamic Arrays: How to Use the Spill Operator
-
Mastering Self-Updating Dropdown Lists with UNIQUE and FILTER
-
Building Self-Updating Summary Tables Without Pivot Tables
-
Mastering Dynamic Arrays: Extract Unique Values Instantly
-
Mastering Power Pivot: Advanced Data Modeling & DAX for Smarter Analysis13 Topics
-
Power Pivot: The Best Way to Analyze Millions of Rows
-
The Secret to Fast and Dynamic PivotTables with Power Pivot
-
DAX Functions in Power Pivot: The Secret to Smarter Data Analysis
-
How to Count Unique Customers in Power Pivot with DISTINCTCOUNT
-
How to Compare Forecasted vs. Actual Sales in Power Pivot
-
How to Use the RELATED Function in Power Pivot to Link Data Tables
-
Mastering Power Pivot: Using Calculated Columns in Pivot Tables
-
How to Use Calculated Measures in Power Pivot for Year-Over-Year Comparisons
-
Mastering KPIs in Power Pivot: Track Goals with Visual Indicators
-
How to Take a Random Sample in Power Pivot (Step-by-Step Guide)
-
Extracting Random Samples from Specific Time Periods in Power Pivot
-
Mastering Power Pivot: Median Sales and Month-to-Date Analysis
-
Mastering Power Pivot: Using DATEADD for Yearly Comparisons
-
Power Pivot: The Best Way to Analyze Millions of Rows
-
Heat Maps & 3D Maps in Excel: Unlocking Powerful Geographic Insights6 Topics
-
Excel’s Hidden Mapping Tool: How to Create Stunning Heat Maps
-
How to Create a US Filled Map to Visualize Sales Data
-
How to Build a 3D Energy Map in Visualize Power Capacity
-
How to Create a 3D Animated Time Map
-
Mapping Political Data: Visualizing Election Results
-
Visualizing Public Transit Data: NYC Subway Stations
-
Excel’s Hidden Mapping Tool: How to Create Stunning Heat Maps
-
Dynamic Data in Excel: Geography, Stocks & Real-Time Information5 Topics
-
How to Use Excel’s Geography Data Type to Pull City Data Instantly
-
Mastering Geography Data: Get State Leaders & Population Instantly
-
The Best Way to Retrieve Dynamic Location Data with FIELDVALUE
-
Picking the Right Location: Resolving Geography Data Ambiguity
-
The Best Way to Fetch Live Stock Data Without External Tools
-
How to Use Excel’s Geography Data Type to Pull City Data Instantly
-
Data Transformation Made Easy: Power Query for Structuring & Cleaning Data13 Topics
-
Mastering Power Query: Pull Live Bitcoin Data with One Click
-
How to Download and Refresh US City Population Data
-
How to Use Power Query to Automatically Structure Sales Data
-
Mastering Power Query: Reshaping Flat Files for Better Analysis
-
How to Add Custom Columns in Power Query with Formulas
-
How to Combine Multiple Excel Tables into One with Power Query
-
Mastering Power Query: Merging All Workbooks in a Folder Automatically
-
Mastering Power Query: Fill Down & Unpivot Data for Better Reports
-
Mastering Power Query: Splitting Data into Rows and Columns Automatically
-
How to Group and Summarize Data Automatically with Power Query
-
Mastering Power Query: Grouping Data by Multiple Columns for Instant Summaries
-
How to Automatically Calculate Revenue Using Custom Columns in Power Query
-
Mastering Power Query: Converting Rows into Columns Automatically
-
Mastering Power Query: Pull Live Bitcoin Data with One Click
-
Mastering Macros: Automate Excel Tasks & Boost Productivity10 Topics
-
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 Macros: Step 1 – Adding the Developer Tab
Participants 407
This video explains how to copy a formula not involving “$” signs.
These are the two files needed to follow along to this video:
