Advanced MS Excel

IMRI: Certified Advanced MS Excel (iCAE) Training Program

Learn IMRI's 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!

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.

Experience MS Excel Learning, by Doing

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.

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

The Learning Approach

  • Mentor-Student Ratio: 1:1
  • Methodology : 90% Hands-on and 10% Theory
  • Mode of Assessment: Results from live project, research report and online examination
  • Certification: IMRI Certified Excel Specialist

Course Schedule

  • Course Duration: 1 month / Twice a week
  • Session Hours: 1 hour per session
  • Total Sessions: 8 sessions

Cost: Rs.18,500/- plus service tax

Note:

  • Full course fee should be paid in advance
  • Discounts are available for bulk registration of more than 3 participants
  • Fees once paid are non-refundable and non-transferable

To apply to the Internet & Mobile Research Institute, in addition to the completed online enquiry form, applicants are required to provide latest bio-data, work credentials (if any), filled-in application form and a full course fee payment receipt through postal mail. Overseas applicants can provide through email with scanned documents. Below are the steps to follow:

  1. Email your resume to info@imri.in with the subject: Interested in IMRI® Experiential program
  2. Download & fill application form
  3. Make payment through cheque, bank transfer or paypal
  4. We will confirm on the course start date

Application Status

We will notify you by email or postal mail regarding your acceptance into the program and online appointment will be fixed to discuss on the course start date, expectations and methodology.

Have a Question?

Please review the frequently asked questions about the IMRI® Experiential Program, or contact the Admissions Office at info@imri.in or 91-9742645476.

 

Please note, information and requirements are subject to change without notice.