Do you have an Excel spreadsheet with huge data and scratching your head about how to find discrepancies? A discrepancy in Excel is quite common irrespective of whether you are an expert or an amateur ...

For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of business processes. Over time, these Excel ...

The Bullet feature is not available in Microsoft Excel by default; you must go to settings to have it enabled. The bullet feature cannot add bullets to cells in your Excel spreadsheet, but it can add ...

Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using ...

This is my simple way to use the VLOOKUP function in Excel to find data fast. I walk through how I use VLOOKUP to look up ...

Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically pleasing and easier to follow. You can use one of ...

When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...

Q. I am trying to create a formula in our accounting system, but I keep getting errors. What can I do to get the formula to work? A. All Excel users know how powerful formulas are, but sometimes it ...

In the November 2004 Tech Q&A column (page 85) I wrote with absolute confidence that there is no easy way to change the case of text in Excel. Within three weeks of the publication date, 435 ...