Microsoft Excel for Accountants – Sinhala

About Course

මෙම course එක accountants ලාට ඉගැන්වීමට සැලසුම් කර ඇති අතර, එදිනෙදා accounting සහ finance වැඩ සඳහා භාවිතා වන practical, real-world Excel tools සෑදීමට උපදෙස් දෙයි. Hands-on projects නවයක් හරහා, ඔබ sales invoices, payroll with payslips, fixed asset registers, loan amortization schedules ආදිය වැනි professional spreadsheets scratch වලින් සෑදීමට ඉගෙන ගනු ඇත. ඔබ beginner හෝ Excel skills වැඩිදියුණු කිරීමට බලාපොරොත්තු වන experienced accountant කෙනෙකු වුවත්, මෙම course එක practical සහ job-focused learning experience එකක් ලබා දෙන අතර, එය ඔබට වේගවත්, බුද්ධිමත්ව සහ නිවැරදිව වැඩ කිරීමට උපකාරී වේ.

Automatic එකතුව සහිත සම්පූර්ණ විකුණුම් ඉන්වොයිස් template එකක් නිර්මාණය කිරීම.
වියදම් කළමනාකරණය සහ හඳුනාගැනීම සඳහා prepayment tracker එකක් සෑදීම.
Automatic payslips සහිත payroll sheet එකක් සැලසුම් කිරීම.
Statement of accounts භාවිතයෙන් supplier ක්‍රියාකාරකම් track කිරීම.
Depreciation ගණනය කිරීම් සහිත fixed asset register එකක් පවත්වාගෙන යාම.
පොලී/මුලික බෙදීම සහිත ගතික loan amortization schedule එකක් නිර්මාණය කිරීම.
Cash Flow නිරීක්ෂණය කිරීම සඳහා daily cash flow planner එකක් සෑදීම.
Ageing summary එකක් සමඟ ගනුදෙනුකරුවන්ගේ ශේෂ විශ්ලේෂණය කිරීම.
Financial forecasting සඳහා annual budget planner එකක් construct කිරීම.

Course Content

Introduction
This section introduces the course, shows who it's for, lists basic requirements, and explains how to get Excel and access the materials.

Purpose and Target Audience of This Course

05:31
Course Requirements and Important Disclaimer

04:50
How to Access Training Materials

03:04
How to get MS 365

07:02

Building a Practical Sales Invoice from Scratch

Sales Invoice – Final Results

01:36
Update Basic Company Information

07:39
Setting the Correct Margin

02:42
Updating Invoice Details – Dropdown

15:21
Data Validation – Date Format

03:17
Customer Information using X-Lookup

07:37
Design Invoice Data Fields

04:09
Give Functionality to the Invoice – Sumif

05:54
Grab Item Description and test the Invoice

10:42

Prepayment Tracker – Expense Recognition

Creating a Payroll Sheet with Automated Payslips

Payroll Sheet – Final Outcome

02:53
Payroll Sheet – Agenda

01:31
Month and Year Drpdown

03:11
Update Basic Employee Information

02:10
Dynamic Salary Calculation

12:26
OT Calculation

04:42
EPF and Paye Calculations

08:56
Adjustments and Final Salary

02:14
Formatting and Table

07:20
Create a Payslip

20:22

Tracking Supplier Balances with Statement of Accounts

Building a Fixed Asset Tracker with Depreciation

Creating a Dynamic Loan Amortization Schedule

Creating a Daily Cash Flow Planner

Daily Cash Flow – Final Outcome

02:24
Heading and Dropdowns

04:49
Setup the Date

12:32
Create Cash in Flow Fields

03:23
Create Cash Out Flow Fields

07:18
Highlight Weekends using Conditional Formatting

05:30
Opening and Closing Balances

05:45
Copy and Create Cash flow Actual sheet

04:12
Variance Report

09:14

Creating a Customer Ageing Summary

Creating an Annual Budget Plan

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction This section introduces the course, shows who it's for, lists basic requirements, and explains how to get Excel and access the materials.

Purpose and Target Audience of This Course

Course Requirements and Important Disclaimer

How to Access Training Materials

How to get MS 365

Building a Practical Sales Invoice from Scratch

Update Basic Company Information

Setting the Correct Margin

Updating Invoice Details – Dropdown

Data Validation – Date Format

Customer Information using X-Lookup

Design Invoice Data Fields

Give Functionality to the Invoice – Sumif

Grab Item Description and test the Invoice

Prepayment Tracker – Expense Recognition

Understanding Prepayment

Update Basic Information

Understanding Prepaymet Expenses

Headings and Double Entry for Prepayment

Formulas and Spreading Expenses Across Periods

Table and Adjustments

How to Get the Summary through Pivot Table

Creating a Payroll Sheet with Automated Payslips

Payroll Sheet – Agenda

Month and Year Drpdown

Update Basic Employee Information

Dynamic Salary Calculation

OT Calculation

EPF and Paye Calculations

Adjustments and Final Salary

Formatting and Table

Create a Payslip

Tracking Supplier Balances with Statement of Accounts

Design the SOA

Supplier Dropdown List

Filter Data by Supplier and Date Range

Automatic Boader based on cell Value

Error Handling

Filter Values based on Transaction Type

Why Should we structure data using a Table

Building a Fixed Asset Tracker with Depreciation

Updating of Basic Information

Calculating the Total

Table and Formattings

Accunting Entry for Depreciation

Creating a Dynamic Loan Amortization Schedule

Design Loan Amortization Schedule

Dynamic Numbering

Payment Calculation

Principal Payment Calculation

Interest Payment Calculation

Automatic Bordering

Final Total Calculation

Creating a Daily Cash Flow Planner

Heading and Dropdowns

Setup the Date

Create Cash in Flow Fields

Create Cash Out Flow Fields

Highlight Weekends using Conditional Formatting

Opening and Closing Balances

Copy and Create Cash flow Actual sheet

Variance Report

Creating a Customer Ageing Summary

Understanding Ageing Summary vs SOA

Design the Ageing Summary Sheet

Dropdown Customer Name

Filter Full Data

Calculate Ageing

Creating an Annual Budget Plan

Introduction to Budget

Design the budget Template

Budget Starting Point

Understanding Cash In and Out Flows

Linking the Flows

Student Ratings & Reviews

Quick Links

Resources

Introduction
This section introduces the course, shows who it's for, lists basic requirements, and explains how to get Excel and access the materials.