Reverse engineering Excel workbooks

  • February 05, 2016

There are many good reasons to reverse engineer an Excel workbook. Let’s take a look at how to decode the structure of a workbook. Then, we’ll see how to demystify...

Demystifying SharePoint permissions

  • January 11, 2016

Permissions can become confusing in SharePoint. A few basic principles help clear the mist a little. The more complex you allow your permissions structure to become, the...

How to recoup FICA tax overpayments

  • December 26, 2015

Common occurrence: A worker overpays FICA tax due to a change in jobs or other circumstances. It could easily happen to you or someone else in your family. Depending...

Turn on the HEET for education

  • December 15, 2015

With the onset of cold weather in many parts of the country, grandparents of college-bound children may seek some warmth in a smart tax-saving device. Investigate the...

IRS Releases 2016 Notice 1036

  • December 08, 2015

The IRS has released the 2016 Notice 1036, which contains the official 2016 withholding allowance amounts, the amount to add to nonresident alien employees’ wages...

Excel: Highlight #N/A results

  • October 25, 2015

You can filter for all #N/A results, but can you also highlight them with conditional formatting? You have to use the ISNA function, which tests a cell for that result.

FICA wage base remains $118,500 in 2016

  • October 15, 2015

The Social Security Administration has announced that the 2016 taxable wage base for the Social Security portion of FICA will remain $118,500. The 6.2% Social Security...

Have you sworn an oath to the Grammar Police?

  • September 23, 2015

Question: "I take some criticism in the office because I'm a stickler for good grammar. So much of what we write to each other comes off as unprofessional that I think...