Learn Excel from Bill Jelen with this daily 2 minute video podcast.
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
Office 2007 debuted at midnight last night. In Episode 433 Bill discusses the new release, the various packages available, and how to run Excel 2003 and Excel 2007 side by side.
posted by Bill at 9:00 AM
Sure, Excel can fill in the months of the year. It can fill in the days of the week. It can fill in 1st period, 2nd period, 3rd period. But - what if YOU need to fill in something else? Perhaps a list of departments, customers, co-workers, acccounts??? Excel is up to the task. Epsiode 432 will show you how to set up a custom list so that the fill handle can fill in the flavors of bagels from your local coffee shop.
posted by Bill at 9:00 AM
If you work Monday through Friday, Microsoft has a great secret shortcut for filling all of the weekdays in your spreadsheet. Episode 431 shows you how.
posted by Bill at 9:00 AM
Sign up to get a free chapter each week of my new book, Excel 2007 Miracles Made Easy. I gave away over 5 million chapters of Learn Excel from MrExcel (plus half a million podcast downloads...) and I will do the same thing with Excel 2007 Miracles. Sign up at http://www.mrexcel.com/freebook2007/ today. Episode 430 shows you how.
posted by Bill at 9:00 AM
Use the Fill Handle to extend a series. Episode 429 shows you how.
posted by Bill at 9:00 AM
Excel 2007 offers amazing new AutoFilter functionality. Instead of choosing a single customer from the dropdown, you can filter a dataset to show 3 or more customers, or use new virtual filters to show all records from next month or last year. Episode 428 shows you how.
posted by Bill at 9:00 AM
This cool trick shows you how to create a Gantt chart right in the Excel cells by using Conditional Formatting. The chart is a live chart that colors cells based on several data values. Episode 427 shows you how.
posted by Bill at 9:00 AM
One of my favorite April Fools Day tricks involves a trick that will only work with Excel 97 through Excel 2003. Since it is Friday, and your manager might be upgrading to Excel 2007 soon, try this trick out now, before the opportunity is lost. Episode 426 shows you how.
posted by Bill at 9:00 AM
Six accent colors x 7 options x 20 themes x your imagination leads to thousands of different formats that you can apply to a table with a single click. Episode 425 shows you how.
posted by Bill at 9:00 AM
More tricks for your Excel toolbars, including how to edit the icons or how to add an icon to the toolbar that opens a particular webpage, perhaps www.MrExcel.com! Episode 424 shows you how.
posted by Bill at 9:00 AM
One of the best features of the new Excel 2007 table functionality is the new table formulas that Excel can create. Once you enter a formula in the first row of a dataset, Excel 2007 will automatically copy the formula down to all of the rows. Episode 423 shows you the details.
posted by Bill at 9:00 AM
Learn some new tricks with your Excel 97-2003 toolbars. Add new buttons for common tasks. Paste icons from other applications. Add words next to existing buttons. Episode 422 shows you how.
posted by Bill at 9:00 AM
This netcast has a couple of tips from Tools - Options - General. First, learn how to control the number of worksheets in your new workbooks. Second, learn how to increase the number of files in your recently used file list. Plus a sneak peak in Episode 421 of how the Recently Used File List is improved in Excel 2007.
posted by Bill at 9:00 AM
Once you have defined an Excel 2007 table, Excel will usually automatically sense when you enter data in adjacent cells and extend the table to include the new cells. Episode 420 takes a look at extending tables, using the Table Tools Design ribbon, and new selection options when you have a table.
posted by Bill at 9:00 AM
In Excel 2000-2003, if you open a menu and only see a third of the menu items, then you still have Adaptive Menus turned on. Learn why Microsoft included this half-baked feature and how you can turn it off in Episode 419.
posted by Bill at 9:00 AM
Excel 2007 adds new table intelligence that you can use in probably 90% of your worksheets. In Episode 418, learn how table functionality can easily apply greenbar formatting, autofilters, and more.
posted by Bill at 9:00 AM
Sometimes you have a single column with several fields joined together. For example, you might have city, state, zip code in a single column. Episode 417 shows how to break this data into three columns using the Text to Columns command.
posted by Bill at 9:00 AM
Microsoft MapPoint is a great product that will allow you to analyze customers on a map. MapPoint is available for US, Canada, and Europe. Episode 416 shows an example of plotting Excel data on a map.
posted by Bill at 9:00 AM
Excel 2007 offers powerful new features for removing duplicates. Episode 415 shows how you can find the unique values in a list using just a couple of clicks.
posted by Bill at 9:00 AM
If you try to use the concatenation character to join text with a date, you will not get the results that you expected. Episode 414 shows you how to modify the formula to properly format the date.
posted by Bill at 9:00 AM
Get quick access to all of the text formatting commands by moving your mouse towards the completely invisible mini toolbar! (Who at Microsoft comes up with this stuff?) Episode 413 shows you how to get the shy mini toolbar to appear.
posted by Bill at 9:00 AM
