Design and produce complex spreadsheets
(This page provides suggestions for content relating to this unit)
E-BOOKS
Using Excel 2019: The Step-by-Step Guide to Using Microsoft Excel 2019
Excel 2019 : business basics & beyond
Microsoft Excel Functions and Formulas with Excel 2019/Office 365
Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP
WEBSITES
What are file naming conventions?
The dangers of sitting: why sitting is the new smoking
WEBSITE DOCUMENTS
PROCEDURE: Computer File Management
Microsoft Excel VLOOKUP Refresher
VIDEOS
1 - 3 MINS
Office Safety - YouTube (1 min)
Excel Tutorial for Beginners | Excel Made Easy - YouTube (1 min)
Excel: Intro to Formulas - YouTube (3 mins)
4 - 5 MINS
T Test Introduction - YouTube (4 mins)
Excel: Working with Multiple Worksheets - YouTube (4 mins)
New Excel Linked Data Types! - YouTube (4 mins)
Excel: Formatting Cells - YouTube (4 mins)
Excel: Charts - YouTube (4 mins)
Excel: Cell Basics - YouTube (4 mins)
Excel: Intro to PivotTables - YouTube (4 mins)
Excel: Understanding Number Formats - YouTube (5 mins)
Do's & Don'ts of Excel Spreadsheet Design (with Examples) - YouTube (5 mins)
10+ MINS
How to Create & Use Excel Macros (Real world example) - YouTube (10 mins)
Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!) - YouTube (13 mins)
Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) - YouTube (15 mins)
How to Link Data in Multiple Excel Workbooks: A Step-by-Step Guide - YouTube (15 mins)
LIBRARY RESOURCES
Database
Videos
Provide financial and business performance information
(This page provides suggestions for content relating to this unit)
PHYSICAL BOOKS
Provide financial & business performance information (Copies available at 2 Library sites)
WEBSITES
Objectives of Financial Management
Financial Management - Meaning, Scope, Objectives & Functions
Chapter 5: Financial Reporting Requirements and Accounting Standards (Australian Government: Treasury)
Operational Risk Overview, Importance, and Examples
Working Capital Management Explained: How It Works
What is Working Capital Management?
Financial Ratio Analysis: Definition, Types, Examples, and How to Use
What Is Weighted Average Cost of Capital (WACC)?
Dividend Policy: What It Is and How the 3 Types Work
Capital Budgeting: What It Is and How It Works
Net Present Value (NPV): What It Means and Steps to Calculate It
VIDEOS
2 - 3 MINS
What is debt financing? - YouTube (2 mins)
What is equity financing? - YouTube (2 mins)
Understand Credit Risk - YouTube (2 mins)
What is Market Risk? - YouTube (2 mins)
3 Minutes! Financial Ratios & Financial Ratio Analysis Explained & Financial Statement Analysis - YouTube (3 mins)
5 - 6 MINS
Hybrids Securities - YouTube (5 mins)
Working Capital Management - What Is It & Why It's Important - YouTube (5 mins)
Types of Financial Analysis - YouTube (5 mins)
Liquidity Risk Management - YouTube (6 mins)
Dividend Policy | Dividend Definitions - YouTube (7 mins)
8+ MINS
Operational Risk Management in Financial Services - YouTube (8 mins)
What is Financial Management? Types, Functions, Objectives - YouTube (8 mins)
Capital Budgeting: NPV, IRR, Payback | MUST-KNOW for Finance Roles - YouTube (10 mins)
Capital Financing with Debt: Intro to Corporate Finance - YouTube (14 mins)
LIBRARY RESOURCES
Database
Videos
Prepare tax documentation for individuals
(This page provides suggestions for content relating to this unit)
E-BOOKS
Foundations of taxation law 2020
Tax for Australians for dummies
PHYSICAL BOOKS
Prepare tax documentation for individuals (17th ed. 2020)- Copies available in 7 Library sites
WEBSITES
New to tax and super | Australian Taxation Office
Understanding the Australian Income Tax System
A Guide to Taxation in Australia
Low and middle income earner tax offsets
Tax-free threshold for newcomers to Australia
Foreign and temporary residents (ATO)
WEBSITE DOCUMENTS
Tax in Australia - What you need to know
Lower, fairer and simpler taxes
VIDEOS
The ATO has changed how you can claim tax deductions | The Business | ABC News - YouTube (5 mins)
LIBRARY RESOURCES
Manage budgets and forecasts
(This page provides suggestions for content relating to this unit)
E-BOOKS
10 Steps to Successful Budgeting
Smart Skills: Mastering the Numbers
PHYSICAL BOOKS
Manage budgets and financial plans
WEBSITES
How to create a small business budget
Budget vs. forecast: 3 key differences
Double-entry bookkeeping explained
Develop your corporate governance structure
VIDEOS
Double entry bookkeeping explained simply in 3:35 minutes (by a CPA) - YouTube (3.5 mins)
Spotlight on the Difference between Budgeting and Forecasting - YouTube (5 mins)
Monthly Budgeting & Forecasting Model - YouTube (5 mins)
How to Create a Budget for Your Business - YouTube (9 mins)
LIBRARY RESOURCES
Prepare financial reports for corporate entities
(This page provides suggestions for content relating to this unit)
E-BOOKS
Painless business finance: from bookkeeping to financial reports and ratios
Mastering QuickBooks 2020: The Ultimate Guide to Bookkeeping and QuickBooks Online
Smart Skills: Mastering the Numbers
PHYSICAL BOOKS
Prepare Financial Reports for Corporate Entities 5th edition
Prepare Financial Reports for Corporate Entities 6th edition
Company Accounting : prepare financial reports for corporate entities
Accounting: business reporting for decision making
WEBSITES
Financial reporting in Australia
Chapter 5: Financial Reporting Requirements and Accounting Standards
Annual reports for corporate Commonwealth entities
A Guide to Understanding Annual Reports
VIDEOS
Three Financial Statements - YouTube (1 min)
Financial Statements: all the basics in 8 Mins! - YouTube (8 mins)
LIBRARY RESOURCES
Implement and maintain internal control procedures
(This page provides suggestions for content relating to this unit)
PHYSICAL BOOKS
Internal Control Procedures 5th edition
Internal Control Procedures 4th edition
Internal Controls and Corporate Governance
WEBSITES
Internal Controls: Definition, Types, and Importance
Types of Internal Controls Used for Financial Accounting
VIDEOS
Corporate Governance Fundamentals: Internal Controls - YouTube (3 mins)
What are Internal Controls - YouTube (4 mins)
Internal Control | Revenue Cycle - YouTube (4 mins)
4 Steps to Design Internal Controls - YouTube (20 mins)
LIBRARY RESOURCES
Provide management accounting information
(This page provides suggestions for content relating to this unit)
E-BOOKS
Management: A Practical Introduction
10 Steps to Successful Budgeting
Research on Firm Financial Performance and Consumer Behavior
Research on Professional Responsibility and Ethics in Accounting
Environmental Accounting, Sustainability and Accountability
PHYSICAL BOOKS
Provide Management Accounting Information 9th edition
Provide Management Accounting Information 8th edition
Provide Financial & Business Performance Information
Accounting for Non-Accountants: A Manual for Managers and Students
Accounting Information Systems
Financial Accounting: Reporting, Analysis and Decision Making
Business Foundations: A Changing World
WEBSITES
Cost Concepts, Categories and Flows
Common Accounting Concepts and Principles
Chapter 5: Financial Reporting Requirements and Accounting Standards
How To Prepare A Budget For An Organization: 4 Steps
Flow of Costs (Process Costing)
Cost variance analysis definition
VIDEOS
What is Standard Costing? What is Variance? Advantages, Disadvantages - YouTube (6 mins)
What is Variance Analysis? - YouTube (8 mins)
MA34 - Variance Analysis - Explained - YouTube (11 mins)
The Cash Flow Statement for Beginners - YouTube (15 mins)
Quintessential TV - YouTube Channel
LIBRARY RESOURCES