Loan Amortization – Final Outcome - LearnNow

Loan Amortization – Final Outcome - LearnNow

Microsoft Excel for Accountants - Sinhala Loan Amortization - Final Outcome

Microsoft Excel for Accountants - Sinhala

0% Completed

Introduction

Purpose and Target Audience of This Course

Video - 00:5:31 mins

Course Requirements and Important Disclaimer

Video - 00:4:50 mins

How to Access Training Materials

Video - 00:3:4 mins

How to get MS 365

Video - 00:7:2 mins

Building a Practical Sales Invoice from Scratch

Sales Invoice - Final Results

Video - 00:1:36 mins

Update Basic Company Information

Video - 00:7:39 mins

Setting the Correct Margin

Video - 00:2:42 mins

Updating Invoice Details - Dropdown

Video - 00:15:21 mins

Data Validation - Date Format

Video - 00:3:17 mins

Customer Information using X-Lookup

Video - 00:7:37 mins

Design Invoice Data Fields

Video - 00:4:9 mins

Give Functionality to the Invoice - Sumif

Video - 00:5:54 mins

Grab Item Description and test the Invoice

Video - 00:10:42 mins

Prepayment Tracker – Expense Recognition

Prepayment Sheet - Final Outcome

Video - 00:2:19 mins

Understanding Prepayment

Video - 00:3:3 mins

Update Basic Information

Video - 00:8:32 mins

Understanding Prepaymet Expenses

Video - 00:4:55 mins

Headings and Double Entry for Prepayment

Video - 00:4:8 mins

Formulas and Spreading Expenses Across Periods

Video - 00:17:1 mins

Table and Adjustments

Video - 00:5:22 mins

How to Get the Summary through Pivot Table

Video - 00:4:30 mins

Creating a Payroll Sheet with Automated Payslips

Payroll Sheet - Final Outcome

Video - 00:2:53 mins

Payroll Sheet - Agenda

Video - 00:1:31 mins

Month and Year Drpdown

Video - 00:3:11 mins

Update Basic Employee Information

Video - 00:2:10 mins

Dynamic Salary Calculation

Video - 00:12:26 mins

Video - 00:4:42 mins

EPF and Paye Calculations

Video - 00:8:56 mins

Adjustments and Final Salary

Video - 00:2:14 mins

Formatting and Table

Video - 00:7:20 mins

Create a Payslip

Video - 00:20:22 mins

Tracking Supplier Balances with Statement of Accounts

Supplier SOA - Final Outcome

Video - 00:1:49 mins

Video - 00:5:19 mins

Supplier Dropdown List

Video - 00:3:7 mins

Filter Data by Supplier and Date Range

Video - 00:7:57 mins

Automatic Boader based on cell Value

Video - 00:1:53 mins

Video - 00:1:29 mins

Filter Values based on Transaction Type

Video - 00:7:21 mins

Why Should we structure data using a Table

Video - 00:3:7 mins

Building a Fixed Asset Tracker with Depreciation

Fixed Asset - Final Outcome

Video - 00:1:49 mins

Updating of Basic Information

Video - 00:7:38 mins

Calculate the Depreciation

Video - 05:47:00 mins

Calculating the Total

Video - 00:2:18 mins

Table and Formattings

Video - 00:3:17 mins

Accunting Entry for Depreciation

Video - 00:2:41 mins

Creating a Dynamic Loan Amortization Schedule

Loan Amortization - Final Outcome

Video - 00:1:19 mins

Design Loan Amortization Schedule

Video - 00:4:54 mins

Dynamic Numbering

Video - 00:2:33 mins

Payment Calculation

Video - 00:7:38 mins

Principal Payment Calculation

Video - 00:3:00 mins

Interest Payment Calculation

Video - 00:4:11 mins

Automatic Bordering

Video - 00:2:18 mins

Final Total Calculation

Video - 00:2:36 mins

Creating a Daily Cash Flow Planner

Daily Cash Flow - Final Outcome

Video - 00:2:24 mins

Heading and Dropdowns

Video - 00:4:49 mins

Video - 00:12:32 mins

Create Cash in Flow Fields

Video - 00:3:23 mins

Create Cash Out Flow Fields

Video - 00:7:18 mins

Highlight Weekends using Conditional Formatting

Video - 00:5:30 mins

Opening and Closing Balances

Video - 00:5:45 mins

Copy and Create Cash flow Actual sheet

Video - 00:4:12 mins

Variance Report

Video - 00:9:14 mins

Creating a Customer Ageing Summary

Ageing Summary - Final Outcome

Video - 00:1:10 mins

Understanding Ageing Summary vs SOA

Video - 00:2:40 mins

Design the Ageing Summary Sheet

Video - 00:6:2 mins

Dropdown Customer Name

Video - 00:4:15 mins

Filter Full Data

Video - 00:6:54 mins

Calculate Ageing

Video - 00:18:20 mins

Creating an Annual Budget Plan

Budget - Final Outcome

Video - 00:1:36 mins

Introduction to Budget

Video - 00:1:54 mins

Design the budget Template

Video - 00:9:10 mins

Budget Starting Point

Video - 00:4:21 mins

Understanding Cash In and Out Flows

Video - 00:8:55 mins

Linking the Flows

Video - 00:4:00 mins

Announcements Reviews Live Classes Gradebook Certificate Course Info