Categories
Excel

How to Use the IF Function in Excel

The IF function lets you evaluate a condition in your spreadsheet. Find out how to incorporate this powerful function in your workflow.Continue readingHow to Use the IF Function in Excel

Categories
Excel

How to Merge First and Last Names in Excel (3 Ways)

The need to merge first and last names seems to come up often. Here are 3 ways to combine first and last names in Microsoft Excel.Continue readingHow to Merge First and Last Names in Excel (3 Ways)

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

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!