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. You might link to product documentation in an inventory sheet or include…
Read More
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
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
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
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
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. To stay entirely within the Excel user environment, use Get Data…
Read More
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…
Read More
As document sharing and co-authoring becomes the norm for how data is gathered and analyzed, it is more important than ever to make sure that there are guardrails in place for ensuring data quality. Variations in spelling, abbreviations, formatting and numerical styles can all radically impact results. Let’s look at a simple example: Your event…
Read More
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
There’s a moment in everyone’s experience with Excel when you are both fairly comfortable using the tool and at the same time recognize just how much more there is to learn! This is often at the point where you want to take on a new task and realize that tools you need aren’t already in…
Read More
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 8,500+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 50 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
