You will learn
On this Excel Advanced course, you will build on the skills covered in our Excel Experienced course and learn how to work with more advanced calculations, data analysis and user-friendly spreadsheet solutions.
The course is designed for experienced Excel users who want to make better use of Excel's advanced tools. You will work with dynamic calculations, Power Query, advanced formulas and functions, database tools, controls and recorded macros.
The focus is on giving you practical skills that can help you work more efficiently with data and create more flexible Excel solutions.
After the course, you will be able to:
- Build complex formulas using dynamic ranges.
- Import, transform, compare, merge and perform calculations on data from a wide range of sources using Power Query.
- Find specific data using the Advanced Filter.
- Build worksheet models or templates using user-friendly controls.
- Automate tasks using recorded macros.
You can find a complete overview of the topics covered under Course Details further down the page.
See also our full selection of Excel courses.
You get
Before the course
- The opportunity to speak with an instructor who can help you determine whether this is the right course for you.
During the course
- Training by an experienced instructor team with many years of experience in Excel.
- Practical training that combines theory with hands-on exercises.
- Course material that you can use as a reference after the course, as well as course exercises.
- Training in our classrooms in central Copenhagen.
- Full catering including breakfast, freshly brewed coffee, tea, fruit, soft drinks, lunch at a nearby restaurant, cake and sweets.
- A course certificate documenting your participation and new skills.
After the course
- Access to our free hotline for up to one year, where you can contact us with questions about the topics covered during the course.
- Our satisfaction guarantee, giving you extra reassurance that you will get the full benefit of your course.
Get the best benefit from the course
This Excel Advanced course is designed for experienced Excel users who want to work with more advanced calculations, data analysis and automation.
We recommend that you have completed our Excel Experienced course or have equivalent knowledge of the topics covered on that course.
The course is taught in English and is part of our selection of English conducted courses.
Course Details
Module 1: Functions
Built-in functions can make it easier to perform and automate advanced calculations in Excel. In this module, you will work with functions and learn how they can be combined within formulas.
You will also work with Excel's Function Wizard and get tips for building formulas with functions.
The following topics will be covered:
- Functions within functions
- Use of the Function Wizard
- Tips & tricks for building functions
Module 2: Get and transform data
In this module, you will work with Power Query to import data from different data sources. You will learn how to transform and manipulate your data, including working with columns and creating calculated columns.
The following topics will be covered:
- Importing data from various data sources - e.g. Excel, text files, SQL Server or other databases
- Cleaning up redundant data
- Connection Manager - keeping your queries up to date
- Merging content from multiple tables - combining multiple lists into one
- Splitting and merging columns
- Creating calculated columns - creating your own formulas
- Converting between numbers and text
- Replacing values
Module 3: Advanced formulas and functions
In this module, you will work with a range of advanced Excel functionalities. You will learn how data ranges can expand automatically as more data is added and work with special types of formulas in Excel, including array formulas.
The following topics will be covered:
- Working with calculations and named ranges
- Creating dynamic lists - lists that automatically expand
- Automatic offset of a named range
- Using the INDIRECT function - a smart reference to named ranges and sheets
- Analysing data using Scenarios and the Data Table tool
- Advanced calculations using array formulas
- Analysing advanced problems using Solver - setting up criteria and letting Excel calculate several unknown variables
Module 4: Controls
In this module, you will learn how to add automation to a worksheet using controls. Controls can also be used to make worksheets easier for other users to work with.
The following topics will be covered:
- Combo Box - a drop-down box with predefined options
- Spinner and Scrollbar, Option Buttons and Check Boxes – a quick way to select a value
- Command Buttons - activating your recorded macros
Module 5: Macros
In this module, you will learn how to automate tasks in worksheets using recorded macros. You will learn what macros do, when they can be used and how to create and run simple macros.
The following topics will be covered:
- Recording and running a macro
- Where are your macros stored?
- Relative and absolute recording - how your code is recorded
- Macro security
Module 6: Database tools
In this module, you will work with two tools for filtering and calculating data in larger datasets.
You will work with the Advanced Filter, where criteria can be used to determine which data should be extracted, as well as database functions for performing statistical calculations based on criteria.
The following topics will be covered:
- Advanced Filter - criteria-based data extraction
- Database functions, e.g. DSUM and DCOUNT - statistical calculations using multiple criteria
module 7: Shortcut keys
This module gives you a logical overview of all the Excel shortcuts.
The following will be covered:
- Compendium of Excel shortcuts
Vælg dato, by og deltagere
Længde
2 dage
Pris
8,500 kr.
ex moms
Sted
System.Collections.Generic.List`1[System.String]
02-12-2026
Kl: 09:00-16:00
Hvad siger vores kunder om os?
Siden 1991 har 4D Academy hjulpet virksomheder og specialister med at omsætte viden til målbare resultater. Vores kursister belønner os med en gennemsnitlig rating på 4,8 ud af 5 på Trustpilot, Google og Facebook, og det gør os stolte.
Se hvorfor både nye og erfarne fagfolk vælger os, når de vil løfte deres kompetencer.
Hold dig opdateret med vores nyhedsbrev
Her bor vi
Læderstræde 22, 2. sal, 1201 København K
Tueager 5, 8200 Aarhus
Ørbækvej 350, 5220 Odense
Tirsdag: 08.00 - 16.00
Onsdag: 08.00 - 16.00
Torsdag: 08.00 - 16.00
Fredag: 08.00 - 16.00
