Al Arafat Siddique

About author

Hello! This is Arafat. Here I'm researching Microsoft Excel. I did my graduation from Bangladesh University of Engineering and Technology(BUET). My interest in data science and machine learning allured me to play with data and find solutions to real-life problems. I want to explore this data-driven world and make innovative solutions.

Latest Posts From Al Arafat Siddique

0
How to Send Email from Excel with Body Using a Macro (with Easy Steps)

This article illustrates 11 easy steps to send an email from Excel with a body using a macro. We’ll be using the Microsoft Outlook under the hood by accessing ...

0
[Fixed!] Excel File Not Opening on Double Click (8 Possible Solutions)

This article illustrates how to fix the issue of not opening an Excel file on double click with 8 possible solutions. The issue can be caused for many reasons. ...

0
Excel VBA: Unprotect Workbook with Password (7 Practical Examples)

This article illustrates how to unprotect a workbook that is protected with a password using VBA in Excel with 7 suitable examples. Excel allows the feature to ...

0
Excel VBA: Unprotect All Sheets (4 Suitable Examples)

This article illustrates 4 suitable examples to unprotect all sheets in a workbook in Excel using VBA. Excel allows the feature to protect sheets with or ...

0
How to Forecast Sales Using Regression Analysis in Excel (3 Methods)

The following article illustrates 3 different methods to forecast sales by using regression analysis in Excel. We’ll find the regression line equation of the ...

0
Excel VBA: Replace Character in String by Position (4 Effective Ways)

This article illustrates how to replace a character in a string by position using VBA in Excel with 4 effective approaches. We’ll use Excel’s built-in ...

0
How to Create a Database That Updates Automatically in Excel

This article illustrates how to create a database in Excel that updates automatically with the help of 4 useful methods. It’s an important feature required ...

0
Excel VBA: Open Word Document and Paste (3 Suitable Examples)

This article illustrates how to open a new or existing word document from Excel and paste data into it using VBA with 3 different examples. We’ll use Excel’s ...

0
How to Import Text File to Excel Using VBA (3 Easy Ways)

This article illustrates how to import a text file to Excel using VBA code with 3 suitable examples. We’ll use Excel’s built-in Split, InStr, and Replace ...

0
Excel Macro to Save as PDF with Filename from Cell Value (2 Examples)

This article illustrates 2 different examples to save an active sheet as a PDF with a filename that comes from a cell value using a Macro in Excel. We’ll use ...

0
How to Import Text File with Multiple Delimiters into Excel (3 Methods)

This article illustrates how to import Text File data with multiple delimiters into an Excel worksheet using 3 different methods. We’ll use Excel’s built-in ...

0
Excel VBA: Split First Name and Last Name (3 Practical Examples)

This article illustrates several approaches that split a full name into its first name and last name components using VBA code in Excel. We’ll use Excel’s ...

0
Excel VBA: Split String by Character (6 Useful Examples)

This article illustrates how to split a string that is separated by a character using the Split function in Excel VBA. We’ll configure different arguments of ...

0
How to Hide Blank Rows in Excel VBA (4 Useful Examples)

This article illustrates how to hide rows that are entirely blank or have blank cells in them using VBA code in Excel. Here we’ll use Excel’s built-in ...

0
Excel VBA: Get Row and Column Number from Cell Address (4 Methods)

This article illustrates how to get the row and column number from cell address using VBA code in Excel. We’re going to use several built-in functions to ...

Browsing All Comments By: Al Arafat Siddique

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo