Search
Chat

EXCEL FORMULAS

Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.

Excelgoodies Excel 2007 Formula course is explicitly designed for candidate’s willing to explore the extensive usage of microsoft adavnced excel formulas in a very short span of time to reduce the work load at job.

This course will equip you with 60+ essential formulas required to perform the job efficiently and effectively.

The training is clubbed with suitable examples from various domains in order to have the better understanding of formula’s real time applications.

PRE-REUQUISITE

It would be suitable for the candidate’s with basic knowledge in Excel.

COURSE DURATION:5 hrs

COURSE CONTENT

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
  • 5. Nested IF(s)
TEXT FUCTIONS
  • 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
Pricing    
Online Instructor Led Training on Excel - How it works ?

You can listen to our instructor, interact with him on a one-to-one basis, access his computer screen from your desktop, make changes on his excel sheet, and get your doubts clarified instantly.

 

  COURSE FEE  US$ 99
Group Training

Encouraging the live interactions with the trainer as well as the understanding of Excel applications in various domains, Group Training on Advance Excel is scheduled on Weekends (Saturday & Sunday) at our premises.

Batch Size:12

Please call +91 91766 33246 / 91766 33247 for further details.

Individual Training

If you need self spaced training, Excelgoodies provides you with an option of Inividual Training which can be scheduled on any of the weekdays (Monday - Friday) at our premises.

Please Call +91766 33246 for further details.

For Corporate

We offer private hands-on training courses that can be held at your company's site. Our Onsite Corporate Training Packages go beyond the standard excel training and can be tailored according to the needs of the organisation and knowledge level of the employees.

Minimum Batch Size : 10

Click Here to request for quote

For Colleges and Universities

Our Services are now available on demand at Colleges and Universities

Minimum Batch Size : 25

Click Here to request for quote
  • Windows OS
  • Internet Speed of 512 kbps or higher
  • Internet Explorer
  • Headsets With Mic
  • JavaScript Enabled
Other Excel Courses
Excel Certifications Provided
Online Excel Help
Online Help
Testimonials
Testimonials
FAQs
View More