Siam Hasan Khan

About author

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.

Latest Posts From Siam Hasan Khan

How to Create a Chart from Selected Range of Cells in Excel

Creating charts is one of the main purposes for which you use Excel. The different kinds of charts give us a visual representation of the data we are working ...

How to Calculate Weighted Average with Percentages in Excel

Calculating a weighted average with percentages in Excel involves multiplying each value by its respective weight (percentage), summing up these weighted ...

Calculate Percentage Difference Between Two Numbers in Excel

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default Excel ...

Students Tracking Their Own Progress Template

"No Macro used. No installation is necessary. Just download and start using." - Siam Hasan Khan (Template Developer) Created using Excel 2016 ...

How to Add the Footer Page 1 to the Current Worksheet

When dealing with a worksheet that has a lot of data pages, it is essential to set the proper page numbers for them. Otherwise, it will be difficult to find ...

How to Calculate Hours Worked Minus Lunch with Excel Formula?

In this article, we will show you the Excel formula to calculate hours worked minus lunch. Lunchtime can be in hours or it can be expressed as in starting and ...

Sort Pivot Table by Values in Excel (4 Smart Ways)

Sometimes after making a Pivot table in Excel, the data can be seen placed in the wrong order. To sort it out, Excel has many different sorting options for the ...

Weekly Meal Planner Template with Snacks (Free Download)

"No Macro used. No installation is necessary. Just download and start using." - Siam Hasan Khan (Template Developer) Created using Excel 2016 ...

Tracking Student Progress Excel Template (Free Download)

"No Macro used. No installation is necessary. Just download and start using." - Siam Hasan Khan (Template Developer) Created using Excel 2016 ...

Perform Commands to Center the Selected Worksheets in Excel

Looking for ways to know how to perform commands to center selected worksheets in Excel? We can select worksheets and perform commands to center them in Excel ...

How to Calculate Years of Service in Excel (4 Easy Ways)

Suppose you have an employee who recently resigned from your company. You want to calculate his/her years of service at your company. There are several ways to ...

How to Sum Multiple Rows and Columns in Excel

Summing up multiple rows and columns in Excel is important for many purposes. In this article, we will see different techniques on how to sum multiple rows and ...

How to Round to Nearest 1000 in Excel (7 Easy Methods)

In this Excel tutorial, you will learn how to round to the nearest 1000 in Excel. Overview of Rounding to Nearest 1000 in Excel using ROUND, ROUNDUP, ...

How to Calculate Working Days in Excel Excluding Weekends and Holidays

Finding the total number of working days between two dates in Excel is a frequently needed function. Usually, we overlook the weekends and holidays when ...

How to Perform a Spelling Check on the Active Worksheet in Excel

Spell checking is mandatory sometimes while working on an Excel Worksheet. In this article, we will see how to perform a spelling check on the active worksheet ...

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.


Advanced Excel Exercises with Solutions PDF