Blog Feed
Two Ways to Compare Columns in Excel
Did you ever squint at two columns of data and examine them row by row to compare the values? Excel can do all that hard work for you in three different ways. Download CompareColumnsinExcel.xlsx to follow along. Note: All values will appear highlighted on the This Equals That Worksheet, initially.…
Read More
Excel Macro Email
Among the many little-known and perhaps even-less-used hacks one could exploit via Microsoft Office, an Excel macro email can save precious hours on a weekly basis. As a bonus, understanding the nature of these handy little "cheats" provides an incidental beginner's introduction to some very basic principles of coding. This…
Read More
Why OSHA?
It was a nice sunny day in Nebraska as two employees working for a roofing company were putting a tin roof on a barn. They had done this type of work many times before without incident. They had no reason to believe that today would be any different. So as…
Read More
Office Safety Tips
As Margie walks up the office stairs where she works, she has no idea what awaits her. The floor at the top of the stairs has just been mopped and there is no warning sign cautioning her about a slick floor. As she reaches the top of the stairs she…
Read More
June is National Safety Month
It was a beautiful Saturday spring day and Stanley decided to do some tree trimming around the house. This was the first weekend he had off for several months and it felt good to be working in the yard. Not only that, he didn’t have his supervisor breathing down his…
Read More
How to Create a Custom Function in Excel
Excel functions are actually shortcuts to more complex calculations. Like a macro is to a series of steps, a function is to a longer equation. While Excel is packed full of functions, you may find that you have proprietary formulas that you use regularly that would be useful as a…
Read More
Using Excel Conditional Formatting Based on Another Column or Cell
Steps in this article will apply to Excel 2007-2016. Images were taken using Excel 2016. Conditional formatting is a useful Excel feature that can help you quickly scan your data without resorting to complicated filtering or fussy charts. Often, you will use conditional formatting to call attention to cells that…
Read More
Using Conditional Formatting: If Statements in Excel
*Steps in this article will apply to Excel 2007-2016. Images were taken using Excel 2016. If you are a fan of Excel’s conditional formatting feature, you probably find looking for even more and more ways to highlight useful information in your data. A question that often comes up among these…
Read More
Nesting Functions in Excel – A Tutorial for Beginners
Most of us begin using Excel by creating simple worksheets that organize data and perform simple calculations. Then, we might dabble with some of Excel’s many pre-set functions for more complex calculations. You know you’re a real Excel addict, however, when you start thinking How can I crunch my data…
Read More
Using Excel Conditional Formatting Based on Date
Turning your cluttered spreadsheet of data into living, actionable information can be as simple as adding visual cues. Unless you are really good at doing date calculations in your head, conditional formatting is especially helpful when determining ages or anticipating birthdays and anniversaries. The following steps show how to perform…
Read More