Excel Basics

How to Insert PDF as Image in Excel (2 Simple Ways)

In terms of working with Microsoft Excel, we might face the necessity of inserting a PDF file in Excel. It is nothing unusual. We can insert the PDF ...

How to Copy Every Nth Row in Excel (3 Easy Methods)

We will use the following dataset to highlight the methods to copy every nth row in Excel. Method 1 - Use OFFSET and ROW Functions ...

How to Copy File Names from Folder to Excel (4 Easy Methods)

Here’s our sample dataset which contains 5 files in a folder named ExcelDemy. We'll copy the names to an Excel sheet. Method 1 - Using the ...

How to Insert an Excel File into Another Excel File

To demonstrate how to insert one Excel file inside another, we'll use the following two Excel files. The first contains Sales of Febuary for some ...

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

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 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 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 Edit Comment in Excel (Including More Features)

When you are sharing an Excel file with someone else, you might need to share some information, express your feelings or concerns, and ask questions ...

How to Copy a Chart from Excel to Word (3 Easy Ways)

Have you ever found yourself spending too much time manually recreating charts in Microsoft Word that you've already created in Excel? Fear not, ...

How to Insert Picture in Excel Comment (with Easy Steps)

  We'll use a dataset of some Students along with their Country of origin. Note: In the Microsoft Excel 365 version, Comments are ...

How to Insert a Multiple Page PDF into Excel – 2 Methods

Method 1 - Inserting a Multiple Page PDF File as a Text Object Steps: Open an excel file. In the Insert tab, click Text and select Object. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo