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.
0/4
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
0/9
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
0/8
Prepayment Sheet – Final Outcome
02:19
Understanding Prepayment
03:03
Update Basic Information
08:32
Understanding Prepaymet Expenses
04:55
Headings and Double Entry for Prepayment
04:08
Formulas and Spreading Expenses Across Periods
17:01
Table and Adjustments
05:22
How to Get the Summary through Pivot Table
04:30
Creating a Payroll Sheet with Automated Payslips
0/10
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
0/8
Supplier SOA – Final Outcome
01:49
Design the SOA
05:19
Supplier Dropdown List
03:07
Filter Data by Supplier and Date Range
07:57
Automatic Boader based on cell Value
01:53
Error Handling
01:29
Filter Values based on Transaction Type
07:21
Why Should we structure data using a Table
03:07
Building a Fixed Asset Tracker with Depreciation
0/5
Fixed Asset – Final Outcome
01:49
Updating of Basic Information
07:38
Calculating the Total
02:18
Table and Formattings
03:17
Accunting Entry for Depreciation
02:41
Creating a Dynamic Loan Amortization Schedule
0/8
Loan Amortization – Final Outcome
01:19
Design Loan Amortization Schedule
04:54
Dynamic Numbering
02:33
Payment Calculation
07:38
Principal Payment Calculation
03:00
Interest Payment Calculation
04:11
Automatic Bordering
02:18
Final Total Calculation
02:36
Creating a Daily Cash Flow Planner
0/9
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
0/6
Ageing Summary – Final Outcome
01:10
Understanding Ageing Summary vs SOA
02:40
Design the Ageing Summary Sheet
06:02
Dropdown Customer Name
04:15
Filter Full Data
06:54
Calculate Ageing
18:20
Creating an Annual Budget Plan
0/6
Budget – Final Outcome
01:36
Introduction to Budget
01:54
Design the budget Template
09:10
Budget Starting Point
04:21
Understanding Cash In and Out Flows
08:55
Linking the Flows
04:00
Microsoft Excel for Accountants – Sinhala
Previous
Next
0% Complete