Laptop Screen and Graduation Mortarboard Hat icon image

    Excel Topic 2: Working with Data Lists and Databases

    Course Duration: 90 Minutes

    Target Audience:

    This session will explain the concept of Databases within Excel. It will ensure the participant is comfortable managing and analysing large blocks of data.

    Course Objectives:

    This session will cover how to handle lists of data, clean up the data, sort and filter the data, use the sub-totals feature. Other features covered will include Text to columns, Data validation and Grouping / Ungrouping.

    Course Outline:

    Introduction and Overview

    Cleaning up Data (e.g. Imported Data)

    Sorting Data Using Values, Icons, Colour

    Using Auto-Filter and Advanced Filter

    Splitting Data in Columns

    Joining Data from Multiple Columns

    Using the Sub-Total Feature

    Using the Sub-Total Function

    Controlling Input into Cells Using Data Validation

    Grouping and Ungrouping Data

    Protecting Workbooks, Worksheets, and Cells

    Discussion and Question Time

    View Schedule
    Contact Us

    Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.