Description
Learning Objectives
At the conclusion of this 3-day webinar training course, participants are expected to be capable of creating navigable workbooks, with electronic dashboards, and automatically updating data sources, tied-in with various data visualizations and Pivot tables. They should be conversant with names, hyperlinks, dashboards, parameters for pivot charts, slicers or report filters, and other advanced and productive capabilities.
During the workshop session, several seatworks, which have to be completed and submitted using the MS Excel version 2010/2016/Excel Office 365, will be administered, to enhance the skills of the participants.
Who Should Attend
- Anyone who is serious about learning Excel for finance
- Everyone involve with Finance function and operations
Course Duration
- 3 days, 3 hours each day
Pre-requisite
- Participants must have been using Microsoft Excel 2010 and above four at least one-year continuous usage.
Course Overview
The following are the subjects to be taken up during the workshop proper
Day 1:
- Foundation for Advanced Techniques
- About the MS Excel Cheat Sheet
- Customizing MS Excel Ribbon and Quick Access Tool Bar
- The MS Excel Date and Time Feature
Day 2:
- Advanced Report Generation Techniques
- Automating and Simplifying Report Updates the Easy Way
- Data entry of Subsidiary data (includes Sales, Cash Receipts, Inventory, Purchases, Cash Disbursements, Chart of Accounts)
- Introducing data visualization using data and date slicers
- Applying built-in financial, statistical, database date and time functions
- Creating actionable insights in Excel Dashboards and Data Visualization
Day 3:
- Formula Audit and Tracing
- Displaying all formulas within a worksheet
- Generating the following financial reports:
- General Ledger statement
- Income statement
- Balance sheet
- Financial Ratios (profitability ratio, Debt-to-Equity ratio)
