|
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
|
|
|
|
Friday, January 20, 2012
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 v..
Download
|
|
|
|
Saturday, January 14, 2012
Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Dev..
Download
|
|
|
|
Wednesday, January 11, 2012
Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are c..
Download
|
|
|
|
Wednesday, January 11, 2012
The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. H..
Download
|
|
|
|
Monday, January 9, 2012
John from New Zealand offers an improvement to Thursday's podcast about creating a Data Entry form on a spreadsheet. Today, in E..
Download
|
|
|
|
Thursday, January 5, 2012
Today, Bill shows off some of the truly dynamic functionability of Microsoft Excel. Oz wants to use a worksheet as a data entry ..
Download
|
|
|
|
Thursday, January 5, 2012
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..
Download
|
|
|
|
Tuesday, January 3, 2012
"I am going out on a limb to predict that the four-point shot will lead to an accidental Washington Generals win this season", B..
Download
|
|
|
|
Friday, December 30, 2011
Today's question... can you use the AutoFilter dropdowns to filter to one row per unique customers? For a solution to this, you ..
Download
|
|