Excel Tips
April 26, 2017
Pam would like to arrange her worksheet tabs alphabetically. This is not a command in Excel, but using a short macro, you can add it to your Quick Access Toolbar.
April 25, 2017
Excel - Can you use the Find dialog to find a worksheet name?
Macro Create Sheets from Cells »
April 24, 2017
You have a column of text. For each text in the column, you want to insert a new worksheet and name that worksheet for the value in the cell.
April 21, 2017
How to show Month-To-Date sales in a pivot table. This is a Dueling Excel episode.
April 20, 2017
Excel Pivot Tables will let you group similar text entries. Say you wanted to group Chicago, Cleveland, and Detroit into a territory called Midwest. This article shows you how.
April 19, 2017
In Microsoft Excel, can you refresh all pivot tables at once? Read this article to learn how.
April 18, 2017
You have data in Excel. When you type a name, you want all of the cells that include that name to light up in another color. This episode will show you how.
April 17, 2017
How to merge data from several Excel workbooks. Say that you have a folder full of Excel files. Each has one worksheet with a differing number of rows. You can import all of the files in the folder to a single Excel workbook.