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… Read More »Go To Special
Copying and Moving
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… Read More »Copying Only Visible Cells
Flash Fill – Leaves Text Functions in the Dust!
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… Read More »Flash Fill – Leaves Text Functions in the Dust!
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… Read More »Grouping Data by Date
Only Copy Cells with Data
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… Read More »Only Copy Cells with Data