Using Excel for Everyday Administrative Tasks (OnDemand Webinar)

$99.00

SKU: 408279EAU

Description

Understand how to sort, filter, format, subtotal and manage the data with the various builtin formulas within Excel.As a modernday administrative professional, you have many responsibilities. On top of the normal tasks that come with the admin job, you may also be presented with huge amounts of data, and then asked to make some kind of sense of it all. This can all be very overwhelming. The information in this topic will help you deal with a large of amount of data by showing you how to sort, filter, conditionally format, subtotal and to manage the data with various builtin formulas within Excel.

Date: 2021-02-04 Start Time: End Time:

Learning Objectives

Sorting Data
• Sorting by One Field
• Sorting by More Than One Field

Filtering Data
• Filtering Text Fields
• Filtering Number Fields
• Filtering Date Fields

Conditional Formatting
• Number Fields
• Text Fields
• Visually Appealing Conditional Formatting

Subtotal With the Data
• Subtotals Using Formulas
• Subtotals Using the Subtotal Feature

Important Formulas
• IF
• VLOOKUP
• Text Formulas

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.