• Skip to main content
  • Skip to primary sidebar

Tux Tech

Leading IT Tutorials Platform

Exploring Charts in MS Excel 2007

Chart is a tool which is used in MS Excel for communicating the data graphically. With charts you can see the meaning of of each number in the spreadsheet. With charts you can show the comparisons as well as trends easily. In the following tutorial you will learn how to work with charts in MS Excel 2007. You can also learn about Slide Master View in MS PowerPoint 2016.

Creating a Chart:

In order to create a chart you need to follow these simple steps.

  • 1st of all you need to select the worksheet which you need to work with.
  • Now you need to select the cells which you want to chart. This include the column titles and row labels.
  • Now you are required to click on Insert tab.
  • Now you need to hover over the Chart options in the Chart group in order to learn more about it.
  • Select one of the Chart options.
  • Select the type of chart from the list that appears.

Parts of the Chart:

Charts are actually the visual representation of the data in a worksheet. Charts will make it very easy to see comparisons, patterns and trends in the data. The parts of the chart are as follows.

Title: It is the title of the chart.

Legend: It is the chart key which will identify what each color on the chart represents.

Axis: Axis is the vertical or the horizontal parts of the chart. The vertical axis is often referred to as the Y-axis and the horizontal axis is referred to as the X axis.

Value axis: Value axis is the axis that represents the values of the source data.

Category Axis: the axis the identifies each data series.

Chart Tools:

Once you are inserted the chart you will notice a new set of Chart Tools which are arranged into three tabs will appear above the Ribbon. These tools will only appear when the chart is selected.

Changing the Chart Type:

In order to change the chart type you need to follow these simple steps.

  • 1st of all select the Design tab.
  • Now click on the Change Chart Type command. You will notice that a dialog box will appear.
  • Now select another chart type.
  • Click on OK.

Changing the Chart layout:

  • 1st of all you need to select the Design tab.
  • Now locate the Chart Layouts group.
  • Click on More arrow in order to view all of your layout options.
  • Now left click on the layout in order to select it.

Changing Chart Style:

  • Select the Design tab.
  • Now you need to locate the Chart Style group.
  • Click on the More arrow in order to view all of your style options.
  • Left click on the style in order to select it.

Moving the Chart to a Different Worksheet:

  • 1st of all select the Design tab.
  • Now click the Move Chart command and you will notice that a dialog box will appear. The current location of the chart is selected.
  • Now you need to select the desired location for the Chart.

Slide Master View in MS PowerPoint 2016

Whenever you change the theme of your presentation you will notice that the texton your slides have changed and there are some new shapes that have been added into your slides. This is because every slide has got built-in slide layouts and some background graphics. These layouts can be modified easily with a feature known as Slide Master view. Slide Master is a feature in MS PowerPoint which will let you modify the slides as well as slide layouts quickly. From this feature you can edit Slide Master which is consequently affect each slide present on your presentation. You can also modify individual slide layouts which will modify any slide using those layouts. You can also learn about Inserting Audio Content into Your Presentation in MS PowerPoint 2016.

Making Changes to All the Slides:

In order to make changes into your slides you need to follow these steps.

  • 1st of all you need to select the View tab and then you need to click the Slide Master command.
  • Now the presentation will switch to the Slide Master view and the Slide Master tab will be selected on the Ribbon.
  • Now from the left navigation pane you need to scroll up and select the 1st slide. This is the slide master.
  • Now you need to make all the desired changes to the slide master like inserting a picture etc.
  • Now move, resize or delete slide objects as required. When you are done you can click the Clode Master View command on the Slide Master tab.
  • The change will appear on all the slides of the presentation.

Customizing An Exisitng Slide Layout:

  • 1st of all you need to navigate to Slide Master view.
  • Now you need to locate and select the desired layout from the left navigational pane.
  • Hover the mouse over each layout to see which slides are currently using that layout in the presentation.
  • In some of the layouts the background graphics may be hidden. In order to unhide the graphics you can uncheck the box next to the Hide Background Graphics.
  • Now add, move or delete any objects.
  • If you need to change the arrangement of the placeholders you can move, resize or delete any one of them.
  • Once you are done click on the Clode Master View command on the Slide Master tab.
  • You will notice that all the slides using the layout will be updated.

Inserting New Slide Layout:

  • 1st of all you need to navigate to Slide Master view.
  • From the Slide Master tab you need to click the Insert Layout command.
  • Now you will notice the new slide layout will appear.
  • The layout will include the title and footer placeholder by default.
  • Click the Title and Footers boxes in the Master Layout group to toggle the placeholders ON and OFF.
  • You can add the background graphics, shapes and pictures to the slide layout. You can move, adjust and delete the existing placeholder.
  • In order to add new placeholdes you need to click the bottom half of the Insert Placeholder command and then select the desired placeholder type.
  • Now you need to click and drag to draw the placeholder on the slide.

