How-To's and Tips and Tricks
How to remove rows from a pivot table
Mon, Jan 23, 2017 at 11:09 AM
Step by step instructions
Thu, Feb 23, 2017 at 3:42 PM
Thu, Mar 30, 2017 at 3:11 PM
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
Mon, Mar 19, 2018 at 5:21 PM
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: Click on the row beside the last row: Click on Filter The following should appear Filterin...
Thu, May 24, 2018 at 12:04 PM
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
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