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

Wednesday, November 26, 2008

Episode 898 - Thanksgiving PivotTable

In Episode 898, I show off some of the deep features in Excel 2007 pivot tables and offer a sincere thank you to everyone at MrExcel.com.

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, November 25, 2008

Episode 897 - Paste Data on a Chart

While I've shown how to drag and drop data on a chart, that method doesn't work if your chart is on a different worksheet than the data. Today in Episode 897, a trick to add new data to an existing chart.

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, November 24, 2008

Episode 896 - Paste Picture Icon

I could never figure out why Excel 2003 doesn't offer a paste picture icon or a close all icon. You can get to these obscure menu items, but when you try to drag them to the toolbar, they revert back to just paste or close. I will muse about this in Episode 896 with a possible explanation.

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, November 21, 2008

Episode 895 - Fill Handle Double

Today is the 10th anniversary of MrExcel.com, so I am repeating my all-time favorite trick. Episode 895 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!

Thursday, November 20, 2008

Episode 894 - Export Each Worksheet

Rod sends in today's question. He has to export several tab-delimited text files for a third-party application. He has the data for each file on a separate worksheet in a workbook and would like a macro to save those worksheets as individual text files. In Episode 894, I record a simple macro, then edit it to solve Rod's problem.

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, November 19, 2008

Episode 893 - WIIW Customizing Icons

Eric asks how to customize icons for his macros on the Excel 2007 Quick Access Toolbar. In Episode 893, I will take a look at this feature in Excel 2003 and the limited options available 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, November 18, 2008

Episode 892 - Validation Formula

Jon wants to set up validation to see if the result of a calculation exceeds a certain value. In Episode 892, we take a look at using Data Validation with a formula.

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, November 17, 2008

Episode 891 - AC DC Video

You've probably seen the AC/DC video running in an Excel spreadsheet. The author did some cool tricks to deliver the WAV file to your hard drive. In Episode 891, I'll take a look at the code to extract an object from a workbook.

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, November 14, 2008

Episode 890 - Offset as TableArray

An alternative to Episode 889...If you need to match two sorted columns with a VLOOKUP, you can make the table array be dynamically calculated with the OFFSET function. Episode 890 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, November 13, 2008

Episode 889 - Concatenated Key

You need to do a VLOOKUP that will look up two values from a table. In Episode 889, I will show a method using a concatenated key field to enable VLOOKUP to work.

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, November 12, 2008

Episode 888 - WIIW - 2 Axes Chart

Rick asks how to set up a chart with two different orders of magnitude. This was a built-in chart type in Excel 2003, but it is harder in Excel 2007. In today's Where Is it Wednesday edition, we will take a look at how to create a chart showing series with different orders of magnitude. Episode 888 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, November 11, 2008

Episode 887 - Keeping Pivot Formats

Nancy sends in a cool tip to solve some of the frustrations from Episode 875 -- Excel changing the column widths of a pivot table as you choose new values from a page field. In Episode 887, I will take a look at how to solve this problem.

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, November 10, 2008

Episode 886 - SumIf 2 Conditions

Mario sends in today's question. He has to do a SUMIF on a non-contiguous section of data. SUMIF can not handle this, but SUMPRODUCT can. Episode 886 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, November 07, 2008

Episode 885 - Ugly Time-Series Charts

Chuck sends in a great question about charts that use a time-series along the x-axis.

Chuck has weekly data. The default chart in Excel 2003 is ugly. Excel makes the columns ultra-thin in the chart. Chuck has one workaround, but his manager doesn't approve.

In Episode 885, a workaround, then the real solution, and a bonus tip about widening the columns in a chart.

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, November 06, 2008

Episode 884 - HLOOKUP with VLOOKUP?

Robert asks how he can combine an HLOOKUP and a VLOOKUP together into a single formula. This is a common problem, but you don't use either VLOOKUP or HLOOKUP. Instead, Episode 884 will introduce a function called MATCH. This obscure but versatile function is similar to both VLOOKUP and HLOOKUP. Episode 884 shows you how to solve this problem.

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, November 05, 2008

Episode 883 - WIIW - Copy as Picture

Shlomo sends in a great tip to solve the Cartesian coordinate numbering problem from last week's Episode 876. The solution involves the camera tool. In Episode 883, we will take a look at where Microsoft moved this tool 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, November 04, 2008

Episode 882 - Custom Views

Another way to solve the problem from podcast 881 is to create a pair of custom views. Episode 882 will discuss how you can quickly hide/unhide columns by using a custom view.

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, November 03, 2008

Episode 881 - Chart Quarters or Months

Tom from Cincinnati asks how to create a chart which can show either monthly or quarterly data. Episode 881 shows how to manually set up group and outline symbols to achieve the result.

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: ,