Institute of Information Technology
+021-36990045
Mon-Sat, 9:00am - 9.00pm
info@theappstation.net
Mail Us
What You Will Learn?
- Learn advance formula
- Learn data, power query , tables and formatting
- Learn Advance Charting
- Pivot table and pivot reporting
- Tables with advance level
- Learn about Macros
Duration: 1 months Classes: 12 Hours: 24
In The Advance Excel You Will learn
ADVANCE EXCEL COURSE OUTLINE
- if conditions
- lookup functions
- paste special
- pivot table & charts
- hyperlink
- files import & export
- attendance sheet
- property window
- student report
- marksheet
- sum if function
- data sorting
- basic & advance formulas
- nested formula
- database functions
- filter/ advance filter
- if analysis
- data validation
- working with scenario
- payroll statementl
- sales report
- macros
- advance macros
- charts & graphs