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 an Excel drop-down listUndreyShutterstock

How to create an Excel drop-down list

  • 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 an Excel drop-down list
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 unauthorised 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
How to insert a picture in an Excel cellG-Stock StudioShutterstock

How to insert a picture in an Excel cell

  • 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 an image in an Excel cell as well as other ways to work with pictures in Excel.

How to insert a picture in an Excel cell
In order to provide you with the best online experience this website uses cookies. By using our website, you agree to our use of cookies. More Info.
Manage cookies