Microsoft Office

Grouping and Ungrouping Worksheets in MS Excel

A Workbook in MS Excel is a multi page Excel document which is composed of various worksheets. Now most of the itime you are required to work with various different workbooks at the same time. It is only possible if you group the multiple worksheets. With grouping you can apply identical formulas and for formatting across all worksheets in the group. You can also learn about Changing the Sizes of the Icons in Windows 10.

Grouping of Worksheets:

For grouping the multiple worksheets you are required to follow these simple steps.

  • First of all you need to click on Sheet tab for selecting one worksheet.
  • Now for selecting more than one worksheet you are required to hold down the Control key and after that click on multiple sheet tabs in the workbook.
  • Now for selecting all the worksheets in the workbook you are required to right click any worksheet tab and then choose Select All Sheets from the shortcut menu.
  • With these simple steps you will be able to group multiple workbooks. When you are done with entering, formatting, moving, and copying the data you need to ungroup the worksheets.

Ungrouping Worksheets:

In order to ungroup the worksheets you are required to follow these simple and easy steps.

First of all you need to right click on any of the selected worksheet tabs.

Now you need to Ungroup Sheets from the shortcut menu.

Moving the Worksheets:

Now moving the worksheets from one place to another you need to follow these steps.

  • Select the worksheet which you want to move.
  • Now select Edit>Move or Copy from the menu bar.
  • Now in the Move or Copy dialog box you have to use drop-down boxes for selecting the name of the workbook which you will move the sheet to.
  • Now check Create a copy for copying it.
  • Now you need to click OK button for moving the worksheet to the new location.
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.
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.