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

Practical MS Office 2010 & 2013 Skills


course overview


16-18 March 2020

3-5 August 2020 

MS Office is probably the single most important computer application in the workplace. Word, Excel, PowerPoint and Outlook are essential tools to anyone working in a business environment. Not only does the MS Office package enable you to professionally and clearly communicate information, it also allows you to create correspondence, spreadsheets and reports for business presentations and external and internal correspondence. If you want to save time, enhance your MS Office skills and move from creating standard business documents to creating outstanding documents that will impress both your manager and the rest of your team, then BizTech’s course on “Practical MS Office 2010 & 2013 Skills” is for you. The course covers the following key topics:



  • Working with Formulas & Functions

  • Creating and using Templates

  • All the Shortcuts to save you time

  • Creating Effective Charts (Bar Charts, Line, Pie, etc)

  • Linking and Embedding Charts and inserting into other office documents

  • Working with Databases - Data manipulation, Auto Filtering and Advanced Filters

  • Using Scenarios - Allowing for “what if” scenarios

  • Pivot Tables - Using Pivot Tables to show information with a different focus

  • Labelling, Colouring and Formatting for clarity of display


  • Creating master Templates - Design Title and Content Slides

  • Create Custom Animation and Transition Slides

  • Creating Charts, Linking and Embedding from Excel

  • Working with Tables, Graphics and Charts

  • Using built in Diagrams and Organograms


  • Headings and Styles to enable Auto Formatting

  • Using Section Breaks for different Formatting Styles

  • Automatic Inclusion of Tables of Content

  • Complex Reports and Contracts

  • Time Sheets, Calendars & Schedules

  • Forms, Newsletters, Invitations, Brochures & Adverts

  • Letterheads and Fax Cover Pages

  • Mail Merge, Auto Text & Auto correct

  • Including Graphics such as Charts, Pictures and Diagrams

  • Using Watermarks for Drafts or Confidentiality

  • Managing complex Tables and Table Data


  • Flag and Categorise e-mails

  • Using signatures and stationery

  • Creating, updating and tracking tasks

  • Use the notes function effectively

  • Arranging messages and applying rules

  • Creating a message in HTML mail format and inserting a hyperlink

who should attend

  • Anyone wanting to increase their productivity

  • Anyone aiming to outperform their peers and co workers

  • Executive Assistants and Secretaries

  • Personal Assistants and Office Administrators

  • Anyone else who wishes to learn MS Office 2007 & 2010 features


After attending this course attendees should be able to:

  • Format Excel, Word, PowerPoint and Outlook with ease and speed

  • Apply complex functions to make documents more professional and easier to work with

  • Produce professional documents your organisation can be proud to send out

  • Select the most appropriate MS Office application for each project

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 3 days - 08:30 to 16:30 daily



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.

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.