[FREE EBOOK]Make a Planning Tool in Microsoft Excel by Tommy Axelsson

DOWNLOAD PDF
DOWNLOAD AZW3

Author:Tommy Axelsson [Axelsson, Tommy]
Language: eng
Format: azw3+pdf
Published: 2017-08-19T04:00:00+00:00

Step 5 Design

Let’s make the planer a little more stylish!

See the title in cell “B1”? Let’s make the font a size of 28 and color the background of “A1:BN5” with a green of (Red:34, Green:116, Blue: 71) (or any other color you want). And while we have “A1:BN5” selected let’s change the font color too. Let’s make it white.

Now select cells “B1 to F5” and merge the cells.

To get a little flavor lets copy in the Excel logo (or your own company logo).

We can also add some borders for your Table from “A6:BN100”. I used a light green. I also like to make the border between column “F” and “G” a little thicker to divide the information part and the table part.

Now select “A5:F5” and go to tab “Data” and select “Filter”. This will create filters for all our columns. I normally add more columns like project, responsible and other stuff suited for what I use the planner for. You can easily add columns without messing stuff up by right click on a column from A to F and add a column. The filters we just made will make it easy to filter our table depending on what we want to see. For example:

Only priority “1” Actions/Tasks

Only one or more tasks in a particular status (for example “in progress” or “not planed”)

A particular project

Deadlines in ascending order

And much more

#evba #etipfree #eama #kingexcel

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1