Recently Posted Videos
Another hidden option allows you to have the pivot table calculate the top 5, 10, or 12 customers. Watch Episode 273 for cool Excel Pivot Table options to produce a report of the best (or worst) customers.
The 'delete' command allows you delete information in the database. Like all the other commands you can tweak the command so as to target specific data in the database. Anyway, we will look at that a little later ...
In this screencast you will learn about define_method in Ruby and how you can use it for meta programming.
The 'update' command allows you to update records/information already in the database.
Summary Ari Zilka, co-founder and CTO of Terracotta, talks about the capabilities of Terracotta, the use cases it supports, and the rationale and impact of taking Terracotta to an open source model. Bio Ari Zilka is CTO and co-founder of Terracotta. Previously, Ari was the Chief Architect at Walmart.com, where he led the innovation and development of the company's new engineering initiatives. P...
In this screencast you will learn about the self and how to change it. This concept is used in writing DSLs in Ruby.
Rob Kaufman talks about using ActionMailer safely, how to keep out of the spam box and how to test your emails before your customers see them.
Why are pivot tables always sorted by customer alphabetically? Wouldn't it be cool if you could get the largest customers first? Learn how using the completely hidden AutoSort option in Excel Pivot Tables. Episode 272 reveals the secret.
In Excel 2003 and earlier, you only have 255 columns to work with. You quickly run into limitations when you try to build a wider pivot table. Even if you hoped to group the dates up to months (more about that on June 22), you will still need to make the field longer than wide. Episode 271 walks you through this.