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
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