Learn Excel From Mr. Excel Video Podcast
|
|
|
|
|
|
|

Learn Excel from Bill Jelen with this daily 2 minute video podcast
About Podcasting:
For those of you new to podcasting, Click Here to read our "Introduction to Podcasting" Article.

Be the First to Review Learn Excel From Mr. Excel Video Podcast
Podcast Feed URL: |
Podcast Website: http://mrexcel.libsyn.com/
Episode 865 - Pivot Formats
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Fri, Oct 10, 2008
Taylor from Orange County California calls in to ask how you can get
the formatting of a pivot table to stick? Every time that you refresh a
pivot table, the formatting reverts back to a default. The bad news is
that you can not make all formatting stick, but Episode 865 will show you a couple of methods to use.
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!

Download File - 19.2 MB Watch This Podcast (Streaming Video)
Episode 864 - Watch Window Format
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Thu, Oct 9, 2008
Today, a question about the Excel Watch Window. If you make changes to
the format of a watched cell, why won't the format in the Watch Window
change? Episode 864 shows you how to set up the watch window and how to get the latest formatting changes.
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!

Download File - 10.5 MB Watch This Podcast (Streaming Video)
Episode 863 - WIIW - Protect Sheet
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Wed, Oct 8, 2008
Where is it Wednesday: Where did they move Tools, Protection, Protect Sheet? In Episode 863,
I will show you how to protect only the formula cells in Excel 2007.
While this was complicated in Excel 2003, it is just a bit more
complicated in Excel 2007 when you can't find the final command,
Protect Sheet.
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!

Download File - 13.6 MB Watch This Podcast (Streaming Video)
Episode 862 - Color Precedents
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Tue, Oct 7, 2008
Dan from Texas asks: is there a way to change the color of cells that
are precedents of a particular formula. Use the technique in Episode 862 to quickly complete this task.
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!

Download File - 7.7 MB Watch This Podcast (Streaming Video)
Episode 861 - Subtotal Anomolies
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Mon, Oct 6, 2008
The subtotal command is a fantastic time-saver, but it occasionally behaves erratically. In Episode 861, I will show two situations which can cause the subtotal command to whack 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!

Download File - 17.8 MB Watch This Podcast (Streaming Video)
Episode 860 - Header Logo
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Fri, Oct 3, 2008 0:00 GMT,
Adding a company logo jpg to your worksheet header. Episode 860 shows how to add a header, and then poses a question about if your image is scaling in size as you add more data.
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!

Download File - 19.3 MB Watch This Podcast (Streaming Video)
Episode 859 - Two Mysteries
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Thu, Oct 2, 2008
Its two-for-the-price-of-one-Thursday (sounds like we need a new
theme...). Question 1: When editing a long formula, the formula covers
up adjacent cells, making it difficult to point to those cells with the
mouse. Question 2: When you use Shift+Ctrl+Right+Ctrl+Down to select a
large range, the Error icon scrolls off the screen. I'll propose
solutions to both of these in Episode 859.
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!
Download File - 15.8 MB Watch This Podcast (Streaming Video)
Episode 858 - WIIW - Copy as Picture
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Wed, Oct 1, 2008
In our Where Is it Wednesday podcast, we go looking for a command that
most people never would have been able to find in Excel 2003! If you
want to send a perfect copy of a formatted spreadsheet in an e-mail,
you could use Snag-It or PrtScrn, but by holding down the shift key,
you can find a hidden Copy as Picture command in Excel 2003. Episode 858 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!

Download File - 17.1 MB Watch This Podcast (Streaming Video)
Episode 857 - Smaller Pivot Files
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Tue, Sep 30, 2008
Say that you have a pivot table and need to send the file via e-mail. Use the trick in Episode 857 to dramatically reduce the size of your Excel 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!

Download File - 9.5 MB Watch This Podcast (Streaming Video)
Episode 856 - Print 2-Up
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Mon, Sep 29, 2008
Is there any way to make Excel print 2 pages per physical sheet of paper? The answer is maybe...it all depends on your printer! Episode 856 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!

Download File - 6.8 MB Watch This Podcast (Streaming Video)
Episode 855 - Dynamic Comment?
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Fri, Sep 26, 2008
Sergiy asks if there is any way to have a cell comment or a validation
input box reflect a value from a formula in a cell. I couldn't find a
good solution, other than using VBA. Episode 855 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!

Download File - 11.1 MB Watch This Podcast (Streaming Video)
Episode 854 - VLOOKUP Below
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Thu, Sep 25, 2008
Can the VLOOKUP return a value one row below the matched value? Episode 854 shows you how to achieve this result using two other functions.
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!

Download File - 16.4 MB Watch This Podcast (Streaming Video)
Episode 853 - Preventing #N/A
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Wed, Sep 24, 2008
You love VLOOKUPs, but you hate the #N/A error that results. In our
Where is it Wednesday edition of the MrExcel podcast, I will show you
two ways to prevent #N/A as the result of your VLOOKUP formulas. One
harder method in Excel 2003 and an easier method in Excel 2007. Episode 853 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!

Download File - 15.1 MB Watch This Podcast (Streaming Video)
Episode 852 - Tiny Blank Columns
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Tue, Sep 23, 2008
Sometimes a manager demands that you insert tiny little columns between
the columns of your data set. While I hate this, use the trick in
Episode 852 to ensure that the data set sorts correctly.
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!

Download File - 8.2 MB Watch This Podcast (Streaming Video)
Episode 851 - Filter by Selection II
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Mon, Sep 22, 2008
Wiebe points out a better solution for Episode #838 - Excel already has
an icon for Filter by Selection. It is hard to find and poorly labeled,
but it is in there. Episode 851 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!

Download File - 7.0 MB Watch This Podcast (Streaming Video)
Episode 850 - Copy Worksheet 750
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Fri, Sep 19, 2008
I've shown how to make copies of a worksheet within a workbook before,
but in today's podcast, someone asks if you can drag a worksheet to a
new workbook. Episode 850 shows you how. Also - in honor of the 750th podcast episode, a new contest for Saturday.
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!

Download File - 9.7 MB Watch This Podcast (Streaming Video)
Episode 849 - Remove Group
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Thu, Sep 18, 2008
After adding subtotals by Customer, Excel adds three group and outline
buttons. Most people use the #2 and #3 buttons but rarely use the #1
button. Could you simply remove the #1 button? Podcast 849 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!

Download File - 7.2 MB Watch This Podcast (Streaming Video)
Episode 848 - Speak Status
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Wed, Sep 17, 2008
Can Excel announce a status when someone opens the workbook? This macro will let someone know if they are over or under quota. Episode 848 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!

Download File - 10.6 MB Watch This Podcast (Streaming Video)
Episode 847 - Filling Blanks
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Tue, Sep 16, 2008
Seiichi from Japan asks how to fill in blank cells in column A with the value above the blank. Episode 847 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!
Download File - 7.2 MB Watch This Podcast (Streaming Video)
Episode 846 - 2007 Pivot Table 101
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Mon, Sep 15, 2008
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!

Download File - 17.1 MB Watch This Podcast (Streaming Video)
Episode 845 - Stacked Column 3
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Fri, Sep 12, 2008
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!

Download File - 10.5 MB Watch This Podcast (Streaming Video)
Episode 844 - AutoSum Macro
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Thu, Sep 11, 2008
Mark asks about how to replicate the AutoSum concept in a macro. The code in Episode 844 gets closer to the AutoSum functionality than the solution that I proposed in Episode 812.
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!

Download File - 15.7 MB Watch This Podcast (Streaming Video)
Episode 843 - WIIW - Custom Toolbars
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Wed, Sep 10, 2008
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!

Download File - 15.0 MB Watch This Podcast (Streaming Video)
Episode 842 - SumIf a Range
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Tue, Sep 9, 2008
Marc sends in an interesting question about SUMIF. Each time the value
is equal to January, he wants to grab a five-cell range! SUMIF doesn't
seem up to the challenge, but an array formula with OFFSET does the
trick. Episode 842 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!

Download File - 14.6 MB Watch This Podcast (Streaming Video)
Episode 841 - Transpose Formula II
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Mon, Sep 8, 2008 :00 GMT,
Kyle sends in a different way to transpose with a formula - the array
function =TRANSPOSE will do the trick. Also, Joe and Adrien check in
with alternate ways of closing Excel. Episode 841 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!

Download File - 10.2 MB Watch This Podcast (Streaming Video)
Episode 840 - Strange Pivot
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Fri, Sep 5, 2008
Vaibhav sends in a question about creating a particular pivot table. There are a number of challenges in this project. In Episode 840,
you will see how to re-order items along a pivot field, how to remove
subtotals from one field, how to arrange multiple date fields to go
across the page, changing the headings from Sum of X to just X, and
filling in blanks with zeroes.
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!

Download File - 17.3 MB Watch This Podcast (Streaming Video)
Episode 839 - Filter by Selection
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Thu, Sep 4, 2008
Shawn sends in a great tip for today's podcast. Access has a Filter by
Selection icon. Using a few lines of VBA code, you can add this
functionality to your personal macro workbook. Episode 839 shows you how.
Here is the code: Sub Filter_by_Active_Cell() Dim ColNum As Integer ColNum = ActiveCell.Column - _ (ActiveCell.CurrentRegion.Column - 1) Selection.AutoFilter Field:=ColNum, Criteria1:=ActiveCell End Sub
Sub AutoFilterToggle() Selection.AutoFilter End Sub
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!

Download File - 13.1 MB Watch This Podcast (Streaming Video)
Episode 838 - WIIW - Move Direction
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Wed, Sep 3, 2008
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!

Download File - 12.7 MB Watch This Podcast (Streaming Video)
Episode 837 - Add up C5 cells
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Tue, Sep 2, 2008
Interesting question from the Southeastern Accounting Show: I want to
sum from cell A5 and sum down a certain number of cells. However, the
number of cells is stored in cell C5!
Episode 837 will show you the obscure but flexible OFFSET function that can 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!
Download File - 11.1 MB Watch This Podcast (Streaming Video)
Episode 836 - Pie Chart on a Coin
Author: Bill Jelenconsult@MrExcel.com (Bill Jelen) Mon, Sep 1, 2008
This was an intriguing question...how can you set up a pie chart in Excel that appears to divide a dollar coin into wedges?
It
is not as easy as you would think. If you try to fill the chart with an
image of a coin, Excel repeats the coin image on each wedge of the pie.
Cool, but not what we are looking for.
Episode 836 will show you how to successfully get the coin as the background of the pie 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!
Download File - 14.3 MB Watch This Podcast (Streaming Video)
- LearnOutLoud.com Product ID:
L019759

Self Development
Instructional

|