Financial Excel course (business economics skills)
Learn to use Excel for business economic analyses: ratio analysis, cost price calculation, variance analysis, capacity and decision calculations.
NRTO quality mark- 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
Your trainer: Luis 162 reviews in total, with an average score of 8,9. View the trainers
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.
Practical information
- Number of days
- 2 days
- Course times
- from 10 am to 5 pm
- Teaching hours
- 12 hours
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials and lunch on site
- Certificate
- At the end of the course you will receive a certificate of attendance
Language
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
The trainers for this course
Ratings from participants after completing their course, across all courses by this trainer.
What others say about this course
Financial Excel course (business economics skills): average 8.1 from 3 reviews
“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.”
“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!”
“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.”
“Pleasant to be able to take part in the course at my own pace while still having plenty of room for questions and comments!”
“A useful way to spend your time; you can work at your own pace and get exercises for all the important topics.”
“Good training, learnt a lot, very usable in practice!”
"Self-study, but with something extra. A good teacher with a great deal of subject knowledge, who genuinely thinks along with you about applying your objectives in your own working environment."
“Learned a great deal in a short time, in a very clear and accessible way. A very efficient method for me!”
“The Excel 2007 Intermediate course is very well set up; interesting topics and applications that can be used at work straight away after practising.”
"An expert trainer who can quickly put himself in the position of real-life situations."
“I think it is a good course with plenty of practical explanation. It opens up a world of useful information for someone with limited Excel experience.”
“Enjoyable course, learnt a lot and everything at my own pace.”
“This course is a logical follow-up to the basics course. It is set up in such a way that people with somewhat less experience of Excel can also follow it well. With a bit of practice you can automate all kinds of tasks in Excel.”
“Never thought I could still learn so much about these programmes. I am also very glad that I took them.”
“Good to be able to work at your own pace. The course is given in small groups (7 in my course), which works very well. In Zwolle the location is very easy to reach, a 1-minute walk from the station! The trainer also gave good individual tips and paid close attention to your learning objectives.”
“I can recommend the Excel course at Learnit to anyone. Excellent guidance from the trainer, a clear textbook and a CD with all kinds of exercises that tie in perfectly with the textbook (you can take these home after the course as practice and reference material). This course made me realise that I could have been working much more efficiently for years. Thanks to Learnit.”
“Excellent self-study course, so you really work at it yourself....that is still the best way to learn !!”
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"
“If I had known about these possibilities in Excel earlier, it would have saved me a lot of time and effort!”
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
“'The first time I have attended a webinar. Definitely worth repeating. Clear explanation. Clear presentation.'”
"A.E. van Wezel - "A very practical course designed above all to make the most of the standard functions" - Rating: 8.6"
“The instruction/explanation is very clear; you can get started yourself straight away, with the convenience of support where needed.”
“'Expert tailored work, highly recommended!!”
“I had a course that was both instructive and relaxed at the same time. The trainer explains things well when you have a question and makes sure you feel at ease. He joins in during the breaks to chat about other things or to go for a walk. Learnit provides good training and makes sure you do not go home with a splitting headache. Excellent!”
"The advantage, I found, was that you work individually, so that everyone can work at his or her own pace."
“Very useful training course! You take home a good reference manual in which you can look things up. The trainer has a great deal of knowledge and explains things well. Recommended!”
“Completely up to speed with Excel again thanks to Learnit training.”
“Very good that courses are offered in this way! Useful explanation of pivot tables in Excel so you can start using them yourself as quickly as possible!”
“An enjoyable course in which everything is explained clearly, but which also makes you think for yourself. Everyone can work at their own pace.”
"Informative, pleasant, clear material, step-by-step method."
“The course fits my work very well. By bringing your own material you work purposefully and learn exactly what you want to learn. There is also plenty of scope and experience available to expand your knowledge further.”
"Recommended, excellent course material and a good trainer."
"Learned a lot in a short time, and in a pleasant way"
“If you want to know the ins and outs in a short space of time, do register!”
“Well worth attending.”
“An excellent course where you can ask all your questions and get very good help.”
“My impression of this course is excellent! Nothing but praise....”
"Excellent, professional training course with plenty of 'tips & tricks' for every starting level."
"A course I can genuinely recommend to anyone who works with Excel and needs to do a bit more than the basics. The quality of the course material and the trainer's expertise are excellent. Every topic is covered in sufficient depth. The teaching method of working independently in a pleasant environment with a good atmosphere, together with the trainer's approach, helps you to remember what you have learned."
"This training course is excellent for those who have a good grounding in Excel and want to improve further. The trainer was very professional and helpful. The right way to run this kind of course."
“During the two-day course I learned about the many possibilities and applications, which has made working with Excel far more appealing.”
“Another good course with plenty of content that can be put into practice well; we were also given extra exercises by the excellent trainer Sjoerd Jellema.”
“Hands-on course that helps you in your day-to-day work”
“The trainer's enthusiasm was infectious! She had no trouble at all switching between the different levels of the participants and/or between the different applications.”
"The training is certainly worth recommending. I had no experience with Excel, but the explanations were so clear that I can definitely get to work with it. The trainer was also very clear in his explanations, definitely recommended."
“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!”
“Excellent, you come to realise how necessary it is to take Excel courses.”
"The material was explained clearly and effectively. The trainer was more than helpful and knowledgeable."
“Well organised, clear and focused. Nice to be able to work through the course material at your own pace.”
Training formats
Classroom
2 days€ 1250,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want
Frequently asked questions
What do you learn in the Financial Excel course?
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.
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 programme more cleverly for financial and business analyses.
What prior knowledge do you need?
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.
How long does the Financial Excel course take?
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.
Do you receive a certificate afterwards?
Yes, on completion you will receive a Learnit certificate of attendance. 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 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.
Which Excel functions are covered?
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.
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 as well, so you can use what you have learned widely.
What does the Financial Excel course cost?
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.