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!