Category: Excel®

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.

Read More

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.

Read More

Four Ways to add Hyperlinks in Excel

We all use hyperlinks every day. That clickable, sometimes underlined, sometimes blue text has come to be as familiar as text itself. And while they might not be as common in Excel, there are many uses for hyperlinks within a workbook as well.

Read More

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.

Read More

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.

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 and advanced conditional formatting.

Read More

Basic Excel Skills Employers Want and How to Get Them

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.

Read More

More Ways to Convert PDF Files into Excel Data

When it comes to storing, analyzing and visualizing data, Microsoft Excel is the preferred choice. But, when the source of the data you need to analyze is contained within a PDF file, your first step is going to be getting it into Excel.

Read More

How to Convert a PDF to Excel Using Get Data

The Portable Document Format, known best by its acronym and file type “PDF”, was developed by Adobe Systems in 1993 and has remained the standard for consumer printing, publishing and electronic sharing ever since. It is no wonder, then, that every now and then the need to convert information stored in a PDF into an Excel worksheet comes up. Powerful tools are destined to collaborate.

Read More

Create a Drop-Down List in Excel

Your event planning company is preparing for a large company meeting. Managers from each department have been tasked with gathering and reporting meal orders, chosen from six meal options, into a shared event spreadsheet. This is the form you sent and the list of meal options offered:

Read More
< >