Advanced Excel

How to Create Mind Map from Data in Excel (2 Common Ways)

Looking for a way to create a mind map in Excel? You have landed in the right place. Although Excel allows a user to create charts and sparklines for ...

How to Create a Weekly Calendar in Excel (3 Suitable Ways)

If you have a weekly calendar, then you can do all your work more routinely. Furthermore, a weekly calendar will help you to maintain your daily ...

How to Filter by Color Using Conditional Formatting in Excel

While working in Excel, we often need to filter our data by color that is formatted by conditional formatting. Utilizing the conditional formatting ...

How to Create Button Without Macro in Excel (3 Easy Ways)

In this article, we will learn to create a button without a macro in Excel. Usually, users create a button in Excel with the help of a macro to ...

How to Create a Yearly Calendar in Excel (with Easy Steps)

An Excel calendar could be pretty helpful if you prefer to plan ahead and have a busy schedule. Remembering this, in this article, we’ll go through ...

How to Combine Two Tables Using Power Query in Excel

Sometimes, you need to combine two tables in Excel. You can do it manually, but that takes a lot of valuable time. Instead of doing this manually, ...

How to Auto Refresh Excel File Without Opening (2 Easy Ways)

Often, users need auto-refresh of Excel files that contain volatile functions or Query Connections. Only VBA Macros do auto-refresh Excel files ...

How to Apply Different Types of Conditional Formatting in Excel (5 Different Types)

Conditional Formatting is a must-be-used feature of Microsoft Excel for better statistical analysis and visualization of data. This feature is mainly ...

How to Break Links in Excel When Source Is Not Found (4 Ways)

In Microsoft Excel, working with multiple workbooks is a common task. You may have connections or links between these workbooks. It helps to ...

How to Filter by Multiple Colors in Excel (2 Ways)

Filtering by multiple colors in Excel means displaying only the rows with some specific color formatting applied to cells. It allows you to analyze ...

Excel Filter by Color and Text (with Easy Steps)

This article illustrates how to filter by color and text in Excel. You can easily filter by color text in Excel. But there is no direct way to do ...

How to Auto Update with Interval 5 Seconds in Excel

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default ...

How to Trace Dependents Across Sheets in Excel (2 Easy Ways)

Many times, in Excel, users use formulas to show desired values. The results from this formula depend on other cell values on that particular sheet ...

How to Create Multi Level Hierarchy in Excel (2 Easy Ways)

While working in Excel, we often need to create multi level hierarchy. By using a multi level hierarchy, we can represent our data in a simple and ...

How to Trace Errors in Excel (with Quick Steps)

Excel is mighty for large data handling and calculations. Now, when working with extensive calculations, anyone might encounter some errors. It might ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo