Excel Tips – How to Use Pivot Table to Summarize Data in Excel 2010

In this tutorial we will cover how to use pivot table to summarize large amounts of data in Excel 2010.

Continue Reading →

Excel Tips – How to Convert Text to Numbers in Excel 2010

In this tutorial we will cover how to both detect text and then convert text to numbers in Excel 2010.

Continue Reading →

Excel Tips – How to Eliminate Divide by Zero Errors and Add Checkmarks in Excel 2010

In this tutorial we will cover two tips: how to eliminate divide by zero errors, and also how to add checkmarks, all in Excel 2010.

Continue Reading →

Excel Tips – How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010

Excel Tips – How to Quickly Edit Formulas And Data In Multiple Cells in Excel 2010 In this tutorial we will cover two tips: how to quickly edit formulas, and also how to quickly edit data in multiple cells, all in Excel 2010. How to Quickly Edit Formulas  I am sure once you see this tip…

Continue Reading →

Excel Tips – How to Select All Cells Matching A Criteria in Excel 2010

What do you do when you want to select all cells matching a criteria like a specific word, character or value and you want to look at each cell individually… and then possibly edit them. Typically, these cells are scattered all around the worksheet. What’s the best way to locate all of these cells? This article shows you how in Excel 2010

Continue Reading →