Calendar of Events

Excel Explained: Filtering and Formatting Data

10/13/2017, 10:00 AM to Noon

No location provided

Amy Davis adavis@msbankers.com 601-948-6366

Description:

Excel Explained: Filtering and Formatting Data


Presented by David Ringstrom
Friday, October 13th, 2017 -10:00 am - 12:00 pm CT
 

Covered Topics:

  • Applying different filter settings with just a couple of mouse clicks using the Custom Views feature.
  • Identifying duplicates in a list using Conditional Formatting.
  • Learning which features, such as Custom Views, you can’t use when one or more tables exist in a workbook.
  • Bypassing filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
  • Using the CLEAN and TRIM functions to eliminate non-printing characters, such as tabs, carriage returns, and spaces, in your data that can trigger #VALUE! and other errors.
  • Transforming dates and numbers into various formats without retyping by way of custom number formats.
  • Gaining control over long lists of data by filtering instead of sorting.
  • Learning how the Table feature allows you to transform filtering tasks.
  • Switching between Custom Views by way of a hidden drop-down list you can enable on Excel’s Quick Access Toolbar.
  • Avoiding retyping data or cumbersome formulas by way of Excel’s Text to Columns command.
  • Using Conditional Formatting to color-code your data, identify duplicates, and apply icons.
  • Transforming text by way of Excel’s UPPER, LOWER, PROPER, and TRIM functions.
Learning Objectives:
  • Identify the Quick Access Toolbar command that can enable you to filter data with one click.
  • Recognize which Excel function capitalizes the first letter of each word.
  • Distinguish between worksheet functions to use when extracting characters from a cell.

Click here to register