Канал: MD ISMAIL Hosen

Hide Password and Important Info Cell in Excel

Hide Password and Important Info Cell in Excel

Compatible Folder Picker Both For Windows and Mac

Compatible Folder Picker Both For Windows and Mac

Extract Search Results from Website to Excel: One click solution

Extract Search Results from Website to Excel: One click solution

Stop Copy Pasting If you want to write clean Code

Stop Copy Pasting If you want to write clean Code

Stop Making These Mistakes In Your VBA Code To Write Clean Code

Stop Making These Mistakes In Your VBA Code To Write Clean Code

Add a Calculated Column In A Table Using Office Script

Add a Calculated Column In A Table Using Office Script

Property Data Directly in Excel from ATTOM API

Property Data Directly in Excel from ATTOM API

Split A Sheets Into Multiple Sheets Based on a Column Using Office Scripts

Split A Sheets Into Multiple Sheets Based on a Column Using Office Scripts

My Intro Video for Freelance Work

My Intro Video for Freelance Work

Get Matching Rows Using Office Scripts

Get Matching Rows Using Office Scripts

Distinct Items From A Range Using Office Scripts (Not Unique ones)

Distinct Items From A Range Using Office Scripts (Not Unique ones)

10. Delete All Sheets Except Active Sheet Using Office Scripts (Be careful before running the code)

10. Delete All Sheets Except Active Sheet Using Office Scripts (Be careful before running the code)

9. Basic of Worksheet Automation in Office Scripts

9. Basic of Worksheet Automation in Office Scripts

8. Remove All #REF! Error using Office Scripts

8. Remove All #REF! Error using Office Scripts

7. Real Application of Named getType method in Office Scripts

7. Real Application of Named getType method in Office Scripts

6. Named Item Type using Office Scripts

6. Named Item Type using Office Scripts

5. Delete Named Range Using Office Scripts

5. Delete Named Range Using Office Scripts

4. Categorize all Named Range Using Office Scripts

4. Categorize all Named Range Using Office Scripts

3. Dynamically Collect All Named Range Details Using Office Scripts

3. Dynamically Collect All Named Range Details Using Office Scripts

2. Read Named Range Info Using Office Scripts

2. Read Named Range Info Using Office Scripts

1. Create Named Range Using Office Scripts

1. Create Named Range Using Office Scripts

Extract Cell Hyperlink URL using VBA

Extract Cell Hyperlink URL using VBA

Extract All Attributes of an HTML element Dynamically Using Power Query | Best Usage of Html.Table

Extract All Attributes of an HTML element Dynamically Using Power Query | Best Usage of Html.Table

Highlight Active Cell Using VBA | Control It Using Checkbox | Free AddIn To Download

Highlight Active Cell Using VBA | Control It Using Checkbox | Free AddIn To Download

Extract the URL From a Hyperlink Using Power Query | Third part of Html.Table ColumnSelector

Extract the URL From a Hyperlink Using Power Query | Third part of Html.Table ColumnSelector

Be aware of these ADODB Issues for Long Text Column

Be aware of these ADODB Issues for Long Text Column

Filter For Errors Only

Filter For Errors Only

Password Validation Using REGEXTEST | Helpful Website to learn REGEX

Password Validation Using REGEXTEST | Helpful Website to learn REGEX

Brand New Excel REGEX Functions | Clean your messed up data

Learn How to Create Custom Functions | From Basic to Advance with Practical Example

Learn How to Create Custom Functions | From Basic to Advance with Practical Example

Find Anomaly in your data using Conditional Formatting

Find Anomaly in your data using Conditional Formatting

Get Data from Data Model Using VBA

Get Data from Data Model Using VBA

cURL 101 For VBA Developer

cURL 101 For VBA Developer

Save Image Response from REST API to a file using cURL in MAC

Save Image Response from REST API to a file using cURL in MAC

Trust access to the VBA project object model In Mac Excel

