# Siam Hasan Khan

Hello! Welcome to my Profile. Here I will be posting articles related to Microsoft Excel. I have completed my BSc in Electrical and Electronic Engineering from American International University-Bangladesh. I am a diligent, goal-oriented engineer with an immense thirst for knowledge and an attitude to grow continuously. Continuous improvement and life-long learning are my mottoes.

## Data Validation Based on Another Cell in Excel (4 Examples)

How to Do Data Validation in Excel? Take a dataset that includes student ID, student name, and age. We would like to make a data validation where the age must ...

## How to Use the INDIRECT Function to Get Values from Different Sheet in Excel (5 Practical Cases)

In the following image, we have Sheet Names, Cell references, and their Total Prices. In cell B6, we entered the sheet names (e.g., Sales Report Q1) and ...

## How to Show Formula in Cells Instead of Value in Excel (7 Ways)

In Excel, a lot of things are done using the functions that together make formulas. In this article, we are going to show you some tips on "How to show formula ...

## How to Make a Heatmap in Excel (2 Easy Ways)

This article illustrates how to make a heatmap in excel. A heatmap is a very useful technique to visualize data to show the magnitude of a phenomenon. Assume ...

## How to Match Two Columns and Return a Third in Excel

Suppose you have a simple table with two columns, and you want to make a new table that is a subset of the first one. You can do so by making a new table where ...

## Excel INDEX MATCH with Multiple Criteria and Multiple Results

Excel INDEX MATCH with multiple criteria and multiple results means getting multiple outputs based on multiple conditions using Excel INDEX and MATCH ...

## How to Copy and Paste Multiple Cells in Excel (8 Quick Methods)

While working in Microsoft Excel, you will need to copy and paste multiple cells to various positions. But sometimes it becomes difficult while working with a ...

## Excel Formula Symbols Cheat Sheet (13 Cool Tips)

In this article, you are going to see some Excel formula symbols cheat sheet. This article will be helpful for learning about the process of inserting formulas ...

## How to Insert Formula for Entire Column in Excel (6 Quick Ways)

The heart and soul of an Excel spreadsheet are its formulas and typically you apply these formulas in a range of cells located in columns or rows. Fortunately, ...

## How to Merge Excel Worksheets Without Copying and Pasting?

The problem that occurs while copying different elements of a worksheet into another worksheet is that you may not get the actual formatting of the elements ...

## Excel IF Function with 3 Conditions (5 Logical Tests)

When you are performing complicated and powerful data analysis, you need to justify various conditions at a single point in time. In Microsoft Excel, the IF ...

## How to Find Duplicate Values Using VLOOKUP in Excel

In this article, we will see the process on how to find duplicate values in Excel using VLOOKUP. We will also see the processes on how to use VLOOKUP to check ...

## How to Reference Cell in Another Sheet Dynamically in Excel

Tired of manually referencing cells in a different worksheet? Then I have some great news for you because in this article weâ€™ll show you how to dynamically ...

## Solving Equations in Excel (5 Useful Examples)

Excel has many features that can perform different tasks. Besides performing different statistical, and financial analyses, we can solve equations in Excel. In ...

## How to Make a Pie Chart in Excel (5 Suitable Examples)

If you are looking for ways to make a Pie Chart in Excel, then this article will be helpful for you. The focus of this article is to demonstrate how to make a ...

Browsing All Comments By: Siam Hasan Khan
1. Thanks Lakisha

2. Yes, it is possible. I insert the grades, grade points and number as most people want to see all of these 3 data. Here the students’ performance is calculated by differencing the Achieved grade and Targeted grade. You can insert the students targeted grade point instead of his targeted grade and calculate the differences between achieved grade point and targeted grade point to calculate the student`s performance.

3. Thanks for the feedback.

4. Thanks for your feedback. It means a lot to us. Keep following our website for more useful articles.

5. Thanks for your feedback.

6. Thanks for your feedback, Surya.

7. Thanks for your comment, Mr. Surya. Stay tuned for more useful articles.

8. Thanks for the comment Mr. JAN. Well, I didn’t test the code. I found accurate results that I was looking for. The other codes that I found out weren`t that much helpful. There were too many errors.

9. Thanks for identifying the typing mistake. I have solved it already. It`s good to know that you find this article useful.

Cheers!!!

Advanced Excel Exercises with Solutions PDF