Recently Posted Videos

This is a fairly wild concept. Sometimes you want to link to an external Excel file, but you run into the limit that your formula can not refer to more than 10,000 cells in the external file. As an alternative, use Microsoft Query to retrieve records from the closed Excel file. Episode 295 shows you how.

Rather than copy and paste data from your browser to Excel, set up a simple web query in Excel to automatically pull your data into Excel. Episode 296 shows you how.

Instead of creating Pivot Tables, create your summary as a flexible chart. Episode 294 shows you how to create a pivot chart.

Unlike the calculated field in yesterday's podcast, calculated items are a horrific feature that should be avoided at all costs. Episode 293 shows why this feature does not work and offers a workaround.

Create a simple data form to help when entering data. Episode 300 shows you how.

I have this data and I am trying to replace the spaces. Every time I use Edit - Replace, it tells me there are no spaces to replace. What the heck is going on? You might have run into this, if you've ever copied data from a web page. Episode 299 shows you how to deal with these. Learn the CODE, CHAR, and SUBSTITUTE functions.

Would you like to keep your web queries fresh? Pull new data from the web every minute, even updating formulas in adjacent columns. Episode 298 shows you how.

How to control the options for your web query. Keep your web data automatically updated in Excel files every time you open the Excel file. Episode 297 shows you how.

The best thing about Photoshop is that there are thousands of ways to acheive different effects. This is what makes Photoshop so much fun!In this episode of Quicktips I show you how to create a very surreal soft focus glow using a combination of blend modes and a filter that I am willing to bet most Photoshop users overlook…

In this screencast you will learn how to simulate keyword arguments in Ruby and the advantages of using keyword arguments