Blog Feed
Three Excel Find and Replace Tips and Tricks You Wish You’d Known Sooner
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.
Working with Data: Improving Organizational Outcomes
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.
The Dichotomies of Data: Understanding Data Opposites
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.
Using Workplace Safety to Build Employee Engagement
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.
In a New Normal, A Renewed Look at Workplace Safety
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).
VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them
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.
Intermediate Excel Skills – Which Ones Do You Need?
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.
Three Lenses of Effective Leadership
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.
Thirty Tips for Leaders
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.
Factors in Designing a Diversity, Equity and Inclusion (DEI) Program
Organizations continue to recognize the benefits of a diverse team: broader talent pools, deeper dialogue, more holistic views of the customer perspective, and more complete decision-making. To better define and implement diversity, equity and inclusion (DEI) programs, organizations are conducting assessments, bringing in training and implementing changes on both systemic and personal levels.