Recent Videos RSS
| Videos with tag Microsoft | All | Novice | Advanced | Expert |
- Video is free for view
- Video is available for download
Add to FavoritesLearn Excel Episode 1049: Tracing Error
You have a large formula which is generating an error. To find which reference in the formula is causing the problem, use the Evaluate Formula tool to step through the formula. Episode 1049 will sh... read more »
| Level: any | Jul 03, 2009 | Votes: 0 | Dmytro Shteflyuk  |
0  |
- Video is free for view
- Video is available for download
DimeCasts.Net #123: Exploring Code Co...
In this episode we are going to take a look at the new Code Contracts library which is out of MS Research and will be part of .Net 4.0/Vs2010.Contracts allow for many different ways to perform lang... read more »
| Level: novice | Jul 03, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
DimeCasts.Net #122: Creating Custom F...
In this episode we will take a look at how to create a custom function for your NAnt script.After you have the basics of NAnt down you may quickly find out that there are features you need, but the... read more »
| Level: novice | Jun 30, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
Learn Excel Episode 1048: Shift-Tab
Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit coo... read more »
| Level: any | Jul 02, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
Learn Excel Episode 1047: Rounding Co...
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. read more »
| Level: any | Jul 01, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
Learn Excel Episode 1046: ASTM E29 Ro...
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 error... read more »
| Level: any | Jun 29, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
Learn Excel Episode 1045: Dueling: Pe...
Izhak asks how to add a scrollbar to a worksheet for selecting a percentage. In this dueling Excel podcast Episode 1045, Bill and Mike will show you two ways to solve the problem. read more »
| Level: any | Jun 27, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
Learn Excel Episode 1044: Multi-Colum...
Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter. read more »
| Level: any | Jun 26, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
DimeCasts.Net #120: Learning the Deco...
In this episode we will take at how we can use the Decorator Pattern in our application.The decorator pattern is a structural pattern which allows you to attach new or additional actions to an obje... read more »
| Level: novice | Jun 23, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
- Video is free for view
- Video is available for download
DimeCasts.Net #121: Exploring how to ...
In this episode we will continue taking a look at the Spark View engine.We are going to take a look at the various different ways you can use Looping Expressions with the Spark View engine. read more »
| Level: novice | Jun 26, 2009 | Votes: 0 | Dmytro Shteflyuk |
0 |
