Recently Posted Videos
Pivot Tables look horrible when you try to add two fields to the pivot table data area. Episode 280 will show you the four different ways to display pivot tables with two data fields.
Yes - you can have multiple fields in the data area of a pivot table - fields like quantity, revenue, and cost. There are some subtle changes to moving fields, removing fields, and sequencing fields. Episode 279 will show you how.
All of the pivot tables lately have been showing the total of the data fields. It is easy to show Min, Max, Average, Count, Standard Deviation or Variance - anything except Median. Episode 278 will show you how to create a pivot table with averages.
In this episode we take a look at how to create a very nice silky smooth skintone effect on your digital portraits. This is very popular in commercial photography and is actually very easy once you learn the techniques. With a little practice you'll be on your way to re-touching like a pro!
In this screencast you will learn about Sake and how to use it in Rails projects. Sake allows you to install rake tasks once and use it across all Rails projects.
Adding a vignettes to photographs is becoming a very popular technique with digital photographers today. Essentially adding a vignette is just adding a gradual shading to the outer portions of your photo. In this episode of Quicktips I take you through my way of adding a "flexible" vignette to your digital photographs.
Skip the whole wizard and create a pivot table in just a few clicks. Episode 277 shows you how.
There are many difficult methods for producing a list of the unique values in a list. Episode 276 will show you the wickedly easy way to get the unique list of customers in 3 clicks.
Use Page Fields in a pivot table to create an ad-hoc reporting tool. Episode 275 shows you how.
What if you need to produce a report for each region or each customer? Pivot Tables can help. Episode 274 shows you how.