Excel

Creating an Excel drop-down list
Creating an Excel drop-down list
  • Online sales

If you regularly use spreadsheet programs to process large datasets, you will welcome anything that helps. This is where drop-down lists in Excel come in. These allow you to conveniently add content with just one click so you don’t have to type the same thing again and again. We show you how to insert a drop-down in Excel.

Creating an Excel drop-down list
IFERROR function in Excel
Using IFERROR function in Excel to avoid problems
  • Online sales

Error messages are never fun. That’s why Excel has the IFERROR function. It allows you to catch error messages and replace them with a custom message or a value. Most importantly, the helpful IFERROR function ensures that your whole formula doesn’t fall apart if you make a typo.

Using IFERROR function in Excel to avoid problems
Merge data in Excel
Merging data in Excel: A step-by-step guide
  • Online sales

If you want to compare data and run analyses, it is often necessary to merge data in Excel. This can quickly get messy though, depending on what kind of contents are in the table. Keep reading our article to find out how to use the Consolidate function as well as the Power Query Editor to successfully merge data in Excel.

Merging data in Excel: A step-by-step guide
Remove Excel read-only
Remove read-only in Excel files
  • Online sales

Some Excel files have a write protection or are marked as final. If you want to edit such an Excel document, there are multiple options to unlock it. In our guide on how to unlock an Excel file from read-only we show options for different protection types like password protection, partially protected files, and finalized files.

Remove read-only in Excel files
How to make Excel file read only
How to make an Excel file read only: step-by-step guide
  • Online sales

Find out how to make an Excel file read only. We’ll show you how to save an Excel file so that modifications can only be made with a password and reveal what you need to know when opening a read only Excel spreadsheet. In just a few simple steps, you can ensure that unintentional changes to your Excel files are a thing of the past!

How to make an Excel file read only: step-by-step guide
Password-protect Excel
Password-protect your Excel files
  • Online sales

Why should you password-protect your data in Excel? Excel documents often contain sensitive information or formulas that shouldn’t be read or edited by unauthorized persons. When you password-protect an Excel spreadsheet, you decide who gets to view or amend your content. As long as you use a secure password, even modern technologies won’t be able to crack it. We'll show you how to get set up....

Password-protect your Excel files
Excel: median function
Excel: median function: explained with practical examples
  • Online sales

The median indicates the middle number in a group of existing numbers. It is also known as the central value. If you do not want to measure the average, but instead are looking for the central value in a series of numbers ordered by size, just use the Excel median function. The median function can be applied to groups of numbers of any size, even or odd.

Excel: median function: explained with practical examples
XLSB
XLSB: just what is an XLSB file in Excel?
  • Online sales

The spreadsheet program Microsoft Excel handles a lot of different file formats. Excel spreadsheets can be saved not only as the usual XLSX format but also as XLSB files. But what actually are XLSB files and what are they used for? This article will give you all the information you need about the XLSB file extension and how to use it.

XLSB: just what is an XLSB file in Excel?
Import Excel to Google Sheets
Import Excel document into Google Sheets: a tutorial
  • Online sales

Want to import Excel spreadsheets into Google Sheets or open CSV in Google Docs? It takes just five steps to edit, convert, and save Excel spreadsheets in Google Drive directly in your web browser – without Microsoft 365. All you need is a personal Google account and an active Internet connection.

Import Excel document into Google Sheets: a tutorial
Inserting pictures in Excel cells
Inserting pictures in Excel cells
  • Online sales

Pictures in Excel can help to make tables clearer. However, if a picture is not aligned and pinned to its cell, it can shift when changes are made to the table. This can cause chaos in your documents. In this guide, you will find out how to insert a picture in an Excel cell and other ways to deal with pictures in Excel.

Inserting pictures in Excel cells