Watch Past #EiEFreshTalk

Episode 12 – CA. Vijay Agarwal

Listen to our esteemed Speaker
CA. Vijay Agarwal by New Formulas in MS Excel and its use cases.

Key Takeaways:

• Dynamic Arrays: New Type of Calculation.
• Seven New Excel Functions : Syntax & Use Cases
• Two New Errors and how to fix them.
• Implicit intersection operator: @ in new formulas.

Episode 11 – CA. Swetha Kochar

Listen to our esteemed Speaker
CA. Swetha Kochar on Managing Business Continuity and Finance during Uncertain Times.

Key Takeaways:

• Ways to maintain business profitability during and post crisis
• Avenues for revenue growth
• Tangible ideas for cost reduction
• How to best manage cash flows in challenging times
• Key finance mantras for business success

Episode 10 – CA. Sandeep Kothari

Listen to our esteemed Speaker
CA. Sandeep Kothari on Modeling a Franchise Business Opportunity.

Key Takeaways:

• Understand the process of Business Evaluation
• Forecast Revenues and Expenses
• Prepare Financial Statements
• Compute Free Cash Flows and Decision making with Capital Budgeting
• Sensitivity Analysis

Episode 9 – CA. Amit P Nahar

Listen to our esteemed Speaker
CA. Amit P Nahar on Design Your Professional Services Business For Acceleration.

Key Takeaways:

• Dis-empowering Myths of Professional Services Businesses
• Principles & Strategies To Design Your Professional Services Businesses
• Professional Services Business Automation & Acceleration Blueprint

Episode 8 – Sangeeta Sumesh

Listen to our esteemed Speaker
Sangeeta Sumesh on Maximising Business Potential.

Key Takeaways:

• Adopting Growth mindset
• Building Teams
• Churning Business wheel
• Designing Action plan

Episode 7 – Sumit Bansal

Listen to our esteemed Speaker
Sumit Bansal on 7 Excel Features Pros Use to be More Efficient.

Key Takeaways:

• Conditional Formatting
• Number formatting
• Find and Replace
• Excel Tables
• Paste Special
• Flash Fill
• Pivot Table

Episode 6 – CA Saran Kumar U

Listen to our esteemed Speaker
CA Saran Kumar U on Spreadsheet and Forensic – A Relation.

Key Takeaways:

• What you see in Excel is not always correct – Case Studies
• Forensic Aspects in Spreadsheet – Case Studies
• Errors reveal some story – Case Studies
• Benford’s Law in Excel

Episode 5 – Prateek Kapoor 

Listen to our esteemed Speaker
Prateek Kapoor on New Finance Skills to adopt during the Digital Era.

Key Takeaways:

• Reduces myth around hype around Digital transformation
• Brings clarity on choosing the right path
• Helps choose right career direction
• Reduces anxiety and race around digital transformation
• Helps SWOT analysis of one self
• Decision which digital technology to follow
• Choose Digital Accountant or Digital Transformation Leader or Entrepreneur

Episode 4 – Chandoo

Listen to our esteemed Speaker
Chandoo aka Purnachandra R Duggirala on 5 Must-Have Charts in any Finance Person’s Toolbox.

5 Must have charts suggested by Chandoo:

• Budget vs. Actual thermometer
• Variance chart
• Table
• Interactive chart
• Forecast chart

Episode 3 – Danielle Stein Fairhurst

Listen to our esteemed Speaker
Danielle Stein Fairhurst on Best Practices in Financial Modeling.

Key Takeaways:

• Why and how of assumptions documentation
• Strategies to reduce error
• Building error checks into your financial models
• Tips, tricks, dos and don’t for best practice modeling

Episode 2 – CA. Premlata Daga

Listen to our esteemed Speaker
CA. Premlata Daga on Inventory Analysis in Tally. ERP 9.

Key takeaways:

• Inventory Accounting in Manufacturing Entities in Tally.
• Common errors in Accounting of stock related transactions in Manufacturing Organisations.
• Missing in-built controls in closing stock valuation in Tally
• Stock consumption entries in Tally.
• Integration of Accounting and Inventory records in Tally

Episode 1 (Part 2/2) – CA. M P Vijay Kumar

Listen to our esteemed Speaker
CA. M P Vijay Kumar on Decision Making in Uncertain Times.

The discussion covers the following points:

• Pause, take stock, prioritize and approach the tasks in hand
• Involve more people in decision making than during normal times, relax hierarchical models during this period
• Make critical and smart choices, anticipate multiple scenarios and have plans for each of them
• Engage others to identify small decision-making areas which can contribute to the bigger cause
• Set up a command center / war room
• Identify situational leaders who can handle things well during crisis situations with good judgement and character and empower them

Episode 1 (Part 1/2) – CA V. Pattabhi Ram

Listen to our esteemed Speaker
CA V. Pattabhi Ram talk on Financial Modelling, its Scope, Skillsets required, Avenues for job opportunities and Road ahead for Financial Modelling.

Scope of Financial Modeling include discussion on the following:

• Business Planning
• Valuation and the evaluation of Financial modeling as an independent profession
• Stock valuation and portfolio building
• Scenario Analysis
• Simulation
• Capital Expenditure related
• Credit rating and credit research
• Key factors to consider in financial modeling
• Working Capital
• Interfirm analysis / Comparison between companies