Advanced MS Excel for Accounts & Finance
Advanced Excel for Accountants and Finance Professionals
Description Participants will learn how to ; perform calculations and manipulate worksheet data; format the worksheet contents; working with sheets ; working with charts; modifying chart options, work with multiple worksheets and workbooks and prepare, set up, print information.
Who should attend? Business analysts and professionals, supervisors and staff from any function including finance who need to improve their understanding and use of Microsoft Excel as an important tool to produce more effective and efficient work.
What You Will Learn: Use Microsoft Excel in business finance more effectively. Perform analysis and evaluation to assist in enhancing the decision making process. Understand and create pivot tables and pivot charts. Analyze business data in no time. Prepare business and flash reports to senior management.
Prerequisites Basic knowledge of Excel.
Objectives: Upon successful completion of this course, students will be able to: Basic Features of MS Excel MS Excel Financial Functions Business and Financial Data Validation Working with Financial Data
Zabeel Institute, UAE. 04-3974905
Page 2 of 5
Must Tools for Every Business and Finance Professional Data Consolidation Pivot Table and Pivot Charts – A Must Learn Tool
Course fee & Duration: AED 3000 for 15 lecture hrs + practice hrs
Course Outline Basic Features of MS Excel
A First Look At MS Excel What are Worksheets and Workbooks? Cells, Rows, Columns Cell References (Absolute, Relative…) Types Of Operators
MS Excel Financial Functions (To calculate depreciations)
Use the SYD function to calculate Depreciation Use the SLN function to calculate straight-line Depreciation Production per hour Calculate the age of a person in days
Business and Financial Data Validation (To validate the error in cash flow, fund flow, etc)
Setting-Up Your Validation Rules Selecting Different Input Variables Using Lists to Restrict Data Input to Your Business Model
Working with Financial Data (To sort list, salary list, stock list etc)
Sort Creating Form Subtotal Text To Columns
Business and Financial Functions (Investment & share details etc)
Decide Amount To Invest Compare investments Using the double-declining balance method Determine the payment of a loan
Zabeel Institute, UAE. 04-3974905
Page 3 of 5
Must Tools for Every Business and Finance Professional (Trial balance, balance sheet, cash flow etc)
IF STATEMENT MID, LEFT, RIGHT VLOOKUP
Data Consolidation (employee sheet, sales budget, etc)
Using Appropriate Function Selecting Different References Creating Source To Consolidated Data
Pivot Table and Pivot Charts – A Must Learn Tool
Using Your Own Data( stock data, cash flow, trial balance) Using Your Imported Data Using Consolidation Ranges( employee salary) Enhancing Your Report with Data and Format Options( variance report)
Certification Certificates will be issued at the end of the course attested by the Ministry of Education, UAE
Zabeel Institute – at a glance Zabeel Institute, established in 1988, is a leading Educational and Training Institute for executives in Dubai and is approved by the Ministry of Education, UAE. We offer training programs to professionals from various industries like Engineering, Construction, Projects, Accounts & Finance, and Management, Languages etc. The Zabeel Advantage
20 Years Experience in training Professional Executives Achiever of many QUALITY AWARDS for training from 1988 till date Qualified & Certified Trainers Sophisticated Lab with High end machines and Licensed software Certificates attested by the Ministry of Education, UAE Vast resource materials for reference and course materials Free online support for further assistance
Free follow up orientation seminars & workshops & placement assistance