If you are working on a large data file and you have two columns of data for each year, you may want to check if there are any changes in the list from one year to the next. In such instances, Excel provides you with a cool function EXACT, that delivers the result in a matter of … [Read more...] about Excel 2010: How to Compare Two Strings of Text for Similarities
excel how to
How to Remove Spaces in Excel 2010 (Leading, Trailing or All)
f you are in the habit of copying content from other spreadsheet or from a website to your Excel database, you might often be faced with the situation where the copied content display additional spaces either the beginning or end of a string. You may also find extra spaces within … [Read more...] about How to Remove Spaces in Excel 2010 (Leading, Trailing or All)
Excel 2010: How to Summarize Data by Creating PivotTables
If you have a long list of raw data that you want to summarize, PivotTable is the tool for you. Pivot Tables help you to dynamically analyze the relationships between different types of data stored in Excel. The introduction of Slicers in Excel 2010 has made the use of Pivot … [Read more...] about Excel 2010: How to Summarize Data by Creating PivotTables
Excel 2010: How to Add and Delete Rows and Columns
Adding or removing rows and columns in an Excel workbook is quite an easy process. For those of you who are not familiar with the process, this tutorial shows you how to add and delete rows and columns. There are more than one ways to do this. While I prefer to use the keyboard … [Read more...] about Excel 2010: How to Add and Delete Rows and Columns
How to Organize Your Room Mates Budget Using Excel 2010
This is a guest post written by Yoav Ezer. If you would like to write for theapptimes, check our Guest blogging guidelines. Maintaining friendships is not always easy. It takes a lot of work and give and take. Add money into the mix and things get complicated, but when people are … [Read more...] about How to Organize Your Room Mates Budget Using Excel 2010
Create Attractive Comments Using Excel 2010 Formatting Options
Chances are that you are sharing an Excel worksheet with a whole lot of calculations in it with a colleague. There may be instances when cell values need further explanation for better understanding. For example, it will make more sense to your colleague, if you added an … [Read more...] about Create Attractive Comments Using Excel 2010 Formatting Options
Protect Your Excel 2010 Worksheet Data
Sometimes you may want to protect a worksheet to prevent others from modifying the contents of all the cells in the worksheet. And sometimes you may want to modify certain cells but prevent other cells from modification. For example, your worksheet may have certain cells that … [Read more...] about Protect Your Excel 2010 Worksheet Data
Extract URLs From Hyperlinked Text Using Macros in Excel 2010
There may be instances when long hyperlinked text has been made pretty by cloaking it with other text. While that may serve some purposes, there may be times when you want to view the URL's that are behind the hyperlinks. If you ever find yourself in such a situation, you can … [Read more...] about Extract URLs From Hyperlinked Text Using Macros in Excel 2010