Back to Course
Advanced Excel and Analytics Course
0% Complete
0/0 Steps
-
OVERVIEW
Sample Lessons -
COURSE CONTENTRange Names2 Topics
-
Text Functions4 Topics
-
Auditing Tools, Circular References, and IF Functions5 Topics
-
Data Tables, Goal Seek, and Scenario Manager6 Topics
-
Conditional Counts and Sums11 Topics
-
Conditional Formatting and Data Validation7 Topics
-
Tables10 Topics
-
Pivot Tables14 Topics
-
Value Field Settings and Show Values As
-
Calculated Fields
-
Slicers and Filters
-
GETPIVOTDATA Function
-
Calculated Items
-
Timelines
-
Analyzing Surveys and More Pivot Charts
-
Creating Pivot Tables From Multiple Ranges
-
Multiple Pivot Tables
-
Data Model
-
Pivot Tables and the NBA Part One
-
Pivot Tables and the NBA Part Two
-
Birth Rate
-
Putting it all Together
-
Value Field Settings and Show Values As
-
Descriptive Statistics7 Topics
-
Trend Curve, Correlation, and Regression to the Mean12 Topics
-
Multiple Regression12 Topics
-
Multiple Regression Part One
-
Multiple Regression Part Two
-
Dummy Variables
-
Introduction to Conjoint Analysis
-
Conjoint Analysis and Regression
-
Value Based Pricing
-
Nonlinearities and Interactions
-
What Makes NBA Teams Win
-
Quarterback Rating
-
Maximum Likelihood Estimation
-
Logistic Regression
-
The Windchill Index
-
Multiple Regression Part One
-
Probability7 Topics
-
Random Variables7 Topics
-
Array Formulas17 Topics
-
Introduction to Array Formulas and Functions
-
Simple Examples of Array Formulas
-
Array Formulas and Text Functions
-
Finding Smallest Numbers in a Range
-
Emulating SUMIF or DSUM
-
Emulating SUMIFS
-
Emulating the OR Operator With Arrays
-
Creating the MEDIANIF Function
-
Creating the STDEVIF Function
-
Conditional Products
-
Finding Unique Entries in an Array
-
Transpose Function
-
Frequency Function
-
Matrix Array Functions
-
Trend Function
-
Linest Function
-
Fermat
-
Introduction to Array Formulas and Functions
-
Offset and Indirect Functions13 Topics
-
Optimization and the Excel Solver25 Topics
-
Introduction to Solver Part One
-
Introduction to Solver Part Two
-
Introduction to Solver Part Three
-
Transportation
-
Scheduling
-
Capital Budgeting
-
Fantasy Sports Part One
-
Fantasy Sports Part Two
-
Financial Solver
-
NFL Point Spreads
-
NFL Totals
-
Pricing Model
-
Warehouse Location
-
Finding Distances
-
Demand Sensitivity to Price Change
-
Saving For 1 Year Salary
-
Sampling Plan For Attributes
-
The Assignment Problem
-
The Transshipment Problem
-
Inventory Model
-
The Shortest Route Problem
-
Hypothesis Testing For a Population Mean
-
Asset Allocation
-
Network Flow Models
-
Cheapest Diet
-
Introduction to Solver Part One
-
Forecasting11 Topics
-
Trend and Seasonality
-
Ratio to Moving Average Part One
-
Ratio to Moving Average Part Two
-
Winters Method of Forecasting Introduction
-
Winters Method - Equations
-
Winters Method - Initialization
-
Winters Method - Implementation
-
Credit Union Forecasting Part One
-
Credit Union Forecasting Part Two
-
Predicting Software Sales
-
Forecasting Candy Bar Sales
-
Trend and Seasonality
-
Charting6 Topics
-
Power View5 Topics
-
Monte Carlo Simulation14 Topics
-
Introduction to Monte Carlo Simulation
-
The RAND and RANDBETWEEN Functions
-
Simulating a Discrete Random Variable
-
Simulating a Normal Random Variable
-
Simulating a Baseball Inning
-
The Birthday Problem
-
Craps
-
The Newsperson Problem
-
Bidding
-
Poker Simulation
-
Simulating the NBA Finals
-
Gambler
-
Stock Problem
-
Winning Streak
-
Introduction to Monte Carlo Simulation
-
Advanced Solver17 Topics
-
Simplex LP Solver Model
-
GRG Solver Model
-
Evolutionary Solver Model
-
Locating One Warehouse
-
Locating Two Warehouses
-
Assigning Workers to Jobs Part One
-
Assigning Workers to Jobs Part Two
-
Scheduling John Deere
-
Traveling Salesperson
-
Estimating Elasticities
-
Advanced Learning Curve Models
-
Bin Packing Problem
-
Final Exam Scheduling
-
Discriminant Analysis
-
Cluster Analysis
-
Resolving Process Bottlenecks
-
The Toyota Manufacturing Sequence Algorithm
-
Simplex LP Solver Model
-
Advanced Charts10 Topics
-
Macros10 Topics
-
Supply Chain14 Topics
-
Inventory on Time
-
Inventory Modeling With Shortages
-
Aggregate Planning
-
Economic Order Quantity
-
Power of Two
-
Multiple Product Economic Order Quantity
-
Quantity Discounts
-
Cycle Service Level
-
Fillrate, Reorder Point, and Safety Stock
-
Finding Distances Between 100 Cities
-
Locating Four Warehouses
-
Jobshop Scheduling
-
Queuing
-
Inventory Turns
-
Inventory on Time
Participants 19
Here are the free topics. One from each lesson.