Enhance your career:

This video will explain how you can achieve that, Click here to watch

Microsoft

Individuals: R 598.00 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: David Ringstrom


Overview:

If you are brand new to spreadsheets or haven't used a spreadsheet in years, this session is designed for you. United States-based Excel expert and certified public accountant David Ringstrom will take you through spreadsheets from the ground up. By the end of this two-hour session, you be empowered to create functional spreadsheets and manipulate lists of data. David's courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. His detailed hand outs serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session. David's materials cover Excel 2016, 2013, 2010, and 2007.


Course Content:

Bring Excel green error-checking prompts under control by managing the underlying rules. Eliminate duplicates from a list with just a few mouse clicks. Get a jump start on spread sheet projects by using free, prebuilt templates in Excel. Get an overview of the different types of files you can create in Excel. Get oriented with Excel's grid of rows and columns. Jump-start data visualization with the Quick Analysis feature. Learn the nuances of copying formulas within Excel spread sheets. Manage column widths within your spread sheets. Master Excels order of operations for mathematical formulas. Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts. Never type $ signs manually in a formula again; use a keyboard shortcut instead. Simplify repetitive tasks by creating your own keyboard shortcuts. Understand how to enter dates in an Excel spread sheet. Wrangle long lists of data by filtering instead of sorting.


Course Objective:

Identify how to skip confusing menus by way of time-saving mouse tricks and keyboard shortcuts. - Define the structural basics of Excel worksheets and workbooks. - Apply some basic data-analysis techniques.


Who Should Attend?

Practitioners who need a basic explanation of what Excel is really all about.

Individuals: R 598.00 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

Are you new to Excel? Have you just joined the work force? Is there a new recruit who will need to use Excel to fulfil daily work duties? If you ve answered yes to any other above questions, then join us for a two-hour webinar where we introduce you to Microsoft Excel.


Course Content:

Introduction: o Terminology o Layout and interface o Move or copy sheets o Status Bar o Print Preview and set print area Completing / Filling in a Spreadsheet Working with Data: o Formatting data (changing appearance, font, size, colour and upper-case / lowercase) and Format Painter o Inserting Line Breaks o Various ways to Paste data Recovering Lost Documents: Auto-save function. Built in Templates: Exploring pre-created templates eg. budgets, expense tracker, invoices Creating and Editing a Spreadsheet: o Insert, delete and adjust rows and columns o Executing sum formula o How to do spell-checks � Navigating Seamlessly: o Freeze panes o How to navigate without a mouse o How to search for text o Quick access toolbar


Course Objective:

Enabling delegates to: o Open and create Excel workbook files o Use the 2016 interface o Format worksheets and data o Become comfortable with Excels interface


Who Should Attend?

Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 598.00 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

Are you new to Excel? Have you just joined the work force? Is there a new recruit who will need to use Excel to fulfil daily work duties? If youve answered yes to any other above questions, then join us for a two-hour webinar where we introduce you to Microsoft Excel.


Course Content:

Introduction: o Terminology o Layout and interface o Move or copy sheets o Status Bar o Print Preview and set print area o Formatting data (changing appearance) and Format Painter o Various ways to Paste data o How Windows Regional Settings may affect your Excel. � Recovering Lost Documents: Auto-save function. � Built in Templates: Exploring pre-created templates eg. budgets, expense tracker, invoices Navigating Seamlessly: o Freeze panes o Quick access toolbar o How to navigate without a mouse o Line breaks.


Course Objective:

Enabling delegates to: o Open and create Excel workbook files o Use the 2016 interface o Format worksheets and data o Become comfortable with Excel�s interface


Who Should Attend?

Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 517.50 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

Excel has powerful formula functionality. The goal of formulae is to automate process that would require manual execution. Formulae are used to save you time and give you the edge when completing daily tasks. Join us as explore basic formulae and attempt to increase your efficiency with helpful formulae that you will need daily in an office space.


Course Content:

