ADVANCED MICROSOFT EXCEL

As you participate in course you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace.

SYSTEM 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 

Anything to ask?

If you have any question about training, fees, courses or anything else, feel free to ask us anytime!


Address

Nexperts Academy Sdn Bhd,
Unit 313, Block E, Phileo Damansara 1, Jalan 16/11 off Jalan Damansara 46350, PJ Selangor, Malaysia

Working Hours

Monday Tuesday Wednesday Thursday Friday

09:00 - 17:30 09:00 - 17:30 09:00 - 17:30 09:00 - 17:30 09:00 - 17:30

Contact

Email: vaheed@nexpertsacademy.com
Phone: +6 011 1221 6872
Office: +6 03 7931 8872