Blog Feed

Most Pryor blog articles are pretty positive – we want to emphasize and build on your strengths, and approach your continuous learning and development through an encouraging lens.  Appreciating and leveraging the positive options ahead creates a spirit of optimism and motivation.

As Excel develops more ways to complete tasks, it is even more important to find shortcuts that accelerate our work. Excel's Find and Replace feature is a powerful tool that allows users to quickly search for specific data and replace it with new values throughout an entire workbook.

Data isn’t just for statisticians, data scientists and computer specialists!  Most employees and supervisors benefit from understanding this resource in today's data-driven world.

Understanding data involves understanding differences in data types. This article describes dichotomies, opposites or dualities that help us broaden our view about the types of data that may be important for our organization and in our jobs.

The workplace is a dynamic environment that requires individuals to be both vigilant and proactive to protect themselves and others. Getting creative in how we address workplace safety can also be a way to build employee engagement. 

Over the past few years, the Centers for Disease Control (CDC) and National institutes of Health (NIH) have gotten a lot of attention, due to the public health threat of the pandemic. However, now that many workplaces are returning to previous operations, another agency deserves some attention: the Occupational Safety and Health Administration (OSHA).

The “new” XLOOKUP function was introduced in Excel 2021 and Office 365, and improves upon the heavily used VLOOKUP function in several ways. Let’s start by reviewing the syntax and an example of each function to understand the differences, starting with VLOOKUP.

Definitions of what Excel tasks are considered “basic”, “advanced”, “intermediate” and in between can vary from company to company or industry to industry. An accounting firm, for example, may consider specific accounting functions, VLOOKUP and INDEX/MATCH “basic” tools for the job while an HR department might consider these unnecessary but require knowledge of Power Query and advanced conditional formatting.

Leadership is a complex and multifaceted activity that requires a combination of skills, traits, perspectives, and behaviors.  In this article, we look at leadership through three different lenses: personality, emotion and social awareness. 

The best “Top Ten” lists are fun because they are informative and educational AND easy to absorb. So, in this article, we review THREE Top 10 lists related to leadership, for a total of 30 tips.