
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