Author Archives: Tepring Crocker

Three Excel Find and Replace Tips and Tricks You Wish You’d Known Sooner

Three Excel Find and Replace Tips and Tricks You Wish You’d Known Sooner thumbnail

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. It offers several advanced options, such as…
Read More

VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them

VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them thumbnail

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.   VLOOKUP Syntax and Examples Here is the syntax: VLOOKUP (lookup_value, table_array, col_index_num,…
Read More

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…
Read More

Basic Excel Skills Employers Want and How to Get Them

Basic Excel Skills Employers Want and How to Get Them thumbnail

Microsoft Excel is one of the most widely used applications in the business world. It is an essential tool for organizing and analyzing data, and being proficient in its use is a necessary skill for many jobs. Perhaps, even more importantly, employers are looking for problem solvers and organized leaders. Basic Excel competence signifies that…
Read More

Excel’s Newest Features That You’ll Want to Know About!

Excel’s Newest Features That You’ll Want to Know About! thumbnail

If you use Excel through an Office 365 subscription, you know that new features appear regularly throughout the year. Because of this ‘trickle’ you might easily miss something new and useful, especially if your updates take place automatically in the background. As we head into a new year, here are several new features and functions…
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