Audience 

You already know how Excel works in a basic way, but you know that there are many more possibilities. You want to discover and utilize those possibilities. You like to study in a flexible way and want to be able to plan where and when you study.

Approach 

With this online course you can learn at your own pace, at a time and place that suits you best. You will get started with advanced options of Excel. You will learn quickly using professional and English e-learning and associated exercises. With this e-learning you will discover all the ins and outs of Excel, including many tips and tricks on how to work with Excel faster and more efficiently. You will learn, among other things, how to work with references, filters and pivot tables. Within the study program you are flexible in which subjects you want to study. Skip topics you’re already familiar with.

You have access to the e-learning environment for 3 months, which consists of the following components:

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

Prior knowledge 

To follow this course you need prior knowledge of Excel at the level of Excel Basic - Online. This means that you, among other things:

• Can enter numbers and dates
• Can make simple calculations
• Select and copy data in cells
• Can print parts of worksheets

Why choose computrain 

• Develop your skills quickly and efficiently
• Decide for yourself where and when you study
• Immediately apply that what you have learned
• Knowledge that you will remember and can still apply after months

Content 

• 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