Promo Video | ExcelShir

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel Mastery Course: Calculate

Course Introduction

Promo Video (3:35)
What Makes This Course Different? (4:20)
Course Goals (4:54)
How Is The Course Organized? (6:53)
What You Should Expect From Me (2:33)
What I'm Expecting From You (2:56)
Welcome & DOWNLOADABLE COURSE RESOURCES

Fundamental Concepts

Syntax Ground Rules (3:07)
Order of Operations (PEMDAS) (0:47)
Arithmetic & Comparison Operators (1:10)
Absolute Vs. Relative Cell References (2:17)
Functions Vs. Formulas (1:18)
Paste Vs. Paste Special (3:51)
Discover New Functions (3:34)

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

TRIM Function (1:31)
CLEAN Function (1:46)
SUBSTITUTE Function (2:19)
REPLACE Function (3:42)
FIND Function (3:50)
LEFT and RIGHT Functions (1:05)
MID Function (1:35)
CONCATENATE Function (2:13)
TEXT Function (4:25)

Other Useful Functions

VLOOKUP Function (5:59)
ROUND, ROUNDUP, and ROUNDDOWN Functions (2:05)
RAND and RANDBETWEEN Functions (2:51)
ISNUMBER, ISTEXT, ISBLANK, ISEVEN, and ISODD Functions (2:09)
VALUE Function (1:43)

Logical Functions

IF Function (2:59)
AND Function (2:06)
OR Function (1:32)
AND and OR Functions Combined (2:46)
NOT Function (1:35)
IF, AND, and OR Functions Combined (4:37)
How to Become the Cool Kid on the Block (Hint: Leave a Review)

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

Extra Practice - Question #1 Answered (3:27)
Extra Practice - Question #2 Answered (1:13)
Extra Practice - Question #3 Answered (3:34)
Extra Practice - Question #4 Answered (2:51)
Extra Practice - Question #5 Answered (6:07)

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

Original Promo Video (3:45)

Teach online with

Promo Video

Music: Dor Gilad
Design: Nick Moscovitz
Animation: Darrell Allen

Complete and Continue