Looking for an excel course along with your master degree? This course has something for everyone, from beginner to advanced in Excel.

Supports Excels:

  1. Windows 2010, 2013, 2016, and 2019
  2. Office 365
  3. Excel is also available for Mac

In  Advance Excel programme, students will learn basic techniques including maths, statistical, logic, and text functions, sorting and filtering of data, formats etc. Students will also learn intermediate and advanced techniques such as VLOOKUP, pivot tables, and recording of basic macros and more.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

CAREER OPPORTUNITY

After the completion of the Advance Excel Certification, the students will have several career opportunity like-

  1. Financial Analysts.
  2. Retail Store Managers
  3. Project Managers
  4. Business Analysts
  5. Data Journalists
  6. Accountants.
  7. Bank Variefer

ELIGIBILITY:

  1. Bachelor degree/ Graduate in any discipline from a recognized University
  2. International/ SAARC Graduate from a recognized/ accredited university or recognized University
  3. Result awaited students can also apply for the final year of examination of their bachelor’s program, subject to successfully completing their bachelor’s degree program/graduation within a time specified by IIM Gurgaon

DURATION AND VALIDITY

  1. The duration of the digital Marketing Certification is one year.
  2. The registration period is valid up to one academic year.

PROGRAM STRUCTURE:

Introduction
Using Excel lists
Creating a List
Sorting
To perform a Simple Sort
To Sort by Multiple Columns
Data Forms
Adding Data Using the Data Form
Finding Records Using Criteria
Filtering Data
AutoFilter
Advanced Filters
Special Features for Filtered Lists
Totals and Subtotals Total
Row
Subtotals
Manipulating data
Working with charts
Working with pivot table
What if’ analysis
Managing Windows
Multiple Windows
Splitting Windows
Freezing Panes
Linking Data
Macros
Printing Excel files
Managing Excel files
Grouping and outlining data
Shortcut keys and references
Analysis tool pack
Analysis by goal seek
Analysis by pivot tables