Microsoft Office

Working with Functions in MS Excel

Functions are the built-in formulas in MS Excel which will let you to perform common calculations on data easily. Functions can be entered in a worksheet using keyboard, AutoSum drop-down menu or Insert Function. You can also learn about Inserting and Positioning Picture in MS Word.

Using Keyboard for Finding the Average:

With the following steps you can calculate the average value of any data by using AVERAGE function.

  • 1st of all select the cell where the result will appear e.g. E5.
  • Now type =av to display the Formula AutoComplete list.
  • Point to AVERAGE function and then double click.
  • Now you need to select the range B5:D5 to insert it as argument to the AVERAGE function.
  • Now you need to press the Enter key.

Using Insert Command to Find the Highest Value:

For finding the highest value you need to follow these simple steps.

  • 1st of all you need to select cell B11 where the answer will appear.
  • Now click Insert Function command and you will notice that Insert Function dialog box will be displayed.
  • Now select MAX in the function list and then click OK.
  • Now type B5:B8 in the Number 1 text box of Function Arguments dialog box and then click OK.

Using AutoSum Drop-down Menu to Find the Lowest Value:

With the following simple steps you can find the lowest value in the range B5:B8 by using AutoSum drop-down menu.

  • 1st of all you need to select the cell B12 where the answer will appear.
  • Now click on the Formulas tab.
  • In the next step you are required to open the AutoSum drop-down menu in the Function Library group and then select Min.
  • Now you need to type the range B5:B8 and then press Enter.

Inserting and Positioning Picture in MS Word

MS Word is a handy application for creating text documents and it is the most widely used text editing application all across the world. With MS Word text documents can be created very easily. In MS Word you can easily insert a picture in your documents so that your documents can be enhanced greatly. You can also learn about Saving and Sharing Documents in MS Word 2013. For Inserting a picture in a document you need to follow these simple steps.

  • 1st of all you need to place the cursor where to insert the picture.
  • Now in the next step you are required to click on the Insert tab.
  • After this click on the Picture command present in the Illustrations group. You will notice that the Insert Picture dialog box will appear.
  • Now you need to browse and select the picture file to insert and then click Insert button.

Positioning the Picture within a Page:

With the following simple steps you will be able to position a picture on page.

  • 1st of all click the picture that is to be positioned. You will notice that Format tab will appear on the screen.
  • Now in the next step you need to click on Position the command on the Arrange group.
  • Now you are required to select a position from the menu. e.g. top right corner or top left corner etc.
  • Once the position is defined the picture will be positioned in your page.

With these simple step you will be able to insert and position the pictures easily.

Saving and Sharing Documents in MS Word 2013

Whenever you create a new document in MS Word you need to know how to save it so that you can easily access as well as edit the document later on. Word documents can be saved on your computer as well as on cloud by using OneDrive. Documents can also be exported and shared directly from MS Word. MS Word offers two different ways of saving the file which are Save and Save As. Both of these options work in a similar manner with just a few minor but important differences. You can also learn about How to Hide your Name and Email Address on Windows Login Screen.

Save: Whenever you create or edit a document you will use the Save the command for saving your changes. This command is used most of the times. When you have to save the file you will need to select a file name and location for the first time and after that you can click the Save command for saving it with the same location and name.

Save As: Save As command is used for creating a copy of a document while you will keep the original. Whenever you use the Save As command you have to select a different name and location for the copied version.

Saving a document:

  • In order to save a document you need to follow these simple steps.
  • 1st of all locate and select the Save command on the Quick Access toolbar.
  • Now if you are saving the file for the very 1st time the Save As pane will appear in the Backstage view.
  • After this you need to select where to save the file and then give it a name. For saving the document to your computer, select Computer and then click Browse. (Alternatively you can click on OneDrive in order to save the file to your OneDrive.)
  • Now the Save As dialog box will appear and then select the location where you need to save the document.
  • Now in the next step you are required to enter the file name for the document and then click on Save.
  • The document will be saved and you can click on Save command again once you modify the document.

Using Save As Command:

Now if you need to save a different version of a document while keeping the original you need to create a copy. For this you are required to click on Save As command in the Backstage View. After this you will need to select the location for saving the file and then need to specify the file name.

Using the AutoRecover option:

For using the AutoRecover option you need to follow these simple steps.

  • 1st of all open MS Word 2013 and if the Autosaved versions of a file are found the Document Recovery pane will appear.
  • Now you need to click to open an available file and the document will be recovered.

Sharing a Document:

In order to share a document you need to follow these simple steps.

  • 1st of all you need to click the File tab to access the Backstage View and then you need to click Share.
  • The Share pane will appear with various different options for sharing the file.

How to Format Text in MS Excel 2007

In MS Excel when you enter the information into your spreadsheet you need to be able to format the information and in this tutorial you will learn how can you use bold, italic as well as underline commands. You can also learn about Clearing History and Cookies in Microsoft Edge Browser.

