Home · Course Details

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.

  • 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

  • Use Sort and Filter tools
  • Use Subtotals
  • Remove duplicates
  • Clean up imported data

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

No pre/post work required

Name Date Time Location Cost
Virtual Class - Excel: Sorting and Filtering Lists and Databases 3 April 2019 12:00 pm - 01:30 pm Online $99
Virtual Class - Excel: Sorting and Filtering Lists and Databases 18 June 2019 09:30 am - 11:00 am 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.