Switch to the Dutch version/Switch to the English version
  1. Home
  2. All courses
  3. Finance & Administration
  4. Bookkeeping
  5. Financial Excel (business economics skills)

Learn to use Excel for business economic analyses: ratio analysis, cost price calculation, variance analysis, capacity and decision calculations.

  • Applying Excel to financial questions
  • From cost price to ratio analysis and decision calculations
  • Practical cases from financial practice
  • Small group and experienced trainer
  • Learnit certificate of participation

In-company

Recommended number of days: None
Group: up to a maximum of 8 people
Location: In-company, throughout the Netherlands
Language: Dutch or English
Investment: on request
Are there any other wishes or requirements? We can tailor the course to your needs.
Request a quote
  1. Home
  2. All courses
  3. Finance & Administration
  4. Bookkeeping
  5. Financial Excel (business economics skills)

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.

Training formats

In-company

Bespoke training

On request

 

  • 100% for your group
  • Bespoke training
  • At your place or ours
Request a quote

Workshop

Up to 4 hours for groups

On request

 

  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yours

On request

 

  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

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.

Participants attending a classroom training course at Learnit

Why choose training at Learnit?

  • Always and everywhere personal

    Personal attention and a pleasant atmosphere. Whether you take a course with us, at your office or on your own PC, we make sure you feel at home enough to push your boundaries.

  • Just do it!

    New opportunities arise when you get moving. Stay sharp. Keep taking new steps. We encourage you to take the plunge and really go for it.

  • Growing through knowledge and inspiration

    Discover something new. Build on your strengths. And choose your own path. We help you grow with training courses and learning formats that genuinely suit you.

  • Skills for the future

    We always think in terms of possibilities and win-win. And every day we work on new solutions for tomorrow. By offering training courses that leave you well prepared for the future.

  • Working together on quality

    We don't make empty promises. What we do offer is quality, knowledge and experience. A broad range of courses, made possible by our inspired staff and trainers.

  • Understanding and being understood

    We listen to what matters to you. To what you need. Because that is where our solution, our tailored approach, begins. Understanding each other properly and communicating clearly: that is what we believe in.

Find out more about Learnit
Trainer and participants working together during a Learnit course

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.

Participants apply what they have learnt straight away in the workplace

Training formats

In-company

Bespoke training

On request

 

  • 100% for your group
  • Bespoke training
  • At your place or ours
Request a quote

Workshop

Up to 4 hours for groups

On request

 

  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yours

On request

 

  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

Reviews

What others say about this course

