A.N.M. Mohaimen Shanto

About author

A.N.M. Mohaimen Shanto, a B.Sc. in Computer Science and Engineering from Daffodil International University, boasts two years of experience as a Project Manager at Exceldemy. He authored 90+ articles and led teams as a Team Leader, meticulously reviewing over a thousand articles. Currently, he focuses on enhancing article quality. His passion lies in Excel VBA, Data Science, and SEO, where he enjoys simplifying complex ideas to facilitate learning and growth. His journey mirrors Exceldemy's dedication to excellence and continuous learning.

Designation

Project Manager at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Computer Science and Engineering (CSE) from Daffodil International University.

Expertise

Data Analysis, Content Writing, C, C++, Python, HTML, SQL, MySQL, Data Science, Microsoft Office, and Project Management.

Experience

Project Manager, SOFTEKO

November 2022 - Present
  • Spearhead the management of article projects, overseeing the entire site structure to enhance user engagement and content accessibility.
  • Implement strategic content plans, including developing editorial calendars and style guides, tailored to project objectives.
  • Lead and supervise a diverse team of content creators, fostering an environment of creativity and high performance.
  • Utilize data analytics to monitor content performance, generating insightful reports to inform future content strategies and development.

Team Leader, SOFTEKO

April 2022 - October 2022
  • Led a team of content professionals in producing high-quality Excel-related articles, ensuring both accuracy and engagement.
  • Conducted thorough reviews and quality checks of over 500 articles, maintaining high standards of content excellence.
  • Facilitated team brainstorming and research sessions, aimed at optimizing content creation processes and team productivity.

Excel and VBA Content Developer, SOFTEKO

 October 2021 - April 2022
  • Authored over 100 informative and user-friendly articles on Excel and VBA, contributing significantly to the knowledge base and user assistance.
  • Employed expert knowledge of Excel and VBA to provide practical solutions and guides, enhancing the utility value of the content.

Online Certifications

  • IBM Data Science Professional Certificate Offered by IBM on Coursera This nine-course specialization covered a wide array of data science topics including open-source tools and libraries, methodologies, Python, databases, SQL, data visualization, data analysis and machine learning.
  • “Managing the Company of the Future” Completed May, 2020 at Coursera.org. Taught by Julian Birkinshaw, University of London.
  • “Cloud Computing Basics” Completed June, 2020 at Coursera.org. Authorized by LearnQuest
  • “Industrial IoT on Google Cloud Platform” Completed May, 2020 at Coursera.org. Authorized by Google
  • “Communication Skills: Be a Star Presenter on a panel” Completed at Udemy.com

Summary

  • Currently working as Project Manager of ExcelDemy
  • Started technical content writing of Excel & VBA in October 2021 later prompted as Team Leader for Content Management.

Latest Posts From A.N.M. Mohaimen Shanto

0
Excel VBA: Copy Worksheet to Another Workbook Without Opening

We'll use the following source file "Source", saved in the .xlsm format. We'll use VBA code to copy a worksheet named "Dataset" to another workbook. ...

0
Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

In Microsoft Excel, you will encounter various situations where you will have to concatenate multiple cells. It is one of the crucial Excel tasks. Sometimes, ...

0
How to Convert Week Number to Date in Excel (2 Suitable Methods)

Method 1 - Using the DATE and WEEKDAY Functions to Convert Week Number to Date There are no straightforward functions to convert the week number to date in ...

0
How to Convert Multiple Columns into a Single Row in Excel: 2 Methods

Method 1 - Convert Multiple Columns into a Single Row with Formula You will find the dataset in the sheet named “Dataset”. Convert these columns to a ...

0
How to Calculate Turnaround Time in Excel (4 Ways)

While working with Microsoft Excel date-time, you will have to perform a lot of things based on this. One of them is turnaround time. We use the turnaround ...

0
Excel Formula To Calculate Time Worked

Formula 1 - Excel Subtraction Formula To Calculate Time Worked The formula to calculate the time difference is to subtract the start time from the end time. ...

0
How to Calculate Percentage Increase in Excel (Examples with All Criteria)

In Microsoft Excel, working with percentage change, percentage increase, or percentage decrease is one of the familiar tasks. We calculate the percent change ...

0
How to Insert a Date Picker in Excel (With Step-by-Step Procedure)

In Microsoft Excel, many essential tools create a great user experience. One of them is the Date Picker. With this tool, you can insert any date and time in a ...

0
How to Use ‘Column Index Number’ Effectively in Excel VLOOKUP

Brief Description of the VLOOKUP Function In the below example, there is a movie dataset. Here, we used the VLOOKUP formula to extract data.   ...

0
Rank IF Formula in Excel (5 Examples)

Excel Rank Function To rank multiple items there is a built-in Excel RANK Function, which ranks multiple values based on a column that you specify, in either ...

0
How to Print and Fit to One Page in Excel (10 Easy Methods)

Printing data from Excel spreadsheets is a common requirement in various professional and personal scenarios. We have to ensure that the printed output appears ...

0
How to Link Cells in Excel (7 Ways)

In Microsoft Excel, linking cells is one of the crucial tasks. You will face many instances where you may have to connect cells. When cells are linked, you can ...

0
How to Create a Hyperlink in Excel (5 Easy Ways)

In Microsoft Excel, the hyperlink is one of the crucial matters. We use this hyperlink for various purposes. It helps us directly go to a link, a specific ...

0
How to Sort and Filter Data in Excel – A Complete Guideline

  What is Sort and Filter in Excel? Sort and filter options in Excel narrow down a dataset allowing a deeper analysis. Using the filter tool, you can ...

0
How to Remove Data Validation Restrictions in Excel (3 Ways)

In Microsoft Excel, data validation is one of those tasks that makes it easy to input data. If you want to limit your input data type, you can use this method. ...

Browsing All Comments By: A.N.M. Mohaimen Shanto
  1. Thank You JUAN. Very glad to know that this article helped you.

  2. Hello P MUMU,
    We are glad to know that this article helped you to solve your problem. For more like this, make sure to check our other articles from ExcelDemy.

  3. Hello Polina. Thanks for asking. Basically, you have to change the cell references here.
    Suppose you have data in the following ranges:
    1. N3:N13
    2. P1:P19
    3. AB13:AB20
    4. CC10:CC20

    Just use the following code:

    Sub ConvertTextToNumber()
    With Range(“N3:N13”)
    .NumberFormat = “General”
    .Value = .Value
    End With

    With Range(“P1:P19”)
    .NumberFormat = “General”
    .Value = .Value
    End With

    With Range(“AB13:AB20”)
    .NumberFormat = “General”
    .Value = .Value
    End With

    With Range(“CC10:CC20”)
    .NumberFormat = “General”
    .Value = .Value
    End With

    End Sub

    There are various ways. But this is the simplest.

  4. Hello HOWARD,
    Thanks for asking this important question. Basically scenario summary will show the latest dataset in the current values column. As we changed the scenario by clicking OK.

    Now, this is not a wonderful solution. But it may help you.

    1. Copy the original dataset to a new sheet.
    2. Then go to Scenario Manager
    3. Now click Summary.
    You will see the original data in Current Values.
    Thank You.

  5. Hey Luna, you can use VBA codes to solve your problem if these methods don’t work.
    Read this article:
    https://www.exceldemy.com/convert-text-to-number-excel-vba/

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo