Best Advance Excel Training Institute in Delhi
The Superweb Computer Education Institute Recognised as the Market Leader in providing
Microsoft Excel Training. Our "Microsoft Excel Team" have more than 5 years of industry
recognised teaching experience in creating and editing workbooks and spreadsheets. Our
specialised instructors have developed unique teaching styles to help aspiring candidates
master the art of successfully using the features of MS Excel to perform various tasks and
improve productivity.
Advance Excel Course Content
Duration: 3 months
Function for Advance Excel
- 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
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
Sorting & Filtering in Advance Excel
- Multiple Level data Sorting
- Custom Sorting data in excel
- Advance Filter
- Multiple Sheet Filtering
- If Function & Its uses
Array & DB Function in Excel
- Stored Array
- Operators in Excel
- Array constant
- Array Formulas of Single Result
- D average, D count, D
View & Protection
- Protection & Un-Protecting Worksheet
- Custom View
- Edit, Switch & Delete Custom View
- Consolidating Multiple Sheet
- Grouping & Outline
- Using External Data Source
Template designe in excel
- If Function & Its uses
- If Function & Its uses
- If Function & Its uses
- If Function & Its uses
- If Function & Its uses
- If Function & Its uses