Databases

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

Resolved · Low Priority · Version Standard

Databases

Julie has attended:
Excel Advanced course

by - delegate Julie [2 posts] (2008 Feb 15 Fri, 16:08) Reply

We currently don't have an HR database and I use excel for all our records, would it be better to create a database in access or can excel provide a lot of the same functionality?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 11 Mon	Bayswater	0	FULL
2003/XP	2008 Aug 13 Wed	Tooting	0	FULL
2007	2008 Aug 13 Wed	Bloomsbury	0	FULL
2003/XP	2008 Aug 15 Fri	Southwark	3	book now	£224	£235
2003/XP	2008 Aug 20 Wed	Southwark	2	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bloomsbury	4	book now	£224	£235
Full Schedule: See all 134 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Databases

by - delegate Paul gold contributer [121 posts] (2008 Feb 18 Mon, 17:08) Reply

Excel is a very powerful tool, but it can't deal with large amounts of data very efficiently.

If you can, I'd say create a DB, however, Excel can be utilised quite well for simple database like tables.

hint. Use Vlookup a lot

· Microsoft Excel Training: Not Just for Newbies Anymore
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part One
· Microsoft Excel's Best Kept Secret
· Tips to Facilitate Printing of Excel worksheets

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

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips