Advanced Excel

Export Folder Structure to Excel: 3 Suitable Ways

Method 1 - Export Folder Structure Using Power Query Select the Data tab > Get Data > From File > From Folder. Locate and open ...

Create Outlook Folders from Excel List (Step-by-Step Guide)

In this article, we will discuss how to create Outlook folders from an Excel list. We use Outlook primarily for managing email messages, scheduling ...

How to Hide Filter Buttons in Excel

We often use Excel to maintain databases in our day-to-day life. In some cases, we need to filter our data based on specific conditions. This can be ...

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

If you want to navigate through multiple levels or categories of a dataset, then Drill Down Chart is the best possible option for you. In Excel, it ...

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

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 Create Data Validation with Checkbox Control in Excel

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

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

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 ...

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

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. ...

Insert Drop Down Calendar in Excel Without Date Picker

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 ...

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

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 Perform Bootstrapping in Excel (with Easy Steps)

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

How to Use Auto Filter and Advanced Filter in Excel

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)

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

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

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

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo