Excel skills are crucial for all business professionals. Financial modeling is a task not only relevant to Finance professionals but to all general managers. Learn how to build a financial model in Excel in this video. I will create a liquidity forecast in Microsoft Excel, based on the Excel formula SUMIFS. The SUMIFS formula is a powerful formula that can be used in many ways in financial modeling. I will teach you how to use SUMIFS. Excel skills enable you to process and analyze data and draw conclusions from them. Learn most important Excel skills for consulting in this video. I talk about the key Excel skills I learned as a McKinsey consultant, having created many financial models myself. These are essential Excel skills for consulting. It is great as an advanced Excel training and will share many great Excel tips, highly relevant to management consulting, including Excel shortcuts. Are you an MBB consultant yourself (McKinsey, BCG, Bain)? Let me know what your favorite Excel tips are!
Chapters
00:00 Introduction
01:37 Explanation of SUMIFS formula
09:04 Financial model that we will build
15:43 Building the financial model
24:31 Wrap-up
MY ONLINE COURSES*
Learn to make PowerPoint presentations like Top Management Consultants:
"CEO-level Presentation Skills - Slide Writing for Consulting"
link.firmlearning.com/slides
Everything you need to know about Blockchain and Cryptocurrency:
"The Complete Course on Blockchain and Bitcoin"
link.firmlearning.com/blockchain
Udacity - Learn the latest tech skills, great to learn how to code without technical background (e.g., as business student) - with this link, 50 USD discount on all courses
link.firmlearning.com/udacity
NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management:
link.firmlearning.com/e-mail
BOOK RECOMMENDATIONS*
The Hard Thing About Hard Things - Ben Horrowitz
amzn.to/3aYseE8
Extreme Ownership: How US Navy Seals Lead and Win - Jocko Willink
amzn.to/3d32sAE
The McKinsey Way - Ethan Rasiel
amzn.to/38SQarl
Influence: The Psychology of Persuasion - Robert Cialdini
amzn.to/2wUI4Bd
How a Diet can be a Game Changer in Life - Marie Mirrlees
amzn.to/2MUyfIh
MY EQUIPMENT*
Camera: amzn.to/32GZ3o7
Lense: amzn.to/3fMIkUo
Lights: amzn.to/32F6tZ3
Microphone: amzn.to/2E2mpud
AUDIOBOOKS*
This is a link to the audiobook service Audible that I use every day. It helps me "read" 50+ books every year. The link gives you a free test month:
link.firmlearning.com/audible
SOCIAL MEDIA
Instagram: link.firmlearning.com/instagram
Facebook: link.firmlearning.com/facebook
NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management:
link.firmlearning.com/e-mail
* Links are Affiliate links. This means that I receive a revenue share whenever a purchase is made via the link. The price for you stays the same. Thank you for supporting my work at Firm Learning!
All views expressed on this channel are private opinions of this channel's creator Heinrich. This is NOT an official channel of any consulting firm.
Негізгі бет EXCEL SKILLS - How to build Financial Model in Excel (liquidity forecast with SUMIFS formula)
Пікірлер: 107