Skip to main content

ONLINE COURSE: ADVANCED EXCEL

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.