Categories
Excel

How to Use the NPER Function in Excel Like a Boss!

The NPER function will calculate the number of payment periods required to repay a loan or reach a savings goal. Read on to learn more!Continue readingHow to Use the NPER Function in Excel Like a Boss!

Categories
Excel

How to Use the Excel SUBTOTAL Function to Analyze Data

The SUBTOTAL function in Excel lets you quickly and easily perform various calculations to summarize data in a list or database.Continue readingHow to Use the Excel SUBTOTAL Function to Analyze Data

Categories
Excel

How to Find and Fix a #REF! Error in Excel (Stay Calm!)

Excel displays a #REF! error when a formula references a cell that doesn’t exist. Learn how to find and fix #REF! errors like a boss!Continue readingHow to Find and Fix a #REF! Error in Excel (Stay Calm!)

Categories
Excel

How to Use Icon Sets with Conditional Formatting in Excel

You can use icon sets in Microsoft Excel to visually enhance data with arrows, check marks, flags, and other objects. Read on to learn how!Continue readingHow to Use Icon Sets with Conditional Formatting in Excel

Categories
Excel

Use EDATE to Add Months to a Date in Excel

You can use the EDATE function to add months to a date in Excel. Great for calculating due dates or maturity dates in one month increments.Continue readingUse EDATE to Add Months to a Date in Excel

Categories
Excel

How to Use the Excel IFNA Function and Why You’ll Want To!

The Excel IFNA function returns an alternate value as specified by the user when a formula returns an #N/A error. Read on for all the details!Continue readingHow to Use the Excel IFNA Function and Why You’ll Want To!