|
|
||||||
 |
||||||
|
Dueling Excel - "Quarters": Podcast #1515 Updated: 2012-02-10 15:47:26 Description: 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514 Updated: 2012-01-30 17:01:41 Description: VJ 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Total All Lookups": Podcast #1513 Updated: 2012-01-27 21:07:31 Description: Mike 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. Due...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - " Move Entire Rows ": Podcast #1512 Updated: 2012-01-26 20:48:00 Description: Charlie -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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Chart An Extra Series": Podcast #1510 Updated: 2012-01-23 16:56:00 Description: Richard 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Conditional Format +/- 15%": Podcast #1509 Updated: 2012-01-20 17:05:37 Description: Today'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 t...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Count Between A Range": Podcast #1508 Updated: 2012-01-19 14:11:00 Description: The 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507 Updated: 2012-01-12 15:05:24 Description: Today'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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506 Updated: 2012-01-11 17:49:08 Description: Simons 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 w...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Next Invoice Number": Podcast #1505 Updated: 2012-01-10 14:04:54 Description: The 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Saving Form to Database": Podcast #1504 Updated: 2012-01-09 15:03:00 Description: John 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Saving Form to Database": Podcast #1503 Updated: 2012-01-05 19:28:04 Description: Today, 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Running Total AutoFill": Podcast #1502 Updated: 2012-01-04 15:50:14 Description: Mally 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Will The Globetrotters Lose?": Podcast #1501 Updated: 2012-01-03 13:53:44 Description: "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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Filter to Unique?": Podcast #1500 Updated: 2011-12-30 20:55:57 Description: Today'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 sh...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Improved Excel Help": Podcast #1499 Updated: 2011-12-29 20:10:07 Description: I'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 wou...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Two Subtotals At Top": Podcast #1498 Updated: 2011-12-28 13:58:19 Description: Today, 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Sheets Revisted": Podcast #1497 Updated: 2011-12-27 15:42:23 Description: Episodes #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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Did Santa bring an iPad?": Podcast #1495 Updated: 2011-12-26 21:49:00 Description: Today, 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 e...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Holiday Gift Labels": Podcast #1494 Updated: 2011-12-26 15:31:23 Description: MrExcel 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!...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Variable Chart by Dropdown": Podcast #1493 Updated: 2011-12-22 19:54:33 Description: Today, 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,...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 – “Random Drug Testing”: Podcast #1491 Updated: 2011-12-21 14:42:14 Description: A 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Find Cubic Feet": Podcast #1492 Updated: 2011-12-16 14:57:50 Description: Today'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 co...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490 Updated: 2011-12-15 14:33:11 Description: All 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 corre...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489 Updated: 2011-12-14 18:47:29 Description: Yesterday, 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 sho...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Worksheet Per Day": Podcast #1488 Updated: 2011-12-12 15:41:26 Description: Damia 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 width...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Watch Box": Podcast #1488 Updated: 2011-12-09 14:02:55 Description: In 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…T...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Zero Point Zero Two": Podcast #1486 Updated: 2011-12-08 16:34:37 Description: Today, 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 typi...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Picture Lookup": Podcast #1485 Updated: 2011-12-07 15:49:11 Description: Prince 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, &...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Labels from Excel Data to Word 2010": Podcast #1484 Updated: 2011-12-05 20:47:35 Description: So, 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 us...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Rounding Invoices": Podcast #1483 Updated: 2011-12-05 14:32:58 Description: We 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 fig...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Table Schmable, I Want Results!": Podcast #1482 Updated: 2011-12-01 16:17:59 Description: Today 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "Repeat Macro for Each Cell in A": Podcast #1481 Updated: 2011-11-30 15:31:57 Description: Learn 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...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Sum Over Threshold": Podcast #1480 Updated: 2011-11-29 15:01:31 Description: Today, 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 Epi...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "Differing Column Widths": Podcast #1479 Updated: 2011-11-28 13:06:09 Description: YouTube 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 E...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Rank Ties Redo": "Podcast #1478 Updated: 2011-11-28 12:41:57 Description: Last 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 MrE...more... LISTEN NOW | VIEW CACHE | DOWNLOAD The Learn Excel from MrExcel Podcast - "BFSBSCM": Podcast #1477 Updated: 2011-11-24 16:17:36 Description: It'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 m...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Number The Visible Row": Podcast #1476 Updated: 2011-11-23 15:50:02 Description: A 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 a...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Lat 12 34.567": Podcast #1475 Updated: 2011-11-22 15:04:49 Description: A 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 resul...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Date Stamp Next to a Yes": Podcast #1474 Updated: 2011-11-21 14:08:24 Description: Superbeast326 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' mac...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Rank Ties by Weight": Podcast #1473 Updated: 2011-11-18 14:00:00 Description: 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 based on another column. Today, in...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Wrap Cells and Resize": Podcast #1472 Updated: 2011-11-17 15:48:08 Description: 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. …This ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Random with No Repeats": Podcast #1471 Updated: 2011-11-16 14:52:11 Description: Choose 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Copy Totals to Week # Macro": Podcast #1470 Updated: 2011-11-15 17:39:26 Description: 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 figure out where to past...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Random Weeks Over 6 Months": Podcast #1469 Updated: 2011-11-14 16:12:06 Description: A 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Added Times Won't Calculate": Podcasts #1468 Updated: 2011-11-11 14:47:00 Description: 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. With a few changes in the Formula and Cell ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Column B is now Column 2?": Podcast #1467 Updated: 2011-11-10 15:37:34 Description: Every 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 ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Embed a PDF in Excel": Podcast #1466 Updated: 2011-11-09 13:52:22 Description: 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. …This blog is the video podcast companion to the book, Learn Excel 2007...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Remove Spaces with VBA": Podcast #1465 Updated: 2011-11-08 14:23:24 Description: 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 running the Macro. Bill shows us, In Episode #1465, how to solve this issue with the 'Application.WorksheetFunct...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Keep The Last Duplicate": Podcast #1464 Updated: 2011-11-07 13:06:56 Description: Tony needs to keep the last duplicate record and throw out the earlier ones. In Episode #1464 Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen demonstrate competing methods to get this issue solved. Dueling Excel Podcast #90&...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Left 26 Even if Only 10": Podcast #1463 Updated: 2011-11-04 13:12:47 Description: Shrikant needs to join the left 26 characters of column A with column B. But...even if A2 only has 10 characters, he needs it to fill with spaces so that the value from B starts in character position 27 each and every time. In Episode #1463, Bill sho...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Word Count from Word": Podcast #1462 Updated: 2011-11-03 14:38:39 Description: Stefan from Sweden checks in with a much better way to do a word count of all the sentences [referring to the "Word Count from Sentences" Podcast, Episode #1460]. How? Using... a tiny little Add-In that most Excel Users already have! Check out Episod...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "Pivot Table Defaults": Podcast #1461 Updated: 2011-11-02 02:34:00 Description: Why can't we do a Pivot Table Template? Why can't we turn off the annoying Compact Layout? Why do I keep asking these questions when it is so easy to override them with a tiny add-in? MrExcel Labs is coming out with a tiny add-in to solve Pivot Ta...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Word Count from Sentences": Podcast #1460 Updated: 2011-11-01 14:44:48 Description: Today on Learn Excel from MrExcel, Zac has 5000 phrases in column A. He wants to figure out which words are most popular in those phrases. With Episode #1460, Bill shows us a number of steps that will solve the problem in about six minutes. …T...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Pivot Table Totals on Left": Podcast #1459 Updated: 2011-10-31 12:32:38 Description: Someone in my Michigan seminar posed this question: “Can you get the pivot table grand total column to appear on the left side of the pivot table?” This is handy when you have so many columns that you’re not able to see the Totals C...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "Scrolling In the Formula Bar": Podcast #1458 Updated: 2011-10-28 12:42:54 Description: Jil asks today's question. Jil used to be able to edit a Formula and use the Wheel Mouse to scroll the Spreadsheet while editing the formula. This apparently doesn't work any more, starting in Excel 2007. Today, in Episode #1458, Bill shows us a work...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Excel Outside The Box": Podcast #1457 Updated: 2011-10-27 13:57:00 Description: Bob Umlas’ new book just arrived from the printer – “Excel Outside the Box: Unbelievable Excel Techniques”. Today, Bill takes a look at the new book, tells you where you can buy an advanced copy, and shows you a trick from the...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "Pivot To Range": Podcast #1456 Updated: 2011-10-27 13:47:10 Description: Two Pivot Table questions today from my ‘Power Excel’ Seminar in Detroit, MI yesterday. First, when you drill down on a pivot table in Excel 2007, you are getting the Table Format instead of just a Range. How can I just get the Range? Sec...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Drag Formula Referene": Podcast #1455 Updated: 2011-10-25 12:43:40 Description: Frank asks if there is a way to rewrite a formula using a scrollbar. While we can’t do it with a scrollbar, I do have a way to rewrite formula with a dragging technique. Following along with Bill in Episode #1455 to see how it’s done. &he...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "The Top 70%": Podcast #1454 Updated: 2011-10-24 14:21:10 Description: Today, Bill “MrExcel” Jelen and Mike “ExcelisFun” Girvin look at a question that asks: “How can I audit 70% of the book value, with samples based on the value?” Conditional Formatting produces 70% of the cells and ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Clear If new Day": Podcast #1453 Updated: 2011-10-21 12:24:52 Description: Kevin wants to clear out data for yesterday’s shift worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added he has added, Bill shows us the solution today in Episode #1453...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Shift Change?": Podcast #1452 Updated: 2011-10-20 19:19:33 Description: Bill wants to know: “Did a new shift start between Time 1 and Time 2? It sounds like such an easy formula, and it probably is, but I sure had a tough time puzzling this formula out. Do you have something easier?” Today, in Episode #1452, ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2011 - "Mac xlautomatic": Podcast #1451 Updated: 2011-10-19 15:17:01 Description: Mark this date: October 18th, 2011 – Bill “MrExcel” Jelen’s First-Ever Podcast for MAC Users! [The Title of this Blog Post is NOT a typo.] Joe has Excel 2011 for Mac. He turned on the macro recorder and changed some colors in ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Formulas Not Working": Podcast #1450 Updated: 2011-10-18 12:52:58 Description: What is ‘Alt+DEF’ good for? Today, in Episode #1450, Christopher and Sheila both wrote in with different problems that required the same solution. Both had formulas that were not working. Both happened to have numbers or dates stored as t...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Positive Subtotals": Podcast #1449 Updated: 2011-10-17 15:01:24 Description: Today, in Episode #1449, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen address different methods to answer the question: “Is there a way that the Grand Totals and Subtotals would omit the Negative Subtotals?” D...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "The MrExcel Mailbag": Podcast #1448 Updated: 2011-10-14 12:07:22 Description: Today, in Episode #1448, Bill re-addresses a few past podcasts with alternate solutions. Follow along, make note and improve your effectiveness with Microsoft Excel! A Non-VBA Solution to get Misplaced Excel Windows back into view (improving upon E...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Add Totals": Podcast #1447 Updated: 2011-10-13 18:23:22 Description: Want to see immediate results? Set an area to the bottom and right of a massive spreadsheet where you can add totals and see them at a glance. In Episode #1447 Bill shows us how to do this with only a few keystrokes. …This blog is the video po...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "MODE from Frequency Table": Podcast #1446 Updated: 2011-10-12 16:22:00 Description: In today’s Dueling Excel Podcast, with Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen, Mike and Bill look at methods to calculate the MODE and MEDIAN from data that is arranged in a Frequency Table. Follow along with ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Within 25% of Budget": Podcast #1445 Updated: 2011-10-11 23:07:26 Description: In a spreadsheet that keeps track of expenses, we want to mark the cell in one color if the expenses are within 25% of the budget and in another color if they are within 10% of the budget. In Episode #1445, Bill shows us how to do this. …This ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Time 1 Hour Ago?": Podcast #1444 Updated: 2011-10-10 16:25:44 Description: Is it possible to flag a cell if the time in the cell is more than an hour late? Today, in Episode #1444, Bill shows us a Conditional Formatting Formula to answer this question. …This blog is the video podcast companion to the book, Learn Exce...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Center Across Selection": Podcast #1443 Updated: 2011-10-07 13:11:00 Description: Jack asked about centering titles above a report. I suggested “Center Across Selection”, and Jack’s coworker suggested “Merge and Center”. While it is a lot easier to find Merge and Center, there are reasons why you don&...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Hide and Protect": Podcast #1442 Updated: 2011-10-06 13:14:00 Description: I want to Hide some Settings right in plain view on the spreadsheet, but the person using the spreadsheet keeps inadvertently deleting those settings! In Episode #1442, Bill shows us one solution to keeping those settings from being deleted. …...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Conditional Format the Entire Row": Podcast #1441 Updated: 2011-10-05 11:27:14 Description: Amal wants to highlight an entire record in red when the date falls within two weeks and then, leave the ‘Done’ column not marked as True. In Episode #1441, Bill shows us the tricky Conditional Formatting method to get the results we want...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Mixing Chart Themes": Podcast #1440 Updated: 2011-10-04 14:40:56 Description: “Last week, I needed one Chart to use the colors from one Theme and a second Chart to use the colors from another Theme. The Chart Fill Dropdown wasn’t helping, but I found a workaround using the Cell Fill Dropdown. Today, in Episode #144...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Algebra? We don't need Algebra!": Podcast #1439 Updated: 2011-10-03 12:31:37 Description: Mike’s son Dennis has a baseball problem from his algebra class. Bill “MrExcel” Jelen and Mike “ExcelisFun” Girvin differ over whether the problem actually requires Algebra, Goal Seek, or simply a visit with Bob Barker. ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Variable Rate Loan Payment": Podcast #1438 Updated: 2011-09-30 13:22:52 Description: “I was in Milwaukee this week at the IIA Regional Conference when Heidi asked me about calculating a loan payment for a loan, with variable interest rates.” Understanding that “PMT” makes this easy for a fixed rate, in today&r...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Where's The Spreadsheet?": Podcast #1437 Updated: 2011-09-29 15:16:00 Description: Today, Episode #1437′s title should be, “Learn Excel Mystery Theater at Hartville Hardware: Where is the Spreadsheet?“ “My friend Lyn opened his spreadsheet and he can’t see anything! What a mystery. Things show up in th...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Access Format": Podcast #1436 Updated: 2011-09-28 13:46:00 Description: Do you need to format your Excel Data Set -which has previously been prepared as a printed report- so that it is now capable of being imported into Microsoft Access or an other Database software? Today, in Episode #1436, Bill shows us how to accompli...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Pivot Table Delta": Podcast #1435 Updated: 2011-09-27 19:29:50 Description: Viabahv asks how to replace the grand total column in a Pivot Table with a Delta Column. Bill re-introduces us to the oft hated Calulated Item feature to solve this problem today, in Episode #1435. For more information on 'Pivot Table Tricks', U...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Count by Quarter Hour": Podcast #1434 Updated: 2011-09-26 18:12:04 Description: In today’s Dueling Podcast, Episode #1434, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen are asked to work with a Spreadsheet with data that summarizes a list of call times… The objective, in using the Data, i...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Remove Duplicates": Podcast #1433 Updated: 2011-09-26 17:49:43 Description: John is looking for some VBA to find and remove duplicate records in a database of 169,000 records. Today, in Episode #1433, Bill shows us how its done with an inherent feature of Excel 2007 / 2010 that takes only a few simple clicks! …This bl...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Hosted PowerPivot": Podcast #1432 Updated: 2011-09-26 17:45:53 Description: Excel 2010 introduces the ability to put your worksheets on the web. Excel 2010 introduced PowerPivot. Unortunately, you could never get your PowerPivot worksheets on the web. Finally, Rob Collie and the team at HostedPowerPivot.com have solved the i...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Numbers to Words in Excel": Podcast #1431 Updated: 2011-09-26 17:29:37 Description: Today, Denver asks how to convert a number in Excel to words such as “three thousand four hundred sixty five dollars and thirty two cents”. In Episode #1431, Bill shows us a cool knowledge base article with the answer to solve this issue....more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Waterfall Charts in Excel": Podcast #1430 Updated: 2011-09-21 16:53:00 Description: A write-in to Bill “MrExcel” Jelen today to ask about methods to create a Waterfall Chart in Excel, without the aid of an Excel Add-in. In Episode #1430, Bill shows us how to accomplish the task without the use of an Excel Add-in. &hellip...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Collapse with a Formula": Podcast #1429 Updated: 2011-09-20 14:40:00 Description: Today’s Dueling Excel looks at what the I.T. Department is sending down. It’s an ugly report, each day, and we want to collapse multiple lines – for each person – into a single line. But it is more complicated than that; we ha...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Rolling Date Data Validation": Podcast #1428 Updated: 2011-09-19 14:41:55 Description: Today’s ‘Learn Excel from MrExcel’ Podcast is focused on some work provided by ‘Dave’ from Boca Raton Fire Dept. Dave sends us this tip: ”Use a Formula to create a Rolling Date Data Validation.” The Dat...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "The Read Aloud Method": Podcast #1427 Updated: 2011-09-15 14:50:00 Description: Today, in Episode #1427, Bill shares an interesting way to find totals in Excel … the Read Aloud Method! This episode is another in our series for the forthcoming book, ”Don’t Fear the Spreadsheet” by Tyler Nash and Bil...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Dynamic Chart Labels": Podcast #1426 Updated: 2011-09-15 14:35:25 Description: Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND “Making Excel Columns Wider” using Gap Width. …This blog is the video podca...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "More Chart Titles": Podcast #1425 Updated: 2011-09-13 12:40:31 Description: Today, in Episode #1425, Bill takes another look at Chart Titles, how to make them Dynamic and using the TODAY() and TEXT() Functions in order to add a date to a Dynamic Chart Title. This blog is / video podcast is brought to you by the book, Le...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Price Beneath Lookup Value": Podcast #1424 Updated: 2011-09-12 18:54:51 Description: Today’s Dueling Excel features a question from a YouTube viewer, who asks: “”How can I be sure that a price value entered into my spreadsheet is actually less than the upper limit in my lookup table. In Episode #1424, Bill “Mr...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "COUNTIF 2 Conditions in Excel 2003": Podcast #1423 Updated: 2011-09-09 14:41:19 Description: Today’s question from Teresa takes us back to Excel 2003. Teresa asks how to do a COUNTIF with 2 conditions in Excel 2003. Today, in Episode #1423, Bill attempts to provide an easy explanation of how SUMPRODUCT actually works. This blog is / vi...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Craziest Excel Question Ever?": Podcast #1422 Updated: 2011-09-08 12:43:10 Description: Today in Episode #1422, a call to Excel-lers! What is the craziest newbie Excel question you’ve ever heard – or asked!? Watch today’s podcast and then send in your questions for a chance to win a prize. …This blog is the vide...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Previous Work Day?" Podcast #1421 Updated: 2011-09-07 14:24:00 Description: Today, in Episode #1421, Bill shows us how to calculate the previous work day – particularly when that previous day is a holiday. Learn how to work with the =WORKDAY Function, Holidays, Weekends, a few Excel Shortcuts and More when calculating ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - "Get Matching Records": Podcast #1420 Updated: 2011-09-06 13:28:51 Description: Today, with “Learn Excel from MrExcel” Episode #1420, Bill “MrExcel” Jelen and Mike “ExcelisFun” Girvin create methods to search for and match records in a Workbook. Learn inherent functions of Excel as well as Cus...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Month Chart Labels": Podcast #1419 Updated: 2011-09-02 14:37:18 Description: Ricardo has a chart and wants to show the monthly label for every third month. This leaves a big gap at the end. Today, in Episode #1419, Bill shows us a workaround solution for this problem. …This blog is the video podcast companion to the bo...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Unwinding Array": Podcast #1418 Updated: 2011-09-01 12:43:14 Description: A VLOOKUP to convert State Codes to State Names all in an Array Formula – and no backward compatibility! Today, in Episode #1418, Bill shows us how to get back to the Range and get this issue fixed along with a brief, but informative look at a ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Dynamic Pictures": Podcast #1417 Updated: 2011-08-31 16:19:32 Description: Last week, in Episode #1411, Bill showed us how to use Pivot Table Slicers to display images. Today, in Episode #1417, Bill shows us how to set up the Dynamic Images in Excel Using Paste Picture Link with an OFFSET named range [to dynamically change ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Jeff's Slicer Trick": Podcast #1416 Updated: 2011-08-30 21:44:00 Description: Last week, in Episode #1411, Bill Challenged the audience to figure out how he was using the Pivot Table Slicer to update images in the Workbook he was using in the broadcast. Today, the question is answered and explained. Follow along with the Learn...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - "Sum Red": Podcast #1415 Updated: 2011-08-29 13:51:31 Description: As some of you know, Bill Jelen conducts ‘Learn Excel’ Webcasts for CFO Magazine. During a recent CFO Magazine webcast, Bill performed a Filter/Sort by color trick. Adam – one of the Webcast Audience members – liked the concep...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel 2010 - 'August' from 8/25/2011: Podcast #1414 Updated: 2011-08-26 13:10:23 Description: Today, Nick asks how to get the word ‘August’ in cell B1 from a date in cell A1. In Episode #1414, Bill shows us how to convert a date to a month name or to a weekday name using the TEXT function. …This blog is the video podcast co...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "4-Way Lookup" Podcast #1413 Updated: 2011-08-25 14:00:11 Description: Shawn has to do a four-way lookup: Worksheet, Row, Set of Columns, Column within the Set. To get the correct LOOKUP result, Bill shows a method using INDEX and INDIRECT to solve the problem posed in Episode #1413. …This blog is the video podca...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "Looks Like a Date, Coincidentally": Podcast #1412 Updated: 2011-08-24 13:06:00 Description: David sends in today’s question… David gets data from SAP that he loads into Excel. Some part numbers in the import data just happen to look like dates and end up being converted to dates by Excel. Today, in Episode #1412, Bill dis...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel: "Back" Podcast #1411 Updated: 2011-08-23 14:42:00 Description: Bill has returned from a long and productive writing hiatus with a new book, one less car, and a good story to tell. So today, in Episode #1411, Bill offers an opportunity… how is he using that Pivot Table Slicer to show pictures on a screen??...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Hiatus: Podcast #1410 Updated: 2011-05-23 15:22:00 Description: Today's podcast, Episode #1410, a direct message to all of our viewers, straight from Bill Jelen to you. "I have some writing to get done, so I won't be in the office again until July 11, 2011. The podcast is going on hiatus until then." - Bill...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - Chart Titles: Podcast #1409 Updated: 2011-05-20 13:54:23 Description: Finishing off the 'Learn Excel with MrExcel Podcast Series' on Charting Basics this week, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen look at The Title of the Chart we've created. Today, in Episode #1409, Bill shows us h...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Chart Title, Legend, Colors: Podcast #1408 Updated: 2011-05-19 09:58:50 Description: The Basics of Excel Charting: Part IV This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we'd set up our Data Set, Created our Chart and made adjustments to our Chart Axis. Today, in Epis...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Change The Chart Scale: Podcast #1407 Updated: 2011-05-18 14:38:22 Description: The Basics of Excel Charting: Part III This is the third of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously, we'd set up our Data Set and proceeded into Creating our Chart; today we will look at changing ou...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Create The Chart: Podcast #1406 Updated: 2011-05-17 13:01:04 Description: The Basics of Excel Charting: Part II This is the second of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Yesterday, we set up our Data Set to be used for the Chart. Today, in Episode #1406, Bill begins creating the...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Set Up Data for Charting: Podcast #1405 Updated: 2011-05-16 13:58:00 Description: The Basics of Excel Charting: Part I This is the first of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Today, in Episode #1405, Bill will begin by showing us the criteria for the Data Set we want to create our...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - Percent of Parent: Podcast #1404 Updated: 2011-05-13 14:06:00 Description: Another Dueling Excel Podcast with Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen. Today, in Episode #1404, Mike and Bill look at finding the Percent of the Parent Row Total in Excel 2003, Excel 2007 and Excel 2010 using Fo...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Azure Data Marketplace: Podcast #1403 Updated: 2011-05-12 13:53:44 Description: The May 2011 MrExcel Challenge of the Month invites you to mash up some data from the Azure Data Market. This episode of the MrExcel Podcast demos getting data from ADM. …This blog is the video podcast companion to the book, Learn Excel 97-200...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - "SUMIF Explained": Podcast #1402 Updated: 2011-05-11 15:12:27 Description: Today, in Episode #1402, Bill takes a look at Calculating a Weighted Average using two (2) SUMIF Functions. This Formula will need to reference Data on another worksheet as well. Learn about "SUMIF"! …This blog is the video podcast compan...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Change-Pro for Excel: Podcast #1400 Updated: 2011-05-10 09:37:40 Description: Today, In Episode #1400, Bill reviews "Change-Pro for Excel", by Litéra. This high-end tool will locate all of the changes between two versions of the same workbook. Follow along with Bill to see it work! …This blog is the video podcast...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - A Better Lotto: Podcast #1401 Updated: 2011-05-10 09:07:14 Description: Warren from Australia writes about choosing Lotto numbers, but =RANDBETWEEN(1,45) is giving him duplicates. Today, in Episode #1401, Bill shows us another way to solve the problem and further eliminate the probability of duplicates. …This blog...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - Top 2 Part II: Podcast #1399 Updated: 2011-05-06 04:41:00 Description: In Part I of "Top 2 by Industry", Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen showed us how to get the result. Today, in Episode #1399, Mike and Bill revisit the Top 2 method to compare formula method...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Dynamic Chart Date: Podcast #1398 Updated: 2011-05-05 10:35:05 Description: Want to let others know that your Chart Data is current? Add a Live Title to that Chart to show that the Chart represents Data through the current date. In Episode #1398, Bill shows us how this is accomplished. …This blog is the video pod...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Column wider: Podcast #1397 Updated: 2011-05-04 12:43:00 Description: Most people know how to make a column wider...simple, right? Ok, so what happens when someone has turned off column headers? What can I do then? Today, in Episode #1397, Bill shows us what to do while discussing a variety of column width adjustment m...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - VLOOKUP Total: Podcast #1396 Updated: 2011-05-03 11:26:42 Description: The question many of us Excel users have asked at one time or another: "Why won't VLOOKUP add up all the matching results?" And the answer is simple: "Because it isn't supposed to." Today, Episode #1396 will show us how to use the SUMIF fun...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - XLYourFinances.com: Podcast #1395 Updated: 2011-05-02 09:12:00 Description: Brad H wrote in to say that he has developed a cool application in Excel for tracking your finances. My first question to Brad: "Why would you do this, when Quicken or Mint already does this so well?" The answer is that some people are more comfortab...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - Top 2 by Industry: Podcast #1394 Updated: 2011-05-02 09:05:00 Description: Alex asks how to identify the top 2 amounts by industry. Today, in Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen show us how its done. Dueling Excel Podcast #77…This episode is the video podcast compa...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Column Width and Row Height: Podcast #1393 Updated: 2011-04-28 11:25:19 Description: Today, Wayne from Kentucky points out that you can quickly adjust Column Widths using the Paste Special Column Widths tool. He laments that there is not a similar tool for copying Row Heights. In Episode #1393, Bill shows us how to copy Row...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Format Cells after Edit: Podcast #1392 Updated: 2011-04-27 09:20:45 Description: Today we look at changing font color automatically after editing a cell. We know that we could use F4, the Format Painter or a Excel VBA [Visual Basic for Applications] Macro - Using Excel VBA create a macro to add a red font color automatically...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - The MrExcel Message Board: Podcast #1391 Updated: 2011-04-26 08:25:00 Description: Mrs. Schleuter's seventh grade computer apps class wanted to figure out how many columns there are between A and XFD. In an effort to find the answer and to introduce her students to the Best Excel Resource available, Mrs. Schleuter went to the ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel with Max -(minus) Min in a Pivot Table: Podcast #1390 Updated: 2011-04-25 10:26:00 Description: Kelly wants to display a Range in a Pivot Table. Unfortunately, Calculated Fields in a Pivot Table look at each individual row, so the MAX(B2)-MIN(B2) will always be zero. PowerPivot and the DAX Measure come to the rescue here and in Episode #1390, B...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Dueling Excel - Add A Hyperlinked TOC: Podcast #1389 Updated: 2011-04-22 10:20:00 Description: Dueling Excel #76 looks at Creating a Table of Contents for your workbook. Hyperlinks that work within the confines of your workbook allowing you to navigate throughout. Today, in Episode #1389, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen show ...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - Project Due?: Podcast #1388 Updated: 2011-04-21 10:47:00 Description: Today's Learn Excel from MrExcel Podcast, Episode #1388, comes from contacts on Facebook: "If a formula is checking to see if a date is today, and you have to add a second condition, use the AND function"...Also...another way to select a hyperli...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - It's 6 O'clock Somewhere: Podcast #1387 Updated: 2011-04-20 09:43:55 Description: Today, in Episode #1387, Bill H. asks, "How do I change a date/time field from midnight to 6PM?" Since Microsoft Excel stores time values as a Fractional portion of a day [where a day is = to 1], MrExcel shows us how to change our time values using P...more... LISTEN NOW | VIEW CACHE | DOWNLOAD Learn Excel - VBA Picture Comments: Podcast #1386 Updated: 2011-04-19 09:53:10 Description: One of the old tricks in Microsoft Excel is adding a pop-up picture to a cell. I showed this a long time ago on an episode of TechTV. The VBA code that I used back in Excel 2003 to add the pop-up pictures is no longer working in Excel 2010. Today, wi...more... LISTEN NOW | VIEW CACHE | DOWNLOAD |
|
|||||
