This Advanced Excel program is designed for executives, engineers and managers who are good user of Microsoft Excel, and who would like to work with most advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating strong and professional MIS reports, writing complex functions and automating various tasks.
Note: This is corporate level program,will be helded as workshop in an external location ,Tea, snacks and Lunch will be provided.
The Frequency of the program is usually on Weekends.
Registration can be done by contacting the Trainer Bhavna Philipose on UrbanPro
Program Objectives:
This Advanced Excel training program will empower the participants to be able to do the following:
Performing complex calculations more efficiently, using various Excel functions. Organizing and analyzing large volumes of data. Creating professional MIS reports. Designing and using templates. Analyzing data using nested function Creating dynamic range Consolidating and managing data from multiple workbooks. Recording Macro to automate work
Audience
executives, engineers and managers who have already been using Microsoft Excel, but now feel the need to learn most powerful features and options of Excel, to manage their worksheet/MIS -related tasks more efficiently.
Prerequisites :
Participants attending this training should be good in Microsoft Excel, especially with Formulas - Function,Vlookup,Logical Functions,Chart & fair knowledge about Pivot table.
Module Topics
Module 1. Efficient way of using Excel
Module 2. Conditional & Logical Function
Module 3. Lookup & Reference Function
Module 4. Formatting using Formula and Function
Module 5. Customized Sorting and Filter
Module 6. Advance Pivot
Module 7. Working with Data Analysis
Module 8. Recording Macro
View this Course
Certified
You have 
