excel training courses -

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

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

excel training courses - 1593

resolvedResolved · Low Priority · Version 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:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips


Server loaded in 0.09 secs.