Beginner Course

Basic Formulas – Index, Match, and Lookups 20 Topics

Expand

Lesson Content

0% Complete 0/20 Steps

From Manual to Automatic: Formula Essentials for Efficiency

Forecast Customer Trends with Churn Rates

Build Dynamic Spreadsheets for Real-World Scenarios

Real-World Excel Skills: Diving Scores Explained

Economic Insights: Learn to Compute the Gini Index

Master Excel Functions to Build Custom Tables

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

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

Range Names 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

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

Using Range Names for Dynamic Lookup Formulas

Text Functions 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

How to Clean and Organize Data with Text Functions

Mastering Text Functions: Split and Organize Data

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

Rounding Numbers for Cleaner Calculations

Date and Financial Functions 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

Mastering Date Functions: From TODAY to NETWORKDAYS

Use DATEDIF for Accurate Time and Date Analysis

How to Insert Static Dates and Times

Build and Edit Custom Lists for Speedy Workflows

Find Holiday Dates Dynamically Using WEEKDAY and INDEX

Master Financial Decision-Making with NPV

Mastering XNPV: Smarter Investment Calculations

Compare Investments Using the IRR Function

Evaluate Investments Like a Pro with XIRR and MIRR

Retirement Planning Made Easy with Excel’s PV and FV Formulas

Mastering Loan Analysis with Excel’s Financial Functions

Auditing Tools, Circular References, and IF Functions 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Master Spreadsheet Analysis with Excel’s Audit Functions

How to Resolve Circular References Using Excel’s Iterative Tools

Data Tables, Goal Seek, and Scenario Manager 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Conditional Counts and Sums 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

COUNTIF and COUNTIFS Functions

COUNT, COUNTA, and COUNTBLANK Functions

SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS

SUMIFS With Duplicates

Subtotals

Conditional Counts and Sums With Non-Blanks

Benford

Finding the N

Analyzing NFL Play Effectiveness

Conditional Formatting and Data Validation 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Top and Bottom Rules

Highlight Cells Rules

Data Bars, Color Scales, and Icon Sets

Formula Option Part One

Formula Option Part Two

Data Validation

Conditional Formatting and Sports Part One

Conditional Formatting and Sports Part Two

Tables 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Worksheet Templates

Three Dimensional Formula

Aggregate Function with Slicers

Pivot Tables 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Introduction to Pivot Tables

Analyzing Pivot Table Data

Text Filters

Grouping and Pivot Charts

Value Field Settings and Show Values As

Calculated Fields

Slicers and Filters

Timelines

Analyzing Surveys and More Pivot Charts

Putting it all Together

Descriptive Statistics 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Histogram Creation

Histogram Shapes

Descriptive Statistics

Rule of Thumb

More Statistical Functions

Charting 16 Topics

Expand

Lesson Content

0% Complete 0/16 Steps

Combo and Secondary Axis Charts

Handling Missing Data

Handling Hidden Data

Adding Pictures to Column Graphs

Check Boxes and Chart Dashboards

List Boxes and Chart Dashboards

Keystroke Shortcuts 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Keystroke Formatting Shortcuts

Worksheet Movement

Keystroke Formulas

Cell Selection Shortcuts

Hyperlinks

Linking Excel Data

Protecting a Worksheet

Format Painter and the F4 Key

Advanced Charts 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Visualize Data Using the REPT Function

Pareto Charts

Boxplots One Variable

Boxplots More Than One Variable

Waterfall Chart – Time Series Data

Waterfall Chart – Revenue to Profit

Treemap Chart – Bookstore

Sunburst Chart – Bookstore

Sunburst Chart – Monthly Breakdown

Treemap Chart – Restaurant

Macros 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Inserting the Developer Tab

Inserting a List of Names

Relative Reference With Macros

Using Macros to Format Cells

Formatting a Range of Variable Size

Using a Macro to Freeze Values

Using Macros For Reporting

Creating a Border With a Macro

Personal Macro

Sorting Macro

Course Content

OVERVIEW

About Instructor

Wayne Winston

Course Includes

CONTACT INFO

CONTACT INFO