Our new Report Enhancer is now available!!  Read on to learn more about it!

This Add-In for Excel 2000 or newer will revolutionize the way you use your reports! 

BONUS!  You can use it for all of your Excel reports--not just your Core Call Out reports.

Click on any of the buttons on the toolbar pictured here to learn about all of its functions!

IMPORTANT!  Once you have the toolbar installed, make a copy of the current sheet before you start experimenting with the toolbar!

 

See/Choose Current Worksheets This button allows you to navigate quickly and easily between sheets.  It brings up a list of available sheets and, when more than one file is open, available workbooks.  Just highlight the one you want.  Double-clicking works the same as the close button.

Make a Copy of the Current Sheet (Add-In Operations cannot be undone) This button allows you to create a copy of a sheet to play with.  You can sort, highlight, edit, anything you want, without risking losing the original data. When you use the toolbar buttons, Undo is not available from the Edit menu.  So this lets you explore your data risk-free.  (It's also a great way to familiarize yourself with the functions of this add-in!)

UnMerge Selected Columns (or entire sheet if only one column's selected) for column sorting. This button allows you to change merged cells back to single cells.  This allows column sorting and other options to work that wouldn't otherwise. Please use a copy of your sheet when unmerging.  Merging cannot be redone.

Highlight (in red) all scores in column that are the same or higher (than the top cell) This button does exactly what it says.  If you sort on one column, you can highlight all scores in another column that are above the average for that column by selecting the average cell at the top of the column you want to highlight. WARNING:  Many reports have hidden rows.  If you highlight the average score and click the button and nothing happens, it is because of the hidden rows.  If this happens, you must select the cells in the column that you want to check against the average and then click the button.  You can use this button on cells other than the average cell, but it will only highlight cells that are AFTER the selected cell.

Make all 10% Larger Click this button to make all the worksheets 10% larger.  The more you click it, the bigger all of the sheets get.

Make all 10% Smaller Click this button to make all the worksheets 10% smaller.  The more you click it, the smaller all of the sheets get.

Make all Normal Size Click this button to resize all of the spreadsheets to 100%.

Sort Rows (a->z)/ Sort Rows (z->a)/ Sort rows below active cell/ Sorts all selected rows if more than one row selected These buttons can be used in a variety of ways.  Instead of selecting the entire chunk of the sheet you want sorted, you can just click on the cell in the column you want to sort on.  Click the top cell that contains data in the row you want to sort and click one of these buttons, and all of your data will be sorted in ascending or descending order on the column you selected.  Or, you can select a few rows of data in a single column and it will sort just those rows of data in ascending or descending order on the column those cells were in.  WARNING:  If the report you are sorting on has hidden rows or blank rows, be careful.  This works only on the current matrix.  Subsequent sections below, separated by blank rows, will not be affected.

Set to Number of Columns in one column set Click the arrow to reveal the drop down box with the different options.  This button can be used to group columns together for the purposes of sorting and shading columns.  This feature is to be used in conjunction with Sort Columns (A->Z), Sort Columns (Z->A), Shade Column Sets and Shade columns within each set.

Sort Columns (a->z)/ Sort Columns (z->a)/ Sorts columns to the right of the active cell/ Sorts all selected columns if more than one column selected. These buttons can be used in a variety of ways.  Instead of selecting the entire chunk of the sheet you want sorted, you can just click on the cell in the row you want to sort on.  Click the cell to the right of the data in the row you want to sort and click one of these buttons, and all of your data will be sorted in ascending or descending order on the row you selected.  Or, you can select a few columns of data in a single row and it will sort just those columns of data in ascending or descending order on the row those cells were in. Or, you can set a column group using the Set to number of columns in one column set button and sort entire groups together. This option will unmerge cells if they are merged.  So be sure to use a duplicate sheet for this because merging cannot be redone.

Shade Column Sets according to the 'Number of Columns' Setting This button shades alternating sets of columns.  The number of columns in a set are determined by the Number of Columns settings and are counted from the right to the left. For example, if you have the number of columns set to 3, then the last 3 columns won't be shaded, the next 3 will, and so on.

Shade Columns Within Each Set according to the 'Number of Columns' Setting This button shades certain columns within column sets.  The first column is shaded and then it counts the number of columns you set and shades again. For example, if you have the number of columns set to 3, then the column you have selected will be the first column shaded.  Then the 4th column will be shaded, the 7th column, and so on.

Remove ALL Shading from this sheet This button removes all shading from the current sheet.

Current Version of this Utility This button gives you the version number and date of the version of the utility you have installed on your computer in a pop up box.

Toolbar Options Click this button and the option to Add or Remove Buttons appears.  If you highlight Add or Remove buttons, the option to customize appears. If you select Customize, a window pops up that allows you to customize ANY toolbar, not just the Utility toolbar.  To do this, you simply check off any toolbar you'd like to view, go to the Commands tab and follow the directions on how to add Commands to the toolbar.

Close This button closes the toolbar.  To open it again, just go to View, select Toolbars, and check Utility.

 

Docking the Toolbar You can "dock" the toolbar on an existing toolbar instead of leaving it "floating."  Just click on it and drag it to where you want it.

 

 

 

 

 

 

 

 

 

 

CLIENTS!!

To read up on HOT TOPICS affecting the music or market research industries, visit...

Download our new REPORT ENHANCER today!  To learn more go to...

To learn about TSL Max®, a new way to Maximize TSL without killing cume, click here...