excel word powerpoint courses london - Database function

Resolved · Low Priority · Version Standard

Thu 29 Nov 2007, 13:03 Delegate Pauline said...

Pauline has attended:
Excel Advanced course
Upgrade to Office 2010 course

Database function

Would it be easier to use V Look up for a simple spreadsheet rather than using database function?

Thu 29 Nov 2007, 13:14 Delegate Paul said...

RE: Database function

there's advantages to both.

I use vlookup a lot and only clogs the system up when you are referencing a lot of cells (and by a lot I mean thousands and thousands)

so I'd say, stick with Vlookup

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

excel word powerpoint courses london - Database function

Database function

RE: Database function

Excel articles

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines