|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| EXCEL CONDITIONAL FORMATTING- 2012-06-05 10:19:19-04 |
Conditional formatting Conditional formatting in Excel 2007 (and later) allows us to colour cells on a spreadsheet depending on whether or not they meet certain conditions. While it existed to some degree in Excel 2003, it has been seriously beefed up in Excel 2007 and later. This particular tutorial was born from a request on [...]
Read more...
|
| VLookup in Excel- 2012-06-07 05:01:58-04 |
In this Vlookup tutorial we are going to look at how to use the Vlookup function. Essentially what this does is allow you to match up information from two lists and pull in matching information. An example would be if we have a list of part numbers and we want to pull in the actual [...]
Read more...
|
|