-
The Baker’s Dozen: 13 Productivity Tips for Using Microsoft PowerPivot and DAX Formulas
By:
Kevin Goff
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2011 - January/February
I know what you’re thinking: an article in CODE Magazine about Excel and PowerPivot? Yes, that’s correct; this installment of the “Baker’s Dozen” covers an important new tool to come out of Redmond: Microsoft PowerPivot. In a nutshell, PowerPivot provides some of the business intelligence capabilities that developers are accustomed to seeing in OLAP tools like Microsoft Analysis Services. So why should you and I care? Because these “end-user” tools still require some programming and configuration. So in this article, I’ll cover the installation of PowerPivot, a brief example of how to use it in Excel - and of course, since this IS CODE Magazine, I’ll show some DAX formula expressions to get the most out of PowerPivot.
-
Post Mortem Web Project
By:
Rod Paddock
Last updated: Thursday, December 16, 2021
Published in: CODE Magazine: 2010 - January/February
First Premier Bankcard (www.firstpremier.com) is the 10th largest issuer of Visa and MasterCard credit cards in the United States.First Premier employs multiple thousands of people spread across the state of South Dakota. A major percentage of the employees at First Premier work in call-center operations helping people apply for credit cards.
-
Ask the Doc Detective
By:
Doc Detective
Last updated: Sunday, December 7, 2025
Published in: CODE Magazine: 2008 - July/August
In “Ask the Doc Detective,” Doc Detective offers practical guidance for navigating and solving tricky issues within Microsoft Visual Studio documentation, emphasizing how elusive or obscure details can hinder problem-solving. Through user-submitted questions, Doc addresses specific technical challenges—such as 64-bit PrintDialog behavior, locating version-specific VSTO resources, customizing Visual Studio menus, and fixing DataRepeater control quirks—while also sharing tips for refining Help searches. The author’s central message is that effective problem resolution often depends on knowing where and how to uncover hidden or poorly documented information in vast technical resources.
-
Visual Studio Team Foundation Server 2012: Adopting Agile Software Practices: From Backlog to Continuous Feedback, 3rd Edition - Chapter 2 - Scrum, Agile Practices, and Visual Studio
Last updated: Saturday, January 18, 2020
Published in: Book Excerpts
-
Visual Studio Unleashed - Chapter 2 - The Visual Studio IDE
Last updated: Saturday, January 18, 2020
Published in: Book Excerpts
This excerpt is from the new book, ‘Microsoft Visual Studio 2010 Unleashed’, authored by Mike Snell and Lars Powers, published in the Sams Unleashed Series, August 2010, ISBN 0672330814, Copyright 2010. For more info, please visit the publisher site http://www.informit.com/store/product.aspx?isbn=0672330814
-
20 Cool Visual Studio .NET IDE Features
By:
Markus Egger
Last updated: Monday, December 8, 2025
Published in: CODE Magazine: 2002 - March/April, Markus Egger Talks Tech
In this article Markus Egger surveys 20 often-overlooked productivity features of the Visual Studio .NET IDE—from the customizable Start Page, dynamic help and flexible window layout to IntelliSense, macros, clipboard ring and advanced search—showing how these tools and granular options empower developers to tailor the environment, streamline coding tasks, and boost efficiency, while encouraging exploration and extension via macros or add-ins.
- Home
Articles filed in category 'Visual Studio Tools for Office'