Latest Blog Posts

How to Create Data Model Relationships in Excel (3 Ways) 

The Data Model is a special feature of Excel that allows users to gather data from various sources and create a relationship between them. ...

How to Create a Decision Table in Excel – 2 Steps

  Using the Conditions, Rules, and Actions in the table below, create a decision table. Step 1 - Create an Outline Set the Borders. ...

How to Display Document Properties in Excel (3 Simple Methods)

When an Excel worksheet is created, the document automatically includes a number of properties. In this article, we will demonstrate 3 simple methods ...

How to Convert Google Sheets to Excel with Formulas

In recent years, Google Sheets has become a strong alternative to Excel. As more and more people are using Google Sheets and the number of Excel ...

How to Create Excel Sheet from Google Form (2 Easy Ways)

Google Forms is a popular tool for creating online surveys and quizzes, which can be used for everything from market research to customer feedback.  ...

How to Insert Sunburst Chart in Excel (2 Easy Examples)

This tutorial will demonstrate how to insert a sunburst chart in Excel. When dealing with lots of data, we often represent the data in a chart form ...

Excel Double Click AutoFill Not Working: 3 Methods

Method 1 - When Excel File Has Hidden or Distant Column The formula in the G5 cell is like this. =C5*D5*E5 We need to ...

COUNTIF Between Two Values with Multiple Criteria in Excel

Sometimes you may need to use the COUNTIF function between two values with multiple criteria. So, if you are looking for the use of a COUNTIF ...

[Fixed] Excel Macros Enabled But Not Working

  Reason 1 - Worksheet Might Be Saved as an .xlsx File The file extension for spreadsheets that support macros is .xlsm, whereas that of ...

How to Enable Paste Option in Excel (3 Suitable Ways)

Excel is sometimes unable to show the Paste Options, usually due to a setting, protected sheet, or corrupted Excel file. In this article, we will ...

How to Use the COUNTIF Function in Excel to Count Bold Cells

Dataset Overview Let’s assume we have a concise dataset with approximately 7 rows and 2 columns. Initially, all cells are in the General format, and ...

How to Design Form in Excel (2 Suitable Examples)

Method 1 - Designing a Printable and Automated Basic Drop-Down Form in Excel We'll create a student application form. Steps: Insert your ...

How to Vlookup from Excel to Google Sheets (3 Suitable Ways)

We are going to use a Sales Report of a particular grocery store. This dataset concludes the Sales Rep, Order Date, Product Name, and the ...

How to Change the Comma Separator in Excel (7 Easy Methods)

Dataset Overview Assume we have a dataset containing a list of fruit, country and the sales amount. Method 1 - Using Excel Options Dialog ...

How to Link Excel to Google Sheets (with Easy Steps)

In this article, we will link Excel to Google Sheets in 4 easy steps. To describe these steps, we'll use the following sample data set: ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo