Excel advanced - Database functions

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel training london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Ro has attended:
Excel Advanced course
Excel Intermediate course
Excel Advanced course

by - delegate Ro [1 post] (2008 Mar 28 Fri, 16:34) Reply

How do you assign a database status to the data table or start a new one so you can use database functions?

Thanks

Ro

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel advanced - Database functions

by - trainer Mara silver contributer [73 posts] (2008 Mar 31 Mon, 01:41) Reply

Hello Ro,
I hope you enjoyed your Excel training sessions with us.

To answer your question, Excel will see any contiguous data table as a database for function purposes. This means that as long as there are no blank rows in your data, Excel will recognise the status.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

· Microsoft Excel Training Course
· Fun Things I've Done With Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Advanced Excel Training - takes you to the next level

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips