Advanced Excel

How to Export Excel to XML – A Guide

Introduction to Extensible Markup Language (XML) XML, a markup language similar to HTML, is specifically designed to store and transport data. Here ...

How to Export Excel to CSV – 4 Methods

This is an overview: Download Practice Workbook Download the Excel files. Excel CSV.xlsm Excel CSV.csv Excel CSV ...

Export Excel to txt (Ultimate Guide)

Download Practice Workbook Export Excel to txt.xlsm A dataset similar to the following is present in each sheet of the sample workbook. ...

How to Import a vCard File to Excel – 2 Methods

Consider a vCard or VCF file named Alberto Ria. Import the vCard file to an Excel spreadsheet. What is a vCard file? A vCard file, also ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo