Microsoft Excel Level III – DLM

(versions: 2003, 2007, 2010, 2016 and 2019)*

Location: Online Format (Zoom, WebEx, Google Meet)

General Overview:

Excel has many features that can be used to quickly analyze large amounts of information.  This course will introduce you to data forms and the use of various database functions to easily summarize data as well as working with Pivot Table, Pivot Charts, Slicers as well as importing and exporting data.

Learning Objectives:

The course will assist users in combing, analyzing and displaying data quickly and efficiently in seconds not minutes or hours. Users will also learn to import and export data from Access, Web Pages and Text Files.

You will Learn:

• Tables
• Data Lists
• Data Forms
• Lookup Tables (Vlookup)
• Sorting Lists
• Filtering Lists (Advanced Filter)
• Summarize Data
• Subtotal
• Database Functions
• Pivot Tables
• Pivot Charts
• Slicers
• External Data

Target Student:

This course is for individuals who are familiar with Excel who wish to expand their knowledge to work with advanced data analysis and time saving tools.

Course Outline:

Section 1: Maintaining Data

• Data list and Excel Table Concepts
• Using Data Forms
• Using Lookup Tables

Section 2: Sorting Lists

• Sorting Concepts
• Sorting Lists
• Custom Sort Orders

Section 3: Filtering Lists

• Filtering Concepts
• Using Auto Filter
• Using the Advanced Filter
• Working with Filtered Data 

Section 4: Summarizing Data 

• Automatic Subtotals
• Working with Subtotaled Lists
• Using Functions to Summarize Data

Section 5: Working with Pivot Tables

• Pivot Table Concepts
• Creating Pivot Tables
• Modifying Pivot Table Layouts
• Working with Pivot Tables
• Pivot Charts
• Slicers

Section 6: Working with External Data

• External Data Concepts
• Importing Query Data from Access
• Importing Query Data from Web Pages
• Importing Query Data from Text Files

*All Classes are instructor led.
Class recording will be made available after the class.