Chat with us, powered by LiveChat

Go To Special

The Special Uses of Go To Special in Excel Hidden on the Home ribbon in Microsoft Excel, within the Find & Select Button, is an Excel feature that has some very special and generally unknown uses for the CPA.  The feature is Go To Special.  It’s the fourth option...

Copying Only Visible Cells

Go To Special Have you ever subtotaled data or produced a pivot table and wanted to use the summarized information for further calculations?  Normally if you copy filtered or subtotaled data, all the data, including the hidden rows, is copied.There is an easy way ...

Grouping Data by Date

Techniques for Grouping Data by Date in Excel If you have a large data set that includes transaction dates, you may want to aggregate amounts by certain dates.  The problem is that you have a separate date for each day of the year.  This makes any meaningful analysis...