Intermediate Excel for the Real World: Cleaning Data for Analysis and Forecasting

Platform Skillshare

Go to Skillshare

Follow along with me as I show you some of the most common techniques and tips I use for cleaning up a data set in Excel before doing analysis and forecasting. In order to clean up and summarize data I’ll show you some intermediate formulas like IFERROR COUNTIF and nesting formulas together. You’ll also learn some forecasting techniques using basic regression in Excel. Most of the skills in this class apply to Google Sheets as well.