• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Excel in Practice

Instead of managing by a table of dates as shown in Figure 23.58, create a table and link the table with an IF(AND formula, conditional formatting, and a dateline to plot the milestone dates for you. By looking at dates sorted in order of occurrence, you can grasp vast amounts of information with just a glance, as shown in Figure 23.59.

Figure 23.58. The typical date table provides limited useful information on a single level.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint