Advanced Excel

How to Send Email from Excel?

Send Email from Excel: Knowledge Hub How to send excel file to email automatically Automatically send emails from excel based on cell content ...

Translate in Excel: An Inclusive Guideline

In this article, we will learn the ins and outs of how to translate in Excel. We will cover how to use the built-in translator, make use of Excel ...

How to Perform XML Mapping in Excel?

In this Excel tutorial, you will learn how to - Perform mapping in Excel - Import XML data after mapping - Remove the XML map We have used ...

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

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

Excel Shapes

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo