Advanced MS Excel
Excel the most trending and highest paid Programming Jobs. Enrol Today!
Learn Python from iteanz the market leader !
Microsoft Excel is a spreadsheet developed byMicrosoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
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.
Live project based on any of the selected use cases, involving of the various Advanced Excel concepts.
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
- Excel Ribbon/Menu Commands
- Basic Data Manipulations
- Managing Workbooks & Worksheets
- Formatting Basics
- Excel Hierarchy
- Logical Functions
- Arithmetic Functions
- Date Functions
CHAPTER 3: Complex Formulas & Functions
- Lookup Formulas
- Nested Vlookup
- Advanced referencing functions
- Match Offset & etc
CHAPTER 4:What-if Analysis
- Goal-Seek command
- Using Data Tables
- 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
- 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
- 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