Advance Excel
Course Contents
- Different types of Formula:
- Sum if
- Count
- Count if
- Aggregate
- Sub total
- If
- Average
- Round & Many More Formulas
- H – Lookup, V – Lookup
- Different Company Salary Sheet in Excel like:
Calculation of Provident Fund (P.F.), Professional Tax (P. Tax), ESI
- Transpose in Excel and utility of it
- Using sub-total option in Excel to Calculate department-wise total
- Pivot table in Excel
- Different worksheet create by using sum and aggregate function
- Purchase & Sales Bill Create (After adding vat amount)
- Filter: i) Advance Filter ii) Auto Filter
- Using advance filter to find out particular employee salary amount
- Text to column & remove duplicate option in Excel
- Conditional Formatting
- Hyperlink, object
- Scenario Management
- Goad seek, solver
- Macro
- Security Protection in Excel
- Freeze panes, split, hide and unhide option in Excel
- Data Form option in Excel
- Utility of Comment option in Excel
copyright@eccikolkata.com
1
2
3
4