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:
MS Excel - Free Step-by-step Guides
The free step-by-step Excel tutorials covering topics to use all the Excel features including Excel formatting, chart, formula, macro, printing and customization. Beside all the free how-to articles, you also can download the free excel template, excel tips and techniques, keyboard shortcuts and ebooks.
Excel Three-Criteria Limit for Conditional Formatting
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In fact, you can use the code to apply virtually an unlimited number of criteria.
Excel VBA Variable
This tutorial teaches you how to declare, initialize and display an Excel VBA variable.
This tutorial looks at all three aspects of spreadsheet security, giving you pointers on the best ways to preserve the integrity of your spreadsheet as well as guard against its more sensitive information from falling into the wrong hands.
Copy Forumulas: Absolute Positioning
Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning.