Print Page   |   Contact Us   |   Sign In   |   Register
Gauteng - Advanced Excel - 5 March 2019
Register Tell a Friend About This EventTell a Friend
Gauteng - Advanced Excel - 5 March 2019

Advanced Excel functionality can save a significant amount of time and effort, especially if the right functions are applied for a specific industry. This course delves into Excel’s advanced functionality for professionals with a specific focus on the property industry. The four main topics covered in the course are data manipulation, advanced formatting and complex charts, multi-advanced formulas and macros.

 Export to Your Calendar 2019/03/05
When: 5 March 2019
Registration Start: 08h00 to 08h15 Ending: 16h00
Where: Thornhill Office Park, Building 27, Suite G7
EduTech Training Centre @ ASAQS Head Office
94 Bekker Road, Vorna Valley
Midrand, Gauteng 
South Africa
Presenter: Ruan Bye
Contact: Nicolle de Bruyn
011 315 4140


Online registration is available until: 2019/02/26
« Go to Upcoming Event List  

Event name: Advanced Excel for Professionals

 

Nature of CPD event: One day interactive course

 

Course overview:

Advanced Excel functionality can save a significant amount of time and effort, especially if the right functions are applied for a specific industry. This course delves into Excel’s advanced functionality for professionals with a specific focus on the property industry.

The four main topics covered in the course are data manipulation, advanced formatting and complex charts, multi-advanced formulas and macros.

Delegates will complete practical examples such as manipulating bill of quantities, visually enhancing progress reports and automating repetitive tasks.

 

Course topics:

·         Assess and manipulate large volumes of data in a fraction of a time by using Excel’s built in intuitive functionality.

·         Program advanced formulas in combination with other formulas and functions (‘multi-advanced formulas’).

          For instance, using Excel’s ‘Name Box’ functionality in combination with data validation lists and the ‘Choose’      

          formula.

·         Identify and resolve user input errors before the values are committed to a spreadsheet.

·         Create multi-axes charts with dynamic colour and shape formatting.

·         Record basic macros and edit the code using Microsoft’s VBA editor.

 

Target delegates:

This course is designed for delegates who already have foundational knowledge and skills in Excel and who wish to take advantage of Excel’s higher-level functionality to analyse and present data.

 

Course presenter:

Ruan Bye holds an honours degree in accounting and a Bachelor of Laws from the University of South Africa and is a Chartered Accountant. He has over ten years’ experience in financial modelling obtained across various industries including banking, private equity and asset management.

He is also the presenter of Financial Modelling for Real Estate Development, an ASAQS CPD accredited course.

 

Course material:

Course material will be provided at the training session. Delegates are required to bring along their own laptop with Microsoft Excel installed (minimum version 2013).

 

Programme:

Registration: 08h00 AM

Event Starts: 08h15 AM

Event Ends:  16h00 PM

 

 

Venue Name: EduTech Training Centre

Venue Address

ASAQS Head Office

Thornhill Office Park, Building 27, Suite G7

94 Bekker Road, Vorna Valley

Midrand

 

 

CPD Hours: 7 CPD Hours - Category 1

 

This event has been assessed and accredited by the ASAQS.

 

Event registration fees:

ASAQS Members: R 2 500.00(Excluding VAT)

Non-Members: R3 000.00 (Excluding VAT)

Retired Members: R 1 250.00 (Excluding VAT)

ASAQS Students: R 1 250.00 (Excluding VAT)

 

Registration & Payment cut-off date: 26 February 2019