How to Create a Fishbone Diagram in MS Word

A fishbone diagram depicts the cause-and-effect relationship of a situation or problem. It is typically presented in a pictorial format. That makes it easier to understand the root cause for taking remedial steps.

It is possible to create a fishbone diagram in Microsoft Word using various shapes. Unfortunately, there is no built-in template in Word to create fishbone diagrams.

We will show you simple, step-by-step instructions for creating a fishbone diagram in MS Word.

Let us begin.

Read more

How to Add Days to a Date in MS Excel

Adding days to a date helps determine deadlines. It can simplify various tasks at hand. For example, completing a task 10 days after the previous task. It is also ‌helpful in stock management, to make sure you don’t sit with old stock. 

4 Methods to add days to a date in Microsoft Excel:

  • Add the quantity directly (If the number of days to be added are the same)
  • Use a separate column (When the number of days to be added differs)
  • Use the Paste Special option
  • Use the End of Month formula

Let us begin.

Read more

How to Add Months to a Date in MS Excel

Adding months to dates could be very useful.

For example, you have the manufacturing date of multiple products with the number of months they are viable.

You can calculate the expiry date of the product by adding the number of months from the manufacturing date.

This can be done quickly, using MS Excel.

4 Methods to add months to a date using Microsoft Excel:

  • Use the EDATE function
  • Use the MONTH function
  • Use Microsoft VBA code
  • Use the Fill Series option

Let us begin by looking at each of these methods in detail.


Read more

How to Add Years to a Date in MS Excel

For calculation and data analysis, you may need to add years to a date in MS Excel. For example, to calculate the date of expiration of goods, to analyze the sales of a company after a period of time or to determine your policy’s payout date.

To do this, MS Excel provides several formulas to make this task easy to execute.

3 Methods to add years to a date in Microsoft Excel:

  • Use the YEAR & DATE function
  • Use the EDATE function
  • Use a generic formula

Let us begin.


Read more

How to Calculate Age from Date of Birth in MS Excel

If you have a list of people with their dates of birth, it is possible to calculate their age using a few tricks in MS Excel. While there are no specific functions to calculate age in MS Excel, these methods will work just as good.

4 Methods of calculating age from date of birth using Microsoft Excel:

  • Use the DATEDIF function
  • Use the YEARFRAC function
  • Use Microsoft VBA code
  • Use the logical formula

Let us begin by looking at how to use these methods to get the age from a person’s date of birth.

Read more

How to Create a Family Tree in MS PowerPoint

Creating a family tree in MS PowerPoint has many advantages. A family tree graphically demonstrates the relationships between family members. You can also add photos to individual names and be as creative as you want.

2 Methods to create a family tree using Microsoft PowerPoint:

  • Use Shapes
  • Use SmartArt

We will show you both methods in simple, step-by-step instructions.

Let us begin.

Read more

How to Create a Family Tree in MS Word

A family tree or a pedigree chart is an illustrative diagram. It has components that demonstrate the history of a family. It uses a chart form to show the relationships of the family members. Using the conventional tree format establishes important lineages.

MS Word makes it easy to create family trees. For creating a family tree, you have two choices:

2 Methods to create a family tree using Microsoft Word:

  • Use Shapes
  • Use SmartArt

We will show you both methods in simple, step-by-step instructions.

Let us begin.


Read more

How to Create a Bookmark in MS Word

When reading a physical book, we often place bookmarks before closing the book. Later, these bookmarks help us locate the page we were reading.

You can do the same in an MS Word document.

In fact, you can place several bookmarks to point to specific paragraphs, objects, or images.

Step by Step Instructions to create a bookmark in MS Word

  • Add a Bookmark
  • Go to a Bookmark from the Bookmark Dialog Box
  • Go to a Bookmark from the Go To Dialog Box
  • Link to a Bookmark
  • Make Bookmarks Visible
  • Delete a Bookmark

Let us start.

Read more