I grant Manipal Global the permission to contact me.

Program Overview

Manipal ProLearn’s Advanced MS Excel Program is comprehensive course to help you understand & apply all aspects of Microsoft Excel 2013 and 2016.

Program Highlights

1. Learn and practice relevant functions and formulae- Pivot Tables, HLOOKUP, VLOOKUP, Macros etc.

2. Discover new and more efficient ways to analyse and visualise data using Microsoft Excel

3. Practice with case studies and real data from various industries

4. Certification in Microsoft Excel 2016 solely provided by Manipal ProLearn

 

HOW WILL YOU BENEFIT FROM THIS PROGRAM?

Learn to use different excel functions like Pivot, Conditional formatting, Excel Charts etc

Get prepared to face the Microsoft Office Specialist certification exam

Learn to automate repetitive tasks using Macros

WHAT WILL YOU LEARN?

 

Introduction to MS Excel

 

Working with Workbook and worksheets

 

 

Introducing Excel formulas

 

Formatting Data

 

 

Inserting Objects in Worksheets

Managing Data in Excel

 

Excel Formulas and Functions

 

References and Lookups

 

 

Excel Tables

 

Working with charts

 

Pivots

 

 

What if Analysis

 

Macros

 

Keyboard Shortcuts

 

Printing Excel files

 

PROGRAM STRUCTURE

Duration 3 months (104+hours)
Delivery Mode Instructor-led webinars
Pedagogy

Live projects, simulations,  mentoring sessions with industry leaders