Build or host a website, launch a server, or store your data and more with our most popular products for less.
VBA in Excel stands for Visual Basic for Applications. The programming language can be used to create useful Excel tools to automate recurring tasks. Excel’s VBA programming is one of the easiest ways to exchange Excel data with other Office applications such as Word or…
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,…
Moving columns and rows in your Excel spreadsheet is effortless when you use the drag-and-drop function or keyboard shortcuts. In this article, we’ll show you how to move columns or rows in Excel as well as how to cut and paste them into a different location. That way, you can…
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…
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 —…
Robert KneschkeShutterstockWant to know how to calculate percentages in Excel? With the most important formulas for calculating percentages in Excel, the process is a cinch. In this article, you’ll learn how to calculate percentages of totals and growth rates, and how to figure out proportions and totals…