Videos in category Companies

In today's podcast, you want to assign a sequential number to each customer's invoice, but start over again at 1 when you get to the next customer. Episode 259 will show you how.

The last trick for consolidation - how to see who appears in one of several lists. Episode 258 will show you how.

Two cool ways to get rid of all the blank cells in a range. Episode 252 will show you how.

Today's podcast shows an old Lotus 1-2-3 trick that lets you perform dozens of what-if analyses in a single function. Episode 251 shows you how.

How can you insert both automatic subtotals and automatic averages on the same row? While the subtotals feature won't normally allow this, Episode 250 shows you how.

This is a really easy request, but is incredibly hard to do. Episode 249 will show you two different methods. If this is something you need to do, plan on hitting the replay button because it is by far the most complicated tip I've shown in the 249 episodes.

Make your subtotals pop out at the reader. I'll use an obscure trick to format just the subtotal rows in Episode 248.

Summary In one of the most entertaining presentations on the topic ever, Dr. Jim Webber debunks myths about the mainstream ESB concept and explains how a lightweight approach can yield real benefits without giving in to vendor pressure. Jim claims that an ESB often ends up being just a thin veneer on an existing mess, and how an approach that doesn't put intelligence into the network is superio...

When you need to subtotal by two different fields, it is important to add the subtotals in the right order. Today's episode shows what can happen if you do the subtotals in the wrong sequence. Episode 247 shows you how.

NateO and Starl join me in Toronto to discuss the age old question regarding GPF's: to send the error report or not? The camera angles were horrible today - so you hear us and see half of us on Episode 246.