Timeline Excel Tutorial

1. Open your Excel worksheet.
2. Click the “Insert” tab on the command ribbon.
3. Click the “SmartArt” button in the Illustrations group. A dialogue window opens prompting you to choose a SmartArt graphic.
4. Click “Process” on the left pane to open the Process gallery, which includes timelines.
5. Click a graphic, such as “Basic Timeline.” A larger, detailed view of the graphic and a description appear in the right pane of the dialogue window.
6. Click “OK.” The selected graphic appears on the worksheet. The “SmartArt Tools” ribbon displays the “Design” and “Format” tabs.
7. Click the “[Text]” area. Type in the bracketed text areas.
8. Customize the graphic by clicking the command buttons in the “Design” and “Format” tabs. The “Design” tab contains “Layouts” and “SmartArt Styles.” The “Format” tab contains “Shape Styles” and “WordArt Styles.”
9. Save this file.