� Building Formulae: o Exploring available library of formulae within Excel o Cell referencing within formulae ie relative and absolute references o Mathematical operators within Excel o Duplicating (dragging) formulae without retyping o Reviewing formulae o Flash fill (Excel 2013 and later only) � Financial formulae: SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV


Course Objective:

Enabling delegates to: o Become comfortable with formulae that are typically used to increase efficiency in a finance space


Who Should Attend?

� Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. � Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. � Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 517.50 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulae, filtering functionality, data searching and extraction tools.


Course Content:

Data Editing: o Sorting o Filtering o Conditional formatting o Data validation o Subtotal formula o Find and replace Data Searching: o Searching within filter o Searching within sheet o VLookUps o CountIf formula o If statements. Data Extraction (basic): o Flash fill o Text-to-Columns o Concatenate.


Course Objective:

Enabling delegates to: o Become comfortable with working with populated Excel sheets and sifting through copious amounts of data o Turning data into logical information o Performing search queries and only returning desired information


Who Should Attend?

Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 517.50 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

Sometimes it is easier to understand something when it is represented in pictures or some other visual medium. This also helps when making decisions, analysing trends and reviewing results. Excel is bursting at its seams with all kinds of techniques to visually represent data in a way that is organised and easier to digest. Numbers can be a bit overwhelming sometimes, so join us as we explore various ways numbers / data can be organised and simplified by converting them into graphs, tables and other visual reports to help with decisions.


Course Content:

Tables / Graphs: o Quick analysis o Pivot tables o Charts


Course Objective:

Enabling delegates to: o Become comfortable with using visual aids within Excel o Turn copious amounts of data into a visual expression, so as to perform better decision making


Who Should Attend?

Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 598.00 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

If you or your firm use Excel for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently? ProBeta Training has designed a course for those individuals and offices that are heavily reliant on Microsoft Excel as part of their day-to-day work duties, be it in audit, accounting or office administration. The goal of this course is to - Freshen up your Basic Excel knowledge, - Improve your efficiency and - Show you alternative ways to get the same things done. This session focuses on the value-add elements like VLookUps, Pivot Tables, Concatenating text, and Financial formulae, amongst others -- for those with an already established basic-level of Excel knowledge.


Course Content:

Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula. Data Searching: VLookUps / CountIf formula / If statements / Search and Replace text. Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate. Building Formulae: Cell referencing within formulae i.e. relative and absolute references. Financial Functions: PMT, RATE, IPMT, NPV, FV and PV Tables / Graphs: Pivot tables.


Course Objective:

Enabling delegates to: o Enter and edit data in a variety of ways o Understand complexities of formula referencing o Introduction to intermediate functionality including Pivot Tables, VLookUps and Financial formulae


Who Should Attend?

Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 437.00 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

The goal of the course is to freshen up your Basic Excel knowledge, improve your efficiency, show you alternative ways to get the same things done. This is largely based on ProBeta Basic Excel training course, which we have reduced into a two-hour session, however we havee removed the very basic elements and are only focusing on the value-add elements for those with an already established basic-level of Excel knowledge. Microsoft Excel is the foremost spreadsheet application used in any and every department within an organisation, be it in audit, accounting, taxation, financial management, human resources, information technology or even reception work and other administrative tasks. Many secondary applications interface with Microsoft Excel and so a working knowledge of Microsoft Excel will streamline many tasks relating to data editing, data filtering / sorting, data searching and data presentation - which will empower decision making. ProBeta Training has designed a NEW practical 2-hour refresher course for users with some basic experience, who are then able to hit the ground running with Microsoft Excel. As an accountant, auditor, receptionist, analyst or anyone required to work on Excel, it is essential to have a firm foundation in terms of Microsoft Excel therefore, let ProBeta Training help you.


Course Content:

Enabling delegates to: o Open and create Excel workbook files o Use the 2016 interface o Enter and edit data in a variety of ways o Understand basic formulas and functions o Use the Quick Analysis features new to the 2016 version o Format worksheets and data o Print and share workbooks o Introduction to intermediate functionality including Pivot Tables, VLookUps and Financial formulae


Course Objective:

