Al Arafat Siddique

About author

Al Arafat Siddique, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, has worked on the ExcelDemy project for two years. He has written over 85+ articles for ExcelDemy. Currently, he is working as a software developer. He is leading a team of six members to develop Microsoft Office Add-ins, extending Office applications to interact with office documents. Other assigned projects to his team include creating AI-based products and online conversion tools using the latest web technologies.

Designation

Software Developer

Lives in

Dhaka, Bangladesh.

Education

B.sc in Naval Architecture and Maring Engineering, Bangladesh University of Engineering and Technology

Expertise

React JS, Express JS, Next JS, Redux, MySQL, MongoDB, Prisma ORM, Git, Laravel, Jest, RTL, Server Management

Experience

  • Project Management
  • Technical Content Writing

Summary

  • Currently working as Technical Lead in Web Technologies in Software Development Team.
  • Started technical content writing of Excel & VBA in December 2021 and later joined the software development team after 6 months.

Latest Posts From Al Arafat Siddique

1
How to Calculate Centered Moving Average in Excel: 2 Examples

Method 1 - Calculate the Centered Moving Average for Odd No. of Periods Calculate this dataset's centered moving average for odd no periods. The dataset shows ...

0
How to Turn On/Off Scroll Lock in Excel

Step 1. Check the Status Bar in Excel The status bar in Excel provides useful information about the active worksheet. We can customize the status bar to set ...

0
How to Fix Hidden Rows in Excel (4 Effective Solutions)

Dataset Overview Let’s delve into various solutions to address the issue of being unable to unhide rows in Excel. For our demonstration, we’ll work with a ...

0
How to Show Percentages in an Excel Pie Chart: 3 Methods

Below, we have the population percentages by major ethnic groups in Southern California. We have created a pie chart using this data and added percentages. ...

0
How to Use VLOOKUP with Multiple Criteria Including a Date Range: 2 Examples

The following dataset will be used. The dataset contains prices of three different products during 3 quarters of the year 2021. From this dataset, we ...

0
How to Sort Merged Cells in Excel: 2 Easy Methods

Method 1 - Unmerge First to Sort Merged Cells in Excel 1.1 Single Column Steps: Part-1 Select the cells that we need to sort. Click on the Merge ...

0
How to Extract Hyperlink from URL in Excel (3 Methods)

We’ll use a bunch of URLs from the Exceldemy website to show how you can extract them. Method 1 - Create a User-Defined Function to Extract a ...

0
How to Sort Range Using VBA in Excel (6 Examples)

Knowing how to sort range using VBA in Excel saves time and effort in our daily calculations. Although Excel provides a sorting facility by default, using the ...

0
How to Remove Negative Sign in Excel (7 Methods)

Method 1 - Remove the Negative Sign in Excel Using the ABS Function We have a list of numbers in cells B4:B10 with both positive and negative. In cell ...

0
How to Filter Horizontal Data in Excel (3 Methods)

The sample dataset contains sales data for 8 products that fall into 3 different categories. We will discuss 3 suitable methods to filter this dataset based on ...

0
How to Use VBA MkDir Function in Excel (4 Examples)

We’ll first discuss how to write code in the Visual Basic Editor. Follow the simple steps to create the setup for writing your code. Steps: Go to the ...

0
How to Auto Refresh Pivot Table in Excel (2 Methods)

To illustrate how to refresh an Excel pivot table, we created two pivot tables for a dataset. The dataset shows a list of sale data with all required details ...

0
How to Get the Sheet Name in Excel (2 Methods)

Method 1 - Using Excel Formula Excel lacks a built-in function to directly retrieve the sheet name, but we can create a formula using the MID, CELL, and ...

0
How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)

In this article, we’ll demonstrate how to count filtered data using the COUNTIF function together with the SUBTOTAL function. Download the Practice ...

0
How to Use Cell References in Excel Formula (All Possible Ways)

Method 1 - Use of Relative Cell Reference in Formila in Excel  Steps: In cell F5, write the following formula to calculate the Price as a product of the ...

Browsing All Comments By: Al Arafat Siddique

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo