How-To's and Tips and Tricks

Position Counts for Salaried Positions – Payroll Assignments Spreadsheet
  Position Counts for Salaried Positions – Payroll Assignments Spreadsheet Select “Type of Pay – S” on the Settings tab. Using this setting will bring in a...
Wed, Jan 2, 2019 at 9:53 AM
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...
Wed, Jan 2, 2019 at 11:29 AM
Locating Employees who had entries for a particular week on a certain 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 ...
Wed, Jan 2, 2019 at 10:18 AM
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 - 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...
Thu, Dec 27, 2018 at 11:24 AM
Setting Macro Security- Office 2010
Setting Macro Security- Office 2010 At the top Click on “File”   Then click on “Options”   ...
Thu, Dec 27, 2018 at 11:26 AM
Saving pivot table data to a new spreadsheet without refresh option.
Thu, Dec 27, 2018 at 11:26 AM
Printing Pivot Table Headings on each 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...
Thu, Dec 27, 2018 at 11:28 AM
Printing Details from the Budget Spreadsheet
Printing Details from the Budget Spreadsheet Printing Details from the Details Tab Click on the Details tab at the bo...
Thu, Dec 27, 2018 at 11:29 AM
Conditional Formatting – Highlighting differences in information
Conditional Formatting – Highlighting differences in information ...
Thu, Dec 27, 2018 at 11:30 AM