Blog Feed
What does Professionalism Look like?
What does professionalism look like? Do you “know it when you see it”? Take a look at the images below and sort them into two groups: More Professional and Less Professional. Did you sort all of the people with digital devices into one group or the other? If not –…
Read More
How to Create Shortcuts in Excel by Adding an Excel Macro Button
If you’ve ever repeated the same actions multiple times in a spreadsheet, you’ll benefit from recording a macro to automate those tasks. But, once you have a macro, how do you access it? The easiest way is to add a macro button to your spreadsheet, for which Excel offers three…
Read More
How to Use Excel Chart Templates
How often do you need to insert a favorite chart style, consistent with your prior submission, to maintain a consistent look and feel to your monthly reporting packages? That consistency is one element that increases the appearance of professionalism—especially if it reflects your company’s brand, typography, and color scheme. The…
Read More
Using the Age Formula in Excel to Calculate Age
Have you ever needed to calculate a person’s age from a birthdate in Excel? Or find the number of years since the last audit? Excel includes two functions that perform well: YEARFRAC and DATEDIF. The YEARFRAC Function YEARFRAC gives the number of years between two dates. The FRAC is short…
Read More
Learn How to Subtract in Excel with the Subtract Formula
You have created a report that shows your company’s sales by month. Your boss asks you to add a row that shows the change from the prior month. You need to subtract the prior month’s sales from the current month’s sales. Unfortunately, Excel doesn’t have a SUBTRACT formula. What do…
Read More
3 Ways to Copy a Formula Down a Column
One of the more tedious tasks in Excel is to copy a formula down an entire column of a report. Not only is it mind-numbing, but it also leaves the opportunity for error if you don’t copy the formula down to exactly the correct cells. For best results, try one…
Read More
Decrease Potentially Fatal Injuries with These Tips
Workers’ Deaths Due to Confined Space. It’s a lead news story heard several times a year. According to one report from the Bureau of Labor Statistics Census of Fatal Occupational Injuries, there is an average of two deaths each week due to confined spaces. Confined spaces create a potentially dangerous…
Read More
The Accident Itself Is Just the Tip of the Iceberg
You are moving right along, making great time and there is an iceberg ahead. There is not enough time to avoid it completely, but thanks to your experience you avoid the worst of it. Have you never thought of the historic Titanic when considering accident prevention and workplace safety? Accidents…
Read More
Know Your OSHA!
Many employers dutifully draft written safety and health programs related to hazardous chemicals, blood-borne pathogens, fire prevention and evacuation, emergency action plans and more. Plus, they appropriately provide training on these programs. Are employees missing something? Unfortunately, many employers do not realize that they must maintain and preserve employee exposure…
Read More
Creating a Flowchart in Excel
Have you been tasked with creating a flowchart to document a business process? Some companies invest in expensive, specialized software that builds flowcharts for you with just a few points and clicks. Other businesses prefer to use a tool which they already have, and in which the employees have already…
Read More