# MS Excel

## Join myTectra to Up-Skill on the most popular programming languages Advanced Excel !

#### Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes. Weekend Class : 10 sessions of 3 hours each. Weekday Class : 15 sessions of 2 hours each.

You get lifetime access to Learning Management System (LMS) where presentations, quizzes, installation guide & class recordings are there.

#### Real-life Case Studies

Live project based on any of the selected use cases, involving real time project of the various Advanced Excel concepts.

#### 24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

#### Assignments

Live project based on any of the selected use cases, involving of the various Advanced Excel concepts.

#### Certification

Towards the end of the course, you will be given access to online Test. myTectra certifies you as an Advanced Excel Expert based on the scoring of 60% or above.

#### Chapter 1: Getting Started

• Excel Overview
• 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
• Vlookup
• Hlookup
• Nested Vlookup
• Index
• Match
• 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
• One Axis Graphs
• 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)

#### 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 Ratings Yet)