EXCEL.NET COMPUTERS EDUCATION CENTRE | Sri Radhey Educational Society of Information technology under Govt. of Utter Pradesh.

Advance Excel 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 Duration

2 Months / 3 Months

Course Fees

To know fees details contact us now.

Class Mode

Monday to Friday

Course Placement

Now a days Advance excel is being used in every organization. So there is no problem in placement.

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.

Advance Excel Course C

To Know Complete Advance Excel Course Content and Advance Excel fees contact us now.