Excel Tutorial Library header
borderExtracting Data from Lists - Part Iborder
border Added to Library on 05 Jan 2008
Length: 9 mins

View Tutorial Movie
Download File Used



This tutorial shows you how to set up query sheet to pull out statistical results from your data based on one or more criteria. The tutorial explains how to use the DSUM, DAVERAGE and DCOUNT functions and how to take the fear out of the concepts on an Excel Database.

The download file contains everything you need to practice these advanced techinques so you are ready to implement them on your own spreadsheet.


Related Tutorials:
Extracting Data from Lists - Part II (using AND)

Feedback for this tutorial:
"Yes... it has helped me... and your tutorials just get better and better... You are really good... Kelly..."

"This is a great tool, I can't wait ti try this out! Thankyou!"

"A most useful tutorial - presented in a most 'endearing' way -thankyou once again."

"This will be very useful for the grant that I manage."

borderborder