Advanced Excel

How to Convert Text to Columns in Excel with Multiple Spaces

The sample dataset is given below where the column named Name City Designation has mixed information using multiple spaces. We want to separate the ...

How to Create an Invoice in Excel with a Database – 5 Steps

    Step 1 - Create a Database This is a sample database.   Step 2 - Create an Invoice Template Select the following ...

CSV UTF 8 Not Available in Excel: 3 Solutions

Method 1 - Using Excel's Save As Option Steps: Go to the File tab. Choose the Save As option >> click the Browse button. ...

How to Encode Survey Data in Excel (Easy Steps)

Dataset Overview In the following dataset, we have data from a survey among some jobholders. We have gathered their gender, age, occupation, and ...

How to Perform Reverse Geocoding in Excel: 5 Methods

Method 1 - Open Microsoft Visual Basic Application from Developer Tab Go to the Developer tab of the ribbon From the Code group, select ...

What Is Metadata in Excel: All Things to Know

How to Add Metadata in Excel Steps: Open a new workbook. Go to the Data tab. Click on From Text/CSV on the Get & transform Data ...

How to Format Latitude and Longitude in Excel (Two Methods)

Dataset Overview In this tutorial, we’ll explore two methods for formatting latitude and longitude data in an Excel spreadsheet. Let’s assume you ...

How to Export Image Metadata to Excel (with Easy Steps)

The screenshot below is an overview of exporting file or image metadata to Excel. Step 1 - Download the ExifTool Open a browser. ...

How to Show Excel Metadata Viewer (4 Effective Methods)

What Is Excel Metadata? Metadata is the hidden information of an Excel file that contains the author's name, initials, organization name, etc. Every ...

How to Create an Order Form in Excel (with Steps)

  Step 1. Making a Customer List Table In the following dataset, List of Customers, there are column headers Customer Name, Street, City, and ...

How to Create a Fillable PDF from Excel (2 Suitable Ways)

  Method 1 - Manually Creating a Fillable PDF Form Using Excel   Step 1 - Create a Fillable Form Insert all the information that ...

How to Convert Address to Lat Long in Excel (2 Easy Methods)

Consider a dataset where the column B consists of various cities and columns C and D refer to the latitude and longitude of those locations. We'll ...

How to Convert ZIP Code to Latitude and Longitude in Excel

A ZIP (Zone Improvement Program) Code is a term used in the United States postal code system to define a specific location. Latitudes are horizontal ...

How to Use Google Translate Formula in Excel (with Easy Steps)

This article will walk you through how to use the translator dialog box from the Review tab to translate cells in Excel. Step 1. Making Data ...

How to Fix If Macros Security Warning Has Been Disabled (4 Solutions)

  Solution 1 - Solve Through the Context Menu   Steps: Open Windows File Explorer and move to the folder where you have saved the desired ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo