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 how to
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
Remove Hyperlinks in an Excel 2010 Worksheet With a Simple Macro
There may be times when you have an Excel sheet with a whole lot of data containing hyperlinks. And you may find that although you do need some of that data, you don't really want all those hyperlinks for your current project. If you want to remove the hyperlinks manually, it can … [Read more...] about Remove Hyperlinks in an Excel 2010 Worksheet With a Simple Macro
Macro to Concatenate Columns in Excel 2010
We have been working on an Excel project for some time now and when creating a database we encountered a problem. We had to merge the contents of two cells and doing this manually was time consuming due to the huge volume of records. We decided to put our VBA skills to the test … [Read more...] about Macro to Concatenate Columns in Excel 2010