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 functions 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.

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

Computer basics:

  • Computer Basics
  • Ms Office
# Topics Covered  
1 Working with Excel Data
2 Working with Basic Math
3 Introduction Formula
4 Understanding functions and their components
5 Understanding statistical functions and text functions
6 Understanding VLookup
7 Understanding Data optimization and MACROs
8 Introduction to PIVOT tables
9 Presentation and reporting using custom rules
10 Project assignment
Total no. of hours 40

On completion of this course the students can work as

  • Data Analyser
  • Excel Programmer
  • Business Analyst

Pay online to book your seat for this course
Course Enrollment