navigate site menu

Start learning with our library of video tutorials taught by experts. Get started

Managing and Analyzing Data in Excel
John Hersey

Managing and Analyzing Data in Excel

with Dennis Taylor

 


In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.
Topics include:
  • Multiple key sorting
  • Single and multiple column numeric filters
  • Creating a top-ten list with values or percentages
  • Setting up subtotals
  • Creating multiple-field criteria filters
  • Creating unique lists from repeating field data
  • Using the Remove Duplicates command
  • Finding duplicate data with specialized arrays
  • Counting the number of unique items in a list
  • Using SUMIF and COUNTIF functions
  • Working with the database functions such as DSUM and DMAX

show more

author
Dennis Taylor
subject
Business, Data Analysis
software
Excel 2007, 2010
level
Appropriate for all
duration
1h 32m
released
Oct 27, 2011

Share this course

Learn more about lynda.com

Start learning today. Lynda explains how.

Ready to join? get started

Keep up with news, tips, and latest courses.

submit Course details submit clicked more info

Please wait...
Dennis Taylor

Dennis Taylor

Dennis Taylor has over 20 years of experience as a highly respected computer trainer and author, having developed over 50 Excel courses and authored or co-authored multiple books on Excel and spreadsheet software. He specializes in improving business efficiency and productivity using Excel and other data analysis programs. As a former employee of Amoco Oil, IBM, Lexmark, Texaco, Levi Strauss, StorageTek, the federal government, and the University of Colorado, he has taught over 3,000 seminars and classes to a wide variety of audiences.
Course Title   Level   Duration   Released  
Excel 2007: Advanced Formulas and Functions Advanced 5h 17m 11/2009  {8}
Excel 2007: Advanced Formatting Techniques Intermediate 3h 8m 03/2010  {8}
Excel 2007: Macros in Depth Intermediate 2h 29m 05/2010  {8}
Excel 2007: Managing Multiple Worksheets and Workbooks Intermediate 1h 12m 05/2010  {8}
Excel 2010 Power Shortcuts Intermediate 3h 43m 08/2010  {8}
Excel 2007: Working with Dates and Times Intermediate 1h 27m 07/2010  {8}
Excel 2010: Working with Dates and Times Intermediate 1h 20m 07/2010  {8}
Excel 2010: Advanced Formatting Techniques Intermediate 3h 2m 02/2011  {8}
Excel 2010: Macros in Depth Intermediate 2h 44m 01/2011  {8}
Excel 2010: Advanced Formulas and Functions Advanced 5h 5m 12/2010  {8}
Excel 2010: Managing Multiple Worksheets and Workbooks Intermediate 1h 29m 01/2011  {8}
Excel 2010: Data Validation in Depth Intermediate 59m 45s 02/2011  {8}
Excel 2007: Data Validation in Depth Intermediate 58m 36s 02/2011  {8}
Excel 2007: Charts in Depth Intermediate 3h 36m 06/2011  {8}
Excel 2010: Charts in Depth Intermediate 3h 38m 06/2011  {8}
Managing and Analyzing Data in Excel Appropriate for all 1h 32m 10/2011  {8}
Setting Up a Database in Excel Appropriate for all 43m 27s 10/2011  {8}
Cleaning Up Your Excel Data Appropriate for all 1h 26m 11/2011  {8}
Excel 2013 Essential Training Appropriate for all 6h 32m 01/2013  {8}
Excel 2013: Advanced Formulas and Functions Advanced 5h 26m 05/2013  {8}

Suggested courses to watch next:

Setting Up a Database in Excel (43m 27s)
Dennis Taylor

Excel 2010: Pivot Tables in Depth (3h 42m)
Curt Frye


Excel 2010: Data Validation in Depth (59m 45s)
Dennis Taylor

Excel 2010: Charts in Depth (3h 38m)
Dennis Taylor


Are you sure you want to delete this bookmark?

cancel

Bookmark this Tutorial

Name

Description

{0} characters left

Tags

Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

bookmark this course

{0} characters left Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

Error:

go to playlists »

Create new playlist

name:
description:
save cancel

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,141 instructional videos.

get started learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Access to lynda.com videos

Your organization has a limited access membership to the lynda.com library that allows access to only a specific, limited selection of courses.

You don't have access to this video.

You're logged in as an account administrator, but your membership is not active.

Contact a Training Solutions Advisor at 1 (888) 335-9632.

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 2,025 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

You don't have access to this video.

You're logged in as an account administrator, but your membership is no longer active. You can still access reports and account information.

To reactivate your account, contact a Training Solutions Advisor at 1 1 (888) 335-9632.

Need help accessing this video?

You can't access this video from your master administrator account.

Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com for help accessing this video.

preview image of new course page

Try our new course pages

Explore our redesigned course pages, and tell us about your experience.

If you want to switch back to the old view, change your site preferences from the my account menu.

Try the new pages No, thanks

site feedback

Thanks for signing up.

We’ll send you a confirmation email shortly.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked