Excel Basics

How to Group Time Intervals in Excel (3 Suitable Ways)

When we work with time data in Excel, we may need to group time intervals. We can do that in many ways. Of them, I will show the quickest and easiest ...

How to Find Outliers in Excel (5 Useful Ways)

While dealing with datasets in Excel, it is often required to find outliers from the dataset. In this article, we are going to learn 5 effective ...

Formula to Create Email Address in Excel (2 Suitable Examples)

Nowadays, companies need to create email addresses for their employees very often. It is tiring and time-consuming to create email addresses one by ...

How to Make a Tally Chart in Excel (3 Easy Methods)

For working advantages in Microsoft Excel we use different types of charts. Of them, the tally chart is a valuable one to mark numbers or ...

How to Sort Excel Sheet by Name (4 Easy Methods)

If you want to sort Excel sheet by name, this article is for you. Here, we will walk you through 4 easy and effective methods to do the task ...

How to Make an Address Book in Excel (An Ultimate Guide)

We can use Excel templates for our daily necessary usage. Instead of using Notes or MS Word, making an address book in excel is quite easy and very ...

How to Calculate Outliers in Excel (5 Ways)

Outliers may need to be identified in order to do statistical computations on data from a data set. You can discover outliers from huge datasets ...

How to Organize Expenses in Excel (3 Templates)

If you are searching for ways to organize expenses in Excel, then this is the right article for you. If we organize our expenses well, we can ...

How to Group Columns Next to Each Other in Excel (2 Easy Ways)

In this article, we will learn to group columns next to each other in Excel. Unfortunately, you can’t start a new group right next to another group ...

How to Reverse the Order of Worksheets in Excel (3 Easy Ways)

There is no limit to how many sheets you can have in an Excel workbook. Overall, it is limited by the available memory of your system. And it is very ...

How to Organize Data in Excel from Lowest to Highest (with Quick Steps)

In the middle of heaps of data and information, it is difficult to discern the relative importance of data between them. For better clarity and ease ...

How to Format Addresses in Excel (4 Easy Methods)

When we copy some addresses from a different file, it is stored in a single cell. As a result, we need to format them in the perfect order for the ...

How to Calculate Average Excluding Outliers in Excel (4 Easy Methods)

The average of a range of data doesn’t always illustrate the perfect pictures. Sometimes there are outliers in the range that causes a deviation from ...

How to Organize Time in Excel (5 Easy Ways)

If you are searching for ways of how to organize time in Excel, this is the right place for you. Sometimes, we have to organize the dataset according ...

How to Group Worksheets in Excel (3 Easy Ways)

Whenever someone is working with a very large dataset, grouping worksheets help to perform tasks more easily. In Microsoft Excel, if you have the ...

ExcelDemy
Logo