Contextures

Excel 2007 Articles List

Many articles were published in 2005-2006, when Microsoft was preparing to release Microsoft Office 2007. However, most of the original articles have been removed from the Microsoft site, so most links have been removed from the list below.

To see archived copies of some articles, go to the Wayback Machine site:

Excel 2007 Articles List

Here are the Excel 2007 articles, listed by category. Only a few links are included, because the original links no longer work.

Articles with Links

Business Intelligence in Excel 2007 [Video clips]; Mike Arcuri; 2006-02-21

Improving Performance in Excel 2007; Charles Williams; 2006-10-23

Developing Add-ins (XLLs) in Excel 2007; Steve Dalton; 2006-10-04

Analysis Services

  • Data Mining In Excel; David Gainer; 2007-02-21
  • SQL Server Analysis Services support - the list; David Gainer; 2006-02-08

Calculation

  • Improving Performance in Excel 2007; Charles Williams; 2006-10-23
  • Excel And High-Performance Computing Part I; David Gainer; 2006-06-26
  • Multi-threaded calculation in Excel, or “how calculation can become much faster in Excel 12; David Gainer; 2005-11-03

Charts

  • Chart Pattern Fills; Eric Patterson; 2007-11-16
  • Charting V - PivotCharts; David Gainer; 2006-04-19
  • Charting IV – Charts in PowerPoint and Word; David Gainer; 2006-04-17
  • Charting III – Tabs and Templates; David Gainer; 2006-04-13
  • Charting II - Professional charts, made easy (continued); David Gainer; 2006-04-12
  • Charting I - Professional charts, made easy; David Gainer; 2006-04-11
  • Quick Detour: cool things on the status bar and great-looking charts; David Gainer; 2005-11-18

Compatibility

  • PivotTable Compatibility; Eric Patterson; 2006-08-30
  • Deprecated Features for Charting; Eric Patterson; 2006-08-28
  • Deprecated Features ; Eric Patterson; 2006-08-24
  • Conditional Formatting Compatibility; Eric Patterson; 2006-08-14
  • Compatibility Checker; Eric Patterson; 2006-08-11
  • Compatibility Mode; Eric Patterson; 2006-08-10

Conditional Formatting

  • Conditional Formatting Trick 3 - The percentmin Property; David Gainer; 2006-09-20
  • Fun With Conditional Formatting; David Gainer; 2006-07-19
  • Conditional Formatting Trick 2 - How to get an icon in some cells, but not all cells; David Gainer; 2006-05-10
  • Conditional Formatting Trick 1 - Multi-Coloured Data Bars; David Gainer; 2006-02-24
  • It's Gonna Be A Hot Summer; Jensen Harris; 2006-02-10
  • Conditional formatting using VBA - some examples ; David Gainer; 2005-10-14
  • More about conditional formatting ... ; David Gainer; 2005-10-13
  • Conditional formatting meets the ribbon ; David Gainer; 2005-10-12
  • New conditional formatting "rules" ...; David Gainer; 2005-10-11
  • Wrapping up new visualizations - icon sets ; David Gainer; 2005-10-09
  • We now return to conditional formatting - what's a colour scale? ; David Gainer; 2005-10-06
  • Conditional Formatting - overview of what we did, and what's a “data bar”? ; David Gainer; 2005-10-04

Excel Services

  • Making Excel Services UDFs work on Excel Client - Part 3; Shahar Prish; 2007-03-07
  • Data-Type Handling with Excel Services User-Defined Functions; David Gainer; 2007-01-31
  • Whitepaper - External Data Connections For Excel Services; David Gainer; 2006-12-04
  • Using Parameters In Dashboards; Dan Parish; 2006-09-25
  • Another Whitepaper - Developing UDFs for Excel 2007 and Excel Services; David Gainer; 2006-09-22
  • Making Excel Services UDFs Work in Excel 2007; David Gainer; 2006-09-01
  • Making Excel Services UDFs Work in Excel 2007 - Part 2; Shahar Prish; 2006-08-30
  • Making Excel Services UDFs Work in Excel 2007 - Part 1; Shahar Prish; 2006-08-03
  • Building Custom Solutions with Excel Services [video]; Danny Khen; 2006-05-06
  • VB.NET example for the Programming against Excel Services APIs; Shahar Prish; 2006-03-27
  • First "Hello World" code sample with the Excel Services APIs; Shahar Prish; 2006-03-24
  • Excel services part 12: Unsupported features; David Gainer; 2005-12-01
  • Excel services part 11: Excel Server, SharePoint, and dashboards; David Gainer; 2005-11-30
  • Excel services part 10: Data Connection Libraries, or connecting to databases made easy, manageable, and secure; David Gainer; 2005-11-29
  • Excel services part 9: Controlling and protecting spreadsheets cont'd; David Gainer; 2005-11-23
  • Excel services part 8: Controlling and protecting spreadsheets; David Gainer; 2005-11-22
  • Excel services part 7: Sample Application with Excel Web Services; David Gainer; 2005-11-21
  • Excel services part 6: Building applications with Excel Web Services; David Gainer; 2005-11-17
  • Excel services part 5: all about “interactivity”; David Gainer; 2005-11-16
  • How do I publish workbooks to the server?; David Gainer; 2005-11-11
  • Excel Services - Architecture; David Gainer; 2005-11-10
  • Excel Services - Key Scenarios; David Gainer; 2005-11-09

File Format

  • Working With Excel's XML-Based File Formats; David Gainer; 2007-08-21
  • Simple SpreadsheetML file (part 2 of 3); Brian Jones; 2006-11-15
  • Simple SpreadsheetML file Part 1 of 3; Brian Jones; 2006-11-02
  • SpreadsheetML Dates; Brian Jones; 2006-10-25
  • All About File Formats; David Gainer; 2006-07-20
  • SpreadsheetML News; David Gainer; 2006-04-06
  • Microsoft Office Open XML Formats Architecture Guide  ; ; 2005-09-15
  • Microsoft Office Open XML Formats Guide  ; ; 2005-09-15
  • Microsoft Office Open XML Formats FAQs ; ; 2005-09-13
  • Microsoft Office Open XML Formats Overview ; ; 2005-09-13

Formatting

  • Headers and Footers in Excel 2007; David Gainer; 2006-04-10
  • Page Layout View; David Gainer; 2006-04-05
  • Table S tyles in Excel 2007; David Gainer; 2006-03-30
  • Cell Styles - More Usable, better defaults; David Gainer; 2006-03-29
  • Document Themes Part II; David Gainer; 2006-03-24
  • Document Themes Part I; David Gainer; 2006-03-23
  • Excel 2007 documents - easy on the eyes; David Gainer; 2006-03-13
  • Quick detour #2: Working with currencies made easy; David Gainer; 2005-12-02
  • Formatting: An Act In Three Plays ; Jensen Harris; 2005-09-22

Formula Bar

  • Formula building improvements Part 4: Defined Names ; David Gainer; 2005-10-21
  • Formula editing improvements Part 3: new functions ; David Gainer; 2005-10-20
  • Formula editing improvements Part 2: Formula AutoComplete ; David Gainer; 2005-10-19
  • Meet the Excel 12 formula bar, or “don't hijack my grid!” ; David Gainer; 2005-10-18

Functions

  • CUBE Functions 4: Deconstructing the PivotTable; David Gainer; 2006-02-15
  • CUBE Functions 3: Formula AutoComplete revisited; David Gainer; 2006-02-09
  • CUBE Functions 2: A Few Examples; David Gainer; 2006-02-06
  • The Excel 12 Blog Rides Again, or “CUBE Functions Part 1”; David Gainer; 2006-02-02

Graphics

  • SmartArt Graphics with Style; David Gainer; 2006-05-16
  • Introducing SmartArt Graphics; David Gainer; 2006-05-15

Keyboard

  • 4 More Shortcut Keys; David Gainer; 2006-06-28
  • Charlie's List, or “214 Keyboard Shortcuts”; David Gainer; 2006-02-23
  • Stroking the Keys in Office 12 ; Jensen Harris; 2005-10-13

Other

  • Templates, Templates; David Gainer; 2006-08-18
  • Business Intelligence in Excel 2007 [Video clips]; Mike Arcuri; 2006-02-21
  • Managing External Database Connections in Excel 12; David Gainer; 2006-02-16
  • Making the Letters Better; Jensen Harris; 2005-11-15
  • Decoding Office Build Numbers; Jensen Harris; 2005-11-11
  • Introduction to Excel Services, or “running Excel spreadsheets on a server”; David Gainer; 2005-11-08
  • Accessibility Begets Usability; Jensen Harris; 2005-11-03
  • We interrupt conditional formatting for a brief message about undo/redo and PDF… ; David Gainer; 2005-10-05
  • Microsoft's Steven Sinofsky Discusses Support for the PDF Format in Office “12” ; Microsoft; 2005-10-02
  • Some other numbers ... ; David Gainer; 2005-09-26
  • The Microsoft Enterprise Content Management Offering ; ; 2005-09-13

