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

Wednesday 22-Sept-2010

posted by ScottieP at 10:00 am |

Find All of the New "Learn Excel from MrExcel" Podcasts Here! The MrExcel Podcast - Now on WordPress!

 

April Fools ? - Episode 1200! MrExcel's 1100th Podcast!

Well, it was supposed to be for April Fools day, but after a slight mix up here Episode 1200 - MrExcel's 1100th Podcast - almost became 'The Lost Episode'.

Here is a great trick with the Speak Cells tools. Episode 1200 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: , , , , , , , ,

posted by Bill at 8:10 PM | 0 comments

AVERAGEPRODUCT? - Episode 1199

Susan asks..."I have been using SUMPRODUCT a lot ever since you showed me how – since I can’t use SUMIFS for users with pre-2007 version. But, is there an AVERAGEPRODUCT or something similar? I know about AVERAGEIFS but, again, it can’t be used by pre-2007 version users. How about MAXPRODUCT?" Episode 1199 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: , , , , , , ,

posted by Bill at 8:01 PM | 0 comments

Tuesday, March 30, 2010

Nudge Selection - Episode 1198

Use the Selection Navigator in Easy-XL to nudge the selection. Episode 1198 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!

To learn more about the Easy-XL Addin, visit the Easy-XL website.

Labels: , , , , , ,

posted by Bill at 9:09 PM | 0 comments

Saturday, March 27, 2010

New vs New... - Episode 1197

Jim from California asks why it takes two clicks to create a new workbook in Excel 2007. Episode 1197 shows you the solution.

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

posted by Bill at 12:35 PM | 0 comments

Paste Values Chart - Episode 1196

Patrick from Alaska asks how to copy a chart but detach it from the original data set. In this Dueling Excel podcast - Episode 1196, Mike and Bill show you various solutions.

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

posted by Bill at 12:20 PM | 0 comments

Wednesday, March 24, 2010

Sparkline Shading - Episode 1195

As envisioned by Professor Tufte, sparklines could have a bit of shading to show the acceptable ranges. While this is not necessarily built in to Excel 2010, you can achieve the same effect. Episode 1195 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: , , , , , , ,

posted by Bill at 8:40 AM | 1 comments

Sparkline Labels - Episode 1194

In Episode 1194, we take a look at how to add labels to your sparklines.

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

posted by Bill at 8:37 AM | 0 comments

Friday, March 19, 2010

PivotTable Text - Episode 1193

Robert asks about using a pivot table to report on text values. This would be easy if Microsoft offered a way to specify "First" as the calculation, but they don't. Instead, episode 1193 shows a Pivot/VLOOKUP solution to the 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: , , , , , , ,

posted by Bill at 3:52 PM | 2 comments

Thursday, March 18, 2010

Scale to Fit - Episode 1192

Mary asks about how to force a report to fit to one page wide. Episode 1192 takes a look at Layout mode, Scale to Fit, and orientation.

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

posted by Bill at 11:01 AM | 0 comments

Validation Tooltip Trick - Episode 1191

This isn't so much of a dueling podcast as Bill being obnoxious and breaking Mike's worksheet. Changing the location for the Validation Tooltip box? Maybe there is a use for this, or maybe not. Episode 1191 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: , , , , , , ,

posted by Bill at 10:58 AM | 0 comments

Add Print Area - Episode 1190

Excel 2007 offers a new way to set up non-contiguous print ranges. Episode 1190 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: , , , , , , ,

posted by Bill at 10:54 AM | 0 comments

Web Excel - Episode 1189

Excel 2010 offers a cool trick that anyone with a browser can try out right now. You can view and edit your Excel workbooks in a browser. Episode 1189 shows you how to try it out.

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

posted by Bill at 10:52 AM | 0 comments

Friday, March 12, 2010

Offset Lookup - Episode 1188

Find a value in this row and then get the values 1 and 2 columns to the right of that value. Mike and Bill duel it out in Episode 1188.

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

posted by Bill at 10:31 AM | 0 comments

Fill Handle Regression - Episode 1187

A lot of behind-the-scenes math goes into dragging the fill handle...
Howie asks why the fill handle does what it does when you select four numbers and drag. Episode 1187 discusses trend lines, LINEST, and straight line regression.

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

posted by Bill at 10:27 AM | 0 comments

