Excel Basics

How to Make a Table Bigger in Excel (2 Useful Methods)

Excel table is one of the most useful tools that Excel offers as we can accomplish many tasks conveniently by using Excel Table. In this article, I ...

[Fixed!] Paste Special Not Working in Excel (4 Possible Solutions)

We often need to paste special values or numbers or characters in Excel. Excel allows users to paste different types of data through a feature called ...

[Fixed!] Cursor Selecting Wrong Cell in Excel (6 Proven Solutions)

Here are the Quarterly Sales Data for 2021 shown in the B4:F14 cells, containing the Location and the four Quarters Q1, Q2, Q3, and Q4, respectively. ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo