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 new to Excel? Then we also have the right course for you: Basic Excel.
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
Advanced Excel
The program consists of 13 modules where you learn how to use the most important Excel functions. You will learn about built-in functionalities, data analysis, working with large amounts of data and look up lists. The course is for experienced Excel users and requires basic experience with Excel.
MODULE 1 - INTRODUCTION
Introduction to Advanced Excel. Walk-through of course modules and prerequisites.
MODULE 2 - ABSOLUTE REFERENCES IN FORMULAS
- Formulas with absolute references
- Formulas with relative references
MODULE 3 - USE NAMES AND TABLES IN FORMULAS
- Naming cells
- Edit and delete names
- Format as table
- Table name – dynamic formulas
MODULE 4 - FUNCTIONS
Introduction to finding and inserting functions in Excel
MODULE 5 - FUNCTIONS: LOGIC
Functions:
- IF with number calculation
- IF with text
- AND & OR functions
MODULE 6 - FUNCTIONS: NESTED
Learn to use nested functions in Excel
MODULE 7 - FUNCTIONS: IF
Functions:
- IFS
- COUNTIFS
- SUMIFS
MODULE 8 - FUNCTION: ROUND
Learn to use the ROUND function
MODULE 9 - FUNCTIONS: LOOKUP
- VLOOKUP (precise)
- VLOOKUP (interval)
- XLOOKUP (precise)
- XLOOKUP (interval)
MODULE 10 - FUNCTIONS: TIME
Functions:
- WEEKDAY
- NETWORKDAYS
- YEARFRAC+TODAY
- ISOWEEK.NO
MODULE 11 - CONDITIONAL FORMATTING
- Rules for highlighting cells
- Rules for highest/lowest
- Line of data
- Icon sets
- Conditional formatting (with the AND Function)
- Edit and delete conditions
MODULE 12 - DATA VALIDATION
- Control entered numbers
- Droplist with fixed values
- Droplist from cell area
MODULE 13 - PROTECTION
Learn how to protect cells from changes
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.