Aeternus Consulting Blog

Hello, We are Aeternus Consulting
We like to put our tentacles into a lot of things. We teach, consult, design presentations and develop VBA applications & websites.
Blog Articles
BP Oil Spill shown in a Microsoft Excel Chart
This Microsoft Excel line chart illustrates some key events 2 months after the explosion and BP’s stock price using a common Date horizontal axis.
Lollipop approach to clarify Microsoft Excel line charts
Traditional Microsoft Excel line charts have a common problem. It is hard to visually associate the data points with the horizontal axis.
Singapore population infographic in Microsoft Excel
This is an info-graphic I created in Microsoft Excel. It shows the population composition of Singapore in 2009.
Why IT folks hate Microsoft Excel
Yes they do. Which is why you hardly get any good support when you have a problem with it. Try opening a support ticket when you hit a snag with Excel. It won’t see the light of day.
Ugly Real Economic Growth Chart from Singapore Statistics-Part 2
The only way to succeed is to be remarkable, to be talked about.
A gallery of Beautiful Charts for Microsoft Excel part 5
This is part 5 of my on-running gallery of beautiful chart designs which can be re-created in Microsoft Excel.
Microsoft Excel 2007 VBA programming. Automated IP Address Checker
As a service to the Excel user community, I’ve written a niffy little Excel VBA program. This program checks a valid IP address and it returns Country, City and Organization information in seconds!
If you can measure it, you can definitely dashboard it!
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!
Aeternus answers Excel questions on Yahoo Answers!
True to our mission of “Serving the Excel Community”, we have been answering Excel related questions on Yahoo Answers.
Ugly Real Economic Growth Chart from Singapore Statistics.
The folks from SingStats seriously need to improve their charts. I could hardly make any sense out of these charts. They seem to be just thrown together with out any theme or purpose.
A 10 year Balance Sheet Dashboard
Imagine you are the new CFO. You took over the position in the new firm and you want to look at the firm’s latest balance sheet.
Klipfolio, a beautiful dashboard software. Free!
This tiny software features beautifully made dashboards that run on your desktop.