optimarcShutterstock 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.
UndreyShutterstock 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.
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.
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.
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!
ESB ProfessionalShutterstock 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.
G-Stock StudioShutterstock 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.
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.
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.
G-Stock StudioShutterstock 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.
