Videos in category Companies
For every accountant who has ever tried to produce a Profit & Loss report using the page setup headers, you probably wondered why you always needed to spell out the word "and". Episode 255 reveals the secret to using an ampersand in the custom header.
Time to raise everyone's rates by 2%. An obscure feature in the Paste Special dialog lets us do that with ease. Episode 253 shows you this trick and more.
Using the replace dialog gets tricky when you need to remove just an asterisk or a question mark. Reporting from the New York City Public Library, Bill reveals the problem and the completely intuitive work-around in Episode 254.
In this episode we will walk you though the the various ways to perform subselects with Linq2Sql. We will also take a look at the SQL that is generated. We will be doing all of our coding in this episode in LinqPad.
In today's dataset, someone tried to make a report look nice by putting the customer number and customer name only once for every group of records. This looks fine, but it is impossible to use in any sort of data analysis. Episode 262 will show you the formulas you can use to copy the customer information down to new columns.
Today, we deal with the most annoying dataset - each logical record is spread out over more than one physical row. It is impossible to analyze this data unless you transform it into one row per record. In Episode 261, Bill shows you how to solve this problem.
In today's podcast, you want to assign all of the same customers an identical group number. Episode 260 shows you how. This technique, as well as the one from podcast 259 will be put together to solve a bigger problem in episode 261.
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.