The best way to solve the challenges in OfficePalooza, and to continue learning long after OfficePalooza has ended, it to take a look at the great resources listed here.
Don’t forget to also look at the Solutions for the Advanced Business Users of Office page for all sorts of great information about customizing your Microsoft Office applications.
Day 1 – Microsoft Office Excel Day
John Walkenbach 's The Spreadsheet Page
Adding Color to Excel 2007 Worksheets by Using the ColorIndex Property
Chart Labels
Editing Data Series
Using Cell Text to Filter PivotTables [blog post]
Implementing Week-Numbering Systems and Date/Time Representations in Excel
Using Styles to Dress Up Your Worksheets in Excel 2007
Creating VBA Macros to Manipulate Worksheets in Excel 2007
Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel
Merging Data from Multiple Workbooks into a Summary Workbook in Excel
Working with Excel Workbooks and Worksheets in E-Mail
Primer in Excel VBA
RibbonX
Add-ins
Calling Excel 2007 Custom Wizards from the Office Fluent Ribbon by Using VBA
What is the fastest way to scan a large range in Excel? [blog post]
Announcing Microsoft Solver Foundation [blog post]
Performance Tips for Excel Programming
COM Library for Excel Web Services - Use EWS from VBA! [blog post]
Microsoft Excel: Revolutionary 3D Game Engine? [external]
Iteration & Conway’s Game of Life [blog post]
Two Methods for Importing Your Zune Playlist into Excel (Part 1 of 2)
Two Methods for Importing Your Zune Playlist into Excel (Part 2 of 2)
Animating Objects in Excel 2007 Using the 3-D Animation Engine
Create or delete a macro
Edit a macro
Working with Excel tables in Visual Basic for Applications (VBA)
Watch This: Use macros to automate repetitive tasks
Using Excel and Visual Basic for Applications to Create a Game
Day 2 – Microsoft Office Visio Day
Microsoft Office Visio Team Blog
Working with Data Programmatically in Visio 2007
Visio Developer Portal
Visio 2007 Library
Publishing Visio 2007 Solutions
Microsoft Office Visio 2007 on TechNet
Visio 2007 Product Information
Day 3 – Microsoft Office Access Day
Microsoft Access Team Blog Power Tips
Clint Covington's Access Blog
Microsoft Access MVP Site
Adding Tabs and Controls to the Office Fluent Ribbon in Access 2007
Displaying Custom Dialog Boxes for Custom Delete Actions in Access 2007
Creating User Prompts in Access 2007
Using VBA code to open a file stored in the new Access 2007 Attachment field [blog post]
Get started with Access programming
Chapter 8: Using Code to Add Advanced Functionality to Forms
Macro improvements in Access 2007 [blog post]
Automate applications with macros in Access 2007
Run an Access macro by using a keyboard shortcut
Create custom menus and shortcut menus by using macros
Adding (All) Options to Combo Boxes or List Boxes in Access 2007
Counting the Number of Working Days in Access 2007
Day 4 – Microsoft Office SharePoint Server Day
Graphically Displaying Data from SharePoint Lists in Visio 2007
Microsoft Office SharePoint Server 2007 on TechNet
Windows SharePoint Server Developer Center
Microsoft Office SharePoint Server Library
patterns & practices: SharePoint Guidance
Creating a Custom Feature in SharePoint Server 2007
Day 5 – Microsoft Office Day
Xtreme VB Talk VBA Forums
DevX.com's FreeVBCode.com site - VBA/Office listing
Steve Hanson's VBA Tips Web site
Stack Overflow Developer Forum, VBA-Tagged Discussions
SourceForge.net - VBA projects
MSDN Code Gallery - VBA projects
Programming the VBA Editor
MS Support - VBA KB Articles
Converting Code from VBA to Visual Basic .NET
Newsletter: Microsoft Office Insider
MS Office Client Developers Content and Resources Blog
Darren Strange: Office Rocker
Office Developer Center
Office Fluent UI Developer Portal
MSDN VBA Forum
MS VBA Developer Discussion Group
MSDN Office Developer Community
Microsoft Webcasts - VBA Topics
VBA Express
Office Zealot Web site
OpenXML Document Viewer
CodePlex - VBA projects
The Code Project - VBA projects
OpenXmlDiff.Exe: A Utility to Find the Differences Between Two Open XML Documents [blog post]
Open XML Developer.org Custom UI Editor Tool
Chapter 11: Creating Dynamic Ribbon Customizations
Boost Office 2007 security with Information Rights Management, the Document Inspector, and the Trust Center
Customizing the 2007 Office System Document Inspector
Writing to a Text File from within a Macro in the 2007 Office System
Digitally sign a macro project
Extending Word 2007, Excel 2007, and PowerPoint 2007 with a Single Line of VBA Code
MSDN Webcast: MSDN geekSpeak: What Is New for VBA Developers in the 2007 Office Release with Stephanie Krieger (Level 200)
2007 Office System Add-In: Icons Gallery
2007 Office System Document: Lists of Control IDs
What is a macro and why you should care [Crabby Office Lady]
Find Help on using the Visual Basic Editor
Office 2007 Search Commands Add-In
Using VBA to Format Long Documents in the 2007 Office System in a Fraction of the Time
Introducing the Open XML Format External File Converter for 2007 Microsoft Office System SP2
Pointers in Visual Basic using Undocumented Functions [external]
Extend Your VBA Code With VSTO
PowerTools for Open XML [blog post]
Day 6 – Microsoft Office Word Day
Customizing the Word 2007 Fluent Ribbon is as Easy as 1-2-3
MS Word Team Blog
Building Word 2007 Document Templates Using Content Controls [VH2]
Creating Word 2007 Templates Programmatically
Configure IT Quick: Re-create Word's Font Sampler macro with these handy refinements [external]
Taking Advantage of Bound Content Controls [blog post]
Mapping Word 2007 Content Controls to Custom XML Using the XMLMapping Object
Data-driven document generation with Word 2007 and the Office XML File Formats: Part 1 [blog post]
Creating a Custom Building Block Gallery for Word 2007 [VH2]
From VBA Macro to Word Add-in
Word Developer Portal
Day 7 – Microsoft Office Communicator/Office Communications Server Day
Microsoft Office Communications Server TechCenter
Office Communications Server 2007 Act 2 -- Er, R2
Top Ten Things You Might Not Know About Office Communications Server 2007 R2
Microsoft Office Communications Server 2007 R2 Library
Office Communications Developer Portal
Office Communicator 2007 R2
Tour of Office Communicator
Office Communications Server Team Blog
Office Communicator Team Blog
Office Communications Server on MSCOM
Day 8 – Microsoft Office PowerPoint Day
PowerPoint Developer Portal
PowerPoint 2007 Developer Reference
2007 Office Resource Kit
How-To Work with Shapes
PowerPoint Discussion Group
Help for PowerPoint 2007
Microsoft PowerPoint Team Blog
Day 9 – Microsoft Office Project Day
Microsoft Project Team Blog
Making the move from VBA to VSTO in Microsoft Project [blog post]
Project 2007 Help
Microsoft Office Project Server 2007
Project Developer Center
Project 2007 Developer Reference
Project Server TechCenter
Day 10 – Microsoft Office Outlook Day
Microsoft Outlook Team Blog
Outlook & VBA : Export contact information to Excel [blog post]
Chapter 24: Generating Reports on Outlook 2007 Data [book excerpt]
Customizing the Filing Format for Outlook 2007 Contacts
Searching Outlook 2007 Appointments by Using a Macro
Retrieving Recurring Appointments in Outlook 2007
Office Outlook 2007 Library
Outlook Developer Portal