 
|
In Excel 2007 and Excel 2010, you can use the new SUMIFS function to sum items using multiple criteria. For example, sum the orders where an account status is Active, and the number of visits is greater than or equal to 10. You can type in the criteria, but it's better to use cell [...] In Excel 2007 and Excel 2010, you can use the new COUNTIFS function to count, based on multiple criteria. For example, in a list of orders, you can find out how many orders were for pens, and had a quantity of 10 or more. I have updated the Contextures COUNT Functions page, to include [...] You're admired by your co-workers, thanks to your awesome Excel skills. Cupcakes magically appear on your desk, in thanks for your help with complex formulas. Your boss keeps stretching the budget, to accommodate the huge bonuses you get, in reward for your amazing talents. Well, that might not be the exact situation, but I'm sure [...] Recently, Jerry Latham showed us how to use Excel to calculate the date of Easter in any year, by using a worksheet formula or Excel User Defined Function (UDF). Now, it's getting close to Thanksgiving in the USA, so lets see how to calculate that date, with an Excel worksheet formula. Date Range for [...]Do you sometimes need to fix data that has numbers, with trailing minus signs? I don't run into this problem too often, but I usually fix them with the Text to Columns feature. Select the column that contains the trailing minus signs On the Excel Ribbon's Data tab, click Text to Columns. Click the [...]One of the best features of Excel is that it's quick and easy to sort columns of data.
You can even sort data in an Excel row, left to right, by changing one of the sort options. Sort Multiple Rows of Data With a Formula In a comment on the Sort [...] There are Excel formulas and User Defined Functions (UDF) that can change numbers into words. Those are handy if you're typing a number into a workbook, and want the written amount to be shown, as it might appear in a cheque. Have you ever tried to do the opposite – change words into numbers? [...] Mock me if you will, but I use Excel to plan the timing for our holiday dinners. Monday was our Canadian Thanksgiving, so it was the perfect occasion to dig the planner out again. You know that it's a delicate juggling act, trying to get everything cooked and on the table at the same time. [...] My son is in an Air Traffic Control course, and there's lots of information to memorize. Directions have to be given in a very specific sequence, or the pilots don't respond. Apparently, you can't say, "Hey dude, just put it down anywhere." No, you have to address the aircraft correctly, and specify an [...] Easter has passed for this year, but it's never too early to figure out when Easter will occur next year. Then, you can book your vacation for that date, and be out of town when the family shows up for Easter dinner! Last week, Excel MVP Jerry Latham showed us how to calculate distance [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
