Creating a Work Breakdown Structure in Excel using SmartArt Graphics, Schemes and Mind Maps of Management Accounting

Download Creating a Work Breakdown Structure in Excel using SmartArt Graphics and more Schemes and Mind Maps Management Accounting in PDF only on Docsity! How to Make a WBS in Excel Step 1: Open Microsoft Excel on your computer. One of the ways to create a basic level of work breakdown structure in Excel is by using SmartArt Graphics. To create a work breakdown structure using SmartArt Graphics, follow the process below. Step 2: Click the Insert tab and navigate to the Illustrations section. After that, select SmartArt Graphics. A dialogue box will open that has different SmartArt Graphics categories, and you can choose a suitable shape for your work breakdown structure in Excel. Step 3: Next, go to the Hierarchy section and select a SmartArt Graphic to construct your work breakdown structure in Excel. After selecting a SmartArt Graphic, click the OK button. The SmartArt Graphic will revamp on the Excel sheet. You can see the Hierarchy SmartArt Graphic revamped on the Excel sheet below. Step 4: Type the title of the first task in the top box of the Excel WBS SmartArt Graphic. The editor will appear beside the SmartArt Graphic, and you can type the content to be displayed in the WBS Excel. Then, move to the boxes below and type the description of the subtask in the editor window. You can manipulate the boxes in the editor window to add new boxes to define more tasks in your work breakdown structure. You can assign different colors to each box as well. Select the box and then click the Change color button.