Row Height .18"? - Episode 1186

In today's podcast, a quick way to hide the column headers, and a row height in inches Episode 1186 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: , , , , , ,

posted by Bill at 10:25 AM | 0 comments

Counting Mondays - Episode 1185

Mike and Bill get together for another live dueling podcast, counting the number of Mondays between two dates. Episode 1185 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: , , , , , , , ,

posted by Bill at 10:22 AM | 0 comments

Thursday, March 04, 2010

Pivot SmartArt - 1184

Create a pivot table that drives a SmartArt diagram. Episode 1184 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: , , , , , , , , ,

posted by Bill at 10:54 PM | 0 comments

Q1, Q2, H1 - Episode 1183

Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.
Episode 1183 shows you why.
Also, in this episode, a challenge to users - view the podcast for details!

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

posted by Bill at 10:50 PM | 0 comments

Friday, February 26, 2010

Plus / Minus - 1182 Dueling Excel

Today's 'Dueling Excel' podcast - Episode 1182, with Bill Jelen and Mike Gel Girvin - shows you how to visually present statistical values (+/-) in a cell.

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

posted by Bill at 10:37 AM | 0 comments

Thursday, February 25, 2010

Dynamic Charting - 1181

Today, learn how to create a dropdown that allows you to change the chart displayed on your worksheet! View Episode 1181 to learn this tip!

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

posted by Bill at 7:01 PM | 0 comments

Wednesday, February 24, 2010

Checkmarks in Excel - 1180

Checkmarks in Excel - 1180

A phone call last evening led me to a really cool solution to having checkmarks on a spreadsheet - not to manipulate data, but for printing purposes only. Fast, Easy and Effective! Episode 1180 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: , , ,

posted by Bill at 10:58 AM | 0 comments

Monday, February 22, 2010

TagCloud Pivot - 1179

Another entry in the Alpha Geek Challenge; How to create an interactive Tag Cloud from pivot data. Episode 1179 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:

posted by Bill at 6:54 PM | 0 comments

Tuesday, January 12, 2010

Links Failing - 1174

A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode 1174 Episode 1174 show why and how to fix this problem forever.

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

posted by Bill at 10:15 AM | 2 comments

Monday, January 11, 2010

Turn Data - 1173

Paula asks how to take a range and turn it on its side.
Episode 1173 Episode 1173 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: , , , , , , ,

posted by Bill at 9:09 PM | 0 comments

Friday, January 08, 2010

Picture Lookup - 1172 - Dueling Excel

Today's dueling Excel podcast shows how to do a picture lookup in Excel.
Episode 1172 Episode 1172 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: , , , , , , ,

posted by Bill at 3:00 AM | 0 comments

Thursday, January 07, 2010

Concatenated Lookup? 1171a - Learn Excel from MrExcel

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Episode 1171 Episode 1171 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: , , , , , , , , ,

posted by Bill at 5:27 PM | 0 comments

Concatenated Lookup? 1171 - Learn Excel from MrExcel

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Episode 1170 Episode 1170 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: , , , , , , , , ,

posted by Bill at 3:00 AM | 0 comments

Wednesday, January 06, 2010

Microsoft First? 1170 Learn Excel Podcast

Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 Episode 1170 takes a look at this mystery and the solution.

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

posted by Bill at 4:51 PM | 0 comments

Microsoft First? 1170 Learn Excel Podcast

Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 Episode 1170 takes a look at this mystery and the solution.

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

posted by Bill at 3:00 AM | 0 comments

Thursday, December 31, 2009

Ahmed asks how to do a lookup that only looks at the text portion of the lookup value. Mike and Bill compare methods in this Dueling Excel Episode 1169.

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

posted by Bill at 3:00 AM | 0 comments

Wednesday, December 30, 2009

Concatenate to 3 Rows - 1168 - Learn Excel from MrExcel

Khader asks how to concatenate three cells so that they appear on three lines in a new cell. Episode 1168 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!

posted by Bill at 5:53 PM | 0 comments

Tuesday, December 29, 2009

Coercing Number Array 1167 - Learn Excel Podcast

Building on Teo's question from yesterday, Bill expands the technique to generate an array of 50 sequential numbers instead of typing that whole range out. Episode 1167 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: ,

posted by Bill at 3:00 AM | 0 comments

