How to Calculate Real Interest Rate
In this lesson, you will learn how to calculate the real interest rate.
Best Excel Tutorial
Excel Skills Simplified: Tutorials That Actually Work
What is Excel and Basic Knowledge You Need to Know
In this lesson, you get to know some basic definitions in Excel.
How to use Sumproduct Function in Excel
In this Excel tutorial, you can learn how to use SUMPRODUCT function in Excel.
How to Use NPER Function in Excel
In this lesson, you can learn how to use NPER function in Excel.
How to Make Logarithmic Scale in Excel
In this Excel tutorial lesson, you will learn what a logarithmic scale is and how to use it with charts.
How to remove non-printable characters in Excel?
In this lesson, you will learn how to remove non-printable characters in Excel with the clean and substitute functions.
How to Use the IPMT Function in Excel to Calculate Loan Interest
In this lesson, you’ll learn how to use the IPMT function in Excel to calculate interest payments.
How to Use Pmt Function in Excel
In this lesson, you can learn how to calculate loan installment using PMT function in Excel.
Excel VLOOKUP Wildcards: Partial Matching with Asterisk, Question Mark and Tilde
VLOOKUP supports wildcards for powerful partial-matching. Specifically, you can use the asterisk (*) for “any number of characters”, the question mark (?) for “exactly one character”, and the tilde (~) for wildcards literally. Consequently, this enables flexible lookups when exact keys don’t exist or vary in format.
How to change the background color?
In this Excel tutorial, you’ll learn how to change the background color in Excel to customize your worksheet’s appearance.