5 steps to create meaning charts & infographics in Excel

By |March 11th, 2012|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , , , , , |

Nathan Yau has given me alot to think about in his book "Visualize This" (book.flowingdata.com). I borrowed some ideas from him to create this long-styled infographic in Microsoft Excel.

For Excel dashboards and powerpoint slide designs. Beautiful, imaginative, futuristic interfaces from Corning Glass.

By |February 11th, 2012|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, PointPoint in General|Tags: , |

This video from Corning Glass shows some cool concept technologies. Take a look at the beautiful and interactive computer interface designs. I can see some good ideas for dashboard designs and PowerPoint slides. http://www.youtube.com/watch?v=jZkHpNnXLB0& Some screen shots here: [...]

Excel Line Charts with Elegant Dates

By |August 29th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I came across this stock chart in the Kuala Lumpur's edition of the Business Times while I was in Malaysia. The chart has an elegant treatment of dates. I have seen this sort of designs in many magazines and wanted [...]

Singapore population infographic in Microsoft Excel

By |May 23rd, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

This is an info-graphic I created in Microsoft Excel. It shows the population composition of Singapore in 2009. The world map and the stick-man was from the standard web-ding font. The only exception was the Singapore flag which [...]

If you can measure it, you can definitely dashboard it!

By |May 7th, 2010|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

Dashboards can be used to show important KPIs (key performance indicators) for all sorts of industries and work processes. If you can measure it, you can definitely dashboard it! I've made a short list of useful KPIs along with the [...]

Klipfolio, a beautiful dashboard software. Free!

By |February 13th, 2010|Categories: Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I have always been a fan of Klipfolio (http://www.klipfolio.com). This tiny software features beautifully made dashboards that run on your desktop. It's useful and very clever. Download it, try it. It's a low risk way to see how dashboards can [...]

8 Microsoft Excel Chart Formatting Tips

By |October 5th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

I will demonstrate the following chart formatting tips starting from Microsoft Excel 2003. 1. Remove plot area colours and borders. 2. Remove any vertical grid-lines. 3. Change horizontal grid-line color from black to a very light shade of gray. 4. [...]

A crappy chart from the Straits Times. GIC looking to Asia, emerging markets

By |September 29th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I'm going to take a potshot at the Straits Times on a chart I saw in the Money Section. The chart was trying to compare GIC's (Government of Singapore Investment Corporation) current asset mix to last year's asset mix. It gave [...]

Ministry of Manpower Unemployment Dashboard in Excel

By |September 17th, 2009|Categories: Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

MOM's website (www.mom.gov.sg) contains a wealth of labor data. An example is on unemployment rates in Singapore. I took two sets of data: Unemployment Rate (Seasonally Adjusted) & Resident Long-Term Unemployment Rate (Non-Seasonally Adjusted). They look like this. As individual charts, [...]

Magazine quality charts in Excel 2003

By |September 16th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

I'd like to show you how we run our Excel Charting courses in Aeternus. I promise that after attending our Excel Charting course, your Excel charting skills will definately go up by several notches. As an example, I plucked out [...]