Advanced Excel

How to Do Conditional Formatting in Excel [Ultimate Guide]

Excel Conditional Formatting feature formats any cell or cell range’s number type, font styles, cell border, and fill color based on a condition. ...

How to Make a Gantt Chart in Excel (with Easy Steps)

Gantt chart is used basically in project management. You cannot create a Gantt chart in Excel in a direct way. But don't worry, you can make an ...

What-If Analysis in Excel (Definition and Types)

What-If analysis in Excel means exploring different scenarios by adjusting input values to observe their impact on formulas, results, and data ...

How to Monitor Cells Using Excel Watch Window (An Easy Guide)

Sometimes we have a great deal of data in the workbook. Everything is important but most important is the last row of the data containing, say, the ...

19 Practical Data Cleaning Techniques in Excel

With data entry and organization, Microsoft Excel can also perform beginner to intermediate-level data analysis easily nowadays. For our everyday ...

How to Do Automated Data Cleaning in Excel (10 Easy Tips)

Looking for ways for automated data cleaning in Excel? Then, this is the right place for you. Sometimes, the data we get is not clean and ready for ...

How to Get Filename from Path in Excel (7 Simple Methods)

While working in Microsoft Excel sometimes we need to extract filename from a given path to work more effectively. This might seem difficult as the ...

How to Use Flash Fill in Excel (7 Easy Examples)

Flash Fill is one of the most important features in Excel. The beauty of Flash Fill is that separation happens within a flash and does not need any ...

Find and Highlight Duplicates in Excel (3 Handy Ways)

Looking for ways to find and highlight duplicates in Excel? Do not worry, we are here for you. In this article, we will describe 3 easy ways to do ...

How to Find & Remove Duplicate Rows in Excel

One very common use of Excel is: that it is used as a tool to clean up data. Cleaning up data means: Getting raw data into a worksheet ...

How to Import Text File to Excel (5 Easy Ways)

Importing text files into Excel can be a powerful way to bring data from external sources into your Excel workbooks. This can include data from ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo