Each course in the Opatel Learning Center (OLC) is a combination of self-study and supervised study. You will study and make assignments at your own pace in a multimedia learning environment. A teacher will be present to answer your questions and help you when necessary. This course can always be taken at short notice. Read all about the Opatel Learning Center.
What do you learn during this course?
In this Excel course for beginners you will learn how to make spreadsheets using calculations and formulas. We will cover the look and design of the worksheet and teach you how to make captivating charts to represent your data. Once you have mastered the material, you will sit a certified exam. The average course duration is 14 hours.
Plan your own days
On the first day the trainer will give you access to an online calendar in which you can plan your following sessions.
What are the prerequisites to follow this course?
This beginners course is for those with little or no Excel experience. Not sure which Excel course to take? Call or email for non-binding advice.
For whom is this course intended?
The Opatel Learning Center (OLC) offers efficient courses at short notice. You are not dependant on tight schedules. The OLC is the ideal solution for groups of participants with mixed skill levels.
What is a logical sequal for this course?
Do you like this method of learning? The Excel Advanced course in the OLC seamlessly continues on from this Basics course.
- Excel basics
- Starting Excel and viewing the program window
- The Ribbon and the Quick Access Toolbar
- Opening and closing files
- Navigating through a worksheet
- Creating a new file
- Entering data
- Save a file
- Entering data and creating simple formulas
- Cutting, copying and pasting
- Calculate with simple formulas
- Copying formulas
- Create a simple invoice
- Using a template
- Close Excel
- The help function
- Set options
- Save files as a different type
- Formatting numbers, text and cells
- ont options
- Options for Alignment
- Options for number
- Column width and row height
- Cell Styles
- Inserting columns, rows or separate cells
- Erase formatting and copying formatting
- Fill handle
- Sorting, Searching (duration 30 minutes)
- Find and Replace
- Freeze Panes
- Charts (duration 2 hours)
- Insert and design charts
- Edit chart
- Edit chart parts
- Copy chart
- Page settings and printing
- Page settings
- Scale to page
- Sheet options
- Header and footer
- Calculation functions
- Calculation functions (Extra material/ECDL)
- Absolute and relative cell references
- Absolute en relative cell references (Extra material/ECDL)