Several tips Excel King. This time in the form of a newsletter with a bit of beauty advice.
NEWSLETTER
You have suttit x number of hours with your Excel report… and soon it shall be distributed to all your colleagues. Furthermore, you have triple checked all the numbers and formulas so that all values are correct. But you also have triple checked HOW figures presented?
Does your Excel file get maximum impact?
In my daily work I have encountered many Excel files that I only barely been able to make me as the presentation itself has been heavily opedagogisk. Immunologic arrays, heavily over-worked format and colors… I simply have not been able to make me content in a quickly and intuitive means.
Early on I realized that the presentation of an Excel file in principle is as important as the content itself. And that the goal of an Excel file that is distributed reasonablymust be it to get as large an impact as possible.
Having said this, I want to of course add that good content is a prerequisiteto it at all should be relevant to send an Excel file.
Men, if the presentation is poor so is the risk that the recipient does not come to terms with the content, no matter how relevant and interesting your numbers are. The result is thus that our Excel file did not get the maximum effect we desired.
It may be difficult to optimize the presentation of Excel. First, it's about trying to give the document a logical structure. Firstly, you have to realize that all recipients are unique. Below I describe two basic rules I myself always working behind in the distribution of Excel Files.
1. The most important content first
Put the most important information / table at the top left, and preferably on the first (vänstersta) tab. Studies show that we first looking on the upper left corner of the screen. Add hence the information to the right so that The key is in the reader's eye-catcher. Internet marketing is working a lot with the structure and how the visitor will accept the contents of the screen.
2. Simple and consistent format
Everyone has different preferences when it comes to color and shape. So you have to find a “lowest common denominator”. Furthermore, it is important to be consistent in the use of format. Otherwise impedes us for the recipient to understand the content.
Consider receiver before you send your Excel file!
It can be difficult to design workbooks that will be distributed, and also there is obviously no right or wrong. But if you continually have the receiver in focus, then I believe you will pretty much.