#1 Introduction to Excel and Terminology

Microsoft Excel is a very versatile program. Although it is mainly used to process numeric data, (i.e. creating tables, analysing data, inserting formulas, creating charts) it can even be used simply for record keeping like a mini database (i.e. registers or staff records etc).

Before we start it is a good idea to get familiar with Excel related terminology. The diagram below labels all main components that make up an Excel Spreadsheet. You may click the image to view an enlarged version.

• A workbook is the entire file containing all worksheets, charts etc.
• The Office button allows the creation of new workbooks, or open previously saved workbooks, print or save active workbook and go into advanced options.
• The tab brings up a ribbon containing groups of related command buttons.
• Active cell references are shown in the box below the ribbon, on to the right in the formula bar, it shows exactly what is entered in the active cell. 
• A worksheet is the actual sheet containing columns and rows of cells where data may be entered.
• The worksheet tabs allow users to scroll through various worksheets within the workbook.
• The zoom slider allows users to enlarge or reduce the size of the worksheet.