Empowering-People-Knowledge

Demystify some of the most complex business relevant areas of Microsoft Excel.

Become an Expert and learn to use Excel like a pro with this Advanced Excel Training.

These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you to become better at your job responsibilities and can give you time to focus on things and people that matter.

Microsoft Excel just might be the greatest piece of software ever developed.

So while there are a lot of basic tricks that you have to know, there are also a few tricks that will set you head and shoulders above the competition.

If you want to dazzle your bosses and beat your rivals, this training is a must for you !!!

Course Module

Module 1 = Conditional Formatting

a) Excel Conditional Formatting Options
b) Simple Conditional Formatting
c) Highlight Cells Rules
d) Clear Rules
e) Top/Bottom Rules
f) Color Cells Based on Cell Value
g) Find Duplicate Data in Excel with Conditional Formatting
Module 2 = Pivot Tables & Pivot Reporting

a) Data Field

b) Column Labels

c) Row Labels

d) Summation values

e) Change Summary Calculation

f)Update (refresh) data in a PivotTable

g) Freeze Panes
Module 3 = Charts

a) Create a Chart
b) Change Chart Type
c) Switch Row/Column
d) Chart Title
e) Data Labels
f) Move or resize a chart
Module 4 = Formulas

a) Text Filter (And, Or)

b) Text ( Concatenate, Len, Lower, Proper, Substitute, Trim, Upper)

c) Date & Time(Now, Today)

d) MIS Functions = Lookup & Reference (Vlookup, Hlookup, Rows, Columns)

e) Auto Filter, Custom Auto Filter

f) Logical ( IF,NESTED IF )

g) Absolute & Relative referencing, Excel Mathematical function: SUM, AVERAGE, MIN, MAX ,ROUND, ROUNDUP, ROUNDDOWN, SUBTOTAL, AUTOSUM
Module 5 = Other Useful Topics

a) Handling Formula Errors

b) Data Validation

c) Insert Comment

d) Macros

e) Goal Seek

f) Sheet Protection

g) To Remove Duplicates

h) Alt Short Cut Keys

Add on Benefits

Choose Your Direction

Advanced Excel Training

Master Yourself into Advanced Excel and

Take your Career to new heights

I WANT THIS PLAN

Advanced Excel Training ( CLASSROOM / ONLINE )

Demystify some of the most complex business relevant areas of Microsoft Excel.

Course Module

Add on Benefits

Choose Your Direction