Find & Select Constants

by CPA Self Study | Jan 16, 2019 | Copying and Moving, Excel, Formatting, Miscellaneous Excel Tips

I just discovered this little timesaver and thought I would share it with you. Okay, to be honest, my husband told me about it. Suppose you have an Excel spreadsheet and you have a number of product codes all in one row and need to break them out. You can do text to...

Go To Special

by CPA Self Study | Nov 9, 2015 | Copying and Moving, Navigating Around

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

by CPA Self Study | Aug 5, 2015 | Copying and Moving

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 ...

Flash Fill – Leaves Text Functions in the Dust!

by CPA Self Study | Jul 29, 2015 | Copying and Moving

FLASH FILL FEATURE Excel 2013 has a cool feature that will save a lot of time for those of you that are always using Text functions such as =LEFT and =RIGHT to extract information. Flash Fill can recognize patterns and extract the information you need with a click....

Grouping Data by Date

by CPA Self Study | Jul 24, 2015 | Copying and Moving

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...

Only Copy Cells with Data

by CPA Self Study | Jul 16, 2015 | Copying and Moving, Navigating Around

A Method to Copy Only Cells with Data Have you ever had a couple of columns of data that you wanted to combine into one column?  What do you do when there are blank spaces in some of the columns of data?  Many will cut and paste the data from one column to the other,...