Two day training programme on Advanced Microsoft Excel

Date : 04/08/2022 - 05/08/2022 (TWO-day Program) Time : 09.30 am to 04.30 pm

Venue : Productivity House, Kalamassery


Introduction


This program is designed for those who are familiar with the basics of Microsoft Excel and would like to work with more advanced features of MS Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports and automating various tasks.

Upon successful completion of this course, participants will be able to:

·         Use advanced calculations

·         Do Dynamic formatting

·         Advanced data analysis

·         Dash board report


TOPICS/MODULES

 

Day 1 : Getting started with Excel 2010 - Office 365 I Working with Routine Functions I Dynamic Formatting I Database Management I Specialized Functions

Day 2 : Working with Reports I Presenting Data Using Charts I More Functions I What-If Analysis I Data Validations I Working with External Data I Creating Dashboard I Concepts of data analysis I Visualization of data I Covariance and Correlation


FACULTY

The core team of trainers lead by Mr. Amardeep Varma, SB Global Educational Resources Pvt Ltd., Kochi. The team has wide experience in handling MS Office tools and has the capacity to go to any level of operation of office tools from basics to advanced.

Download Brochure Click to Register

Style Switcher

Color Skin