If You want to make a decision Table in Excel, you have come to the right place. Here, we will walk you through some easy steps to do the task effortlessly.
What Is a Decision Table?
A Decision table gives a firm procedure to represent complex business rules. It has an easy-to-understand layout. The Decision Table can be comprehended by business developers and its users smoothly. A Decision table has three sections, these are conditions, rules, and actions.
How to Make a Decision Table in Excel: 2 Easy Steps
In the following table, you can see the Conditions, Rules, and Actions for Making a Decision Table. In the following article, using these Conditions, Rules, and Actions we will make a decision table. Here, we used Microsoft Excel 365. You can use any available Excel version.
Step-1: Making Outline
In This step, we will make an outline for making our decision table.
- To do so, first of all, we used Borders to make an outline.
Therefore, you can see the structural outline for a decision table.
- After that, we enter the Conditions in cells C6:C8.
- Along with that, we enter the Actions in cell C9:C13.
- Furthermore, we enter 4 employees in cell D5:G5.
Hence, you can see the complete outline of a Decision Table.
Step-2: Inputting Conditions and Actions in Decision Table
In this step, we will input the Conditions entry and Actions entry in the Decision Table.
- In the beginning, we enter the Conditions entry in cells D6:G8.
- Here, we put Yes if the condition is fulfilled, otherwise, we put No.
After that, according to the condition, we will put a Tick mark as an Action entry.
Here, according to rule 1, If a person works for 40 hours in a week, then, he/she will get $400 dollars in a week.
Thus, we will put a Tick mark in cell D9, since employee 1 meets the first condition and, therefore, he/she will earn $400.
- Afterward, to insert a Tick mark in cell D9, we will go to the Insert tab.
- Furthermore, we from the Symbols group >> select the Symbols option.
Then, a Symbol dialog box will appear.
- Furthermore, we will type Windings in the Font box.
- Afterward, we will scroll down until we find a Tick mark >> select the Tick mark.
- Then, click Insert >> click Close.
As a result, you can see the Tick mark in cell D9.
- In a similar way, we put Tick marks in cells G10, F11, and E12.
Here, we put Tick marks only when the conditions are met.
Therefore, you can see a complete Decision Table.
- How to Create a Lookup Table in Excel
- How to Make 3D Table in Excel
- How to Make a Conversion Table in Excel
- How to Create a League Table in Excel
How to Make a Decision Tree in Excel
A Decision Tree is like a flowchart structure that represents conditions, rules, and actions in an easy way. A Decision Tree is used for classification and prediction.
Here, in the following table, you can see the Conditions, Rules, and Actions for Making a Decision Tree. After that, using these Conditions, Rules, and Actions we will make a decision tree.
Step-1: Inserting Rounded Corner Rectangle for Decision Tree
- To insert a Rounded corner rectangle, first, we will go to the Insert tab >> select Shapes.
As a result, a number of Shapes will appear.
- Then, we will select a Rounded corner rectangle.
- Afterward, we will insert the Rounded corner rectangle.
Hence, you can see a Rounded corner rectangle.
Step-2: Formatting Shape
- In the beginning, we will select the Rounded corner rectangle >> go to the Shape Format tab.
This will bring out several numbers of Theme Style.
- Then, we will select the Theme according to our choices.
Hence, you can see the formatted Shape.
- After that, we typed Varsity Admission into our shape.
Thus, the first shape starts our discussion tree.
Step-3: Inserting Conditions and Actions Shapes
In this step, we will insert Conditions and Actions Shapes to make a Decision Tree.
Therefore, you can see the Conditions and Actions Shapes of the Decision Tree.
Furthermore, we will connect the shapes with an arrow.
- To do so, we will go to the Insert tab >> select Shapes.
As a result, a number of Shapes will appear.
- Then, we will select a Line Arrow.
- Afterward, inserting the Line Arrow, we will join the Varsity Admission shape with Condition shape Math Score = 80.
- In a similar way, we connect all the Shapes with Line Arrows according to the Conditions and Actions.
Hence, you can see a complete Decision Tree.
You can download the above Excel file to practice the explained method.
Download Practice Workbook
You can download the Excel file and practice while you are reading this article.
Here, we tried to show you some easy steps to make a decision table in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.
- Create Table in Excel Using Shortcut
- Create a Table in Excel Based on Cell Value
- How to Create a Table with Existing Data in Excel
- How to Create a Table Without Data in Excel
- How to Create a Table with Merged Cells in Excel
- How to Create a Table in Excel with Multiple Columns
- How to Make a Table in Excel with Lines
- How to Create Table from Another Table in Excel
- How to Create Table from Another Table with Criteria in Excel
- How to Create a Table with Subcategories in Excel
- How to Mirror Table on Another Sheet in Excel
- How to Create Table from Multiple Sheets in Excel
- How to Make a Table Bigger in Excel
- How to Create a Table with Headers Using Excel VBA
- How to Add New Row Automatically in an Excel Table