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 Fee

$199
  • Course Duration:
  • 4 Hours (2 Sessions, each of 2 hours)
  • Mode of Training:
  • Virtual Classroom (Instructor-Led)
  • Pre-requisite:
  • Basic Excel knowledge

What will you 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

60+ Essential Functions Overview

Mathematical Functions

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

Logical Functions

1. And

2. Or

3. Not

4. If

Text Functions

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

Date & Time Functions

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

Rounding Numbers

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

Course Fee

For One-to-One
personalized training
$199
For Group of 3
Participants

$129 (per participant)

Contact Us

  • Mr. Perrie Smith, Business Associate
  • (650) 491-3131, (315) 633-4414
  • inquiry_excel@excelgoodies.com

Connect us on

@

Other Excel Courses offered

Powerpivot - Data Analytics

View Details

Advanced Excel Training

View Details

Financial Modeling with Excel

View Details

MIS Reporting with Excel

View Details