Excel

XMATCH in Excel
XMATCH in Excel explained through examples
  • Online sales

If you want to search through a range or a specific array of cells for data in Excel, the XMATCH function can come in handy. The Excel XMATCH function lets you find specific data responses from ranges of cells and gives you the result’s relative position. We will use examples to show you how XMATCH works and how it differs from MATCH.

XMATCH in Excel explained through examples
Removing a password in Excel
Removing a password in Excel – here’s how it’s done
  • Online sales

Removing a password in Excel: Encrypted files or individual worksheets can usually be unprotected by removing the password. While removing a known password from an Excel file is quick to do, things quickly turn messy if you can’t remember your password. Read on to find out tips and tricks, what works and what doesn’t.

Removing a password in Excel – here’s how it’s done
XLOOKUP in Excel
XLOOKUP: Here’s what Excel’s XLOOKUP can do
  • Online sales

Excel is well-known for its helpful functions and features when it comes to managing and organizing large amounts of data. One of them is the relatively new XLOOKUP function, which makes it easier to search for specific values within a dataset. Learn how to use the XLOOKUP function in Excel and why it replaces functions like the VLOOKUP or HLOOKUP here.

XLOOKUP: Here’s what Excel’s XLOOKUP can do
Excel: track changes
Excel: track changes
  • Online sales

Imagine you’re preparing an Excel spreadsheet that several colleagues will be collaborating on at the same time. You can monitor whether all collaborators made an entry by tracking changes in Excel. This way, you’ll be able to keep an overview of who wrote what. In this article we’ll show you how it’s done.

Excel: track changes
Inserting Excel into Word
Inserting Excel into Word
  • Online sales

Want to learn how to insert an Excel table into Word and aren’t sure how to proceed? We’ll explain how to insert an Excel file into Word. The easiest way is to use the copy and paste commands. But if you want to edit the data later, it’s better to link the Excel spreadsheet in Word. You can do this quickly and easily with our simple step-by-step guide.

Inserting Excel into Word
Creating an Excel table
How to create a table in Excel
  • Online sales

Excel is a powerful tool for formatting, analyzing and presenting your data. Excel lets you create tables that perfectly organize groups of data and provide useful features like sorting and filtering functions, for example. In this tutorial, you’ll learn how to create Excel tables and tailor them to your individual needs.

How to create a table in Excel
Editing an Excel drop-down list
Editing an Excel drop-down list
  • Online sales

Drop-down lists allow you to configure tables in Excel in a way that is more professional, easier and less prone to errors. However, like anything else in day-to-day work, drop-down menus also have to be changed now and again. For this reason, we are going to explain how to edit Excel drop-down lists so you can adapt their content and appearance and add useful information for other users.

Editing an Excel drop-down list
Excel: SUM Function
Excel: Calculate the Sum of a Group of Numbers
  • Online sales

The Microsoft Excel program is a convenient and easy way to collect and archive data. In addition, mathematical formulas can be solved using the software. For example, you can use the Excel SUM function to add the values of specific cells or entire ranges of cells without having to use a calculator.

Excel: Calculate the Sum of a Group of Numbers
Excel: Find and replace
Excel: Find and Replace – made simple
  • Online sales

Microsoft’s favorite spreadsheet software offers a plethora of useful features and tools. Among the most important commands are “Find” and “Replace.” We’ll show you how they work step-by-step. In addition, this article offers tips and tricks to search for unknown values using placeholders.

Excel: Find and Replace – made simple
Gantt chart in Excel
Gantt chart in Excel – it’s this easy!
  • Online sales

A Gantt chart is a useful tool in project management. Using this graphic, teams are able to quickly gain an overview of the timing of tasks. To be able to create this kind of chart, however, you don’t necessarily need any kind of specialist software. You can also create a Gantt chart in Excel without any difficulties. We’ll explain step-by-step how it works.

Gantt chart in Excel – it’s this easy!