MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Excel Mastery Course Part 1 of 5: Calculate

### Course Summary

Everything You Need to Know About Formulas & Functions

• +

### Course Syllabus

• Course Introduction
• Promo Video
• What Makes This Course Different?
• Course Goals
• How Is The Course Organized?
• What You Should Expect From Me
• What I'm Expecting From You
• Fundamental Concepts
• Syntax Ground Rules
• Order of Operations (PEMDAS)
• Arithmetic & Comparison Operators
• Absolute Vs. Relative Cell References
• Functions Vs. Formulas
• Paste Vs. Paste Special
• Discover New Functions
• QUIZ - Fundamental Concepts
• Commonly Used Functions and Date & Time Functions
• Previous Section Recap: Fundamental Concepts
• SUM and AVERAGE Functions
• COUNT Functions
• TODAY and NOW Functions
• TODAY and NOW Value Shortcuts
• YEAR, MONTH, DAY, HOUR, MINUTE, SECOND Functions
• DATE Function
• WEEKDAY Function
• WORKDAY and WORKDAY.INTL Functions
• How to Become My BFF (Hint: Leave a Review)
• QUIZ - Commonly Used Functions and Date & Time Functions
• CALCULATE EXERCISES - ROUND ONE
• Previous Section Recap: Commonly Used Functions and Date & Time Functions
• Round One - Instructions & Tips
• Round One - Question #1 Answered
• Round One - Question #2 Answered
• Round One - Question #3 Answered
• Round One - Question #4 Answered
• Round One - Question #5 Answered
• Round One - Question #6 Answered
• Round One - Question #7 Answered
• Round One - Question #8 Answered
• Text Functions
• TRIM Function
• CLEAN Function
• SUBSTITUTE Function
• REPLACE Function
• FIND Function
• LEFT and RIGHT Functions
• MID Function
• CONCATENATE Function
• TEXT Function
• QUIZ - Text Functions
• Other Useful Functions
• Previous Section Recap: TEXT Functions
• VLOOKUP Function
• ROUND, ROUNDUP, and ROUNDDOWN Functions
• RAND and RANDBETWEEN Functions
• ISNUMBER, ISTEXT, ISBLANK, ISEVEN, and ISODD Functions
• VALUE Function
• QUIZ - Other Useful Functions
• Logical Functions
• Previous Section Recap: Other Useful Functions
• IF Function
• AND Function
• OR Function
• AND and OR Functions Combined
• NOT Function
• IF, AND, and OR Functions Combined
• How to Become the Cool Kid on the Block (Hint: Leave a Review)
• QUIZ - Logical Functions
• CALCULATE EXERCISES - ROUND TWO
• Previous Section Recap: Logical Functions
• Round Two - Instructions & Tips
• Round Two - Question #1 Answered
• Round Two - Question #2 Answered
• Round Two - Question #3 Answered
• Round Two - Question #4 Answered
• Round Two - Question #5 Answered
• Round Two - Question #6 Answered
• Round Two - Question #7 Answered
• Round Two - Question #8 Answered
• Round Two - Question #9 Answered
• Bonus Topics
• Text to Columns
• Formula Audit Mode
• Goal Seek
• VLOOKUP Approximate Match
• Nested IF Substitution Method - Step 1
• Nested IF Substitution Method - Step 2
• Nested IF Substitution Method - Step 3
• Nested IF Substitution Method - Step 4
• Nested IF Substitution Method - Step 5
• QUIZ - Bonus Topics
• CALCULATE EXERCISES - EXTRA PRACTICE
• Previous Section Recap: Bonus Topics
• Extra Practice - Question #1 Answered
• Extra Practice - Question #2 Answered
• Extra Practice - Question #3 Answered
• Extra Practice - Question #4 Answered
• Extra Practice - Question #5 Answered
• Course Conclusion
• Previous Section Recap: All-In-One
• How to Use This Conclusion
• Prepare the Data
• Break Down the Dates
• Clean the Data
• Standardize the Data
• Massage the Data - Net Calculations
• Massage the Data - Smart Sort Order
• Massage the Data - Abbr. with a Lookup Table
• Massage the Data - Abbr. with Text Functions
• Massage the Data - Contains Text
• Logical Calcs - IF Function
• Logical Calcs - IF and AND Functions
• Logical Calcs - IF, AND, and OR Functions
• Bonus - Grouping with VLOOKUP Approximate Match
• Conclusion Wrap Up
• Fun & Games
• Original Promo Video

Course Fee:
USD 199

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts: