Creating Web 2.0 Style Objects in Excel and PowerPoint 2003

Posted by schone on July 1st, 2008

previewAfter playing around with Excel and PowerPoint 2007, I was very impressed at the way you can format your objects to look very Web 2.0ish, but as I use 2003 at work a lot I wanted to see if I could replicate this.

Here is a quick tutorial on how to change your objects in an Excel 2003 worksheet or PowerPoint 2003 presentation into Web 2.0 style objects.

Read the rest of this entry »

How to link a Pivot Chart to a Powerpoint Presentation (IV)

Posted by schone on June 17th, 2008

In this tutorial I will go through how you can link a Pivot Chart in Excel to a PowerPoint presentation. I suggest you read a post I did earlier which is an overview on linking between Excel and PowerPoint.

Related Posts :

Read the rest of this entry »

How to link a chart in Excel to a PowerPoint presentation (III)

Posted by schone on June 12th, 2008

This is the last part of the 3 part tutorial on linking PowerPoint to Excel. In this tutorial I will go over how you can link a chart in a PowerPoint presentation to one that you have built in an Excel worksheet.

Related : Part 1 - How to link an Excel worksheet to a PowerPoint presentation
Related :
Part 2 - How to link a table in Excel to a PowerPoint presentation
Related : Part 4 - How to link a Pivot Chart in Excel to a PowerPoint presentation
Related : Part 5 - How to link a Pivot Table in Excel to a PowerPoint presentation

Read the rest of this entry »

How to link a table in Excel to a PowerPoint presentation (II)

Posted by schone on June 11th, 2008

This is the 2nd part of my series on how to link a PowerPoint presentation to an Excel worksheet, in this tutorial I will run through how to link a table in PowerPoint to one that you have built in Excel.

Read the rest of this entry »

How to link a PowerPoint presentation to an Excel worksheet (I)

Posted by schone on June 10th, 2008

This is part 1 of many tutorials on how to link cell values, tables and charts in a PowerPoint presentation to an Excel worksheet. This will be helpful when creating regularly updated presentations, for example: A quarterly business performance presentation. Once it is setup all you will need to do is update your Excel worksheet and it will flow through to your PowerPoint presentation … Yes, dynamic presentations!

This post will look at linking cell values.

Related Posts :

Read the rest of this entry »

Making charts look good in Excel 2003

Posted by schone on May 29th, 2008

Everytime I open up or view a report which still has the default Excel 2003 chart formatting visible I cringe, the grey and off blue colours just make me dry reach.

The whole point of charting is to represent data in a consumable medium, so to go against the grain of ugly Excel 2003 charting I’m going to go over some of my do’s and don’ts when it comes to charting in Excel 2003.

F.Y.I : I know Excel 2007 has some great charting options and anti-aliased charts, however I believe this will benefit the users of Excel 2003.

Read the rest of this entry »


Copyright © 2008 Jumbabox. All rights reserved.