Thursday, May 3, 2018

Advanced Excel training in Bangalore

Advanced MS Excel Training in Bangalore - Live Online & ClassroomGain 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.myTectra the Market Leader in Advanced Excel Training in BangaloremyTectra offers Advanced MS Excel training in Bangalore using Class Room. myTectra offers Live Online Advanced MS Excel Training Globally.


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

Chapter 7 : Sparklines
Creating a Sparkline
Design a Sparkline
Comparing Sparklines

Chapter 8 : Excel Tools (In-Built)
Data Filters & Usage
Data Sorting
Pivot Tables (Creating, Updating & Modifying)
Advanced Formatting

Chapter 9: Macros
Recording, Executing & Saving a Macro
Editing & Debugging a Macro
Error Handling

Chapter 10: Career guidance
Discussion on a practical business scenarios
Interview question bank with answers
Resume modeling

No comments:

Post a Comment