From the category archives:

Excel Tips & How-To

Importing contacts from Excel into Outlook

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

If you are in a business that attends a lot of trade shows or you simply have kept all of your Contacts in Excel in the past. There is a quick and efficient way to import all contacts from Excel into Outlook so that you don’t have to manually re-type all of them. Maybe you [...]

Read the full article →

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 [...]

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 [...]

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 [...]

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 [...]

Read the full article →

← Previous Entries

Next Entries →