Office Training

Skillshare – Intermediate Excel for the Real World Cleaning Data for Analysis and Forecasting-ViGOROUS
English | Size: 752.62 MB
Category: Tutorial

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.