Description
This course is not for starters, rather, it has been packaged to enable casual and intermediate users with financial related deliverables to take their MS Excel skills to another level of proficiency. This is a hands-on course that will showcase efficiencies with the use of advanced financial functions while introducing super user shortcuts.
Training Objectives
During this training, participants will learn how to;
❖ Automate recurring processes
❖ Use the most powerful features of Excel
❖ Know which features and functions should be used for various high-level tasks
❖ Entering and editing formulas
❖ Absolute and relative cell referencing
❖ Conditional formatting
❖ Learn to record macros
❖ Data validation and creating drop-down lists
Learning Outcomes
At the end of this course participants will be able to;
❖ Project financial statements including key schedules
❖ Perform financial statement analysis
❖ Perform sensitivity and scenario analysis for Budget
❖ Understand visual basic: macro and user-defined functions
❖ Manipulate and create pivot charts
❖ Secure worksheets and workbooks
❖ Understand IF functions and other efficiency gains
❖ Learn using advanced Excel tools
❖ Prepare Final Accounts using Pivot Tables
Target Audience Accountants, Financial Analysts, Auditors, Equity Analysts, Budgeting Managers, Credit Controllers & anyone with corporate finance & accounts responsibilities.
Mode Of Delivery Virtual Class with instructor-led class exercises and project-based/assignments learning methodology 9hours of learning sessions Course material and Course Certificate will be issued Course video available on-demand Face- to- Face learning available on request
Reviews
There are no reviews yet.