Excel For Finance Accounting Beginner

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

What Will I Learn?

  • Understand the Excel interface and essential navigation for finance tasks

  • Use basic formulas (SUM, AVERAGE, IF) in accounting contexts

  • Create and manage financial tables and ledgers in Excel

  • Apply number formatting for currency, percentage, and accounting standards

  • Build simple income statements and balance sheets

  • Use sorting, filtering, and conditional formatting for financial data analysis

  • Learn to use basic charts to visualize financial trends

What Will You Learn?

  • Understand the Excel interface and essential navigation for finance tasks
  • Use basic formulas (SUM, AVERAGE, IF) in accounting contexts
  • Create and manage financial tables and ledgers in Excel
  • Apply number formatting for currency, percentage, and accounting standards
  • Build simple income statements and balance sheets
  • Use sorting, filtering, and conditional formatting for financial data analysis
  • Learn to use basic charts to visualize financial trends
  • Understand how to protect sheets and use data validation for secure inputs
  • Build foundational Excel skills for accounting and finance
  • Increase accuracy in recording and calculating financial data
  • Create basic financial statements in Excel with confidence
  • Improve data analysis skills using Excel filters and formulas
  • Understand practical accounting workflows through real examples
  • Reduce manual work by using templates and formatting tools
  • Learn to present financial data in a clear, professional manner

Course Content

Excel for Finance Accounting – Beginner

  • Excel for Finance Accounting – Beginner
    00:00

15 Rumus Excel

Cara Membuat Laporan Kas Masuk dan Keluar Harian – Buku Kas | Tutorial Excel Pemula

RUMUS+PIVOTTABLE Jurnal Umum sampai Laporan Keuangan

Laporan Keuangan Pemasukan dan Pengeluaran Otomatis di Excel

EXCEL : Jurnal Umum, Buku Besar & Neraca Saldo hanya dengan 3 rumus (VLOOKUP, SUMIF, IF)

Final Exam

Student Ratings & Reviews

No Review Yet
No Review Yet