Certificate Course in Advance Excel



Course Name : Certificate Course in Advance Excel

This course provides expert level training in Microsoft Excel for any professionals wanting to enhance their office productivity skills. The students will learn how to optimize and analyze data using Pivot table, functions, charts and MACRO.



The students will learn advance excel skills like using math, statistical, logic and text functions, organize data by sorting and filtering. This course teaches how to use Pivot tables and MACRO functions for intelligent data projection.


Target Audience

  • 10th and 12th class students
  • Undergraduates, graduates and post graduates
  • Job aspirants
  • Corporate Employees



  • Computer Basics
  • Ms Office


Course Outline

  • Operators
  • Presenting Data Using Charts
  • Conditional Formatting
  • Data Validation and Name Manager
  • Text and Logical Functions
  • Date and Time Functions
  • Lookup and Other Useful Functions
  • Pivot Tables
  • What If Analysis
  • Macro
  • Assignments

Duration: 20 Days


Career Opportunities

  • Data Analyst
  • Excel Analyst
  • Business Analyst
  • MIS Executive
  • Research Analyst
  • Reporting Analyst

Pay online to book your seat for this course
Course Enrollment