Excel Terminology Youll 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.