Available Course

Basic Excel Session 3 - Data Filtering / Sorting / Searching / Editing / Extraction

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

Duration: 2 hours
CPD Hours: Attendance at this seminar will secure 2 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)
Course Facilitator: Tristan White
T:  0118861395
E:  gillian@probetatraining.co.za

Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulae, filtering functionality, data searching and extraction tools.

Enabling delegates to: o Become comfortable with working with populated Excel sheets and sifting through copious amounts of data o Turning data into logical information o Performing search queries and only returning desired information

• Data Editing: o Sorting o Filtering o Conditional formatting o Data validation o Subtotal formula o Find and replace • Data Searching: o Searching within filter o Searching within sheet o VLookUps o CountIf formula o If statements. • Data Extraction (basic): o Flash fill o Text-to-Columns o Concatenate.

• 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 any version of Microsoft 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) 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.