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? Join us for session 3 of the Excel training Series Online Course.
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 training 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 with 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.
Find and replace
Searching within filter
Searching within sheet
Basic Data Extraction
Excel is a program within the Microsoft Office Suite. It contains a spreadsheet that can automatically input, calculate and analyze data, which makes it a valuable skill for the workplace. Employees can use Excel to accomplish an abundance of daily tasks.
Advanced knowledge of Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks. The way Excel is used depends on the needs and duties of specific departments or job roles.