Excel for Accountants - Balance Sheet, Income Statement, Cash Flow, and Financial Analysis
Simon Sez IT via YouTube
AI Adoption - Drive Business Value and Organizational Impact
PowerBI Data Analyst - Create visualizations and dashboards from scratch
Overview
Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
Master Excel for comprehensive financial statement creation and analysis in this specialized training webinar designed for accounting and finance professionals. Learn to construct balance sheets, income statements, and cash flow statements while developing advanced Excel skills for financial reporting and analysis. Explore the fundamentals of each financial statement type, understanding their structure and purpose in financial reporting. Discover how to add formulas and create links between financial statements to ensure accuracy and consistency across your financial documents. Develop expertise in ratio analysis through comprehensive two-part instruction covering key financial ratios and their applications. Gain the ability to decode financial health using ratios and analytical techniques that provide meaningful insights into business performance. Enhance your Excel proficiency while building essential financial management capabilities that streamline reporting processes and improve analytical accuracy for professional accounting and finance work.
Syllabus
00:00:00 - Overview of the Balance Sheet
00:09:36 - Overview of the Income Statement
00:17:16 - Overview of the Cash Flow Statement
00:26:17 - Adding Formulas and Links to the Financial Statements
00:36:14 - Ratio Analysis Part 1 of 2
00:45:45 - Ratio Analysis Part 2 of 2
00:55:12 - Decoding Financial Health with Ratios and Analysis
Taught by
Simon Sez IT