Back to Course Home

Introduction

Thank you for enrolling for this course. The main aim is to teach you a variety of Excel functionalities that will bring you to a strong beginner level in using Excel. The next module that you can subscribe to will build on this one and you can ultimately reach a strong intermediate level. Although the course is designed so that students can follow if they do not have access to Microsoft Excel, you are strongly advised to practice and implement the content of this course in Excel to help transfer the content from only knowledge to skill.

 

A spreadsheet program is defined by Wikipedia as – “an interactive computer application for organization, analysis and storage of data in tabular form. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.”

 

When Excel is opened a screen opens in a Window, and is referred to as a workbook, which is a collection of worksheets and charts. Let us recap on what students were taught in the previous course in the picture below:

 

Note:  Each workbook has worksheets in it.  The default number of worksheets per newly opened workbook is normally three.  (This can be changed if required from the options on the File Tab at the top left of the screen.)

 

The worksheet consists of the following:

 

  • A worksheet area – it looks like a grid and is the work area.  A mouse, or using the arrow keys, “Tab” or ‘Enter” keys on the keyboard, is required to move in the work area
  • Sheet tabs – This is at the bottom of the worksheet and when clicked it will go the next worksheet.

 

The worksheet concepts are described below. (see Figure 1)

 

This reading refreshed your memory of the Excel user interface and will ensure that students can move easily around in Excel

 

The next reading will introduce an effective and efficient manner on saving time by using shortcut menus and keyboard shortcuts