0:00 Introduction
0:37 Tip 1 Columns and Rows
1:08 Tip 2 Cell Names and Ranges
1:27 Tip 3 One Item One Cell
4:26 Tip 4 Ribbon and Views
6:24 Tip 5 Excel Formulas
8:10 Tip 6 Excel Functions
11:38 Tip 7 Copy / Paste (5 ways)
12:10 Tip 9 Cell Formatting
16:00 Tip 8 Relative vs. Absolute Address
18:42 Tip 10 AutoSum
20:09 Tip 11 Format a Table
21:48 Tip 12 Column Width
22:26 Tip 13 and 14 Filter and Sort
25:08 Tip 15 Multiple Sheets / Tabs
25:30 Tip 16 VLOOKUP
26:20 Tip 17 Formula Builder
28:20 Tip 18 Data Validation
30:08 Tip 19 Named Range
31:26 Tip 20 AVERAGEIFS and COUNTIFS
34:00 Tip 21 Copy and Paste Special