NEXPERTS ACADEMY 

GET THE RIGHT CERTIFICATION

Live Online Training 
Classroom Training 

Online Training 

Learning is now made easy with the advancement of technology. In Nexperts Academy, we engage and collaborate with industry experts and committed trainers to provide quality training with best user experience.

Learn from anywhere with our most flexible training hours

MICROSOFT TECHNOLOGIES

COURSE OUTLINE

ADVANCED MICROSOFT EXCEL

Excel Overview
Excel Ribbon/Menu Commands
Basic Data Manipulations
Managing Workbooks & Worksheets
Formatting Basics
Excel Hierarchy  

Logical Functions
Arithmetic Functions
Date Functions
Aggregations
Strings  

Lookup Formulas
1. Vlookup
2. Hlookup
3. Nested Vlookup
Advanced referencing functions
1. Index
2. Match
3. Offset & etc 

Goal-Seek command
Using Data Tables
Scenarios
Merge scenarios from another worksheet 

Creating Charts using chart wizard
Useful Graphs & Charts
1. One Axis Graphs
2. Two Axis Graphs & etc
Gantt Charts 

Steps to create Pivot Table
Arranging fields (Methodology –How & Why)
Formatting Pivot Table
Introducing Slicing Tool
Managing & Formatting Slices 

Creating a Sparkline
Design a Sparkline
Comparing Sparklines  

Data Filters & Usage
Data Sorting
Pivot Tables (Creating, Updating & Modifying)
Advanced Formatting  

Recording, Executing & Saving a Macro
Editing & Debugging a Macro
Error Handling 

Discussion on a practical business scenarios
Interview question bank with answers
Resume modeling