Mukesh Dipto

About author

Mukesh Dipto is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, HTML, CSS, JavaScript, and WordPress. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content all about Excel and VBA. You'll find him reading books, travelling, and enjoying movies and TV series outside work.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc in Naval Architecture & Marine Engineering, BUET.

Expertise

Microsoft Word, Excel & VBA, PowerPoint, Microsoft Power BI, AutoCAD, Rhinoceros, HTML, CSS, JavaScript, WordPress

Experience

  • Resource Person at Directorate of Primary Education, Bangladesh, Dhaka.

Research

  • Maritime risk assessment of LNG carrier in Bangladesh using Fuzzy Logic Approach.

Latest Posts From Mukesh Dipto

0
How to Convert Qualitative Data to Quantitative Data in Excel

This tutorial will demonstrate how to convert qualitative data to quantitative data in Excel. It is inaccurate to say that a qualitative study differs from a ...

0
How to Make Address Labels in Word from Excel (With Easy Steps)

This tutorial will show you how to make address labels in Word from Excel. Labelling is essential in terms of marketing a product, tagging the address of a ...

0
How to Make a Grouped Bar Chart in Excel (With Easy Steps)

This tutorial will demonstrate how to make a grouped bar chart in Excel. Compared to a simple bar chart, a grouped bar chart is slightly different. In the ...

0
How to Make Daily Vehicle Mileage and Fuel Report in Excel

This tutorial will demonstrate how to make daily vehicle mileage and the fuel report in Excel. A Daily vehicle mileage and fuel report must keep a record of ...

0
How to Create Tally Salary Slip Format in Excel (With Easy Steps)

This tutorial will demonstrate how to create a tally salary slip format in Excel. For a professional, it is very important to understand what a salary slip is. ...

0
How to Analyze Satisfaction Survey Data in Excel (with Easy Steps)

This tutorial will show you how to analyze satisfaction survey data in Excel. Sometimes we get a list of survey data in an Excel worksheet. From that ...

0
How to Calculate Selling Price from Cost and Margin in Excel

This tutorial shows how to calculate selling price from cost and margin in Excel. A good selling price is very important to create a successful business with ...

0
How to Find Chi-Square Critical Value in Excel?

This tutorial will illustrate how to find Chi-Square critical values in Excel. Suppose we will perform a Chi-Square test. As a result, we will get a test ...

0
How to Create a Swimlane Flowchart in Excel (With Easy Steps)

This tutorial will show how to create a swimlane flowchart in Excel. Swimlane flowchart is very helpful to get insights into a particular business. We can make ...

0
How to Calculate Manhattan Distance in Excel (2 Suitable Ways)

This tutorial will show how to calculate Manhattan distance in Excel. From the name, we can get an assumption that it is named after the famous city Manhattan ...

0
How to Print Notes in Excel (2 Simple Methods)

This tutorial will demonstrate how to print notes in Excel. In Microsoft Excel 365, we use notes as reminders. The notes in Excel 365 look like sticky notes in ...

0
How to Automate Data Entry in Excel (2 Effective Ways)

If you have endless data, it may be nearly impossible to input every data manually. Automating data entry is crucial in such cases to save time by reducing ...

0
Excel VBA Macro to Save PDF in Specific Folder (7 Ideal Examples)

This tutorial will demonstrate different examples to use Excel VBA macro to save as PDF in a specific folder. We can export or save an Excel sheet as a pdf ...

0
How to Restrict Data Entry in Excel Cell (2 Simple Methods)

Restricting data entry in Excel cells is essential for ensuring accuracy, preventing errors, and maintaining data consistency. By restricting, you can reduce ...

0
How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)

Sometimes while working with a big dataset we need to repeat rows in Excel when scrolling. This feature helps to keep important rows visible during the time of ...

Browsing All Comments By: Mukesh Dipto
  1. Hello Ruby,
    Thanks for your query. If you do not want to see the formula for a blink then you have to do it by protecting the worksheet. You can try the following code:
    Sub HideFormulasDisplayValues()
    With ActiveSheet
    .Unprotect
    .Cells.Locked = False
    .Cells.SpecialCells(xlCellTypeFormulas).Locked = True
    .Cells.SpecialCells(xlCellTypeFormulas).FormulaHidden = True
    .Protect AllowDeletingRows:=True
    End With
    End Sub

  2. Thanks for your feedback sir.
    The range is (>=50 and <=80). In Excel COUNTIF function by default omit the upper end value.
    So, the formula is basically showing the result for the values less than 80.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo