TIMELINES

-
WELCOME TO THE SECOND TERM 2016.


Here you are some useful information to get into timelines this second ter.

How to Make a Timeline in Excel Microsoft Excel Icon

A timeline is a type of chart which visually shows a series of events in chronological order over a linear timescale. The power of a timeline is that it is graphical, which makes it easy to understand criticalmilestones, such as the progress of a project schedule. Timelines are particularly powerful for project scheduling or project management when paired with a gantt chart as shown below.

Timeline example:

Timeline with Milestones

Manually Create an Excel Timeline Template


1.     List your key events and dates in an Excel 2007, 2010, 2013 and 2016 table

  1. List out the key events, important decision points or critical deliverables of your project. These will be called Milestones and they will be used to create a timeline.
  2. In Excel 2007, 2010, 2013 and 2016 create a table out of these Milestones and next to each milestone add the due date of that particular milestone.
  3. To create a timeline in Excel, you will also need to add another column to your table that includes some plotting numbers. Add a the new column next to your milestone description column and list out a repetitive sequence of numbers such as 1, 2, 3, 4 or 5, 10, 15, 20 ect. Excel will use these plotting points to vary the height of each milestone when plotting them on your timeline template.
  4. For this demonstration I will turn the following table into an Excel timeline template, and then I will also use it again make a timeline in PowerPoint.

2.     Make a timeline in Excel by setting it up as a Scatter Bar chart

  1. From the timeline worksheet in Excel, click in any blank cell.
  2. Then from the Excel ribbon, select the Insert tab and in the Charts section of the ribbon, drop down the Bar Chart selection menu.
  3. Select Scatter Chart which will insert a blank white chart space onto your Excel worksheet.
    Choose Scatter Chart

Comments

Post a Comment

Popular posts from this blog

CONJUNCTIONS FOR THE FUTURE

-
Image
In order to extend your knowledge about this topic that is just the incorporation of conjunctions to the already well-known structure of the future tense, I share this information, grabbed, as always, from the best websites to enlarge, reinforce and improve your skills. We can join two sentences using a conjunction. A conjunction is a 'linking' word or phrase. A time conjunction gives us information about when two events happen, relative to each other. Common time conjunctions are: When While As soon as Until After Before During Future with time expressions (after, as soon as, before, till, when, while ... ) The  time clauses  in the English language are introduced by conjunctions such as after, as soon as, before, till, until, when, whenever, while or time expressions such as the minute, the moment etc. We do not use the  future tense  (will) in a time clause to describe future activities (in this respect, it i...
Read more

PARTITIVE NOUNS

-
DEFINITION In  English grammar , a  partitive  is a word or phrase (such as  some of  or  a slice of ) that indicates a part or quantity of something as distinct from a whole. Also called  partitive noun  or  partitive noun phrase . Partitives can appear before  mass (or noncount) nouns  as well as  count nouns . Although most partitive constructions refer to a quantity or amount, some are used to indicate quality or behavior ("the  kind of  teacher who . . .").   See Examples and Observations below. Also see: A Lot (Much, Many) Collective Nouns Determiner Indefinite Pronouns Nouns Quantifier Etymology From the Latin, "relating to a part"   EXAMPLES AND OBSERVATIONS "You must have been warned against letting the golden hours slip by. Yes, but  some of  them are golden only because we let them slip." (J.M. Barrie, "Courage." Rectorial Address deliv...
Read more

MODAL PERFECTS

-
The following is a very useful and comprehensible information about MODAL PERFECTS. Take a deep look at it and improve what we learned in class preparing for the mid-term evaluation next friday 5th August,2016. All modal perfect auxiliary verbs refer to the past. FORM : Modal + Have (Infinitive) + Past Participle 1. must have done = we are almost sure something happened in the past Jane wasn't feeling well yesterday. She must have caught a cold. Bill didn't answer the phone when I called him. He must have fallen asleep. 2. can't have done = we are almost sure something did not happen in the past She can't have forgotten to send you an invitation. I gave her your address. They can't have gone to bed late. They were very tired. 3. may / might / could have done = it is possible that something happened in the past but we aren't sure. Laura hasn't arrived yet. She may/might/could have missed the bus. I didn't see Paul at work. He may/mig...
Read more