Design

This section focusses very much on how to design your spreadsheet document for the best possible presentation. This includes the integration of graphical user interface elements as well as colouring your Excel and applying styles to several areas of your file.

Spinning images

Print
PDF

Written by inservo | 17 February 2010

Okay, folks. Today I want to show you a really cool trick I learned recently. It’s all about images and how to spin them with an Active-X-Control

Read more... Comments (3)

Purpose of a good dashboard and an announcement

Print
PDF

Written by inservo | 08 February 2010

Dear visitors of Excel-King (that is an introduction, isn't it?): During the last days and weeks I wasn't able to post as much to this blog as I wanted to but it was for the greater good! 

Read more... Comments (40)

Conditional styles

Print
PDF

Written by inservo | 12 December 2009

I have played around with one of the cooles features of MSXL 2007 - the new options in conditional formatting. I asked myself, if there could be a way to emulate some of its behavior back in MSXL 2003.

Read more... Comments (10)

Doing matrix paper with conditional formattting

Print
PDF

Written by inservo | 12 May 2009

Do you remember this old two-colored paper that was used in the old dase when there were large printouts from the good old matrix printers? That has to be inserted with the little perforated hole stripes on both sides? If you are - like me - a child of the 80s you will remember those very well.

Read more... Comments (3)

Adding custom colors to Excel

Print
PDF

Written by inservo | 09 May 2009

Imagine that you are doing a report in Excel for a customer / colleague / your boss and you are asked to take care, that it fits perfectly into the corporate identity. How can you enhance the standard colors of MSXL by the ones defined in your corporate design?

Read more... Comments (2)