Katrina has attended:
Excel Advanced course
Databases Excel
How do I use a database formula to query?
RE: Databases Excel
Hi Katrina
Thank you for your question; and welcome to the forum.
There are a group of functions in Excel called the Database functions, which allow you to find totals, averages, minimums, maximums (amongst other summary figures) from an Excel database, according to criteria that you specify.
If you search for functions in Excel Help, there should be a 'Worksheet functions listed by category' subtopic that appears which you can then use to access further information on the database functions.
I hope this helps.
Amanda