Advanced Excel

How to Set Floating Picture in Excel (with Easy Steps)

In this article, I will show how to set a floating picture in Excel. In many situations, we need to keep a picture side by side when scrolling ...

How to Edit Tooltip in Excel (2 Easy Methods)

If you want to edit tooltip in Excel, you have come to the right way. Here, we will walk you through 2 easy methods to do the task smoothly. ...

How to Create Excel Data Connection to Another Excel File

In this article, I will show how to create an Excel data connection to another Excel file by using 3 easy methods. When you work on an Excel ...

Create an Excel Data Entry Form That Includes Checkboxes

In this article, we will learn how to create an Excel data entry form that includes checkboxes. Sometimes, users need to make a To-Do list or ...

How to Find RegEx Patterns in Excel (2 Suitable Methods)

When it comes to finding one substring in another, Microsoft Excel offers users a number of options, including the Find and Replace tool and a few ...

How to Do Multi Product Break Even Analysis in Excel

If you are heading to a new business, then you should know the calculation of the multi-product break-even analysis. So, if you are looking for how ...

How to Calculate Break Even Sales with Formula in Excel

If you run a business or work for a company, knowing the profit margin is important. For this, you need to conduct break-even analysis. In this ...

How to Make a Running Clock in Excel (2 Easy Ways)

Undoubtedly, while working in Excel, we may need a timer that displays the time within the worksheet. Sounds complex, right? Wrong! In this article, ...

How to Create 3D Animation in Excel

If you want to create 3D animation in Excel, you have come to the right place. Here we will walk you through 2 easy methods to do the task smoothly. ...

How to Apply UTF 8 Encoding on CSV File in Excel

In this article, we will talk about how to apply UTF 8 encoding on a CSV file in Excel. Thus, users will be able to encode the CSV file and transfer ...

How to Create Drill Down in Excel (with Easy Steps)

While working with a large amount of data, one might need to filter only a fraction of the whole data for various purposes. Excel can be a very ...

How to Refresh Data Connection in Excel Without Opening File

Microsoft Excel is a powerful software. We can carry out a variety of operations on a given dataset using Excel's tools and capabilities. We need ...

How to Export File Metadata to Excel (3 Effective Methods)

In this article, we will discuss how to export file metadata to Excel. The metadata of the file contains the necessary information regarding the ...

[Fixed!] External Data Connections Have Been Disabled in Excel 

While working in Excel, we often encounter a warning message like this, "External Data Connections have been disabled" when we open an Excel file. A ...

How to Calculate Break Even Analysis with Formula in Excel

This tutorial will demonstrate how to calculate break-even analysis using formula in Excel. Break-even is one of the most important parameters for ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo