Basic Formulas Part One
This video explains how to copy a formula not involving “$” signs.

Basic Formulas Part Two
This video explains how to copy formulas across rows and down columns, the meaning of $ signs, and setting up a dynamic model of customer evolution.

Basic Formulas Part Three
This video explains how to create a worksheet that computes students final grades based on homework and exams.

Computing a Production Function 
In this video we show how to compute a production function which shows how labor and cloth can be transformed into dresses.

Diving Score
This video explains using the LARGE function to help compute Olympic Diving Scores.

Gini Index
This video shows how to use Excel to compute a complex important formula (Gini index measuring income inequality). It also discusses Order of Operations (PEMDAS).

Body Mass Index
This video shows how to use PEMDAS to compute Body Mass Index (BMI).

Big Mac Index
In this video we use the Economist’s Big Mac Index and basic spreadsheet formulas to show that the Chinese currency is vastly undervalued.

Modeling Supply and Demand
This video explains how to create a simple chart to model supply and demand for a product.

Cost Curves
This video explains how to use PEMDAS to compute basic economic cost curves (Average Cost, Marginal Cost, etc.).

Retirement
This video explains how to model the evolution of a retirement fund.

Modeling Fish in a Pond
This video explains how to create a dynamic model that shows the evolution of the number of fish in a pond.

Amortization Schedule
This video explains how a loan payment reduces the balance of a loan by the end of the loan term.

Depreciation
This video shows how to model 3 different methods of depreciation used to depreciate a machine to its final salvage value.

Gravity Model 
This video explains how to implement a complex formula, the Gravity Model which computes market shares for stores based on their locations and quality.

Butterfly Effect
This video illustrates the Butterfly effect: If a butterfly flaps its wings in Tahiti it may cause a snowstorm in Kansas.

Variance Analysis
In this video we show how to decompose a sales variance into a volume, product mix, and price variance.

Vertical Lookup
This video shows how to use the VLOOKUP function to compute a tax rate based on income and a products price based on its code.

Horizontal Lookup
This video uses the HLOOKUP function to lookup sales and employees during each month.

Product Prices Based on Date
This video uses a VLOOKUP to determine a product’s price based on a date when the price changes over time.

Vertical Lookup From Multiple Worksheets
This video shows how to use a VLOOKUP to efficiently pull multiple columns of data from different worksheets.

Vertical Lookup From Multiple Columns
This video shows how to efficiently pull multiple columns of data using a VLOOKUP and the COPY command.

Index Function
This video introduces the INDEX function.

Index With Rows and Columns
This video shows how to use the INDEX function to pick off an entire row or column.

Match Function
This video defines the MATCH function and explains the three values (-1,0 and, +1) that are related to the lookup type.

Combining Match and Index
This video shows how to combine the MATCH and INDEX functions to lookup the distance between two cities based on their names.

Match, Index, and Large Functions
This video shows how to use the MATCH, INDEX, and LARGE functions to find the country with the n’th largest population.

Finding the Most Recent Date of a Sale 
This video shows how to use MATCH lookup type +1 to find the date of the most recent sale.

Cost of Living 
In this video we answer the question: Is a $140,000 salary in New York better than a $110,000 salary in West Virginia?

Currency Exchange
In this video we create a calculator to determine the exchange rate between any two currencies. 

Predicting the Future of the US Population
In this video we show how to use the copy command and the vlookup function to help us predict the future age distribution of the US population.

The CHOOSE Function
In this video we show how the CHOOSE function can be used as an alternative to Lookup formulas.

VLOOKUPS and Income Taxes
In this video we use 3 VLOOKUPS to compute the amount of federal taxes owed for any amount of after-tax income.

Math is Fun 
In this video we use Excel to illustrate three beautiful results from elementary mathematics.

Rule of 72 
In this video we show how the Rule of 72 allows you to easily approximate for a given annual interest rate, the number of years needed to double your money.

Bringing PDF Tables Into Excel
In this video we show how to import tables from a PDF file into Excel.

Multiplying 4 Consecutive Integers
In this video we use Excel formulas to demonstrate that whenever you multiply 4 consecutive integers and add 1 you get the square of an odd integer.

Explaining Google’s Page Rank
In this video we discuss the intuitive basis for Google’s Page Rank algorithm, which is used to rank web pages that are shown in response to search requests.

The XLOOKUP Function
In this video we introduce the incredibly powerful XLOOKUP function, which makes HLOOKUP and VLOOKUP functions obsolete!

XLOOKUP and the TRUE Argument 
In this video we show how the XLOOKUP function can return multiple arguments when data for each item is in different rows (not columns) and how XLOOKUP can extend the VLOOKUP function with the TRUE argument.

XLOOKUP and the INDEX MATCH Combination
In this video we show how to use the XLOOKUP function to extend the INDEX MATCH combination.

Using XLOOKUP to reference a cell Range 
In this video we show how XLOOKUP can be used to reference a range of cells in a table based on the start  and end row (or column) chosen.

Basic Filters
This video shows how to filter based on selecting entries in a column.

Number Filters
This video shows how to filter based on numerical data.

Top 10 Filtering
This video shows how to pick out top 10, bottom 10, and the top 5% from a column.

Date Filters
This video shows how to filter based on dates.

Text Filters
This video shows how to filter based on text.

Color Filters
This video shows how to filter based on cell or font color.

Filtering a Column on Two Criteria
This video shows how to filter a single column based on text and cell color.

Basic Sorting
This video shows how to sort based on text, numbers, and dates.

Sorting on Colors
This video shows how to sort based on cell or font color.

Sorting A to Z
This video shows how to sort without using the sort dialog box.

Case Sensitive Sorting
This video shows how to sort with lower case entries coming before upper case entries.

Sorting With a Custom List
This video shows how to sort using a custom list.

Creating a Custom List
This video shows how to create a custom list and use it in sorting.

Sorting Across
This video shows how to sort across a row instead of a column.

Removing Duplicates
This video shows how to remove duplicates.

Filter by Selection
This video shows how you can filter a spreadsheet database simply by selecting items in the database. For example, selecting a player on the Boston Red Sox will filter the database to  show only members of the Red Sox.

Name Box
This video shows how to create range names using the Name Box.

Create From Selection
This video shows how to create range names based on spreadsheet text using Create from Selection and using the Name Manager to edit and delete range names.

F3 Trick
This video shows how to use the F3 key to paste a range name into a formula.

Name Entire Row or Column 
This video shows how to name an entire row or column.

Apply Names
This video shows how to ensure that if you create range names, they will show up in previously created formulas.

Worksheet and Workbook Names
This video shows how you can create range names that apply to only a single worksheet or the entire workbook.

Range Name Tricks
This video shows how to use a named row in a formula and create ranges based on Excel formulas.

Implicit Intersection
This video shows how to pick off an entry in an array by simply typing the row and column headings.

Vertical Lookup With Range Names
This video shows how to use Range names in VLOOKUP formulas.

Left, Right, Mid, Len, and Concatenate Functions
This video shows how to use the LEFT, RIGHT, MID, LEN and CONCATENATE functions to manipulate text in a single cell.

Find Function and Text to Columns
This video shows how to use the FIND function and TEXT to COLUMNS to parse data in a single cell.

Histograms
This video shows how to use the REPT function to create a simple histogram.

Clean Function
This video shows how to Use the CLEAN, FIND, and SUBSTITUTE functions to remove invisible characters from your data.

Flash Fill
This video shows how to use FLASH FILL in Excel 2013 and 2016 to automatically perform the work of text functions.

Control + E and Flash Fill
In this video we show how Control + E makes Flash Fill perform better.

Finding the Last Word
This video shows how to use the SUBSTITUTE function to find the last word in a cell.

Two Column Lookup
This video shows how to use a VLOOKUP based on multiple columns of data.

Social Security Numbers
This video shows how to turn Social Security Numbers into PeopleSoft IDs.

Unicode
This video shows how to use Excel’s vast library of UNICODE characters.

Creating an Email List With Text Functions
This video shows how to take a list of email aliases and turn it into an email list.

The TEXT Function
In this video we show how the TEXT function can ensure that a value in one cell is converted in a different cell to any desired number format.

The ROUND, ROUNDUP, ROUNDDOWN, and INT Functions
In this video we show how to use the ROUND, ROUNDUP, ROUNDDOWN, and INT functions to round numbers in any desired fashion.

Special Text Formats
In this video we show how to format zip codes, social security numbers, phone numbers, beginning zeroes, and trailing zeroes.

Using Flash Fill to Clean Messy Data
This video shows how to use Flash Fill to eliminate invisible characters. When using a VLOOKUP, invisible characters will return an error message.

Auditing
This video shows how to use Precedents to see which cells are needed to compute a formula and using Dependents to find cells that are dependent on spreadsheet inputs.

Circular Reference
This video shows how circular references can be used and resolved.

IF Statements
This video shows how to use IF statements to calculate purchasing costs and analyze the game of craps.

Odds and Evens
This video explains how to use IF statements and the MOD function to determine the winner in odds and evens.

Annual Revenue
This video shows how to use IF statements to extract annual sales from quarterly sales data.

Product Life Cycle
This video shows how to use IF statements to model sales during the product life cycle.

Flatten Table
This video shows how to use IF statements to extract the data in a 20 row by 12 column table into 240 different rows.

Error Trap
This video shows how to use the IFERROR function to remove error messages from your spreadsheets. It also covers the AGGREGATE function which allows you to ignore error values in calculations.

NFL Scores
This video shows how to use the IFERROR function to copy a formula down many rows when every 10th row has headings and not data.

The ISERROR Function
In this video we show how to use the IF and ISERROR functions to adjust a professor’s number of students based on whether a course lasted half a semester.

Divide by 7
This video shows how to determine if a check number like 2453589-6 has the sum of digits divisible by 7.

Valuation 
This video shows how to use a two stage growth model to reverse engineer a stock price.

Combining Addresses
This video shows how to efficiently put information for 1000 people in a single row if you have a person’s name in one row, street address in another row, and city in the next row.

IF Statements And Sales Commission Calculations
This video shows how to use IF statements to compute sales commission based on a tiered commission structure.

IF Statements And Sales Commission Calculations Part Two
In this video we use VLOOKUP, MATCH, INDEX, And IF functions to model a complex sales incentive plan.

IF Statements And Option Investing
This video shows how IF statements can be used to model investment strategies involving options.

IF Statements Continued
In this video we use IF statements to model customer value, insurance premiums, and a person’s future salary.

Basic Shift Code
In this video we show how ASCII characters, IF, IFERROR, VLOOKUP, MATCH, and INDEX Functions can be used to implement Julius Caesar’s famous basic shift code.

Rail Fence Code
In this video we show how to use IF Statements and Text Functions to Implement the Famous Rail Fence Code.

Longest Winning Streak
In this video we use IF statements to find the longest winning streak by the Washington Nationals during the 2016 season.

The Ducci Sequence
In this video we show how to use IF statements and the MATCH function to study the Ducci sequence

The Stern Sequence
In this video we use IF statements, the ISEVEN function, and the INDEX function to model the amazing Stern Sequence

How does waist to height ratio affect your longevity?
In this video we use IF statements and Range Names to show how interpolation can be used to determine how the ratio of your waist to height determines how many years (on average) you will live.

Combining the IF and IFERROR Functions
In this video we show how to combine the IF and IFERROR functions in a single formula that is used to determine if a given school is an elementary school.

One Way Data Table
This video shows how to use a One Way Data Table to determine how changing a single spreadsheet input affects multiple outputs.

Two Way Data Table 
This video shows how to use a Two way data table to determine how changes in two spreadsheet inputs affect a single output.

Mortgage Data Table
This video shows how to use a Two way data table to determine how the monthly payment on a loan depends on the loan size and annual rate.

Customer Value
This video uses a Two way data table to determine how a customer’s value depends on the time value of money and customer retention rate.

Goal Seek 
This video shows how Goal Seek can be used to determine the number of unit sales needed for a juice bar to break even.

Goal Seek Finance
This video shows how to use Goal Seek to determine the annual rate on a loan that makes the monthly payment hit a desired value.

Time to Breakeven
In this video we use Goal Seek to determine the number of weeks of sales needed to breakeven.

Scenario Manager
This video shows how the Scenario Manager can be used to describe how scenarios involving multiple spreadsheet inputs influence multiple spreadsheet outputs.

Down Payment
This video shows how to use a Two way data table to determine how the return on equity for a home investment depends on the size of the down payment and the change in home value.

Project Management
This video shows how to use a One-Way data table to determine the critical activities in a project.

Hedging
This video shows how to use a One way data table to show how hedging with puts can reduce equity risk.

Bill Belichick’s Bold Move
This video explains how to use a Two way data table to show that Belichick was right when he went for it on 4th down against the Colts.

IF Statements and Data Tables
In this video we combine IF statements and a one-way data table to calculate how many antitrust cases were active during the years 1960-2016.

Data Table Chart
In this video we show how to create a chart to summarize the numbers in a two-way data table.

Hedge Funds
In this video we use a one-way data table to show how a simple hedge fund strategy neutralizes market risk.

The Syracuse Problem
In this video we use IF, MATCH, the ISEVEN function, and data tables to describe the famous Syracuse Problem conjecture

Relating Bond Price and Yield
In this video we use data tables to show the relationship between bond prices and yields.

Creating a Data Table Based on a Model in a Different Worksheet
In this video we show how to create data table based on a model in a different worksheet.

COUNTIF and COUNTIFS Functions
In this video we show how the COUNTIF and COUNTIFS functions are used to do conditional counts on single or multiple criteria.

COUNT, COUNTA, and COUNTBLANK Functions
In this video we show how COUNT, COUNTA, and COUNTBLANK functions are used to count cells in a range containing numbers, non-blanks, or blanks.

SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS Functions
This video shows how the SUMIF and AVERAGEIF functions are used to calculate conditional sums and averages based on a single criterion. It also shows how the SUMIFS and AVERAGEIFS functions are used to calculate conditional sums and averaged based on multiple criteria.

SUMIFS With Duplicates
This video shows how the SUMIFS function and the Remove Duplicates functionality are used to calculate the sales each sales person made of each product.

Subtotals
This video shows how SUBTOTALS are used to determine how much each salesperson sold in each region.

The SUBTOTAL Function
In this video we show how the SUBTOTAL function can be used to perform calculations that ignore hidden rows or just include filtered rows.

Using The Subtotal Function To Count Cells With Colors
In this video we use the SUBTOTAL function to count the number of cells in a range that have a certain color.

Sorting Subtotals
In this video we show how you can sort Subtotals of revenue so the largest revenue shows on top.

Data Consolidate
This video shows how data consolidate is used to combine data from several workbooks to calculate total sales of each product during each month.

Summing Data in Different Worksheets
This video shows how to consolidate data in a single workbook.

Showing Data in Different Worksheets Side by Side
This video shows how to easily display the data in different worksheets in a side by side summary display.

Database Functions
This video shows how the DCOUNT, DSUM, and DAVERAGE functions are used to compute conditional counts, sums, and averages. It includes doing conditional calculations based on an “OR” criteria.

Computed Criteria
This video shows how Database functions are used with criteria based on an Excel formula.

DGET Function
This video shows how to use the DGET function to pull the location of a transaction based on the date and ID code.

Advanced Filter
This video shows how the Advanced Filter can be used to extract any subset of a spreadsheet’s data and copy this data to a new location.

Conditional Counts and Sums With Non-Blanks
This video shows how to do conditional sums and counts where one criteria is that the cell does not contain a blank.

Benford’s Law
In this video we show (amazingly) that for 70% of all countries the first digit in their population is 1,2,3, or 4!

Finding the n’th Match
In this video we show how to find the n’th match to a word in a column.

Analyzing NFL Play Effectiveness
In this video we show how to use text functions, IFERROR, COUNTIF, and AVERAGEIF functions to analyze the effectiveness of Adrian Peterson’s off tackle runs.

Using the SUMPRODUCT Function for Conditional Sums and Counts
In this video we show how to use the amazing SUMPRODUCT function to calculate conditional counts and sums

How Many Winning Seasons?
In this video we use the amazing SUMPRODUCT function to count the number of winning and losing seasons the San Antonio Spurs had.

Using OR Criteria with Conditional Counts, Sums, and Averages
Usually conditional counts, sums, and averages utilize AND criteria. In this video we show how to utilize OR criteria with these functions.

Computing Sales
In this video we use the SUMIFS functions to compute sales of all products at each of 221 beauty stores for a specified range of dates.

Ranked Choice Voting
In this video we use the COUNTIF and COUNTIFS functions to show how ranked choice voting works.

Top and Bottom Rules
This video shows how to highlight the 20 warmest temperatures since 1881 and all above average and below average temperatures since 1881.

Highlight Cells Rules
This video shows how to highlight duplicates, any cells containing a given text string, and highlighting cells based on criteria involving dates.

Data Bars, Colors Scales, and Icon Sets
This video shows how Data Bars, Color Scales, and Icon sets are used to summarize numerical data.

Formula Option Part One
This video shows how cells can be formatted based on a complex Excel formulas. For example, highlight in green, each quarter a company’s sales increase, and in red each quarter a company’s sales decrease.

Formula Option Part Two
This video continues to show how to conditional format based on a formula.

Stop if True
This video shows how to use the Stop If True Criteria to highlight 10 states that have the highest income with an up arrow and not highlight any other states.

Data Validation
This video illustrates how Data Validation can return an error message when incorrect data is entered. For example, if we enter that an NBA team scored 1000 points, we receive an error message. We also show how to create a drop-down list from which a user selects an input.

Custom Option
This video shows how Data Validation criteria can be set up with Excel formulas. For example, we show how to ensure that entering any non-numerical entry in column A creates an error message.

Using Data Validation To Prevent Entry Of Duplicates
In this video we show how to use data validation to prevent users from entering duplicate rows in a workbook

Circle Invalid Data
This video shows how to ensure that data not meeting a desired criteria is circled.

Highlighting New Hires
This video shows how to highlight employees who have just been hired.

Conditional Formatting and Sports Part One
In this video we show how to highlight all baseball players who are good on HR’s, Stolen Bases, and Batting Average.

Conditional Formatting and Sports Part Two
In this video we show how to use data bars, color scales, and icon sets to format sports data.

Conditional Formatting and Fraud Detection
In this video we show how conditional formatting can be used to perform many tests that are used to detect fraud in financial transaction data.

Worksheet Templates
This video shows that if you need a worksheet for each state set up in an identical format, how to easily use worksheet templates to set up the 50 needed worksheets.

Three Dimensional Formula
This video shows how three dimensional formulas can be used to sum data across worksheets.

Three Dimensional Formulas With Wildcards
This video shows how to write 3D formulas that do calculations based on a worksheet name.

Paste Special
This video shows how the Paste Special Menu can be used to transpose data and divide “spread out cells” in a worksheet by 100

Tables Introduction
This video shows how making data a Table ensures that formulas update automatically when new data is added.

Table Graphs
In this video we show how making data a Table ensures that charts update automatically when new data is added.

Table Slicers

In this video we show how slicers can be used to “slice and dice” the data in Tables.

Table Extended
In this video we show how tables make drop down boxes, VLOOKUPS, SUMIF formulas and NPV calculations automatically update when new data is added.

Aggregate Function With Slicers
In this video we show how the AGGREGATE function is needed to ensure calculations based on Table Slicers are correct.

Conditional Formatting Tables
In this video we show how to make Conditional Formats based on Formulas update automatically when new data is added.

Copying Formulas Across Tables
This video shows how copying formulas across a table can be tricky.

Vignere Code
In this video we use VLOOKUP, ROW(), CHAR, MOD functions and the Table feature to encode and decode messages using the Vignere Code.

Filtering Charts With Table Slicers
In this video we show how to use Table Slicers to filter charts.

Introduction to Pivot Tables
In this video we introduce PivotTables and show how to collapse and expand fields, sort data, and drill down to source data.

Analyzing Pivot Table Data
In this video we show how to ensure that a PivotTable updates automatically when new data is added and how to use Value Filters to determine customers that generate 80% of our sales.

Text Filters
In this video we show how text filters are used to filter a PivotTable based on text.

Grouping and Pivot Charts
In this video we show how to group data in a PivotTable and create a chart based on a PivotTable.

Value Field Settings and Show Values As
In this video we show how to summarize data as a Percentage of a Row or Column.

Calculated Fields
In this video we show how to create a calculated field based on PivotTable columns.

Slicers and Filters
In this video we show how slicers allow you to slice and dice sales by country and product.

GETPIVOTDATA Function
In this video we show how GETPIVOTDATA is used to extract data from a PivotTable for use in reports and charts.

Calculated Items
In this video we show how to create a calculated item based on rows in a PivotTable. For example, group together all cars made in Germany in a Calculated Item called Germany.

Using Solve Order to Change Order of Calculations
In this video Solve Order is used to change the order in which Calculated Items are computed.

Timelines
In this video we show how to slice and dice PivotTable calculations based on any subset of months, quarters or years. The functionality of this video is for Excel 2013 and Excel 2016 users.

Analyzing Surveys and More Pivot Charts
In this video we show how to summarize a survey with a PivotTable and PivotChart.

Creating Pivot Tables From Multiple Ranges
In this video we show how to create PivotTables from data in multiple worksheets and/or workbooks.

Multiple Pivot Tables
In this video we show how to create many PivotTables based on a Filter.

Data Model
In this video we show how Excel 2013 and 2016 users can use the Data Model to efficiently link data without using thousands of VLOOKUPS.

Pivot Tables and the NBA Part One
In this video we show how to use Pivot Tables to analyze NBA players.

Pivot Tables and the NBA Part Two
In this video we continue to show how Pivot Tables can be used to analyze NBA players.

Why Are There Fewer Births On Weekends?
In this video we show that the lack of C sections on weekends explains why there are fewer births on weekends.

Republican Congress
In this video we use PivotTables to show why Democrats get more votes for Congress yet more Republicans win.

PivotTables and Dating
In this video we show how to use PivotTables to analyze the dating preferences of men and women.

Simpsons Paradox
In this video we show how PivotTables illustrate the classical Simpson’s Paradox.

Putting it all Together
In this video we show how to use IF, VLOOKUP, PivotTables, and AVERAGEIFS functions to solve a tax accounting problem.

Election Demographics
In this video we use PivotTables and Slicers to analyze preferences of various demographic groups for Donald and Hillary.

Editing Pivot Table Default Features with Office 365
In this video we show how subscribers to Office 365 can now easily update their Pivot Table defaults

Using Multiple Slicers with Pivot Tables
In this video we show how slicers can be set to control more than one PivotTable

Conditional Formatting and PivotTables
In this video we show how to apply Excel’s great Conditional Formatting capabilities to PivotTables

Pivot Tables and Unrecognized Dates
In this video we show how to group orders by month when Excel doesn’t like your date format.

Summarizing Bitcoin Data
In this video, using daily returns on bitcoin, we show how to summarize average returns by month, year and quarter of the year.

More on Calculated Fields
In this video we use calculated fields to determine total sales by year and fraction of sales each year that are promotional sales.

Using Custom Groups to Compute Net Promoter Score
In this video we use Custom Grouping in a Pivot Table to compute an important marketing metric, the Net Promoter Score.

Formatting a Single Pivot Table Cell and Moving a Pivot Table In this video we show how in Excel 2019 and Office 365 you can move a Pivot Table and format a single cell in a Pivot Table.

Histogram Creation
In this video we show how to use a histogram to summarize Cisco’s monthly returns.

Histogram Shapes
In this video we discuss symmetric, positively, and negatively skewed histograms.

Descriptive Statistics
In this video we discuss measures of typical value, varation about the mean, and skewness.

Rule of Thumb
In this video we discuss how to determine normal variation for any data set.

More Statistical Functions
In this video we discuss the PERCENT, PERCENTRANK, LARGE, SMALL, and RANK functions.

Taking a Random Sample
In this video we show how to take a random sample size of 50 from 285 NBA players.