Inserting Audio Content into Your Presentation in MS PowerPoint 2016

MS PowerPoint allows you to add the audio content into your presentations like you can add the background music into one slide and a sound effect into another slide. You can also record your own commentary and narration. The added audio content can also be edited. You can also learn about Line and Paragraph Spacing in MS Word 2016.

Inserting the Audio File from a File:

In order to add an audio file from File you need to follow these simple steps.

  • 1st of all you need to click Audio from the Insert tab. And after that select Audio on My PC.
  • Now locate and select the desired audio file and after that click Insert.
  • You will notice that the audio file will be added into your slide.

Recording Your Own Audio:

There are scenarios where you have to record your own voice into your presentation like you may want to add the narration into your presentation. You need to make sure that you have got a microphone which is compatible with your computer.

For recording the audio content you need to follow these simple steps.

  • 1st of all you need to click on Audio drop down arrow from the Home tab and after that select Record Audio.
  • Now you need to type a name for the audio recording if you need.
  • Now you are required to click on Record buton for starting the recording process.
  • Once you are finished click the Stop button.
  • Now for previewing the recording you are required to click the Play button.
  • Now click OK when you are done. The audio will be added into your slide.

Previewing Audio File:

In order to preview the audio file follow these steps.

  • 1st of all click on an audio file to select it.
  • Now click the Play/Pause button below the audio file. The sound will start playing and the timeline located right next to the Play/Pause button will advance.
  • In order to jump to a different part of the file you need to click anywhere on the timeline.

Moving an Audio File:

  • Click and drag to move the audio file to the new location on a slide.
  • Deleting Audio File:
  • Select the audio file which you need to delete and after that press the Backspace or Delete key from your keyboard.

Trimming an Audio File:

  • 1st of all selelc the audio file and after that click the Playback tab on the Ribbon.
  • Now click on the Trim Audio command.
  • You will notice a dialog box will appear. You need to use the green handle to set the start time and the red handle to set the end time.
  • In order to preview the audio file you need to click the Play button.
  • Now adjust the handles once again if necessary and then click on OK.

Adding Fade in and Fade out:

  • From the playback tab you need to locate the Fade In: and Fade Out: fields.
  • Now you need to type the desired values or use the up and down arrows for adjusting the times.

Line and Paragraph Spacing in MS Word 2016

MS Word is the world’s leading text editor developed by MS Office . While creating a text document you have to consider the line and paragraph spacing. You can easily increase the spacing to enhance the readability and can also reduce it in order to fit more text on the page. Line Spacing is the space between each line in the paragraph. MS Word lets you customize the line spacing to be single spaced, double spaced or any other amount. You can also learn about Tables in MS PowerPoint 2016.

Formatting Line Spacing:

In order to format the line spacing you need to fiollow these simple steps.

  • 1st of all you are required to select the text which you need to format.
  • Now on the Home tab you need to click the Line and Paragraph Spacing command.
  • After this you need to select the desired line spacing.
  • The line spacing will change in the document.

Fine Tuning the Line Spacing:

When it comes to line and spacing options you are not limited to the Line and paragraph Spacing menu. For adjusting the spacing with accuracy you need to select Line Spacing Options from the menu in order to access the paragraph dialog box. After this you will have few additional options which can be used for customizing the spacing.

  • Exactly: This option the line spacing is measured in points for example font size.
  • At least: This application allows you to selelct the points of spacing which you need. However if you have various different sizes of the text on the same line, the spacing will expand in order to fit the larger text.
  • Multiple: Multiple option allows you to type the number of lines of spacing you want like selecting Multiple and changing the spacing to 1.2 will make the text a bit more spread out than the single-spaced text. If you need the lines to be closer together you can select smaller value for example 0.9.

Paragraph Spacing:

Like line spacing in your document you can also adjust spacing before and after paragraphs. This feature comes in handy for separating paragraph, heading and subheading.

Formating Paragraph Spacing:

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

  • 1st of all you are required to select the paragraph which you need to format.
  • Now from the Home tab you need to click the Line and Paragraph Spacing command.
  • Now click Add Space Before Paragraph or Remove Space after Paragraph from the drop-down menu.
  • From the drop-down menu you can also select Line Spacing Options for opening the Paragraph dialog box. From here you can control how much space there is before and after the paragraph.

Tables in MS PowerPoint 2016

Tables are the tools which can be used for displaying the information in MS PowerPoint. A table is actually a grid of cells which are arranged in rows and columns. Tables can be used for various different tasks which includes presenting the numerical data and text information. You can also learn about Shapes in MS PowerPoint 2016.

