تفاصيل الدورة

Mastering MS Excel is rarely this easy and fast. We have come up with this course which will help you learn the more advanced functions and complex formulas used MS Excel skills by investing just over a couple of hours

Build a strong foundation in Excel and spreadsheet processing using complex functions and formulas and perform the most complex calculations, quickly and effortlessly! 

What will be covered in the course?

Functions is what makes Excel smart. In this course you will learn all about using functions. For those of you who haven't used functions before, you will learn the basic fundamentals about them as well. 

At the end of this course you would have learnt about:

  1. Basic Functions
  2. Nested Functions
  3. Displaying and Analysing Functions
  4. Logical Functions
  5. Mathematical Functions
  6. Financial Functions
  7. Lookup and Reference Functions,
  8. Arrays, and
  9. Dynamic Formulas

Content and Overview (Now this is the important part)

Based on our vast training experience and a lot of research on MS Excel usage trends across industries, we have identified Excel functions that provide maximum utility with the least effort. We have focused on key functions from each category. Familiarity with these gets you set for effortless use of other similar ones. 


The simple training style will enable you to master seemingly hard-to-grasp concepts in a very short while. This course will cover functions under broad categories. 


You must have often spent hours trying to identify missing data fields or non-standard data. A special section has been devoted to "Information Finding Functions". So you will learn to do previously cumbersome tasks in just a few seconds!


Another problem area is the annoying errors that pop up in spreadsheets. If a single cell involved in a calculation has an error, the dependent formula goes completely topsy-turvy. Not anymore! With knowledge of error checking functions, you can ensure that errors are nipped in the bud and all calculations go through smoothly.


So this course is also going to help you resolve problems in a jiffy! In most cases, since the root cause of the errors is eliminated, the problems won't occur at all.

What are the requirements?

No specific eligibility requirements. This course is for anyone and everyone who is looking to learn the more advanced formulas and functions in Excel to increase their productivity. Very basic knowledge of Excel is required to enroll for this course. 

When you learn this course, we strongly recommend that you create those projects simultaneously for an effective learning experience. 

Who will benefit the most from this course?

The ideal student for this course is anyone and everyone who wants to learn the advanced functions and formulas in Excel to increase their productivity.

This course will be particularly helpful for 

  1. Individuals in supervisory roles, 
  2. Sales and Marketing professionals, 
  3. Human Resources and Payroll Professionals,
  4. Supply Chain Management analysts,
  5. Financial Analysts,
  6. Bankers,
  7. Students looking for a career in the fields of Data Analysis and Processing, and
  8. Data Analysts
  9. Students learning Excel, 
  10. High School and College students, 
تحديث بتاريخ 22 March, 2018
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن. See all courses

قيِم هذه الصفحة