Advanced Excel

How to Create a Workflow Management Template in Excel – 6 Steps

Step 1 - Prepare the Work Plan Timeline Enter the data Headlines. Enter the Project name and the tasks. Enter the names of the workers ...

How to Set Alarm Clock in Excel (3 Easy Methods)

In this article, I will show you how to set an alarm clock in Excel. While working in Excel, we may want to remind ourselves of something important ...

How to Perform the Left Join in Excel – 3 Methods

There are 2 datasets below. The first dataset contains Product ID and Name. The second one contains Product Name, salesperson's name, and value of ...

How to Create Dynamic Tooltip in Excel (with Easy Steps)

Step 1 - Use Formula to Fetch Data from Another Sheet In a new worksheet, create a data table with columns L No and Name. In the first column, ...

How to Add Cell Tooltip in Excel (3 Easy Methods)

Consider a worksheet where we have a list of grocery items. In this list, in one column, we have the item name. In another column, the price per unit ...

How to Perform an Outer Join in Excel – 2 Methods

Consider the List of Customer Orders containing the “Product ID”, “Customer”, and “Date”. Mind this List of Products and Sales with “Product ...

How to perform an Inner Join in Excel – 2 Methods

Consider two tables with examination marks in math and physics. Method 1 - Applying the VLOOKUP Function to perform an Inner Join ...

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 an Excel Data Connection to Another Excel File – 3 Methods

This is the sample dataset. Method 1 - Using the Connections Function to Create an Excel Data Connection to Another Excel File   ...

Create an Excel Data Entry Form That Includes Checkboxes

In this article, we will demonstrate how to create an Excel data entry form that includes checkboxes, such as a To-Do list or checklist. We'll also ...

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 a Multi-Product Break-Even Analysis in Excel (Step-by-Step Guide)

  The following dataset contains information on per-unit sales, per-unit variable expenses, and the expected sale ratio of 3 products, along ...

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)

The screenshot below represents a digital running clock in Excel. In the following sections, we’ll explore the process of preparing this and another ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo