Lifetime access
Pay once for lifetime access to the course and our dedicated blog for members
Real world data
We hate boring theories and dummy data. That’s why we use 100+ real life cases to explain each concept.
Content update
Continuous update based on student feedback and new versions of software released
Quizzes
Questions that drive deep learning of concepts to ace technical interviews
Instructor assistance
Post questions on discussion forum to get answers from instructor within 24 hours
Certificate of completion
Showcase achievement through digitally verified certificate on your social media profile
Community learning
Discover the joy of learning with other students while helping each other
Become a Pro
We cover topics from basic to advanced level to get you to the top 5 percentile of your peers
Moneyback guarantee
Don’t like our course? Get full refund upon request within 30 days of purchase.
Course Curriculum
- Download practice workbook
- Math: SumProduct, Count, CountA, Round, RoundUp, RoundDown (2:19)
- Logical: If, And, Or, IsBlank, IfError (2:37)
- Math + Logical: SumIf, SumIfs, AverageIf, AverageIfs, CountIf, CountIfs (3:12)
- Text: Left, Right, Mid, Concatenate, Trim (1:28)
- Date: Today, Date, Day, Month, Year (1:08)
- Time: Now, Time, Hour, Minute, Second (1:04)
- Lookup: Match, Index , Vlookup, Hlookup, Vlookup/Hlookup with Match (3:25)
- Download practice workbook
- Math: SubTotal (1:31)
- Math/Logical: Rows, Columns, Choose, Rank (3:26)
- Reference: Offset, Row, Column, Address, Indirect (5:38)
- Text: Find, Search, Substitute, Replace (3:14)
- Date: Edate, Eomonth, DateDif (3:07)
- Array functions/formulas: Transpose, Others (4:08)
- Formula auditing (4:03)
- Calculation modes (2:13)
- Links to external workbooks (2:10)