Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Wednesday, September 09, 2009

Split? - 1098 - Learn Excel from MrExcel Podcast

What the heck is the SPLIT command for? Episode 1098 wonders about this.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Thursday, September 03, 2009

Automatic Freeze Panes - 1094 - Learn Excel from MrExcel Podcast

Excel 2007 offers a cool trick to replace Freeze Panes. Episode 1094 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Tuesday, July 07, 2009

Clearing Input Cells - 1052 - Learn Excel from MrExcel Podcast

Jerry has a model with input cells and formula cells. He wants to copy the model for next month and clear out all the input cells. Episode 1052 will show you how to clear out the numeric input cells.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Tuesday, April 07, 2009

MrExcel's Learn Excel #987 - Undoing AutoCalculate

When you declare a range as a table in Excel 2007, any calculations entered to the right of the table are automatically copied throughout the table. Episode 987 talks about how to solve this problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Thursday, March 12, 2009

MrExcel's Learn Excel #969 - Print Titles

There is a new podcast featuring my Excel tips. Learn about this podcast and also see how to repeat your title rows at the top of each printed page. Episode 969 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, March 11, 2009

MrExcel's Learn Excel #968 - Keep Headings

Smack83 sends in today's question via YouTube. How do you freeze specific rows and columns in Excel and have them appear without retyping. Episode 968 shows you how to you Freeze Panes to keep the headings visible on the screen.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, February 18, 2009

MrExcel's Learn Excel #953 - Ctrl+N Compatibility Mode

A question from Gary: Why does Excel 2007 open with only 65,536 rows? Wouldn't Microsoft want to show off the cool functionality available in Excel 2007 without forcing you to up convert each worksheet? Episode 953 discusses the unfortunate setting causing this problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Friday, January 16, 2009

MrExcel's Learn Excel #930 - QAT 2007

It is frustrating that commands in Excel 2007 are spread out amongst 7 different ribbon tabs. Episode 930 will show you how to add your favorite commands to the QAT - Quick Access Toolbar so that you can have one-click access to these commands.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Friday, January 09, 2009

MrExcel's Learn Excel #925 - Partial Icon Set

Apply icons only to the numbers that qualify for a red X. It is possible, but tricky. Episode 925 will show you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Thursday, January 08, 2009

MrExcel's Learn Excel #924 - Icon Set Adjustment

Adjust the ranges used by the icon sets. Episode 924 will show you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, January 07, 2009

Learn Excel from MrExcel Episode 923 - Icon Set Alignment

The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Monday, January 05, 2009

Learn Excel from MrExcel Episode 921 - Workbook Sheets

Change the default number of worksheets in a new workbook using Excel 2007. Episode 921 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Friday, January 02, 2009

Episode 920 - 2003 Dialogs

As you switch to Excel 2007 and try to find things on the new Ribbon, look for the tiny dialog launcher icons to take you back to the old Excel 2003 dialogs. Episode 920 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Monday, December 29, 2008

Episode 917 - Chart Background

Add a picture as a background for a chart in Excel 2007. Episode 917 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Thursday, December 11, 2008

Episode 907 - 2007 Highlighted Sheets

One of the annoying things about Excel 2007 is that the color for selected sheets and cells is almost identical to the color for unselected sheets and cells. Harry from Culver-Stockton college suggests a simple solution for the tab color in Episode 907.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Friday, October 31, 2008

Episode 880 - Scrolling Ribbon Tabs

Rick from Madison Alabama sends in a cool trick today. You can use your wheel mouse to quickly scroll from ribbon tab to ribbon tab in Excel 2007. Episode 880 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Thursday, October 30, 2008

Episode 879 - Icon Sets II

Excel 2007 offers a new visualization called an Icon Set. I usually hate this feature, because my numbers are right justified and the icons are left justified. However, in Episode 879, Joanna from Columbus, Ohio offers a cool tip to get the numbers and icons next to each other.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Monday, September 15, 2008

Episode 846 - 2007 Pivot Table 101

Creating your first pivot table in Excel 2007.
Episode 846 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Friday, September 12, 2008

Episode 845 - Stacked Column 3

Episodes 801 and 815 suggested many ways for getting the total of 3 series in a stacked column chart to appear above the column. Both Ute and John wrote in with yet another method, a method that is probably the easiest. Episode 845 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, September 10, 2008

Episode 843 - WIIW - Custom Toolbars

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.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, September 03, 2008

Episode 838 - WIIW - Move Direction

Donna asked a question at one of my Excel 2007 seminars: There used to be a way in Excel 2003 to prevent the active cell from moving downwards after pressing Enter. In today's Episode 838 - Where Is It Wednesday, I will take a look at how this feature works, where it is in Excel 2007, and how to simulate the feature using a shortcut key.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, August 06, 2008

Episode 818 - Where's the Ribbon?

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.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Monday, August 04, 2008

Episode 816 - Total Red Cells

Say that you need to add up all of the red cells. This is easier in Excel 2007 using Filter by Color. Episode 816 will show you how to do this in Excel 2007 as well as a clever trick using find by format to do the same thing in Excel 2003.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Friday, August 01, 2008

Episode 815 - 801 Chart Redux

I was pretty happy with my tricky chart back in Episode 801, but couldn't find a way to be tricky in Excel 2007. Today, both Eddie and Ricardo send in brilliant ideas to get the sum of three stacked columns to appear on top of the stack of columns. Episode 815 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, July 16, 2008

Episode 803 - Move or Copy Sheet

