 
|
You can use Excel VBA to show messages to someone who's using your workbook. This messages lets the user know that a customer name must be selected, and there's an OK button to click after reading the message. (No one would ever click the OK button without reading the message, would they?) But sometimes [...] In the old days, the Sort dialog box in Excel only had 3 levels. However, with a bit of planning, you could sort Excel data by 4 columns or more, and once you learned that trick, life was good. Or at least it was sort of good. ;-) In Excel 2007, the Sort dialog [...] You might not love the Ribbon in Excel 2007, but the user interface does have new features that are an improvement over Excel 2003. The new features are useful when you're working with large formulas or long names. Change the Formula Bar Height In Excel 2003, if you click on a cell that contains a [...] Are you too old to compete in the Olympics? Maybe you’re not as bendy as those 16-year-old figure skaters, but there might be other sports with athletes about your age. Athlete bios are posted on the Vancouver 2010 Winter Games website, and I compiled that data, then created a few Excel pivot tables, to [...] You have two Excel lists, and you’re trying to find the items that are in both lists. You know there are matching items, but your VLOOKUP formulas can’t find them. In this screenshot, the tiptech.html page is in both lists, but the VLOOKUP formula in cell C2 can’t find it. Spot the Differences [...] Yesterday, Seth Godin suggested that we should invent a holiday to celebrate the things that we love. For example, today is Family Day here in Ontario, Canada, a holiday that has only existed for a couple of years. It’s nice to have the day off, and that gave me the chance to think about other [...] If you've wanted to try Tableau data visualization software, now's your chance! They've just launched Tableau Public, where you can upload your data, and use the free Tableau tools to create amazing interactive charts, maps and dashboards. This example shows Economic Indicators & Stock Market Returns, and you can select from a drop down list [...] You added some data validation drop down lists to your Excel worksheet, to make it easier to enter the data. Later, you opened that workbook, and the data validation arrows were missing! What happened, and how do you get those arrows back? Select the Cell The data validation drop down arrow only shows when you [...] You can create order forms and price lists in Excel, and automatically show a price when a product is selected in the order form. But what happens if you want to give some customers special pricing, or offer sales pricing occasionally? Using the VLOOKUP Function With a simple VLOOKUP function in Excel, you can pull [...] After you update the source data for a pivot table, and refresh the table, some of the old data might still appear in the pivot table drop downs. For example, you changed a product name from Whole Wheat to Whole Grain, and now both names show up in the pivot table’s Product drop down. [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
