BACKGROUND INFORMATIONSome people fear Excel, however in today’s busy and fast-pacing world having knowledge of this tool saves you time, money and heartache. It’s an application that works with logical inputs, so whatever does not make sense will not give you back anything – garbage in, garbage out.This course includes will give you knowledge that you would need within an Accounting function or department. Accounting professionals need Excel on a daily basis to produce reports, prepare financial statements including cashflows and registers, make reconciliations, organise data whilst also getting rid of the authentic calculator.OBJECTIVES OF THIS SESSIONSession one will delve into the fundamentals of Excel and session two will build on that to explain basic formulae professionals can use, whilst also explaining keyboard shortcuts that will give the user more confidence in using this powerful tool. It’s a practical workshop were attendees are requested to bring their laptops with Windows (ideally with the latest Excel version installed to be able to follow all functions; some techniques might not work on mac). The attendees will be given an excel workbook with examples to use during the session.After the session the attendee will be able to understand Excel better and master techniques that will make using Excel a piece of cake.TOPICS ON THE AGENDA- Fundamentals of Excel- Choosing the keyboard over the mouse (for Microsoft Windows keyboard users only)- Important formulae for the Accountant (including concatenate, date and time, splitting content in cells, difference between sum and subtotals, conditional formatting, data validation, pivot tables, vlookup