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.