advance-excel-course-in-pune

Certificate Course in Advance Excel

Objectives

 

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.

 

Overview

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

 

Pre-requistes

  • 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