Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
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. Method One: This Equals That…
Read More
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
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 they had done countless times…
Read More
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 slips on the wet floor…
Read More
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
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 function shortcut. Advanced Excel users…
Read More
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
*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
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 even more efficiently? This means…
Read More
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
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 8,500+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 50 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
