Excel Basics

How to Create Table from Multiple Sheets in Excel (4 Easy Ways)

Suppose we have 2 datasets containing the Product Name, Quantity, and Sales amount of 2 shops in different worksheets. The above image is the ...

How to Download Google Sheets to Excel (2 Easy Ways)

Microsoft Excel is a powerful program, and we use it on a regular basis. Nowadays, Google Sheets is getting very popular among the public and slowly ...

The Excel Cursor is Not Showing – 6 Solutions

Consider the following dataset. Solution 1 - Press the Escape (Esc) Key At first, you can try using Esc key if cursor is not showing up. ...

How to Paste a List of Emails into Excel: 2 Easy Ways

Method 1 - Using Combination of Text to Columns and Paste Special Commands Steps: Select the email addresses that you want to paste and press ...

How to Create a Lookup Table in Excel (5 Easy Ways)

  Suppose we have a dataset containing some Product ID, Delivery Status and Price of those products. We will show the way to find specific ...

How to Create a Subtraction Formula in Excel – 7 Methods

The sample dataset showcases Employees' Salaries and Expenses.   Method 1 - Subtraction Between Two Cells Using Generic Formula ...

How to Create a Table from Another Table with Criteria in Excel (3 Methods)

Method 1 - Using the INDEX and ROW Functions We'll use a table named Source_table with three columns named Employee ID, Employee Name, and Gender. ...

Paste Comma Separated Values into Excel (in Different Orders)

Method 1 - Paste Comma Separated Values into Excel from a CSV File Directly Steps: We have data in a CSV file like the image below: ...

How to Create a Conditional Formula in Excel (5 Easy Ways)

Let's use a Score List of Math scores of some students. This dataset contains the ID, Student Name, and their corresponding Marks in columns B, C, ...

How to Move or Copy a Sheet Not Working in Excel

The below dataset contains employee Information: Employee ID, Name, and Designation. Reason 1: Having an Excel Table in Grouped Worksheets ...

Unlocking Potential of Google Sheets QUERY Function in Excel: 6 Examples

Method 1 - Excel Equivalent of QUERY Function: Copy Whole Range We have some sales information in the range B4:E12 and want to copy the whole range ...

[Fixed]: Conditional Formatting in Data Bar Percentage Not Working in Excel

To demonstrate the solutions, we'll use a dataset of 10 employees of a company and their salaries. Our dataset is in the range of cells B5:C14. ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo