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.

Curriculum

 

Introduction:

  • Event-oriented programming

  • How to add Developer Tab into your Excel instance

  • Code Window, Properties Window, Project Explorer, Tool Bars

Variables And Constants:

  • Objects -Properties and Methods

  • Variables

  • Data Types

  • Difference between variables and Objects

Option Explicit:

  • Explicit variable declarations using the Option Explicit statement

  • Implicit variable declarations

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