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
