How-To's and Tips and Tricks

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
Shortcut 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...
Tue, Mar 24, 2020 at 4:52 PM
Pivot Table - How to Add and Remove Subtotals
Add and Remove Subtotals by using the Field Settings option on Pivot Table Right-click on a column heading that you wish...
Tue, Mar 24, 2020 at 5:13 PM
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, Mar 18, 2020 at 5:35 PM
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
Using the CCI Spreadsheets to determine who has worked more than 30 hours
Using the CCI Spreadsheets to determine who has worked more than 30 hours ...
Wed, Jan 2, 2019 at 11:04 AM