Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Office 2010 finally allows you to customize the ribbon. Episode 1077 shows you how.
posted by Bill at 9:00 AM
Add the Page Setup dialog launcher to your Excel 2007 Quick Access Toolbar. Episode 1003 shows you how.
posted by Bill at 9:00 AM
Where is it Wednesday? A person in one of my seminars asked me about a feature missing from Excel 2007. While the feature sounded familiar, it was also missing from Excel 2003. In Episode 911, we will take a look at a faster way to start a formula using the mouse.
posted by Bill at 9:00 AM
Robert asks how I get the custom toolbar below my Excel 2007 ribbon. This is the Quick Access Toolbar. In Episode 843, I will show you how to customize this toolbar in Excel 2007.
Labels: Excel 2007, Ribbon
posted by Bill at 9:00 AM
In our third Where Is it Wednesday, I will take a look at the changing face of the ribbon, including the point where the ribbon completely disappears. Episode 818 will show you how your co-workers ribbon may appear completely different than your ribbon.
Labels: Excel 2007, Interface, Ribbon
posted by Bill at 9:00 AM
Two tips for finding an Excel 2003 command on the Excel 2007 ribbon. One is to use the Customize QAT dialog. Pam sends in a cool website from Microsoft that will help you to find the command. The website is here: http://office.microsoft.com/en-us/help/HA101491511033.aspx. Episode 739 shows both methods.
Labels: Excel 2007, Ribbon
posted by Bill at 9:00 AM
Bill Gates asked the question: “The ribbon is fine, but there will be a classic mode, right?”. The Office interface team convinced Bill that this was not the way to go. And, unfortunately, learning the new ribbon is the #1 complaint about Office 2007. Well, the folks at www.addintools.com did for you what Microsoft would not do, they brought the classic Excel 2003 menu bar, plus the standard and formatting toolbars back to Excel 2007. The add-in is perfect for someone who is trying to learn Excel 2007 in a pain-free manner and is now available at www.mrexcel.com. If you need a new feature, you can use the new ribbon tabs. But, if you need to use an item off the old menu, just stay right on the new Menu tab and find the menu exactly where you expect it would be. Episode 488 shows you how.
Labels: Excel 2007, Ribbon
posted by Bill at 9:00 AM
As you dive in to get all the great features in Excel 2007, you will be frustrated trying to find things on the ribbon interface. The MrExcel tip card will solve those problems. Download the card for free. Episode 434 shows you how.
posted by Bill at 9:00 AM
Starting on Tuesdays and Thursdays, I will be taking a look at the new features in Excel 2007. Today, an introduction to the ribbon and the options to minimize the ribbon. Episode 391 shows you the details.
Labels: Customizing, Excel 2007, Ribbon
posted by Bill at 9:00 AM
