Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Whether you’re tracking your personal or business finances, an average daily balance calculator in Excel can help you get a better understanding of your loan payments, and it can also be useful for creating payment projections. The average daily balance method is commonly used to calculate finance charges for credit card balances, as well as…Read More
Want to know how to use Excel for finance & budgeting? Here’s how to create a customizable budget that accurately tracks income and expenses.Read More
The family of IFS functions, such as SUMIFS and COUNTIFS, use AND logic when evaluating multiple conditions. In other words, all conditions must be true to be included. And generally, this logic works well. However, there are situations when we’d like to use OR logic instead. That is, any of the conditions can be true…Read More
Let’s face it, Excel users probably insert the SUM function more often than any other function. As you know, we can improve our productivity by keeping our hands on our keyboards. This post discusses my favorite keyboard shortcut for inserting the SUM function. Keyboard Shortcut The SUM function is easily inserted into a workbook with…Read More