excel training courses - 1593

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

Resolved · Low Priority · Version Standard

1593

Vela has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Vela [3 posts] (2007 Mar 21 Wed, 09:46) Reply

How to extract information from detail data base

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: 1593

by - trainer Tom [20 posts] (2007 Mar 23 Fri, 14:12) Reply

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.

· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part Two
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training Course
· Microsoft Excel Courses Teach Advanced Macro Techniques