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
