Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Jeff from Akron asks how to create a column chart where two series are stacked, but a third series is clustered. Episode 1091 shows you how.
Labels: charting
posted by Bill at 9:00 AM
In today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090 .
Labels: Advanced Filter, Filter, formula, ISNUMBER, lookup
posted by Bill at 9:00 AM
It became harder to exit Excel starting in Excel 2007. Episode 1089 takes a look at how to exit Excel 2010.
Labels: 2010
posted by Bill at 9:00 AM
Excel 2010 adds some new picture tools. Episode 1088 shows off some of the cool tricks in Excel 2010.
posted by Bill at 9:00 AM
New in Excel 2010, stolen from OneNote 2007 - the ability to insert a screen clipping into your worksheet. Episode 1087 shows you the two ways to use this new functionality.
posted by Bill at 9:00 AM
More tricks with the Paste Options menu, this time with Live Preview. Episode 1086 shows you how.
Labels: 2010, Paste Special
posted by Bill at 9:00 AM
Mike and Bill offer five different way to solve a simple bonus calculation. Episode 1085 shows you how.
Labels: formula
posted by Bill at 9:00 AM
Jamie from the UK sends in yet another formula to solve the Last Match formula from Episode 1073. Episode 1084 shows you how.
Labels: array formula, CSE, formula
posted by Bill at 9:00 AM
Daniel from Quebec sends in a wild formula to solve the Last Match problem from Episode 1073. We'll look at using Evaluate Formula to study how the LOOKUP value actually works. Episode 1083 shows you how.
posted by Bill at 9:00 AM
Shaun asks how he can link values in one worksheet to a lookup table in an external workbook. Episode 1082 will show you how.
posted by Bill at 9:00 AM
Paul writes in with today's question. Is it possible to keep Excel 2003 and also install Excel 2007 on the same computer? In Episode 1081, I discuss this issue and show a cool way to export a chart as a graphic.
Labels: 2007
posted by Bill at 9:00 AM
Excel 2010 offers 56 new functions. In this dueling podcast Episode 1080, we take a look at some of those functions.
Labels: 2010
posted by Bill at 9:00 AM
Another improvement in Excel 2010 is in the pivot table calculation options. You can now calculate the rank of an item, or the % of the parent row! Episode 1079 shows you how.
Labels: 2010, Pivot Table
posted by Bill at 9:00 AM
Excel 2010 finally gives you an option to fill in the blank spots in the outermost row fields. Episode 1078 shows you how.
Labels: 2010, Pivot Table
posted by Bill at 9:00 AM
Office 2010 finally allows you to customize the ribbon. Episode 1077 shows you how.
posted by Bill at 9:00 AM
More features from the Excel 2010 technical preview: The Excel 2010 Backstage view replaced the old Office Icon for all of the things that you do to a document. Episode 1076 shows you how.
Labels: 2010
posted by Bill at 9:00 AM
Manfred from Germany has an interesting problem. Each record takes up six rows in his spreadsheet. Formulas need to point to the first row of the company. Those formulas need to be copyable. But those formulas are in conditonal formatting rules. Episode 1075 tries to solve this problem.
Labels: conditional formatting
posted by Bill at 9:00 AM
LearnAccessByCrystal sends in a cool tip that will allow you to format dates to show quarters, weeks, and more. Episode 1074 shows you how.
posted by Bill at 9:00 AM
Sarah from the cattle farm in the UK writes in again with an insanely difficult question. Do a VLOOKUP, but find the last previous entry that matches the vehicle. Episode 1073 shows you a formula from Excel Gurus Gone Wild to solve this problem.
Labels: array formula, MATCH, VLOOKUP
posted by Bill at 9:00 AM
Uma wants to create many worksheets in a new workbook that are named after values in range B2:B20. Episode 1072 shows a VBA macro that makes all of this possible.
posted by Bill at 9:00 AM
Terry from Springfield, MO asks about a quicker, one-click way to change the Move Selection After Enter direction. Episode 1071 show you how to solve this problem by recording a couple of quick macros.
posted by Bill at 9:00 AM
