Excel, the longstanding powerhouse of spreadsheet software, is one of the most commonly used business applications nowadays. Now, you can get up to speed fast on the most advanced features for improving your efficiency and expanding your capabilities in Excel. The software has unlimited capabilities for making your job easier and less stressful. This training will teach you the most advanced features and functions Excel offers —taking your level of proficiency from basic to advance.
Naming Techniques
Advance Data Manipulation
Advance Chatting
Advance Functions
Pivot Tables
What-if Analysis
Macro
Upon successful completion of each training, participants will be awarded the certificate of attendance.
Hands-on, exercise, case study, test, brain-storming session.
Upon completion of the training, participants should gain renewed confidence in applying the skills and able to:
> Perform and apply the most advanced features of Excel
> Use formulas and functions in Conditional Formatting, Data Validation • Perform combination of functions
> Create modern and sophisticated charts
> Analyze, customize and summarize data using advanced features of Pivot Table
> Perform advance data analysis and projection using What-If Analysis
> Perform basic data automation using Macro
Managers. HR Personnel, Executives, Administrators and those who are interested to upgrade their spreadsheet skills. For anyone who want to develop a solid foundation in mastering advanced spreadsheet skills.
