How-To's and Tips and Tricks

Sartox Deductions Register: Comparing Months of Information in the CCI Spreadsheets
Sartox Deductions Register Comparing Months of Information in the CCI Spreadsheets Example – Sartox Deductions Register ...
Wed, Jan 2, 2019 at 10:47 AM
To save pivot table data to a new spreadsheets:
To save pivot table data to a new spreadsheets: Right click on the tab for the pivot table. Select...
Wed, Jan 2, 2019 at 10:48 AM
Comparing Months of Information in the CCI Spreadsheets(Example uses Sartox Deductions Register)
Comparing Months of Information in the CCI Spreadsheets(Example uses Sartox Deductions Register) ...
Wed, Jan 2, 2019 at 10:49 AM
Adding the Conditional Formatting in Office 2007/2010
Adding the Conditional Formatting in Office 2007/2010 From the Home tab, click on Conditional Formatting, New Rule ...
Wed, Jan 2, 2019 at 10:50 AM
How to add in a count of PEOPLE…Example – Annual Leave count:
How to add in a count of PEOPLE…Example – Annual Leave count: ...
Wed, Jan 2, 2019 at 10:56 AM
Short Cut to add or remove a Subtotal within a Pivot Table
Short Cut to add or remove a Subtotal within a Pivot Table Example - if you wish to remove Total line from the Object co...
Wed, Jan 2, 2019 at 10:58 AM
Pivot Table - Add and Remove Subtotals by using the Field Settings option
Add and Remove Subtotals by using the Field Settings option on Pivot Table Right-click on a column heading that you wish...
Wed, Jan 2, 2019 at 11:01 AM
Procedures to Repeat All Item Labels in the Pivot Table - Office 2010 & 2013
Procedures to Repeat All Item Labels in the Pivot Table - Office 2010 & 2013 (these functions are not available in 2003 or 2007) The Pivot Table...
Wed, Jan 2, 2019 at 10:59 AM
How to copy information from Excel to another Excel document without copying the hidden cells/rows
How to copy information from Excel to another Excel document without copying the hidden cells/rows:   Office 2007 and above: ...
Wed, Jan 2, 2019 at 11:00 AM
How to create multiple years of data in Budget Details
How to create multiple years of data in Budget Details Budget Details Pivot Table – Compile details for multiple years  ...
Wed, Jan 2, 2019 at 11:03 AM