Team OfficeBeginner

How to Insert Superscript in MS Excel

by

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

by

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

by

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 Specific 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

by

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

by

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

by

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

How to Round off Decimals in MS Excel

by

Rounding off decimals helps to improve the readability of your information. It is also simpler to work with numbers where the decimals have been rounded off. It is also very helpful when exact values are not required.

4 Methods to round off decimals in Microsoft Excel:

  • The ROUND function
  • The ROUNDUP function
  • The ROUNDDOWN function
  • The MROUND function

Let us begin by looking at each of these methods.

Read more

How to Convert CSV to MS Excel

by

A CSV file is a very basic file that stores data in a simple format, separated by commas. That is why it is called CSV – comma-separated values.

In contrast, MS Excel saves data in spreadsheets with formatting and formulas. It is best to convert a CSV file into Excel to make use of the information.

2 Methods to convert a CSV file to Microsoft Excel:

  • Save As option
  • Data Import option

Let us begin.

Read more

How to Combine MS Word Documents

by

Combining the contents of Microsoft Word documents should be easy. Simply copy and paste one document into the other. This method works well, provided the documents are small.

The copy and paste method becomes tedious when the documents are large. It is even more tedious when merging several large documents.

MS Word makes it easier to combine many documents with a simple method. We will show you this method with easy, step-by-step instructions.

Let us begin.

Read more

How to Create a Fishbone Diagram in MS Word

by

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