As an instructor I’ve had the opportunity to teach courses on analytics. Two areas I’ve worked in are Data Mining using SAS Enterprise Miner and Data Analysis using Excel. The first set of videos below will be Data Analysis using Excel. The source files for the Excel instructional material can be found in this book by Wayne Winston:
Analytics Using Excel
Data Navigation in Excel (Intro topic)
Advanced Count Functions in Excel for Analytics
Advanced Sum and Average Functions in Excel For Analytics
The Named Range Feature in Excel
Sorting Data in Excel
Conditional Formatting of Data in Excel Part 1
Conditional Formatting of Data in Excel Part 2
Tables in Excel
Lookups, VLookups and HLookups in Excel
Importing Text into Excel
Histograms in Excel
Descriptive Statistics in Excel
Pivot Tables in Excel Tutorial
The Excel Data Model
Power Pivot in Excel Tutorial
Overview of Power BI
Power BI Use Example
Text Functions in Excel Part 1
Text Functions in Excel Part 2
Straight Lines and Regression in Excel
Correlations and Correlation Matrices in Excel
Multiple Regression in Excel
Qualitative and Lagged Variables in Regression using Excel
One Way (One Factor) ANOVA in Excel
Two Way (Two Factor) ANOVA in Excel
SAS Enterprise Miner Topics
Decision Trees in SAS Enterprise Miner
Creating Default Models in SAS Enterprise Miner (quick)
Regressions with SAS Enterprise Miner
Optimizing Regression in SAS Enterprise Miner
Neural Networks and Assessing Models in SAS Enterprise Miner
Cluster Analysis in SAS Enterprise Miner