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.

Google officially announces 10 billion app downloads in Excel

By |December 8th, 2011|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found a pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business [...]

Making Beautiful Excel Charts is Simple

By |December 6th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

Have you ever told yourself that creating great looking Excel charts is hard? Well it's not. You only need to understand the only reason we create charts is to aid comprehension of a trend. Once you understand this, you can [...]

BP Oil Spill shown in a Microsoft Excel Chart

By |July 12th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

On 20 April 2010, a BP oil well exploded in the Gulf of Mexico, causing the largest offshore spill in U.S. history. This Microsoft Excel line chart illustrates some key events 2 months after the explosion and BP's stock price [...]

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 [...]

PowerUp Workshop: Making Beautiful Excel Charts

By |January 4th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

What if you could turn a drabby Excel chart: into something like these? For many Excel users, there is a need to produce clear, concise and even attractive charts in Excel without using expensive software. What is lacking are the [...]

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 New York Times Chart in Excel

By |September 23rd, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

I was surfing the web and came across this chart from the New York Times. My attention was totally captivated by this intricate chart. It says that healthy food are getting more expensive while junk foods are getting cheaper! What's [...]

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 [...]