NEED TO UNDERSTAND EXCEL?

Are you new to Excel or have very little or no knowledge of how to even begin? Do your staff struggle with spreadsheets, formulas and sorting data? Then join us for these 4 two-hour webinars where we introduce delegates to Microsoft Excel.

SESSION 3 - DATA FILTERING, SORTING, SEARCHING EDITING AND EXTRACTION

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 formulas, filtering functionality, data searching and extraction tools.

The objective of SESSION 3 is to enable delegates to become comfortable working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information.

Content Discussed:

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

MS YVONNE ROSSOUW | B.Com Honours(SA), CA (SA)

Yvonne Rossouw is a CA(SA) with a passion for doing the right thing. With ten years of experience in the auditing and accounting profession, Yvonne applies the knowledge she has obtained towards uplifting and training others. Yvonne started her professional career as an academic clerk at the University of Pretoria, where she was an assistant lecturer to the CTA students. This is where she developed her enthusiasm for teaching and developing others. She completed her articles at BDO South Africa Inc and pursued her dream of training those in the auditing and accounting profession. Yvonne joined ProBeta team in 2015 as a public speaker and consultant, facilitating auditing and legislative courses to a range of different audiences. When she is not presenting, Yvonne consults clients on auditing and accounting matters, as well as compliance with legislation such as FICA and POPI. Yvonne also volunteers on various committees and working groups within IRBA and SAICA to provide input and guidance in the development of the auditing and accounting profession.

Please note that this link is unique to you. Transferring this link to another user is an infringement of copyright. If you have subscribed to a course, the cost is per delegate, not per screen.