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
Reviews
There are no reviews yet.