Latest Blog Posts

CONCATENATE vs CONCAT in Excel (2 Ideal Examples)

Introduction to the CONCATENATE Function Summary The CONCATENATE function in Excel combines multiple text values or numeric values into a single ...

How to Create Weekly Comparison Chart in Excel

Step 1 - Create a Dataset Create a dataset to create a weekly comparison chart in Excel. We have created a dataset with sales data for 3 ...

How to Create CSV File from Excel (6 Easy Ways)

CSV, short for Comma Separated Values, is a widely used file format used to store delimited records in plain text. It is often used to transfer data ...

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

How to Attach Documents in Excel (3 Suitable Ways)

Undoubtedly, Excel is a popular and useful tool for summarizing large sets of data. Now, wouldn’t it be great if we could attach documents in Excel? ...

How to Calculate Confidence Interval Without Standard Deviation in Excel

The article will show you how to calculate Confidence Interval without standard deviation in Excel. Basically, it’s easy to determine the Confidence ...

How to Extract Data from XML File to Excel: 2 Easy Ways

How to Extract Data from XML to Excel: 2 Easy Ways We will extract data from the XML file to Excel using both the Data and Developer tabs. ...

How to Select an Entire Column in Excel (5 Quick Methods)

While working in Microsoft Excel sometimes we need to select an entire column so that we can edit and organize data according to our choice. It might ...

How to Change Author Name in Excel Comments (3 Easy Ways)

Here are 3 simple methods to change the author name in Excel Comments. Method 1 - Changing Author Name from the User Name Box This is a very simple ...

How to Make a CSV File in Excel for Contacts (With Easy Steps)

  What Is a CSV File? You will unavoidably come across a comma-separated values file, or CSV, if you work with spreadsheet programs like ...

How to Set Excel Column Width to cm Unit (with Easy Steps)

To demonstrate how to change the column width into cm (centimeters) in Excel, we'll use a dataset of order details with multiple columns. ...

Excel Is Opening CSV Files in One Column: 3 Solutions

Method 1 - Changing Regional Settings to Prevent Opening CSV Files in One Column in Excel Steps: Open the Control Panel. Click on Clock and ...

How to Keep Leading Zeros in Excel CSV Programmatically

Microsoft Excel is a powerful program. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel ...

How to AutoFit All Columns in Excel (3 Methods)

  Method 1 - Double-Clicking Column Headers   To autofit all columns using double-click, follow these steps. Select the triangle ...

Man Hours Calculation in Excel (6 Useful Methods)

Method 1 - Using Subtraction If we know the starting time and the finishing time, we can calculate hours by using subtraction. Case 1.1. Time ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo