If you have a list with cells of all different colors, you can apply a filter to those cells to have Excel filter them by color, and then apply a formula to count how many of those cells are visible. First, select your list. Right click and choose Filter | Filter by Selected Cells Color. You can then select the filter drop down in your list's first cell and choose which … [Read more...]
Excel 2007
For a person who has used previous versions of Excel, Excel 2007 can be a little intimidating at first. For starters, there are none of the familiar menu options, and some of the keyboard shortcuts that have become second nature have changed. Don't let this discourage you though. With a little guidance and familiarization, you'll find that Excel 2007 is more powerful and … [Read more...]