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 Pivot charts; use data tables and scenarios to make data projections; insert lookup and database functions and audit worksheet formulas.