Advanced MS Excel

Advanced MS Excel Training in Bangalore - Live Online & Classroom

Gain a strong foundational knowledge of Advanced MS Excel and become a certified ProAdvisor. Master the art of managing your clients' books in Advanced MS Excel and customizing it so you're equipped to fulfill the needs of any client. Getting certified in Advanced MS Excel is the best way to enhance your professional profile, showcase your expertise and attract new clients.

Chapter 1: Getting Started

Excel Overview

Excel Ribbon/Menu Commands

Basic Data Manipulations

Managing Workbooks & Worksheets

Formatting Basics

Excel Hierarchy

Chapter 2: Functions

Logical Functions

Arithmetic Functions

Date Functions

Aggregations

Strings

Chapter 3: Complex Formulas & Functions

Lookup Formulas

1. Vlookup

2. Hlookup

3. Nested Vlookup

Advanced referencing functions

1. Index

2. Match

3. Offset & etc

Chapter 4: What-if Analysis

Goal-Seek command

Using Data Tables

Scenarios

Merge scenarios from another worksheet

Chapter 5: Chart & Layouts

Creating Charts using chart wizard

Useful Graphs & Charts

1. One Axis Graphs

2. Two Axis Graphs & etc

Gantt Charts

Chapter 6: Pivot Tables

Steps to create Pivot Table

Arranging fields (Methodology –How & Why)

Formatting Pivot Table

Introducing Slicing Tool

Managing & Formatting Slices

>> Read more >>