Rawpixel.comShutterstockDo you have a huge table where it’s difficult to keep track of all the entries? In Excel, you can use LOOKUP to quickly find values. You can think of this function as a mini search engine for your spreadsheet. Enter a search term and Excel will seek out the value for you. Here,…
G-Stock StudioShutterstockThe median is the middle number in a set of numbers. It is also known as the central value. If you don’t want to measure the average, but instead are looking for the central value in a series of numbers, you can use Excel’s median function. The median function can be applied to…
Rawpixel.comShutterstockIn business, you often need to know the calendar week number. Excel’s WEEKNUM function ensures that you always have the correct week number right at your fingertips. The function can even take different counting methods into account, allowing it to adapt to international…
Ground PictureShutterstockIf a cell contains several values, it often makes sense to split the Excel cell. Although the Microsoft spreadsheet program doesn’t offer a general feature for this, you can split the contents in the cell among multiple columns by configuring and using separators. In this…
A histogram shows the frequency of data, making this chart an important tool for statistics. With a bar graph format, histograms make it easy to identify which ranges of data have a high frequency and which ones don’t. Luckily, you don’t need to use any extra software, because…
G-Stock StudioShutterstockThe FIND function in EXCEL is an effective tool. It allows you to find specific strings within a cell, regardless of how much information it contains. FIND is especially useful in combination with other functions. What tasks can the function help you with? And what is the…
It’s often necessary to merge data in Excel if you want to compare it and run analyses. This can quickly get messy though, depending on what kind of data you have in your worksheet. Find out here how to use the Consolidate function as well as the Power Query Editor to…
Excel ROUNDUP is one of the basic functions used for business, scientific and financial tasks. This function makes calculation results easier to read by removing decimal places that are considered unnecessary. Find out how to round up results in your Excel tables with this…
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. We’ll also reveal what you need to know when opening a read-only Excel spreadsheet. In just a few simple steps, you can ensure that…
There are various ways to disable read-only in Excel. Our dedicated article explains how you can open and edit a write-protected Excel document, how you can turn off read-only in an Excel workbook or spreadsheet and how you can continue editing an Excel document marked as final —…