INTRODUCTION
Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.
This course introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables.
In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, and create and use macros.
By the end of the training, you will bring home the following skills:
- Manage data in lists
- Filter and query data
- Use lookup and database functions
- Protect worksheets and workbooks
- Use PivotTables to display and chart data
- Use data tables & scenarios to make projections
- Audit worksheets
- Work with Macros
NOTE: THIS COURSE IS 100% HRD CORP SBL-KHAS CLAIMABLE
For inquiries, please contact the following Program Consultant:
Ms. Emily / email: emily@cfrontier.com / Tel: +6088731412
Mr. Azrul / email: azrul@cfrontier.com / Tel: +6088731410
Ms. Joan / email: joan@cfrontier.com / Tel: +6088731570
Ms. Tracy / email: tracy@cfrontier.com / Tel: +6088731575