Tuesday, April 15, 2014

Excel basics

Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets (or worksheets). By default, Excel has three worksheets per workbook. You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.

A spreadsheet has a number of built in features and tools, such as functions, formulas, charts, and data analysis tools that make it easier to work with large amounts of data.

The basic storage unit for a spreadsheet file is a table. In a table, the data is arranged in rows and columns to make it easier to store, organize, and analyze the information.

To open new workbook, follow the steps:
  • Click File -> New.
  • Under New, click the Blank workbook.