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

databases

ResolvedVersion Standard

Carol has attended:
Excel Intermediate course
Excel Advanced course
Project Intro Intermediate course
Project Advanced course

Databases

How do you tell excel a data selection is a 'database' to then be able to use dsum etc

RE: databases

Hello Carol,
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

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

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.1 secs.