Categories
Microsoft Office

Charts in MS PowerPoint 2016

Chart is a tool which can be used for communicating the data graphically. Charts will make it very easy to visualize the comparisons and trends. PowerPoint has got several types of charts letting you to select the one which fits your data the best. For using the charts in PowerPoint effectively you need to understand about different types of charts. You can also learn about Inserting Video in MS PowerPoint 2016.

Column Charts are the ones made up of vertical bars which represent data. Column Charts work with various different types of data but they are mostly used for comparing the information.

Line Charts are the ones which are ideal for showing the trends. All the data points are connected with lines thus making it very easy to see whether the values are decreasing or increasing over time.

Pie Charts are the ones which are used for comparing the proportions. Every value is shown as a lice of the pie thus it is very easy to see which values make up the percentage of a whole.

Bar Charts are the ones which are similar to the column charts but the difference is that they use the horizontal bars in place of vertical bars.

Area Charts are the ones which are similar to the line charts except the areas under the lines are filled in.

Surface Charts are the ones which will elt you display the data across a 3D landscape. These charts will work best with the large data sets this letting you to see a wide variety of information simultaneously.

Inserting a Chart in a Presentation:

MS PowerPoint uses a spreadsheet as a placeholder in order to enter the chart data like MS Excel. The process of entering the data is the very simple but if you are not familiar with Excel you need to review your knowledge about MS Excel.

For inserting the charts in a PowerPoint presentation you need to follow these simple steps.

  • 1st of all you need to select the Insert tab and then click the Chart command in the Illustrations group.
  • A dialog box will appear where you need to select the Category from the left pane and review the charts which appear in the right pane.
  • Now select the desired chart and then click OK.
  • Now a chart and spreadsheet will appear and the data that appears in the spreadsheet is placeholder source data and you will replace with your own information. The source data is used for creating the chart.
  • Now you need to enter the data into the worksheet.
  • Only the data enclosed by the blue lines will appear in the chart and this area will expand automatically as you type in.
  • Once you are done with it just click X in order to close the spreadsheet.
  • The chart will be completed.
Categories
Microsoft Office

Inserting Videos in MS PowerPoint 2016

MS PowerPoint is an amazing application which can be used for creating some stellar presentations. PowerPoint lets you insert videos onto yourslides and then also lets you play it during your presentations. After inserting videos your presentations will become more captivating to your audience. Once the video is inserted you can easily edit the video within PowerPoint and then customize it’s appearance. You can also learn about Using OneDrive with Windows 8.

Inserting a Video from a File:

In order to insert the video from file you need to follow these simple steps.

  • 1st of all go to the Insert tab and then click on Video drop-down arrow. After this select Video on My PC.
  • Now you need to locate and select the desired video file and then click Insert.
  • Now the video will be added to the slide.

Inserting an Online Video:

Many websites like YouTube lets you embed the videos into your slides. The embedded videos will still be hosted on it’s original website which means the video itself won’t be added to your file.

Previewing a Video:

For previewing a video you need to follow these simple steps.

  • 1st of all you need to click a video for selecting it.
  • Now click the Play/Pause button located below the video. The video will begin playing and the timeline next to the Play/Pause button will advance.
  • In order to jump to a different part of the video you need to click anywhere on the timeline.

Resizing a Video:

1st of all you are required to click and drag the corner sizing handles till your video is of the desired size.

Categories
Microsoft Office

Creating Reports in MS Access 2010

If you are required to share the information from your database with someone but you don’t want that person to work with your database you can consider creating reports. With reports you can easily organize as well as present data in a very reader-friendly and visually appealing format. MS Access 2010 will make it very easy to create as well as customize a report by using data from any query or table in your database. You can also download Applying Hyperlinks to your Text in MS Word 2016.

Creating Reports:

MS Access 2010 lets you create the reports from tables and queries. For creating reports you need to follow these simple steps.

  • 1st of all you need to open the table or query which you want to use in your report.
  • Select the Create tab from the ribbon and then locate the Reports group.
  • Now you need to click the Report command.
  • MS Access will create a new report based on your object.
  • Some of your data may be located in the other side of the page break. In order to fix this you need to resize the fields.
  • Select the field and then click and drag its edge till the field is of the desired size.
  • Repeat with additional fields until all your fields fit.
  • For saving your reports you need to click the Save command on the Quick Access toolbar.
  • Whenever prompted you need to type a name for your report and after that click OK.

Deleting Fields:

You may find out that your report has got some fields which you don’t want to view so you need to delete the fields. For deleting the fields you are required to follow these simple steps.

  • 1st of all you need to click any cell in the field which you want to delete.
  • Now press the Delete key for deleting the required fields.