Videos in category Companies

Dan from Akron notes that when he inserts new columns in Excel, Excel is automatically extending the size of any charts that happen to span the new column. With most objects, you can right-click and indicate that you don’t want to move or size with cells. However, charts don’t seem to have the ability to change the resizing options. Episode 456 will show you the bizarre solution.

Joe writes in with a question of how to subtract the most second most recent price in the row from the most recent price. The solution involves the relatively obscure OFFSET function. Episode 455 shows you how.

Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast. Episode 454 shows you how.

After Scott’s question for tomorrow’s podcast, I thought it would be cool to see how a pivot table could analyze the most popular lottery numbers. The MegaMillions jackpot in several US states is up to $216 million and today’s podcast will select the most popular numbers. Episode 453 shows you how.

Rupal asks how to return the worksheet name as the result of a formula. Episode 452 shows the obscure function which can be adapted to solve this problem.

Heidi asks a question that is a new twist on an old problem – how to fill in the blank cells in a range with an outline numbering system. Episode 451 shows how to adapt the technique discussed in Learn Excel to solve this problem.

As a follow-up to yesterday’s netcast, Episode 450 shows you how to unhide column A and a cool trick left over from Lotus 1-2-3 where you can see what is in the hidden columns without unhiding them.

Stuart from the UK asks: say that you have columns B through H hidden and want to unhide only one of those columns? Episode 449 will take a look at the process of hiding and unhiding columns. Although I had never tried it before Stuart posed the question, it seems that there is a way to unhide just that one column.

Another popular way for people to lie with charts is to use a cone or pyramid chart. Episode 448 shows why your radar should go up anytime you see someone presenting data using these chart types.

Here is a bizarre problem sent in by a viewer. Many of you will think that you know the answer, but this problem is not as simple as it appears. In a worksheet, any dates are instantly converted to their 5 digit serial number. The actual date is shown in the formula bar, but the worksheet cells show the underlying serial number. Yes – my first thought was that someone had formatted the wo...