Latest Blog Posts

How to Rename Legend in Excel (2 Useful Methods)

If you are looking for how to rename legend in Excel, then you are in the right place. While using Excel, we often need to use charts of various ...

How to Create Bi Weekly Budget in Excel (2 Useful Methods)

Method 1 - Creating a Biweekly Budget in Excel Manually Here's the overview of the biweekly budget we'll make. Step 1 - Add Headings on ...

How to Copy and Paste from Excel to Google Sheets (4 Ways)

To illustrate, let's assume the Fruit Sales Data shown in the B4:E13 is what we want to copy and paste from Excel to Google Sheets. Method ...

How to Convert a Date to a Quarter and Year in Excel (3 Methods)

Dataset Overview We'll use a dataset called the Product arrival Date of ABC Shop to demonstrate these methods. This dataset consists of two columns ...

How to Concatenate Cells with If Condition in Excel (5 Examples)

  Method 1 - Concatenate with Ampersand and IF Condition We can see some blank cells in the “middle name” column. In the fourth column, we ...

How to Open VCF Files in Excel (2 Methods)

What are VCF Files? VCF files store business contact information and are commonly known as vCards. Although Excel lacks built-in support for .vcf ...

How to Export Data from Excel to vCard (2 Simple Methods)

The dataset below contains people’s Names, Mobile numbers, and Email addresses. We will use this data to create vCard files. Method 1 – ...

How to Set Column Width in Inches in Excel (with Easy Steps)

We frequently need to adjust the column width in Excel. In this article, you will learn about two quick steps for how to set column width in inches ...

How to Attach Zip File in Excel (3 Methods)

Method 1 - Attach Zip File as an Icon Select a cell in the worksheet where you want to place the zip file. Go to the ribbon and choose ...

How to Save a Copy of an Excel File: 3 Easy Methods

Method 1 - Applying Keyboard Shortcuts to Save a Copy of an Excel File Steps: Create an Excel file like the below screenshot. Ppress  ...

Excel VBA: Merge Multiple CSV Files into One Workbook 

It is very common to convert CSV files to Excel files. In this article, you will learn how you can Merge Multiple CSV Files into one Excel Workbook ...

How to Convert Alphabet to Number in Excel – 4 Easy Methods

This is the sample dataset. Method 1 - Converting Single Alphabet letters to Numbers in Excel 1.1 Using the COLUMN Function STEPS: ...

How to Calculate Confidence Interval Proportion in Excel

When you want to gather any formation based on a large population, things get difficult sometimes to capture this huge number of people. In that ...

How to Insert Digital Signature in Excel (3 Quick Methods)

Suppose we have a dataset of a company’s Product Name and the Remaining Stock for the products. Let's insert a digital signature, using 3 different ...

How to Copy CONCATENATE Formula in Excel (5 Easy Ways)

While working in Excel, we often need to copy CONCATENATE formula to join multiple text strings. If you are finding difficulties to copy CONCATENATE ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo