How to Filter a Table in Excel

How to Filter a Table in Excel

by | Jun 18, 2019

Data filters are essential for reporting and decision making. In Excel, you will get filter arrows by default when you create a new table. In this guide, we’re going to show you tips about how to filter Excel Tables. For more information about creating Excel...
Function: EDATE

Function: EDATE

by | Jun 17, 2019

The Excel EDATE function is a Date & Time formula that calculates and returns the serial date number for a certain number of months before or after a given date. EDATE function is useful for calculating maturity dates or due dates that fall on the same day of the...
Function: DATEDIF

Function: DATEDIF

by | Jun 16, 2019

The DATEDIF Excel function is a Date & Time formula that calculates and returns the number of days, months, and years difference between two dates. The DATEDIF function has been derived from Lotus 1-2-3 for compatibility, and is still kept in Excel for backwards...
How to add Total row in Excel Tables

How to add Total row in Excel Tables

by | Jun 13, 2019

Excel Tables are very useful for organizing and reporting data in a tabular format. Furthermore, you can also add a dynamic row to your table to display aggregate data while still utilizing the Excel Table features, like using the same styling and automatically...
Function: RRI

Function: RRI

by | Jun 13, 2019

The Excel RRI function is a Financial function that calculates and returns the equivalent interest rate for the growth of an investment. When given a present value, a future value, and the number of periods for an investment, you can calculate the rate of return for...
Slicers in Excel Tables

Slicers in Excel Tables

by | Jun 12, 2019

Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. An Excel Table contains...
How to Change Table Style in Excel

How to Change Table Style in Excel

by | Jun 12, 2019

Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. In this guide, we’re...
Function: NPER

Function: NPER

by | Jun 11, 2019

The NPER function is a Financial formula that calculates and returns the number of repayment periods of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel NPER function and also go over some tips and error...
Function: PMT

Function: PMT

by | Jun 10, 2019

The PMT is a Financial function that calculates and returns the repayment amount of a loan based on constant payments and a constant interest rate. This formula is commonly used in amortization schedule Excel models. In this guide, we’re going to show you how to use...