|
Friday, March 2, 2012
Always love this time of year – when Microsoft is hosting the MVP Summit – because it means that Bill “Mr..
Download
|
|
|
|
Wednesday, February 29, 2012
In Episode #1522, Bill showed us how to set up a Comparative Histogram Chart. Today, in Episode #1523, Bill shows us alternative..
Download
|
|
|
|
Monday, February 27, 2012
JB asks, "How can I create a Comparative Histogram?" Today, in Episode #1522, Bill shows us how to set up our Data, create Data ..
Download
|
|
|
|
Saturday, February 25, 2012
Bill looks at pasting Values today, in Episode #1521. Using one line of VBA code, Bill shows us how to convert Formulas to Value..
Download
|
|
|
|
Thursday, February 23, 2012
Today's episode is a reversal of Episode #1517 [click link to view]. In Episode #1520, Bill looks at two ways to solve the ..
Download
|
|
|
|
Thursday, February 23, 2012
Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It isn’t as str..
Download
|
|
|
|
Tuesday, February 21, 2012
With a list of Products and a list of Dates, Bill's mission is to find the last order date for each product in the Dataset.Learn..
Download
|
|
|
|
Tuesday, February 21, 2012
From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to ..
Download
|
|
|
|
Friday, February 17, 2012
Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures exist in both column..
Download
|
|
|
|
Saturday, February 11, 2012
Today in Episode #1515 we have a series of Dates. We want to show quarters for the year 2012. Bill 'MrExcel' Jelen goes Old Scho..
Download
|
|
|
|
Wednesday, February 1, 2012
VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the entry and 'Stop Speakin..
Download
|
|
|
|
Saturday, January 28, 2012
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..
Download
|
|
|
|
Saturday, January 28, 2012
Charlie -who admits he is relatively new to Microsoft Excel- needs to rearrange the rows of his spreadsheet. Today, in Epi..
Download
|
|
|
|
Tuesday, January 24, 2012
Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the C..
Download
|
|
|
|
Sunday, January 22, 2012
Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by 15%"
Initially, it appears that ..
Download
|
|