Filtering Techniques for Excel Data

$149.00

SKU: 411302

Description

Save time by learning how to filter your spreadsheets to get to the data you need.
These days most of us have a ton of data that we find ourselves dealing with. This course will show you how to filter that data to get the exact records that you are looking for. Learn about the basic filter, how to apply a custom view, how to copy filter cells onto other worksheets using visible cells only, and advanced filters. Our speaker will also discuss slicers with formatted tables, slicers on PivotTables and filtering using Power Query.

Date: 2024-02-26 Start Time: 1:00 PM ET End Time: 2:05 PM ET

Learning Objectives

* You will be able to review how to apply a filter.

* You will be able to identify identify timelines on PivotTables.

* You will be able to recognize recognize slicers with formatted tables.

* You will be able to review review filtering using Power Query.

Filter

Custom View

Visible Cells Only

Advanced Filter

Slicers With Formatted Tables

Filters on Charts

Subtotals

Visible Cells Only

Filters on PivotTables

Slicers on PivotTables

Timelines on PivotTables

Filters on Conditional Formatting

Filtering Using Power Query

AIPB ,ASAP PACE ,IAAP ,CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Tom Fragale-The PC Guy, Inc.