Excel Basics

How to Use Advanced Sorting Options in Excel

Excel has Advanced Sorting options that can help you to perform multi-level sorting within a large database. Sometimes alphabetical or numerical ...

How To Sort Alphabetically In Excel And Keep Rows Together

One of the common tasks you may have to do in Excel is sorting data. While performing sort you may face the situation where you need to organize data ...

How to Swap Rows in Excel (2 Methods)

While working in Excel we might need to re-arrange data between rows and cells. Sometimes there is a possibility when you need to swap your data ...

How to Auto Sort Multiple Columns in Excel (3 Ways)

Data sorting is an amazing tool to arrange your information systematically as per your requirements. There are many cases when we need to sort ...

How to Filter Multiple Columns in Excel Independently

If your Excel worksheet contains a lot of data then it can be hectic to find information quickly. To facilitate this problem, the Filter of Excel can ...

How to Filter Multiple Columns Simultaneously in Excel (3 Ways)

Filtering data is a great way to find information quickly especially when the worksheet contains a lot of input. When you filter a column then the ...

How to Copy and Paste in Excel Without Changing the Format

Today I will be showing how you can copy and paste in Excel without changing the format. How to Copy and Paste in Excel Without Changing ...

How to Copy Excel Sheet with Formulas to Another Workbook (5 Ways)

While working in Excel, it is a very common problem. We have to copy one or more Worksheets from one workbook to another. Today I am going to show ...

Copy Formula in Excel by Changing Only One Cell Reference

Sometimes we may need to copy formulas in MS Excel where there is a need to change only one cell reference. Generally, most of the time, we need to ...

How to Copy a Formula in Excel with Changing Cell References

Do you need to copy formulas or functions in excel with or without changing cell references? There are lots of ideas and techniques to do it without ...

Excel Sort By Date And Time [4 Smart Ways]

Sorting implies rearranging data for getting a better visual presentation of your dataset. It is such a powerful tool that can organize text, ...

How to Apply Multiple Filters in Excel [Methods + VBA]

Filtering becomes indispensable when you have a larger and complicated dataset. Retrieving the desired data is quite time-consuming from such a ...

How to Sort Columns in Excel without Mixing Data

How often do you need to sort in Excel? The generic answer is, “Every now and then”. Sorting is one of the most common tasks while dealing with data. ...

Excel Compare Text in Two Columns (7 Fruitful Ways)

Comparing text in two columns in Excel is a significant task in our daily life especially when you have to find something compared to the given text. ...

How to Add 30 Days to a Date in Excel (7 Quick Methods)

In Microsoft Excel, by using different functions you can easily add 30 or any number of days to a particular date. In this article, you'll learn a ...

ExcelDemy
Logo