Excel Basics Archives - Page 3 of 11

How to Use Advanced Sorting Options in Excel

Sep 22, 2021 Excel Basics

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

How to Use Advanced Sorting Options in Excel

How To Sort Alphabetically In Excel And Keep Rows Together

Sep 22, 2021 Excel Basics

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)

Sep 22, 2021 Excel Basics

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)

Sep 22, 2021 Excel Basics

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

Aug 25, 2021 Excel Basics

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 in Excel Independently

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

Sep 22, 2021 Excel Basics

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 Filter Multiple Columns Simultaneously in Excel (3 Ways)

How to Copy and Paste in Excel Without Changing the Format

Sep 15, 2021 Excel Basics

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)

Sep 15, 2021 Excel Basics

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

Sep 15, 2021 Excel Basics

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

Sep 15, 2021 Excel Basics

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 ...

How to Copy a Formula in Excel with Changing Cell References

Excel Sort By Date And Time [4 Smart Ways]

Sep 21, 2021 Excel Basics

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]

Sep 20, 2021 Excel Basics

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

Sep 20, 2021 Excel Basics

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)

Sep 20, 2021 Excel Basics

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)

Sep 20, 2021 Excel Basics

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 ...