Whether it’s a photograph, an artistic sketch or your logo, images go a long way in making your spreadsheet better. Instead, manually adjust the height and width so that they have just enough white space but not too much to give your presentation some breathing room and improve readability. You need to have flexibility and creative control of your workspace. You should also make sure that the column and row dimensions are the same.Īdditionally, don't autofit the height and width of your document. Leaving the A column and the first row blank. Try to start your presentation on column B, row 2. But when there is breathing space and the spreadsheet is divided up into categories, it becomes more pleasant to the eyes and ripe for interpretation by the brain. When you see tightly packed, clumsy or wordy text or spreadsheet, your brain automatically gets tired of reading it before you even start. To wrap your data or title around the cell, click on the cell then go to the Home toolbar, click on Alignment then select wrap text. Center alignment is not advisable in the data input. The data should have an extreme right alignment for numbers or numerical data and a hard left alignment for texts. Headers should often have center alignment unless it is better at aside. If you want to make your presentation look beautiful and business-like, you will need to maximize the alignment feature. People don’t often use the alignment tool in Excel. This is where the "zebra stripes" rule comes in, which will be discussed later in the post. ![]() a light color text on a dark background and vice versa. You want to create a sharp contrast between the text color and the background colors e.g. You do not want to use more than 2 complementary colors, colors of the same shade, or 2 contrasting colors for your presentation. While this is often emphasized in fashion, it is equally true for designs like Excel presentations. The headers should be larger than sub-headers which in turn should be larger than data fonts. As stated earlier, the header font can be larger. This ultimately depends on your presentation but officially, font 12 is often advised with double spacing to improve readability. If used with the right alignment, spacing, and color, they can bring out the best in your Excel presentation. Calibri, Helvetica, Arial or Playfair are few examples. Here is a quick tip, fonts of the sans-serif group are the best for your Excel spreadsheet if readability is your goal. These are the guidelines to follow in selecting the right format for your font. You can use three fonts in a single presentation and that is the recommended maximum, else you would be pushing it. ![]() Always use a uniform font for your data, you can use the same font for your header or you can change that of the header. Just remember, we want to make it distinct, not isolated.įull transparency: Fonts make or break your spreadsheet. You can also use a different readable for your header. It has to stand out but also blend with the template color scheme and overall aesthetic look. You should center align it and use a different font color. To do this, try a larger font for your header, underline and embolden it. Your header must be able to speak to the reader and make the reader know at first glance what the header is. Your header and title can be anything but it needs to stand out. ![]() After all, what is the use of all the tips you will learn here today if you will not be able to find the worksheet you applied them on? 3. You also must make sure it is distinct from the names of other worksheets stored on your computer. Just make sure it is easy to understand by you or by anyone you will be sharing the file with. It could be a sentence, a phrase or just a word. For this single reason, the importance of a correct and reliable project or worksheet name cannot be overemphasized. Name your worksheets correctlyĮxcel presentation is all about clarity. On the other hand, if you want to know how to make your Excel presentation better on your own, then find someone to teach you or stick around until the end of this post.Ĭheck out our 50 best Excel templates to make your life easier and our 33 Excel business templates for workplace productivity. If getting things done is your priority instead of getting better at designing presentations, then, by all means, use a template and be done with it. Of course, using a template means you will not get better at designing things yourself. Simply enter your values to customize it, and you are ready to go. You can choose from an array of purpose-specific templates with beautiful designs, fonts, and colors. If you are a busy person, and you cannot fit an Excel presentation design into your schedule, enter the ex machina: pre-made Excel templates. Get your certificate today! Start free course Learn Excel essentials fast with this FREE course.
0 Comments
Leave a Reply. |