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 >>Read More>>