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

excel training courses -

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - 1593

excel training courses - 1593

ResolvedVersion Standard

Vela has attended:
Excel Intermediate course
Excel Advanced course

1593

How to extract information from detail data base

RE: 1593

Hi Vela

You need to use the "New Database Query" Command from the "Import External Data" Mnu from your Data Menu on your Menu bar. Specify the type of database you are wanting to connect to or the Query from the Query tab if already saved a query , then press OK. Select the file and followed the rest of the wizard to specify your criteria for the query, save if required again. Select where you would like the data returned then return the data.

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

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.