Category Archives: Basic Excel

Excel Keyboard Shortcuts You Wish You’d Learned Sooner (and How to Learn Them)

It’s not an exaggeration to say that Excel is the most-used business software tool in the world. Some have even described it as the “Swiss Army Knife” of business analytics, but whether you use the blade or the spork, all users benefit from learning keyboard shortcuts that keeps their hands on the keyboard. How to…
Read More

5 Excel NON-Keyboard Shortcuts You Wish You’d Learned Sooner

Did you know that the Excel application has been around since 1985? As an almost 40 year old program, Excel has added not only calculation tools and functionality over the years, it has also invested in solid user experience and quality-of-life useability improvements. To that end, there are many (non-keyboard) “shortcuts” savvy users will employ…
Read More

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

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