Trust access to the VBA project object model In Mac Excel

Before Starting Any VBA Project

Before Starting Any VBA Project

Highlight Active Row or Column of any sheet Dynamically using VBA

Highlight Active Row or Column of any sheet Dynamically using VBA

List Down Hidden and Visible Folder Details: Shell App and Filesystem object combination.

List Down Hidden and Visible Folder Details: Shell App and Filesystem object combination.

Read more than 255 Columns From Closed Workbook Without Opening: ADODB Part 2

Read more than 255 Columns From Closed Workbook Without Opening: ADODB Part 2

Read Data From Closed Excel File Without Opening: Part1

Read Data From Closed Excel File Without Opening: Part1

Save Image Response from REST API VBA

Save Image Response from REST API VBA

Run exe from VBA: The Correct way to do it.

Run exe from VBA: The Correct way to do it.

Looping In Immediate Window: VBA Tricks You may need to know

Looping In Immediate Window: VBA Tricks You may need to know

Speed up code refactoring: VBE Pattern Matching Part2

Speed up code refactoring: VBE Pattern Matching Part2

Speed up code refactoring: VBE Pattern Matching

Speed up code refactoring: VBE Pattern Matching

How would I approach learning excel in 2024

How would I approach learning excel in 2024

Insert Image Part 1

Insert Image Part 1

Sort Table By Custom List Power Query: Multiple Practical examples included.

Sort Table By Custom List Power Query: Multiple Practical examples included.

Enum In VBA: Learn to use them correctly.

Enum In VBA: Learn to use them correctly.

How to Switch Beta Channel to Current Channel and Vice Versa Excel (2 Easy Ways)

How to Switch Beta Channel to Current Channel and Vice Versa Excel (2 Easy Ways)

How To Repair a Corrupted Excel file Which Crash Excel on Opening File

How To Repair a Corrupted Excel file Which Crash Excel on Opening File

Scrap paginated website dynamically using List.Generate M function

Scrap paginated website dynamically using List.Generate M function

Cross Tabulated Data to Proper Data Using Formula (LAMBDA Too)

Cross Tabulated Data to Proper Data Using Formula (LAMBDA Too)

TOP N Including Duplicates LAMBDA Too

TOP N Including Duplicates LAMBDA Too

Find a hidden selector in Selenium Basic

Find a hidden selector in Selenium Basic

Run Click Event JS Code in VBA Selenium Basic without clicking on the button

Run Click Event JS Code in VBA Selenium Basic without clicking on the button

MD ISMAIL Hosen Live Stream

MD ISMAIL Hosen Live Stream

Convert Long Table To Flat Table

Convert Long Table To Flat Table

Table Rows To Cols

Table Rows To Cols

Add Prefix on Record Field Names (The easy way)

Add Prefix on Record Field Names (The easy way)

Looping and Calculating final value using List.Accumulate

Looping and Calculating final value using List.Accumulate

Data Table using what-if analysis feature in excel

Data Table using what-if analysis feature in excel

Goal Seek

Goal Seek

Multiple Handler For One TextBox In VBA

Multiple Handler For One TextBox In VBA

How to use TextBox events that are not directly exposed when using WithEvents keyword

How to use TextBox events that are not directly exposed when using WithEvents keyword

Handling Similar Validation Using WithEvents Keyword in VBA

Handling Similar Validation Using WithEvents Keyword in VBA

Filter JSON Conditionally Using This Easy Technique

Filter JSON Conditionally Using This Easy Technique

Select Specific Fields From JSON Easily Using This Technique

Select Specific Fields From JSON Easily Using This Technique

This website saved me hours working with JSON

This website saved me hours working with JSON

Smart Nutrition Choices: Excel Solver's Approach to Bag Weight Management!

Smart Nutrition Choices: Excel Solver's Approach to Bag Weight Management!

Lead Collection Project

Lead Collection Project

