Microsoft® Excel: Data Lists and Tables with Pivot Tables

Click Here For More Information

Loading Courses

December 2020

Microsoft® Excel: Data Lists and Tables with Pivot Tables (1:00pm – 5:00pm) Virtual Live

December 14 @ 1:00 pm - 5:00 pm
$199

https://knowledgesourceinc.com/course/microsoft-excel-data-lists-and-tables-with-pivot-tables/

Find out more »
+ Export Events

This course will expose the user to the use of data lists and tables where both simple and complex sorting is involved. They will also work with a variety of filters and experience how to create subtotals on their data. In addition, the user will create table field formulas and use spreadsheet formulas that feature table fields. The creation of effective Pivot Tables off of data will also be featured along with a variety of filters and slicers. There will also be an exploration of the Database Function category where criteria can be used to create aggregate functions on list and table data.

Objective: Upon completion of this course the Excel user will be able to effectively sort and filter list and table data, create subtotals on data lists, utilize Pivot Tables, and use DFunctions.

  • Observing a Data List
    1. Sorting data
      1. Simple sorting
      2. Complex sorting
        • Specified custom sorting
      3. Filtering data
        1. Using AutoFilter
        2. Multi-field filters
          • The Advanced Filter
  • Creating Subtotals
    1. Grouping data by sorting
    2. Single and multi-level subtotals
  • Using Tables
    1. Table options
    2. Formula Fields
    3. Using Table Fields in formulas
  • Working with Pivot Tables
    1. One and Two Dimensional Pivot Tables
    2. Filtering data and using Slicers
    3. Grouping data fields
    4. Creating Pivot charts
    5. Using external data sources
  • Using Database Functions
    1. DSUM
    2. DAVERAGE
    3. DMAX
    4. DMIN
    5. DCOUNT
Course Information
  • Course Level:Basic
  • Prerequisite:Familiarity with Excel
  • Credit:4 CPE hours
  • Fee:$199

Related Courses

Virtual Live Classes Available for Nearly All Courses