When your spreadsheet has a financial focus, key figures should be displayed using the accounting number format. Read on to find out how!Continue readingHow to Apply the Accounting Number Format in Excel (3 Ways)
Category: Excel
Articles, shortcuts, tips and tricks designed to help Microsoft Excel users get more out of the business world’s leading spreadsheet application.
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!
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
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!)
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
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