Met een gegevensmodel kunt u gegevens uit meerdere tabellen integreren, waardoor u effectief een relationele gegevensbron opbouwt in een Excel-werkmap. Een datamodel wordt gevisualiseerd als een verzameling tabellen in een veldenlijst, en meestal weet u niet eens dat het er is.
Wat zijn Excel-modelleringsvaardigheden?
De belangrijkste vaardigheden op het gebied van financieel modelleren zijn:
- Een gedegen kennis van boekhouding.
- Sterke Excel-vaardigheden.
- Weten hoe u de 3 financiële overzichten moet koppelen.
- Begrijpen hoe u een prognose maakt.
- Een logisch kader voor het oplossen van problemen.
- Aandacht voor detail.
- Mogelijkheid om grote hoeveelheden gegevens in een eenvoudig formaat te destilleren.
Overzicht cursussen Excel-modellering
Doelgroep: Anyone curious to master Forecasting Models from beginner to advanced..
Bedrijf: Udemy
Duur:
7 uur in totaal
Richtprijs: €199.99
You're looking for a complete course on understanding Forecasting models to drive business decisions involving production schedules, inventory management, manpower planning, and many other parts of the business., right?You've found the right Marketing Analytics: Forecasting Models with Excel! This course teaches you ev..
Meer info
Doelgroep: Working Professionals,Students pursuing Degree, Diploma, Engineering and commerce who want to make a career in finance/Fixed Income market.,Professionals who want to pursue a career in the Private Equ..
Bedrijf: Udemy
Duur:
31,5 uur in totaal
Richtprijs: €199.99
This course is a comprehensive bundle of MS Excel, Valuation, Accounting, Financial Analysis and Financial Modeling. Any one interested in a career in Finance and Financial Analyst Industry. This course is a must. Many students and professionals assume that their chances of making an Analyst career in Fi..
Meer info
Doelgroep: Students / graduates trying to get hired for analytical skills,Consultants and corporate analysts looking to develop core skills,Entrepreneurs needing to model their new businesses,Experienced profess..
Bedrijf: Udemy
Duur:
16,5 uur in totaal
Richtprijs: €19.99
*** This training teaches you:1) All of the crucial excel techniques you should care about: including model structure, data handling, smart lookups, aggregation & basic statistics, tables, pivot tables, charts, VBA macros & custom formul..
Meer info
Doelgroep: Supply chain professionals,Professionals in manufacturing industries looking to learn more about supply chain management,MBA students,Operations students..
Bedrijf: Udemy
Duur:
2 uur in totaal
Richtprijs: €19.99
A detailed demonstration of the development of a multi-echelon supply chain model in Microsoft Excel is provided. First, the conceptual model for the supply chain is explained and developed in Microsoft PowerPoint. The monthly bucketed supply chain model is then developed in Microsoft Excel starting with a ..
Meer info
Doelgroep: Anyone who is keen to learn a solid investment approach used by hedge fund professionals founded on math and common sense.,Anyone who is interested in generating stable returns with lower risk over th..
Bedrijf: Udemy
Duur:
8,5 uur in totaal
Richtprijs: €199.99
Do you think professional methods of investing are beyond your reach because it involves the state of the art infrastructure, rocket science, and a huge amount of money? Have you tried replicating someone else's trading style and method only to end up with drastically different or inconsistent results?Do you find it di..
Meer info
Doelgroep: This is the course for anyone who is interested in applying financial methods to real-life situations. You will see how theory works in real business with every figure of Excel model created in front..
Bedrijf: Udemy
Duur:
4 uur in totaal
Richtprijs: €29.99
What is Financial Modeling?How to build a financial model in Excel?What is EBITDA? How to read the P&L? How to calculate WACC, ROIC, equity risk premium? How to use DCF?Every student will receive an Excel file with input data for Sample Company valuation, which will include both historical financial accounts and op..
Meer info
Doelgroep: Anyone looking to learn the finances behind real estate development.,Anyone looking for a functional financial model they can use to impress future employers, or use for a RE development project,Anyon..
Bedrijf: Udemy
Duur:
1 uur in totaal
Richtprijs: €64.99
This course will teach you how to financially model a multi-family real estate development project and comes with a downloadable, complete Excel model. The model that comes with this course is plug and play with minimal work necessary to adapt it to any kind of multi-family development project. T..
Meer info
Doelgroep: Anyone who is keen to learn a solid investment approach used by hedge fund professionals founded on math and common sense.,Anyone who is interested in generating stable returns with lower risk over th..
Bedrijf: Udemy
Duur:
8,5 uur in totaal
Richtprijs: €199.99
Do you think professional methods of investing are beyond your reach because it involves the state of the art infrastructure, rocket science, and a huge amount of money? Have you tried replicating someone else's trading style and method only to end up with drastically different or inconsistent results?Do you find it di..
Meer info
Doelgroep: Anyone who is keen to learn a solid investment approach used by hedge fund professionals founded on sound principles and common sense.,Anyone who is interested in generating decent returns with modera..
Bedrijf: Udemy
Duur:
7 uur in totaal
Richtprijs: €199.99
Do you think professional methods of investing are beyond your reach because it involves state of the art infrastructure, rocket science, and huge amount of money?Have you tried replicating someone else's trading style and method only to end up with drastically different or inconsistent results?Do you find it difficult..
Meer info
Doelgroep: Junior to Mid-Senior finance and accounting professionals, who are engaged in the budgeting process,Business owners and entrepreneurs who want to understand how budgeting works in practice,Managers in..
Bedrijf: Udemy
Duur:
5,5 uur in totaal
Richtprijs: €119.99
If you are currently working in an FP&A role, or anywhere between accounting and finance, there’s a high chance you’ll probably face the challenge of preparing a budget statement. It would be great if you are ready to tackle such a challenge with confidence and promptly.And this is the course to prepare you for..
Meer info
Doelgroep: Any one who wants to learn Advanced modeling techniques and Tricks in Microsoft Excel,Accountants who wants to efficiently manage their Prepaid Expenses and Balance Sheet Reconciliations,Non-Accountin..
Bedrijf: Udemy
Duur:
6 uur in totaal
Richtprijs: €99.99
If you’re an accountant, analyst or business professional looking to take your Excel skills to the next level, this is the course you’ve been looking for!This Course will teach you how to prepare efficient Excel model with advanced (powerful) formulas and function, Power Query /Pivot Tables and Excel VBA (all templ..
Meer info
Doelgroep: Beginner financial modeller looking to enhance their Microsoft Excel skills.,Anyone with basic financial knowledge who wishes to create or work with financial models in Excel...
Bedrijf: Udemy
Duur:
4 uur in totaal
Richtprijs: €19.99
This course equips delegates with Excel tools to build financial models. This course takes delegates through the most useful Excel functions, add-ons and formulas to build financial models, perform lookups, assess risk and scenarios and build reports.The course also delves into Goal Seek, Solver and Data Tables f..
Meer info
Doelgroep: Anyone interested in finance, accounting, or related fields...
Bedrijf: Udemy
Duur:
1,5 uur in totaal
Richtprijs: €34.99
In this course we learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. We concentrate on th..
Meer info
Doelgroep: Engineers,Students,Beginners to Excel VBA,Anyone who deals with modelling,Anyone who wants to learn numerical math..
Bedrijf: Udemy
Duur:
3 uur in totaal
Richtprijs: €49.99
Hello everyone,As it is known, the engineers deal with a big amount of data and they use the sophisticated calculations to solve the problems. However, sometimes the analytical approaches are not efficient, because of the complexity or impossibility. In this case, the numerical methods are very useful to solve the prob..
Meer info
Doelgroep: Any one who wants to get into main stream Finance Profile,Advised specificlly to all MBA Finance, CA, Mcom, CFAs..
Bedrijf: Udemy
Duur:
1,5 uur in totaal
Richtprijs: €19.99
In simple words, financial modelling is the process to forecast the financial statements including IS, BS, CFS. The output of financial modelling is called a financial model. A standard financial model will include Historical & projected financial statements along with various schedules and assumptions. Finan..
Meer info
Doelgroep: Anyone interested in Finance, Accounting, Excel or related fields...
Bedrijf: Udemy
Duur:
1 uur in totaal
Richtprijs: €24.99
This course is designed to take users through the process of building the fundamental financial statements in Excel; income statement, balance sheet and cashflow statement. The statements are built from basics using key assumptions and/or linking related items together e.g. accounts receivable and revenue. Key assumpti..
Meer info