Excel for Finance and Reporting
For anyone who wants to learn Excel for financial and administrative tasks from the ground up. Work with cells, tables, simple formulas, sorting, filtering and core functions and finish with a simple reporting task.
What will you gain?
Learn a simple and practical Excel workflow: from raw data to a clear financial report. We start with the fundamentals and build step by step so you can use the methods in administrative and finance tasks.
After the course, you can
- Work confidently with cells, tables and simple formulas in Excel.
- Use SUM, SUMIF, IF and XLOOKUP in a simple financial task.
- Sort, filter and structure raw data so it is easier to work with.
- Build a simple report with a summary table, result and chart.
Who is the course for?
Administrative and finance employees as well as recent graduates and jobseekers who want practical Excel skills from a basic level. You do not need experience from a finance department or previous professional Excel use.
Prerequisites
No advanced Excel experience is required. The course starts with cells, tables and simple formulas. It is helpful if you have opened Excel before, but it is not essential; the core steps are covered from the beginning.
What you will work on
Excel basics and formulas
Cells, tables and simple calculations plus SUM, SUMIF, IF and XLOOKUP in small finance examples.
Structuring data
Sorting, filtering, categories and basic checks of a simple dataset with financial entries.
Simple reporting
Summarise financial data in a report table and present the result in a simple chart.
From knowledge to a work task
Work with a prepared dataset of financial entries. Structure the data, use core functions to summarise amounts and build a simple report with a table, result and chart for a manager.
Relevant roles and work tasks
- Finance assistant / accounting staff
- Prepare data and summarise financial figures for reporting.
- Administrative professional
- Update tables, summaries and recurring reports.
- Controller / reporting professional
- Analyse financial data and make simple reporting tasks reusable.
Level and scope
Beginner / early intermediate. The course starts with fundamental Excel skills and builds towards simple financial functions and reporting. The focus is practical application; Power Query, macros and advanced analytical models are not included.
Teaching and materials
Live online teaching combines short explanations, guided exercises, discussion and a practical task. Prepared cases let participants practise without sharing confidential business data. The instructor provides feedback on exercises. Course materials and the case files used are included.
Documentation after the course
After attending both teaching days, participants receive an attendance certificate stating the course title, dates, teaching hours and topics covered. It documents attendance; the course does not award ECTS credits, an AMU certificate or a formal qualification.
Related courses
Choose a foundation in financial understanding, practise planning with budgets or strengthen reporting in Excel. Your existing knowledge determines the right starting point.
The detailed course programme is sent after confirmed registration.
Let’s find the right programme for you.
Tell us what you would like to learn. We will help you clarify level, content and format.
