Advanced Excel

How to Import XML Data File into Excel (3 Quick Methods)

Importing XML data files into Excel allows you to integrate structured data from various sources into your spreadsheets to take advantage of Excel's ...

How to Import HTML into Excel (3 Easy Ways)

Download the Practice Workbook Import HTML.xlsx Method 1 - Use the Data Tab to Import HTML from Existing Connection Save an HTML ...

Text Import Wizard Excel

We often need to import data in our Excel worksheet from a different file. The Text Import Wizard Excel is a feature that allows you to simplify the ...

Protect a Workbook in Excel – 6 Methods

This is an overview. Download Practice Workbook Download the practice workbook here: Here's the password- 12345. Protecting ...

RegEx in Excel (For Matching, Extracting and Replacing)

Here's an example of using a User-Defined Function to apply RegEx in Excel. Download the Practice Workbook RegEx in Excel.xlsm ...

How to Use Geocoding in Excel – 2 Examples

Geocoding is the process of converting addresses or place names into geographic coordinates. Geographic coordinates are latitude and longitude. ...

Excel Shapes

Excel Shapes: Knowledge Hub Inert Shape in Excel Align Shapes in Excel Excel VBA Shape Position << Go Back to Learn Excel

Data Entry in Excel (Basic, Form Creation & Error Handling)

In this article, we are going to learn about data entry in Excel. We will learn about the basics of data entry, form creation, and error handling. ...

Text Box in Excel – A Complete Overview

The sample dataset contains sales of different accessories in different locations. The text box below showcases a summary of the dataset, displaying ...

Mail Merge in Excel – Purposes, Procedure, Uses & Limitations

Mail Merge is a powerful feature in Microsoft Word that allows you to personalize and send the same document (such as emails or letters) to multiple ...

Excel Drop-Down Lists: Create, Edit, Remove, Filter, Protect

  The dataset showcases online shopping information: ‘Order ID’, ‘Customer Name’, ‘Device’, ‘Order Date’, ‘Delivery date’, and ‘Payment ...

Database in Excel: Definition, Types, Creation, Free Templates

Database in Excel means gathering and arranging information on individuals, products, demands, transactions, etc. In this Excel tutorial, you will ...

Progress Bar in Excel

Progress Bar in Excel: Knowledge Hub Create a Progress Bar in Excel Show Percentage Progress Bar in Excel Progress Bar Based on Another ...

Data Validation in Excel: A Complete Guideline

In this tutorial, you will learn everything about Data Validation from its purpose to how to apply it in your Excel worksheet. In the image ...

How to Copy Conditional Formatting in Excel

Copy Conditional Formatting in Excel: Knowledge Hub Copy Conditional Formatting to Another Cell Copy Conditional Formatting Color to Another ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo