Saturday, May 29, 2010
Friday, May 21, 2010
Advanced Microsof Office Documents 2007 Inside Out - maybe it will unravel the locked up knowledge on Themesin reference to: Advanced Microsoft® Office Documents 2007 Edition Inside Out (view on Google Sidewiki)
Stephanie Krieger does a show and tell.in reference to: http://mediadl.microsoft.com/mediadl/MSDN/O/Office/en-us/2007OfficeVH2s/odcofficeSK_UsingVbaToControlBuiltInCommands.wmv (view on Google Sidewiki)
Wednesday, May 19, 2010
This is a new feature. Check it out.in reference to: Microsoft Project 2010 : Project 2010: Introducing Inactive Tasks (view on Google Sidewiki)
Tuesday, May 18, 2010
Monday, May 17, 2010
Chandoo's got a concise summary of the major new features.in reference to: What is new in Microsoft Excel 2010? - Overview of Excel 2010 Features and Introduction | Chandoo.org - Learn Microsoft Excel Online (view on Google Sidewiki)
Wednesday, May 12, 2010
Although not linking to concise info, here is Microsoft's one stop webpage for Windows installsin reference to: Install, reinstall, and uninstall Windows - Help & How-to - Microsoft Windows (view on Google Sidewiki)
Tuesday, May 11, 2010
It's quite useful to do SUM with multiple criteria in reference to: Excel SUMPRODUCT formula - Syntax, Usage, Examples and Tutorial | Chandoo.org - Learn Microsoft Excel Online (view on Google Sidewiki)
Updated: 21st July 2010
Criteria driven results can also be arrived through use of Array Formulae. Mr. Excel writes about this on his CSE (Control+Shift+Enter) article.
Saturday, May 8, 2010
Friday, May 7, 2010
Thursday, May 6, 2010
I used to be a fan of Mike Lin's Clipomatic. Then my Windows XP became too crowded and my mult-clipboard programs stopped working properly. Now I am on Windows 7 but Clipomatic is sadly out of date and does not cope with the security settings to %Program Files%
Fortunately, ClipX has been updated, trying out the beta 7 x86 release.....
Wednesday, May 5, 2010
Tuesday, May 4, 2010
Saturday, May 1, 2010
It's difficult to figure out what lies after VBA when you are cool with VBA in Office and see that there are nice things you could do but they are in .NET. Aside from the skilling up and hoping that the .NET bits and pieces are installed on end users' machines, it's the case of what features that could be tempting. .NET is evolving at a rapid rate but not every feature is grokkable or even worth grokking to you.
Here are some videos.