INTRODUCTION TO EXCEL
Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite.
Excel is a commercial spreadsheet application produced and distributed by Microsoft for Microsoft Windows and Mac OS. It features the ability to perform basic calculations, use graphing tools, create pivot tables and create macros.
Excel has the same basic features as all spreadsheet applications, which use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs.
Excel permits users to arrange data so as to view various factors from different perspectives. Visual Basic is used for applications in Excel, allowing users to create a variety of complex numerical methods. Programmers are given an option to code directly using the Visual Basic Editor, including Windows for writing code, debugging and code module organization.
What is Spreadsheet?
A spreadsheet is primarily designed to provide a digital form of the paper-based worksheet. Spreadsheets work through spreadsheet application software. The rows and columns within the spreadsheet contain cells that are filled with data to create unique operations. A typical spreadsheet program can have multiple functions such as:
- Numerous rows and columns for data and values storage
- Support for mathematical formulas and calculations
- Data sorting and analysis
- Multiple worksheets and their interlinking
- Integration and visualization of data in the form of graphs and charts
A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labeled with letters while rows are usually numbers. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. In Excel 2010, the maximum size of a worksheet is 1,048,576 rows by 16,384 columns.
A workbook is an Excel file that contains one or more worksheets. Each of the workbook’s worksheets is in separate tabs on the bottom of the Excel window. By default, a new Excel workbook will contain three worksheets. You can switch between worksheets by clicking on the worksheet’s tab on the bottom of the Excel window.
A sheet is a single page that contains its own collection of cells to help you
organize your data. There can be many sheets in your Excel document and you can see the sheets listed as tabs along the bottom of your document. In this example, we have three sheets in our spreadsheet – Sheet 1, Sheet 2, and Sheet 3. Each sheet has its own name and you can switch between the sheets by clicking on the name of the sheet you want to view. In the example above, we have selected Sheet 3. Traditionally when you create a new Excel document, three sheets (Sheet 1, Sheet 2, and Sheet 3) are created in the spreadsheet and Excel automatically selects Sheet 1