Wasim Akram

About author

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and programmable languages.

Designation

Excel VBA and Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Industrial and Production Engineering, AUST.

Expertise

Content Writing, VBA, C, C++, HTML, AutoCAD, Microsoft Office.

Experience

  • Technical Content Writing
  • Team Management
  • SEO Strategy

Summary

  • Currently working as a technical content writer of ExcelDemy.
  • Started as an SEO strategist in October 2021. Later promoted as a technical content writer in April 2022.

Latest Posts From Wasim Akram

0
How to Audit Formulas Using Excel Auditing Tools – 7  Tools

The following showcases an overview of  Excel auditing tools. Download Practice Workbook Audit Formulas.xlsx The sample dataset ...

0
How to Divide in Excel (Using Functions and Features)

In this Excel tutorial, you will learn in detail about how to divide in Excel including dividing numbers directly, by a constant number, applying the array ...

0
Data Bars in Excel (Insert, Format, and Deal with Negative Values)

In this Excel tutorial, you will learn in detail about data bars in Excel including inserting, making custom data bars, based on another cell, using formulas, ...

0
Excel Row and Column Limit – 3 Tips

  Limiting rows and columns is crucial for managing data in large datasets This is an overview of Excel row and column limit. Download ...

0
How to Import XML Data File into Excel (3 Quick Methods)

Importing XML data files into Excel allows you to integrate structured data from various sources into your spreadsheets. Utilizing this strategy, you may use ...

0
How to Use Dynamic Arrays in Excel (20 Useful Functions)

Dynamic array functions are a set of powerful formula tools introduced with the release of Excel 365 and Excel 2021 for Windows and Mac. These functions are ...

0
How to Insert, Use and Convert Complex Numbers in Excel?

In this Excel tutorial, you will learn how to - Insert complex numbers in Excel - Find imaginary and real parts of a complex number - Sum, subtract, ...

0
Table Array in Excel (Create, Use and Fix Issues)

In this article, we will learn in detail about table array in Excel including using, and applying variables, with defined names, from another worksheet, using ...

0
How to Insert Calendar in Excel Cell (2 Quick Methods)

Inserting a calendar into an Excel cell allows you to easily track dates and schedule events. Because in some cases, it's got bothering to insert dates ...

0
Extracting Email Addresses from Excel (4 Easy Ways)

Here's a dataset that will provide an overview of extracting email addresses from Excel. It contains addresses embedded into larger strings in cells. ...

0
How to Create Dynamic Table of Contents in Excel (3 Easy Methods)

A dynamic table of contents in Excel is a very powerful thing that allows users to create an interactive and automated index for their workbooks. By linking ...

0
How to Calculate Safety Stock and Reorder Point in Excel (6 Methods)

Safety Stock Safety stock acts as a buffer to ensure that a company can meet customer demand even during unexpected fluctuations in demand or lead time. ...

0
How to Run a Private Sub in VBA (3 Methods)

In this article, I am sharing with you how to run a private sub in VBA. In VBA, a private sub is a sub procedure that can only be accessed from within the same ...

0
Excel VBA to Count Files in Folder and Subfolders (4 Examples)

Counting the number of files in a folder and its subfolders can be a tedious and time-consuming task, especially if there are a large number of files involved. ...

0
How to Make Excel Slicer with Search Box (with Easy Steps)

Excel Slicers with search functionality provide a user-friendly way to filter and navigate data in Excel. By incorporating a search feature, users can quickly ...

Browsing All Comments By: Wasim Akram
  1. Dear FODAY,

    Thank you for your response. As per your query-

    1. You can create a Pie Chart to visualize the sales from the “Insert” option.

    Imagine a dataset with multiple Bakery Products and their Total Sales. Now we will create a pie chart using the information from the dataset.

    First, select the products and total sales column and then press “Recommended Chart” from the “Insert” option.

    Second, from the new dialog box choose “Pie Chart” and press OK to continue.

    Finally, within a moment your final pie chart will be in your hands showing sales of multiple products.

    2. As per your second query-
    We will use the IF function to calculate the “10%” discount price if the sales of cake is more than 100.
    To do that choose a cell (G5) and write the following formula down-

    =IF(E5>100,(D5-(D5*0.1)),D5)

    Hence, hit Enter and the final output will be in your hands.

    3. Now coming to the last query you wanted to use the data validation for ladies with only 5 letters in their name. Well, below I have shared the simplest solution.
    Suppose we have a dataset with some Lady Names. Now we will use data validation for the name list.

    First, selecting the names from the list click the “Data Validation” option from the “Data” feature.

    Second, click “Settings” and choose criterias according to the screenshot and press OK to continue.

    Finally, we have applied data validation over the name list. To check try editing any names not fulfilling the condition and you will get a notification about “This Value doesn’t match the data validation restrictions defined for this cell.

  2. Dear AJ,

    Thank you for your response.
    There are a few potential issues that could prevent this code from working properly-

    1. Make sure that the worksheet module contains the correct event handlers. To do this, right-click on the worksheet tab in Excel and select “View Code”. Then, make sure that you have pasted the code into the correct module, which should be named something like “Sheet1 (Sheet1)”.

    2. Check that the password used to protect and unprotect the workbook is correct and does not contain any typos. In this case, the password is set to “”123″”, but you can change this to any other password of your choice.

    3. Ensure that the workbook is not already protected by another password. If the workbook is already protected, you may need to unprotect it first before running this code.

    If none of the above solutions work, you may need to provide more context or information about the specific error message or issue you are encountering when trying to run this code.

    Thanks
    Wasim Akram
    Exceldemy Team

  3. Hello jean,
    Thank you for sharing your problem with us!
    In order to calculate the participation percentage, you can follow the instructions below.

    1. Simply choose a blank cell.
    2. Insert the following formula:
    =COUNTIF($C$5:$C$25, E5)/COUNTA($C$5:$C$25)

    Calculating Percentage of the Participants

    Thus you can calculate the participation percentage.

    Note:
    1. The formula you used did not work because you did not lock the cell range using absolute reference.
    2. Another reason is don’t leave the cells blank for the choosen cell range.

  4. Dear Betty Domowski,
    Thank you for sharing your problem. As you already know how to get rid of these lines but to stop them from coming back there is no other alternative except using the Remove Arrows option from the Formulas tab. Please check the image below.

    Remove blue lines

    Hope you found your solution you are looking for.

    Regards
    Wasim Akram
    Exceldemy

  5. Dear vishal saini,
    Thank you for your response.
    Here I have shared a solution using VBA code to protect a worksheet in the manner you are looking for.

    First, opening the VBA window you need to put the following code in the This Workbook section. Don’t forget to change the sheet name according to your sheet.

    
    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Set WS = Worksheets("Sheet1")
    Sheet1.Addresses = ""
    Sheet1.Values = ""
    For i = 1 To WS.UsedRange.Cells.Count
    If IsEmpty(WS.UsedRange.Cells(i).Value) = False Then
    Sheet1.Addresses = Sheet1.Addresses & _
    WS.UsedRange.Cells(i).Address & ","
    Sheet1.Values = Sheet1.Values & WS.UsedRange.Cells(i).Value & ","
    End If
    Next i
    End Sub

    Protect Sheet from Deleting-1

    Next, insert the below code in your worksheet. You can change the password from the marked section.

    
    Public Addresses As String
    Public Values As Variant
    Public NewAddresses As String
    Public NewValues As String
    Public IsDone As Boolean
    Private Sub Worksheet_Change(ByVal Target As Range)
    Password = "ExcelDemy"
    Adds = Split(Sheet1.Addresses, ",")
    Vals = Split(Sheet1.Values, ",")
    If Target.Value <> "" Then
    Sheet1.NewAddresses = Sheet1.NewAddresses & _
    Target.Address & "*" & Target.Value & ","
    End If
    Found1 = False
    Found2 = False
    NewValue = ""
    If Target.Value = "" And Sheet1.IsDone = False Then
    For i = LBound(Adds) To UBound(Adds)
    If Adds(i) = Target.Address Then
    Found1 = True
    Exit For
    End If
    Next i
    NewAdds = Split(Sheet1.NewAddresses, ",")
    For i = UBound(NewAdds) - 1 To LBound(NewAdds) Step -1
    Arr = Split(NewAdds(i), "*")
    If Arr(0) = Target.Address Then
    NewValue = Arr(1)
    Found2 = True
    Exit For
    End If
    Next i
    If Found1 = False And Found2 = True Then
    Target.Value = NewValue
    UserPassword = InputBox("Enter the Password: ")
    If UserPassword = Password Then
    Sheet1.IsDone = True
    Target.Value = ""
    Sheet1.IsDone = False
    Target.Select
    Else
    MsgBox ("Invalid Password.")
    Target.Select
    End If
    End If
    End If
    End Sub

    Protect Sheet from Deleting-2

    Finally, you can protect your worksheet in the manner where you can add data and after saving the data you can’t delete the same until you don’t save.

    Thanks
    Wasim Akram
    Exceldemy Team

  6. Hi Farhan,
    Hope you are doing well.
    Here Jacob and Ben are sales representative working in both night and day shifts.
    In order to calculate their day and night shift from the list for each we used a simple formula using the COUNTIFS function.
    First, the COUNTIFS function counts the number of cells in the cell range ($C$5:$C$92) matching the value in cell (K23) which indicates sales representative Ben.
    Next, it also match the value in cell (L22) within the cell range ($D$5:$D$92).
    As a result, we will get the result counting total number of day shifts attended by Ben.

    Counting number of days attended for a sales representative

    Similarly, we can calculate the total number of shifts attended by Jacob.

    Counting number of shifts for a sales representative

    Hope you found the answers for your submitted queries.
    Regards
    Wasim Akram
    ExcelDemy

  7. Dear Anita,
    Thank you for the comment. We really appreciate your response for sharing with us.
    The currency sign not appearing in Excel may be due to the values are stored as text in your spreadsheet. When values are stored as text, you need to convert those as numbers and then change the format to currency to get your desired currency format. You can follow the below instructions to learn about this technique.

    First, choose the cells (D5:D12) and click the error icon following the image below.

    Getting error sign as the values are stored as text values

    Next, choose Convert to Number option from the list.

    Converting values to numbers by clicking the error icon

    As the numbers are now converted as number, now press CTRL+1 to visit the Format Cells feature to add currency symbol.

    Pressing CTRL+1 to open Format Cells window

    From the Format Cells window, choose Currency from the left pane, select your desired currency symbol and hit OK.

    Choosing currency and desired symbol from the list

    As a result, you will get the currency sign added in your worksheet.

    Final result with solving currency symbol not working in Excel

    If you are still having problem with the currency symbol, then you can share your workbook with us. We will check and solve the problem.

    Thanks & Regards
    Wasim Akram
    Team Exceldemy

  8. Dear Brenda,
    Thank you for your comment.
    In order to create a pie chart you don’t need to create a pivot table. But if your data have duplicate values then you must create a table to group those data and then create a pie chart. Otherwise the duplicate value will not group together. Because there’s no direct command or pivot pie chart in Excel to group data.
    There’s Pivot chart feature by which you can group data from pivot table fields and that is a column chart not pie chart. That’s why you need to create a table first and then create the pie chart.
    We’ll really appreciate your response If you have any alternative solution and share with us.

    Thanks & Regards
    Wasim Akram
    Team Exceldemy

  9. Dear Ben,
    Thank you for your comment. We really appreciate you for contacting with us.
    In order to insert multiple rows of data, you can try the below VBA code.

    Sub InsertDataIntoTable()
    Dim tableName As ListObject
    Set tableName = ActiveSheet.ListObjects("Table1")
    Dim dataRows() As Variant
    dataRows = Array( _
    Array("1/1/2022", "Apple", 5, 1.77), _
    Array("2/1/2022", "Banana", 3, 2.05), _
    Array("3/1/2022", "Orange", 8, 0.95))
    Dim i As Long
    For i = LBound(dataRows) To UBound(dataRows)
    Dim addedRow As ListRow
    Set addedRow = tableName.ListRows.Add()
    With addedRow
    .Range(1) = dataRows(i)(0)
    .Range(2) = dataRows(i)(1)
    .Range(3) = dataRows(i)(2)
    .Range(4) = dataRows(i)(3)
    End With
    Next i
    End Sub

    Using the Array statement inside the VBA code, you can add as many rows you want inside your table.

    Thanks & Regards
    Wasim Akram
    Team Exceldemy

  10. Dear Yogiraj,

    Thank you for your comment.

    You are absolutely right about your opinion regarding its use.

    By creating equation from data points you can also see the difference between the plotted and actual data points.

    Thanks

  11. Dear TAYFOON,

    Thank you for your response.

    If you want to see the arguments as “RETAILPRICE(Price1,Price2,Divisor)”.
    Then follow the instructions below-

    1) In the module Place the following code-

    Public Function RETAILPRICE(Price1, Price2, Divisor) RETAILPRICE = (Price1 + Price2) / Divisor End Function

    2) Then go to your worksheet and type “=RETAILPRICE(” and after that press Ctrl+Shift+A to get the arguments just as you want.

    Hope you found your solution. Thanks!

  12. Dear MIKE WELLS,
    Thanks for your response.

    There are several reasons behind this “Source Validates to an error” occurring. You can solve them efficiently providing the correct data inside the string.

    Reason: The source validates that an error can occur if the source to which the formula is applied demonstrates an error. Thus the final statement stands to whether the formula is not correct or the formula refers to data returning an error.

    Solve: To solve this problem, you have to provide correct data or change the formula.
    From our dataset, suppose we are having trouble with the “Source Validates to an error“. This error is occurring due to the blank cell (E4). As the INDIRECT function converts a string into an actual reference thus finding the reference cell (E4) blank it’s showing an error. Check the following screenshot.

    In order to solve this just put the same text from the list in the reference cell and you won’t find any more errors further.

    Other reasons behind this “Source Validates to an error” might happen-
    a) The applied formula is not the proper formula to find the references.
    b) Put exact names from the list to the reference list to avoid errors.

    Hope you will find your solution with this reply. If you are still having problems, don’t hesitate to let us know below. We are always here with you to solve your problems. Thanks!

  13. Dear FLEET,

    Thank you for your response.

    The answer for the intersection of “Laptop” and “China” will be “$63,800”.
    The SUMPRODUCT function returns the sum of an array from an argument. With the intersection between “China” and Laptop” within the cell range we got two outputs which are “$56,000” and “$7,800”. Thus summing the total value with the SUMPRODUCT function stands to “$63,800”.

    You can check the screenshot below.

    We have also attached a worksheet with our article. You can practice the formula there, too. Thanks!

  14. Dear SWAROOP,
    A syntax error occurs due to misspelling or missing code. Mostly, due to not specifying the condition and not putting closing brackets. You can check the VBA editor which will help you identify the problems. You can try applying the code in a new worksheet to find your solution.

    In addition, if you are applying VBA code with your own workbook data, don’t forget to change the ranges. Check the below screenshot. Thanks!

  15. Dear ERIC CHARLES BAUMGARDNER,
    In order to enter your own workbook value into the code, you need to change the ranges inside the code. Check the following screenshot. Thanks!

  16. Dear RUBY,
    Here is the solution you are looking for.
    Suppose you have a dataset with conditional formatting applied in the list.

    First, select all the cells (C2:C11) from the column and click the “Filter” option from the “Data” ribbon.

    Now press the “Filter icon and choose “Filter by Color”. Hence choose your cell color.

    Thereafter, you will get to see only the cells with the selected colors. Let’s calculate the total sum now. To do so, choose a cell (C13) and writhe the following formula down-
    =SUBTOTAL(109,C3:C11)

    Finally, you will get the sum value for the colored cells only.

    If you are still facing problems then you can read this article – How to Sum Colored Cells in Excel

    Thanks!

  17. Dear Jamil,
    Using conditional formatting you can search for a specific text and color them according to your choice. Follow the instructions below.

    Suppose we have a dataset of some countries’ names in cells (B3:E9). Now we are going to color a specific text (United States) from the list.

    First, select all the cells and click the “Text that contains” option from the “Conditional Formatting” feature.

    Second, put your desired text and choose a color of your choice. Gently, press OK.

    Finally, we have successfully highlighted a certain text from the list.

    Hope you got the solution you are looking for. If you still having problems then check the link below. Thanks!
    Highlight Cells Based on Text

  18. Dear KOLAPALLI PAVAN KUMAR,
    The output you are looking for can be achieved using the COUNT function in excel. Here the COUNT function counts the cell number given in the string.
    Apply the following formula-
    =COUNT(C2:C8)

    You can check the screenshot below-
    First, select a cell (E3) to apply the formula.

    Second, press Enter to get the desired output.

    Hope you got your solution. If you still didn’t get it, check out the article below-
    The Different Ways of Counting
    Thanks!

  19. Dear DON_1234567,
    You can use the simple subtraction formula to calculate the difference between two times.
    You can use the formula below-
    =C5-D5
    Check out the screenshot below-

    If you are still not getting the result. Then change the cell format to time.
    You can visit the below article to learn more. Thanks!
    Calculate Difference Between Two Times

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo