Excel Intermediate 2: Queries, Subtotals & Tables

In this three-hour session, you will import external data, create simple queries to bring in data from SQL sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting and totals and use AutoFilter to show only rows that meet your criteria.

Prerequisites

This class is suited for people who have taken Excel levels 1 and 2 or been using Excel (any version) for a year or more and want to learn Excel's powerful tools for managing and summarizing long lists of data.

Outline

Writing Queries to Import Data

• importing data from text files
• writing queries to import data

Summarizing Data with Subtotals

• sorting tables by one or many fields
• generating sub- and grand totals
• outlining to show only sub- and grand totals
• creating multi-level subtotals

Using Data in Tables

• importing data from text files
• converting data into a table
• applying tables styles and totals row
• using AutoFilter to find records
• creating custom AutoFilter criteria