|
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 |
|
|
|
general |
|
COURSE DURATION
The course
will take place over 2
days - 08:30 to 16:30 daily
COURSE FEES
R7 710.00
(excl. VAT) per delegate
(5 % discount for
enrolment 2 weeks prior to course date)
REGISTRATION DEADLINE
Registration Confirmation must be sent prior to the
start of the scheduled course.
|
|
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.
|
