Welcome
Welcome to learn to use the Excel spreadsheet software! This course will teach you its essential functions and to use them independently. The course consists of eight pages, each containing tasks, instructional videos, and concise, informative briefs. The material is structured so that the previous pages lay the groundwork for future ones, and the difficulty increases as the course progresses.
During the Basics of Spreadsheets chapter, you will practice using Excel with the help of an exercise workbook, which will be turned in for evaluation at the end of the course. In addition to pre-made exercises, you can also do your own testing in the Excel workbook, for example by adding your own tab. However, please make sure that you have completed all the required tasks.
Learning is the most effective by doing
If the instructions are unclear or you encounter other difficulties, our message board is open for business! You can read more about the message board and learn some more general info at our support page.
The main subjects of Basics of Spreadsheets:
- Terms
- Excel in a Nutshell
- Entering Data and Data Types
- Selecting and Editing Ranges
- Formatting a Table
- Calculus
- Relative and Absolute References
- Charts
- Printing
Task: Let's get the mood right
Let's tune in to the atmosphere by going through the terminology and the most common Excel operations, which we will learn more about as the course progresses.
Excel is a spreadsheet software with which, in addition to calculations, you can e.g. process large lists and make charts. Can you see how you could use Excel in your everyday life? Do you remember if you have come across the software before, for example, around your workplace?
Excel Concepts
The Excel file is called _____. It can have multiple tabs, i.e. _____, each consisting of _____ (A, B, C, etc., last is XFD) and of _____ (1, 2, 3, etc.) of which there are over a million. Single box called a _____. For example, in the upper left corner is cell A1 and below it cell _____. To the right of cell A1 is cell _____.
- workbook
- tables
- columns
- rows
- cell
- A2
- B1
Should we start?