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
Pingback: Excel: Intro to Charts – Analytics4All
Hello friend
This post is so helpful,and summer is comming, all of us like oakley sunglasses,why we choose it? i think it is cool!thanks a lot!