Maintenance Alert: Saturday, October 21st, 7:00am-6:00pm CT. During this time, the shopping cart and information requests will be unavailable.

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Excel Macro Email

Default Image

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 handy VBA code will send…
Read More

June is National Safety Month

June is National Safety Month thumbnail

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 neck with all that safety…
Read More

Using Excel Conditional Formatting Based on Another Column or Cell

Default Image

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 represent an outlying condition –…
Read More

Using Conditional Formatting: If Statements in Excel

Default Image

*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 “conditional formatting addicts” is Can…
Read More

Using Excel Conditional Formatting Based on Date

Default Image

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 a common Human Resources task:…
Read More

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories