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

“I got a great training from Rajesh Sir who is an expert in digital marketing field. I used to be at the institute almost 8 hrs every day
working hard and today, I am managing several projects independently. Thank You.”
Sivaranjan, Senior SEO Analyst
“Fabulous! Learnt so much, hands-on concepts on latest SEO techniques. Amazing value for money
thank you so much. I am keen to do more online media courses.”
S. Srinivas, Certified SEO Expert
“IMRI is the place were one can learn in depth digital marketing. Mr GRR is a leading trainer in India, gives hands on training in SEO, SMO & SEM. If anyone is looking for digital marketing course, i recommend IMRI for better exposure.”
Sauvagya Patnaik, Social media expert
“Lots of practical things I can take away on SEO techniques and use them immediately on my job.”
Prem Sushanth, SEO Analyst
“The IMRI Digital Marketing certification served as a reinforcement for what I’m doing, so I am now more confident in achieving the top 10 search engine rankings in less than 3 months.”
Vijayakumar R, Digital Marketing Expert
“Personal, one-on-one training with Expert….This course has given me real direction in what I should be doing as a PPC expert. The trainer was very friendly! “
Saranya, Adwords Professional

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 Microsoft 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


Program Cost: Rs.18,500/- plus taxes

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

Note:

  • Full course fee to 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.

  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.

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


Experience Advanced MS Excel Learning, by Doing

Personal Advanced MS Excel Training
Are you tired of not getting enough opportunities, respect, and money out of your Advanced MS Excel career? Well, guess what? Nothing will change unless you take action towards becoming a world-class Advanced MS Excel professional. Learn how to earn your IMRI® Advanced MS Excel Certification with hands-on job experience.
Experience -> Share -> Process -> Generalize -> Apply