PROGRAM OVERVIEW

The resources within Microsoft Excel that are available to accounting and finance professional’s remains one of the industry’s most widely used tools. Excel’s features provide data-driven insights that can help facilitate business decisions and client recommendations. In addition, it has calculation capabilities built-in, making it extremely convenient in a wide range of scenarios.

This course will guide participants through Excel’s features such as creating editing and modifying charts; working with multiple worksheets and workbooks; use financial and logical functions and protect worksheets and workbooks. This course also introduces Microsoft Excel users to the advanced features of the software application.

Participants will learn how to analyze and present data using PivotTables and Pivot charts; use data tables and scenarios to make data projections; insert lookup and database functions and audit worksheet formulas

At the end of this workshop, participants will be able to:

  • Create, edit and modify charts
  • Use financial and logical functions
  • Work with multiple worksheets and workbooks
  • Protect data for worksheets and workbooks
  • Use PivotTables to display and chart data
  • Use data tables & scenarios to make projections
  • Use lookup and database functions
  • Audit worksheet formulas
  • Use data tables & scenarios to make projections
  • Use lookup and database functions
  • Audit worksheet formulas

NOTE: THIS COURSE IS 100% HRD CORP SBL-KHAS CLAIMABLE

For inquiries, please contact the following Program Consultant:

Ms. Joan / email: joan@cfrontier.com / Tel: +6088731570

Ms. Emily / email: emily@cfrontier.com / Tel: +6088731412  

Mr. Azrul / email: azrul@cfrontier.com / Tel: +6088731410  

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