| Learn Excel 2010 - "Remove Hidden Columns": Podcast #1539
Your workbook started off with hidden columns...but you got it back, the columns are no longer hidden and... |
| Learn Excel 2010 - "Conditional Diagonal Borders": Podcast #1538
From Jumping Bean on YouTube, the question: "How can I apply Conditional Formatting to Double the Diagonal... |
| TimeWarp with Bill Jelen: "From 1979 - VisiCalc and LOOKUP!" #1537
You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back... |
| Dueling Excel - "ALmost Live looks for Unfinished Projects": Podcast #1536
MZI1A at YouTube has a column of completed projects; she also needs to show a column of projects that are... |
| Learn Excel 2010 - "Consolidate and Lookup": Podcast #1535
Bill brings us another use of VLOOKUP combined with the 'Consolidate Function' in Episode #1535 of the 'Learn... |
| Learn Excel 2010 - "Compare 2 Lists": Podcast #1534
In the spirit of "VLOOKUP WEEK 2012" [march 25th - March 31st, 2012], Bill centers on VLookup again today. In... |
| Learn Excel - "VLookup in Plain English": Podcast #1533
Bill starts from the beginning; why to use a VLOOKUP, when to use a VLOOKUP and how to Use a VLOOKUP. If you... |
| Dueling Excel - "Remove Duplicates If...": Podcast #1532
Today, in yet another ‘Almost Live’ Dueling Excel with Mike... |
| Learn Excel 2010 - "Random Chooser":Podcast #1531
MS Access MVP Crystal Long has a Random name selection workbook that was originally developed in MS Access.... |
| Learn Excel 2010 - "Sort by Substring": Podcast #1530
Danny wants to enter a value and have all of the like values sort to the top of the list.One way to do this... |
| Learn Excel 2010 - "DAX Calculate": Podcast #1529
Today's Learn Excel from MrExcel Podcast is Part 2 of the "Percent of Production" Podcast [Episode #1528]... |
| Learn Excel 2010 - "Percent of Production-Part I": Podcast #1528
We are looking for the amount of scrap compared to good units - but as a percentage of production and not... |
| Dueling Podcast - "Extract Values from a Text & Value Mix": Podcast #1527
Bill has decided that Mike is going to do all of the work today. In 'Almost Live' Episode #1527, Mike... |
| Learn Excel 2010 - "Excel on iPad": Podcast #1526
Hold on to your seat… today Bill shows us how to not only view workbooks on the iPad, but also how... |
| Dueling Excel - "100th Episode!": Podcast #1525
It’s Duel 100 with Mike “ExcelisFun” Girvin and Bill... |
| Dueling Excel - "Record Fill Down- Part Due(l)x:"Podcast #1524
Always love this time of year – when Microsoft is hosting the MVP Summit –... |
| Learn Excel 2010 - "Comparative Histogram Part II": Podcast #1523
In Episode #1522, Bill showed us how to set up a Comparative Histogram Chart. Today, in Episode #1523, Bill... |
| Learn Excel 2010 - "Comparative Histogram": Podcast #1522
JB asks, "How can I create a Comparative Histogram?" Today, in Episode #1522, Bill shows us how to set up our... |
| Learn Excel 2010 - "Paste Values with VBA": Podcast #1521
Bill looks at pasting Values today, in Episode #1521. Using one line of VBA code, Bill shows us how to... |
| Learn Excel 2010 - "Separate Dates from Text": Podcast #1520
Today's episode is a reversal of Episode #1517 [click link to view]. In Episode #1520, Bill looks at... |
| Learn Excel 2010 - "Record Fill Down": Podcast #1519
Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It... |
| Learn Excel 2010 - "MAXIF": Podcast #1518
With a list of Products and a list of Dates, Bill's mission is to find the last order date for each product... |
| Learn Excel 2010 - "Words With Dates": Podcast #1517
From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along... |
| Dueling Excel - "Any of These in Those?": Podcast #1516
Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures... |
| 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'... |
| Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514
VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the... |
| Dueling Excel - "Total All Lookups": Podcast #1513
Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell... |
| Learn Excel 2010 - " Move Entire Rows ": Podcast #1512
Charlie -who admits he is relatively new to Microsoft Excel- needs to rearrange the rows of his... |
| Learn Excel 2010 - "Chart An Extra Series": Podcast #1510
Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard... |
| Dueling Excel - "Conditional Format +/- 15%": Podcast #1509
Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by... |
| Learn Excel 2010 - "Count Between A Range": Podcast #1508
The Question: "I have a =COUNTIF to count values less than 10 and another to count values less than 20; but... |
| Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507
Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean... |
| Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506
Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General... |
| Learn Excel 2010 - "Next Invoice Number": Podcast #1505
The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of... |
| Learn Excel 2010 - "Saving Form to Database": Podcast #1504
John from New Zealand offers an improvement to Thursday's podcast about creating a Data Entry form on a... |
| Learn Excel 2010 - "Saving Form to Database": Podcast #1503
Today, Bill shows off some of the truly dynamic functionability of Microsoft Excel. Oz wants to use a... |
| Learn Excel 2010 - "Running Total AutoFill": Podcast #1502
Mally wants a simple Spreadsheet - Two (2) Columns; she asks how to enter a Value in Column A and have the... |
| 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... |
| Learn Excel 2010 - "Filter to Unique?": Podcast #1500
Today's question... can you use the AutoFilter dropdowns to filter to one row per unique customers? For a... |
|
I'm sure [like myself] that some viewers will be somewhat confused when viewing... |
|
Today, Amelie asks how to add Two sets of Subtotals, with the Subtotals appearing at the top! In Episode... |
|
Episodes #1488 and #1489 of the "Learn Excel from MrExcel Podcasts" generated a lot of email from viewers.... |
|
Episodes #1488 and #1489 of the "Learn Excel from MrExcel Podcasts" generated a lot of email from viewers.... |
|
Today, Bill offers a quick tip on getting acclimated to your new iPad! Check out QUE Publishing.... |
|
MrExcel on Word for The Holidays!?
Running short of gift tag labels? They are available for Free, inside... |
|
A small company has decided to start doing Random Drug Testing. They want to randomly select two... |
|
Today, in Episode #1493, Mike from Athens, Greece asks how to create a control that would change a chart to... |
|
A small company has decided to start doing Random Drug Testing. They want to randomly select two... |
|
Today's Dueling Excel comes from France... Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen are looking for... |
|
All this week, Bill has been dealing with a Workbook with 31 sheets - one Worksheet per day. Today, in... |
RSS Feeds |
Contact Us
Subscribe to this show
Claim this show…