Inserting a Table:

  • 1st of all you need to click on Table command from the Insert tab.
  • In the next step you need to hover the mouse over the grid iof squares to select the desired number of columns and rows in the table.
  • You will notice that a table will appear on the currently selected slide.
  • Now click anywhere in the table and then begin typing to add text. You can also use the Tab key or the arrow key on your keyboard for navigating through the table.
  • You can also insert the table by simply clicking the Insert table command in placeholder.

Moving a Table:

  • Click and drag the edge of the table in order to move it to a new location on a slide.

Resizing a Table:

  • Click as well as drag the sizing handles till the table is of the desired size.

Adding a Row or Column:

  • 1st of all click a cell adjacent to the location where you need to add a row or column.
  • Now click on the layout tab on the right side of the Ribbon.
  • Now you need to locate the Rows & Columns group. Now if you need to insert a new row then select either Insert above or Insert Below.
  • If you need to insert a new column, select either Insert Left or Insert Right.
  • Now you will notice that the new row or column will appear.

Deleting a Row or Column:

  • 1st of all you need to select the desired row or column.
  • From the layout tab in the Rows & Columns group and click the Delete command and then select Delete Rows or delete Columns from the menu.
  • You will notice that the selected row or column will be deleted.

Deleting a Table:

  • Click the edge of the table which you need to delete and after that press the Backspace or Delete key on your keyboard.

Applying a Table Style:

  • 1st of all select any cell in your table and then click the Design tab on the right side of the Ribbon.
  • Now locate the Table Styles group and after that click the More drop-down arrow in order to see the available table styles.
  • Now you need to select the desired styles.
  • You will notice that the selected table style will be applied.

Changing the table Style Options:

  • First of all select any cell in your table.
  • Now from the Design tab you need to check or uncheck the desired options in the Table style Options group.

Shapes in MS PowerPoint 2016

Shapes are something which will make your PowerPoint presentation very compelling and interesting. MS PowerPoint will provides you loads of different shapes to choose from and these shapes can be customized in order to suite your needs by using your own color palette and preferences. While you may require the shapes in all the presentations you create as they can make your presentations visually very appealing. You can also learn about Using Find and Replace in MS Excel 2016.

Inserting a Shape in MS PowerPoint:

In order to insert the shape in your MS PowerPoint presentation you need to follow these simple steps.

  • 1st of all you ar required to select the Insert tab and then click the Shapes command in the Illustrations group. You will notice that a drop-down menu of shapes will appear.
  • From this menu you need to select the desired shape.
  • Now you need to click and drag in the desired location to add the shape to the side.

Modifying a Shape or Text Box:

Whenever you click on the shape or the text box you will notice that handles will appear which will allow you to manipulate the shape. The handles are of different types which include Sizing handles, Rotation handles and Yellow handles.

Sizing Handle: Click and then drag on the sizing handles till your shape or the text box is of the desired size. Corner sizing handles can be used for changing the height and width simultaneously.

Rotation Handles: Click and drag the rotation handle in order to rotate the shape.

Yellow handles: Some shapes have got one or more yellow handles which can be used for customizing the shape.

Changing the Shape Style:

In order to change the shape style you ar required to follow these simple steps.

  • 1st of all you need to select the shape or the text box which you need to change.
  • From the Format tab you ar required to click on More drop-down arrow in Shape Styles group.
  • You will notice that a drop-down menu of styles will appear and from this menu you need to select the style which you need to use.
  • You will see the shape or text will appear in the selected style.

Changing the Shape Fill Color:

  • 1st of all select the shape or text box you need to change.
  • On the Format tab you need to click the Shape Fill drop-down arrow. You will notice that Shape Fill menu will appear.
  • Now you need to move the mouse over various colors. Select the color which you need to use.
  • In order to view more color options you need to select More Fill Colors.
  • You will notice that the shape and text box will appear in the selected color.

Changing the Shape Outline:

  • 1st of all select the shape or text box which you want to change.
  • Now you need to click the Shape Outline drop-down arrow from the Format tab and you will see the Shape Outline menu will appear.
  • Now select the color which you need to use.
  • If you want the outline to be transparent you need to select No Outliine.
  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • Go to Next Page »

Primary Sidebar

  • How To Guides
  • Privacy Policy
  • Terms of Service

Recent Posts

  • Working with Pictures in MS Publisher 2010
  • Working with Shapes and Objects in Publisher 2010
  • Text Basics in MS PowerPoint 2013
  • Worksheet Basics in MS Excel 2013
  • Entering and Editing the Data in Tables in MS Access 2007
  • Applying the Styles and Themes in MS Word 2007
  • Exploring Charts in MS Excel 2007

© Copyright 2017 All Rights Reserved ·