"Excel" category, page 10

Excel IFERROR function with formula examples

"Give me a formula, and I shall make it return an error," an Excel user would say. In this tutorial, we won't be looking at how to return errors in Excel, we'd rather learn how to prevent them in order to keep your worksheets clean and your formulas transparent. Continue reading

Excel RANK functions with formula examples

When you need to determine the relative position of a number in a list of numbers, the easiest way is to sort the numbers in ascending or descending order. If for some reason sorting is not possible, the Excel RANK function is the perfect tool to do the job. Continue reading

Excel Data Validation: custom formulas and rules

In yesterday's tutorial we started to look at Excel Data Validation - what its purpose is, how it works, and how to use built-in rules to validate data in your worksheets. Today, we are going to take a step further and talk about the nitty-gritty aspects of custom data validation. Continue reading

Data validation in Excel: how to add, use and remove

When setting up a workbook for your users, you may often want to control information input into specific cells to make sure all data entries are accurate and consistent. Among other things, you may want to allow only particular data type such as numbers or dates in a cell, or limit numbers to a certain range and text to a given length. Continue reading

How to track changes in Excel

When collaborating on an Excel workbook, you may want to keep track of the changes that have been made to it. On a printed copy, you could use a red pen to mark edits. In an Excel worksheet, you can review, accept or reject changes electronically by using the Track Changes feature. Continue reading

How to do calculations in Excel

When it comes to calculations, there is almost noting that Microsoft Excel cannot do, from totaling a column of numbers to solving complex linear programming problems. Apart from that, you can use Excel as a calculator to do math - add, divide, multiply, and subtract numbers as well as raise to power and find roots. Continue reading

Basic Excel formulas & functions with examples

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel. Continue reading

How to calculate standard deviation in Excel

In statistics, the arithmetic mean and standard deviation are two closely related concepts. But while the former is understood by most, the latter is comprehended by few. The aim of this tutorial is shed some light on what the standard deviation is and how to calculate it in Excel. Continue reading

Mean, median and mode in Excel

When analyzing numerical data, you may often be looking for some way to find the "typical" value. For this purpose, you can use one of the so-called measures of central tendency such as arithmetic mean, median or mode. Continue reading

How to align text in Excel

By default, Microsoft Excel aligns numbers to the bottom-right of cells and text to the bottom-left. However, you can easily change the default alignment or even align a column of numbers by a decimal point or a specific character. Continue reading

Lookup in Excel: functions and formula examples

Looking up a specific value within a dataset is one of the most common tasks in Excel. And yet, there exists no "universal" lookup formula suited for all situations. In this tutorial, you will find an overview of the most popular Excel Lookup functions with formula examples and in-depth tutorials linked for your reference. Continue reading

Show time over 24 hours, 60 minutes, 60 seconds in Excel

When subtracting and adding time in Excel, you may sometimes want to display the resulting time intervals over 24 hours in the hh:mm format, over 60 minutes in the mm:ss format, and over 60 seconds in the ss format. The task is a lot easier than it may sound, and you will know the solution in a moment. Continue reading

Excel Hyperlink: how to create, change and remove

Hyperlinks are widely used on the Internet to navigate between web-sites. In your Excel worksheets, you can easily create such links too. In addition, you can insert a hyperlink to go to another cell, sheet or workbook, to open a new Excel file or create an email message. Continue reading

How to change column width and AutoFit columns in Excel

Microsoft Excel provides a variety of ways to manipulate the column width – you can resize columns using the mouse, set the width to a specific number or have it adjusted automatically to accommodate the data. In this tutorial, you will find the detailed information about all these methods. Continue reading

How to Vlookup multiple values in Excel with criteria

When using Microsoft Excel for data analysis, you may often find yourself in situations when you need to get all matches based on a specific id, name, email address or some other unique identifier. An immediate solution that comes to mind is using the Excel VLOOKUP function, but the problem is that it can only return a single match. Continue reading