You can shade alternate rows to make the data in your worksheet easier to scan and soothing to the eyes. This is also known as color banding. In this article, we will learn how to shade every other row in Excel. Also read: Select non-adjacent cells in Excel Here’s the step to step guide to …
In this tutorial, we will learn 3 easy ways to calculate the square root of a number in Excel. It will be a very common calculation that you’ll perform very often if you work with large mathematical datasets of any kind. So let’s get started. Different Ways to Calculate the Square Root in Excel There …
In this article, we’ll learn to randomize a list in Excel. Although there is no native function to perform random sort in Excel, an inbuilt function RAND, which is used to generate random numbers, can be utilized to randomize a list. The RAND function takes no arguments. Steps to Randomize a List in Excel Let …
Let’s learn how we can convert Excel to PDF in an easy step-by-step manner. Often one needs to share Excel files with others over the Internet. Sharing as PDF is one of the widely-used and most reliable ways of sharing documents as the document format is maintained and it works on almost any operating system …
In this article, we’ll learn how to square a number in excel. Squaring a number simply means multiplying a number by itself, or raising it to the power of 2. In Excel, there are three easy ways in which you can square a number. To understand how to quickly square a number, we consider the …
You may need to generate random numbers for a variety of purposes. In this tutorial, we will learn how to generate random numbers in Excel. There are two in-built functions in Excel to generate random numbers: RAND and RANDBETWEEN. Let’s look into how we can use these two functions. Generate random numbers using RAND RAND function returns …
The mean is the average or the most common value in a set of numbers. In this article, we will learn how to calculate the mean in Excel. Steps to Calculate Mean in Excel Let us consider the following dataset of a group of students with their marks: We are interested in finding the mean of the …
How to calculate mean in Excel? [Easy Step-by-Step Method] Read More »
In this article, we’ll learn how to stop Excel from rounding numbers. When you enter a number in a cell, Excel may round it off. It is quite annoying when Excel keeps rounding off numbers. While there may be several reasons behind this but the most common reasons are: If the cell width is small, …
In this article, we’ll learn how to insert today’s date in Excel. Many a time, we need to insert today’s date in a worksheet. There are two types of date insertion available in Excel: static and dynamic. Both are suited for different purposes. We’ll see the two types in action in the following sections. Recommended …