0

0

We have released the 7.0.4 version of VivoSocial. This release includes the update for DNN 5.2.3 and VivoWare latest module releases. Here is a list of the latest changes:

1

1

VivoSocial has been open source for 1 month now. It has been great seeing all of the excitement and feedback from the community this past month and we have even gotten our first two code contributions. Thank you David Trumble and "wpmilk". This week we r

0

0

If you have to round 0.5 do you think it should round to 0 or 1? I bet that you learned in school that it should round to 1. However this will introduce errors. Episode 1046 talks about the errors introduced by this rounding. This blog is the video podcas

0

0

After yesterday’s podcast about ASTM E29 rounding I produce a function in VBA that will correctly do the bankers rounding algorithm in Excel. Episode 1047 shows you how. This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel

0

0

The Excel fill handle is really cool with quarters. But wait....it can not do quarters and years. But wait...it can do them but in a hideous format. Episode 1132 asks  - "Does anyone have a better way?" This blog is the video podcast companion to the book

0

0

Patricia called the other day with a problem which will be familiar to everyone who works in a public school district. The state pays the school for every student who is enrolled on the magic date of October 1. Given a start date and end date how can you

0

0

Today's Dueling Excel Podcast is a question sent in by Hassan. Hassan wants to enter a name and a through-month and then add up that person's sales from January through the selected month. Mike and Bill show various methods in Episode 1134. This blog is t

0

0

Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit so I decided to use the range version of VLOOKUP. But...as a twist I embed the table right in the formula. Episode 1135 shows you how. This

0

0

Mary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records. Episode 1136 shows you how. This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel. Download a new two minute video e

0

0

In Episode 1137 a cool way to remove all hyperlinks from a spreadsheet. This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

0

0

Rod from Cincinati asks how to solve the problem of trailing spaces in the lookup table. I had never tried it before but you can apply a TRIM to the entire lookup table. Episode 1138 shows you how. This blog is the video podcast companion to the book Lear

0

0

A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go! This blog is the video podcast companion to the book Learn Excel 97-2007 from MrExcel. Download a new two minute video every wo