Course Introduction
Fundamental Concepts
Commonly Used Functions and Date & Time Functions
-
SUM and AVERAGE Functions (1:36)
-
COUNT Functions (3:26)
-
TODAY and NOW Functions (1:41)
-
TODAY and NOW Value Shortcuts (0:36)
-
YEAR, MONTH, DAY, HOUR, MINUTE, SECOND Functions (1:52)
-
DATE Function (1:08)
-
WEEKDAY Function (1:10)
-
WORKDAY and WORKDAY.INTL Functions (1:57)
-
How to Become My BFF (Hint: Leave a Review)
CALCULATE EXERCISES - ROUND ONE
-
Round One - DOWNLOADABLE SPREADSHEETS
-
Round One - Instructions & Tips (1:49)
-
Round One - Question #1 Answered (5:18)
-
Round One - Question #2 Answered (4:26)
-
Round One - Question #3 Answered (3:23)
-
Round One - Question #4 Answered (3:41)
-
Round One - Question #5 Answered (4:21)
-
Round One - Question #6 Answered (5:25)
-
Round One - Question #7 Answered (2:15)
-
Round One - Question #8 Answered (1:26)
Text Functions
Other Useful Functions
Logical Functions
CALCULATE EXERCISES - ROUND TWO
-
Round Two - Instructions & Tips (1:15)
-
Round Two - Question #1 Answered (9:16)
-
Round Two - Question #2 Answered (2:09)
-
Round Two - Question #3 Answered (3:19)
-
Round Two - Question #4 Answered (3:38)
-
Round Two - Question #5 Answered (4:20)
-
Round Two - Question #6 Answered (1:30)
-
Round Two - Question #7 Answered (2:59)
-
Round Two - Question #8 Answered (2:06)
-
Round Two - Question #9 Answered (3:04)
Bonus Topics
-
Text to Columns (3:19)
-
Formula Audit Mode (1:28)
-
Goal Seek (3:04)
-
VLOOKUP Approximate Match (5:37)
-
Nested IF Substitution Method - Step 1 (5:25)
-
Nested IF Substitution Method - Step 2 (7:02)
-
Nested IF Substitution Method - Step 3 (4:32)
-
Nested IF Substitution Method - Step 4 (6:11)
-
Nested IF Substitution Method - Step 5 (4:55)
CALCULATE EXERCISES - EXTRA PRACTICE
Course Conclusion
-
How to Use This Conclusion (3:25)
-
Prepare the Data (5:25)
-
Break Down the Dates (5:39)
-
Clean the Data (5:58)
-
Standardize the Data (2:30)
-
Massage the Data - Net Calculations (3:46)
-
Massage the Data - Smart Sort Order (3:00)
-
Massage the Data - Abbr. with a Lookup Table (3:45)
-
Massage the Data - Abbr. with Text Functions (5:29)
-
Massage the Data - Contains Text (7:40)
-
Logical Calcs - IF Function (3:26)
-
Logical Calcs - IF and AND Functions (6:06)
-
Logical Calcs - IF, AND, and OR Functions (7:55)
-
Bonus - Grouping with VLOOKUP Approximate Match (5:09)
-
Conclusion Wrap Up (6:08)
Fun & Games
