You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Tips
How-to
News
Videos
Stories
I’d like to take this opportunity to announce a new feature of the blog, which some of you might have noticed already. Our Content Publishing team has begun collecting “Power Tips” from members of the Excel community, including the product team, Excel MVPs, user group members, and other Excel enthusiasts. Power Tips are intermediate-level “How-to” tips that you can use to enhance your spreadsheets. We hope they’ll be valuable to those of you who feel pretty proficient with Excel, but who don’t consider yourselves seasoned spreadsheet "developers" (yet).
We have already tagged a number of past posts with the Power Tips tag, so you can start following this feature today by clicking the tag on the right side of this page. You can even set up an RSS feed for just that tag, if you want.
Enjoy!
Comments: (21) Collapse
Is it just me, or is this new tagging messing up syndication? The RSS feed, as far as I can tell, isn't picking up any of the new posts.
The new posts just came out today. Perhaps your RSS feed hasn't been updated yet? I haven't noticed any issues on my end.
I thought this Blog had gone to sleep
Power Tips is a great idea
***...
Hey Joe,
I'm really psyched to see the Power Tips kicked off. It looks like it's off to a great start. :-)
-- Mike
Here is a good suggestion for your first power tip. "How to switch from Ribbon to Classic View". Oh wait. You got rid of classic view becuase it was "burying functionality". The Ribbon is awful. I wish you guys would listen to your faithful users from the last decade, but instead you decided to listen to idiot product management and marketing execs who are trying to turn Office into and Apple product. Thanks for destroying my productivity idiots. I hope Google's new spreadsheet app steals all of your market share.
www.exceluser.com/.../ribbon-survey-results.htm
Here is a good article about what people think about the ribbon. Sounds like ribbon was built for the benefit of microsoft engineers and not users. What a joke.
Come on guys, this is a blog for useful information regarding Excel. Many of us receive the initial posting as well as posted comments as these too can be beneficial. If you have complaints to make regarding Excel then I'm sure there are better places to be making them.
In response to your comments, I too was disheartened when I first started using the Ribbon. However, with time I have come to find it at least as simple to navigate as the old style menus.
With regard to productivity, the best way to improve that is to use the keyboard shortcuts to the numerous commands, thus removing the need to navigate the Ribbon. The shortcuts used in 2003 still hold in 2007. Whilst the most common commands have their own keyboard shortcuts (CTRL + O to open etc), those that don't will still respond to the keyboard shortcuts that you could use in 2003 to access the command via the menus (ALT D, F, F to Autofilter etc). I created a fairly comprehensive list of shortcuts for my colleagues so as to help them find the required commands, but also to speed up their access to them. I'm sure such lists exist online, but if not then feel free to ask and I'll send you mine. If your productivity is being affected by the Ribbon then I'd say that you're most likely not using keyboard shortcuts as much as you could be, and therefore your productivity pre-Ribbon would have been below par. My personal opinion on improving productivity would be to make people work for a month without a mouse!
As a developer I find the Ribbon is head and shoulders above the old style menus. There are too numerous reasons for me to list here, but suffice to say I am one much happier customer and avoid developing for 2003, or older, if I can help it.
So please, let's keep using these blogs for useful comments and tips (I'm hoping that my suggestion of using keyboard shortcuts is one) and keep the complaints in their relevant place.
Sean - if MSFT wants these blogs to contain only 'helpful' comments, they could always moderate comments to screen out 'unhelpful' ones. That they don't means either that they don't care (and since these are their blogs, they have the right to be indifferent) or that they find some benefit to letting rants remain. Either way, GET USED TO IT!
Now with respect to the more efficient keyboard shortcuts, I completely agree that they're the quickest way to access commands either using the ribbon or the classic UI in Excel 2003 or prior. Those of us who have developed our Excel experience with older versions learned those keyboard shortcuts IN THOSE OLDER VERSIONS. How exactly would new Excel users learn keyboard shortcuts based on the classic menu?
I agree that there were some improvements in Excel 2007, but the main ones were in the worksheet and in a few of the dialogs (e.g., defined names). None of those improvements require the ribbon.
Harlan,
I don't have a problem with rants per se, I apologise that this wasn't clear in my initial post, but note the title of this blog for instance, it harldy seems the place for moaning about the Ribbon does it?
I am fully aware that many people don't like the Ribbon, and probably other areas of Excel or the Office suite. I just think it would be nicer if rants were kept in their appropriate places. We all recognise your name and know that you enjoy a good old rant (usually with interesting and useful comments attached, I must add), but at least you are only doing so with regard to the topic in hand.
As to the new users, they can use the new keyboard short cuts. As soon as you press that ALT key all the letters for the Ribbon tabs should jump up, click one and then that tab reveals the letters for its commands, and so on. This, by the way, is something I am certain you are aware of, I only mention it so that any new users can also become aware.
The Power Tips link does not work
Sean, Ex-Fan was asking a perfectly reasonable question appropriate to this thread - how do we get the classic menus back ? this could be answered by anyone who has tried the third-party add-ins that purport to restore this functionality
You can bring the classic menu back with only RibbonX if you want. But learn the new ribbon instead. Look forward and not back.
Ron
hi guys,
about the Ribbon - it is great on my point of view. I do like it because it is smart, convinient and finally nice.
about 'a number of past posts with the Power Tips tag'(blogs.msdn.com/.../default.aspx)- I have a trouble 404 with it...
'Nice' is a subjective opinion. There are a great many Excel users who don't find the ribbon nice.
As for convenient, read Jon Peltier's blog on charting in Excel 2007 vs prior versions. Excel 2007 was definitely NOT an improvement for charting.
:( 404 Error when clicking the PowerTips links *cry*
Comments: (loading) Collapse