Learn Excel from Bill Jelen with this daily 2 minute video podcast.
David asks why his total formulas are getting #VALUE errors. Episode 1112 shows this common problem and a solution.
Labels: formulas
posted by Bill at 9:00 AM
Priscilla from Plano Texas offers up yet another way to have the Fill Handle automatically extend 1 to 1, 2, 3. Episode 1111 shows you how.
Labels: shortcuts
posted by Bill at 9:00 AM
Erik has a combination lock and has forgotten the combination. He wonders how many possible combinations there are for the lock. Episode 1110 suggests some solutions.
posted by Bill at 9:00 AM
BackIn2Shape at YouTube has two worksheets; one of customers, and one of prospects. If a prospect is on the customer list, he would like to delete it. Episode 1109 show you how.
posted by Bill at 9:00 AM
John asks if there is a way to automate the process from Episode 322 of adding pop-up pictures to a cell. Today's Episode 1108 takes a look at the VBA code to add pop-up pictures to many cells.
posted by Bill at 9:00 AM
John asks how to take 10 years worth of stock data and convert it to a chart showing months across the bottom and a different line for each year. Episode 1107 shows you how.
Labels: charts, Pivot Table, stock
posted by Bill at 9:00 AM
David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 shows you how.
posted by Bill at 9:00 AM
Fabien sends in an intriguing pivot table question. I show one mildly acceptable way to solve the problem using the existing data and then a way to spin the data to make the problem easier to solve. Episode 1105 shows you how.
Labels: Pivot Table
posted by Bill at 9:00 AM
|
0 comments
In this Dueling Excel podcast, how to find the earliest date for records that match two criteria. Episode 1104 shows you how.
Labels: array formula, AutoFilter, Filter
posted by Bill at 9:00 AM
Sam from Vienna sends in today's question. In a database of events, how can he add new blank rows to represent every missing day? Episode 1103 shows you one method.
posted by Bill at 9:00 AM
Dak asks how to take a long cell entry and to split it into 20 character entries going down a column without using wrap text. Episode 1102 shows a couple of ways to solve the problem.
Labels: array formula, formula, MID
posted by Bill at 9:00 AM
Gary, Jamie, Monish and Michael all check in with ideas on why to use the Split command. Episode 1101 is a follow up to last Wednesday's podcast 1098.
Labels: Split
posted by Bill at 9:30 AM
DRG asks how to use COUNTIF to find records that match a range. Unfortunately, it can not be done with COUNTIF. In Episode 1100, Bill and Mike compare six solutions.
posted by Bill at 9:00 AM
It is Friday, September 11, 2009. We are holding our 1000th podcast episode until Monday September 14.
posted by Bill at 9:00 AM
Pablo sends in a cool tip for using Spearing Formulas. Episode 1099 shows you how.
Labels: formulas, summary worksheet
posted by Bill at 9:00 AM
What the heck is the SPLIT command for? Episode 1098 wonders about this.
Labels: Excel 2007
posted by Bill at 9:00 AM
Shift-Del sends in some alternative formulas to solve the problem from episode 1043. To see uses of SUBSTITUTE and REPLACE in Excel, check out Episode 1097.
Labels: formula, MID, replace, RIGHT, SUBSTITUTE
posted by Bill at 9:00 AM
Your recorded macros might not work if someone renames a worksheet. Rather than use the worksheet name, use the code name for the worksheet. This name can never be changed and is more reliable. Episode 1096 shows you how.
posted by Bill at 9:00 AM
|
2 comments
Mike and Bill offer different ways of generating a random date between two dates. Episode 1095 shows you how.
Labels: DATE, dates, INDEX, RandBetween
posted by Bill at 9:00 AM
Excel 2007 offers a cool trick to replace Freeze Panes. Episode 1094 shows you how.
Labels: Excel 2007, Freeze Panes, Table
posted by Bill at 9:00 AM
Mike from Arizona asks how to create a revenue bridge chart. This is similar to a waterfall chart, except some of the points are negative. Episode 1093 will show you how to create this chart.
Labels: charting
posted by Bill at 9:00 AM
Craig added an arrow to a line chart. Every time the data changes, the arrow needs to be repositioned. Episode 1092 shows how to add a dynamic XY series to redraw the arrow.
Labels: charting
posted by Bill at 9:00 AM
