September 2009 - Posts
In the last part of this 3 part series on slicers I’ll show you how slicers can be customized many different ways to create stellar looking reports. Previously in this series: Part 1 : Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers
Read More...
In part 2 of this 3 part series introducing slicers, I’ll show you some of the ways you can interact with slicers. Part 1 can be found here . Slicers reveal where the data is Let’s say I want to slice on my customer data for yesterday, and I only want
Read More...
Today’s author is Rob van Gelder, previously quite active in the online Excel scene (Newsgroups, Excel forums, his own but currently inactive website) and who just upgraded to Excel 2007 because he still likes to dabble. The following power tip shows
Read More...
Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , which includes more than 300,000 questions and answers about Excel. Jenny asks "Is there a
Read More...
Thanks to Karen Cheng for putting together this series on Slicers. New to Excel 2010 are slicers, which are visual controls that allow you to quickly and easily filter your data in an interactive way. They float above the grid, like charts and shapes.
Read More...
Thanks to Eric Patterson for putting together this post. In Excel 2010, we have made a number of improvements to Solver that make it easy for beginners to get started and more advanced ones to find solutions to all types of problems. The purpose of this
Read More...
A while back I blogged about the announcement at PDC of the Excel Web App. Today I am excited to share with you that we are making the Excel Web App, as well as the Word and PowerPoint Web Apps, available to a select group of Windows Live users. To quote
Read More...
Today’s author is Shane Devenshire, who has been an Excel MVP for many years and who regularly contributes to Excel Newsgroups. He has published over 300 articles in different computer magazines, and co-authored numerous books. Excel might be better today
Read More...
In the past two posts I talked about all of the improvements we have made to the function library in terms of accuracy and consistency. In this post I will describe the UI changes we have made to help users take advantage of these improvements in Excel
Read More...
The second part of the function improvements work we are making for Excel 2010 is to create a more consistent function library. We have implemented a new naming scheme to allow consistent and accurate naming convention for functions. Also, we have added
Read More...
Thanks to Jessica Liu for putting together the next few posts on function improvements. In Excel 2010, we made many improvements to Excel's function library. Excel 2010 will feature an accurate and consistent function library while remaining compatible
Read More...
In this second post about our investments in Excel 2010 performance I’m going to wrap up talking about the challenges and opportunities we embraced for this release, specifically on the topics of large data set scenarios, calculation performance and investment
Read More...
Thanks to Chad Rothschiller for putting together these posts on performance. In this release of Excel we spent dedicated research and development resources on improving performance. In addition to the usual optimizations and tuning efforts we make post
Read More...
Today’s author is Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ Problem : It is not possible to copy more than one sheet to a new workbook or existing workbook
Read More...
Today’s author is Derek Mang, owner of Systems Solution Developers Inc. You can find more useful tips from Derek on his website: www.officevbasolutions.com . This post shows you how to create a custom popup menu in Excel. Microsoft Excel has lots of popup
Read More...
