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.
Question: "We're getting concerned where I work that the overwhelming amount of documents and data that we generate every day aren't being safely stored and tracked....
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...
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...
VLookUp is a powerful and useful function in Excel. It allows you to look up a value in a list and return any column from the look-up column, left. But what if your...
One of the best new features introduced in PowerPoint 2010 (and also included with PowerPoint 2013) is the ability to group presentation slides into sections.
Ever had to keep covering for a boss who was frequently late, forgetful or just plain not available? We've got advice on what to do from experts and admins.
Alimony paid by a taxpayer is deductible while child support is not. Conversely, alimony payments are taxable to the recipient, while amounts paid for child support...
One of the best features of SharePoint 2010 and 2013 is the way it permits co-authoring. Co-authoring means more than one person is in a document, workbook or...
Question: "My company is gearing up to get into social media. They seem pretty open to creativity, so I'd like to know if anyone's noticed any companies out there that...
Everyone wants a piece of you. Employees expect their paychecks to be correct all the time. The IRS expects your payroll taxes to be deposited on time and in the correct...
Q: It’s likely that later this year, one employee will receive a bonus that will boost his supplemental pay to more than $1 million. In anticipation of that, his...
