Home ·
Learn how to turn raw data into useful business information to help you make more informed decisions. Work with built-in, easy to use database and list management tools in Excel to analyse large sets of business data quickly and efficiently.
Snapshot
- Duration: 90 minutes
- Category: Excel
- Platform: Adobe Connect
- Level: Beginner
- Pre-requisites: Basic familiarity with Windows applications
- Version: Suitable for 2010, 2013, 2016 and Office 365
Learning Outcomes
- Use Sort and Filter tools
- Use Subtotals
- Remove duplicates
- Clean up imported data
Course Outline
Topics covered include:
- Introduction to Database Tables
- Rules for databases
- Sorting data
- Sorting by multiple columns
- Filtering a list
- Automatic Subtotals
- Importing data
- Cleaning up imported data
- Parsing data into columns
- Removing duplicates
Resources & Precourse Work
No pre/post work required
| Name | Date | Time | Location | Cost (inc GST) | |
| Virtual Class - Excel: Sorting and Filtering Lists and Databases | 18 June 2019 | 09:30 am - 11:00 am | Online | $99 | |
| Virtual Class - Excel: Sorting and Filtering Lists and Databases | 27 August 2019 | 12:00 pm - 01:30 pm | Online | $99 | |
| Virtual Class - Excel: Sorting and Filtering Lists and Databases | 23 October 2019 | 12:00 pm - 01:30 pm | Online | $99 | |
| Virtual Class - Excel: Sorting and Filtering Lists and Databases | 3 December 2019 | 02:30 pm - 04:00 pm | Online | $99 |
Not quite the content you’re looking for?
Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.