Excel Twitters 20091208
Now that more people are using the Excel 2010 beta, they’re tweeting about it. Some are excited about the new features, others…not so much. Some of my clients use Walmart Retail Link reports, so I’ll have to warn them about the problem in 2010.
And speaking of features, that person who needs the opposite of the Concatenate function could use Excel’s Text To Columns feature.
New Excel
- #Microsoft #Office 2010. Nothing new that excites me except Word Paste Preview and Excel Sparklines. Decided not to try the beta.
- 2010 Excel will not open Walmart Retail Link reports…This is a big problem, on my way back to 2007.
- I’m disappointed with Excel 2010’s V-Lookup feature for large amounts of data. It’s better than 2007 but still slow.
- Excel 2010 will add pivot tables that can be based on multiple tables of data. Woohoo! What, that sort of stuff doesn’t turn you on? Weird.
- *the new Excel. I could work the old one (believe it or not). graphs- done, now for the rest of the report.
New Functions
- Why doesn’t excel have a word count function? Stupid!
- Does anyone know the opposite of the "concatenate" function in Excel?
- Why doesn’t excel show the fx bar when I double-click a cell? It says on the formatting tab.
- Loving the Filtering facilities in Excel 2007 versus previous versions. Obviates writing code for many rather simple cases. A few clicks…
So Sleepy
- Sleepy.. One of the disadvantages of getting up to work on an Excel spreadsheet at 4 in the morning…
- Monday morning nightmare: 3hours class how to use excel. Almost fell asleep there 😀
- Poppies…. Poppies will put them to sleep. And if that don’t work, Excel will!
Needs More Sleep?
- Just noticed the person next to me is working on an Excel spreadsheet he titled "killme.xls" Remember, we’re all stressed about something…
______________
P.S. For quick filtering in Excel 2007 you can use the AutoFilter by Selection feature.
_____________