- Guaranteed To Run
- All Courses
- ALL MICROSOFT COURSES
- WORKPLACE WELLNESS PROGRAMS
- SFC-ELIGIBLE COURSES
- SG ENABLE (TT-CDC Grant)
- About Us
- Insights
- Rewards Account Login
This is an advanced course which will prepare the participants to use advanced spreadsheet features and functionality. Participants will have the knowledge and application skills in using a spreadsheet application at an advanced level. The skills include maintaining complex spreadsheets, using complicated functions of various types, and using auditing techniques to check for errors.
Information workers using Excel in daily work processes. Basic experience with Excel including creating workbooks, navigating worksheets, columns and rows and using basic functions such as SUM, AVERAGE will be expected from the audience.
Participants will have the knowledge and application skills in using a spreadsheet application at an advanced level. The skills include maintaining complex spreadsheets, using complicated functions of various types, and using auditing techniques to check for errors.
Module 1: Advanced Formatting
Module 2: Advanced Functions and Formulas
Module 3: Data Analysis using Pivot Tables and Business Intelligence
Module 4: Workbook Management Features
Module 5: Advanced Charts, Functions and What-If Analysis
Module 6: Data Filtering, Macros and Forms
Avantus Training began from the need to develop a skilled pool of technology talent for the community; keeping abreast of the constantly evolving IT landscape. Since, we have been recognized for our ability to be a life-long training partner and mentor for every individual.