User Posts: Souptik Roy
0

## How to Make a CSV File in Excel for Contacts (With Easy Steps)

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

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)

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)

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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  