Have you ever copied a formula to another tab in your workbook, and the result was not at all what you expected? Moved a formula to a new location and were surprised that it didn’t change?
If you’ve ever repeated the same actions multiple times in a spreadsheet, you’ll benefit from recording a macro to automate those tasks. But, once you have a macro, how do you access it? The easiest way is to add a macro button to your spreadsheet, for which Excel offers three straightforward methods: Add a button…
How often do you need to insert a favorite chart style, consistent with your prior submission, to maintain a consistent look and feel to your monthly reporting packages? That consistency is one element that increases the appearance of professionalism—especially if it reflects your company’s brand, typography, and color scheme.
Have you ever needed to calculate a person’s age from a birthdate in Excel? Or find the number of years since the last audit?
You have created a report that shows your company’s sales by month. Your boss asks you to add a row that shows the change from the prior month. You need to subtract the prior month’s sales from the current month’s sales.
One of the more tedious tasks in Excel is to copy a formula down an entire column of a report. Not only is it mind-numbing, but it also leaves the opportunity for error if you don’t copy the formula down to exactly the correct cells. For best results, try one of the methods below.
Have you been tasked with creating a flowchart to document a business process? Some companies invest in expensive, specialized software that builds flowcharts for you with just a few points and clicks. Other businesses prefer to use a tool which they already have, and in which the employees have already been trained: Excel.
Does your code need to execute the same action more than once? Instead of programming it multiple times, try writing it once and repeating it with a loop.
Microsoft eliminated the Excel Chart Wizard in Excel 2007, and it has not returned in the successive versions. In fact, the company rebuilt the entire chart system, and the team decided it would not be worthwhile to update the wizard and all of its options.
Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer?