|
|
|
PowerUp Workshop: Making Beautiful Excel Charts
What if you could turn a drabby Excel chart:
into something like this?
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 clear techniques to do so. Compelled by this need, AEternus has designed a PowerUp Workshop to show [...]
Continue Reading
2015 Prediction: Google Docs is the new MicroSoft Office!
I just tried out Google Docs over the weekend and I like what I see. Google Docs is Google’s online version of wordprocessor, spreadsheet, and presentation software similar to Microsoft’s Word, Excel, and PowerPoint programs.
Let me explain why you should pay attention to Google Docs. It might change your life by the year 2015!
Firstly these [...]
Continue Reading
Death by PowerPoint
Excerpts from our workshop & PowerUp Seminar: PowerPoint Design Ideas for the Non Designer.
It is a fact that most presentations suck, and they suck for many reasons.
This seminar is about how to create great looking slides. Making bad slides is easy and we have seen many. Making good slides is easy too, but you need to [...]
Continue Reading
A gallery of Beautiful Charts for Excel part 4
I saw these couple of charts from the Standard Chartered Bank website.
Things I like about it:
Fresh colour scheme. Blues and greens work well together.
Bold titles that explain the intentions of each chart.
Each chart has an Increase/Decrease call out to emphasize the conclusion from the data trend.
Overall it’s a format that is pleasing to the [...]
Continue Reading
A gallery of Beautiful Charts for Excel part 3
The New York Times has the best illustrated charts I have ever seen. They are visually clear, easy to understand with good copy writing to explain the message behind a story. Note the use of blues and orange shades to give visual contrasts.
Continue Reading
A gallery of Beautiful Charts for Excel part 2
I have scoured the web and magazines for beautiful charts designs that we can use in our Excel reports. This will be part of a gallery I am creating. Do visit this blog for regular updates.
Continue Reading
A gallery of Beautiful Charts for Excel part 1
I have scoured the web and magazines for beautiful charts designs that we can use in our Excel reports. This will be part of a gallery I am creating. Do visit this blog for regular updates.
Continue Reading
8 Excel Chart Formatting Tips
Excerpts from the Excel Chart Hacks & Techniques seminar.
I will demonstrate the following chart formatting tips starting from an Excel 2003 default.
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. Adjust chart series colours to get better contrast, remove series [...]
Continue Reading
A crappy chart from the Straits Times. GIC looking to Asia, emerging markets
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 me an absolute headache. This is my list of grouses:
Weak title. What does “ASSET MIX” really [...]
Continue Reading
4 points of Effective Learning for Adults
Malcolm Knowles was a widely known and influential professor of adult education. He said that classroom lecture formats will not work with adults because adults learn in a different way from kids.
Malcom advocated :
Adults need to be involved in the planning of their instruction.
Get your people involved in the training outlines. Ask what problems [...]