Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel for Accountants - Balance Sheet, Income Statement, Cash Flow, and Financial Analysis

Simon Sez IT via YouTube

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

Reviews

Start your review of Excel for Accountants - Balance Sheet, Income Statement, Cash Flow, and Financial Analysis

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.