Graphs, Statistics and Numerical Reporting for PAs and Administrators
 

course overview

Businesses depend on accurate and reliable information presented in a meaningful format to assist management and teams to make effective business decisions.

Whether it's the MANCO report, EXCO report, sales report or finance report, the information contained is often critical for determining the company's future direction.

However, surprisingly few people have had any kind of formal training to equip them with the skills and knowledge needed to deliver and enhance the information so critical to business success.

In order to assist PAs and administrators to master the skills required, BizTech is offering a course on "Graphs, Statistics and Numerical Reporting for PAs and Administrators". 

The course covers the following topics:
 

• When should you use which kind of graph (Bar chart, line, pie, etc)
  
• Data manipulation so that you only use what you want to use through sorting and filtering
  
• Presenting meaningful data
  
• Combining multiple sets of data to show a comparative analysis (different years, product lines, etc)
  
• Showing targets vs actuals on a graph
  
• Developing templates so that updates are quick and easy
  
• Allowing for "what if?" scenarios

• Designing graphs to show trends and seasonality
  
• Designing graphs to show variances
  
• Understanding and using the typical formulas used for numerical reporting
  
• Producing forecasts and histories
  
• Showing the top 10 and / or the bottom 10
  
• Labeling, colouring and formatting for clarity of display
  
• Using pivot tables to show information with a different focus
  
• Excel techniques that make your life easier

• Professional graphing and reporting using Excel
  

who should attend

• Office managers and team leaders entrusted with producing performance statistics
• PAs, secretaries and office administrators who are required to compile numerical reports
• Support staff responsible for producing monthly reports
• Any person looking to improve their numerical reporting skills

outcomes

After attending this course, you should be able to:

• Understand numerical reporting so that you can develop your own meaningful charts
• Add value to your manager or team by producing information to assist with business decision making
• Improve efficiencies through better understanding data and charting methods
• Produce reports for marketing, finance, sales, HR, production, etc through understanding the principle techniques of data manipulation and graphs

take home tools

Training Manual & CD

All delegates receive one month of telephonic support relating to course content

general

COURSE DURATION
The course will take place over 2 days - 08:30 to 16:30 daily

COURSE FEES
R6 650.00 (excl. VAT) per delegate

(5 % discount for enrolment 2 weeks prior to course date)

PROVISION OF THE COURSE BY BIZTECH INCLUDES:

• Dynamic and knowledgeable facilitators

• Training File and a CD

• Certificate of Attendance

• High quality training venue

• Lunch and refreshments

• Parking

• Quality folder, notepad and pen

the venue

The course will take place at the AstroTech Conference Centre in Parktown, Johannesburg. 

The AstroTech Conference centre is in a gracious mansion in one of the most historic and beautiful areas of Johannesburg.

It is a high-end business focused conference centre with competitively priced packages, excellent facilities and top client service.

Close to major highways, airport and Johannesburg city centre, this state-of-the-art venue offers elegance, discretion, security and convenience with safe parking.

The course will be run from 08:30 to 16:30 daily.

Course venues will be confirmed prior to course commencement.

bbbee compliance

BizTech is BBBEE level 1 compliant. This means that we are a 135% contributor and companies investing money in training their staff through BizTech can also improve their own BBBEE scorecard. Not only does it offer an opportunity to improve your company's Skills Development BBBEE category, but you can also improve your BBBEE Preferential Procurement category. In each case your company will benefit 135% of the spend made.

terms and conditions

Should course expectations not be met for any reason, delegates are given the opportunity to leave before lunch on the 1st day and receive a full refund of the course fee.

Cancellations:
A cancellation can only be confirmed if we are advised in writing at training@biztech.co.za
For cancellations received more than one week prior to the course:
          0% cancellation fee will apply.
For cancellations received less than ONE WEEK prior to the course:
         50% cancellation fee will apply. 
For cancellations received within 24 hours of the course:
         100% cancellation fee will apply.

Substitutes are welcome at no additional charge at any time prior to the course.

Postponements:
Requests to postpone course attendance must be received in writing at least three full working days prior to the course commencement. Should we not receive written confirmation within this period; the postponement will be subject to an additional fee of R 1,000 (excl VAT) per delegate.

All course postponements or programme exchanges need to be utilized within 6 months of the original course booking or the course fee will be forfeited.

Cancellations on postponements or exchanges are subject to the full course fee

Absent Delegates:
In the event that a delegate does not arrive for the course and no written cancellation has been received and confirmed, the full course fee will be payable

Presenters:
Should it be necessary, BizTech reserves the right to substitute the presenter.

Communication:
When a person registers on BizTech’s website, is registered on a BizTech course or sends an email to BizTech, that person consents to receiving communications electronically or otherwise by BizTech and/or its business partners

Disclaimer:
BizTech wish to advise that they will not be held responsible for any loss, damage or harm, direct, indirect, consequential or otherwise and howsoever arising that may be caused to any person or property during the providing of any services by BizTech to the client.