Now a days, financial and corporate sector in India require many professionals who are acquiring good knowledge of Advanced excel.
So what are these Advanced Excel skills?
Advanced understanding Of Excel, make user familiar to some tools which can create formula and give platform to make good analysis so that one can make advanced analysis.
Classes are typically held 1.5 hours a day/5 days a week.
On successfully completing the course, you will be ready to join top companies as:
- Accounts Professional
- Accounts Executive
ORGANISING AND PRESENTING DATA
- MANAGE CELL & RANGE NAME
- CALCULATING DATA ACROSS WORKSHEETS
- USE SPECIAL FUNCTIONS
- USING FORMULA TO SEPERATE DATA INTO SEPERATE COL.
- LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON
- Create A Chart
- Chart Element
- Changing A Chart Type
- Modifying A Chart
- Format A Chart
- Set Up Dynamic & Intreactive Chart
- Calculating In Pivot Table
AUDITING & ANALAYING DATA
- Create Table Dialog Box
- Styles And Quick Style Set
- Formate Table
- Sort Or Filter Worksheet Or Table Data
- Database function…….Dsum(), Daverage(), Dcount()
- Insert And Modify Picture And Clipart
- Draw And Modify Shapes
- Illustrate Workflow Using SmartArt graphics
- Layer And Group Graphics Object
- Customizing And Enahancing Workbook
- Customizing Workbook
- Manage Themes
- Create And Use Template(ex-bills)
IMPORTING AND EXPORTING