Note: After selecting 'Buy Now', please follow the provided steps to complete your payment. Once the payment is processed, the access link will be sent directly to your email. If you don’t see it, be sure to check your spam or junk folder. Kindly double-check your email address to avoid any issues with delivery.

Financial Statement Creation and Analysis using Microsoft Excel

Master the fundamentals of accounting and financial statement analysis with a step-by-step guide using Microsoft Excel. Learn how to create income statements, balance sheets, and cash flow statements from scratch, and gain invaluable skills for your career.

[Enroll Now - Start Your Journey Today!]

What You Will Learn in This Course

This course will equip you with the knowledge to confidently create and analyze financial reports. We’ll take you step-by-step through the process, from basic accounting principles to advanced analysis techniques.

Course Highlights:

Double Entry Principle: Understand the core of accounting and how to create a journal from scratch.
Income Statement Creation: Learn how to build an income statement directly from Excel.
Balance Sheet Fundamentals: Master the structure and formulation of balance sheets.
Cash Flow Statement Creation: Learn the essentials of cash flow and its direct impact on business.
Financial Statement Analysis: Discover how to analyze and interpret financial statements for better business decisions.
Excel Features: Use Excel's powerful tools like pivot tables, slicers, and power queries to automate your work and improve accuracy.
Industry Standards: Learn how to create statements like major corporations such as MTN, Dangote, and Unilever.

Course Outline

Module 1: Introduction to Financial Statements

Lesson 1: What Are Financial Statements?
Lesson 2: Why Are Financial Statements Important?
Lesson 3: Types of Financial Statements
Income Statement (Profit & Loss Statement)
Balance Sheet (Statement of Financial Position)
Cash Flow Statement
Statement of Changes in Equity

Module 2: Principles and Standards of Financial Accounting

Lesson 1: Accounting Principles and Standards (GAAP, IFRS)
Lesson 2: Accrual vs. Cash Accounting
Lesson 3: Recording and Summarizing Transactions

Module 3: Foundations of Financial Recordkeeping in Excel

Lesson 1: Recording Business Transactions
Lesson 2: Preparing General Journal
Lesson 3: Creating Ledger Accounts
Lesson 4: Preparing Trial Balance

Module 4: Creating, Analyzing, and Reporting Income Statements

Lesson 1: Components of an Income Statement
Lesson 2: Preparing an Income Statement for a Company
Lesson 3: Analyzing the Income Statement
Lesson 4: Preparing a One-Page Report on the Income Statement

Module 5: Creating, Analyzing, and Reporting Statement of Financial Position

Lesson 1: Components of a Balance Sheet
Lesson 2: Preparing a Balance Sheet for a Company
Lesson 3: Analyzing the Balance Sheet
Lesson 4: Preparing a One-Page Report on the Balance Sheet

Module 6: Creating, Analyzing, and Reporting Statement of Cash Flow

Lesson 1: Components of a Cash Flow Statement
Lesson 2: Preparing a Cash Flow Statement for a Company
Lesson 3: Analyzing the Cash Flow Statement
Lesson 4: Preparing a One-Page Report on the Cash Flow Statement

Module 7: Creating Financial Statements Using the Comparative Analysis Format

Lesson 1: Creating the Income Statement using the Comparative Analysis Format
Lesson 2: Creating Balance Sheet using the Comparative Analysis Format
Lesson 3: Creating Cash Flow Statement using the Comparative Analysis Format

Module 8: Financial Statement Analysis of Microsoft Corporation

Lesson 1: Analyzing Microsoft’s Income Statement
Lesson 2: Analyzing Microsoft’s Balance Sheet
Lesson 3: Analyzing Microsoft’s Cash Flow Statement

Module 9: Financial Statement Analysis of MTN Nigeria Communications Plc

Lesson 1: Analyzing MTN Nigeria’s Income Statement
Lesson 2: Analyzing MTN Nigeria’s Balance Sheet
Lesson 3: Analyzing MTN Nigeria’s Cash Flow Statement

Module 10: Financial Statement Analysis of Multiverse Mining and Exploration Plc

Lesson 1: Analyzing Multiverse Income Statement
Lesson 2: Analyzing Multiverse Balance Sheet
Lesson 3: Analyzing Multiverse Cash Flow Statement

Module 11: Financial Statement Analysis of Dangote Sugar Refinery Plc

Lesson 1: Analyzing Dangote Sugar’s Income Statement
Lesson 2: Analyzing Dangote Sugar’s Balance Sheet
Lesson 3: Analyzing Dangote Sugar’s Cash Flow Statement

Module 12: Financial Statement Analysis of Unilever Nigeria Plc

Lesson 1: Analyzing Unilever Nigeria’s Income Statement
Lesson 2: Analyzing Unilever Nigeria’s Balance Sheet
Lesson 3: Analyzing Unilever Nigeria’s Cash Flow Statement

Who Should Enroll in This Course?

This course is perfect for:

Aspiring Finance Professionals: If you're aiming for roles like financial analyst, accountant, or CFO, this course is essential to your career path.
Business Owners & Entrepreneurs: Learn how to create your own financial reports and understand your company's financial health.
Students & Graduates: Ideal for those studying accounting, finance, or business, this course will give you practical skills for the workforce.
Anyone Looking to Improve Their Excel Skills for Financial Reporting: If you want to take your Excel skills beyond basic functions and apply them to real-world financial scenarios, this course is for you.

Meet Your Instructor: Muhammad Jamilu Abdullahi

Muhammad Jamilu Abdullahi is a seasoned finance expert with over 3 years of experience in financial analysis, accounting, and teaching. Having worked with top companies such as Newage Network and Daily Trust, he is passionate about empowering others to build strong financial foundations using Microsoft Excel. his hands-on approach ensures that students not only understand the theory but also gain practical, actionable skills.

Frequently Asked Questions

Q: Do I need any prior experience with Excel?

No, this course starts from the basics, and no prior experience with Excel is required. However, basic computer literacy will be helpful.

Q: Will I get a certificate after completing the course?

Yes, you’ll receive a certificate of completion, which can be shared on LinkedIn or added to your resume.

Q: How long will it take to complete the course?

The course consists of 7 hours of content, and you can move at your own pace. Most students complete it within 2 weeks.

Contact Information:

Email: proskills.biz@gmail.com

WhatsApp: +2348143382733

Financial Statement Creation and Analysis using Microsoft Excel

Frequently bought together