Congressional Apportionment
In this video we show how to fairly allocate members of the House of Representatives based on state populations.

Matchmaker
In this video we show how statistical functions and data tables can be used to find your “perfect match.”

Multiple Objective Decision Making
In this video we show how to choose a job based on multiple objectives.

Income Inequality
In this video we use PivotTables, PivotCharts, and Exce Statistical functions to analyze the changes in the distribution of US family income between 2000 and 2015.

Descriptive Statistics for Grouped Data
In this video we show how to compute the mean, variance, and standard deviation for grouped data.

Chinese Accidental Deaths and Histograms
In this video we use a histogram to prove that Chinese provinces under-report accidental deaths.

Describing Baseball Salaries
In this video we show how to create a histogram based on text and use box plots and histograms to describe Major League Baseball Salaries.

Linear Regression Part One
In this video we show how to find the line best fitting a set of bivariate data.

Linear Regression Part Two
In this video we show how the RSQ, SLOPE, INTERCEPT, and STEYX functions can be used to analyze a linear regression.

Exponential Growth
In this video we show how exponential growth can be used to fit bivariate data where the graph gets steeper.

Power and Demand Curves
In this video we show how to fit a constant elasticity or power demand curve.

Polynomial Demand Curves
In this video we show how to fit a quadratic demand curve based on 3 data points.

Learning Curves 
In this video we show how to estimate a Learning curve which shows how the unit cost of producing a product drops as more of the product has been produced.

Correlation
In this video we show how the concept of correlation can measure the strength of the linear association between monthly returns on six stocks.

Estimating the Beta of a Stock
In this video we show how the SLOPE function can be used to quickly estimate the Betas of many stocks.

Regression to the Mean
In this video we show how the idea of Regression to the Mean explains why NFL teams that do well in one season usually do not do as well the next season.

Moving Average
In this video we show how to summarize quarterly Amazon.com revenues with a Moving Average Chart and smooth out the trend and eliminate seasonality.

Finding a Good R Squared
In this video we show that an R Squared value of 0.99 is not necessarily that good.

Finding the Best Curve to Fit Data
In this video we show how to determine which of the linear, exponential, and power curve best fit a bi-variate relationship.

Converting ACT scores to SAT scores
In this video we use regression to show how to convert an ACT score to an SAT equivalent.

Multiple Regression Part One
In this video we show how multiple regression is used to predict computer sales per-capita based on education and income.

Multiple Regression Part Two
In this video we continue from the previous example.

Dummy Variables
In this video we show how to incorporate qualitative variables such as seasonality to predict auto sales.

Introduction to Conjoint Analysis
In this video we show how conjoint analysis can determine what product attributes are valued by customers.

Conjoint Analysis and Regression
In this video we show how an actual regression is used to illustrate conjoint analysis.

Value Based Pricing
In this video we show how conjoint analysis is used to estimate the value of product attributes.

Nonlinearities and Interactions
In this video we show how to include nonlinearities and interactions in a multiple regression analysis.

What Makes NBA Teams Win
In this video we use multiple linear regression to show what makes NBA teams win.

QB Rating
In this video we show how to use multiple regression to closely approximate the NFL’s QB Rating formula.

Maximum Likelihood Estimation
In this video we show how Maximum Likelihood Estimation is used to estimate statistical parameters.

Logistic Regression
In this video we show logistic regression can be used to predict dependent variables that can assume two outcomes (such as Live or Die after an operation.)

Logistic Regression for Grouped Data
In this video we explain how to do logistic regression with grouped data

The Windchill Index
In this video we use multiple regression with nonlinearities and interactions to reverse engineer the complex Windchill Index formula.

Predicting Wine Prices
In this video we show how to use multiple regression to predict prices of Bordeaux wine based on temperature and rainfall.

One Way ANOVA
In this video we show how to perform a One-Way ANOVA.

Randomized Blocks
In this video we show how to perform a Two-Way ANOVA with no replication.

Two Way ANOVA Without Interaction
In this video we show how to analyze a Two-Way ANOVA with no interaction.

Two Way ANOVA With Interaction
In this video we show how to analyze a Two-Way ANOVA with interaction.

ANOVA With More Than Two Factors
In this video we show how to determine how 3 or more factors can be set to optimize a dependent variable.

Offset Function
In this video we define the complex, powerful, and often misunderstood OFFSET function.

Left Hand Lookup
In this video we use the OFFSET function to emulate a VLOOKUP when the look value is matched in the right-hand and not left-hand column of a spreadsheet range.

Offset Cost
In this video we show how the OFFSET function can be used to create (in 2 minutes) thousands of formulas that create Phase I, II, and III costs for a drug.

Offset Account
In this video we show how the OFFSET, MATCH, and INDEX functions can analyze tax data imported from a PDF.

Most Recent Sales
In this video we show how the OFFSET function is used to return the most recent month of sales.

Dynamic Range
In this video we show how to create a dynamic range that automatically expands when new rows or columns of data are added.

Graphing the Last 6 Months of Sales
In this video we create a chart that always shows the last 6 months of sales.

Indirect Function
In this video we define the complex, powerful, and often misunderstood INDIRECT function.

Indirect Consolidate
In this video we use the INDIRECT function to consolidate data from any subset of cells in any subset of worksheets into a single summary.

Indirect With Spaces
In this video we show how to create worksheet cell combination addresses when the sheet names have spaces.

Indirect Formatting
In this video we show how to use the INDIRECT and ADDRESS functions to set up conditional formatting where you select a row heading and the formatting changes.

Indirect Range
In this video we use the INDIRECT function to efficiently copy formulas involving Range Names.

Worksheet Names
In this video we show how to easily find all the worksheet names in a workbook.

Nested Drop Down
In this video we show how to create a Nested Dropdown box where the entries in the second dropdown box depend on the value selected in the first dropdown box.

Indirect Function and Stocks
In this video we show how to use the INDIRECT function to move monthly stock return data in 30 different worksheets to a single worksheet where the data can be analyzed.

Income Distribution Part One
In this video we begin to show how to use a country’s GINI coefficient (a measure of income inequality) to determine the entire distribution of a country’s income

