Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
Accelerate your productivity. Taught by Microsoft Certified Trainers
This is a 5-hour course designed for Excel users, willing to explore the extensive usage of Microsoft Advanced Excel Formulas in a very short span of time, to speed you through the spreadsheet work.
The course equips you with 60+ essential, productive time-saving functions and formula building techniques through suitable examples, required to solve a variety of data analysis problems.
Besides knowing the formulas and the usage of them in a particular scenario, we would learn how to debug a formula, audit them, and know the alternatives to the complex functions.
Course Fee $199
1. Sum
2. Sumif
3. Sumifs
4. Average
5. Averageif
6. Averageifs
7. Max
8. Min
9. Sumproduct
10. Count
11. CountA
12. Countblank
13. Subtotal
1. Vlookup
2. Dynamic Vlookup
3. Hlookup
4. Dynamic Hlookups
5. Match
6. Index
7. Indirect
8. Offset
1. And
2. Or
3. Not
4. If
1. Istext
2. Code
3. Char
4. Exact
5. Len
6. Trim
7. Upper
8. Lower
9. Proper
10. Left
11. Right
12. Mid
13. Substitue
14. Replace
15. Find
16. Search
1. Date
2. Datevalue
3. Day
4. Days360
5. EDate
6. Emonth
7. Month
8. Today
9. Weekday
10. Year
11. Now
12. Hour
13. Minute
14. Second
15. Time
16. Timevalue
1. Ceiling
2. Even
3. Floor
4. INT
5. Mround
6. Odd
7. Round
8. Roundup
9. Rounddown
10. Trunc
1. Isna
2. Iserr
3. Iserror
