ONE-DAY WORKSHOP

For up to 10 participants at your place of business

Request a Quote or More Information on this Workshop >

WORKSHOP DESCRIPTION

Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Whether you are tracking orders, working with budgets, or analyzing a database – Excel is the powerful and flexible solution your job requires.

This hands-on course will teach you the important functions of this industry-standard software.

Courses offered for Excel 2010, 2013, and 2016.

Other workshops on this topic: Excel – Basic | Excel – Intermediate | Excel Advanced (Spreadsheet Analysis)

Microsoft Excel Training

WHO SHOULD ATTEND:

  • Experienced Excel users who work with large data sets

YOU WILL LEARN:

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form
  • Use VLOOKUP and HLOOKUP to aggregate data from multiple tables
  • 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 subtotalled lists
  • Use various database functions to summarize data
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers
  • Import external data from a variety of sources into Excel

COURSE OUTLINE

Maintaining Data

  • Understanding data list and Excel table concepts
  • Using data forms
  • Using lookup tables

Sorting Lists

  • Sorting concepts
  • Sorting lists
  • Performing custom sort orders

Filtering Lists

  • Reviewing filtering concepts
  • Using AutoFilter
  • Using Advanced Filter
  • Working with Filtered Data

Summarizing Data

  • Setting automatic subtotals
  • Working with Subtotalled Lists
  • Using Functions to Summarize Data

Working With PivotTables

  • Reviewing PivotTable Concepts
  • Creating PivotTables
  • Modifying PivotTable Layouts
  • Working with PivotTables
  • Using PivotCharts and Slicers

Working With External Data

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

Summary and Evaluations

METHODOLOGY

  • Live, instructor-led training with hands-on exercises

Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.

Request a Quote / More Information

< Back to all Microsoft Office Courses

Course Code: MOB703

-MB-1