Blog Feed

List of Essential Excel Formulas

There are hundreds of functions in Excel that can be very helpful in crunching numbers and transforming data into information. Here are three categories of critical functions that every savvy Excel user should know how to read and use. See these formulas and functions in action by downloading: List of…
Read More

It’s About Time! Excel Timesheet Formulas

Date and time math is one of the strengths of Excel. However, it helps to know a few secrets and hidden gems to make your timesheet calculations work smoothly. In this practice, we’ll work with several different Excel functions. But first we need a basis from which to understand how…
Read More

Effective Business Communication

It was a cold Christmas Eve, and I was on a conference call at 2am. I cringed as the project manager belittled her team members and complained about having to take time away from her family. She never once acknowledged that everyone else on the call was also missing family…
Read More

How to Write a Business Letter

Twenty-five years ago, business letters and memos were the go-to forms of written communication in the workplace. Today, most of us hastily type emails and instant messages instead. But the business letter is not dead! Use this more formal approach to present official information – such as contract terms and…
Read More

The Email Tennis Match…Business Communication at its Worst

It happened again. I’m copied on an email and have become part of an email tennis match, watching the emails go back and forth between two colleagues. At this point, no one is winning and the emails are becoming more heated with every exchange. Have you ever sent an email…
Read More

The Guide to Animated Excel Graphs

There are a lot of cool new tools in the latest professional versions of Excel that allow you to add some animation to your charts and graphs. However, with a little help from PowerPoint, you can do some types of animation in almost any version! While animating chart data can…
Read More

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
< >