Participants will gain an advanced level of understanding of the Microsoft Excel environment, empowering them to guide others in effectively using the program’s full range of features—skills that are especially valuable in roles such as accountants, financial analysts, and commercial bankers.

This workshop will enable participants to create, manage, and distribute professional spreadsheets for various specialized purposes. They will also learn how to customize their Excel 2016 environments to meet specific project needs, enhancing productivity. Workbook examples covered in the course include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

1 Day

R2500 per delegate (VAT inclusive)

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

• Entry-level employees handling data and spreadsheets
• Administrative staff managing reports and records
• Finance professionals working with numbers
• Students and job seekers wanting to boost their computer skills
• Entrepreneurs tracking business finances and sales

Session 1: Course

• Create worksheets and workbooks
• Navigate within worksheets and workbooks
• Format worksheets and workbooks for optimal presentation
• Change views and configurations to enhance user experience
• Print and distribute worksheets and workbooks effectively
• Manage data cells and ranges for efficient data organization
• Create tables, charts, and objects to visualize data
• Perform operations with formulas and functions for dynamic analysis