Certified Industrial Excel Professional

  • Duration of the course: 6 Months
    Fees: INR 25000 / $ 500 / AED 1500

Nothing beats getting something for nothing When it comes to learning Microsoft Excel, the same holds true. In today’s fast-paced, technical business environment, numbers are everything, Much of our success hinges on how well we can manage the data- statistics, planning, reporting – that we encounter on a daily basis.

WHY CERTIFIED INDUSTRIAL EXCEL PROFESSIONAL?

Formulas make Excel smart. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion and they also know few alternatives for any given formula problem.

COURSE OUTLINE

  • Customizing the Excel User Interface
  • Creating Formulas for Financial Applications
  • Introducing Array Formulas
  • Performing Magic with Array Formulas
  • Linking and Consolidating Worksheets
  • Making Your Worksheets Error-Free
  • Getting Data from External Database files

  • Analyzing Data with Pivot Tables
  • Learning Advanced Charting
  • Performing Spreadsheet what -if analysis
  • Analyzing Data Using Goal Seeking & Solver
  • Introducing Visual Basic For Applications
  • Visualizing Data Using Conditional Formatting
  • Using Auditing tool with excel

For registration contact nearest branch of IIAP. Contact Us