Overview

  • New Whitepaper - Migrating to Excel 2007; David Gainer; 2007-03-02
  • More places to learn about Excel 12 ... ; David Gainer; 2005-09-29
  • Office 12: It's Not Just UI ; Jensen Harris; 2005-09-28
  • The big picture ...  ; David Gainer; 2005-09-28
  • Let's start with some "big" news  ; David Gainer; 2005-09-23

PivotTables

  • Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables; Microsoft; 2007-04-09
  • PivotTable Styles; David Gainer; 2006-03-31
  • Pivot Tables grand finale: Tricks with the Value field; David Gainer; 2006-01-13
  • PivotTables 12: Filtering OLAP data, and some “persistence” improvements; David Gainer; 2006-01-12
  • PivotTables 11: Key Performance Indicators, Actions, and Named Sets; David Gainer; 2006-01-10
  • PivotTables X: Server formatting, translations, member properties; David Gainer; 2006-01-05
  • PivotTables 9: Great support for SQL Server Analysis Services; David Gainer; 2005-12-29
  • PivotTables VIII: “Defer Layout Update”, or adding multiple fields in one fell swoop; David Gainer; 2005-12-22
  • PivotTables VII: Conditional formatting gets even better, or visualizing your data in PivotTables; David Gainer; 2005-12-21
  • PivotTables VI: Sorting and Filtering; David Gainer; 2005-12-20
  • PivotTables V: Context menus; David Gainer; 2005-12-15
  • PivotTables part 4: Task-oriented UI, or “improvements the Ribbon affords us”, and some bonus talk about dialogs; David Gainer; 2005-12-14
  • PivotTables part 3: More clickable, more compact, and nicely styled ; David Gainer; 2005-12-13
  • PivotTables part 2: Creating summary reports made easy ; David Gainer; 2005-12-09
  • PivotTables - overview of improvements in Excel 12 ; David Gainer; 2005-12-06

Programming

  • Developer Resources for Office 2007 RTM ; Jensen Harris; 2006-11-13
  • Final Schema for RibbonX-based Solutions; Jensen Harris; 2006-10-26
  • Developing Add-ins (XLLs) in Excel 2007; Steve Dalton; 2006-10-04
  • Excel 2007 & Internet Explorer; David Gainer; 2006-09-26
  • Hey, Where Did Solver Go?; David Gainer; 2006-09-09
  • Referencing Tables From RefEdit Controls; Sam Radakovitz; 2006-09-05
  • Sam On Forms Controls; Sam Radakovitz; 2006-08-16
  • Developer Tab ; David Gainer; 2006-08-15
  • The Add-In Tab; David Gainer; 2006-08-12
  • Trust Center Part 5: Data Connection Security; Sam Radakovitz; 2006-08-03
  • Trust Center Part 4: Trusted Locations; Sam Radakovitz; 2006-08-01
  • Trust Center Part 3: Making Sense of Security Settings; Sam Radakovitz; 2006-07-28
  • Trust Center Part 2: Trust Bar - Eliminating Unnecessary Trust Decisions; Sam Radakovitz; 2006-07-26
  • Trust Center Part 1: Principles; Sam Radakovitz; 2006-07-24
  • XLLs: A New Way To Optimize; David Gainer; 2006-07-13
  • Custom Task Panes; David Gainer; 2006-07-11
  • Managed Add-In Improvements; David Gainer; 2006-06-21
  • 2007 Microsoft Office System Primary Interop Assemblies; David Gainer; 2006-06-19
  • Excel 2007 investments in UDFs #3: client/server solution using a core library; Danny Khen; 2006-05-05
  • Excel 2007 investments in UDFs #2: Existing UDFs; Danny Khen; 2006-05-04
  • Excel 2007 investments in UDFs #1; Danny Khen; 2006-05-04
  • A Small Piece Of Pleasant News For Those Of Us That Write Code In Office, Plus Some More Screenshots …; David Gainer; 2006-04-04
  • Quick detour #3: Updates we have made to XLLs; David Gainer; 2006-01-03
  • Because You Want To, Not Because You Have To [Add-ins]; Jensen Harris; 2005-10-27
  • It All Adds Up [Add-ins]; Jensen Harris; 2005-10-26

Tables

  • Fun With Tables; David Gainer; 2006-07-18
  • Tables Part 7: Good-looking, well-behaved table formatting made easy ; David Gainer; 2005-11-07
  • Tables Part 6: Removing duplicates from tables (and ranges) of data ; David Gainer; 2005-11-04
  • Tables Part 5: Everything you wanted to know about sorting in Excel 12; David Gainer; 2005-11-02
  • Tables Part 4: AutoFilter improvements: much more than just multi-select … ; David Gainer; 2005-11-01
  • Tables Part 3: Using Formulas with Tables ; David Gainer; 2005-10-28
  • Tables Part 2: Stickiness, Structured Selection, And More; David Gainer; 2005-10-27
  • Tables Part 1: Working With Tables Of Data ; David Gainer; 2005-10-25

