Joe maintains a sales register of all over 50 products in Excel. He has one sheet for every month and a Totals sheets that consolidates data from the other sheets. Every now and then the company launches a new product and Joe has to go through the painful exercise of updating every sheet, adding the new products and changing the formula. It takes a long time to do that and he tends to make a mistake in one or two sheets which takes him hours to find and fix.
Watch the video below to learn a few simple techniques that reduces the time spend on updates by more than 90%. n.b. Pay attention to the various shortcuts that I demonstrate in the video that you can apply in other places too.