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.
Learn Excel Episode 258: Citizen Aquanaut
The last trick for consolidation - how to see who appears in one of several lists. Episode 258 will show you how.
Learn Excel Episode 252: No Blanks
Two cool ways to get rid of all the blank cells in a range. Episode 252 will show you how.
Learn Excel Episode 251: WhatIf 32
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.
Learn Excel Episode 250: Average & Total
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.
Learn Excel Episode 249: Blank Row After Each Subtotal
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.
Learn Excel Episode 248: Subtotals Pop
Make your subtotals pop out at the reader. I'll use an obscure trick to format just the subtotal rows in Episode 248.
Jim Webber on "Guerilla SOA"
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...
Learn Excel Episode 247: Subtotals Times Two
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.
Learn Excel Episode 246: GPF with co-stars
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.