Videos in category Companies
Dan has an unusually wide spreadsheet where the page breaks suddenly disappear. This is a decade old problem and as soon as I heard the question, I remembered beating my head against my desk when this started happening to me back in the mid-90’s. Episode 460 will take a look at what causes the problem and how it can be solved.
How to import a delimited text file into Excel. Learn the gotchas associated with this type of file, including the annoying “feature” that gets turned on for the rest of the day after importing the text column. Episode 459 show you how.
In our continuing look at importing text files, today’s netcast discussed how to import fixed width files into Excel. Watch to learn why choosing the text column type will cause your formulas to never work. Episode 458 provides the details.
If you need to import a text file into Excel, you will need to use the text to columns wizard. Before you start importing text, you need to figure out if your dataset is fixed width or delimited. Episode 457 will explain the difference.
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.