Joseph is an old hippy who dropped out of the rat race but then dropped back in to start a successful muffin company. There is still a bit of that free spirit in Joseph, and to reflect this his Excel worksheets are a mass of graphics and bright colours and effects. So how does he do it?
Joseph was a hippy back in the heyday of flower power. He attended various pop festivals where he painted flowers on fellow hippies' faces and danced naked in the rain. He was convinced back then that the way forward was through peace, love and harmony. Soon after this the flowers wilted and Joseph set himself up in business selling rather tasty bran muffins. His hippy ideals went out of the window as he became a hard-nosed businessman in the muffin market.
Although now quite successful there is still a little of the hippy idealist inside Joseph: he wears sandals, listens to The Grateful Dead and adds as much colour as is possible to his Excel charts to remind himself of those carefree psychedelic days.
First of all Joseph ditched that plain old white background. He found a lovely photo of a deserted beach and blue sky, which he thought would be ideal for his worksheet.
Go to Format/Sheet/Background and browse for your selected image in the normal way. If you choose an image that is rather 'busy', then you may have to fill the cells with colour in order to read their contents. To remove the background image go to Format/Sheet/Delete Background. Those plain old gridlines are Squaresville to Joseph so he opts for a far more eye-catching colour.
Go to Tools/Options and select the View tab. In the dialog box click on the small arrow next to the box that says Gridline Colour. Then simply select a colour from the drop down menu in the normal way and press OK. If you are using Excel 2007, click the Office button and then click ExcelOptions/Advanced. Scroll until you find and select the Show Gridlines check box. Click Gridline Colour and choose the colour you want. Click OK.
And while he is doing the gridlines, Joseph may as well add a splash of colour to the border of his chart. Select the area you want the coloured border to appear in. Go to Format/Cells and then select the Border tab. From the colour drop down box select the colour you would like your border to be. Before you leave this dialog box, specify the borders you want then click OK. It is possible using this technique to create a border with a different coloured line on each side.
Joseph has a brightly coloured text box above his chart and he has used a psychedelic font. For that 3D effect he has added a drop shadow to the text box so it looks like it is raised from the worksheet
Make sure that your Drawing toolbar is displayed (View/Toolbars/Drawing) Select the text box you wish to apply the shadow to. On the Drawing toolbar there is a square shaped Shadow Style icon. Click on this and then click on your preferred shadow style from the selection available.
These are just a few ways our friend Joseph brightens up his Excel worksheet to take himself out of the humdrum procedure of entering figures. They bring a little fun to Excel, and there are many more ways to enhance the appearance of charts, graphs and text in an application not generally known for its fun side.
You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
If you do not agree to these terms, please do not use this article.
Hitachi Solutions Europe Facilities Co-ordinator Shazad Khan
"Everything is perfect, from the trainer, location, meal. Can't think of any improvements."
The Salvation Army Committed Giving Co-Ordinator Henry Hutchinson
"It's was great no improvement needed"
The British Academy Deputy Head Of International Programmes Stephanie Appleton
"The session was excellent and very informative, just on a narrower focus than I had anticipated. Maybe this is more to do with communication about the scope beforehand. I found the pace a little bit swift - I tend to need a bit more time to practice things to really have them sink in - but I appreciate that making the session any longer would probably impact on engagement, so there's a balance to be struck."
Excel articles
