Friday, January 16, 2015

Spreadsheets for Data Analysis

To begin the 3rd Quarter, we tackle first Spreadsheets for Data Analysis.

Basically, an excel file is called a Workbook while an excel sheet is called Worksheet. A worksheet is the page where you work on which is made up of grid Cells. Cells are where you input data or formulae into. They are arranged by row and column.
http://www.etektraining.com/

In Microsoft Excel, the top part of your workbook is called the Ribbon. The Ribbon holds different task bars for you to use in working in your excel file such as the name bar, formula bar and other options.







There are some keys that may hell in making your working in excel easier. Here are some.
  • Alt + Enter
  • check "Advanced Options"           
  • Ctrl + ;  or Ctrl + Shift + ;
  • Ctrl + Enter

No comments:

Post a Comment