training courses in excel - microsoft excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training courses in excel - Microsoft Excel

training courses in excel - Microsoft Excel

resolvedResolved · Low Priority · Version Standard

replyReply Tue 9 Oct 2007, 16:11Delegate Pedro said...

Pedro has attended:
Excel Intermediate course
Excel Advanced course

Microsoft Excel

what is the difference between IF and Vlookup

For upcoming training course dates see: Pricing & availability

replyReply Tue 9 Oct 2007, 16:33Trainer Richard said...

RE: Microsoft Excel

The IF Function allows you to EVALUATE a cells contents, and then output a certain value, based on if it is TRUE OR FALSE.

A Vlookup will take avalue that you specify, locate it in the first column of a table, and then return a related record in a column that you specify.

 

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard