Microsoft Excel Level 3 – Data List Management

    January 16, 2019 @ 9:00 am – 4:00 pm
    Water Tower Inn
    360 Great Northern Rd
    Sault Ste. Marie, ON P6B 4Z7
    Angelo Pacione, ICT Sector Lead
     705-942-7927 ext. 3148

    Microsoft Excel Level 3 – Data List Management

    Join us for this hands-on workshop that will expand your Microsoft Excel spreadsheet skills within the area of Data List Management. Our expert trainer from BDO Canada – Sault Ste Marie will be your guide through this full day workshop where you will learn many ways to work with your spreadsheet data such as: sorting, lookups, summarizing, filtering, Pivot Tables, importing from external sources.

    This workshop is intended for those who are already comfortable with Microsoft Excel. You should have working knowledge or equivalent experience in the concepts as taught in the BDO Excel Level Two course.

    A laptop is necessary with at minimum Microsoft Excel 2010 installed (Excel 2016 will be used by the trainer). Please read on for more details.

    “Microsoft Excel Level 3 – Data List Management” –

    presented by BDO Canada – Sault Ste. Marie
    Wednesday, January 16 from 9:00 AM – 4:00 PM  – doors open at 8:30 AM.
    includes complimentary lunch
    In this workshop you will learn how to:

    Organize columns and rows to accommodate information and edit the contents of cells
    create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data
    Sort records in a data list using a variety of methods
    Filter data in a list using a variety of methods, as well as work with filtered data
    Create and work with subtotaled lists, as well as use various database functions to summarize data
    Create, modify, and work with PivotTables and PivotCharts
    Import external data from a variety of sources into Excel

    Course Outline

    Maintaining Data Lists: Data List & Excel Table Concepts, Using Data Forms, Using Lookup Tables
    Sorting Lists: Sorting Concepts, Sorting Lists, Custom Sort Orders
    Filtering Lists: Filtering Concepts, Using AutoFilter, Using Advanced Filter, Working with Filtered Data
    Summarizing Data: Automatic Subtotals, Working with Subtotalled Lists, Using Functions to Summarize Data
    Pivot Tables: PivotTable Concepts, Creating PivotTables, Modifying PivotTable Layouts, Working with PivotTables & PivotCharts
    External Data: External Data Concepts, Importing Query Data from Access, Importing Query Data from Text Files

    Things you will need:

    Required: A laptop with Microsoft Excel installed (at minimum Excel 2010; Excel 2016 will be used by the trainer). WIFI access will be provided. Please remember your power cords and bring a mouse if you prefer.

    About Our Trainer: Deborah Spina

    Deborah is Lead Trainer and a Consultant with the Advisory Services area of the Sault Ste. Marie office of BDO. She has over 25 years of experience in the information technology industry from delivery of technology training and end-user troubleshooting to technical writing and solutions application. Her area of expertise is training and consulting with the Microsoft Office Suite of applications. Her knowledge extends not only to Microsoft Word, Excel, Outlook, PowerPoint & Access, but as well to Microsoft Project, Visio and Publisher. She has been providing and delivering training and consulting services to businesses and organizations in the Sault Ste. Marie and surrounding area since 1994.

    Please note that this session is limited to 12 attendees.

    For more information contact Angelo Pacione, ICT Sector Lead

     705-942-7927 ext. 3148 or
    Proudly Supported by:
    Maintaining Data Lists: Data List & Excel Table Concepts, Using Data Forms, Using Lookup Tables


    Please enter your comment!
    Please enter your name here