Virtual Training Course
Basic Excel 2016 Essentials - VT
>> Click here to book this training as an In-House course <<
This Course is not part of the MUS Subscriber discount structure.
Price: | R1403.00 (VAT Incl.) Per Person |
Presenter: | Mr Tristan White |
Date: | 1 Feb '19 |
Times: | Registration:08H00 Start:08H30 End:16H00 |
Duration: | 1 Day |
CPD Hours: | Attendance at this seminar will secure 6.5 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc) |
Platform: | Web Based (Online) |
Course Facilitator: |
Nerissa Singh
T: 011-886-1395 E: nerissa@probetatraining.co.za |
Back Book Now |
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 practical one-day course for users with no or limited experience to be able to hit the ground running with Microsoft Excel.
As an accountant as well as auditor, it is essential to have a firm foundation in Microsoft Excel - let ProBeta Training help your trainees.
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
Module 1:
Getting Started - Spreadsheet terminology, navigating the worksheet, using templates.
Module 2:
Creating a worksheet: Quickly populate information, edit data, saving and updating workbooks.
Text and number formatting, conditional formatting, additional formatting options.
Module 3:
Modifying a worksheet: Viewing Excel data, moving and copying of data and formulas, inserting and deleting rows and columns, absolute and relative references
Module 4:
Building formulas: Entering and editing formulas, using functions, other common functions
Module 5:
Using quick analysis, sorting and filtering data
Module 6:
Formatting data alignment, colours and borders, merging, wrapping, styles, themes and effects
Module 7:
Charts: Chart basics, formatting charts (in introduction)
Module 8:
Printing and sharing your workbook preparing to print, page setup options, printing worksheets
Additional Modules:
(More challenging case studies - an introduction to the Intermediate Course):
o Working with text and data
o CountIF formula
o VLookUP
o Pivot Table
o IF Function
o Creating a chart
o Financial functions: PMT, IPMT, NPV, IRR, FV and PV
Additional useful tips:
Short cut keys
• 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.
Delegates must have the following available on the course day:
o Own computers (PC or laptop) with Excel loaded onto the machine (Preferably Excel 2016)
o Proper internet connection (Wi-Fi or 3G) with sufficient data for the day
o USB headset with microphone and speaker Webcam (external or built-in)
For the engagement activities and tools, other devices such as the iPad or iPhone are not recommended.
Please ensure that you are logged in 15 minutes prior to the start of the session.
Delegates should be familiar with using personal computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on his / her own computer.