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.
The SUMIFS function is for sure, without a doubt, one of my most favorite Excel functions of all time. I’m sure I use it in well over half of my workbooks, and it is a must-know function for Excel users. I’ll try to get you warmed up, but just know that this post only gets…Read More
As you probably know, I like converting manual input cells to formula cells in Excel. To me, the more I can delegate to Excel the better off I am. Some workbooks can benefit by automatically computing the last day of the month, eliminating one more manual input cell. As you also know, it seems that…Read More
Thanks to Excel’s PMT function, computing the monthly payment of a loan with various terms is easy. In summary, you provide the function with the basic loan information, including the loan amount, the interest rate, and the term, and the function will compute the payment. You provide this basic loan information to the function through…Read More