User Interface

  • Using RibbonX with C++ and ATL; Eric Faller; 2006-12-08
  • RibbonX Image FAQ; Eric Faller; 2006-11-27
  • Licensing the 2007 Microsoft Office User Interface; Jensen Harris; 2006-11-27
  • Recently Used Items; Jensen Harris; 2006-08-16
  • Sander Viegers Rides Again; Sander Viegers; 2006-07-12
  • Meet Sander Viegers, Excel User Experience Designer; Sander Viegers; 2006-07-12
  • Using the Command Well; Jensen Harris; 2006-06-20
  • Introducing the Command Well; Jensen Harris; 2006-06-19
  • Tools|Options -- the Rest; David Gainer; 2006-05-24
  • Whatever happened to Tools|Options?; David Gainer; 2006-05-22
  • Super Tooltips and Collapsing The Ribbon; David Gainer; 2006-03-10
  • Excel 2007 - The Final Look, and more rows and columns; David Gainer; 2006-03-09
  • Picture This: A New Look For Office; Jensen Harris; 2006-03-09
  • The New Microsoft Office User Interface Overview ; ; 2006-03-09
  • Making features easier to find and quicker to use; David Gainer; 2006-03-02
  • Super Tooltips ; Jensen Harris; 2005-12-02
  • You'll Know It When You See It [Live Preview]; Jensen Harris; 2005-11-21
  • Grading on the Curve (Why the UI, Part 8); Jensen Harris; 2005-11-14
  • 1000 Card Pick-up [commands]; Jensen Harris; 2005-11-10
  • Zoom, Zoom, Zoom; Jensen Harris; 2005-11-09
  • For Sale By Owner [managing screen real-estate]; Jensen Harris; 2005-11-08
  • No Distaste for Paste (Why the UI, Part 7); Jensen Harris; 2005-11-07
  • The Importance Of Labels [Ribbon]; Jensen Harris; 2005-11-01
  • Inside Deep Thought (Why the UI, Part 6) ; Jensen Harris; 2005-10-31
  • Tipping the Scale (Why the UI, Part 5) ; Jensen Harris; 2005-10-24
  • More Than Just the Two-Way Mirror  [UI Research]; Jensen Harris; 2005-10-21
  • A Disappearing Act [Ribbon]; Jensen Harris; 2005-10-19
  • Scaling Up, Scaling Down  [Ribbon]; Jensen Harris; 2005-10-18
  • New Rectangles to the Rescue? (Why the UI, Part 4) ; Jensen Harris; 2005-10-17
  • Most People Are Not Trained In Geology ; Jensen Harris; 2005-10-11
  • Combating the Perception of Bloat (Why the UI, Part 3) ; Jensen Harris; 2005-10-10
  • Why is it called the Ribbon? ; Jensen Harris; 2005-10-07
  • Saddle Up to the MiniBar ; Jensen Harris; 2005-10-06
  • Thrown For a Loop  [Ribbon]; Jensen Harris; 2005-10-05
  • Ye Olde Museum Of Office Past (Why the UI, Part 2) ; Jensen Harris; 2005-10-03
  • What programs get the new Office UI? ; Jensen Harris; 2005-09-30
  • Be Willing To Be Wrong  [Ribbon]; Jensen Harris; 2005-09-29
  • Dialog Launchers ; Jensen Harris; 2005-09-27
  • The Why of the New UI (Part 1) ; Jensen Harris; 2005-09-26
  • Results-Oriented Design (Galleries: Part 3 of 3) ; Jensen Harris; 2005-09-21
  • Visualize Whirled Peas (Galleries: Part 2 of 3) ; Jensen Harris; 2005-09-20
  • I'm In Louvre! (Galleries: Part 1 of 3) ; Jensen Harris; 2005-09-19
  • It's All About Context ; Jensen Harris; 2005-09-16
  • Mythbusters: The Office 12 New UI ; Jensen Harris; 2005-09-15
  • Enter the Ribbon ; Jensen Harris; 2005-09-14
  • New Microsoft Office User Interface FAQs ; ; 2005-09-13
  • Office 12 New UI: The Cat's Out ; Jensen Harris; 2005-09-13

About Debra

 

Last updated: August 14, 2022 9:02 PM