Tag Archives: Excel

How to quickly find duplicates in Excel

This gallery contains 1 photo.

Have you ever had a long list of items and you need to quickly identify which ones are duplicates?  Thankfully, Excel’s Conditional Formatting feature makes it easy to quickly find duplicates in Excel. Open your Excel file and highlight the … Continue reading

More Galleries | Leave a comment

How to produce a family calendar in Excel

This gallery contains 9 photos.

How to produce a family calendar in Excel Microsoft Excel has many templates that you can download for free from Office.com. In this blog post we demonstrate how to produce a family calendar in Excel 2010 using one of these … Continue reading

More Galleries | Leave a comment

Excel Review Questions

This gallery contains 1 photo.

Have you ever had someone tell you they know Excel?  Of course, one might ask, “What does it really mean to say you know Excel?” It is true that the program has so many features that it is almost impossible … Continue reading

More Galleries | Leave a comment

Using a Data Form in Excel 2010

This gallery contains 5 photos.

Last week a friend of mine was doing some data entry into a large spreadsheet that had a lot of columns to it. She found it a bit cumbersome to enter the data going across in the spreadsheet. Her question … Continue reading

More Galleries | Leave a comment

Working with Dates in Excel 2010

This gallery contains 2 photos.

Recently, I was asked by one of my Excel students if there was a way to insert a date on their spreadsheet that doesn’t automatically update. The answer is “yes”. They were already familiar with the date function =TODAY(). Here … Continue reading

More Galleries | Leave a comment

Understanding VLookup

This gallery contains 9 photos.

Vlookup is a powerful function that can help you lookup information from a table or list of data. Suppose you have a list of 5000+ movies like the one shown below. The VLookup function will allow Excel to lookup an … Continue reading

More Galleries | Leave a comment