Income Distribution Part Two
In this video we finish showing how to use a country’s GINI coefficient (a measure of income inequality) to determine the entire distribution of a country’s income

One Man One Vote?
In this video we explain the concept of “wasted votes” and show how this metric may determine thefuture of American politics

Average Points Scored
In this video we show how to find the average points scored by an NBA team during their last 5 games.

Technical Analysis
In this video we use the OFFSET function and Data Tables to show that a Moving Average Trading Rule does not beat Buy and Hold.

Using the INDEX Function to Return a Cell Address
In this video we show how the INDEX function can be used to return a cell address rather than a cell value.

Introduction to Solver Part One
In this video we introduce the concept of optimization and show how the Excel Solver can be used to find a profit-maximizing product mix.

Introduction to Solver Part Two
This video builds upon the previous video on Solver Optimization.

Pricing Model
In this video we show how to estimate the demand for lipstick and use Solver to find a profit-maximizing price.

Demand Sensitivity to Price Change
In this video we show how to determine for a given percentage price change, the change in demand needed to break even.

Two Person Negotiation Part One
In this video we show how to fairly divide property in a divorce settlement.

Two Person Negotiation Part Two
In this video we conclude our discussion of fairly dividing property in a divorce settlement

Why Maximize POP (Proportion of Potential)
In this video we show why it is reasonable to maximize POP (Proportion of Potential).

Store Contractor Negotiation Part One
In this video we show how a store and a construction contractor can negotiate on multiple issues.

Store Contractor Negotiation Part Two
In this video we continue our discussion of how a store and a construction contractor can negotiate on multiple issues.

Store Contractor Negotiation Part Three
In this video we conclude our discussion of how a store and a construction contractor can negotiate on multiple issues.

Three Player Negotiation
In this video we show how to allocate property among 3 participants.

Six Player Negotiation
In this video we show how 6 segments of Congress can compromise on difficult issues.

How to Determine Reservation Levels
In this video we show how to determine a person’s level of satisfaction if negotiations fall through.

Introduction to Array Formulas and Functions
In this video we show how array formulas and functions can fill more than one cell.

Simple Examples of Array Formulas
In this video we use simple examples to enhance your understanding of array formulas.

Array Formulas and Text Functions
In this video we show how to use array formulas to find the total length of cells in a range or the length of the longest cell in the range.

Finding Smallest Numbers in a Range
In this video we show how to find the 6 smallest numbers in a range.

Emulating SUMIF and DSUM
In this video we show how array formulas can emulate the SUMIF and DSUM functions.

Emulating SUMIFS
In this video we show how an array formula can emulate the SUMIFS functions.

Emulating the OR Operator With Arrays
In this video we show how an array formula can select rows for a conditional sum based on an “OR” criteria.

Creating the MEDIANIF Function
In this video we use an array formula to create a MEDIANIF function.

Creating the STDEVIF Function
In this video we use an array formula to create a Standard Deviation If function.

Conditional Products
In this video we show how the SUMPRODUCT function can be used to set up a criteria used to select rows in which columns are multiplied.

Finding Unique Entries in an Array
In this video we use an array formula to find all unique entries in an array.

Transpose Function
In this video we show how the TRANSPOSE function can be used to dynamically transpose a row of data into a column.

Frequency Function 
In this video we show how the FREQUENCY array function can be used to count the number of observations in a data set that fall into several bin ranges.

Matrix Array Functions
In this video we show how to Multiply and Invert matrices.

Trend Function
In this video we show how to use multiple regression and the TREND array function to predict US Auto Sales.

Linest Function
In this video we show how the LINEST array function can be used to run a multiple regression which automatically updates when new data is added.

Fermat’s Little Theorem
In this video we use an array formula to determine if an integer is prime and then discuss Fermat’s Little Theorem, a beautiful result from number theory.

Trend and Seasonality
In this video we show how to estimate the trend and seasonal indices for monthly US airline miles.

Ratio to Moving Average Part One
In this video we show how the Ratio to Moving Average Method is used to forecast time series in the presence of Trend and Seasonality.

Ratio to Moving Average Part Two
In this video we conclude our discussion of the Ratio to Moving Average Method.

Winter’s Method of Forecasting Introduction
In this video we show how Winter’s exponential smoothing method can be used to forecast in the presence of Trend and seasonality.

Winter’s Method – Equations
This video is a continuation of the Winter’s Method of forecasting.

Winter’s Method – Initialization 
This video is a continuation of the Winter’s Method of forecasting.

Winter’s Method – Implementation
This video is the implementation and conclusion of the Winter’s Method of forecasting.

Credit Union Forecasting Part One
In this video we show how to incorporate seasonality and special factors in a forecast of a bank’s daily customer count.

Credit Union Forecasting Part Two
In this video we finish our discussion of forecasting daily customer count at a bank.

Predicting Software Sales
In this video we show how to use the Excel Solver to determine how seasonality, PC sales, and launch dates affect software sales.

Using The Brier Score To Evaluate Forecasters
In this video e show how the Brier score can be used to evaluate forecasters that predict binary outcomes (rain or no rain, home team wins NFL game, etc.)

Forecast Sheet
In this video we show how to use the Excel 2016 Forecast Sheet capability to forecast and develop confidence intervals for future values of a seasonal times series.

Forecast Functions
In this video we show how to use Excel 2016 Forecast Functions to forecast and develop confidence intervals for future values of a seasonal times series.

Forecasting Candy Bar Sales
In this video we show how to use the Solver to determine how our price, the competitor’s price, and whether the product is on display influences candy bar sales.

Forecasting Google Trend Data
In this video we show how to download search data from Google Trends and use the Forecast Sheet to forecast future searches.

Evaluating Forecast Bias
In this video we show how to evaluate the bias in 538.com’s forecasts and find them to be unbiased.

Forecast Sheet Statistics
In this video we discuss Excel’s FORECAST.ETS.STAT function, which gives important statistics based on the forecasts created by the Forecast Sheet Tool.

Combo and Secondary Axis Charts
In this video we create Combination charts and Charts with a Secondary Axis.

