IMRI® Certificate Program in Advanced MS Excel (iCPAE) Training Program

Learn IMRI®’ scientific approach to Advanced Microsoft Excel including working with scenarios, macros, lookup functions, pivot tables, charts, and auditing formulas.; plus get certified in Advanced Microsoft Excel for better career and business prospects!

Quick View

Ideal for: Graduates – any stream
Duration: 1 Month (Weekly 2 days)
Schedule: One-on-One, Flexible Mode

Learn the Art & Science of Advanced Microsoft Excel

MS Excel is both an art and science in creating custom dashboards for web analytics, traffic sources, key performance indicators, charts and graphs.. Greater the website visibility, higher the brand credibility. Now with proven, time-tested and hands-on MS Excel Training from IMRI experts, you can enhance your core skill sets and competencies.

[fusion_tabs layout="horizontal" justified="" backgroundcolor="" inactivecolor=""]
[fusion_tab title="COURSE OUTLINE"]
[tagline_box backgroundcolor="#f6f6f6" shadow="yes" border="0px" bordercolor="" highlightposition="" link="" linktarget="" button="" title="Experience Microsoft Excel Learning, by Doing" description="IMRI® Experiential Learning on Advanced Microsoft Excel course teaches the complexities of Advanced Microsoft Excel in an interactive and practical approach with hands-on job experience."][/tagline_box]

[separator top="-50"]

Advanced MS Excel Training: Getting started with Excel

  • Basic formula and cell name review
  • Conditional Formatting and Data Validation
  • Worksheet Functions: VLookup, Match, SumProduct, CountIF, SumIf, Index, If
  • Text Functions: Right, Mid, Left, Substitute and Replace
  • Nesting Worksheet Functions
  • Concatenation
  • Databases & Lists
  • Sort / AutoFilter / Advanced Filter Tools

Advanced MS Excel Training: Fundamentals

  • Text Wizard and Text to Columns
  • Using Ranges functions
  • Array Formulas for dashboards and summaries
  • Dynamic ranges
  • Drawing / Pictures and Business Flow Charts
  • Business Report Generation
  • Forms and Questionnaires
  • Pivot Tables
  • Link Excel to Word and PowerPoint

Advanced MS Excel: Indepth

  • Time Formulas
  • Workbook Templates / Worksheet Templates
  • Business Forms
  • Dashboards and Advanced Formulas
  • Linking Workbooks
  • Sharing Workbooks
  • OLE Automation
  • Importing Text Files
  • Microsoft Query
  • Microsoft Access
  • Microsoft Excel Security
  • Macro Recorder