Blog Feed
Create a Gantt Chart in Excel
If you do any project management, you’ll eventually need to (or be asked to) create a Gantt chart
The Power of Excel Array Formulas Part II
Use an array formula to attach an IF to a function that doesn’t have one
Give Your Spreadsheets a Visual Punch with Charts and Graphs
When presenting important information, a visual – such as a chart or graph – is worth a thousand lines of data. But communicating your message is not as simple as tossing in a pie chart. Visual representations of data must be carefully planned and crafted to present a clear and…
Read More
7 Steps for Successful Worksheet Setup
Have you been asked to create an Excel worksheet from scratch and had no clue on how to approach the process? Did you build a worksheet only to discover that you should have added elements in the beginning to save time and frustration? Below is a seven step guide that…
Read More
A Quick Guide to Excel Shortcuts
Integrating keyboard shortcuts into your daily routine saves you time and energy. We love finding new ways to avoid the mouse. For instance, you can edit a cell using the F2 key. Highlight the cell you want to edit. Then, press F2 and the cursor appears at the end of…
Read More
Danger Zones That Can Trip Up Even the Most Seasoned HR Professional
Let's talk about "best practices" that can minimize the legal threat all HR professionals face – be they seasoned or beginning. Think consistency in enforcement. This is a tricky because we always think we are being consistent - we are not. Using checklists will help when you are hiring, giving performance…
Read More
The Essentials of Employee Coaching, Counseling, and Discipline
Virtually all aspects of HR and management practices impact employee rights. Think hiring, performance appraisals, quality control, references or employment disciplinary actions taken. Providing proper coaching and advice to your supervisors and managers is essential. How would you answer the following questions? Can we install a security camera in the…
Read More
Family and Medical Leave Act 2013 Update and New Regulations
While the Department of Labor's (DOL) new posting requirements for FMLA have taken effect, the updated regulatory changes apply mainly to FMLA provisions not often used by employees in the workplace. Lets highlight a few of the key issues with regard to the revisions: The new regulations require covered employers…
Read More
Email Etiquette: Treat Emails Like Phone Calls
Getting your head around email etiquette is easy if you show the same courtesy and respect you would show if you were on the phone with them. Respond—If the phone rings, you answer it. If someone emails you, answer it Answer all questions—When you're talking to someone, you don't just…
Read More
Five Steps for Dealing with Multiple Priorities
Lay the groundwork. Organize your workspace, especially your desk. Clutter breeds confusion, so get rid of objects (supplies, stacks of paper, toys, etc.). These things seem harmless, but they register in your peripheral vision and compete for your attention. Clarify instructions and standards so you don't waste time with trial and…
Read More