You will learn
On this Excel Experienced course, you will build on your existing Excel skills and learn how to create more advanced and efficient spreadsheets. You will work with some of Excel's built-in functions and tools for handling larger amounts of data.
The course is designed for users who already have a basic knowledge of Excel and want to work more efficiently with formulas, functions, multiple worksheets and workbooks, formatting and data analysis.
You will also learn how to work with larger data lists and use tools that can help you create a better overview of your data.
After the course, you will be able to:
- Manage multiple workbooks, create formulas between them and validate entered data to help avoid errors.
- Build advanced formulas using useful built-in functions, including IF functions at several levels.
- Use VLOOKUP and MATCH to look up values in large data lists.
- Handle formulas that return errors.
- Use conditional formatting to highlight key figures or values that meet specific criteria.
- Create an overview of and perform calculations on large lists using tools and functions such as Subtotals and SUMIFS.
- Create PivotTables to get an overview of larger amounts of data.
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 Experienced course is designed for users who already have a basic knowledge of Excel and want to develop their skills further.
The course is particularly relevant if you work with larger amounts of data and want to become more efficient when using formulas, functions, formatting and data analysis tools in Excel.
We recommend that you have completed our Excel Basic 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: Worksheets and workbooks
In this module, you will learn how to work with multiple worksheets and workbooks. You will work with managing several worksheets, creating formulas across sheets and creating links between workbooks.
You will also work with consolidation as well as sharing and protecting worksheets and workbooks.
The following topics will be covered:
- Creating and managing multiple sheets
- Formulas on multiple sheets in the same workbook
- Arranging multiple workbooks and creating links between workbooks
- Saving multiple workbooks in a workspace
- Merging data from different worksheets or different workbooks using consolidation
- Sharing the workbook and permitting multiple users to work simultaneously
- Protection of cells, sheets and workbooks
Module 2: Validation and special tools
In this module, you will learn how to control data entry in your worksheets. You will also work with different options for copying, pasting and selecting specific content in Excel.
The following topics will be covered:
- Data validation - checking that data entries in the worksheet are correct
- Merging entries from different cells into one
- Insert and Paste Special options - e.g. converting formulas to values
- Selecting specific areas in the worksheet - e.g. formulas or number values
Module 3: Using build-in functions
Built-in functions can make it easier to perform calculations and solve different types of tasks in Excel. In this module, you will work with a selection of Excel's built-in functions.
The following topics will be covered:
- Statistical functions - e.g. AVERAGE, MAX, MIN and COUNT
- Text functions - e.g. extracting first and last names from a cell containing a full name
- Date functions - e.g. calculating year, weekday and week number from a date
- Logical functions - using criteria when something needs to be calculated
- Information functions - e.g. returning an error message if a formula fails
- Lookup functions - retrieving data from large lists or comparing lists
Module 4: Advanced formatting
In this module, you will learn how to create customized formats and apply formatting based on the content of a cell or a formula.
The following topics will be covered:
- Creating your own formats for numbers or dates
- Conditional formatting - automatically formatting cells with fill colors, bars or icons based on their content
- Controlling formatting when combining text
Module 5: Data analysis and calculation tools
In this module, you will be introduced to useful tools for working with large worksheets and larger amounts of data.
The following topics will be covered:
- Removing duplicates from a list
- Grouping rows and columns
- Functions with criteria, such as SUMIFS and COUNTIFS
- Introduction to PivotTables - with just a few clicks, you can calculate totals for similar data
Module 6: Keyboard shortcuts
In this module you will get an overview of keyboard shortcuts and key tips.
The following will be covered:
- Excel standard keyboard 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]
29-10-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
