[FREE EBOOK]Make a Planning Tool in Microsoft Excel by Tommy Axelsson - EBOOKS AND TIPS FREE

EBOOKS AND TIPS FREE

Ebooks and Tips free for you.

Trang

Saturday, March 21, 2020

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

[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

No comments:

Post a Comment