How-To's and Tips and Tricks

Position Counts for Salaried Positions – Payroll Assignments
  Position Counts for Salaried Positions – Payroll Assignments Spreadsheet Select “Type of Pay – S” on the Settings tab. Using this setting will bring in a...
Tue, Mar 24, 2020 at 5:05 PM
Using the Pivot Table to Identify who has a combination of jobs
  Using the Pivot Table to Identify who has a combination of jobs… Use the Payroll Assignments Spreadsheet. We are interested in determinin...
Tue, Mar 24, 2020 at 5:01 PM
Locating Employees who had entries for a particular week on a pay date
  Locating Employees who had entries for a particular week on a certain pay date   You can get this information from your payroll history ...
Tue, Mar 24, 2020 at 5:04 PM
Conditional Formatting – Highlighting differences in information
  Conditional Formatting – Highlighting differences in information In this example, we will show how to use conditional formatting to high...
Thu, Dec 27, 2018 at 11:24 AM
Setting Macro Security - MS Office 2007
Office 2007- Setting Macro Security Excel 2007 works differently than previous versions of Excel. In order to allow the buttons and macros to work correc...
Tue, Mar 24, 2020 at 10:44 AM
Setting Macro Security- Office 2010/2016/2019
Setting Macro Security- Office 2010 At the top Click on “File”   Then click on “Options”   Look for and then click on “Trust Center” ...
Thu, Mar 19, 2020 at 4:06 PM
Saving pivot table data to a new spreadsheet without refresh option
Tue, Mar 24, 2020 at 10:45 AM
Printing Pivot Table Headings on every page – Office 2010
Printing Pivot Table Headings on each page – Office 2010   Your Pivot Table spans several printed pages and the page, row and column headings only print...
Tue, Mar 24, 2020 at 10:46 AM
Printing Details from the Budget with Details Spreadsheet
Printing Details from the Budget Spreadsheet Printing Details from the Details Tab Click on the Details tab at the bo...
Tue, Mar 24, 2020 at 4:20 PM
Conditional Formatting – Highlighting differences in information
Conditional Formatting – Highlighting differences in information In this example, we will show how to use conditional formatting to highlight differences ...
Tue, Mar 24, 2020 at 5:25 PM