Teach Yourself Excel Lesson 4 - Definitions

Nick's picture


Definitions

Familiarise yourself with the definitions of the basic components as we'll be referring to them a lot during the course.

  • Ribbon
  • Cell
  • Range
  • Tab
  • Worksheet
  • Workbook
  • Pivot Table
  • Chart

The best way to think of an Excel workbook is one big collection of grids.

Ribbon - The menu at the top with Icons that you can click on

Cell - A single reference on the grid

Range - Several cells

Tab - Place to house cells

Worksheet - All cells on a tab

definitions

Workbook - All worksheets (no easy way to show that)

 

Pivot Table - Summary of data

definitions

 

Chart -

definitions

 

Next Lesson: Teach Yourself Excel Lesson 5 - Sheet Navigation  

Training Video on Definitions of basic components in Excel: