Excel Terminology You’ll Need

Workbook: An Excel file which includes one or more worksheets (tabs)

Worksheet: A single page inside a workbook which consists of cells   

Cell: The intersection of a column & a row is a cell

Cell Address: Each cell has an address (e.g. C3, column= C, row=3)

Formula Bar: Shows the formula written in the selected cell or the cell value (if no formula is written)

Name Box: Shows the address of the selected cell

Range: A group of cells

Range Address: Starts from the top left-hand corner to “:” bottom right-hand corner (e.g. C3:D6)

Shortcuts Learnt in This Section

[Ctrl] [▼] – Jump to the bottom of the current data region in a worksheet

[Ctrl] [►] - Jump to the right of the current data region in a worksheet

[Ctrl] [Home] - Jump to cell A1

[Ctrl] Mouse wheel – Zoom in on the cells

[Ctrl] S – Save Workbook

[Esc] – Leave Backstage view (File Tab)

[Ctrl] Z – Undo previous action

[Ctrl] Y – Redo previous action

Most Common Features For Every Tab

File: Also called Backstage View – Save, Open, Pin documents & Print

Home: Formatting options as well as most common Excel features     

Insert: Insert Charts, Tables, PivotTables (Sections 11 & 12)

Page Layout: Prepare for Printing (Sections 9 & 10)

Formulas: Overview of Excel Functions (Section 6)

Data: Get & Transform Data (Section 13)

Review: Spell check, Protect worksheet (Section 4)

View: Remove Gridlines

Developer: For Advanced Excel users who use VBA

Help: Get Help, provide feedback & suggest new features

Remember: Your downloadable course notes cover the most important points. Make sure you keep them handy.