Learn Excel from Bill Jelen with this daily 2 minute video podcast.
How much ice cream will Sally sell on any given day? Today’s Episode 624 tries to figure out a relationship between temperature, rain and ice cream sales.
posted by Bill at 9:00 AM
Sometimes the growth in a model is not linear, but it is exponential. In those cases, Excel has forecasting tools to replace LINEST and FORECAST. Episode 623 shows you how.
posted by Bill at 9:00 AM
Rather than using FORECAST to choose the next number, you can use LINEST to generate the slope and y-intercept of a line. Today’s podcast graphs the results of LINEST so you can see how Excel is forecasting the next number in a series. Episode 622 shows you how.
posted by Bill at 9:00 AM
Today, we take a second look at Leon’s question – how to forecast the next number in a sequence of numbers. But, in Episode 621, I show you how to solve this with one cell instead of 6 cells.
posted by Bill at 9:00 AM
Leon asks how to forecast the next number in a series of numbers. In Episode 620, I will take a look at a formula solution and a faster solution.
posted by Bill at 9:00 AM
Say that you add automatic subtotals and collapse the data down to the #2 view. Is there any way to sort the largest customer to the top? Episode 619 shows you how.
posted by Bill at 9:00 AM
Mark sends in a question about why Excel underlines the entire cell for currency, but only the digits for percents. We’ll decode this problem in Episode 618.
posted by Bill at 9:00 AM
In today’s episode, I take a look at three non-macro solutions to solve Ethan’s long text problem. Episode 617 shows you Shrink to Fit, Wrap Text, and AutoFit.
posted by Bill at 9:00 AM
Ethan sends in a question about optionally allowing long cell values to spill over into the next column. Episode 616 shows you how.
posted by Bill at 9:00 AM
In today’s podcast, I address the same question from podcast 614, but assume that the dataset can not be sorted. This requires a powerful array formula to find the most recent date for each customer. Episode 615 shows you how.
posted by Bill at 9:00 AM
Alicia and George have sent in similar questions; George asks how can I filter a data set to one record per customer? Alicia had a similar question but specified that she wanted only the most recent record for each customer. If you are allowed to sort the data, Episode 614 will show you how to solve this problem.
posted by Bill at 9:00 AM
Alicha asks – how can you return many columns from a table using VLOOKUP? I have a couple of tips to make this process easier. Episode 613 shows you how.
posted by Bill at 9:00 AM
Anne sends in today’s question: How can I change the default header and footer that is used for all future workbooks? In Episode 612, I’ll show you how to change the default settings for all future workbooks.
posted by Bill at 9:00 AM
You can hide several sheets with a single command, but you have to unhide sheets one at a time. Today, using a little VBA, we turn unhiding into a single keystroke. Episode 611 shows you how.
posted by Bill at 9:00 AM
We figure out the thickness of a coat of paint, live from the site of the World’s Largest Ball of Paint.
posted by Bill at 9:00 AM
When you hide a row, Excel will remove that series from a chart. In Episode 609, I create a hideous chart, but then use an AutoFilter to create a cool ad-hoc charting tool that allows a sales manager to see results for any one sales rep.
posted by Bill at 9:00 AM
Learn how to quickly navigate worksheets. Episode 608 shows you how.
posted by Bill at 9:00 AM
My favorite Excel trick is to double-click the fill handle to copy a formula down to all of your rows of data. In Episode 607, I’ll take a look at many different details of the double-click trick.
posted by Bill at 9:00 AM
To create a true histogram from frequency information, you need to make the columns in the chart touch each other. This was difficult to do in Excel 2003 but much easier in Excel 2007. Episode 606 shows you how.
posted by Bill at 9:00 AM
Creating a Frequency Distribution with the FREQUENCY function is fairly difficult. In Episode 605, I’ll show you how to quickly produce a frequency distribution using a pivot table.
posted by Bill at 9:00 AM
Do you have a chart which is too confusing? Try replacing the one chart with four smaller charts, each chart focusing on one particular statistic. Episode 604 shows you how.
posted by Bill at 9:00 AM
Add new worksheets in seconds. Episode 603 shows you how.
posted by Bill at 9:00 AM
Rod asks how to set up a summary worksheet that will selectively point to different worksheets. The solution is the INDIRECT function in combination with some other functions. Episode 602 shows you how.
posted by Bill at 9:00 AM
