What do you learn in the Financial Excel course?

You will learn how to use Excel for business economics questions. Think of ratio analysis, cost price calculation, variance analysis, capacity calculations and decision calculations. You will also work on drawing up a business plan and optimising your financial reports.

Who is the Financial Excel course suitable for?

The course is suitable for finance staff, controllers, business specialists and analysts who work with figures a great deal. You already have a basic knowledge of Excel and want to use the program more cleverly for financial and business economics analyses.

What prior knowledge do you need?

You need a basic knowledge of Excel: working with cells, simple formulas and formatting. It also helps if you have an affinity with financial concepts and business economics figures.

How long does the Financial Excel course take?

The course consists of two consecutive course days. In that time you will cover all the topics, from ratio analysis to decision calculations, with plenty of practical exercises.

Do you receive a certificate afterwards?

Yes, on completion you will receive a Learnit certificate of participation. This certificate shows that you have successfully completed the Financial Excel course.

Can the course also be taken in-company?

Yes, the Financial Excel course is also available as an in-company or bespoke programme. That way the content fits the financial questions within your own organisation even better.

What is the difference between Financial Excel and a general Excel course?

A general Excel course focuses on functions and techniques within the program. Financial Excel goes a step further: you learn to apply Excel to business economics questions such as cost price calculation, ratio analysis and decision calculations. The content is aimed directly at financial practice.

Which Excel functions are covered?

You will work with formulas and functions that are relevant to financial analysis, such as lookup functions, financial functions, conditional calculations, pivot tables and charts. The choice of functions matches the business economics cases you work on.

Can you bring your own figures and files to the course?

Yes, you may bring your own Excel files and figures. The trainer will help you link these to the techniques covered, so that you apply the material directly to your own working situation.

How large are the groups during the course?

The course takes place in a small group. This leaves plenty of room for personal attention, your own questions and individual guidance during the exercises.

Which version of Excel is used during the course?

During the course we work with a current version of Microsoft Excel. The functions and techniques covered are broadly applicable in earlier versions too, so you can make wide use of what you have learned.

What does the Financial Excel course cost?

You will find the current price at the top right of this course page, together with the schedule, location and delivery format. For in-company or bespoke courses we are happy to provide a quotation on request.

Financial Excel course | Business Economics Calculations

You work with financial figures every day and want to use Excel more intelligently. In this course you combine business economics knowledge with the powerful functions of Excel, so that your analyses become faster, sharper and clearer.

Description

As a finance professional you process large volumes of data. Excel is your most important tool for this, but often you use only a small part of what the programme can do. In this course you learn how to use Excel for business economics calculations and analyses, from cost price to capacity.

You work with practical cases that match your daily work. Think of drawing up a business plan, carrying out a ratio analysis and making decision calculations. You learn formulas, functions and techniques that you apply directly to your own figures.

Afterwards you will know how to translate financial questions into clear models in Excel. You will report more clearly, calculate faster and have a firmer grip on the figures behind the decisions.

Topics

Drawing up a business plan in Excel
Carrying out ratio analysis on financial data
Recognising and processing cost types
Setting up cost price calculations
Carrying out variance analysis between budget and actuals
Carrying out capacity calculations
Drawing up decision calculations
Optimising analyses and presentations with charts and pivot tables

Result

After the course you use Excel purposefully for business economics questions. You carry out ratio analyses, calculate cost prices and produce well-founded decision calculations. You report clearly and save time in your daily work with figures.

Target audience

This course is suitable for financial staff, controllers, business specialists and analysts who work with figures and Excel on a regular basis. You already have experience with Excel and want to use the programme more effectively for financial and business economics analyses.

Teaching method

You work in a small group under the guidance of an experienced trainer. Theory and practice alternate, with plenty of room for your own questions and exercises on your own laptop. You apply the material directly to recognisable cases from financial practice.

Prior knowledge

You have a basic knowledge of Excel and an affinity with financial figures and business economic concepts.

Language

The training is given in Dutch as standard. The trainer has a good command of English. English-language course material can be used. With a minimum enrolment of 3 participants, the training can also be given entirely in English.

Practical Information

Number of days:

2 days

Course times:

from 10 am to 5 pm

Study load:

14 hours

Education level:

This training is suitable for all levels.

Exemptions:

Exemptions do not apply to this course.

Preparation time:

No preparation time applies to this course.

Certificate:

At the end of the course, a certificate is issued as proof of participation.

The best training for you

At Learnit you will always find a course that takes you further. From (technical) IT skills to communication or personal leadership. You can also choose the training format that suits you best: a classroom course, a tailor-made course at your own office, an online course or an e-learning. We have the right course and the right format for everyone. Because learning in the way that suits you best delivers the best results.

Moving forward together

Taking a training course at Learnit means learning together. Together with your experienced trainer, together with your course group or together with your colleagues. And whether you take the training at home, at your office or at one of our training locations, we are always available to help you. To share our knowledge with you in a way that is genuinely useful to you. Getting further together through personal attention and understanding each other well; that is what we believe in.

Apply it directly in your work

Learning theory from a book that you can then hardly use in your work? Not at Learnit! Whichever training you take with us, you can put it to use at your workplace straight away. Because of the unique learning objectives you set together with the trainer at the start of the training. Because of the alternation between theory and (interactive) practical assignments. And by bringing the challenges you face in your daily work along to the training.