Home » Blog » Page 30
Microsoft Excel Guides
Google Sheet guides
Productivity resources
Suppose we have a dataset of student scores in a class. If this were the total population we will use the the standard deviation formula as follows, Where the lower […]
Sometimes when you are working with big datasets, you need to highlight the cells that are blanks. Excel provides us with a built-in function to check whether the cell is […]
Sometimes our data contains dates as the key parameter and we have to rearrange the data based on the date values. In such situations, we need to sort the whole […]
For this purpose, we can draw more than one line on the same chart. In this tutorial, we’ll learn how to plot two lines on the same chart in Excel. […]
Here we have a simple dataset with two columns and 5 rows as an example. We will be copying the dataset and pasting it in a vertical position by following […]
Here we have a dataset related to Cars. In this dataset row 5 and 7 are hidden and we will copy the dataset and paste it with the hidden rows […]
Microsoft Excel is a powerful tool that is widely used in businesses, academic institutions, and personal finance. One of the most common tasks in Excel is to copy and paste […]
In this tutorial, we’ll learn how to plot multiple lines on the same graph in Excel. Let’s start with an example dataset above. Suppose we have a dataset that tracks […]
When you want to protect the contents of an Excel file, the most common approach is to protect the worksheet(s) with a password. However, this can be problematic if you […]
Here we have a dataset which contains names of 10 functions used in Python for Data Science. We will be adding PDF links for those functions to explain them. Step […]
Delta symbol (∆) is a mathematical symbol that represents the change or difference between two values. It is commonly used in fields such as mathematics, science, finance, and engineering to […]
Here we have a dataset above which contains ten random addresses, we will be separating the addresses into multiple columns using some formulas. Step by step procedure is given below, […]
In this tutorial we will learn how to fit an excel sheet on one page pdf. For this we will Page alignment and then save the file in pdf form. […]
Slope is a graphical representation of data. Slope is used to represent change of a quantity with respect to other quantity , mostly time. The slope explains the relationship between […]
In this tutorial we will learn how to find table names in Microsoft Excel. Locating the name of a table in Excel is an uncomplicated task, which involves accessing the […]
