Online Excel course – a world of opportunities
No matter what job position you are in today, Excel is often one of the programs you are working with – in one way or another.
What can you use Microsoft Excel for?
Excel is used for calculations as well as all kinds of data processing and data analysis. Excel also works in conjunction with Word and PowerPoint.
You can use Excel for:
- Accounting
- Calculating offers
- Planning
- Data analysis
- Statistics
- Budgets
- Reports
What does the course consist of?
The Advanced Excel online course consists of small video tutorials, where a feature is shown and explained, followed by a small assignment, you have to try yourself in Excel. All example files from the course can be downloaded.
See duration and language options below.
Are you already an experienced Excel user? Then we also have the right course for you: Advanced Excel or Excel Pivot Table.
Why online courses?
Without on-going learning and development, the skills of your employees are quickly outdated. And with outdated skills you risk losing your competitive advantage. With Grape Micro Learning you can quickly build knowledge and grow skills in your organisation.
THE PROGRAM INCLUDES
-
DURATION: 90 MIN.
-
LANGUAGE: DANISH
BASIC EXCEL
The program consists of 9 modules where you learn how to use Excel and the basic functionalites. So, you can work with numbers, calculations and large amounts of data more easily. The course is for beginners and does not require prior knowledge or experience with Excel.
MODULE 1 - INTRODUCTION
Introduction to Basic Excel. Walk-through of course modules and prerequisites. Walk-through of course modules and prerequisites.
MODULE 2 - STRUCTURE OF EXCEL
This module gives the employee a thorough introduction to the interface in Excel. The employee will get a walk-through of the structure of Excel and the most commonly used functionalities.
MODULE 3 - FORMULAS
The module teaches the employee to work with formulas in Excel. The employee will learn how formulas are created, edited and copied as well as using percentage and date calculating formulas.
MODULE 4 - FUNCTIONS
The module teaches the employee to work with the basic functions: AVERAGE, NUMBER, MIN and MAX in Excel.
MODULE 5 - FORMATTING
The module teaches the employee to work with formatting. The employee learns all about cells, frames and formatting of numbers, date and percentage.
MODULE 6 - BIG DATA
The module teaches the employee to work with large amounts of data. The features: sorting, filtering and freezing panes, are all useful tools when working with large amounts of data.
MODULE 7 - CHARTS
The module teaches the employee to work with pie and bar charts.
MODULE 8 - PAGE LAYOUT AND PRINT
The module teaches the employee all about page layout and how to print data from Excel.
MODULE 9 - TIPS & TRICKS
In the last module of the course, the employee gets tips and tricks in the format of shortcut keys and a small quick guide, which can be downloaded and used the next time the employee is working with Excel.
The program has been developed in collaboration with Officekursus.dk, who are specialists within all Microsoft Office programs.
Their skilled Office consultants have developed a range of courses that cater to all levels of learning and development.