Categories
Microsoft 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
Microsoft 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

Categories
Microsoft Excel

How to Trace Precedents and Dependents in Excel

Formulas often refer to other cells. Use trace precedents and trace dependents to better understand the structure of your Excel worksheet.Continue readingHow to Trace Precedents and Dependents in Excel

Categories
Microsoft Excel

XLOOKUP vs VLOOKUP: Excel Trainer Explains Key Differences

XLOOKUP vs VLOOKUP. They’re both lookup functions in Excel but which one should you use? We compare them and outline key differences.Continue readingXLOOKUP vs VLOOKUP: Excel Trainer Explains Key Differences

Categories
Microsoft Excel

Use the NOW Function in Excel to Work with Dates and Times

The NOW function can display the current date and time or it can be used in calculations involving other date and time values.Continue readingUse the NOW Function in Excel to Work with Dates and Times

Categories
Microsoft Excel

How to Use the Excel SORT Function to Reorder Data Quickly

The Excel SORT function reorders the contents of a range of cells in ascending or descending order and returns a dynamic array.Continue readingHow to Use the Excel SORT Function to Reorder Data Quickly