### Quick 60+ Essential Excel Formulae Training

Accelerate your productivity. Taught by Microsoft Certified Trainers

• (2656)

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 Duration:
• 4 Hours (2 Sessions, each of 2 hours)
• Mode of Training:
• Virtual Classroom (Instructor-Led)
• Pre-requisite:
• Basic Excel knowledge

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

### Lookup Functions

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

### Error Handling Functions

1. Isna

2. Iserr

3. Iserror

#### What you will be able to do post-training?

1. Have high comfort working with Excel leading to quick turnaround time
2. Use right formulas for the given scenario
3. Write Complex Formulae with ease
4. Present data with better interpretation

#### What's included in your training?

1. Pre-Course Assessment
2. 60+ Essential Formulae
3. Hands-On Instructor Led Training
4. 30+ Assignments and Real time excercises