Excel

30 Excel shortcuts to speed up your workoptimarcShutterstock

30 Excel shortcuts to speed up your work

  • Web analytics

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

30 Excel shortcuts to speed up your work
How to create a drop-down list in ExcelUndreyShutterstock

How to create a drop-down list in Excel

  • Online sales

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

How to create a drop-down list in Excel
Using IFERROR function in Excel to avoid problems

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
Merging data in Excel: A step-by-step guide

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 read-only in Excel files

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 an Excel file read only: step-by-step guide

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 your Excel filesESB ProfessionalShutterstock

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: explained with practical examplesG-Stock StudioShutterstock

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: just what is an XLSB file in Excel?

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 document into Google Sheets: a tutorial

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
We use cookies on our website to provide you with the best possible user experience. By continuing to use our website or services, you agree to their use. More Information.