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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...