Total Sessions - 10
Session Dates - Each Sunday starting
Session Time - 11 AM- 12&nbsp;PM IST
Benefits
<ul>
	<li>10-week intensive program&nbsp;with interactive sessions and assignments.</li>
	<li>Covers all&nbsp;aspects of FP&amp;A&nbsp;&ndash;&nbsp;FP&amp;A, PowerBI, Financial Modelling</li>
	<li>Industry-relevant curriculum&nbsp;designed by FP&amp;A professionals.</li>
	<li>Expert instructors&nbsp;with extensive experience in the field.</li>
	<li>Recording Available&nbsp;- to access as per your need</li>
	<li>Study Material and Assignment files -&nbsp;Free PDF Handbook and Excel Assignment files&nbsp;for hands on experience</li>
	<li>Power BI&nbsp;option -&nbsp;Your chance to learn Power BI through a live session at subsidized fee</li>
	<li>Certificate -&nbsp;from an ISO 9001:2015 certified institute</li>
</ul>
Topics Covered
ADVANCE FP&amp;A
Module 1: Introduction to FP&amp;A
<ul>
	<li>Understanding FP&amp;A
	<ul>
		<li>Definition, role, and objectives of FP&amp;A</li>
		<li>FP&amp;A vs. Financial Accounting</li>
	</ul>
	</li>
	<li>&nbsp;Key Terminologies
	<ul>
		<li>Glossary of essential FP&amp;A terms (e.g., budget, forecast, variance, driver-based planning)</li>
	</ul>
	</li>
	<li>&nbsp;Demystifying FP&amp;A Myths
	<ul>
		<li>Common misconceptions about FP&amp;A and their impact</li>
	</ul>
	</li>
	<li>Core FP&amp;A Activities
	<ul>
		<li>Detailed overview of FP&amp;A functions (planning, budgeting, forecasting, analysis, reporting)</li>
	</ul>
	</li>
	<li>The FP&amp;A Calendar
	<ul>
		<li>Importance of a well-structured FP&amp;A calendar</li>
		<li>Key milestones and deadlines</li>
	</ul>
	</li>
</ul>
Module 2: Planning and Budgeting
<ul>
	<li>Strategic Planning
	<ul>
		<li>Aligning FP&amp;A with organizational goals</li>
		<li>Developing strategic financial plans</li>
	</ul>
	</li>
	<li>&nbsp;Annual Operating Plan
	<ul>
		<li>Translating strategy into actionable plans</li>
		<li>Key components of an AOP</li>
	</ul>
	</li>
	<li>Budgeting Fundamentals
	<ul>
		<li>Budgeting process, cycle, and KPIs</li>
		<li>Budgeting techniques and approaches (zero-based, incremental, activity-based)</li>
		<li>Practical budgeting exercises</li>
	</ul>
	</li>
	<li>Forecasting
	<ul>
		<li>Forecasting process and key inputs</li>
		<li>Rolling forecasts and their benefits</li>
		<li>Practical forecasting exercises</li>
	</ul>
	</li>
</ul>
Module 3: Variance Analysis
<ul>
	<li>Variance Analysis Process
	<ul>
		<li>Identifying and analyzing deviations from plan</li>
	</ul>
	</li>
	<li>Types of Variance Analysis
	<ul>
		<li>Sales variance, cost variance, profit variance, etc.</li>
	</ul>
	</li>
	<li>Practical Variance Analysis Assignments
	<ul>
		<li>Hands-on exercises to apply variance analysis concepts</li>
	</ul>
	</li>
</ul>
Module 4: Reporting and Communication
<ul>
	<li>FP&amp;A Reporting
	<ul>
		<li>Common FP&amp;A reports (financial statements, performance metrics, key indicators)</li>
		<li>Dashboard design and development</li>
	</ul>
	</li>
	<li>Data Storytelling
	<ul>
		<li>Effective communication of financial information</li>
		<li>Using visuals to convey insights</li>
	</ul>
	</li>
	<li>Business Acumen and Strategic Thinking
	<ul>
		<li>Developing a strong business understanding</li>
		<li>Applying financial knowledge to strategic decision-making</li>
	</ul>
	</li>
	<li>FP&amp;A Tools and Technology
	<ul>
		<li>Leveraging FP&amp;A software and tools (Excel, BI tools, planning software)</li>
		<li>Exploring the role of AI in FP&amp;A</li>
	</ul>
	</li>
	<li>Management Reporting
	<ul>
		<li>Tailoring reports to different audiences</li>
		<li>Budget vs. actual reporting</li>
		<li>Cash flow forecasting and flash reports</li>
	</ul>
	</li>
	<li>Excel Proficiency
	<ul>
		<li>Essential Excel functions for FP&amp;A</li>
	</ul>
	</li>
	<li>Reporting Exercises and Assignments
	<ul>
		<li>Practical application of reporting skills</li>
	</ul>
	</li>
</ul>
Financial Modeling&nbsp;
<ul>
	<li>Building 3 Statement Model</li>
	<li>What If Analysis</li>
	<li>Financial Modeling Exercise</li>
	<li>Project Evaluation Tools</li>
	<li>NPV, IRR and Payback period</li>
	<li>Discounted Cash Flow</li>
	<li>Financial Modeling Exercise</li>
	<li>Assignment</li>
</ul>
Trainers
CA Vini Goel
CA Vini Goel is a seasoned finance professional with over 12 years of experience in Financial Planning and Analysis, Consolidation, and Reporting. She currently works at PWC and has previously held positions at prestigious organizations like HSBC, ICAI, and HCL. When not immersed in her work, Vini enjoys reading and traveling.
Gaurav Sharma
A seasoned FP&amp;A expert with 18 years of experience at leading companies like Airtel, Genpact, Infosys, and IHG. Currently working as an Associate Director FP&amp;A at Pyramid Consulting Inc. He has been helping aspiring professionals build a career in FP&amp;A for over 5 years. An MBA in Applied Finance and Leadership and Strategy from Narsee Monjee Institute of Management Studies, he has held several guest lectures at DTU, Delhi, IMA Delhi Chapter House, SAGE University Bhopal, and IIM Sirmaur.

Elevate your FP&amp;A expertise with this targeted Excel course. Master essential formulas, functions, data analysis, and financial modeling techniques designed to optimize your planning and analysis processes.
Benefits
<ul>
	<li>Live Session&nbsp;</li>
	<li>Real world excel file for assignments</li>
	<li>Weekly assignments and feedback</li>
	<li>PDF containing summary of excel shortcuts and functions</li>
	<li>Certificate on completion</li>
</ul>
This course is your gateway to FP&amp;A proficiency in Excel. You will learn:
<ul>
	<li>Advanced formulas and functions for financial calculations</li>
	<li>Data manipulation, cleaning, and transformation</li>
	<li>PivotTables and data visualization for clear reporting</li>
	<li>Building dynamic financial models for forecasting and scenario planning</li>
	<li>Excel shortcuts and best practices tailored to FP&amp;A</li>
</ul>
Functions Covered
<ul>
	<li>Data gathering and Compilation - Pivot, Sumif, Sumifs, Subtotal, Aggregate</li>
	<li>Formatting -Conditional Formatting, Table, Trace Precedents, Trace Dependents</li>
	<li>Data from other sources - Vlookup, Hlookup, Xlookup,IndexMatch</li>
	<li>Forecasting - Average, Forecast, Slope, Intercept</li>
	<li>Data Simulation - Whatif, Scenario Manager, Goal Seek,Data Table</li>
	<li>Presentation - Charts, Graphs, Slicers</li>
</ul>
Session 1
If, Swtich, Vlookup, Index Match, Xlookup,Scan, EO Month,NetworkDays, WorkDay, WeekDay, ChooseColumns,Chooserows,Take,VStack,HStack
Data, Table, Pivot,Slicers, Charts,Bar Chart, Stack Chart,Combo Chart, Waterfall Chart, Sunburst Chart
Session 4
Navigation. Watch Window, GoTo, Data Validation, Checkbox, Combo box.Whatif Analysis, Goal Seek, Data Table, Scenario Manager, Forecast Sheet
&nbsp;
Instructors
Santosh Subudhi, a seasoned Excel expert with over 17 years of experience in renowned organizations like TCS and Genpact. He has honed his skills to a mastery level, making him a sought-after professional in the field. Passionate about sharing his knowledge, Santosh&nbsp;runs a popular YouTube channel dedicated to guiding students and young professionals. His channel offers comprehensive tutorials and practical tips to help individuals master the art of MS Excel.
Gaurav Sharma:&nbsp;A seasoned FP&amp;A specialist with 17 years of experience at leading companies like Airtel, Genpact, Infosys, and IHG. Currently working as an Associate Director FP&amp;A at Pyramid Consulting Inc. He has been helping aspiring professionals build a career in FP&amp;A for over 5 years. An MBA in Applied Finance and Leadership and Strategy from Narsee Monjee Institute of Management Studies, he has held several guest lectures at DTU, Delhi, IMA Delhi Chapter House, SAGE University Bhopal, and IIM Sirmaur.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
<div id="m1fc0fse" style="display: none;">&nbsp;</div>

Master the Art of Cracking Big 4 FP&amp;A Interviews
Are you ready to take your FP&amp;A career to the next level? This comprehensive course is designed to equip you with the essential skills and knowledge to ace your Big 4 FP&amp;A interviews.
Key Highlights:
<ul>
	<li>Deep Dive into FP&amp;A Fundamentals: Gain a solid understanding of core FP&amp;A concepts, methodologies, and best practices.</li>
	<li>Mastering Common Interview Questions: Prepare for the most frequently asked questions and learn how to deliver impactful answers.</li>
	<li>Industry Insights and Trends: Stay up-to-date with the latest developments in the FP&amp;A industry, giving you a competitive edge.</li>
	<li>Sharpened Communication and Presentation Skills: Learn to effectively articulate your ideas and present complex financial information with confidence.</li>
	<li>Enhanced Problem-Solving and Critical Thinking Abilities: Develop the skills to analyze complex financial scenarios and provide insightful solutions.</li>
	<li>Boost Your Interview Performance: Gain confidence, improve your interviewing techniques, and make a lasting impression on potential employers.</li>
</ul>
Enroll now and take your FP&amp;A career to new heights!
Trainers
CA Vini Goel
CA Vini Goel is a seasoned finance professional with over 12 years of experience in Financial Planning and Analysis, Consolidation, and Reporting. She currently works at PWC and has previously held positions at prestigious organizations like HSBC, ICAI, and HCL. When not immersed in her work, Vini enjoys reading and traveling.
Gaurav Sharma
A seasoned FP&amp;A specialist with 17 years of experience at leading companies like Airtel, Genpact, Infosys, and IHG. Currently working as an Associate Director FP&amp;A at Pyramid Consulting Inc. He has been helping aspiring professionals build a career in FP&amp;A for over 5 years. An MBA in Applied Finance and Leadership and Strategy from Narsee Monjee Institute of Management Studies, he has held several guest lectures at DTU, Delhi, IMA Delhi Chapter House, SAGE University Bhopal, and IIM Sirmaur.
&nbsp;
FAQs
Q: What is the format of the course? A: This is a pre-recorded online course, which means you can access the content at your own pace and convenience.
Q: How long is the course? A: The course duration is approximately 1 hour 30 minutes
Q: What is the level of the course? A: The course is designed for both beginners and experienced professionals looking to enhance their FP&amp;A interview skills.
Q: What are the prerequisites for this course? A: Basic understanding of financial concepts and a keen interest in FP&amp;A.
Q: What is the mode of delivery? A: The course is delivered through pre-recorded video lectures.
Q: Will there be any live Q&amp;A sessions? A: While we don&#39;t offer live Q&amp;A sessions, we provide a dedicated forum where you can ask questions and interact with other learners.
Q: How long is the course access? A: You will be able to&nbsp;access the course content for a period of 1 year from the date of enrolment.
Q: Can I download the course content? A: No, course content cannot be downloaded..
Q: How can I contact the course support team? A: You can contact our support team through via email at allfintalk@gmail.com
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Live Session on Sunday 11th Aug 2024 - 12:00 PM - `1.30 PM
Topics Covered
<ul>
	<li>Budgeting
	<ul>
		<li>Types of Budgeting</li>
		<li>Budgeting Approach</li>
		<li>Budgeting Cycle</li>
	</ul>
	</li>
	<li>Forecasting</li>
	<li>Rolling Forecast</li>
	<li>Management Reporting</li>
	<li>Common FP&amp;A Reports</li>
</ul>
Training Methodolgy - Through practical real life scenarios
Mode-&nbsp; Online (Live) - Recording available for registered users
Medium - English
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Courses

₹12,000
₹18,000
34% off

₹599

₹1,200
₹2,000
40% off

₹599
₹799
26% off

₹2,000

Quick Links

Download App