MS Excel

Course Features

Course Details





Advanced MS Excel

Excel the most trending and highest paid Programming Jobs. Enrol Today!


Learn Python from iteanz the market leader !

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

Training Features

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.

Lifetime Access

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.

Course Outline



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
  • Vlookup
  • Hlookup
  • Nested Vlookup
  • Advanced referencing functions
  • 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)
  • 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


Request more information


Fascinated to Learn MS Excel


Ratings

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Awards

This course does not have any sections.

More Courses by this Instructor