Formatting Cells:

In order to format the cells you need to follow these simple steps.

Formatting text in bold or italics:

  • 1st of all left click a cell in order to select it or drag the cursor over the text in the formula bar to select it.
  • Now click on the Bold or Italics command.
  • You can select entire columns and rows or some specific cells. In order to select the entire column all you need to do is to left-click the column heading and all the column will be selected.

Formatting Text as Underlined:

  • Select the cell or cells which you need to format.
  • Now click on the drop down arrow next to the Underline command.
  • Now select the Single underline or Double Underline option.

Changing the Font Style:

  • 1st of all select the cell or cells which you want to format.
  • Now left click the drop-down arrow next to Font Style box on the Home tab.
  • Now select the font style from the list.

Changing the Font Size:

  • 1st of all select the cell or cells which you want to format.
  • Now left click the drop-down arrow next to the Font Size box on the Home tab.
  • Now select the font size from the list.

Changing the Text Color:

  • 1st of all select the cell or cells which you need to format.
  • Left click the drop-down arrow next to the Text Color command. You will notice that a color palette will appear.
  • Now select the color from the palette.

OR

  • Select the More Colors and a dialog box will appear.
  • Now select a color and then click OK.

Indenting Text in MS PowerPoint 2013

Indentation is one of the most important features which can be used for changing the way text is appeared on a slide. Indentation can be used for creating multilevel listss or for visually setting the parapgraphs apart from each other. Indenting of text will let you format the layout of text so it will appear in a more organized manner in the slide. Tab key is used for indenting the text quickly and the alternative way of creating an indent is to use Indent commands. With these command the indent can be increased or decreased. You can also learn about WordArt Styles in MS PowerPoint 2013.

Indenting Text using Tab Key:

For indenting the text using tab key you need to place the insertion point at the start of the tline which you need to indent and after that you are required to press Tab key.

Indenting Text using Indent Commands:

For indenting the text by using the Indent commands you need to place the insertion point at the start of the line which you want to indent and then from Home tab you need to press Increase Indent or Decrease Indent command. For decreasing the indent you need to select the line and after that press Shift+Tab.

FineTunning the Indents:

Sometimes there are scenarios where you want to fine tune the indents in your presentations and you can fine tune them by adjusting the indent markers on the ruler. The ruler is hidden by default which means you need to show the ruler first. In order to show the ruler you need to follow these simple steps.

  • 1st of all you need to select the View tab on the Ribbon.
  • Now in the Show group check the box located nex to Ruler and the ruler will appear.

Applying Themes in MS PowerPoint 2013

A theme is a predefined combination of colors, fonts and effects and it can be used in different slide layouts. By default Office theme is applies to all the slides but you can select any other one of your choice froma variety of new themes at any time thus giving your presentation an appealing look. You can also learn about WordStyles in MS Word 2013. Every theme is composed of various themes elements which are as under.

Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts.

Theme Colors: There are 10 theme colors along with darker and lighter variations which are available from every Color menu.

Theme Effects: These effects can be found in the shape styles on the Format tab.

Applying Themes in your Presentation:

In order to apply themes in your presentations you are required to follow these simple steps.

  • 1st of all you need to select the Design tab loacted in the Ribbon menu.
  • Now you need to locate the Themes group and each image represents a theme.
  • Now in the next step you need to click the More drop-down arrow in order to see all of the available themes.
  • Now you need to select the desired theme from the list.
  • Once you select the desired theme it will be applied to the entire presentation.
  • Now for applying a different theme you need to simply select it from the Design tab.
  • With these simple steps you will be able to apply various themes into your presentations.

WordArt Styles in MS PowerPoint 2013

There are many features as well as commands which can be used in PowerPoint for creating some scintillating slides. One of these features is WordArt. WordArt lets you create stylized text with different effects like textures, outlines and shadows etc. MS PowerPoint lets you add various different effects to the text inside of the text box which is called WordArt.You can also learn about Applying Transitions to MS PowerPoint 2010. Now for applying WordArt style to your text you need to follow these simple steps.

  • 1st of all you need to select the text box or select some text in the text box.
  • Now on the Format tab you need to click the More drop-down arrow in the WordArt Styles group.
  • Now a drop-down menu of WordArt Styles will appear and you need to select the style which you want to use.
  • Now text will appear in the style which has been selected now if you desire you can modify the font or font color from the Home tab.

Adding or Modifying the Text Effects:

  • 1st of all you need to select the text box or select some text in the text box. A Format tab will appear.
  • From the Format tab you need to click the Text Effects command in the WordArt Styles group.
  • Now a drop-down menu will appear which will show various different effect categoriesn Now you need to hover the mouse over an effect category and then select the desired effect from the menu which appears.
  • The effect will be applied to your text . You can also combine several different effects .
Go to Top