Excel Basics

How to Copy WhatsApp Group Contacts to Excel (with Easy Steps)

Millions of people all over the world use WhatsApp, one of the most widely used instant messaging applications for our online discussions. It is ...

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

Looking for ways to create a table from multiple sheets in Excel? Then, this is the right place for you. Sometimes, datasets are stored in different ...

[Fixed!]: Excel Cursor Not Showing (6 Possible Solutions)

While working on an Excel worksheet, you may face many problems. One of the most common problems is the Excel cursor not showing. This may happen at ...

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

Excel users often need to record emails of certain contacts. It not only becomes tiresome to manually enter emails, but also it is prone to mistakes. ...

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 Quick Ways)

Microsoft Excel holds a strong position in the software market as a powerful calculation software. Though there is no exact function to subtract two ...

How to Create Table from Another Table with Criteria in Excel

When working with Excel tables, sometimes we need to create another table from the existing tables based on criteria. In this article, I will show ...

Paste Comma Separated Values into Excel (in Different Orders)

While working in Excel we have to deal with a comma or space-separated data from a different source. Commonly, the file in CSV format has many ...

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

[Fixed!] Move or Copy Sheet Not Working in Excel

Move or Copy sheet is a very useful feature in Excel. You can move or copy worksheets by using this feature. But, sometimes you may face a situation ...

Unlocking Potential of Google Sheets QUERY Function in Excel

The QUERY function of Google Sheets is renowned for its flexibility and powerful data querying abilities. But what about those who prefer using ...

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

The conditional formatting data bar is an amazing feature of Microsoft Excel to visualize the data-changing pattern. Using these data bars, we can ...

[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 Drop-Down List in Word from Excel (2 Easy Ways)

Drop-down lists are an eloquent way to showcase options. It allows users to select effectively from different options. Excel has several ways to ...

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

Using Microsoft Excel, one can perform various types of tasks. Along with the analysis and presentation of data, one can also make charts and tables ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo