Md. Asaduzzaman

About author

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

Latest Posts From Md. Asaduzzaman

How to Reverse Axis Order in Excel (4 Suitable Ways)

We create an Excel chart to make a dataset more understandable and realize the variations of the data. We can add axis titles, chart names, and labels of data ...

How to Create GST Bill Format in Excel with Formula

Every company, shop, bank, or other financial organization needs a GST bill format to provide an invoice to their customer for every transaction. We can easily ...

How to Solve an Equation for X When Y is Given in Excel (2 Suitable Ways)

Sometimes we have to solve an equation for X when Y is given. We can easily solve this problem using Microsoft Excel. We can perform any kind of mathematical ...

How to Create One Variable Data Table Using What If Analysis

Data tables are important parts of the Excel What-If Analysis feature to perform the sensitivity analysis of a business model. It is one of the most ...

How to Make Summary in Excel From Different Sheets

Sometimes we have to make a summary from different sheets of a workbook in Microsoft Excel. It is frequently used in schools, companies, and shops which helps ...

How to Save Excel Macro Files as Filename from Cell Value

Sometimes we need to convert a macro file into other file types like PDF, XLSX, etc. We can convert a macro file into these types of files in many ways. But if ...

How to Print Background in Excel (With Easy Steps)

Sometimes we need to print a dataset in Excel with a background. We can insert a background to our dataset if we choose the Background option from the Page ...

How to Edit Table Array in Excel (2 Suitable Ways)

Sometimes we use a table array formula in Excel and after that, we need to edit it. Editing an array formula is different than editing a normal Excel formula. ...

How to Undo and Redo in Excel (2 Suitable Ways)

Sometimes we mistakenly perform an action in Excel and we need to undo it. Again we need to redo an action sometimes. These can be easily done in Excel and it ...

How to Calculate Average Score in Excel (7 Suitable Ways)

A common task in sports is to calculate the average score of a player. Microsoft Excel makes calculating the average score easy. Excel has a variety of ...

How to Draw Shapes in Excel (2 Suitable Ways)

Sometimes we need to add different shapes to our worksheets in Microsoft Excel. This is very useful to make flow charts, decision-making charts, etc. Also, it ...

Excel Formula to Return Blank If Cell Value Is Negative

Sometimes we use a formula in Microsoft Excel and the calculated result becomes negative, which is unimportant. Instead of showing negative values, we want to ...

How to Compare Two Tables in Excel Using VLOOKUP Function

If we need to compare two tables in Excel, we can use the VLOOKUP function. It’s an easy way to compare two tables and find missing values, common values or ...

How to Calculate Present Value in Excel with Different Payments

Sometimes we have to calculate the present value of an asset or a future value in Microsoft Excel. This calculation can be done in several cases. Are you ...

How to Create Employee Attendance Sheet with Time in Excel

An employee attendance sheet is very important for any company or organization to keep track of their employees. Every company has its own employee attendance ...

Browsing All Comments By: Md. Asaduzzaman

Advanced Excel Exercises with Solutions PDF