Advanced Excel Archives - Page 16 of 62

How to Make an Excel Metadata Extractor (with Easy Steps)

Nov 11, 2025

When you develop, download, or upload a Microsoft Excel workbook, it may contain information that you do not want to make public online. The formal ...

How to Make an Excel Metadata Extractor (with Easy Steps)

How to Create Data Validation with Checkbox Control in Excel

Jul 13, 2024

Scenario Imagine we have an empty dataset for ABC Company’s sales data. Our objective is to populate this dataset using data validation with ...

How to Create Data Validation with Checkbox Control in Excel

Excel Queries and Connections Are Not Working: 4 Possible Reasons with Solutions

Jul 6, 2024

Method 1 - The Source Has Not Been Saved Properly If you don’t save the source file correctly, the Excel Queries and Connections won’t work ...

Excel Queries and Connections Are Not Working: 4 Possible Reasons with Solutions

How to Create Cross Join in Excel (3 Simple Ways)

Jul 3, 2024

The sample dataset contains the Color and Sizes of a t-shirt. We will Cross Join these tables to get all the available variations of that t-shirt. ...

How to Create Cross Join in Excel (3 Simple Ways)

Insert Drop Down Calendar in Excel Without Date Picker

May 29, 2024

Step 1 - Prepare Calendar Layout Prepare the layout of the outline of the calendar. Place the date and month on the sheet. The date and ...

Insert Drop Down Calendar in Excel Without Date Picker

How to Make Dynamic Drop Down List from Another Sheet in Excel

Nov 11, 2025

When you work with a large set of data, your data may disperse in several sheets of your Excel file. A dynamic drop-down list can help you to ...

How to Make Dynamic Drop Down List from Another Sheet in Excel

How to Perform Bootstrapping in Excel (with Easy Steps)

Jul 16, 2024

Introduction to Bootstrapping Bootstrapping is a method of constructing a confidence interval for a statistic with the following features: The ...

How to Perform Bootstrapping in Excel (with Easy Steps)

How to Use Auto Filter and Advanced Filter in Excel

Nov 11, 2025

Today, we will discuss how to use Auto Filter and Advanced Filter in Excel. The Auto Filter is the default filtering option in Excel. It allows users ...

How to Use Power Query Date Functions in Excel (3 Examples)

Aug 2, 2024

Consider the dataset below. Some products of an online store, their order, and delivery dates are provided. Example 1 - Getting the Year, ...

How to Use Power Query Date Functions in Excel (3 Examples)

How to Do Multidimensional Scaling in Excel (with Detailed Steps)

Nov 11, 2025

Multidimensional Scaling is a way to visually present the similarity between objects (brands, product attributes, etc.) in a 2-dimensional scale, ...

How to Do Multidimensional Scaling in Excel (with Detailed Steps)

How to Use an Advanced Filter for a Date Range in Excel – 2 Methods

Aug 2, 2024

The dataset showcases the sales quantity of electronic products on different dates in January, February and March 2022. Method 1- Use the ...

How to Use an Advanced Filter for a Date Range in Excel – 2 Methods

How to Use Advanced Filter with Wildcard in Excel

Nov 11, 2025

In this article, I will show you how to use the Advanced Filter with Wildcard in Excel. As we know, sometimes we need to use the Excel Advanced ...

How to Use Advanced Filter with Wildcard in Excel

How to Remove an Advanced Filter in Excel – 5 Methods

Aug 11, 2024

The dataset represents a duty roster. Advanced Filters were applied. To know if a dataset is Advanced filtered, look at the row index numbers. If ...

How to Remove an Advanced Filter in Excel – 5 Methods

How to Perform Left Outer Join in Excel (2 Easy Methods)

Jul 6, 2024

This tutorial will demonstrate how to perform left outer join to merge data tables in Excel. We’ll use the sample dataset below, which contains ...

How to Perform Left Outer Join in Excel (2 Easy Methods)

How to Create an Analog Clock in Excel (with Easy Steps)

Jul 5, 2024

Step 1: Setting up Hours, Minutes, and Seconds Click on cell C5 and enter the following formula: ...