Receive regular training updates

A Winning Team: You & Your Manager

B-BBEE - The New Codes of Practice

B-BBEE Fronting

Becoming the Best Accounts Administrator

Becoming the Best Team Secretary / Administrator

Becoming the Best Customer Service Professional

Becoming the Most Successful Salesperson

Business Ethics for PAs and Administrators

Business Writing: The Unwritten Rules

Create and Deliver Dynamic Business Presentations

Contact Centre / Call Centre Service Excellence

Effective Stock Control

Emotional Intelligence

Excel Dashboards

Finance for PAs and Administrators

Graphs, Statistics and Numerical Reporting for PAs and Administrators

Great Organisational Skills: Organise Yourself to Success!

Intermediate Excel

Innovation & Creative Thinking in the Workplace

Key Elements of Successful Newsletters

Let's Talk Business: Verbal Communication for the Business World

Macros and VBA for Excel: Unleash the Power in your PC

Management Skills for Supervisors

Managing Generation Y

Managing your Image and Business Etiquette

Managing Your Personal Finance

Mastering Minutes and Meeting Protocol

Mastering Time and Self Management: Become a High Achiever

Masterminding the Perfect Business Function or Event

Mastering Confidence, Influence and Assertiveness Skills

Practical Project Management for PAs and Administrators

Practical MS Office 2010 & 2013 Skills

Practical Skills for Office Managers/Team Leaders

Professional Problem Solving Techniques: Overcome any Workplace Challenge

Professional Switchboard, Reception and Frontline Skills

Sexual Harassment: Righting the Wrongs

Successful Importing and Exporting

Social Intelligence

Stand-Out Presentation Preparation Skills for PAs

Technical Report Writing

The Complete PA: Step up and Stand out!

The National Credit Act

The Protection of Personal Information in Business and Government

The Relationship Edge: Creating High-Trust Client Relationships

The Secrets of Debt Collection Success

The Stand Out PA

The Total Team Leader

Time Management: Beat Work Overload and Achieve More!

Train the Trainer: How to Bring Training to Life

Trouble-free Travel Planning for PAs

MS Project for Effective Project Management

Word that Works: Create Professional Business Documents and Templates

Winning Ways: Persuade, Influence and Negotiate

Excel Dashboards


course overview

9-10 March 2020

20-21 July 2020

26-27 October 2020

WOW your customers, team and/or superiors with a Dashboard that will leave a lasting impression! Excel Dashboards keep track of all your key business metrics on a single page! Whether you’re tracking financials, KPI’s, staff performance, customer service, project management or sales, you can now create a fully interactive and dynamic presentation in a few effortless steps!

The course will cover the following topics:

  • Make an appealing dashboard - all in a page

  • Displaying key trends and comparisons graphically

  • Create dashboards that operate interactively with the user

  • Dashboard automation

  • Dashboard design and display principles

  • Dynamic Dashboard Viewing

  • Using sparklines in dashboards

  • Protecting your Dashboard

  • Dashboards Tips and Tricks

  • Refresh of Excel features commonly used in dashboards:

  • Data Formatting, sorting & filtering

  • Graphs and Tables

  • Formulas, Logic & Functions

  • Macros & Pivot Tables

who should attend

  • Managers that need to produce status reports or monitor performance (e.g.sales/ marketing)

  • Financial managers and professionals

  • Personal assistants involved in reporting

  • Professionals involved in reporting or data review

  • Professionals who are already proficient at an intermediate Excel level and would like to supercharge their capability


After attending this course, you should be able to:

  • Understand Excel dashboards and how they can help you in the workplace

  • Learn how to show a lot of important information in a single page

  • "Wow!" your colleagues and managers with your reports

  • Understand how to automate tasks for efficiency

take home tools

  • Training Manual & Electronic copy of study material

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



  • Dynamic and knowledgeable facilitators

  • Training File and a USB

  • Certificate of Attendance

  • Quality folder, notepad and pen

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

Registration confirmation must be sent prior to the start of the scheduled course.

the venue

Unless otherwise stated, 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 4 compliant. This means that we are a 100% 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 100% of the spend made.