How-To's and Tips and Tricks

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
How to select Absence Reasons on Absent History Spreadsheet
Wed, Jan 2, 2019 at 11:05 AM
How to select Terminated / Retired employees
How to select Terminated / Retired employees: Payroll Assignment spreadsheet will give you the infor...
Wed, Jan 2, 2019 at 11:06 AM
How to retrieve 2 years of data into Payroll History Spreadsheet
How to retrieve 2 years of data into Payroll History Spreadsheet The...
Wed, Jan 2, 2019 at 11:07 AM
How to successfully use Subtotals buttons
I think the Pivot Table is the best way to print reports for Auditors – but if you like to use the main tab for subtotals, below is helpful information. ...
Wed, Jan 2, 2019 at 11:09 AM
Using Conditional formatting to highlight Pay Group differences in the Payroll Deductions sheet for ISIS
Using Conditional formatting to highlight Pay Group differences in the Payroll Deductions sheet for ISIS ...
Wed, Jan 2, 2019 at 11:10 AM
How to update Remaining Balance Dollars in Budget with Details Spreadsheet
How to update Remaining Balance Dollars in Budget with Details Spreadsheet This document is an example of Remaining Balance column amounts do not match th...
Wed, Jan 2, 2019 at 11:11 AM
How to prevent spreadsheets from prompting for password multiple times
Spreadsheets keep prompting for password over and over again ...
Wed, Jan 2, 2019 at 11:12 AM
Tutorial Videos
Tutorial Videos Click or copy the link into a browser to view the videos on how to use the pivot tables in the CCI Spreadsheets http://cci.cook...
Wed, Jan 2, 2019 at 11:13 AM
How to create Multiple Year Data for Payroll History
 This article is helpful for Public information records requests (specifically teachers) but can be applied to anything.
Wed, Jan 2, 2019 at 11:23 AM