OfficePalooza

OfficePalooza is an online competition that tests your skills in Visual Basic for Applications, teaches you new skills, and above all, ensures that you have some fun with it.

Prize Update

All the prize winners have been notified and the prizes have been mailed out. If you were notified...

Author: Greg Stemp Date: 06/24/2009

The End

OfficePalooza is over, but you can still find all the challenges and solutions from the Home page,...

Author: Greg Stemp Date: 05/03/2009

Day 10

Well, this is it. Day 10. The final day of our two-week super-event, OfficePalooza. We’ll continue...

Author: Greg Stemp Date: 05/01/2009

Solution - Novice Challenge 10: Skip It

Did you like the first slide in this challenge? We hope so. The first slide turned out to where...

Author: Greg Stemp Date: 05/01/2009

Solution - Novice Challenge 9: I Need a Break

It’s true: we all need a break once in a while. A break from work, a break from the kids, a break...

Author: Greg Stemp Date: 05/01/2009

Solution - Experienced Challenge 10: Don’t Get Ten of Those Little Red Cells

You know, if we were a little smarter we would have made Challenge 10 an easy one; after 2 solid...

Author: Greg Stemp Date: 05/01/2009

Solution - Experienced Challenge 9: And They’re Off!

This was one challenge that we actually had to think about. (Does that mean we didn’t think about...

Author: Greg Stemp Date: 05/01/2009

Day 9

Day 9 of OfficePalooza. Yes, that’s right, Day 9. Only one more day left. But don’t be sad, just...

Author: Greg Stemp Date: 04/30/2009

Day 8

It’s Day 8, and Challenges 7 and 8 were due this morning. Scores are still being updates as more...

Author: Greg Stemp Date: 04/29/2009

Solution - Experienced Challenge 8: Twenty Questions

So were we able to come up with a solution to challenge 8? Good question. As it turns out, we wrote...

Author: Greg Stemp Date: 04/29/2009

Solution - Experienced Challenge 7: It’s Showtime!

This was an interesting challenge for us. We knew that there was no simple, straightforward way to...

Author: Greg Stemp Date: 04/29/2009

Solution - Novice Challenge 8: It’s Not My Fault

We all make mistakes, right? Like maybe we say something we really shouldn’t have said, or even...

Author: Greg Stemp Date: 04/29/2009

Solution - Novice Challenge 7: Switcheroo

This was an interesting challenge. As with just about any coding challenge, there were multiple ways...

Author: Greg Stemp Date: 04/29/2009

Day 7

It’s Day 7, and guess what we have in store for today? Today is Office Communicator/Office...

Author: Greg Stemp Date: 04/28/2009

Day 6

We’re back for Week 2 of OfficePalooza! Challenges 5 and 6 were due this morning. Check our...

Author: Greg Stemp Date: 04/27/2009

Solution - Novice Challenge 6: How Animated Am I?

For the first five challenges we sort of eased you into all the Visual Basic for Applications (VBA)...

Author: Greg Stemp Date: 04/27/2009

Solution - Novice Challenge 5: You Name It

We’ll start out by admitting something to you: we messed up. That probably isn’t a big surprise to...

Author: Greg Stemp Date: 04/27/2009

Solution - Exprienced Challenge 6: How Do You Spell That Again?

This was a challenge a good 15 or 20 years in the making. That’s not because it took us that long to...

Author: Greg Stemp Date: 04/27/2009

Solution - Experienced Challenge 5: I’m Leaving on a Jet Plane

We have to admit that Challenge 5 took us a little by surprise: it turned out to be easier than we...

Author: Greg Stemp Date: 04/27/2009

Day 5

OfficePalooza Day 5 is here! Challenges 3 and 4 were due today. Take a look at the solutions to...

Author: Greg Stemp Date: 04/24/2009

Solution - Novice Challenge 4: I Need a New Style

Our initial idea for this challenge was to have you set the font in the entire document to the first...

Author: Greg Stemp Date: 04/23/2009

Solution - Novice Challenge 3: What Do I Owe You?

Challenge 3 was an interesting one. Not so much the challenge itself, but people seemed surprised at...

Author: Greg Stemp Date: 04/23/2009

Solution - Experienced Challenge 4: Hmmm, So Maybe This is Rocket Science After All

This is the story of The Challenge That Almost Wasn’t. When we first thought of adding a missile...

Author: Greg Stemp Date: 04/23/2009

Solution - Experienced Challenge 3: Are You Smarter Than a PowerPoint Developer?

What could be more fun than taking a test? OK, good point: pretty much everything is more fun than...

Author: Greg Stemp Date: 04/23/2009

Day 4

It’s Day 4 of OfficePalooza! Two more challenges in each division are due tomorrow, Friday, April...

Author: Greg Stemp Date: 04/23/2009

Solution - Novice Challenge 2: What Did I See?

This challenge required that you use search and replace and that you know how to call up an input...

Author: Greg Stemp Date: 04/21/2009

Solution - Novice Challenge 1: Color My Column

We gave you a good start in this challenge by having you put the code in the...

Author: Greg Stemp Date: 04/21/2009

Solution - Experienced Challenge 2: The Secret Word is FGJAJGSHSBSW

So is this what real spies do all day: write Visual Basic for Applications (VBA) macros that decode...

Author: Greg Stemp Date: 04/21/2009

Solution - Experienced Challenge 1: That’s a Lot of Jellybeans … Isn’t It?

Well, we said Challenge 1 in the Experienced Division would be an easy one, and guess what: we were...

Author: Greg Stemp Date: 04/21/2009

Day 3

Today is Day 3 of OfficePalooza! The deadline is up for the first two challenges in both the Novice...

Author: Greg Stemp Date: 04/21/2009

Day 2

Welcome to Day 2 of OfficePalooza! Just one more day to get those first couple of challenges done....

Author: Greg Stemp Date: 04/20/2009

Novice Division Scores

Here are the final scores (OK, the current number of virtual goldfish awarded) for the OfficePalooza...

Author: Greg Stemp Date: 04/20/2009

Experienced Division Scores

Here are the final scores (OK, the final number of virtual goldfish awarded) for the OfficePalooza...

Author: Greg Stemp Date: 04/20/2009

Day 1

Welcome to Day 1 of OfficePalooza! Take a look around then get started on your challenges. The first...

Author: Greg Stemp Date: 04/19/2009

OfficePalooza Every Day

OfficePalooza: Learn on Your Own Thank you to everyone who joined us for this online competition! We...

Author: Greg Stemp Date: 04/19/2009

The best way to solve the challenges in OfficePalooza, and to continue learning long after...

Author: Greg Stemp Date: 04/19/2009

Challenge Descriptions and Solutions

@font-face { font-family: Cambria Math; } @font-face { font-family: Calibri; } @page Section1 {size:...

Author: Greg Stemp Date: 04/19/2009

Experienced Challenge 10: Don't Get Ten of Those Little Red Cells

Office Programs Required Microsoft Excel 2007 Goldfish Awarded 20 Deadline for Submission Friday,...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 9: And They're Off!

Office Programs Required Microsoft PowerPoint 2007 Goldfish Awarded 10 Deadline for Submission...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 8: Twenty Questions

Office Programs Required Microsoft Access 2007 Goldfish Awarded 20 Deadline for Submission...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 7: It's Show Time!

Office Programs Required Microsoft PowerPoint 2007 Microsoft Excel 2007 Goldfish Awarded 10 Deadline...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 6: How Do You Spell That Again?

Office Programs Required Microsoft Word 2007 Goldfish Awarded 5 Deadline for Submission Monday,...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 5: I'm Leaving on a Jet Plane

Office Programs Required Microsoft Access 2007 Goldfish Awarded 10 Deadline for Submission Monday,...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 4: Hmmm, So Maybe This IS Rocket Science After All

Office Programs Required Microsoft Excel 2007 Goldfish Awarded 5 Deadline for Submission Friday,...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 3: Are You Smarter Than a PowerPoint Developer?

Office Programs Required Microsoft PowerPoint 2007 Goldfish Awarded 5 Deadline for Submission...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 2: The Secret Word is FGJAJGSHSBSW

Office Programs Required Microsoft Word 2007 Goldfish Awarded 10 Deadline for Submission Wednesday,...

Author: Greg Stemp Date: 04/18/2009

Experienced Challenge 1: That's a Lot of Jellybeans ... Isn't It?

Office Programs Required Microsoft PowerPoint 2007 Goldfish Awarded 5 Deadline for Submission...

Author: Greg Stemp Date: 04/18/2009

Novice Challenge 10: Skip It

Office Programs Required Microsoft PowerPoint 2007 Goldfish Awarded 20 Deadline for Submission...

Author: Greg Stemp Date: 04/18/2009

Novice Challenge 9: I Need a Break

Office Programs Required Microsoft Word 2007 Goldfish Awarded 15 Deadline for Submission Friday, May...

Author: Greg Stemp Date: 04/18/2009

Novice Challenge 8: It's Not My Fault

Office Programs Required Microsoft Word 2007 Goldfish Awarded 5 Deadline for Submission Wednesday,...

Author: Greg Stemp Date: 04/18/2009

Next>