Excel Database Functions

So this week I’ve had a bit of inspiration creating some Excel tutorials but don’t worry I’ve also started others including the photography and video podcasts which will be with you in January 2014. But here is one Excel one that I use all the time.

It is the database functions in Excel. These functions can look at a list and by putting in some criteria you can use some functions to do things like total up, average, find the highest or lowest figure. For example, if you had a list of student grades you could find the average just of maths students or find the highest or lowest scores of science students.

In the example I have in the video below I use a list of computer models and how many in stock. Then I can use the DSUM function to total up the quantities of a particular brand. I also use it to find out the average cost using DAVERAGE and the highest and lowest costs using DMAX and DMIN.

This is one of those functions that I find needs a bit of practice if you are doing the ECDL advanced for Excel.

Don’t forget you can also find more on my website www.jargonfreehelp.com

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Office 2010 and tagged , , , , , , , . Bookmark the permalink.

1 Response to Excel Database Functions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s