This course is designed for participants seeking an advanced understanding of the Microsoft Excel environment. It equips them with the ability to guide others in utilizing Excel’s full suite of features, which is essential for roles such as accountants, financial analysts, and commercial bankers.

Participants will learn to create, manage, and distribute professional spreadsheets tailored to specialized purposes and business needs. The course will also focus on customizing the Excel 2016 environment to boost productivity. Advanced workbook examples, such as custom business templates, multi-axis financial charts, amortization tables, and inventory schedules, will be used throughout.

1 Day

R2500 per delegate (VAT inclusive)

• Onsite: Instructor-led training in Johannesburg
• Online: Live virtual sessions

• Analysts and data professionals
• Finance and accounting professionals
• Business intelligence specialists
• HR professionals handling payroll and employee data
• Experienced Excel users looking to automate processes

• Save a workbook as a template, including custom colors, fonts, cell styles, and themes
• Reference data using structured references or from another workbook
• Protect a workbook from further editing to secure sensitive information
• Prepare a workbook for internationalization to ensure compatibility with global audiences
• Apply custom data formats and validation to control data input
• Use advanced conditional formatting and filtering for more dynamic and responsive worksheets