Excel 3 - Advanced Data Processing with Corporate Finance Applications
Strengthen your ability to analyse and structure larger datasets using Excel’s advanced tools with applications relevant to Corporate Finance.
Du skal være medlem af Djøf studerende og i gang med et studie, for at kunne deltage.
3 timer
14.00-17.00
Er studiekurset for dig?
You are a student and use Excel in connection with your studies or student job. You already master the basic tools in Excel and now want to take your skills to the next level.
The course is especially relevant for those working with larger datasets - including finance-related datasets such as cash-flow inputs, financial assumptions, and structured financial data.
To participate in the course, you should be familiar with the basic functions in Excel. If you are unsure about your level, we recommend that you first attend the student course Excel 1 - Introduction with AI or Excel 2 - Effective Functions with AI.
Om studiekurset
In this course, you will learn how to combine Excel’s analytical tools with generative AI to work faster and smarter with data.
You will gain insight into how AI can assist you in analysing, summarising, structuring, and presenting larger datasets - directly within your Excel workflow.
Where relevant, examples and exercises will draw on Corporate Finance contexts, such as structuring financial data, organising model inputs, and supporting investment evaluation.
You will also be introduced to useful keyboard shortcuts and techniques for navigating quickly and efficiently in larger spreadsheets.
During the course, you will learn to:
- analyse larger datasets using pivot tables and advanced lookup functions (XLOOKUP, INDEX, MATCH)
- structure financial inputs and ensure consistency across tables
- navigate quickly and format efficiently using smart keyboard shortcuts
- structure and present data clearly and professionally
- support financial evaluation work (e.g. cash-flow structuring and NPV-style outputs)
The teaching alternates between presentations, practical examples, and exercises, ensuring that you gain hands-on experience with the tools and techniques covered.
Before you attend
You must have Microsoft Excel 2016 or a newer version installed on your computer - preferably Office 365. It does not matter whether you use Mac or Windows.
We use ChatGPT as our generative AI tool. You do not need a paid subscription to participate.
Anton Meier Ebsen
Praktisk information
Her får du svar om de vigtigste praktiske informationer. Har du andre spørgsmål, så kontakt os endelig.
Hvornår foregår det?
Hvor foregår det?
Solbjerg Pl. 3
2000 Frederiksberg
Hvornår skal jeg senest tilmelde mig?
Hvem kan jeg kontakte, hvis jeg har spørgsmål?
Hvordan håndterer I mine personoplysninger?
Når du tilmelder dig en aktivitet hos Djøf, skal vi bruge nogle oplysninger om dig. Du kan læse i vores privatlivspolitik, hvordan vi håndterer og beskytter dine personoplysninger.
Få ny viden og inspiration
I Djøfs kalender kan du finde en lang række af faglige og sociale arrangementer, kurser og netværksgrupper, der handler om alt fra personlig udvikling, aktuelle samfundsemner, lovændringer, ledelse, trivsel og meget mere. Skal du med?