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

Price Based Country test mode enabled for testing Brunei. You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari