Description
Learn how to transform data into meaningful, organized tables in Microsoft Excel.Managing and analyzing data can be overwhelming. However, an Excel table allows for consistent and uniform data. Your data’s additional rows and columns will update with refresh and features, such as sorting and filtering. It is a simple way to professionally format your work and is especially helpful in organizing your data with PivotTables. Along with Excel tables, you can manage data via a list or sequence of rows of related data. The difference is that tables have additional functionality. For example, tables display rows in alternating colors, while lists do not. Lists allow for more layout options than a table and are a helpful feature in data validation. A dropdown list can be created to allow users to select even a dependent value.
Date: 2021-12-21 Start Time: End Time:
Learning Objectives
Lists and Tables
• Create Tabular Data in Excel
• Understand a Spreadsheet List vs. Table
• Use a Table as a List
• Fields and Records vs. Columns and Rows
Table Features
• Elements of a Table
• Table Tools
• Total Row
• Adding Subtotals
• Subtotal Syntax
Apply Filters
• Showing Relevant Data
• Effect of Filters on a Table
• Data Cleansing
Drop-Down Lists
• Using Pick From Drop-Down List Feature
• Using Data Validations Drop-Down Feature
• Creating a Dependent Drop-Down List
Data Validation Lists
• Responding to Invalid Data
• Stop
• Warning
• Information
• The Offset Command
Named Ranges
• Why Name a Range
• Assign a Name to a Block in a Column
• Using Named Ranges in Data Validation
Structured References
• What Is a Structured Reference?
• Creating a Reference
• Using a Structured Reference in a Formula
AIPB ,ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Lauritta Sowa-WiseOwlOps, Inc.
