Spreadsheet Terms — Spreadsheets Shouldn’t be Scary (Part 5)
Do you ever hear someone talk about cells, or read a blog mentioning workbook and worksheets, and feel a bit lost? Then this post is for you, we’re going to explain some terms to help you understand spreadsheets a bit better.
The entire spreadsheet is often called a workbook (mainly in Excel), a spreadsheet or referred to as a Google Sheet or an Excel (I’m not 100% sure this is correct, but it happens). This is the file which you open either in Excel or in your browser for Google Sheets or Excel Online. Each spreadsheet has a name (which defaults to untitled unless you change it).
Within each spreadsheet, you can create individual sheets (or tabs or worksheets) to store your data, create charts or write formulas. One or multiple of these sheets make up a spreadsheet. They can easily be added (usually by clicking a plus icon at the bottom of the spreadsheet), renamed and deleted.
Each sheet is made up of lots of rectangles which can contain data or formulas, these are called cells. Cells are arranged in rows (vertical) and columns (horizontal). Rows have a number reference.
Columns have a letter reference.
An individual cell reference is made up of a letter (for the column) and a number (for the rows), e.g. A1, G55, AB100.
If you’d like to learn more, we have an Intro to Spreadsheets video as part of our Short and Sweet series for Google Sheets and Microsoft Excel. This 5 minute intro video goes over these terms and some quick steps to getting started with spreadsheets.
— — — — — — — — — — — — — — — — — — — — — — — — — —
Part of our mission over at Taught by Humans is to provide education for humans. By humans. Powered by tech. Recently we’ve been focusing on Spreadsheet Skills. We have a few ways to learn about spreadsheets:
Short and Sweet — up to 5 minute videos explaining a specific topic or task.
Courses — longer courses which can be taken online at your own pace.
Bespoke — training tailored to your needs as a business or individual.
Come learn with us as spreadsheets shouldn’t be scary.
