How-To's and Tips and Tricks

How to Remove Rows from a Pivot Table
How to remove rows from a pivot table
Mon, Jan 23, 2017 at 11:09 AM
Calculating average teacher salary using payroll assignments spreadsheet
Step by step instructions
Thu, Feb 23, 2017 at 3:42 PM
Budget Summary and Board Report - Dashboard
Using slicers
Thu, Mar 30, 2017 at 3:11 PM
Setting Macro Security - Excel 2016
Setting Macro Security - Excel 2016 At the top Click on “File”   Then click on “Options”   Look for and then click on “Trust Center”   ...
Mon, Jul 31, 2017 at 11:31 AM
Purchase Orders - Report for Public Records Request - pulling from PO tab to Details and creating PT
Purchase Orders - Report for Public Records Request  Can use for any spreadsheet really.
Thu, Oct 19, 2017 at 10:41 AM
Chat of Accounts - FY 2018
Mon, Mar 19, 2018 at 5:21 PM
New features for Budget with Details
Attached is Word document showing the new features for budget with details.
Thu, Apr 5, 2018 at 11:11 AM
Filtering on pivot table calculated fields
Filtering on pivot table calculated fields: Click on the row beside the last row: Click on Filter The following should appear Filterin...
Thu, May 24, 2018 at 12:04 PM
How to create 4 Digit SSN in pivot table in payroll history spreadsheet
Below is article on how to create a 4 digit Social Security number in the payroll history pivot table
Thu, Feb 7, 2019 at 8:40 AM
Avoiding the "security warning" when opening spreadsheets
When a spreadsheet is opened, if the message below is displayed, macro security has not been set.  There is another article in our solutions database about ...
Mon, Feb 18, 2019 at 9:57 AM