Latest Blog Posts

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

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

A CSV File is Not Opening Correctly in Excel – 4 Cases with Solutions

Case 1 - A CSV File Is Opening in One Column When the delimiter is not properly set, Excel may open CSV files in one column. Open the CSV file ...

Merge CSV Files into Multiple Sheets in Excel (with Easy Steps)

  We have three individual Excel workbooks for grade 6, grade 7, and grade 8 report cards for various subjects for multiple students. The ...

How to Calculate Contribution Percentage with Formula in Excel

    Method 1 - Calculate the Contribution Percentage Based on Age Bands with the SUM Function In the dataset below, we will ...

How to Link Excel to Word for Automatic Updates

Dataset Overview Assume you have the following Excel dataset containing store-wise sales. Step 1 - Enable “Update Automatic Links at ...

How to Save Excel File as CSV with Commas (3 Suitable Methods)

  What Is a CSV? CSV or Comma-Separated Values stores the values as text strings separated by commas. Various software and programming ...

Combine CONCATENATE & TRANSPOSE Functions in Excel

Introduction to the CONCATENATE Function Syntax: =CONCATENATE(text1,,...) Argument: text1– the first text, number, or array you ...

How to Convert 13 Digit Timestamp to Date Time in Excel (3 Methods)

Dataset Overview A Unix timestamp indicates the amount of time that has passed since January 1, 1970 (epoch time). When the timestamp has 11 digits, ...

How to Copy Table from Excel to Word (3 Easy Ways)

In this article, we’ll demonstrate 3 easy methods to copy a table from Excel to Word. To illustrate our methods, we'll use the following dataset, a ...

How to View a CSV File in Excel – 3 Methods

Consider the following dataset containing Customer Information: Name, Id, and Email Id. This file was saved as a CSV file. To view it in Excel: ...

How to Convert Gregorian to Julian Date in Excel – 3 Easy Methods

Julian Date in Excel Julian dates are expressed as 5-digit numerals, the first two representing the year and the final three, the day. Gregorian ...

How to Edit VCF File in Excel (with Easy Steps)

This article shows a step-by-step guide on how to edit VCF file in Excel, as well as in Notepad. We have used the Microsoft 365 version of Excel ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo