We all know that keyboard shortcuts are the fastest way to accomplish most tasks in Excel. I already showed you my top 10 keyboard shortcuts, and you can get a free quick reference for them when you join the newsletter. Unfortunately, not every common action in Excel has a keyboard hot-key assigned to it by default. Paste Values, for example, is one of the most common actions when formatting spreadsheets, but the only keyboard access for it is the cumbersome ALT+H+V+V through Excel Key Tips. Here, we’ll show you how to make your own custom keyboard shortcuts with macros by giving Paste Values the convenient CTRL+SHIFT+V it should have had all along… Continue reading Make Your Own Custom Keyboard Shortcuts Using Macros
Tag Archives: VBA
Car Loan Calculator, Part 4: Data Visualization Using Conditional Formatting, Charts, and VBA
By the end of Part 3 of this series, we have a very functional car loan calculator that gives us a detailed view of the trade-offs between interest rates and loan terms. With all this data at our fingertips, the purpose of a tool can get lost. This is where data visualization can save the day. A clear chart or graph can turn a complicated mountain of information into a simple, intuitive business decision. In Part 4, we’ll change our car loan calculator from an analyst’s tool into a user-friendly application by adding a dynamic chart and heat map using conditional formatting and a little bit of VBA. Continue reading Car Loan Calculator, Part 4: Data Visualization Using Conditional Formatting, Charts, and VBA