Excel Basics

How to Remove Borders in Excel (4 Quick Ways)

Sometimes we apply Borders in Excel cells to make them stand out. But we also need to Remove those Borders when they are not useful or necessary ...

How to Remove Data Validation Restrictions in Excel (3 Ways)

In Microsoft Excel, data validation is one of those tasks that makes it easy to input data. If you want to limit your input data type, you can use ...

Create Table in Excel Using Shortcut (8 Methods)

Table in Excel allows you to perform different calculations and organize your data more easily. You can create a table in Excel in different ways. In ...

How to Format Number to Millions in Excel (6 Ways)

In Excel, number formatting is an amazing feature. Sometimes we have large numbers which may be difficult to read. We can improve the readability of ...

How to Sum by Group in Excel (4 Methods)

To sum by group means to add up values of a particular category. We often use it on numerous occasions in our daily lives. The summation of a group ...

How to Apply ‘If Greater Than’ Condition In Excel (9 Ways)

While working with a big data set, we frequently need to compare numbers. In some cases, we need to find the summation, average or conditional ...

How to Sum Only Visible Cells in Excel (4 Quick Ways)

There are a few ways to Sum Only Visible Cells in Excel. Today we will go through 4 quick ways to Sum Only Visible Cells. Frequently, we need to hide ...

How to Illustrate Relative Frequency Distribution in Excel

The Relative Frequency Distribution in Excel is a phenomenon where any numerical values symbolize the density of the occurred values within a range. ...

Labour Contractor Bill Format in Excel (Download Free Template)

In Microsoft Excel, we most of the time create formulas for each of our tasks. But sometimes we make formats for different tasks that perform a ...

How to Sum Only Positive Numbers in Excel (4 Simple Ways)

We can easily Sum a range of Excel datasheets. But, quite frequently we need to add the cell values following a condition. This article will show you ...

How to Calculate Cumulative Sum in Excel (9 Methods)

The Cumulative Sum is very commonly performed in Excel by many people all over the world. It is often called the Running Total/Balance. The ...

Keep 0 Before a Phone Number in Excel (6 Methods)

In some cases, a number starts with zero (0). Such as phone numbers, credit card numbers, product codes, postal codes, personal identification ...

Hotel Bill Format in Excel (Create with Easy Steps)

Hotel Bill format is an invoice format which you can use to create hotel bills for clients in order to document information about hotel services as ...

Shortcut for Sum in Excel (2 Quick Tricks)

From time to time, we store various types of data in Excel sheets, and most of the time we need to Sum up cell values. This article will show you ...

How to Calculate Sum of Squares in Excel (6 Quick Tricks)

Microsoft Excel provides us with the option to calculate the Sum of Squares very easily. We can also compute the Sum of Squares using mathematical ...

ExcelDemy
Logo