Recovering Lost Documents: Auto-save function. Built in Templates: Budgets / expense tracker / invoices. Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / Print Preview / Format Painter / various ways to Paste data / How Windows Regional Settings may affect your Excel. Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks. Data Editing: Sorting / filtering / conditional formatting / data validation / Subtotal formula. Data Searching: VLookUps / CountIf formula / If statements. Data Extraction (basic): Flash fill / Text-to-Columns / Concatenate. Building Formulae: Available library of formulae within Excel / Cell referencing within formula ie relative and absolute references F4-key Mathematical operators within Excel / Reviewing formula with F2-key and CTRL+~ / Spell-check with F7-key. Financial Functions: PMT, IPMT, NPV, FV and PV Tables / Graphs: Quick analysis / charts / pivot tables. Printing: Set print area.


Who Should Attend?

Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. Delegates that prepare reports and need to be able to edit text and numbers.

Individuals: R 598.00 (Incl. VAT)

CPD Hours: 2 hrs

Presenter: Tristan White


Overview:

If you or your firm use Word for multiple hours each day, imagine what the wasteful labour cost must be from using it inefficiently? ProBeta Training has designed a course for those individuals and offices that are heavily reliant on Microsoft Word as part of their day-to-day work duties, be it in audit, accounting or office administration. The goal of this course is to Establish a sound, practical Microsoft Word foundation


Course Content:

Creating a Document: Converting PDF to Word, Saving in other Formats Formatting a Document: Insert Headers and Footers, Insert Page Numbers, Format Painter, Setting default font for all Word Documents Editing Text and Formatting Paragraphs: Adding Special Characters, Search and Replace Text, Line and Paragraph Spacing, Indents Breaking Up Text: Page and Section Breaks, Adding Columns Bullets and Numbering Inserting Tables Views: Split Views Graphics: Inserting and Wrapping Text SmartArt and Textboxes


Course Objective:


Who Should Attend?

Financial managers Auditors Bookkeepers Financial accountants Audit managers Audit partners Business professionals Non-finance staff

Individuals: R 437.00 (Incl. VAT)

CPD Hours: 1.5 hrs

Presenter: Gillian Peach- Stander


Overview:

Participants will gain a fundamental understanding of the Microsoft Word environment and the ability to complete tasks independently. They will demonstrate the correct application of the principle features of Word 2016 by creating and editing documents for a variety of purposes and situations. Document examples include professional looking reports, multi-column newsletters, resumes, and business correspondence.


Course Content:

Opening and closing MS Word and MS Word files Understanding the interface, including the ribbon, the status bar and the backstage view Creating and saving documents Inserting and work with text, symbols and numbers Performing basic editing tasks Formatting fonts, including type, size, colour, enhancements and case Formatting paragraphs, including spacing, alignment, indents, tabs, bullets and numbering Using more advanced formatting, including the font and paragraph dialogue boxes Using Styles and Themes Formatting the page Previewing, printing, sharing or emailing documents.


Course Objective:


Who Should Attend?

Anyone who may benefit from learning from using Microsoft Word more effectively and efficiently.

Make Booking Instructions

Please click here for a video instruction on how to register Click Here.

Online Courses

The ProBeta Online Learner Management System specialises in delivering high-quality cost-effective online video training that includes a wide range of Accounting, Auditing and Tax topics.

The ProBeta Online Learner Management System is particularly suited for those candidates who cannot spare regular time in a classroom workshop. You can listen to our recorded webinars and learning sessions whenever you want, wherever you want. There is no time limit, you can move at your own pace.

If you're not sure what you want to register for, it might be a good idea to browse our course categories or subjects to determine where your interests lie. All that you have to do once you've found a session that you are interested in, is to register for the specific on-line session by clicking on Make Booking and select the "Online Booking" and follow the steps provided on the screen.

At the end of each lesson, we provide multiple choice and interactive tests in order for you to assess the knowledge you have obtained as you progress.

Your success is our priority!

For any enquiries please contact us at info@probetatraining.co.za or 011 886 1395.