 
|
Good news, if you're spelling challenged -- or too lazy to type long words. You can combine cell values in Excel, without using the CONCATENATE function. Keep reading, to learn the easy way to combine cells, and add some fancy formatting to the dates and numbers. Use the & OperatorYes, instead of using [...] How many students got a grade between 50 and 70? How many golfers scored between 70 and 80? How many orders were for a quantity between 5 and 10? In Excel 2007 and higher, you can use the COUNTIF and COUNTIFS functions to calculate the answers to those questions. In earlier versions, COUNTIFS is [...] In Excel 2003, you could create a custom toolbar, and attach it to a specific workbook. I didn't use that feature, but occasionally I receive a workbook where someone has attached a toolbar. Custom Toolbars in Excel 2007 The Ribbon was introduced in Excel 2007, to replace the Excel toolbars. It has an [...] Mike Alexander, Microsoft Excel MVP, and madcap owner of DataPig Technologies, is interviewing Excel people this summer, and posting the interviews on his Bacon Bits blog. Lots of fun! Here's the only picture that I have of Mike, and apparently John Walkenbach has a photo of me.
It's funny, that picture reminds me [...] If you're doing Excel training, or writing blog posts, or creating sample files, you might need to find some public data to use in your Excel file. You don't want to publish confidential client data, even if it's a bit disguised, or reveal your household finances to the world. Instead of creating sample data on [...] Automatic or manual makes me think of cars, and choosing a transmission type, but an Excel workbook can also be on Automatic or Manual calculation. And just like a car, it's safest if you know what type of Excel calculation mode you're driving, before you head for the information highway. In a car, you can [...] A while ago, I suggested that we pick a day to celebrate as Spreadsheet Day. There was a poll to pick a date, and October 17th, the release date of VisiCalc, got the most votes. So, we still have lots of time to plan events for this year's Spreadsheet Day. Do you have any ideas? [...]If you've used Excel for a while, you have lots of skills that you might assume everyone else shares. However, based on the Excel questions that I see online, those assumptions are very optimistic! For example, I recently saw this plea on Twitter: Can anyone help pls? can't work out how to add a LOT [...] Last week, you saw a quick tip for filtering by selection in Excel 2007. That's helpful when you've found an item in a list, and want to filter for that item. There's another new feature in the AutoFilter dropdown, in Excel 2010. When you click the drop down arrow in the AutoFilter heading cell, you'll [...] You're comfortable with Excel, and can change formulas on the fly, when necessary. If you're creating Excel workbooks for other people to use, their Excel skills probably aren't as strong as yours. Last month we looked at the COUNTIF formula, and how you can type an operator, then refer to a worksheet cell, to set [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
