Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Databases

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Databases

Resolved · Low Priority · Version Standard

Reply Fri 15 Feb 2008, 16:08Delegate Julie said...

Julie has attended:
Excel Advanced course

Databases

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?

For upcoming training course dates see: Pricing & availability

Reply Mon 18 Feb 2008, 17:08Delegate Paul said...

RE: Databases

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

Excel articles

· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· Easing the Transition to Excel 2007
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· Make More of your Money with Excel 2007
· The Importance of Data Backups

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

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips