Available Course

Excel Beginners and Advanced

>> Click here to book this training as an In-House course <<

Duration: 1/2 Day
CPD Hours: Attendance at this seminar will secure 4.5 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
Course Facilitator: Yvonne Rossouw
T:  011-886-1395
E:  nerissa@probetatraining.co.za
Back

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. Microsoft Excel is the foremost spreadsheet application used in any and every department within an organisation, be it in audit, accounting, taxation or financial management. As an accounting professional as well as auditor, it is essential to seek new ways of maximising the functionality of Microsoft Excel to be in the best position to make informed financial decisions 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.

Excel Beginners and Advanced

Excel Beginners and Advanced Basic Basic:  Excel Terminology, layout and interface  Creating and editing a Spreadsheet  Moving around in large worksheets by using the hotkeys  Working with Data  Formatting data  Copy and paste  Sorting a database  Filtering of data  Searching for data Date and time functions  Flash fill  Basic Formulas o Cell referencing within formulae o Mathematical operators within Excel o SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV Advanced Advanced formulas: o Using the IF/AND functions o The COUNTIF and SUMIF function o VLOOKUP and HLOOKUP function  Create unique lists  Advanced filtering  Text-to-Columns  Create a pivot table  Charts