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.
Q: “If an employee has requested lifelong, intermittent FMLA leave (worked one year, and worked over 1,250 hours in preceding 12 months), can an employer make a...
Did you ever have a co-worker stop what he or she is doing and listen to your discussions or, worse, comment on discussions you are having with others? Often this...
Now is a good time to remind supervisors that making negative comments about FMLA usage can end in litigation. That’s because telling employees that taking time...
Q. An employee’s daughter has diabetes and the employee has intermittent leave to provide assistance and care for her. The employee is now using FMLA leave to...
"Erica's been cutting out early every Friday," comes the whisper in the break room. Managers don't have time for this sort of pettiness—here's what to do about it.
National retailer Petco has settled a lawsuit filed by employees in California who groom pets in the company’s stores. The suit alleged the company failed to pay...
We all have different productivity styles. Learning which style fits each person the best can help to personalize productivity efforts, writes Carson Tate, founder of...
Communication in the workplace affects productivity and engagement. When teams communicate well and demonstrate their ideas, they maintain a steady work flow and make...
Whenever groups of people work closely together, conflict is sure to arise. However, there are ways to negotiate peacefully and calmly to ensure both sides are heard,...
Employers can’t rely on the lack of a formal reasonable accommodations request as the basis for not providing one if it is obvious the employee is disabled and...
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.