Microsoft Power BI

    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