Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

databases excel

ResolvedVersion 2003

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.