Your result 

After following this course: 

• You can work with Excel without needing any help 
• You know how to use built-in functions flawlessly
• You can create and update tables and graphs
• You know how to edit large amounts of data
• You can use Excel to analyse data 

Audience

You want to be able to work with Excel and make use of all the advanced possibilities. You like to study in a flexible way and want to plan where and when you study.

Approach

With this online course you learn at your own pace, at a time and place that suits you best. You will get started with the possibilities of Excel. You will learn quickly using professional and English e-learning exercises. This way you discover how Excel works and how to perform calculations and create graphs. Within the course program you are flexible in which subjects you want to study.

This e-learning covers the following: 

• English spoken video classes 
• Exercises in the application itself
• Assessments 

Prior knowledge

To take this course you must be able to work with Windows. You can control a computer mouse and know how to open and close files.

Course material 

This training uses an English-language online learning platform with interactive tools and assignments, where specific attention is also paid to tips for independent, online learning.

Content

• Introduction to Excel
• Creating, opening and saving a worksheet
• Moving the cell pointer and entering data
• Selecting, copying and moving cells
• Calculations
• Formatting
• Page settings
• Charts
• Absolute and relative references
• Using functions
• Calculating with date and time
• Searching in tables
• Logical and information functions
• Working with text functions
• Checking formulas
• Conditional formatting
• Links
• Combining data
• Publishing Excel data on a webpage
• Hyperlinks
• Modifying charts
• Using comments
• Sharing a worksheet
• Tracking changes
• Macro security
• Applying and executing macros
• Group and ungroup data
• Overviews
• Lists
• Tables
• Sorting
• Advanced filtering
• Deleting double values
• Calculating, viewing and deleting subtotals
• Creating and refreshing a pivot table
• Adjusting numeric fields’ calculations
• Wizard Text to columns