Monday, December 28, 2009

Sum Big 3 - 1166 - Learn Excel from MrExcel Podcast

Teo asks how to sum up the three largest values in a range. Episode 1166 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: , , ,

posted by Bill at 3:00 AM | 0 comments

Thursday, December 24, 2009

Lookup 3 Tables - 1165 - Dueling Excel Podcast

In today's dueling podcast, we need to look up a value in one of three different tables depending on the product selected. Mike and Bill show many ways to solve the problem in Episode 1165.

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

posted by Bill at 3:00 AM | 0 comments

Wednesday, December 23, 2009

Curved Arrows - 1164 - Learn Excel from MrExcel Podcast

Brent asked me how I managed to draw a curved arrow on a worksheet. Episode 1164 takes a look at how to customize the drawing tools to draw in curved arrows.


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

posted by Bill at 3:00 AM | 0 comments

Tuesday, December 22, 2009

Show a Month - 1163 - Learn Excel from MrExcel

Shaun has a large worksheet with 12 monthly reports on it. On a summary worksheet, he would like to show one particular month based on a dropdown. In episode 1163,discusses Paste Special Column Widths, Array Formulas, Match, and OFFSET.

...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!

posted by Bill at 8:36 AM | 0 comments

Monday, December 21, 2009

January Not = January - 1162 - Learn Excel from MrExcel Podcast

A simple MATCH formula is not working. In episode 1162, we wander through the Validation dialog, the Name Manager dialog, all trying to figure out why the MATCH formula is returning #N/A.

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

posted by Bill at 10:54 AM | 0 comments

Friday, December 18, 2009

VLOOKUP All Columns - 1161

Today's dueling podcast question is how to return the sum of all columns from a VLOOKUP. Mike and Bill show you various methods in episode 1161.

Labels: ,

posted by Bill at 9:00 AM | 0 comments

Thursday, December 17, 2009

Sheet Tabs - 1160 - Learn Excel from MrExcel

Riham asks if there is any way to arrange the sheet tabs in two rows. While there is not, Episode 1160 shows various ways of dealing with the issue.

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

posted by Bill at 4:41 PM | 0 comments

Wednesday, December 16, 2009

PowerPivot Mashup - 1159 - Learn Excel From MrExcel

Using PowerPivot for Excel 2010 to mashup data on two different worksheets. Episode 1159 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:

posted by Bill at 3:53 PM | 0 comments

Tuesday, December 15, 2009

Right Two

David asks how to use Text to Columns to grab the right-most two characters from a column. Episode 1158 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:

posted by Bill at 8:29 AM | 0 comments

Monday, December 14, 2009

Easy-XL

Easy-XL adds 50 new data analysis features to Excel. Episode 1157 shows some of the cool features of Easy-XL.

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!

posted by Bill at 11:27 AM | 0 comments

Friday, December 11, 2009

Named Lists

Ed asks how to assign a list of weekdays to a name in Excel. Episode 1156 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:

posted by Bill at 9:39 AM | 0 comments

Wednesday, December 09, 2009

Thousands Millions

A question from Texas about setting up a chart in Excel. The goal is to show a mix of points that contain thousands and/or millions. While typing the K or M abbreviations might seem like a good way to get the table to appear, it is not a good way to have numbers that you can chart. Episode 1155 shows you how to solve the 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:

posted by Bill at 8:24 AM | 0 comments

Monday, December 07, 2009

Mapping Route - 1154 - Learn Excel From MrExcel Podcast

Take geographic data from Excel and plot it as a route in MapPoint. Episode 1154 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:

posted by Bill at 11:55 AM | 0 comments

Friday, November 27, 2009

Weekly Report - 1153 - Learn Excel from MrExcel Video Podcast

Lotfy from Egypt asks how to create a weekly report from daily transactional data. Mike and Bill show you several different methods in Episode 1153.

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

posted by Bill at 9:00 AM

Wednesday, November 25, 2009

DoubleClick Fill Macro - 1152 - Learn Excel from MrExcel Video Podcast

Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle. Episode 1152 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:

posted by Bill at 9:00 AM

Tuesday, November 24, 2009

Watermark - 1151 - Learn Excel from MrExcel Video Podcast

How can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of 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: ,

posted by Bill at 9:00 AM