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: 2019-12-02 Start Time: End Time:
Learning Objectives
Integrating Data on Web Pages Into Your Workbooks and Creating Automatic Links
Learning How to Repair Broken Workbook Links
Controlling Whether or Not Linked Workbooks Update Automatically as Well as Suppressing Unwanted Prompts
Linking to Other Data Sources Such as Access®, SQL Server, and Text Files
Having the Links to Other Data Sources Update the Information Automatically
Linking Formulas Between Worksheets and Workbooks
Using the Data Consolidate Function to Add Sheets Together and Link
Eliminating the Risk of Workbook Links by Using Microsoft® Query® to Get Data From One Workbook into Another
Managing Prompts That Appear When You Open a Workbook That Contains Links
Learning How to Arrange Two Worksheets From Within the Same Workbook On-Screen
Linking Charts to Data in Other Sheets
ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Tom Fragale-The PC Guy, Inc.