Transform Flat Table to Long Table with Full Code and Explanation for Beginner in Excel Power Query

Transform Flat Table to Long Table with Full Code and Explanation for Beginner in Excel Power Query

Interface: Export Data Example with Code Implementation in VBA

Interface: Export Data Example with Code Implementation in VBA

Flat Table To Long Table

Flat Table To Long Table

Interface: String Manipulation Example In VBA

Interface: String Manipulation Example In VBA

Interface Implementation in VBA With Real Example

Interface Implementation in VBA With Real Example

Importance and Uses of Interface In VBA

Importance and Uses of Interface In VBA

Sample Use Case of Factory Method and Interface

Sample Use Case of Factory Method and Interface

Automate Boring Stuff

Automate Boring Stuff

3 Techniques for Character Validation You've Missed

3 Techniques for Character Validation You've Missed

How To Toggle Console In Network Tab Chromium Browser

How To Toggle Console In Network Tab Chromium Browser

Composition Vs Aggregation

Composition Vs Aggregation

Shell.Application Trap Exposed: Prevent Debugging Headaches Now!

Shell.Application Trap Exposed: Prevent Debugging Headaches Now!

Table.ReplaceValue Function: Convert Multiple Steps To One

Table.ReplaceValue Function: Convert Multiple Steps To One

Replacer.ReplaceText Vs Replacer.ReplaceValue M Function : Explanation on List.ReplaceValue

Replacer.ReplaceText Vs Replacer.ReplaceValue M Function : Explanation on List.ReplaceValue

Data Cleaning Project

Data Cleaning Project

Run M Code Hosted In Server Or Local File Using Expression.Evaluate

Run M Code Hosted In Server Or Local File Using Expression.Evaluate

Banner Info

Banner Info

Form Encoded Data In Power Query

Form Encoded Data In Power Query

Clean Data From Word Files Table To Excel

Clean Data From Word Files Table To Excel

Extract Data From PDF Files Project Review

Extract Data From PDF Files Project Review

Word File Project Review

Word File Project Review

Uniq And Dup Project

Uniq And Dup Project

File Rename Project

File Rename Project

Web Scraping Made EASY With Html.Table M function: Complete Guidelines.

Web Scraping Made EASY With Html.Table M function: Complete Guidelines.

Extract Ratings and Review Count From Amazon Using PQ: Html.Table Function

Extract Ratings and Review Count From Amazon Using PQ: Html.Table Function

Hide Password In Excel And Base64 Conversion

Hide Password In Excel And Base64 Conversion

Best M Function For Web Scrapping: Html.Table

Best M Function For Web Scrapping: Html.Table

Rename Files Project For MAC

Rename Files Project For MAC

Excel Data Refresh in the Blink of an Eye: Unleashing Speed with Table.Combine!

Excel Data Refresh in the Blink of an Eye: Unleashing Speed with Table.Combine!

FilterColumns Lambda

FilterColumns Lambda

Are You Neglecting This Technique in Power Query? Here's What You're Missing

Are You Neglecting This Technique in Power Query? Here's What You're Missing

Local Recursive Lambda Without Saving In the Name Manager

Local Recursive Lambda Without Saving In the Name Manager

Nested Each Power Query

Nested Each Power Query

CHARSEQUENCE Lambda Demo

CHARSEQUENCE Lambda Demo

Combiner CombineTextByPositions

Combiner CombineTextByPositions

Clear Concept on Row And Column Vector Operation

Clear Concept on Row And Column Vector Operation

Case Insensitive Text.Replace With Explanation

Case Insensitive Text.Replace With Explanation

Case Insensitive Text.Replace

Case Insensitive Text.Replace

Write Code Faster VBA

Write Code Faster VBA

Data Preparation AddIn Demo

Data Preparation AddIn Demo

Unblock Macro In Excel 365

Unblock Macro In Excel 365

Outlook + VBA + Power Query Project

Outlook + VBA + Power Query Project

Combination Algorithm Lexicographic

Combination Algorithm Lexicographic

Scrambler Addin Power Point Project(Paid Project)

Scrambler Addin Power Point Project(Paid Project)

Mark Different README as Github README

Mark Different README as Github README

Formula.Firewall Error: Rebuild This Data Combination(References other queries or Steps)

Formula.Firewall Error: Rebuild This Data Combination(References other queries or Steps)

Download Bulk Files Using VBA From Win API

Download Bulk Files Using VBA From Win API

Why I choose to be Freelance VBA Developer instead of Civil Engineer

Why I choose to be Freelance VBA Developer instead of Civil Engineer

Meeting With My Mentor

Meeting With My Mentor

Power Query : Case Insensitive Sorting

Power Query : Case Insensitive Sorting

How To Share and Install AddIn Excel

How To Share and Install AddIn Excel

Create Lambda In Excel : Prime Number Count

Create Lambda In Excel : Prime Number Count

Power Query Challenge : Find All Quarters Count

Power Query Challenge : Find All Quarters Count

Data Entry Form In 60 Second

Data Entry Form In 60 Second

Data Entry Form In 60 Second #sorts

Data Entry Form In 60 Second #sorts

Excel Formula Challenge : Total goal scored & sort team in descending order on total goals

Excel Formula Challenge : Total goal scored & sort team in descending order on total goals

Power Query Challenge : Create Pivot Unpivot

Power Query Challenge : Create Pivot Unpivot

Power Query Challenge : Merge Duplicate Warning

Power Query Challenge : Merge Duplicate Warning

Excel Formula Challenge : Even Or Odd License Plates

Excel Formula Challenge : Even Or Odd License Plates

Excel Power Query : Data Stack Challenge

Excel Power Query : Data Stack Challenge

Power Query Challenge : Find Out Maximum Scorer

Power Query Challenge : Find Out Maximum Scorer

Excel VBA : Create Custom Events In OOP

Excel VBA : Create Custom Events In OOP

Excel Lambda Challenge : Find Out Longest Word in a Sentence

Excel Lambda Challenge : Find Out Longest Word in a Sentence

Formula Challenge : Difference Of Square Matrix Trace

Formula Challenge : Difference Of Square Matrix Trace

Power Query Challenge : Split By Unknown character

Power Query Challenge : Split By Unknown character

Power Query Challenge : Columns to Rows Challenge

Power Query Challenge : Columns to Rows Challenge

Power Query Challenge : Add Custom Index

Power Query Challenge : Add Custom Index

Power Query Challenge : Flex Your Power Query Skills

Power Query Challenge : Flex Your Power Query Skills

AUTOHOTKEY : Run and Stop AUTOHOTKEY

AUTOHOTKEY : Run and Stop AUTOHOTKEY

AutoHotKey : Context Sensitive Hotstring

AutoHotKey : Context Sensitive Hotstring

AUTOHOTKEY : HotString & Their Usage

AUTOHOTKEY : HotString & Their Usage

Excel VBA : Install AutoHotkey and Use Case for VBA

Excel VBA : Install AutoHotkey and Use Case for VBA

Vba Integration : Find Any Application Path

Vba Integration : Find Any Application Path

Power Query Challenge : Creating Dynamic Column

Power Query Challenge : Creating Dynamic Column

Power Query Challenge : Generate Multiple Columns

Power Query Challenge : Generate Multiple Columns

Power Query Challenge ( What Did They Choose )

Power Query Challenge ( What Did They Choose )

Power Query Challenge (Find Score From Text )

Power Query Challenge (Find Score From Text )

SOLID Principle : Open Closed Principle (OCP)

SOLID Principle : Open Closed Principle (OCP)

Solid Principle : Single Responsibility Principle(SRP)

Solid Principle : Single Responsibility Principle(SRP)

Dynamic Table Transformation

Dynamic Table Transformation

Vstack N Times and Repeat Each Row N Times Using LAMBDA

Vstack N Times and Repeat Each Row N Times Using LAMBDA

Frequency Count Using Excel LAMBDA

Frequency Count Using Excel LAMBDA

Extract Number From Text Using LAMBDA ||| Don't Miss The Last Part.

Extract Number From Text Using LAMBDA ||| Don't Miss The Last Part.

CLOCKIFY REST API ( Patch Method )

CLOCKIFY REST API ( Patch Method )

Clockify REST API (PUT and DELETE)

Clockify REST API (PUT and DELETE)

Clockify REST API (GET And POST)

Clockify REST API (GET And POST)

Long Table To Flat Using Power Query (Use Table.FromColumns)

Long Table To Flat Using Power Query (Use Table.FromColumns)

VBA Loop Class 5

VBA Loop Class 5

OOP VBA Part 06 ( Encapsulation)

OOP VBA Part 06 ( Encapsulation)

Map Date Power Query Challenge : Map Date To Event

Map Date Power Query Challenge : Map Date To Event

OOP VBA PART 05 (Composition vs Aggregation : Clear Your Concept)

OOP VBA PART 05 (Composition vs Aggregation : Clear Your Concept)

Lambda Challenge Solution

Lambda Challenge Solution

Listbox Intro VBA Class 4

Listbox Intro VBA Class 4

OOP VBA Part 04 (Composition instead of Inheritance)

OOP VBA Part 04 (Composition instead of Inheritance)

Power Query Survey Respons Challenge Solution

Power Query Survey Respons Challenge Solution

Userform Intro VBA

Userform Intro VBA

OOP VBA Part 3 (Polymorphism)

OOP VBA Part 3 (Polymorphism)

Write Good M Function

Write Good M Function

Long Table to Flat Another Way

Long Table to Flat Another Way

OOP VBA Part 2 (Abstraction)

OOP VBA Part 2 (Abstraction)

Long table to flat table using POWER QUERY

Long table to flat table using POWER QUERY

CALL API FROM VBA

CALL API FROM VBA

Flaten Table

Flaten Table

Data Type VBA Class 2

Data Type VBA Class 2

VBA Lecture 1

VBA Lecture 1

Class 34

Class 34

Text Data Type Power Query

Text Data Type Power Query

New Context Menu For XLSM File

New Context Menu For XLSM File

Identifier Class 32

Identifier Class 32

Data Cleaning function Power Query

Data Cleaning function Power Query

Taking Input From User Power Query

Taking Input From User Power Query

Trace Log Demo

Trace Log Demo

Data Cleaning Class 29

Data Cleaning Class 29

Data Cleaning and Optimize Solution Class 28

Data Cleaning and Optimize Solution Class 28

Add Multiple Column With Default Value In Power Query Just in one click

Add Multiple Column With Default Value In Power Query Just in one click

Question And Answer

Question And Answer

Data Cleaning Example

Data Cleaning Example

Closure and Recursion in Power Query

Closure and Recursion in Power Query

Function Value, Pass Function as Input Power query

Function Value, Pass Function as Input Power query

Function From Scratch Class 21

Function From Scratch Class 21

Class 21 Custom Function M

Class 21 Custom Function M

Class 20Custom M Function On Action

Class 20Custom M Function On Action

Class 19 Custom Function

Class 19 Custom Function

Class 18 List , Text functions

Class 18 List , Text functions

Class 17 Part1 Data Cleaning using Power Query

Class 17 Part1 Data Cleaning using Power Query

Class 17 Part2 Data Cleaning using Power Query

Class 17 Part2 Data Cleaning using Power Query

Lecture 16List And Text Functions

Lecture 16List And Text Functions

Class 15 Group By Power Query

Class 15 Group By Power Query

Class 14(Power query data cleanup)

Class 14(Power query data cleanup)