From the category archives:

Excel Tips & How-To

How to use Conditional Formatting in Excel 2007

by Michelle MangenOctober 22, 2009 Excel Tips & How-To

Conditional Formatting is probably one of my favorite things in Excel – the possibilities are probably nearly endless.
This post and video will explain two uses for Conditional Formatting:

How to have cells recolored automatically based on the text in the cell
Automatically alternate row colors using a macro and formula

In the video the sample water and [...]

Read the full article →

Excel 2007: Using Data Filter to retreive data quickly

by Michelle MangenOctober 15, 2009 Excel Tips & How-To
Thumbnail image for Excel 2007: Using Data Filter to retreive data quickly

Using the data filter option in Excel will allow you to quickly and efficiently “retreive” desired data based on the criteria you want.
In Excel 2007:
Tip: All columns must have a header (name) before applying the filter
In cell A1 go to:
Data>Filter (the funnel icon)
Once you have applied the filter you can then select the “arrow” to [...]

Read the full article →

Excel Tip: separate data in one cell into multiple cells

by Michelle MangenOctober 1, 2009 Excel Tips & How-To

Although this video is for Excel 2007 it is the same in Excel 2003 except for how you get to the “Text to Column” command.
The key to remember for this to work in the desired manner is that wherever you want Excel to “break” the data into separate cells must be “pre-defined” with some type [...]

Read the full article →

Want to be an Excel Wizard? Six handy tips to become more efficient

by Michelle MangenSeptember 25, 2009 Excel Tips & How-To

I have my own little hashtag (#ExcelQueen) on Twitter for all the Excel shortcuts I share. I thought it was time to do a video with a few of them.
Under the video you will find the written version of the tips.

Tip 1: Maneuvering to different sheets – two different options for selecting tabs in [...]

Read the full article →

Excel Tips & Tricks: Changing default direction of cell movement

by Michelle MangenJune 22, 2009 Excel Tips & How-To

When working in Excel and you hit Enter by default moves down to the cell just below where you are working. However, you may want to move in a different direction? For example, I have mine set to move to the right as most times that is the direction I am filling data into my [...]

Read the full article →

← Previous Entries

Next Entries →