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

• 10^th and 12^th 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