RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)
RRI returns the constant growth rate needed to go from a start value to an end value — i.e. CAGR in one function.
Read article →Atul Vij
FVSCHEDULE Function in Excel: Growth at Changing Rates
FVSCHEDULE Function in Excel: Growth at Changing Rates
FVSCHEDULE compounds an amount through a list of different rates — FD renewals, varying annual returns.
Read article →XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV discounts cash flows that happen on irregular dates — more accurate than NPV for real projects.
Read article →SAP as Business Suite
SAP as Business Suite
SAP Business Suite is a collection of fully integrated applications such as SAP CRM, ERP, PLM, SRM, and SCM modules.
Read article →FV Function in Excel: Future Value of Savings or SIPs
FV Function in Excel: Future Value of Savings or SIPs
FinancialLevel: IntermediateAvailable in: Excel 2007+FV returns what regular investments (like a SIP or RD) grow to at a fixed rate.Syntax=FV(rate, nper.
Read article →Outlook Intermediate Lesson 8: Power Automate Flows for Email
Outlook Intermediate Lesson 8: Power Automate Flows for Email
Save invoice attachments to OneDrive automatically, get a Teams message for VIP mail and log orders to Excel with Power Automate cloud flows: no…
Read article →IRR Function in Excel: Return of Regular (Periodic) Cash Flows
IRR Function in Excel: Return of Regular (Periodic) Cash Flows
IRR returns the rate at which the NPV of regular, equally spaced cash flows is zero. For irregular dates use XIRR.
Read article →Outlook Intermediate Lesson 7: Safe VBA Macros – Save Attachments, Unread Report, Template Replies
Outlook Intermediate Lesson 7: Safe VBA Macros – Save Attachments, Unread Report, Template Replies
Three Outlook VBA macros that only read and save: save attachments of selected mails with the date in the file name, an unread-mail report…
Read article →Outlook Intermediate Lesson 6: Calendar Skills for Teams
Outlook Intermediate Lesson 6: Calendar Skills for Teams
Scheduling Assistant and room finder, shared and delegated calendars, time zones for overseas calls, Bookings pages and meeting habits that save time.
Read article →Outlook Intermediate Lesson 5: The 4D Inbox System and Category Color Management
Outlook Intermediate Lesson 5: The 4D Inbox System and Category Color Management
Set up a simple system with five colour categories and flag dates, Quick Steps and the daily and weekly routine that keeps the inbox…
Read article →MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR fixes IRR's optimistic assumption that cash is reinvested at the IRR itself, using separate finance and reinvestment rates.
Read article →SUMIFS Between Two Dates and With OR Conditions in Excel
SUMIFS Between Two Dates and With OR Conditions in Excel
Total sales between two dates, for this month, or for “North OR East”: SUMIFS with date operators, array constants, SUMPRODUCT and FILTER, with the…
Read article →