databases

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

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

Databases

resolvedResolved · Low Priority · Version Standard

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?

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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.