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 analyse and present data using PivotTables and Pivotcharts; use data tables and scenarios to make data projections; insert lookup and database functions and audit worksheet formulas.
LEARNING OBJECTIVES
Upon completion of this program, 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
100% HRD Corp Claimable Course: Skim Bantuan Latihan Khas
For more information, please contact the following Program Consultant:
Ms. Joan / email: joan@cfrontier.com / Tel: +6088 731575