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....
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...
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...
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...
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...
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...
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptRejectPrivacy Policy
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.