How to Add Months to a Date in Google Sheets

Adding months to date helps in fixing future dates or deadlines. It is useful to simplify various tasks, such as determining stock expiry dates.

4 Methods to add months to a date in Google Sheets:

  • Use the DATE function when the number of months to be added is the same.
  • Use the EDATE function when the number of days to be added are different.
  • Use the End of Month function.
  • Use a generic formula (handy only in particular cases).

Let us begin.

Read more

How to Publish an Event on Google Calendar

You can publish an entire calendar on a website for the public to see. Similarly, it is possible to publish a single event on Google Calendar as well. Google makes it easy to do so by providing a link for the event.

We will show you how to create an event on Google Calendar with simple step-by-step instructions. We will also show you how to publish this event.

Let us begin.

Read more

How to Create a Bookmark in Google Docs

If you have a lengthy document in Google Docs, you can make navigation easier by using bookmarks. Bookmarks make it easy to jump to preset points in the document. 

From the table of contents, you can directly go to a specific chapter, or to a bookmark in another document.

3 ways to create a Bookmark in Google Docs

  • Create a bookmark with a link within a document
  • Create a bookmark with a link to another document
  • Remove bookmarks from a document.

We will show you all these options in easy, step-by-step instructions.

Let us begin.

Read more

How to Create a Venn Diagram in Google Docs

Venn diagrams portray the differences and similarities between concepts while displaying their interconnections. 

You can use Venn diagrams for:

  • Comparative analysis, 
  • Problem-solving, and 
  • Demonstrating basic concepts. 

Venn diagrams help to simplify complex ideas by bringing clarity.

We will show you how to create a Venn diagram in Google Docs in easy, step-by-step instructions.

Let us begin.

Read more

How to Insert Superscript in MS Excel

When writing chemical formulas or calculations, you may need to insert a superscript in your Excel spreadsheet.

Not sure how to do it? Don’t worry as there are several methods to insert a superscript. Here are 10 methods that you can use in your Excel workbook. 

10 Methods of inserting a superscript in Microsoft Excel:

  • Use the Font tab in Format Cells
  • Use keyboard shortcuts
  • Use the Superscript option
  • Use the Equation option
  • Use the Ink Equation option
  • Use the Alt key
  • Use the CHAR function
  • Use the Custom option in the Number tab
  • Use third-party websites
  • Use Microsoft VBA code

Let us begin by looking at how each of these methods works.

Read more

How to Create a Tree-Diagram in MS Word

You can use tree diagrams to represent a series of events visually. 

Tree diagrams help to depict many outcomes for a sequence of potential events. Each potential path looks like a different branch of a tree. That is why it is called a tree diagram. You can effectively use tree diagrams for defining probabilities of events.

2 Methods to create a tree diagram in Microsoft Word:

You can create tree diagrams using:

  • Free Shapes
  • Pre-built SmartArt Diagrams

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

Let us begin.

Read more

How to Display Non-printing Characters in MS Word

In any MS Word document, by default, only the characters you type in are visible. 

But Word also places extra characters in the text for formatting. These characters are normally not visible and will not show up when you print the document. Hence, they are known as non-printing characters.

Sometimes, displaying non-printing characters on the screen helps. You can tell where you have added an extra return or inserted two spaces between words. Once you have finished with the diagnosis, you may want to hide these characters again to view your document as it will be printed.

2 Methods to display non-printing characters in Microsoft Word

Word allows you to:

  • Always display selected non-printing characters,
  • Show or hide the non-printing characters.

We will explain the two methods above, and show you their execution in easy, step-by-step instructions.

Let us begin.

Read more

How to Single Space in MS Word

Line spacing is the distance between two lines of text in a document. 

The default line spacing differs in various versions of MS Word. Earlier versions of Word had single spacing, but in 2007, Microsoft changed it to 1.5. In later versions, they reduced the default line spacing to 1.08.

Using a line spacing of 1.0 or single spacing compresses the lines and makes the document difficult to read. You can change the default value to be 1.5 or even 2.0 depending on your requirements. 

Increasing the line spacing makes a document easier to read. But keep in mind that it also increases the length of the document.

3 Methods to change single spacing in Microsoft Word:

You can easily set line spacing in your MS Word document by:

  • Adjusting the line spacing
  • Adjusting the paragraph settings
  • Default line setting for a new document

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

Let us begin.

Read more

How to Create a Flowchart in MS PowerPoint

When you represent a process graphically, this is called a flowchart. A symbol represents each step in a flowchart, and the connecting arrows show the flow.

A simple flowchart follows certain rules:

  • An oval represents a terminal point and indicates the beginning or ending of a process.
  • A hexagon represents preparation and indicates the preparatory stage in a process.
  • A rectangle represents a process and indicates the main steps.
  • A diamond represents a decision and indicates inflection points in the process.
  • Arrows connect all the above and shows the general flow.

2 ways to create a FlowChart in Powerpoint

  • Use shapes
  • Use SmartArt with pre-built images

We will explain both methods in easy, step-by-step instructions.

Let us begin.

Read more

How to Stop MS Excel from Rounding off Numbers

When you type in a large decimal number, MS Excel will likely round off the number. This can be due to several reasons: 

  • The column width is too small
  • The format is set to General instead of Number
  • The number of decimal places to be displayed is set for a lower number.

As a result, it can be annoying when Excel automatically rounds off your numbers. However, you can easily rectify this by using any of the methods given below.

5 Methods to stop Microsoft Excel from rounding numbers:

  • Increase the column width
  • Increase the decimals
  • Format the cells
  • Add an apostrophe
  • Format the number as text

Let us begin by looking at all the methods in detail.

Read more