Excel is often overlooked in discussions on Analytics. However, due to the fact that most people already have it loaded on their computer, combined with the wide array of add-ons available, Excel a versatile tool everyone should take the time to learn.

• Extracting Date from a Date Time Stamp
• Linear Regression – Single Variable
• The Numbers Won’t Add Up
• Excel: Convert Numbers from Text
• Transpose Data with Excel
• Excel: Tables

Introduction

• Excel: An Introduction
• Excel: Copy, Cut, Paste, and Format Painter
• Excel: Sorting and Filtering
• Excel: Learning to Use Formulas
• Excel: Range Names
• Excel: Adjusting Named Ranges
• Excel: Randomly Select Names from a List
• Excel: Create a Grade Book

Conditional Formulas

• =If() Statements
• =SUMIF() and =COUNTIF()

Data Cleaning

•  Merging Data using Vlookup ()
• Excel: Data Cleaning
• Excel: Data Transformations
• Excel: Split name column into First and Last at comma

Pivot Tables

• Excel: Intro to Pivot Tables

Power Query

• Power Query: Merge Data Sets
• Power Query: Pull data from a website into Excel

Visualizations

• Excel: Intro to Charts
• Excel: Scatter Plots
• Excel: Charts, Customizing Which Columns You Want to Chart