Office Training

Cybrary – Intermediate Excel

Intermediate Excel | Cybrary
English | Size: 2.17 GB
Category: Tutorial


This course provides intermediary knowledge of Excel and teaches advanced calculations in Excel, creating macros, and data analysis on various data sets.

Skillshare – Intermediate Excel for the Real World Cleaning Data for Analysis and Forecasting

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.