Latest Blog Posts

How to use the Excel VLOOKUP Function for a Partial Match in a Table Array – 3 Examples

Example 1 - Using Wildcards in the VLOOKUP Function to Look up a Partially Matched Text Steps: Prepare the dataset: assign cells to insert the ...

How to Make a Histogram in Excel Using Data Analysis: 4 Methods

Method  1 - Prepare Dataset We created a dataset with three columns. The first two are for student information, ID and Name, and the third one ...

How to Display Text from Another Cell in Excel (4 Ways)

Below, we have a fixed grading system for an institution. And a dataset of 10 students' marks and grades per the institution's grading system. ...

How to Create a Table with Merged Cells in Excel (4 Easy Methods)

One of the major drawbacks of an Excel table is that you can not create a table with merged cells. Let's assume you have a data set that consists of ...

How to Get the Absolute Value in Excel – 8 Methods

This is an overview:   The sample dataset showcases the name of the Brand, and the present day, and the previous day sales. ...

How to Use IFS and AND Functions Together in Excel (3 Examples)

  Syntax of IFS and AND Functions The syntax for the IFS function is given below. =IFS(logical_test1, value_if_true1, ,...) The IFS ...

How to Use the Nested IF and AND Functions in Excel (4 Examples)

Dataset Overview Let’s start by introducing our dataset. On the sheet, we have the names of students, their CGPA, and the number of credits they’ve ...

How to Create Button to Link to Another Sheet in Excel (3 Ways)

We will show you how to create a button to link to another sheet by inserting Shapes, using the Button from Form Controls, and the Command Button ...

How to Create Pro Forma Financial Statements in Excel

In this article, we will create pro forma financial statements in Excel. We will project three years of financial statements for a startup company. ...

How to Use the VLOOKUP Function with Multiple Criteria in Different Sheets – 4 Methods

The sample dataset is an overview. Method 1 - Using in VLOOKUP Function on Each Sheet Individually Steps: Create a dataset as shown ...

How to Use Excel VLOOKUP with Multiple Criteria in Column and Row: 6 Methods

Methods 1 - Insert Ampersand Inside Excel VLOOKUP to Join with Multiple Criteria in Column and Row STEPS: Insert a Helper column on the ...

How to Add Option Button in Excel (With Easy Steps)

Consider the following dataset of fruit items and two stores. We'll insert option buttons so we can use this dataset to input data in other sheets. ...

How to Make All Numbers Positive in Excel (11 Effective Methods)

Method 1 - Using the ABS Function to Make All Numbers Positive Steps: Make a column to store the positive numbers and enter the following ...

How to Create Format for Projected Financial Statements in Excel

Part 1 - Creating a Projected Income Statement Format Steps: Insert all the assumptions. These values will be referenced in the income ...

How to Create a Histogram in Excel with Two Sets of Data – 4 Methods

The sample dataset contains 3 columns: Student ID, Math, and English. You want to calculate how many students get marks between different intervals. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo