Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 404137
 
Credit & Course Provided by:

Create and Manage an Excel® Database

Live Webinar
September 25, 2018
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart

Learn how to create, analyze, and manage data in Microsoft® Excel®.

Managing data is becoming more important than ever as data collection is more automated and you're getting swamped with tons of data. But what can you do with all that data? You need to know how to rearrange the data (sort), see just what you want to see (filter), create quick summaries (subtotals), restructure fields containing too much data (text to columns) and eliminate redundant records. If you are setting up a new database, you need to become familiar with the best ways to lay out your data, how to take advantage of Excel®'s Table feature, and how to use the powerful validation tools that not only keep out bad data from the start, but also drastically reduce data entry drudgery with drop-down clickable lists.

Learning Objectives

  • You will be able to discuss using Excel® Tables for database data - advantages and disadvantages.
  • You will be able to identify the use of auditing tools to check the validity of existing data.
  • You will be able to review expand and collapse displays quickly with grouping and outlining symbols.
  • You will be able to describe how to use SUMIF and COUNTIF and related functions for quick data analysis.

Registration

Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart