User Posts: Souptik Roy
0
How to Make a CSV File in Excel for Contacts (With Easy Steps)
0

While working on an Excel Worksheet, sometimes you may need to work with a set of information like customer information, product information, or contacts of ...

0
How to Concatenate Cells but Keep Text Formatting in Excel
0

In Excel, you can join the texts by using the CONCATENATE function. But, the problem arises when you need to keep the same text format after using the ...

0
How to Add a Comment on a Graph in Excel (3 Easy Methods)
0

While working in an Excel Workbook, you may need to add charts or graphs to make the results more attractive and easy to understand. To make the graph more ...

0
How to Use Text to Columns in Excel for Date (With Easy Steps)
0

While using Excel, you may need to use text to columns option in Excel. This option can be used for many activities. In this article, I will show you how to ...

0
How to Calculate Derivative from Data Points in Excel
0

A derivative is a common tool to calculate any rate of change of any value. You can calculate derivatives by using Excel. In this article, I will show how to ...

0
How to Calculate Prorated Salary in Excel (3 Suitable Ways)
0

While using Excel, sometimes you may need to calculate salary of employees if you run a company. To calculate the salary, you may need to calculate prorated ...

0
How to Calculate Probability in Excel (3 Practical Examples)
0

Sometimes, you need to calculate probability with your database. You can calculate this probability using Excel. In this article, I will show how to calculate ...

0
How to Do Sum of Percentages in Excel (2 Easy Ways)
0

While working with a dataset, sometimes, you need to make a percentage. After getting percentages, the sum of percentages may be required. In Excel, there are ...

0
How to Lock Borders in Excel (With Easy Steps)
0

While working in Excel, we need to deal with a lot of tables in a dataset. Sometimes we may need to lock the borders of a table in Excel. There is a few ...

0
How to Calculate YTM of a Bond in Excel (4 Suitable Methods)
0

Every company needs to buy or sell bonds for its financial activities. For these activities, every company needs to calculate Yield to Maturity (YTM) of the ...

0
How to Convert Date of Birth to Age in Excel (3 Easy Ways)
0

While working in an excel spreadsheet, sometimes we need to convert the date of birth to age. To know any person’s age, we can use some simple methods in ...

0
How to Autosum Column in Excel (4 Easy Methods)
0

When working in Excel, you need to do many kinds of operations. One of the most common operations is to make a sum of a column or a row. Calculating the sum of ...

0
How to Left Align a Chart in Excel (with Easy Steps)
0

Charts are very important tools to visualize and represent data attractively. While working with excel charts, sometimes you need to Align the Charts in Left, ...

0
How to Use CHAR(10) Function in Excel (3 Practical Examples)
0

While working in Excel, sometimes you need to break your line or connect two strings to make your report or presentation more lucrative and presentable. To ...

0
How to Calculate Average of Averages in Excel (with Easy Steps)
0

In Excel, we use to solve different types of real-life problems. One of them is to Calculate Average of Averages. In real life, an Average of averages or ...

Browsing All Comments By: Souptik Roy

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo