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
      • About The Instructor
      • How Is The Course Organized?
      • What You Should Expect From Me
      • What I'm Expecting From You
      • Welcome & DOWNLOADABLE COURSE RESOURCES
    • 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 - DOWNLOADABLE SPREADSHEETS
      • 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

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top