 Primary Format :
Language :
Also Listed as:
City :
State/Province :
Country :
Region :
User Tags:
User Votes:
 RSS Feed
Website
People found this Podcast
Searching for:
View this Podcast on a Google Map. 
 Text Only listing of Learn Excel from MrExcel Video Podcast Podcasts
 Methings.com listings of Learn Excel from MrExcel Video Podcast Podcasts
If you like this podcast, you might also like:
|
Dueling Excel - "Quarters": Podcast #1515 Today in Episode #1515 we have a series of Dates. We want to show quarters for the year 2012. Bill 'MrExcel' Jelen goes Old School on this one while Mike 'ExcelisFun' Girvin goes for a more Functionally 'stream-lined' approach. Mike and Bill look at the =CEILING, =MONTH, VLOOKUP functions and more.
Dueling Excel Podcast #97…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the entry and 'Stop Speaking Cells' -on the Quick Access Toobar- is not making it stop. Why? Follow along with Bill in Episode #1514 to learn why the cells won't stop speaking and then learn how to turn off the 'Speak On Enter' function.
Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring ... Listen | Listen in your iPhone | Download | View full cache |
Dueling Excel - "Total All Lookups": Podcast #1513Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn more about the LOOKUP function, how to use SUM and SUMPRODUCT and Array Formulas in Episode #1513.
Dueling Excel Podcast #95…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currentl ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - " Move Entire Rows ": Podcast #1512Charlie -who admits he is relatively new to Microsoft Excel- needs to rearrange the rows of his spreadsheet. Today, in Episode #1512, Bill shows us several methods to accomplish this task.
Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill &ldquo ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Chart An Extra Series": Podcast #1510Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the Chart is giving three (3) Series instead of two (2). With a few simple clicks in Episode #1510, Bill "MrExcel" Jelen solves the additional series issue.
Today's Episode is brought to you by... New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articl ... Listen | Listen in your iPhone | Download | View full cache |
Dueling Excel - "Conditional Format +/- 15%": Podcast #1509Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by 15%"
Initially, it appears that there is only one way to accomplish this task, but Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen find another way to tackle and solve this challenge. Follow along with Episode #1509 to see how its done!
Dueling Excel Podcast #95…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel&rs ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Count Between A Range": Podcast #1508The Question: "I have a =COUNTIF to count values less than 10 and another to count values less than 20; but how do I count the values that fall between 10 and 20?" In 2007 and newer, there is a New Function called '=COUNTIFS". Follow along with Bill in Episode #1508 to learn how to solve this question - even if you are using Excel 2003 or earlier!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new t ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Deviation?" =RANDBETWEEN won't do it, but a clever use of =RAND and =NORM.INV ["Normal Inverse"] will do it. In Episode #1507, Bill shows us how to generate Random Numbers with this method.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to le ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the " N-NN-NNNN " Format to Dates, by Excel. Today, how to prevent this from happening is the subject Bill works with in Episode #1506.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteri ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Next Invoice Number": Podcast #1505The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Ex ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Saving Form to Database": Podcast #1504John from New Zealand offers an improvement to Thursday's podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the p ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Saving Form to Database": Podcast #1503Today, Bill shows off some of the truly dynamic functionability of Microsoft Excel. Oz wants to use a worksheet as a data entry form and then post the record to a database. In Episode #1503 - the first of a two part tutorial series - Bill shows us how to use some VBA to make this happen.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 5 ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Running Total AutoFill": Podcast #1502Mally wants a simple Spreadsheet - Two (2) Columns; she asks how to enter a Value in Column A and have the Running Total over in Column B automatically fill down. Episode #1502 shows you how to use the new Table functionality to solve this. Also, in reference to the Learn Excel from MrExcel Podcast Episode #1482, Bill readdresses a few more Table Topics, such as: 'Control-T' to define your Data Set as a Table or going to 'File > Options > Formulas > 'Working With Formulas' area and ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Will The Globetrotters Lose?": Podcast #1501"I am going out on a limb to predict that the four-point shot will lead to an accidental Washington Generals win this season", Bill said. Episode #1501 shows off a couple of dueling Win/Loss sparklines with my prediction. I don't know when, but sometime soon, the Harlem Globetrotters will fall to the Washington Generals.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Filter to Unique?": Podcast #1500Today's question... can you use the AutoFilter dropdowns to filter to one row per unique customers? For a solution to this, you can move to the Advanced Filter or use Remove Duplicates on a copy of the data. Follow along with Episode #1500 as Bill shows us both methods.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solv ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Improved Excel Help": Podcast #1499I'm sure [like myself] that some viewers will be somewhat confused when viewing this podcast today...I assume that many of us thought Bill "MrExcel" Jelen and the MrExcel Community was the 'Excel Help' function...but that would be only partially correct! Today, in Episode #1499, Bill focuses on Excel Help and how it has learned a new trick; Excel Help now includes Community Content! Episode #1499 shows us the ins and outs!
…This episode is the video ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Two Subtotals At Top": Podcast #1498Today, Amelie asks how to add Two sets of Subtotals, with the Subtotals appearing at the top! In Episode #1498 of the Learn Excel from MrExcel Podcast Series, Bill shows us how to get the Subtotals.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’ ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Sheets Revisted": Podcast #1497Episodes #1488 and #1489 of the "Learn Excel from MrExcel Podcasts" generated a lot of email from viewers. Today, in Episode #1497, Bill revisits those episodes [that were dealing with making copies of worksheets]. Looking at several methods emailed in over the last week, Bill demonstates even more Copy Worksheet methods - including a VBA Macro routine!Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Did Santa bring an iPad?": Podcast #1495Today, Bill offers a quick tip on getting acclimated to your new iPad! Check out QUE Publishing. QUE is offering a free enhanced eBook sampler. This is a great way to show off your new iPad! See Episode #1495 for details – Bill shows you exactly how to get this FREE Sampler easily!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 5 ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Holiday Gift Labels": Podcast #1494MrExcel on Word for The Holidays!?
Running short of gift tag labels? They are available for Free, inside Microsoft Word 2007 or newer. Today, in Episode #1494, Bill "MrExcel" Jelen reminds you of the Office Online Templates that are available to you!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More&nbs ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Variable Chart by Dropdown": Podcast #1493Today, in Episode #1493, Mike from Athens, Greece asks how to create a control that would change a chart to show either units or revenue. Bill presents a borrowed solution from Mike Alexander at DataPigTechnologies.com, but when you see the solution, you will realize that the trick is barely a trick at all.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn on ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 – “Random Drug Testing”: Podcast #1491A small company has decided to start doing Random Drug Testing. They want to randomly select two (2) employees each month. In Episode #1491, Bill builds a handy Workbook for this task. Enter the Employee Names in B2:B101, then press F9 to select two (2) employees for the month. The Randomization is done with formulas – no VBA.
*Oh No! Podcast #1490 never launched; we apologize for the misfire!*
…This episode is the video podcast companion to the book, “Learn Excel 20 ... Listen | Listen in your iPhone | Download | View full cache |
Dueling Excel - "Find Cubic Feet": Podcast #1492Today's Dueling Excel comes from France... Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen are looking for the words 'Top laod' or 'Front load', and then Cubic Feet. In the process they will also need to change the decimal in the value to a comma to make the value appropriate in French. Using Formulas, a little VBA and some creativity, Mike and Bill offer a few different solutions to the challenge in Episode #1492.
Dueling Excel Podcast #94…This episode is the video podcast co ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490All this week, Bill has been dealing with a Workbook with 31 sheets - one Worksheet per day. Today, in Episode #1490, Bill presents a bizarre Formula to put the Sheet Name in a Cell. Actually, today, I use a MID of the Sheet Name to fill in the correct Date in a Cell.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489Yesterday, in Podcast Episode #1488, Bill showed us a cool way to make 30 copies of a worksheet. However, after creating the worksheets we were left with strange names like Sheet1 (2), Sheet1 (3) and so on. Horrible! Today, in Episode #1489, Bill shows us how - with one line of code in the VBA Immediate Window - to solve the remaining issue of renaming the new Worksheets.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Worksheet Per Day": Podcast #1488Damia from YouYube has to create 31 copies of a worksheet; one for each day of the month. Right now, Damia is using 'Insert Worksheet' 30 times, copying Sheet1 contents and pasting 30 times; then changing the zoom, changing the column widths and changing the print settings. Today, in Episode #1488, Bill introduces the 'Move or Copy' dialog and shows us how to knock out 30 copies of the worksheet in just a few seconds! Awesome!
…This episode is the video podcast compani ... Listen | Listen in your iPhone | Download | View full cache |
Dueling Excel - "Watch Box": Podcast #1488In today's Dueling Excel, Episode #1488, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen team up to defend Excel's honor, showing two different methods to create a Watch Box in Excel.
Dueling Excel Podcast #93…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Ed ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Zero Point Zero Two": Podcast #1486Today, in Episode #1486, Bill discusses his experience at a recent seminar.
"I was doing a Power Excel Seminar in Miami when I kept typing zero point zero two (0.02) in a formula. Of course, 0.02 is 2%. Someone asked me why I didn't cut the typing in half with 2%. Wow! Silly me... this clearly works!"
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Picture Lookup": Podcast #1485Prince asks if there is a way to return a Picture as the result of a VLOOKUP instead of a Value. In Episode #1485, Bill shows us one way to solve the challenge and deliver the result.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“ ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Labels from Excel Data to Word 2010": Podcast #1484So, You have address information in Excel and you want to produce mailing labels in Word. Should be easy, right? Moslty, Wrong. No venture into Word is easy. In Episode #1484, Bill will show us the hassle-free method to produce labels in Word 2010 using our Excel data.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solve ... Listen | Listen in your iPhone | Download | View full cache |
Dueling Excel - "Rounding Invoices": Podcast #1483We don't call it 'Dueling Excel' for No Reason! And at some point one has to stop and ask, "How can two guys possibly disagree about the best way to Round Invoices?"Well... leave it to Mike and Bill because they can - and do. Today's Duel is figuring out the best way to Round Invoices in Episode #1483
Dueling Excel Podcast #92…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Maki ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Table Schmable, I Want Results!": Podcast #1482Today Yari is frustrated that his Formulas pointing into a Table (with a capital T) will not copy across the Columns. Yari wants totals and he isn't getting them. In Episode #1482, Bill explains why Yari isn't getting his totals and then shows us two methods that will display totals for us.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel - "Repeat Macro for Each Cell in A": Podcast #1481Learn a little about Customizing your VBA. We have a Macro that runs on the current cell; JK wants the macro to run for each cell in Column A. Today, in Episode #1481, Bill shows us how calculate the number of cells we need to check and then loop the macro.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% M ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Sum Over Threshold": Podcast #1480Today, lets consider this question: Someone has a threshold value of $25000 in cell E1. We want to add up all the values in A2:A8 that are over the threshold. But...as a twist, how do we work with only those amounts in excess of the threshold? In Episode #1480 Bill shows how this can be accomplished.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of th ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel - "Differing Column Widths": Podcast #1479YouTube viewer Bill sent in a question: "How can change column widths when I am half way down the column?" Bill is using Mac Office 2008. Though there isn't a way to do what Bill is asking, MrExcel offers up a possible solution to this challenge in Episode #1479.
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Rank Ties Redo": "Podcast #1478Last weeks Dueling Excel Episode #1473 looked at Ranking Ties by Weight. Today, in Episode #1478, Bill shows a method using a temporary column.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExce ... Listen | Listen in your iPhone | Download | View full cache |
The Learn Excel from MrExcel Podcast - "BFSBSCM": Podcast #1477It's the eve of the holiday shopping season. And while we don't hope to have anyone camping out at MrExcel overnight, here are some of the deals that we are running starting Thursday, 24-November-2011 and through Monday 28-November-2011. Don't miss out on these Excel-lent opportunities from MrExcel.com!
…This blog and video podcast are sponsored by the book, Learn Excel 2007 through Excel 2010 from MrExcel and The MrExcel Excel Store!
Learn Excel 2007 through Excel 201 ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Number The Visible Row": Podcast #1476A Challenge from none other than Bob Umlas - author of "Excel Outside The Box: Unbelievable Excel Techniques". Bob wants to Number Rows, but ignore the 'Hidden' Rows. In Episode #1476 Bill looks to a New Function for Excel 2010: " =AGGREGATE" Learn about it with the 'Learn Excel from MrExcel' Video Podcast.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Lat 12 34.567": Podcast #1475A facebook posting asks how to convert a column of 7 digit numbers (ie, 1234567) into the format of "Lat 12 34.567". The answer is easier than you might think. In Episode #1476, Bill shows us a non-formula way to answer the question and get the result.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than&nbs ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Date Stamp Next to a Yes": Podcast #1474Superbeast326 at YouTube asks if there is a way to add the current date to the right of any 'Yes' entries in a spreadsheet; if a cell is marked 'Yes', then I want the cell to the right of that cell to show the date. Using a simple 'Event Handler' macro, in Episode #1474, Bill creates a means to answer the question and record the date.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday ... Listen | Listen in your iPhone | Download | View full cache |
Dueling Excel - "Rank Ties by Weight": Podcast #1473Dueling 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 based on another column. Today, in Episode #1473, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen offer their solutions to this challenge.
Dueling Excel Podcast #91…This episode is the video podcast companion to the book, “Slaying Excel Dra ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Wrap Cells and Resize": Podcast #1472Herbie 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.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous e ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Random with No Repeats": Podcast #1471Choose random weeks from the Data Set, but do it without repeating a week. In a revisit to Episode #1469, how will Bill assure that there are no repeats in the Random selection? Follow along with Episode #1471 today to learn the answer and solve the challenge.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Copy Totals to Week # Macro": Podcast #1470Patrick 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 figure out where to paste special the data. Follow along with Episode #1470 as Bill shows us how to accomplish the task.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video ever ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Random Weeks Over 6 Months": Podcast #1469A YouTube viewer wants to find a way to generate random weeks over the next 6 months. In Episode #1469, Bill “MrExcel” Jelen – using TODAY, WEEKDAY, and RANDBETWEEN Functions – shows us a Formula to calculate random weeks for the next 6 months or year.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Added Times Won't Calculate": Podcasts #1468Shaun 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. With a few changes in the Formula and Cell Formats, Bill shows us in Episode #1468 how to get the real resulting Total Hours and Cost.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every wor ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Column B is now Column 2?": Podcast #1467Every few months Bill receives a call or an email from someone stating that their Formulas are 'changed' and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? "R1C1" is the answer. Follow along with Bill in Episode #1467 to find out what happened and how to correct it.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Exc ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Embed a PDF in Excel": Podcast #1466Can 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.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel ... Listen | Listen in your iPhone | Download | View full cache |
Learn Excel 2010 - "Remove Spaces with VBA": Podcast #1465Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the worksheet; the spaces in the middle remain after running the Macro. Bill shows us, In Episode #1465, how to solve this issue with the 'Application.WorksheetFunction' to remove those spaces in the middle.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries ... Listen | Listen in your iPhone | |