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.
Learn Excel Episode 296: Web Query
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.
Learn Excel Episode 294: Pivot Charts
Instead of creating Pivot Tables, create your summary as a flexible chart. Episode 294 shows you how to create a pivot chart.
Learn Excel Episode 293: Calculated Items
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.
Learn Excel Episode 300: Data Form
Create a simple data form to help when entering data. Episode 300 shows you how.
Learn Excel Episode 299: Replace Malfunction
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.
Learn Excel Episode 298: Fresh WebData
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.
Learn Excel Episode 297: Web Options
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.
PS Quicktips Episode 41: High Pass Glow
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…
Ruby Plus #53: Keyword Arguments and Ruby
In this screencast you will learn how to simulate keyword arguments in Ruby and the advantages of using keyword arguments