Author Archives: Jesper

Simple in-cell graphing with Excel

Version: Tested with Excel 2003 Keywords: in-cell graph, in-cell chart, text chart graph In-cell graphs are built in Excel 2007, but these are notorously hard to read and actually does more to confuse the reciever than anything else. There are … Continue reading

Popularity: 3% [?]

Comments Off

Replacing Excel default data points with custom images/symbols

 Version: Tested on Excel 2003. Keywords: Excel, data points, custom images, change default It is surprisingly easy to change the somewhat boring, default data points in excel to something more of your own taste and imagination. Here’s how to do it: 1. Create … Continue reading

Popularity: 2% [?]

Comments Off

Eight fundamental ways to improve your Blog

Summary:This article covers eight important features and considerations to improve usability and the reader confidence for your blog. This post is largely based on Jacob Nielsens ideas about writing and presenting content on Internet. The focus is on usability, and … Continue reading

Popularity: 2% [?]

1 comment

Effective writing and layout for your blog

Internet users, and blog readers, generally don’t like to read long, winding texts, so cut your writing in half. Make sure your content is scannable and properly structured, starting with the conclusion and then the supporting information. I’ve been reading … Continue reading

Popularity: 2% [?]

Comments Off

Output formatting in Excel: average value and confidence interval in one cell

Keywords: cell formatting, two values in one cell, average value, confidence interval Version: Should work in any Excel version from Excel 97 and forward. Sometimes it is useful to have the output from your excel sheets arranged in such a … Continue reading

Popularity: 5% [?]

Comments Off