You need to enable JavaScript to view more than 15 articles by this author.
What Is a Pivot Table
Publish Date: Aug. 12, 2005
Pivot tables are a hidden gem in Excel. While many otherwise experienced spreadsheet users avoid them because they seem too complicated at first glance, the real problem is that pivot tables are rarely explained properly. This article illuminates how your life will be better when you learn to use pivot tables, then walks you through how to build a basic pivot table.
Refactoring in Visual Basic 2005
Publish Date: Jul. 26, 2005
Refactoring is the one-size-fits-all name given to a set of coding shortcuts that help you rework code on the fly. C# developers have such a tool, but Visual Basic developers were not so lucky--till now. Matthew MacDonald, author of Visual Basic 2005: A Developer's Notebook , reviews Refactor, the free VB 2005 tool, and offers some how-to techniques for using it.
Getting Real-Time Data from the Web in Excel
Publish Date: Feb. 8, 2005
Did you know that you can use Excel for more than just storing and organizing static data? In this article, Matthew MacDonald, author of Excel: The Missing Manual , shows you how to use Excel as a tool to handle up-to-the-minute information like sales figures and currency exchange rates.
New Language Features in C# 2.0, Part 2
Publish Date: Apr. 12, 2004
The first part of this series introduced three new C# language features: anonymous methods, iterators, and partial types. In this second part, Matthew MacDonald tackles the last and most exciting new feature: Generics.
New Language Features in C# 2.0, Part 1
Publish Date: Apr. 5, 2004
Four years ago, a new upstart language named C# surprised the development world with its elegance and consistency. Now that Microsoft has released a technology preview version of Visual Studio 2005 (formerly codenamed Whidbey), .NET's favorite language is back, with some new innovations. In this two-part servies by Matthew MacDonald, you'll get a first look at three of the four major language refinements in the latest version of C#.
Enhancing ASP.NET Pages with JavaScript
Publish Date: Sep. 15, 2003
A sprinkling of JavaScript code can enhance the reach and responsiveness of
your ASP.NET web pages without sacrificing ASP.NET's secure,
server-based model for your coding. Matthew MacDonald, coauthor of
ASP.NET in a Nutshell, 2nd Edition , shows you how to use
JavaScript in an ASP.NET web page to perform three common tasks: showing a pop-up window, changing control focus, and handling frame navigation. You can use these tricks to quickly solve problems that have
no native .NET solution.
Using Visual Studio .NET Macros
Publish Date: Dec. 9, 2002
One of the often-overlooked features of Visual Studio .NET's productivity tools is the macro engine and extensibility model that's built into Visual Studio .NET. This model provides almost 200 objects that give you unprecedented control over the IDE. In this new article by Matthew MacDonald, he shows you how they can work for you.
Web Services: Objects or XML Endpoints?
Publish Date: Sep. 3, 2002
Matthew MacDonald, coauthor of Programming .NET Web Services offers valuable advice for every .NET Web service programmer.