Advertisements
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
Data Cleaning
- Merging Data using Vlookup ()
- Excel: Data Cleaning
- Excel: Data Transformations
- Excel: Split name column into First and Last at comma