Advanced Excel

How Can You Create Alerts in Excel? (4 Practical Examples)

In this Excel tutorial, we will demonstrate how to set up alerts in Excel. To create alerts, you can use conditional formatting, IF, AND, and ...

How to Export Excel to XML? (An Ultimate Guide)

Exporting data from Excel to XML (Extensible Markup Language) is a valuable process that enables the interchange of structured information between ...

How to Export Excel to CSV?

In this article, you’ll learn how to export an Excel file to a CSV file using 4 methods. The methods include exporting only the active sheet using ...

Export Excel to txt (Ultimate Guide)

In this article, we will discuss how to export Excel to txt (or .txt) files. We will present the process to export a single sheet (active sheet) or ...

How to Import vCard File to Excel

Importing vCard to Excel is essential to consolidating and organizing contact information in a spreadsheet format, sorting and filtering data, as ...

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. Utilizing this strategy, you ...

How to Import HTML into Excel (3 Easy Ways)

In this article, we will learn to import HTML into Excel. Excel is an excellent tool for managing data, and data comes in various formats. One of ...

Protect Workbook in Excel (6 Ways)

In this article, you will learn how to protect a workbook in Excel. Throughout this article, we will discuss a total of 6 effective ways to protect a ...

RegEx in Excel (For Matching, Extracting and Replacing)

In this Excel tutorial, you will learn how to use RegEx in Excel.  We will first learn about RegEx and then explore how we can use different VBA ...

How to Use Geocoding in Excel? (2 Practical Examples)

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

Text Box in Excel (A Complete Overview)

A Text Box is a rectangular-shaped object in Excel that can hold and display texts within a specific area of a worksheet. In this Excel tutorial, ...

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

Mail Merge is a feature in Microsoft Word that enables you to add personal details like name and address from a database (Like Excel, SQL Server ...

Excel Drop Down List: Create, Edit, Remove, Filter, Protect, etc.

An Excel drop down list is a feature that allows users to select an element from a list of options. It is used to create a list of homogeneous ...

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

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

Data Validation in Excel: A Complete Guideline

Data validation in Excel refers to the process of restricting or controlling the types of data that can be entered into a cell or range of cells. It ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo