Have you ever worked in a workbook with only a few worksheets…say three or four sheets? Navigating to the correct sheet is fast and easy, and you spend very little time getting to the spot you need to be to do your work. Have you ever worked in a workbook with more sheets? Say, 10, […]
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 […]
Overview Starting with Excel 2007, Microsoft enhanced the Excel Cell Styles feature providing great built-in choices and flexibility. The purpose of this post is to briefly discuss the styles feature and demonstrate how it can be used in conjunction with worksheet protection.