Financial Excel (business economics skills) course reviews - Average rating 8.1 from 3 reviews

  • “The Excel training course was good. We also received good materials to practise with on our own afterwards. The trainer passed on his knowledge to us in an interesting way.”

    M. Polderman, Randstad Nederland B.V. Head Office- Financial Excel (business economics skills)
    Rating 7.6

  • “I would certainly recommend this course. It not only increases your knowledge of Excel, but also gives you the 'tools' to approach it in a problem-solving way. I also liked the trainer's personal teaching style. He had tips for working life based on his own experience and tried to coach every participant in that way.”

    Johan Bakker, Randstad Nederland B.V. Head Office - Financial Excel (business economics skills)
    Rating 7.7

  • “I was very pleased with my Excel course, and I was fortunate enough to have a friendly and helpful trainer (Albert Keupink) whom I would happily recommend to others!”

    R. Eberson, Randstad Nederland B.V. Head Office- Financial Excel (business economics skills)
    Rating 9.0

  • “Enjoyable, inspiring course, I learnt things and picked up ideas I didn't know were possible with Excel and VBA. Even though I normally use Excel a lot in my daily work as a tool.”

    L. van Gaalen - Excel VBA
    Rating 9.2

  • “Good course. What I particularly appreciated is the fact that everyone learns at their own pace whatever interests them.”

    J. Kelmanutu - Excel Basics
    Rating 7.7

  • “Doing is learning”

    Roelof Pieters, Scania Production Meppel BV - Excel Basics
    Rating 8.0

  • “Sjoerd Jellema made the course personal by explaining the material with exercises, which I then applied myself. Sjoerd is a pleasant course leader who has a good command of the subject matter but also carries the group along with the material being covered. I found the course very practical, and cases I brought along myself were also dealt with. This brought the theory to life in practice.”

    L. Poortman, Laurentius - Excel Advanced
    Rating 9.2

  • “Good training, learnt a lot, very usable in practice!”

    José Hoogeboom, RINO Amsterdam- Excel Basics
    Rating 7.9

  • “Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”

    E. Geelen- Excel Expert
    Rating 8.0

  • “I have been working with Excel for quite some time. However, I had no idea of everything you can do with it. I would recommend this course to any novice like me! Do it!!”

    S. Hulshof, CEVA Logistics- Excel Basics
    Rating 8.8

  • "The training has given me a good tool to do my work better and make it easier for me."

    P. Coert, Cofely - Excel Basics
    Rating 8.4

  • “A good course to regain and increase knowledge on valuable Excel skills to make worklife easier and faster”

    Bart Verdoorn, Marchon - Excel Expert
    Rating 8.0

  • “Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”

    Sandra de Haas, Euler Hermes Kredietverzekeringen- Excel 2002 Basics
    Rating 9.4

  • “The assignments are very clear and easy to follow. There is also plenty of room to put forward your own input from your own work situation, so you can also address the issues you run into on a daily basis.”

    N. Hartman, Priva- Excel Advanced
    Rating 7.7

  • “The Excel 2010 Basics course gives you a good picture of what the new Excel has to offer. You'll be amazed by the new possibilities with charts. 180 pages won't make you a guru, but you will become a good deal more capable.”

    P. Kersten, ABN AMRO - Excel Basics
    Rating 9.0

  • "The course allows everyone to achieve their learning objectives at their own pace."

    J. van Wolfswinkel, Cofely - Excel Advanced
    Rating 8.0

  • “Practice-oriented, ties in seamlessly with your work.”

    B. Derks, JHV Exploitatie BV- Excel Basics
    Rating 8.9

  • “Excellent course; the tips and tricks in particular can save you a great deal of work. The limitations of the package are also covered, and that helps too.”

    Thijs Janssens, BIJ12 - Excel Pivot Tables, Formulas and Functions
    Rating 7.8

  • “Interesting course. To really master all the material, it is advisable to set aside enough time for it.”

    J. Sijtsma, Gemeente Woerden- Excel Advanced
    Rating 7.7

  • “Enjoyable course, learnt a lot and everything at my own pace.”

    W. Wever, Scania Production Meppel B.V. - Excel Intermediate
    Rating 10.0

  • “Excellent training. You work at your own pace. The guidance is very good and takes your own issues into account. Recommended for all levels.”

    S. van den Brink, Beter Wonen - Excel Basics
    Rating 9.0

  • “For a beginner like me this was a very pleasant and concise training course. Starting from a low level, I gained a lot of confidence and can now genuinely put what I have learned into practice.”

    S. Dijkstra, Verslavingszorg Noord Nederland - Excel 2003 Basics
    Rating 9.0

  • "Bart was very passionate and driven; we could not have wished for a better trainer over those two days. It felt good and approachable, and you could tell he genuinely enjoys Excel. Got some good practical tips. Brilliant!! Bart got me completely enthusiastic even though I had really been dreading it."

    - Excel Basics

  • "The course made a good impression on me. The material provided is excellent. Because I had not indicated in advance what knowledge I already had and what purposes I wanted to use the course for, the material offered was quite a lot for 2 days. So follow Learnit's advice and state this beforehand."

    Silvia Megens, Meiland Azewijn B.V.- Excel Basics
    Rating 8.7

  • “The course materials and the trainers of the various courses I have taken were very good. I have taken 3 courses in the last 2 months and I am very pleased with the result!”

    S. Verhaert, NKM Noell Special Cranes GmbH - Excel Advanced in-company
    Rating 7.9

  • "Excellent, professional training course with plenty of 'tips & tricks' for every starting level."

    - Excel Pivot Tables, Formulas and Functions

  • “Discovering new applications from start to finish. Excel opens up a whole new world for you.”

    C. Westhof, Alrijne Zorggroep- Excel 2010
    Rating 8.6

  • "Good impression. You understand the structure and set-up of VBA much better. Recommended for all editors, you now understand how it really works!"

    A. de Blieck, Randstad Nederland B.V. - Excel VBA
    Rating 8.6

  • “I am extremely satisfied with this way of teaching. You get a lot of individual attention with good tips from the trainer. Also if you want to discuss work-related topics. In short, I would recommend this way of teaching to anyone who wants to master the material at their own pace.”

    J. B.W.M. van Asperen- Excel Basics
    Rating 9.0

  • “To me, Excel was no more than a program with little squares... But that you could do so much with it ... A whole new (Excel) world opened up for me. I will definitely be applying this from now on. It is going to save a lot of time.”

    Brenda Molenaar, Coty Prestige - Excel 2002 Basics
    Rating 7.7

  • “No pressure to keep up with fellow participants who might be faster, as you would have in a classroom course. A trainer is on hand if needed and comes straight over when you ask.”

    Marjan Lof, Yarden Uitvaartverzekeringen N.V.- Excel Pivot tables, formulas and functions
    Rating 8.0

  • “A plus point is that the teaching is not classroom-based, so you can work at your own pace. Two days is exactly enough.”

    R. Frings, Keyrail B.V.- Excel Basics
    Rating 8.0

  • “Excellent course for people who want to achieve their own learning goals at their own pace.”

    G.E. Verweij- Excel Basics
    Rating 8.4

  • “This course is a good introduction to VBA/macros. It is a mix of theory and practice.”

    A. Bergers - CEVA Logistics - Excel Macros and Working with Other Applications
    Rating 7.8

  • “The location of the course is perfect. The course material is clearly presented, which makes it easy to work through the subject matter.”

    Karin van der Laan, TU Delft- Excel Basics
    Rating 8.0

  • “I can recommend this course to every Office user. The course material and the pace can be adapted to your own situation and there is every opportunity to ask questions, which are always answered well.”

    M. Oostdijk, ROC Mondriaan - Excel Macros and Working with Other Programs
    Rating 8.1

  • “The open learning format is a good way to follow a course. You can take the course at your own pace, with or without prior knowledge.”

    M. Ensel-Boonstra, Ensel Staalkonstrukties - Excel Basics
    Rating 8.0

  • “Very good course! Everything is perfectly organised and I would certainly recommend taking a course at Learnit.”

    Luciano Felida, New Neopharm - Excel Basics
    Rating 9.0

  • “The trainer takes the time and explains things well.”

    I. Bojovich, Robert Walters- Excel Basics
    Rating 8.0

  • “The Excel 2010 Basics training is a great way to make the programme entirely your own. By working independently at your own pace, attention can be paid to all the topics that matter to you. The experienced trainer gives plenty of examples and tips along the way. By working with your own material, you know at the end of the training that you can really apply it in practice. In short: highly recommended!”

    C. Bijsterveld - Excel Basics
    Rating 9.1

  • “An excellent way to extend your Excel knowledge. Your learning question and your Excel problems take centre stage. If you bring your own material, you solve your own issues during the course.”

    E. Niessen, Stichting Philadelphia Zorg- Excel Expert
    Rating 8.0

  • “An instructive, practically applicable Excel basics training that gives plenty of insight into everything Excel 2010 has to offer.”

    P. van der Meule, NUON - Excel Basics
    Rating 8.0

  • "I learned a great deal from the Excel Basics course. You can follow it in a quiet setting, at an easily accessible location and with a professional trainer, at your own pace. Course material consisting of a clear book alongside appealing examples in Excel to practise with. In short: highly recommended!"

    - Excel Basics

  • “If in doubt, do get advice from Learnit. I found these 2 days interesting, all the more so because this course was taught in an expert manner.”

    H.J.M. van Noorbeek, Cofely Nederland N.V.- Excel Advanced
    Rating 8.8

  • “If I had known about these possibilities in Excel earlier, it would have saved me a lot of time and effort!”

    L. Wijnvoord, Movir- Excel Basics
    Rating 8.7

  • “I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”

    L. van den Berg-van Heusden, Meyra Holding BV - Excel 2003 Intermediate
    Rating 8.9

  • "Good course. The trainer has extensive knowledge of Excel and explains things calmly and clearly."

    - Excel Basics

  • "Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."

    Arline de Rooy, SMT Netherlands B.V. - Excel Basics
    Rating 7.9

  • “The Excel Advanced course fully met our expectations. The learning objectives were completely achieved and both the less experienced and the more advanced users learned new Excel applications.”

    L. Jautze, Universiteit van Amsterdam - Excel Advanced
    Rating 8.1

  • “A good coursebook with exercises that let you work at your own pace. You can ask the trainer for help at any time.”

    W. Huiberts, Teleplan- Excel Advanced
    Rating 9.1

