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

databases

ResolvedVersion 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

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.