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

Intermediate Excel
 

   

course overview

4-5 March 2019

8-9 July 2019

25-26 November 2019


There are so many “hidden” tools in Excel that can make a big difference to your productivity. The key is learning where they are and how they work.

Most of them are actually quite simple as soon as you know they exist. So why not give your skills a boost and in the process up your game. You owe it to yourself to be the best you can be!

BizTech is offering a course on "Intermediate Excel".

 

The course covers the following topics:

Formatting:

  • Changing Row Height and Column Width

  • Changing Cell Alignment

  • Using the Format Painter

  • Using AutoFormat

  • Merging Cells, Rotating Text, and using AutoFit

  • Using AutoFill

  • Working with Groups and Outlines

  • Sharing information across the Microsoft platform

  • Inserting Graphic Elements

Editing in Excel:

  • Sorting and filtering
  • Advanced Filters
  • Using the Paste Special Command
  • Inserting Cell Comments
  • Working with Multiple Worksheets and Workbooks
  • Using Named Ranges in Excel instead of Cell References
  • Sharing & Protecting a Workbook

Using Formulas & Functions in Excel:

  • Creating Simple Formulas
  • Excel Cell References - Relative and Absolute
  • Working with Subtotals
  • Formulas with Several Operators and Cell Ranges
  • Using Excel Functions
  • Applying Conditional Logic
  • Data Validation
  • Data Tables

Charts:

  • Creating different Charts
  • Formatting and Editing Objects in a Chart

PivotTables:

  • Creating a PivotTable
  • Changing a PivotTable's Calculation
  • Selecting What Appears in a PivotTable
  • Updating a PivotTable

Printing Workbooks:

  • Page Margins and Orientation
  • Inserting Page Breaks
  • Creating Headers, Footers, and Page Numbers
  • Adding Print Titles and Gridlines

who should attend

  • Anyone wishing to take their Excel skills to the next level
  • Anyone who works frequently with numbers
  • Finance staff
  • Anyone who needs to process or analyse data
  • Anyone who needs to present graphs or charts

outcomes

After attending this course, you should be able to:

  • Produce more complex reports including calculations
  • Format data to present more professionally
  • Include graphs in reports and presentations
  • Apply complex formulas and functions to data

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

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.