The MAC Excel Formulas Guru Challenge is designed for people who know the basics on writing formulas. This challenge will introduce you to over 50 functions that can be used individually or combined to help you become more efficient and production and start RECLAIMING YOUR VALUABLE TIME.
Finish your projects FASTER and RECLAIM YOUR VALUABLE TIME!
In just 15 minutes a day for 10 days and you'll know more than most Excel users.
Here's what you'll learn:
Day 1: Introduction to using named ranges in formulas.
Day 2: Advanced named range tips & tricks.
Day 3: Logical functions: If, And, Or, IfError, IsBlank, IsErr, IsError.
Day 4: Math functions: Rounding functions, Ceiling, Floor, Count functions, SumIf, and AverageIf.
Day 5: Date functions: analyze dates using Date, DateValue, NetWorkDays, WeekDay, WeekNum, and more.
Day 6: Lookup functions: VLookUp (vertical lookup) and HLookup (horizontal lookup).
Day 7: Text functions: Modify text and values using Left, Right, Mid, Trim, Concatenate, and more.
Day 8: Financial functions: Pmt (payment), PV (present value), and FV (future value).
Day 9: Advanced math functions: SumIfs, AverageIfs, and CountIfs.
Day 10: Time functions: Time, TimeValue, Hour, Minute, Second, Mod, and more.
Watch the Sample Lesson Below
Challenge Details