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 Gantt Chart - Excel tutorial
More cool Excel tutorials:
Convert Text Numbers to Real Numbers Convert Text Numbers to Real Numbers
Remember that numbers in Excel are right-aligned by default, and that text is left-aligned by default.
Errors in Formulas
It's not uncommon to enter a formula only to find that the formula returns an error.
Count or Sum Cells That Have a Specified Fill Color
Using a bit of code, you can easily SUM or COUNT cells whose fill color was specified manually.
Working with Excel 2007 Files
This tutorial explains how to work with Excel 2007 files.
VBA: Find Text in a String (instr)
You can use the instr function in VBA to test if a string contains certain text. The result is the number of times the specified text appears in the string.