Advanced Excel

How to Fix If Data Connection Is Not Refreshing in Excel (3 Solutions)

  Solution 1 – Inputting Accurate Data When Importing a File Destination Steps: In the Data tab, click on the Edit Links command from the ...

How to Remove Floating Cells in Excel (3 Easy Ways)

In this article, we will learn how to remove floating cells in Excel. Floating cells mean their contents float over adjacent cells. Floating cells ...

Create an Alternative to the Datepicker in Excel – 2 Easy Methods

The datepicker feature of Microsoft Excel is only available for the Windows 32-bit version. This is the sample dataset. Method 1 - Use ...

How to Perform Pattern Matching in Excel – 2 Methods

This is the sample dataset. Check if the texts follow this pattern: The total character length is 9. The first 3 characters are uppercase ...

How to Filter Using RegEx in Excel (with Simple Steps)

We have the Store Location of different cars in different stores. The Serial Number follows a RegEx pattern but there are some cars that have the ...

How to Anchor Cells in Excel (with Easy Steps)

If you are looking for how to anchor cells in Excel, then you are in the right place. While using Excel, we often need to use formulas where we have ...

How to Calculate Bootstrapping Spot Rates in Excel (2 Examples)

  Example 1 - Bootstrapping Spot Rates for Annual Bond The below dataset, Yield to Maturity of Annual Treasury Bond, includes the Par Value, ...

Anchoring Columns in Excel (2 Efficient Ways)

In Excel, we often need to do various types of mathematical calculations. Anchoring columns is a common practice when performing these calculations. ...

Data Validation with RegEx in Excel (With Easy Steps)

In Microsoft Excel, there is no inbuilt function named RegEx. Rather we have to create it manually in the workbook. This function is required to ...

How to Extract Data from Multiple Web Pages into Excel

The dataset we will use has two columns called Year and URL, which link to articles of top movies for the respective year. We will use those URLs to ...

How to Create an Audit Checklist in Excel (With Easy Steps)

  An Overview of an Audit Checklist In the following picture, you can see an overview of an Audit Checklist. We will show you how you can ...

How to Resample Time Series in Excel (3 Examples)

Dataset Overview Here, we have the following time series and the gap between time is 0.1, starting from 0 to 10. With respect to these time periods, ...

How to Find and Replace RegEx Patterns in Excel (3 Examples)

User-Defined Function in Excel VBA That Will Find and Replace RegEx Patterns VBA Code: Public Function Find_Replace_RegEx(main_txt As String, pat ...

[Solved!]: Cannot Open Encrypted Excel File (2 Quick Fixes)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we ...

How to Import a Table from a Website to Excel (2 Easy Ways)

We will explore a sample website from which we will fetch a table. In this case, we will visit microsoft.fandom.com. The following website has a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo