Latest Blog Posts

How to Make a Population Density Map in Excel (2 Quick Methods)

Population density refers to the population per unit area of land. A population density map gives us an idea of the worldwide population. It shows ...

Excel Data Validation Greyed Out: 4 Reasons with Solutions

Method 1 - Excel File Is Protected or Shared If the Excel file is in protected view or has been shared by others, the Data Validation window may be ...

How to Convert XML to Excel Table (3 Easy Methods)

What Is an XML File? An XML file can store data in a readable format for different applications and systems. XML stands for Extensible Markup ...

How to Concatenate If Cell Values Match in Excel (7 Easy Ways)

To demonstrate our methods we'll use the following dataset, containing columns for State and Sales Person. We'll concatenate the values in the Sales ...

How to Export Data from Excel to Google Sheets (2 Easy Ways)

For various purposes, you may need to get data from Excel to Google Sheets. In this article, I will show you how you can import data from Excel to ...

How to Attach an Email in Excel (Useful Steps)

Dataset Overview We'll use a dataset named Attaching Email with column headers Name, State, Sales and Profit. Step 1 - Selecting the Cell ...

How to Copy Only Highlighted Cells in Excel (3 Quick Tricks)

In this article, we will demonstrate 3 quick ways to copy highlighted cells to a new worksheet in Excel. To illustrate the methods, we'll use the ...

[Solved] Excel Copy Paste Loses Formatting

When you copy and paste data in a worksheet, sometimes Excel loses formatting after performing the task. There are several ways how you can avoid ...

How to Use Food Cost Percentage Formula in Excel: 3 Methods

Method 1 - Calculating Total Food Cost Percentage Formula for Cost per Meal   Steps: Select cell C8. Write the following formula into the ...

How to Convert Text Filter to Date Filter in Excel (3 Examples)

The basic method to convert a text filter to a date filter in Excel is simple - just disable the text filter first, then move on to work with the ...

Pros and Cons of Google Sheets vs Excel – Which Is Better?

Google Sheets and Microsoft Excel are both powerful spreadsheet applications, but they differ in several aspects. In this article, we will explore ...

How to Copy from Excel and Paste to Google Sheets with Formulas

When working with Excel files, sometimes we need to copy data to Google Sheets for more people’s access. But when copying from Excel by default, the ...

How to Find Column Index Number in Excel VLOOKUP: 2 Methods

1. Find and Insert VLOOKUP Column Index Number Manually Find the column index number and then insert that in the formula manually in the VLOOKUP ...

How to Copy Paste Vertical to Horizontal in Excel (2 Easy Ways)

  Let's use a daily Sales Report of a fast-food shop to demonstrate vertical-to-horizontal copying. Columns B, C, and D of this dataset ...

How to Copy Chart Format in Excel (3 Easy Ways)

This is our sample dataset. The image below shows Year vs Sales curve generated from the dataset. The next image is the Year vs Profit ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo