Advanced MS Excel
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 (Methodol