Now we take a step up the Excel ladder and introduce you to even more tools for your daily work with Excel.
Excel is often used by administrative employees for many different types of tasks. These employees may not have the necessary experience with Excel. With this Excel course, you will gain many new tools to handle and utilize spreadsheets for your daily work tasks.
You will learn to work with multiple sheets in the same workbook, format numbers, data, and cells, and use lookups and databases. At the same time, the course allows you to apply your own data, making you even sharper on what Excel can do for you.
We introduce you to a very wide range of functions to streamline your workday.
In this course, we use the English version of Excel 365 — all menus, terms, functions, and shortcuts are entirely in English.
These can consist of the following:
• Creation of formulas that span across multiple worksheets
• Table format for data lists, sorting, filtering, slicers, as well as calculations
• Conditional formatting – highlight data based on their values
• Functions for date calculation, statistics, and text
• VLOOKUP and XLOOKUP to retrieve data from different lists
• Data validation to prevent incorrect entries
• Sheet protection – to secure your data and protect it with a password
• Naming of cells and ranges to optimize your formulas
• Import of data as well as nested functions
Here, you create real added value while simultaneously making your work tasks easier. You will learn how to structure spreadsheets, apply lookup and table functions in the most optimal way, and automate workflows that make your daily work easier.
By following the recommended order of Excel courses, you continuously build upon your skills, ensuring you get the most out of each course. Below is our recommended sequence:
The Excel courses listed above are offered as classroom instruction. You also have the option to take Excel courses in our IBC 360 E-learning Center, but these courses are all in danish. Here, instruction takes place independently of a group, allowing you to take the course on days that suit you. E-learning courses are conducted at our IBC facilities in Kolding and Aabenraa.
This Excel course is for you who work with spreadsheets on a daily basis. You want to optimize your work and produce finished documents in less time and of higher quality.
It is a prerequisite that you have previously worked with spreadsheets to the extent that you:
The course is aimed at you who work in or wish to work in the mercantile sector
Spreadsheet - advanced strækker sig over 3 undervisningsdag(e), og udbydes i Kolding
Denne erhvervsrettede arbejdsmarkedsuddannelse er officielt anerkendt og delvist finansieret af Undervisningsministeriet. Har du en videregående uddannelse fra fx seminariet eller universitet skal du betale det fulde deltagergebyr: DKK 0,- eksl. moms. Faglærte og ufaglærte kan få tilskud til arbejdsmarkedsuddannelser, og der kan være mulighed for at søge tilskud til transport, kost og logi og tilskud for tabt løn.
Er du selvstændig, kan du også søge om refusion, såfremt du tilhører AMU’s målgruppe, dvs. du er faglært eller ufaglært. Læs mere om Voksen- og Efteruddannelsesgodtgørelse. Prisen med tilskud er fra DKK 2259,- momsfrit. Vi tager forbehold for prisændringer som følge af ministerielle tiltag.
The following AMU subjects are included in the course:
| 44346 | Design and automation of spreadsheets | DKK 428 |
| 40748 | Working with large data sets in spreadsheets | DKK 214 |
| Total price for participants in the AMU target group incl. loan of books, materials, and PC |
DKK 642 | |
Prices are subject to change due to ministerial initiatives.