Ishrak Khan

About author

Qayem Ishrak Khan, BURP, Urban and Regional Planning, Chittagong University of Engineering and Technology, Bangladesh, has been working with the ExcelDemy project for 1 year. He wrote over 40+ articles for ExcelDemy. He is an Excel and VBA Content Developer providing authentic solutions to different Excel-related problems and writing amazing content articles regularly. Data Visualization, DBMS, and Data Analysis are his main areas of interest. Besides, He has passions about learning and working with different features of Microsoft Office Suite.


Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Urban and Regional Planning (URP), Chittagong University of Engineering & Technology.


Data Analysis, Content Writing, Python, Microsoft Office, Urban Design, ArcGIS, AutoCAD, Sketchup, EDRAS Imagine, ENVI, SPSS and R.


  • Technical Content Developer, SOFTEKO
    • Published 40+ tutorials on Advanced Excel and VBA Macro.
    • Contributed to generating video content based on the tutorials.
    • Proofreading and editing blog posts to ensure overall quality.
    • Solving complex user problems in Excel
  • Research Assistant, RAJUK
  • Conducted reconnaissance survey and physical feature survey.
  • Report writing, presentation, map creation, drafting TOR, TAPP, and DPP.
  • Coordinated and organized meetings and field tours for foreign delegates.
  • Junior Urban Planner, Access Asia
    • Conducted reconnaissance survey, demographic survey, and road inventory survey.
    • Boundary demarcation using GIS software, organizing teams, compiling data, and preparing reports.
    • Conducting sessions with official delegates and local representatives, introducing them to the development and planning practice, values, policies, and procedures.
  • Technical Research Consultant, CEGIS
    • Generate land use database.
    • Landmark digitization.
    • Geo-referencing of Base Map.
  • Junior Urban Planner (Intern), Eastern Housing Limited
    • Landscape planning and road design.
    • Plot mapping and documentation.
    • Create IEE and FS reports.

Research & Publication

  • Identification and Analysis of Accident Black Spot: A case study of Chattogram City's major arterial road. In 2022, the 6th International Conference on Civil Engineering for Sustainable Development (ICCESD). Accepted and currently processing in AIP Conference Proceedings (Indexed in SCOPUS, Web of Science, and Scimago).

Latest Posts From Ishrak Khan

How to Do F Test in Excel

In this article, we will explore how to do F test in Excel, using two methods: the built-in function and the Data Analysis ToolPak. Moreover, we will show you ...

Cell Styles in Excel (All You Need to Know)

In this article, we will show you all the features and benefits of cell styles in Excel. Particularly the default cell styles that enhance the visual ...

How to Print in Excel – Basic Guidelines for Beginners

Printing in Excel means making a paper copy or a PDF copy of your Excel sheet. This is handy for meetings or sharing physical documents. In this article, ...

How to Use Excel Screenshot Option (Take, Edit and Copy)

In this article, we are going to demonstrate how to take an Excel screenshot without taking any help from any third-party app. There are three ways you can ...

Excel Waterfall Chart Change Colors

In this article, we will learn how to make a waterfall chat and how to use a waterfall chart to change colors in Excel for impactful and insightful visuals. ...

Excel VBA Range Address (5 Suitable Examples)

In this article, we will demonstrate the significance of Excel VBA range address, its common usage, and how they can contribute to our day-to-day professional ...

Excel Color Index Formula

In this article, we will help you understand how to use the Excel color index formula to simplify the work of professionals. In everyday life, color plays a ...

[Solved!] MINVERSE in Excel Not Working

In this article, we'll help you to solve the issue of MINVERSE in Excel not working. We will navigate you through any challenges and unleash the full potential ...

How to Perform Excel Data Analysis: Forecasting (3 Easy Ways)

This article will help you understand how to use Excel and its widely used features to perform data analysis and forecasting values. I hope all these tools, ...

Excel Slicer Greyed Out

In this article, we will explore common reasons behind the Excel slicer greyed-out issue and provide practical solutions to resolve the problem effectively. ...

Excel Formula to Change Cell Color Based on Text

In our daily life, we use color to communicate a wide range of messages and emotions. In professional life, for example, assume that you have a list of sales ...

Prevent Excel from Converting to Scientific Notation in CSV Data

Are you tired of dealing with Excel's automatic conversion of large numbers to scientific notation when importing data from a CSV file? Don't worry, you're not ...

Excel Sparklines: Simplifying Data Trend Analysis in a Single Cell

Excel Sparklines are compact versions of line or column graphs in a single cell. In this Excel tutorial, you will learn about Excel sparklines. In the ...

Browsing All Comments By: Ishrak Khan
  1. Dear MATHMAN,

    We are glad that you have already got your answer related to the ROUND function.

    Now let’s jump to the problem related to finding other EigenValue and EigenVector using the power method.

    In the power method, it is a must to choose an initial vector V0. So, the tips for what to keep in mind while randomly choosing an initial vector V0:

    1. Ensure that the initial vector has non-zero elements.
    2. The initial vector must be non-orthogonal. To check you can use this example:
      If initial vector V0 =[0,1,1] and W is the given dominant Eigenvector, then V0 X W =0 
    3. Avoid extremely small or large values in the initial vector.
    4. If possible, ensure that the magnitude of the initial vector is consistent.

    The dominant Eigenvalue for the 3×3 matrix [5,4,-1; 4,5,1; -1,1,2] is approximately λ ≈ 9.

    If you are getting Eignevalue λ≈0 for the initial EigenVector V0 = [0,0,1] most probably because the vector has no magnitude along the x and y axes and a magnitude of 1 along the z-axis. Therefore, the initial vector V0 does not converge to the dominant Eigenvalue for the given matrix. It is expected that different EigenVectors can lead to different EigenValues.

    The dominant eigenvalue is typically the one with the largest magnitude. It is recommended to use multiple initial vectors in the power method so that you know which eigenvalue converges to the dominant eigenvalue.

    I hope this solution resolves your issue. Feel free to email us at [email protected] if you have any further problems or inquiries.


    Qayem Ishrak Khan

    Team ExcelDemy.

  2. Dear ALEX,

    Thank you for this interesting question. If you want to find the total sales value for each brand within a quarter or QTD, you can use a formula that combines the SUMIFS, INDEX, and MATCH functions.



    sum with index-match functions under multiple criteria in Excel

    The formula used here is the same as the one explained in the “Use of SUMIFS with INDEX & MATCH Functions in Excel” section. We repeat the formula two more times, adjusting the column reference for each specific month in the quarter.

    I hope this solution resolves your issue. Feel free to email us at [email protected] if you have any further problems or inquiries.


    Qayem Ishrak Khan

    Team ExcelDemy.

Advanced Excel Exercises with Solutions PDF