Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft Office Suites.
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 ...
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 ...
While using Excel, you may need to use the text-to-columns option in Excel. This option can be used for many activities. In this article, I will show you how ...
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 ...
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 ...
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 ...
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 a ...
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 ...
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 ...
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 ...
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, ...
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 ...
In Excel, we use to solve different types of real-life problems. One of them is to Calculate the Average of Averages. In real life, an Average of averages or ...
To perform calculations and retrieve data based on the values in specific cells, you must know how to use a cell address in Excel Formula. However, it can be ...
In Excel, graphs are so important to visualize data or results after any kind of operation. Most of the time, for business purposes, there is no need to show ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS