Welcome to Nonprofit.Courses

Live Event Calendar

When’s the next webinar or podcast or conference?

Here’s where you find out – and more.

Loading Events

« All Events

Tabular Data and Lists in Microsoft® Excel®

December 21 @ 1:00 PM - 2:00 PM EST

$99
Lorman Logo

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 drop-down list can be created to allow users to select even a dependent value.

 

Learning Objectives

  • You will be able to describe how and why to use a list and table.
  • You will be able to explain how named ranges add to functionality.
  • You will be able to recognize structured references versus formulas.
  • You will be able to explain how to create a dependent drop-down list in data validation.

Details

Date:
December 21
Time:
1:00 PM - 2:00 PM EST
Cost:
$99
Event Category:
Event Tags:
https://www.lorman.com/training/general-business/excel-managing-lists-and-tabular-data?affiliate=NPCS&p=19623&c=1830

Venue

On Your Computer, Phone or Tablet

Organizer

Lorman
View Organizer Website

Questions or Corrections? Contact us by Clicking Here.

Want to Post an Event?

Go HERE for Single Day Events.

Go HERE for Multi-Day Events.

Exciting New Content Upcoming Live Events
Don't miss out! Get Weekly Alerts on ...
Stay up to date
Don't miss out on the latest Content & Events!
0
Would love your thoughts, please comment.x
()
x