Latest Blog Posts

[Solved!] Currency Sum Not Working in Excel (6 Suitable Solutions)

How to Detect If a Sum Is Not Working in Excel We have the following dataset to get the sum. We applied the SUM function on Cell C10. ...

Excel VLOOKUP Exercises: 10 Tricky Problems

In this article are ten Excel VLOOKUP exercises to practice. Most of the problems are easy to solve, however you will need some intermediate level ...

How to Transfer WhatsApp Group Contacts to Excel

Step 1 - Access WhatsApp Web on Your Computer Open WhatsApp on your computer using the browser. Step 2 - Link Your Smartphone If ...

How to Sort Data in Excel Chart (5 Easy Methods)

In the following dataset, you can see the Product and Sales columns. Using this dataset, we will insert a Bar chart. Select the entire ...

[Fixed!] Excel Ruler Not Showing (With Easy Solution)

While working in Excel, we may want the Ruler to show up on the top and left side of the worksheet. It helps to resize the Row Height or Column Width ...

How to Fix If the COUNTIF Function Is Returning 0 in Excel (4 Solutions)

  Solution 1 – Insert an Inverted Comma While Using Text Value In the following dataset, we haven’t inserted the text within the double ...

How to Translate Multiple Cells in Excel – 2 Methods

This is the sample dataset. Method 1 - Use the Built-in Translator in Microsoft Excel Steps: Select the range you want to translate. ...

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 Design an Employee Details Form in Excel (Free Template)

Step 1 - Inserting Organization Information Add the organization’s information to the employee details form. Enter the following basic ...

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

How to Create a Summary Table from Multiple Worksheets in Excel: 3 Useful Ways

In this sample dataset there is sales data for a few products and the vendors that sold them in the months of March, April, May, and June. To ...

How to Translate Excel File from German to English

In terms of working with Microsoft Excel, we might have to deal with a file written in other languages rather than English. There is nothing to worry ...

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 Many to Many Relationship in Excel

    Types of Relationships Between Tables in Excel In Excel, we can create three different types of relationships among tables. They ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo