In this short article, I will show how to calculate periodic interest rate in Excel. I will show 4 methods of calculating the periodic interest rate. 1) Calculate periodic interest rate when ...
READ MORE +
In many cases, after working with your Excel worksheets you may want some of the selected worksheets to be aligned in the center position of the pages while printing. In this article, we will perform ...
READ MORE +
In this article, I will create a report that displays the quarterly sales by territory. You can call it also a dynamic and interactive Excel dashboard that will be updated automatically to reflect ...
READ MORE +
Suppose you have an employee name who recently resigned from your company. You want to calculate his/her years of services at your company. There are many ways to calculate that. We can use many ...
READ MORE +
Summing up multiple rows and column in Excel is important for many purposes. In this article, we will see different techniques on how to sum multiple rows and columns in Excel. Functions like SUM, ...
READ MORE +
Sometimes it is often required to round numbers to its nearest hundreds or thousands. In this article, we will see how Excel round to nearest 1000. There are many formulas for doing that. Besides ...
READ MORE +
In this article, I am going to show you "How to Remove Table Formatting in Excel". Sometimes it is important to remove table formatting in Excel. People often face difficulties while doing that but ...
READ MORE +
It is often required in Excel to find out the total number of working days between two dates. Usually while counting this, we often neglect the weekends and holidays. Excel has two different ...
READ MORE +
Spell checking is mandatory sometimes while working in an Excel Worksheet. In this article, we will see how to perform a spelling check on the active worksheet of Excel. The methods are very simple. ...
READ MORE +
In this article, we are going to discuss the Excel custom number format multiple conditions. We will learn about the meaning and uses of different symbols of the custom number formatting. The custom ...
READ MORE +
In this article, you will see how to round numbers in Excel without formula. You will get to see a number of processes to round up, round down and chop off decimal numbers in Excel. Here we will ...
READ MORE +
While working with a big range of data it is often required to find the number of specific text. In this article, we will count cells that contain specific text. In Excel, counting cells that contain ...
READ MORE +
In this article, we will see how VLOOKUP and HLOOKUP Combined functions work together in Excel formulas. Here we will use VLOOKUP and HLOOKUP combinedly to solve a problem. The basics of VLOOKUP and ...
READ MORE +
In this article, I will discuss how to calculate IRR (internal rate of return) in Excel. I will focus on several topics like: Calculating IRR using Excel’s IRR & XIRR function Calculating ...
READ MORE +
Data Validation is an important feature in Excel. In this article, we will see how Excel data validation based on another cell is created. Data validation makes a list more creative and ...
READ MORE +ExcelDemy is a place where you can learn Excel, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide Excel solutions to your business problems.
ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. I earn a small commission if you buy any products using my affiliate links to Amazon.