Handling Missing Data
In this video we show options for handling missing data in charts.

Handling Hidden Data 
In this video we show options for handling hidden data in charts.

Adding Pictures to Column Charts
In this video we show how to add pictures to your column charts.

Data Labels
In this video we show how to add Data Labels to a column chart.

Data Tables
In this video we show how to add a Data Table below a column chart.

Labels From Cells
In this video we show how to label points with labels based on cells in Excel. This is for users of Excel 2013 and Excel 2016.

Creating Icon Sets
In this video we show how to use the WINGDINGS3 font to create customized Icon sets.

Band Charts
In this video we show how to create a Band Chart to summarize how inventory moves between lower and upper control limits. We also show how to create and use Chart Templates.

Thermometer Charts 
In this video we show how to create Thermometer charts that summarize monthly performance against a target.

Dynamic Chart Labels
In this video we show how to create Chart Titles and Series Labels that dynamically update as we change our spreadsheet inputs.

Check Boxes and Chart Dashboards
In this video we show how to use Check Boxes to control which series show in a chart.

List Boxes and Chart Dashboards
In this video we show how to use List Boxes to control which series shows in a chart.

Spinners
In this video we show how to create a Spinner that enables you to change the values of any number of spreadsheet inputs by clicking on your Spinners.

Gantt Charts
In this video we show how to create a Gantt Chart that monitors completion times of project activities.

Dynamic Histograms
In this video we show how to create a dynamic histogram that updates automatically when new data is added.

Charts Based on Sorted Data
In this video we show how use a column chart to summarize sales in 50 states where the columns are listed in descending order of sales.

Adding Conditional Colors to a Chart
In this video we show how to color monthly sales green when we have a good month, yellow for a typical month, and red for a bad month.

Waterfall Charts
In this video we show how to create Waterfall Charts with Excel 2013.

Creating Charts With GETPIVOTDATA
In this video we use GETPIVOTDATA and the Excel Table feature to create dynamic charts based on a PivotTable.

Pareto Charts
In this video we show how to create Pareto Charts in Excel 2013.

Vertical Line
In this video we show how to place a vertical line in a chart that moves when the chart is relocated.

Radar Charts
In this video we use Radar charts to summarize employee attributes on multiple dimensions.

Bubble Charts
In this video we use a Bubble Chart to summarize sales in different countries on three dimensions.

Sparklines Part One
In this video we use Sparklines to visually summarize daily customer counts in different bank branches in a single cell for each branch.

Sparklines Part Two
In this video we use Win Loss Sparklines to visually summarize week by week NFL results.

Adding a Picture to a Column Graph
In this video we show how to replace the bars in a column graph by a picture (in this case a soda bottle).

Stacking Pictures in a Column Graph
In this video we show how to stack pictures in a column graph so that, for example 1 plane = sales of 50 units.

Creating a Chart With a Secondary X and Y Axis
In this video we show how to create a chart with both a secondary x and y axis.

Pie Charts With a Bar Chart Breakout
In this video we show that starting with a pie chart, how to break out into a bar chart items with small values.

Deleting Points From a Chart
In this video we show how to delete selected points from a chart.

Highlighting the Best and Worst Months of Sales
In this video we show how to highlight the best and worst month of sales in a line chart.

Discriminant Analysis
In this video we show how to use the Evolutionary Solver to develop a linear scoring rule that effectively classified data points into one of two groups.

Cluster Analysis
In this video we use the Evolutionary Solver to show that every US city is demographically similar to either LA, Memphis, SF, or Omaha.

Estimating Elasticities
In this video we use the GRG Multistart solver to estimate product and cross product elasticities.

Introduction to Neural Networks
In this video we describe how neural networks work and sketch the approach needed to fit a neural network to data.

Fitting a Neural Network
In this video we use the GRG Multistart Solver to use a neural network to predict the Wind Chill Index. Our simple network accurately fits the complex wind chill equation.

Histograms
In this video we show how to use Excel to create much improved histograms.

Pareto Charts
In this video we show how to use Excel to create much improved Pareto charts.

Boxplots One Variable
In this video we show how to use Excel to create a Boxplot to summarize the results of the 1970 Draft Lottery.

Boxplots More Than One Variable
In this video we show how to use Excel to create a Boxplot that summarizes multiple test scores at three high schools.

Waterfall Chart – Time Series Data
In this video we show how to use an Excel Waterfall chart to summarize the progress of sales during a year.

Waterfall Chart – Revenue to Profit
In this video we show how to use an Excel 2016 Waterfall chart to summarize how various cost centers reduce Company Revenue and Profit.

Treemap Chart – Bookstore
In this video we use an Excel TreeMap or Mosaic chart to summarize hierarchical bookstore sales data.

Sunburst Chart – Bookstore
In this video we use an Excel Sunburst chart to summarize hierarchical bookstore sales data.

Sunburst Chart – Monthly Breakdown 
In this video we use an Excel Sunburst chart to summarize quarterly and monthly sales data.

Treemap Chart -Restaurant
In this video we use the SUMIFS functions to prepare restaurant sales data and then summarize the sales data with a TreeMap chart.

Funnel Chart
In this video we show how to create a funnel chart which shows the winnowing of a pool of donors from prospects to bid donors.

The TEXTJOIN Function
In this video we show how the TEXTJOIN function can be used to make concatenation easier.

The MAXIFS and MINIFS Functions
In this video we show how to use the MAXIFS and MINFS Office 365 functions.

The IFS Function
In this video we show how the IFS Office 365 function simplifies the creation of nested IF formulas.

The SWITCH Function
In this video we show how the SWITCH function can be used as an alternative to the IFS or CHOOSE function.

The Unique Function
In this video we show how the UNIQUE function extracts all unique entries across multiple columns.

The Unique Function and Tables
In this video we show that the UNIQUE function automatically updates with new data if the original data is in a table.

The SORT and SORTBY Functions
In this video we show how to use the SORT and SORTBY functions to sort arrays based on one or more columns.

The SORT and SORTBY Functions With Range Names and Tables
In this video we show how the SORT and SORTBY functions work with ranges and tables.

The FILTER Function
In this video we use the FILTER function to filter data based on single or multiple criteria.

