Uploaded March 2015 | Updated September 2026, 55 minutes ago

---

Get my Excel file's here: http:--1drv.ms-1bYwrTa

Data Analysts need to be efficient when navigating Excel and creating solutions.

00:04 Tip 1: Efficient ways to drag formulas down.
02:10 Tip 2: Quickly normalize a data set.
03:34 Tip 3: 'Fill in the blank' trick to simplify formula.
05:21 Tip 4: Get all combinations of two fields.
06:39 Tip 5: Repeat sets of numbers.

twitter.com/kevinlehrbass
myspreadsheetlab.com