• MS Excel
  • Function Keys

    F1               Displays the Microsoft Office Excel Help task pane. CTRL + F1 display or hide the Ribbon, a component of the Microsoft Office Fluent user interface. ALT+ F1 creates of the chart of the data in the current range. ALT + SHIFT + F1 insert a new worksheet. F2      […]

  • MS Excel
  • Cursor Movement and Shortcut Keys in Excel

    Movement Keys Enter                                                       Move to cell below. Shift + Enter                                           Move to sell above. Page Down                                            Down one screen. Tab                                                          Move to sell to right. Shift + Tab                                              Move to sell to left. Page Up                                                  Up one screen. Ctrl + Any Arroe Key                             Move to end of section. Ctrl + Home                                            Go to first cell […]

  • MS Excel
  • Pivot Table

    Pivot tables are extremely powerful tools for data analysis and pivot charts allow the visualization of that analysis. You will create a pivot table and chart of the data collected from a web survey. This will allow you to find useful information about the patterns in the data and communicate those findings thorough a graphical […]

  • MS Excel
  • Sort and Filter in Excel

    Sorting data is an integral part of data analysis. You might want to put a list of names in alphabetical, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons. Sorting data helps you quickly visualize and understand your data better, organize and find the data that […]

  • MS Excel
  • Creating Charts in Excel

    On the worksheet, arrange the data that you want to plot in a chart. Select the cells that contain the data that you want to use for the chart. On the Insert tab, in the Charts group, do one of the following: (a)  Click the chart type and then click a chart subtype that you […]

  • MS Excel
  • How to Protect Excel Worksheet

    Protect Worksheet Elements Select the worksheet you want to protect. To unlock any cells or ranges that you want other users to be able to change, do the following: Select each call or range that you want to unlock On the Home tab, in the Cells group, click Format and then click Format Cells. On […]

  • MS Excel
  • Charts in MS Excel

      MS Excel provides the charts, explained below: 1. Column Charts Data that is arranged in column or rows on a worksheet can be plotted in a column chart. Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items. In column charts, categories are typically organized […]