Advanced Excel Online Intermediate Level by MITCON Udyog Prabodhini

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

Career Opportunities

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