Course Detail()

For Youth Associate members only
Sign up for complimentary ISCA student membership here now to enjoy similar entitlements.

Programme Objective

Developing Excel skills is a powerful way to start analysing data like the professionals do. Excel spreadsheet is one of the most essential tools to any modern Accounting and Finance Professional. This hands-on workshop is designed to provide you with a good grasp of Excel and the ability to collate, organise and analyse data. Mastering this essential skill set allows you to conduct data reporting and simulate data outputs efficiently.

By the end of the workshop, you will:

Learn how to develop a “toolkit” of Excel tips and techniques
Learn how to debug formulas and stress test Excel outputs from models
Learn how to understand and solve problems within an Excel spreadsheet environment
Use with confidence Excel’s keyboard shortcuts to improve their speed and efficiency
Develop with confidence Excel formula in order to build robust solutions
Learn to format presentation-quality reports quickly and consistently

Programme Outline

Excel Productivity Techniques and Best Practices
- Excel spreadsheet setup and development environment
- Spreadsheet development techniques
- Excel fundamentals and formula building
- Keyboard shortcuts (to make you 8 times faster)
- Formula debugging and auditing
- Inputs vs. formulae
Building Flexible Formulas in Excel
- Relative vs. Absolute referencing
- Using names to increase formula efficiency
- Formula layout to simplify
- Logical statements
- IF, AND, OR functions
- Conditional formatting
Data retrieval and report presentations in Excel
- HLOOKUP/VLOOKUP
- CHOOSE
- INDEX/MATCH
- OFFSET
Working with text and dates in Excel
- Text strings (dynamic text)
- TEXT functions
- Date Functions
Building Flexible Charts in Excel
- Form controls for flexible reporting and charts
- Chart set ups/labels
Analysing the Output
- Macros and automation in Excel
- Adhoc reporting and data analysis with Pivot tables

Training Methodology

This course is a hands-on workshop where participants will get to apply their knowledge with hands-on exercises, guided by the trainer. Participants are required to bring along their laptops, equipped with latest Excel with full installation. Participants should have basic knowledge of Excel.

Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Youth Associates and Accountancy undergraduates only

Schedule & Fees

Testimonial

Funding

No funding Available!

Programme Facilitator(s)