The SEQUENCE Function
In this video we show how the SEQUENCE function can be used to insert a sequence of numbers with a constant increment in a range of cells.

The RANDARRAY Function
In this video we use the RANDARRAY function to generate a rectangular array of random numbers and also “shuffle” a deck of cards.

The #SPILL Operator
In this video we show  how using the # (Spill) operator, you can refer to the results of a  dynamic array formula in other formulas.

Dynamic Arrays and Nested Dropdowns
In this video we use Dynamic Arrays to create nested dropdown boxes. In the first dropdown you pick a college football conference. Then the 2nd dropdown just shows the teams in that conference.

Using Dynamic Arrays to Emulate a Pivot Table
In this video we show how to use Dynamic arrays to emulate a Pivot Table. When new sources of data are added, our calculations seamlessly update.

Introduction to PowerPivot
In this video we show how to use PowerPivot to combine data sources and create a PivotTable.

Creating PivotTables From a Database
In this video we show how to use PowerPivot to import tables from an Access database and create a PivotTable based on the imported data.

DAX Functions
In this video we show how to use DAX functions to add new columns to a PowerPivot page and use the new columns in a PivotTable.

The DISTINCTCOUNT Function
In this video we use PowerPivot to create a Pivottable that compares a company’s actual sales to their forecasted sales.

Comparing Forecasted Sales to Actual Sales
In this video we use PowerPivot to create a PivotTtable that compares a company’s actual sales to their forecasted sales.

The RELATED DAX Function
In this video we show how the RELATED DAX function is used to pull data from one data source tab to another data source tab

Pivot Tables Based on PowerPivot Calculated Columns
In this video we show how to create PivotTables based on PowerPivot calculated columns.

Calculated Measures
In this video we use the CALCULATE function to creae calculated measures.

Key Performance Indicators
In this video we use a KPI to visually summarize a calculated measure.

Using Power Pivot to Draw a Random Sample
In this video we show how to use Power Pivot to take a random sample from a sales database.

Using Power Pivot to Sample From a Subset of a Database
In this video we use Power Pivot to take a random sample from only 2019 sales invoices.

Median and Date Intelligence DAX Functions
In this video we show how to use the MEDIAN DAX function to compute median sales and use the DATESMTD DAX function to compute sales to date during the current month.

Date Intelligence Functions Part II
In this video we show how date intelligence functions are used to determine sales on a given day a year ago and sales to date during the same month a year ago.

World Filled Maps
In this video we create a filled map showing sales in different countries.

US Filled Maps
In this video we create a 3D map that shows sales from different sources in different counties and cities.

Building a 3D Energy Map
In this video we create a 3D map that shows the energy capacity from different sources in each state.

3D Time Animation
In this video we create a movie that shows how sales in each state change over time.

Mapping the 2016 Election
In this video we use a Filled map to show how Trump won the 2016 election by winning the “Flyover States.”

Mapping NYC Subway Lines
In this video we show how 3D Maps can be used to show the location of NYC subway stations.

Introduction to Geography Data Types
In this video we show how Excel’s new geography data types let you create formulas that enter data about locations.

Geography Types and Excel Tables
In this video we show how Geography Data Types can be used with Excel Tables.

The FIELDVALUE Function
In this video we help you master the FIELDVALUE function which let’s you vary the property extracted for a location.

Resolving Ambiguity
In this video we show how to resolve ambiguity about the location of interest.

Stock Data Types
In this video you will learn how to use the new data types to extract data about a corporation.

Downloading Bitcoin Prices and Volumes
In this video we use Power Query to download Bitcoin price data and transform its appearance.

Downloading the Population of US Cities
In this video we use Power Query to download populations of the largest US cities and merge the city and state names in a single column.

Flattening a Table
In this video we use Power Query to flatten a table.

Turning a Flat File Into a Table
In this video we use Power Query to flatten a table.

Using a Formula to Add a Column
In this video we use an IF formula to compute a discounted price in a custom column.

Appending Queries
In this video we show how to append queries using Power Query.

Power Query Trick
In this video we show how you can combine all files in a folder and if you add new files the summary automatically updates when refreshed.

Filling Blanks in a Column
In this video we are given a list of NBA player statistics with most of the player’s teams missing. We use Power Query to fill in the missing team names and transpose the statistics from different columns to different rows.

Transforming Data Using Delimiters
In this video we split data at a comma and split the data into different rows. Then we split the data at a colon into two different columns.

Grouping Data with Power Query
In this video we show how to group sales data by region so that when new data is added, our calculations update to include calculations for new regions.

Using Power Query to Summarize Data Across Multiple Columns
In this video we show how to use Power Query to summarize sales by person and region. After refreshing, new data is automatically included in our summary.

Creating Custom Columns
In this video we create a custom column for revenue based on price and units sold and summarize revenue by year.

Pivoting Columns With Power Query
In this video our spreadsheet contains a single piece of data for a single player in each row. Each player has 5 rows of data and we show how to pivot the data so each player’s data appears in a single row and 5 columns.

Inserting the Developer Tab
In this video we show how to make the Developer Tab appear on your ribbon.

Inserting a List of Names
In this video we record a Macro that inserts a list of team members starting in cell A1. We also create a button to run the macro.

Relative References With Macros
In this video we show how to use Relative References to make sure our list of names can be entered anywhere in our workbook.

Using Macros to Format Cells
In this video we create a macro to apply a desired format to a range of selected cells and show how to run the Macro by clicking on a picture (in this case an Aircraft Carrier).

Formatting a Range of Variable Size
In this video we show how to create a macro that formats a range of variable size.

Using a Macro to Freeze Values
In this video we create a macro that coverts formulas in a selected range to numerical values.

Using Macros For Reporting
In this video we create macros that enable us to toggle in a PivotTable between a view that shows sales for all customers and sales for only our top 20 customers.

Creating a Border With a Macro
In this video we show how to create a macro that places a border around a range of selected cells.

Personal Macro
In this video we discuss how to save a macro to your Personal Macro Workbook.

Sorting Macro
In this video we show how to create a macro that will sort a list by last and first name.