Advanced Excel

How to Create Alerts in Excel – 4 Examples

This is an overview. Download Practice Workbook Create Alerts.xlsm Example 1 - Using the Conditional Formatting to Set Up ...

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

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo