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

In the following dataset, we have qualitative data for two questions from a survey about people's preferences in movies. We will convert this qualitative data ...

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

What Is a Grouped Bar Chart? A grouped bar chart is also known as a clustered bar chart. It displays the values of various categories in different time ...

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

In the following image, you can see the final template. We will create this template using step-by-step procedures. Step 1 - Create Information ...

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

In this tutorial, we’ll demonstrate how to analyze satisfaction survey data using Excel. We’ll follow a step-by-step approach using a sample dataset. The ...

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 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 Automate Data Entry in Excel: 3 Effective Methods

The following dataset has 2 cell ranges. The lower range (B11:C14) contains the names of some fruits and corresponding prices. The upper range (B5:C8) is ...

0
How to Use Excel VBA Macro to Save a PDF in a Specific Folder (7 Examples)

The following dataset contains the sale amounts of different salespeople. Method 1 - Using Excel VBA Macro to Save Active Worksheet as PDF in a ...

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

The following dataset contains the names of students in a column. We’ll restrict the data entry in the Project Code column. Method 1 - Using Data ...

0
How to Type Minus Sign in Excel Without Formula: 6 Methods

Method 1 - Apply Insert Tab to Type Minus Sign in Excel Without Formula STEPS: Select cell C5. Go to the Insert tab. From the Symbols section ...

0
How to Calculate a Standard Error of Regression Slope in Excel

  Method 1 - Calculating the Standard Error of the Regression Slope with a Scatter Chart in Excel STEPS: Select cell (B4:C9). Go to the ...

0
How to Import Stock Prices from Yahoo Finance into Excel – 3 Easy Steps

  What Is the Historical Stock Price? The historical stock price is the stock price in a specific date in the past. Historical prices are used to ...

0
How to Make an Eisenhower Matrix Template in Excel (With Easy Steps)

  In an Eisenhower Matrix, we will have two parts. One part is the data section of the template. The data section will contain two parameters named ...

0
How to Set Decimal Places in Excel with Formula (5 Ways)

Suppose we have a dataset that contains values with five decimal places, but we want to only display two decimal places. In this article, we demonstrate 5 ...

0
How to Generate Report in PDF Format Using Excel VBA (3 Quick Tricks)

This tutorial will illustrate how to generate a report in PDF format using Excel VBA. Suppose a user has to create reports every day for his company. He keeps ...

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