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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - Database function

excel word powerpoint courses london - Database function

ResolvedVersion 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:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel word powerpoint courses london - Database function

Database function

RE: Database function

Excel articles

Excel tip:

Seeing named ranges as part of the zoom