Yes I want demo!

Ask for Free Demo Now!

​

It’s not just about training. It’s about career progress. Jumbo Techno allows you to take control of your career by learning the right skills at the right time.

  MS
Excel

Curriculum

 

​

Getting Started:

  • Excel Overview

  • Excel Ribbon/Menu Commands

  • Basic Data Manipulations

  • Managing Workbooks & Worksheets

  • Formatting Basics

  • Excel Hierarchy

​

Functions:

  • Logical Functions

  • Arithmetic Functions

  • Date Functions

  • Aggregations

  • Strings

​

Complex Formulas & Functions:

  • Lookup Formulas

  • Vlookup

  • Hookup

  • Nested Vlookup

​

Advanced referencing functions:

  • Index

  • Match

  • Offset & etc

​

What-if Analysis:

  • Goal-Seek command

  • Using Data Tables

  • Scenarios

  • Merge scenarios from another worksheet

​

Chart & Layouts:

  • Creating Charts using the chart wizard

  • Useful Graphs & Charts

  • One Axis Graphs

  • Two-Axis Graphs & etc

  • Gantt Charts

​

Pivot Tables:

  • Steps to create Pivot Table

  • Arranging fields (Methodology –How & Why)

  • Formatting Pivot Table

  • Introducing Slicing Tool

  • Managing & Formatting Slices

​

Sparklines:

  • Creating a Sparkline

  • Design a Sparkline

  • Comparing Sparklines

​

Excel Tools (In-Built):

  • Data Filters & Usage

  • Data Sorting

  • Pivot Tables (Creating, Updating & Modifying)

  • Advanced Formatting

​

Macros:

  • Recording, Executing & Saving a Macro

  • Editing & Debugging a Macro

  • Error Handling

​

Career guidance:

  • Discussion on practical business scenarios

  • Interview question bank with answers

  • Resume modelling

​

​

Let’s Write Your Story

Lorem ipsum dolor sit amet!

We'd love to help you.

We help you unlocking your learning Potentials!

Top Categories

Company

  • Facebook
  • LinkedIn
  • Twitter
  • YouTube
  • Pinterest
  • Instagram

Resources

Support

Webinars

Request for demo