Course Overview?
Most professionals acknowledge the importance of manipulating numerical data using spreadsheets, yet this very important business tool is greatly underutilized (i.e. less than 10% of its capability is actually used).
The main reason for the underutilization is a lack of formal training in Best Practice Spreadsheet modelling that is necessary to enable them to tap into the features that excel can offer if applied properly.
As a result, most professionals spend more hours working in Ms. Excel based reports than desired. Therefore, This Four (4) days practical course, is packed with spreadsheet fundamentals and essentials which every professional must know.
Course objectives
This training is designed for Chief Accountants, Accountants, HR Professionals, Administrators, Economists and Planners, Project officers, Assistant accountants, Accounts officers, Budget officers, Finance Managers, Finance officers, Auditors, Audit assistants, Audit officers, Treasurers, Financial Analysts, Tax Consultants, Investment professionals and other interested professionals who want to transform their Excel skills to the next level and move from building simple excel models to Complex financial models. Employees from Public and Private organizations are highly invited. For those want to develop data analysis and reporting skills, this training is a perfect match to their career goals!
Course contents
- Overview of Excel and acquainting with the Excel Environment and what’s new in Excel 21 and Offices 365.
- Formulas and Functions, including Function Golden Rules
- Cell Referencing – when Copying Formulas
- Types of errors including the Circular Reference
- Excel Short Cuts
- Flash fill and Custom list
- Data Outlining tools like Sub-Total and Grouping
- Analysing data with Tables, and Remove Duplicates
- Exporting data from other systems to Excel – Exploring the use of TEXT TO COLUMNS tool
- Collaboration of Excel and other MS Office packages – Embedding and linking
- Consolidating several sheets into a summary page
- Printing by creating print titles, headers & footers in Excel for professional reporting.
- Joining text using Concatenate
- Using Text and Date functions and how to make dynamic concatenation
- Using Format cell tools