Excel Basics

How to Add Blue Data Bar in Excel (3 Easy Ways)

We occasionally need to use the data bars feature to display our dataset. We can rapidly do it with Excel's Conditional Formatting feature. In this ...

How to Make a Conversion Table in Excel (8 Easy Examples)

This tutorial will demonstrate how to make a conversion table in Excel. In our day-to-day life, we need to convert different units. Sometimes we need ...

How to Add a Drop-Down List in Word from Excel (2 Ways)

Method 1 - Using the Paste Special Command Steps: Select the cell that contains the drop-down list in the Excel file. In this case, it will be ...

How to Make a School Time Table in Excel (with Easy Steps)

We'll use the following dataset to create a school timetable. Step 1 - Input Days and Periods Make an 8x8 table in your Excel sheet ...

[Fixed!] Cannot Insert PDF into Excel (3 Reasons and Solutions)

Object Linking and Embedding or OLE is a technology from Microsoft which restricts many files from different companies to insert into Excel. However, ...

How to Rename a Workbook in Excel (4 Easy Methods)

While working in Excel, we often have to rename a workbook. In addition to this, properly named and organized worksheets and workbooks are important ...

How to Copy Horizontal and Paste Vertical in Excel

While working in Microsoft Excel sometimes we need to copy horizontal data and paste them vertically to rearrange data. It might seem difficult to ...

How to Automatically Convert Excel File to Google Sheets

If you are looking for a way to automatically convert your Excel file to Google Sheets then you have come to the right place. The objective of this ...

Best Practices for Linking Excel Spreadsheets

In this article, you will learn about best practices for linking Excel spreadsheets. This is very easy to understand; a basic understanding of Excel ...

How to Create a League Table in Excel (4 Easy Methods)

Tocreate a league table in Excel, we'll use the dataset below, containing some team names and their points totals. We used Microsoft Excel 365 here, ...

How to Create a Formula Using Defined Names in Excel -7 Examples

The sample dataset (B4:D13) showcases Item, Quantity, and Unit Price of Fruit Sales.   Example 1: Multiplying Named Ranges Steps: ...

How to Copy Array Formula in Excel: 3 Easy Methods

Method 1 - Use Fill Handle Tool Steps: Choose a cell (F5) where the array formula is placed. Move the cursor to the border of the cell (F5) ...

How to Copy and Paste Pivot Table Values with Formatting in Excel

If you copy a pivot table and then paste it in the usual manner (CTRL +C / CTRL + V), you will get the pivot table but not necessarily with the ...

[Fixed] Excel Not Copying Formulas, Only Values (4 Solutions)

Copy-Paste is a very useful feature in Excel. Sometimes, you may face the problem that you need to copy the formulas along with the values or even ...

How to Create an Array Formula in Excel – 13 Examples

Get the final sale of values by multiplying sales by the number of the packages: What is Array Formula An array formula can execute many ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo