EXCEL SKILLS - How to build Financial Model in Excel (liquidity forecast with SUMIFS formula) |
![]() |
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" https://link.firmlearning.com/slides Everything you need to know about Blockchain and Cryptocurrency: "The Complete Course on Blockchain and Bitcoin" https://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 https://link.firmlearning.com/udacity # NEWSLETTER Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management: https://link.firmlearning.com/e-mail # BOOK RECOMMENDATIONS* The Hard Thing About Hard Things - Ben Horrowitz https://amzn.to/3aYseE8 Extreme Ownership: How US Navy Seals Lead and Win - Jocko Willink https://amzn.to/3d32sAE The McKinsey Way - Ethan Rasiel https://amzn.to/38SQarl Influence: The Psychology of Persuasion - Robert Cialdini https://amzn.to/2wUI4Bd How a Diet can be a Game Changer in Life - Marie Mirrlees https://amzn.to/2MUyfIh # MY EQUIPMENT* Camera: https://amzn.to/32GZ3o7 Lense: https://amzn.to/3fMIkUo Lights: https://amzn.to/32F6tZ3 Microphone: https://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: https://link.firmlearning.com/audible # SOCIAL MEDIA Instagram: https://link.firmlearning.com/instagram Facebook: https://link.firmlearning.com/facebook # NEWSLETTER Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management: https://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. |