In our first Where's it Wednesday segment, I tried to figure out where the popular Move or Copy Sheet command is hidden in Excel 2007. Check out the cool new Wednesday theme from George Wood in Episode 803!

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Monday, July 14, 2008

Episode 801 - Stacked Chart Labels

How to add a the total of the stacked columns at the top of the chart. This is obscure but possible in Excel 2003, but as Episode 801 shows, it is maddeningly impossible to do in Excel 2007.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Thursday, April 17, 2008

Episode 739 - Menu to Ribbon

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.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Tuesday, April 15, 2008

Episode 737 - Excel 2007 Charts

Lorin asks if there is anything new in Excel 2007 charts. While Microsoft rewrote the charting engine in Office 2007, you still have the same basic chart types. However, there are new data visualization tools in conditional formatting that allow you to add bar charts to every cell. Episode 737 discusses these new features.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, April 02, 2008

Episode 728 - Table Formulas

Excel 2007's table functionality is cool, but viewer Jim is wondering why Excel is changing his formulas. In Episode 728, we will take a look at how to control this behavior,

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Monday, March 10, 2008

Episode 711 - Show Pages

Do you ever need to produce a report for every customer? This is a snap with pivot tables in Excel 2007. In Episode 711, we take a look at how to use Show Report Filter Pages to replicate a report for every customer.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Friday, March 07, 2008

Episode 710 - Pivot Filters

Learn how to filter a pivot table to only items from this week, last quarter, or next month. Episode 710 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , , ,

Thursday, March 06, 2008

Episode 709 - Pivot Dates

Excel offers amazing tools to group daily dates to months, quarters, years, or weeks. Episode 709 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , , ,

Wednesday, March 05, 2008

Episode 708 - Pivot Sorting

Episode 708 shows how Excel offers sorting rules that allow your pivot tables to be sorted in a certain manner. The old AutoSort option is now hidden behind a dropdown in the pivot table field list.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Tuesday, March 04, 2008

Episode 707 - Changing Pivot

To rearrange a pivot table in Excel 2007, simply drag fields to a new drop zone in the pivot table field list. Episode 707 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Monday, March 03, 2008

Episode 706 - Pivot 2007

Create your first pivot table in Excel 2007. Episode 706 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Friday, February 29, 2008

Episode 705 - Pivoting Time Columns

It is difficult to create a pivot table when you have a time component stretching across the columns in your data set. In today's episode, an amazing trick in Excel 2007 to change four quarterly columns into four rows. Episode 705 will show the multiple consolidation ranges trick.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Thursday, February 21, 2008

Episode 699 - 2007 Pivot Interface

Microsoft changed the pivot table interface in Excel 2007. While the new interface is much better, in this lesson, we will take a look at how to bring back the old interface. Episode 699 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Monday, February 18, 2008

Episode 696 - Alt Shortcuts

Jim from California suggests that I take a look at the new Excel 2007 Alt shortcut keys. They are pretty cool, with one minor drawback. Episode 696 takes a look.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Thursday, February 14, 2008

Episode 694 - Double Greenbar

As a follow-up to yesterday's podcast, we'll take a look at how to customize the formatting used in the Excel 2007 table formatting. Episode 694 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , , ,

Wednesday, February 13, 2008

Episode 693 - Easy Greenbar

Excel 2007 offers easy greenbar formatting using the table functionality. While the table functionality offers amazing tools that we'll discuss on another day, today's Episode 693 looks at the few clicks necessary to format a range with alternating row formatting.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Thursday, February 07, 2008

Episode 689 - Hiding in 2007

Justin asks how to hide columns in Excel 2007. Finding the command on the 2007 ribbon is a little tough, but Episode 689 shows a way to invoke any Excel 2003 command in Excel 2007.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Tuesday, February 05, 2008

Episode 687 - VBA in 2007

Microsoft hides some of the VBA controls in Excel 2007. Episode 687 will show you how to access the Developer tab in the Excel 2007 ribbon.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Tuesday, April 17, 2007

Episode 488 - Classic Menus 2007

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.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy.

Labels: ,

Thursday, February 08, 2007

Episode 440 - Virtual AutoFilters

Excel 2007 does offer a number of improvements in the AutoFilter arena. Episode 440 shows the new virtual date filters, such as selecting records from this week, next month, or last quarter.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: , ,

Thursday, January 04, 2007

Episode 415 - Removing Duplicates

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.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: ,

Thursday, December 28, 2006

Episode 411 - Expanding FormulaBar

Do you notice that in Excel 97-2003, if you have a really long formula in row 1, when you select a cell, the formula bar obscures the value in the cell? This is now fixed in Excel 2007. Episode 411 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels:

Thursday, December 14, 2006

Episode 403 - 2007 Formats

Actually - there are three different file formats in Excel 2007. Episode 403 describes the differences and shows you how you can use a zip utility to take a look inside the new file format.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels:

Thursday, December 07, 2006

Episode 398 - QAT Taming

The only toolbar that is easy to customize in Excel 2007 is the QAT or Quick Access Toolbar. Episode 398 shows you how to customize the QAT with your favorite icons.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: , ,

Tuesday, December 05, 2006

Episode 396 - Data Visualization

A look at Excel 2007 data bars and color scale features. These new features allow you to quickly see the largest/smallest values in a sea of numbers. Episode 396 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: , ,

Thursday, November 30, 2006

Episode 393 - Shortcut Keys

It's another Excel 2007 Thursday. I'll take a look at how your old Excel 2003 shortcut keys continue to work in Excel 2007. Episode 393 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,

Tuesday, November 28, 2006

Episode 391 - Ribbon Minimization

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.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: , ,