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.

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

• 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.

• 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.