Learnit reviews

Others also viewed

Excel Basics

  Excel Basics

In this Excel course you will learn to work with formulas, functions, charts and formatting. You will create clear spreadsheets yourself and apply your knowledge directly in practice. Optionally, you can also give attention to Excel with Copilot.

View the course

Excel Macros and working with other programs

  Excel Macros and working with other programs

In this course you will learn to record, edit and understand macros in order to automate tasks in Excel. You will create links with Word, Access and PowerPoint. Optionally, you can also look at Excel with Copilot.

View the course

Excel Expert

  Excel Expert
In this Excel Expert course you delve into advanced functions, pivot tables, macros and what-if analyses. You learn to structure, analyse and present complex data. Optionally, attention is paid to working with Copilot in Excel.
View the course

Financial management for the non-financial manager

  Financial management for the non-financial manager

In this course you build a solid foundation in financial management. You learn to read the annual accounts, carry out analyses and assess investments. You get to grips with concepts such as liquidity, return on investment and ratio analysis, so that you can hold your own in discussions with financial professionals.

View the course

Turnover tax (VAT)

  Turnover tax (VAT)
In this Turnover Tax course you gain insight into VAT and learn which aspects matter when filing your return. You will discover how to make the best use of VAT schemes and exemptions, and so get more out of your VAT return.
View the course

Excel PowerPivot

  Excel PowerPivot

In this course you will learn to work with Excel PowerPivot. You will link external data sources, build a data model and analyse data using DAX formulas in clear pivot tables. Optionally, you can also cover Excel with Copilot.

View the course

Excel Pivot Tables, formulas and functions

  Excel Pivot Tables, formulas and functions
In this course you delve into advanced formulas, functions and pivot tables in Excel. You learn to set up and filter databases and to present data clearly using pivot tables and pivot charts. Optionally, you can also look at Excel with Copilot.
View the course

IFRS Essentials

  IFRS Essentials
In this IFRS Essentials course you work with the common IFRS standards for financial reporting and the annual accounts. You discover the differences with Dutch GAAP, see the impact on your organisation and apply practical calculation models to your own figures.
View the course

Excel VBA

  Excel VBA

In this Excel VBA course you learn to automate common tasks with VBA code. You work with the VBA editor, create procedures, variables and your own functions, and program Userforms. Optionally, you can spend time on Excel with Copilot.

View the course
View all courses

Frequently asked questions

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

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 programme more cleverly for financial and business analyses.

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

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

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

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.

A general Excel course focuses on functions and techniques within the programme. 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.

You 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 ties in with the business economics cases you work on.

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.

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.

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

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