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!