A beginner level training on Excel and data analysis for busy professionals.
An in-depth training on Excel and data analysis for busy professionals.
This course will provide you with mastery in using Excel Pivot Tables. You'll learn to effectively summarize large datasets, create insightful Pivot Charts, and perform essential calculations within Pivot Tables for impactful data presentations.
FMI Advanced Financial Modeler (AFM) Mock Exam to help you prepare better. Are you planning to take the AFM certification exam by Financial Modeling Institute? Then this is a very helpful mock exam to give a try. It is a fairly rigorous one and with a different sector than the ones in the official samples you probably have.
Comprehensive financial modeling and DCF Valuation for a non-service product company - unit economics - cost - overhead expenses - debt raising with timing, moratorium (if any), interest rate, repayment schedule and other details of the debts - equity raise separated into common stocks and preference stocks with dividend payment plans - capital expenditure across different asset types with timing details, salvage value and depreciation duration - tax rate - bank overdraft facility rate
How to create a startup or existing company financial model from scratch and carry out the DCF Valuation
How to create a startup or existing company financial model from scratch and carry out the DCF Valuation
How to build complex, insights-rich, interactive reports and dashboards in Power BI
Power Automate is a service that helps you create automated workflows between your favorite apps and services to synchronize files.
SQL Murder Mystery is a game designed to help learners learn SQL concepts and commands while trying to solve an intriguing crime. A crime inspired this mystery game in the neighboring Terminal City. Joon Park and Cathy He created the game while they were Knight Lab fellows. It was adapted for the web by Joe Germuska. Thus, you can also solve the crime right on the web SQLite environment. The game revolves around a murder case committed around January 15, 2018, in SQL city. Using police reports and the town databases, you're to help the detective solve this murder case.
Structured Query Language (SQL) is a standardized programming language designed for managing and interacting with relational databases. It plays a crucial role in data retrieval, manipulation, and the overall administration of relational databases.
A more objective and practical application oriented test of competency
How to build complex, insights-rich, interactive reports and dashboards in Power BI.
Comprehensive financial modeling and DCF Valuation, a Model Input Sheet for a SaaS company. - monthly recurring revenue (MRR) - customer acquisition cost (CAC) - average revenue per customer (ARPC) - cost of revenue - different scenarios - overhead expenses - debt raising with timing, moratorium (if any), interest rate, repayment schedule and other details of the debts - equity raise - capital expenditures - tax rate - bank overdraft facility rate