Excel Tip: How to easily find and delete duplicate data

Have you been looking for an easy way to find duplicates in Excel? There are many different formulas and avenues you can take to find duplicate data in Excel. This particular function is my favorite because your list does not have to be in any particular sorted order....

Importing contacts from Excel into Outlook

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

How to use Conditional Formatting in Excel 2007

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

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

Excel Tip: separate data in one cell into multiple cells

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...
Want to be an Excel Wizard? Six handy tips to become more efficient

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

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