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