Spreadsheets

Microsoft Excel Workbooks are made up of Spreadsheets. A Spreadsheet is organised into  rows and columns of cells. The columns lettered and the rows are numbered. These numbers and letters combine to give each cell an address (e.g A1). All of this is covered in our Beginners Excel Training Course.

The contents of each cell can be entered via the formula bar. This is divided into two parts: the left side of the formula bar shows the cell address, and the right side shows the information that the cell is holding. If you can’t see the formula bar, select the “view” tab in the top menu and click the formula button in the show/hide section.

Excel Formula bar

You can also see the total, mean, maximum or minimum of any numbers or cells by highlighting them and looking at your status bar. This is located at the very bottom of your excel window. If you wish you can also change the information the status bar gives by right clicking on the status bar and choosing its options in the Customize Status Bar Menu.

Excel Status Bar

Excel Status Bar

Similar resources you may like

  1. Tools and Commands
  2. Getting Moving
  3. Highlighting Cells
  4. Submitting Information
  5. Reference Operators

Tags

, , , , , , , , , , , , , , , , , , , , , , , ,

Share This Resource

Bookmark and Share

Leave a Reply

+44 (0)1273 622272

Follow Silicon Beach Training

Categories

Sign up for e-mail offers

Receive reduced-rate offers on our training courses.

Home | Sitemap | Print |