Shorthand Course Content
Function for Advance Excel
If Function & Its uses
Nested If Function
And, Or, Not Compound If Function
Advance Lookup, V lookup, H lookup
Match Index, Sum Ifs, Count Ifs
If Error & Is Error Formulas
Array & DB Function in Advance Excel
Stored Array
Operator
Array Constant
Array Formulas of Single Result
Array Formulas of Multiple Result
D average, D count, D product, D sum
Sorting & Filtering in Advance Excel
Sorting Table
Multiple Level Sorting
Custom Sorting
Filtering Data for Selected View
Advance Filter
Multiple Sheet Filtering
Report MIS
Creating Sub Total
Creating & Customizing Pivot Table
Advance Options of Pivot Table
Consolidating Multiple Sheet
Using Pivot Table, Pivot Charts
Using External Data Source
View & Protection
Protection & Un-Protecting Worksheet
Custom View
Edit, Switch & Delete Custom View
Grouping & Outline
Freeze Panes
Templates
Designing Templates
Using Predefine Template
Worksheet Standardization
Planers
Budgets
Inventory
Advance Excel Course Highlights
Course Fees
To know fees details contact us now.
Carrer Objectives
High Court
Indian Railways
NDMC
Ministry of Home Affairs
NSDC
After Course Completion
After Completing this Course you can create any type of automation with Excel and become excel expert.
After This Course you can work as MIS Executive also.
