Advanced Excel

How to Make a Correlation Table in Excel (5 Handy Ways)

We have the following sample dataset containing sales records of Laptops, Mobile and Routers for different years. We will create a correlation table ...

How to Translate Chinese to English in Excel (2 Methods)

Dataset Overview To illustrate these methods, we'll use a dataset containing the report cards of some students. This dataset includes marks for ...

How to Clean Survey Data in Excel (with Detailed Steps)

In this article, we will discuss how to collect survey data in Excel and clean it with proper illustrations. Survey works are mostly performed by ...

How to Create a Sensitivity Table in Excel (2 Methods)

Sensitivity analysis evaluates how various values of an independent variable impact a specific dependent variable. We will apply this to the sample ...

Making Excel Formatting Work Without Double Clicking Cell: 2 Methods

Method 1 - With Text to Columns Feature ⏩ Steps: Select a data range of a column (i.e. Start Time) > go to the Data tab> click the Text ...

[Fixed!] Excel Hyperlink Keeps Coming Back (5 Quick Solutions)

A hyperlink is a form of text that refers to a certain web address with a URL link. Microsoft Excel allows us to auto-hyperlink any text whenever we ...

How to Create a Word Cloud in Excel – 2 Methods

What Is a Word Cloud? Word clouds are groups of words that are visually displayed in Excel. This is a sample word cloud of Marine Life: ...

How to Convert Excel to VCF Without Software (With Easy Steps)

What Is a VCF File? VCF (Virtual Contact File) is used to store virtual contact information. These files can be used as virtual business cards. VCF ...

How to Import CSV Data into Excel (4 Handy Approaches)

In this article, we’ll show you 4 handy approaches to importing CSV data into Excel. The above image shows the process of importing CSV data ...

How to Translate an Excel File from French to English – 2 Methods

Consider the following dataset. The text is in French. To translate it into English: Method 1 - Applying the Translate Command in ...

How to Translate Language in Excel Formula (with Easy Steps)

You can use the Functions Translator add-in by Microsoft to translate the language of formulas in Excel. Step 1 - Inserting the Functions ...

[Fixed!] Macros Not Working in Excel (3 Possible Solutions)

We prepared a sample dataset here with the First Names, Last Names, and Ages of six people. We want to copy a single cell from the dataset ...

[Fixed!] Excel Filter Stops at Blank Row (4 Possible Solutions)

We applied a filter to a dataset that has a blank row, but it stopped filtering when it encountered the blank row. Fix 1 - Selecting the ...

How to Edit CSV File in Excel: 3 Simple Ways

Method 1 - Employ File Tab to Edit CSV File in Excel Step-01: Open CSV File in Excel Open the CSV file in Excel. Go to the File tab. ...

The Unshare Workbook Feature is Grayed Out in Excel – Quick solution

The dataset showcases the Sales Analysis of the XYZ Store. If you go to the Review tab on the Ribbon, you will see that the Unshare Workbook ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo