News

HOT LINE:

9019191856

+1 (210) 977-1011 (USA)

My Cart

0

Advanced MS Excel

 

  

Training Mode: Class Room / Live Online


Need Help? please call us on +919019191856 or Click Here to send us an Enquiry

QUICK OVERVIEW

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.

myTectra the Market Leader in Advanced Excel Training in Bangalore

myTectra 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

To Learn Live Online Advanced MS Excel Training in Training Globally and Advanced Excel Training in Bangalore using Class Room, ENROLL TODAY at myTectra.


Customer Reviews

1 Item(s)

per page
I am highly satisfied with the Training and Support provided by myTectra. Review by Kempi
Price
Value
Quality
Joined in this institute for completing my course. . Study materials have been provided to clarify our doubts.

1 Item(s)

per page

Only registered users can write reviews. Please, log in or register

brand
myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.
WHY DO YOU AWAIT FOR FIXED SCHEDULES ? CHOOSE MYTECTRA LEARN AT YOUR CONVENIENT TIME

myTectra flexible batch schedules enables you to start your class at your convenient date and time.


1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time


Do you have any questions ? please call us on +919019191856 or email to support@mytectra.com