Learn Excel from MrExcel Podcast

About this original series

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

# Episodes
193 episodes
Rating
TV-UN

Episodes of Learn Excel from MrExcel Podcast

- Play
  
  Learn Excel 2010 - "Date Next to a Yes" #1474
  
  A YouTube viewer asks if there is a way to add the current date to the right of any 'Yes' entries in a spreadsheet. Using a simple 'Event Handler' macro, Bill creates a means to answer the question.
  - Release date
    
    Dec 28, 2011
  - Runtime
    
    03:19
- Play
  
  Dueling Excel - "Rank Ties by Weight" #1473
  
  Today in Episode #1473, Dueling Excel looks at Scores and Tie Breaking. In this example, When there is a tie, we want to award the Highest Rank to the Largest Weight. Quite simply, after ranking a column with ties, we want to break the tie.
  - Release date
    
    Dec 28, 2011
  - Runtime
    
    07:52
- Play
  
  Learn Excel 2010 – “Wrap Cells and Resize" #1472
  
  Herbie has a Calendar spreadsheet being populated by a huge concatination formula. He asks if there is a way to combine Wrap Cells and Shrink to Fit as he works in the calendar. In Episode #1472 Bill shows us one way to accomplish this.
  - Release date
    
    Dec 28, 2011
  - Runtime
    
    03:39
- Play
  
  Learn Excel 2010 - "Random with No Repeats" #1471
  
  Choose random weeks from the Data Set, but do it without repeating a week. In a revisiting #1469, how will Bill assure that there are no repeats? Follow along with Episode #1471 today to learn the answer and solve the challenge.
  - Release date
    
    Dec 28, 2011
  - Runtime
    
    02:09
- Play
  
  Learn Excel - "Copy Total to Weeks Macro": #1470
  
  Patrick has a weekly Expense Ledger Spreadsheet set up; he wants to create a Macro to copy the Totals from Report 1 to a corresponding Week Number Row on the Summary worksheet. This Macro has to use the FIND command in VBA to...
  - Release date
    
    Nov 29, 2011
  - Runtime
    
    06:30
- Play
  
  Learn Excel - "Random Weeks Over 6 Months": #1469
  
  A YouTube viewer wants to find a way to generate random weeks over the next 6 months. In Episode #1469, Bill – using TODAY, WEEKDAY, and RANDBETWEEN Functions – shows us a Formula to calculate random weeks for the next 6 months or year.
  - Release date
    
    Nov 29, 2011
  - Runtime
    
    02:23
- Play
  
  Learn Excel - "Added Times Won't Calculate": #1468
  
  Shaun has a beautiful spreadsheet to calculate staffing levels and expense.He needs to multiply shift length by the number of staff and the answer that he is getting is . . . immaterial to the task at hand.
  - Release date
    
    Nov 29, 2011
  - Runtime
    
    02:59
- Play
  
  Learn Excel - "Column B is now Column 2?": #1467
  
  Formulas are ‘changed’ and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? “R1C1″ is the answer. Learn Excel 2010 from MrExcel!
  - Release date
    
    Nov 21, 2011
  - Runtime
    
    01:01
- Play
  
  Learn Excel 2010 - "Embed a PDF in Excel": #1466
  
  Can you embed a PDF in a worksheet? Yes - Using the 'Insert Object' Menu Tab. Follow along with Bill, in Episode #1466, as he shows us how to embed a PDF in our Worksheet.
  - Release date
    
    Nov 14, 2011
  - Runtime
    
    01:26
- Play
  
  Learn Excel 2010 - "Remove Spaces with VBA": #1465
  
  Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the worksheet; the spaces in the middle remain after a Macro run. Bill shows us, In episode #1465, how to solve this issue with the 'Application.WorksheetFunction'.
  - Release date
    
    Nov 10, 2011
  - Runtime
    
    02:24