How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Vlookup - Excel tutorial
This tutorial teaches you how to insert the Vlookup function in Excel.
More cool Excel tutorials:
The tips and tools in these free tutorials include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful, roll-up-your-sleeves guide shows you new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible.
Quick Access Toolbar
If you use an Excel command frequently you can add its icon to the Quick Access Toolbar.
Shows how to use the TEXT function in Excel to improve the formatting of joined cells e.g. Score= 0.4 to Score= 40%.
The CONCATENATE function in Excel
The Concatenate (or &) can be used to join up the contents of multiple cells into one cell. This text function is extremely useful for generating unique keywords or preparing intelligent reports.
Find/ Replace in Excel
The find replace tool is more commonly used in MS Word. However, it is extremely useful in Excel and can be used to quickly make changes to a spreadsheet.