E-Updates
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

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

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

   

course overview

Available as in-house course only

Please contact us on

011 582 3333, or email training@biztech.co.za

Using Macros and VBA in Excel can help you dramatically improve the usability and efficiency of your spreadsheets.

While formulas and functions are great tools, macros takes things to a whole new level particularly for repetitive tasks and regular reports. Learn how you can transform your excel spreadsheets by attending our course called “Macros and VBA for Excel: Unleash the power in your PC”.

 

Course topics include:

 

  • Automating tasks that you perform frequently such as:

    • Formatting

    • Reporting

    • Data extraction from multiple sheets

  • Creating buttons and customising toolbars

  • Using the Excel Macro recorder

  • Understanding the limitations of the macro recorder

  • Editing, debugging and running Macros

  • Understanding VBA

  • Understanding the Visual Basic editor

  • Create a macro by using VBA

  • Learn about Macro security

  • Utilise multiple Worksheets with ease

  • Create user defined Functions

  • VBA Programming Concepts including Projects, Modules, Objects and Methods

  • Using debugging tools on recorded code

who should attend

  • Finance Personnel and Managers

  • Data administrators, professionals and managers

  • Project managers and engineers

  • Analysts

  • Anyone working extensively with Microsoft Excel

  • Attendees should have a reasonable working knowledge of MS Excel

outcomes

After attending this course attendees should:

  • Learn how to automate tasks in Excel

  • Understand the difference between macro recording and VBA and when to use which

  • Understand how to do simple VBA programming

  • Dramatically improve efficiencies in the office relating to Excel

  • Apply your knowledge of Macros to other MS Office Products such as Word and PowerPoint

 

take home tools

  • Training Manual & Electronic copy of study material

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

general


PROVISION OF THE COURSE BY BIZTECH INCLUDES

  • Dynamic and knowledgeable facilitators

  • Training File and a USB

  • Certificate of Attendance

  • Quality folder, notepad and pen

COURSE DURATION

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

 

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 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.