Image

Finance

Financial capability of our staff is integral to ensuring financial sustainability of TMR, and TMRs ability to achieve its vision.To ensure TMR can continue to achieve our financial goals it is imperative we:

  • Manage financial risks effectively - through good governance and risk mitigation strategies
  • Actively build staff capability in financial management, analysis and advice
  • Promote a continuous improvement culture
  • Resources are allocated consistently
  • Our funding sources are stable and maximised with a reduced reliance on government revenues
  • Our financial resources are used effectively and efficiently
graphical divider

Financial principles and accounting

Understand how and when to apply Australian accounting standards framework and practices, for particular types of transactions and events.

Provider Resource Location Type Time Skill level
Linkedin Learning Accounting Foundations

This course provides an introduction to the four basic types of accounting—bookkeeping and financial, managerial, and tax accounting—and explains the links between accounting, decision-making, business performance, and financial health

Online Course 2 hrs Beginner
Linkedin Learning Financial Accounting Foundations/a>

An overview of key financial statements, including the balance sheet and income statement, and the mechanics of accounting. Review some the current issues and emerging trends facing financial accountants, such as revenue recognition and tax deferral (US perspective).

Online Course 2 hrs Beginner
Linkedin Learning The importance of financial accounting

Designed to give business professionals—including managers, analysts, and entrepreneurs—the confidence they need to use financial data to drive strategic decision-making.

Online Course 2hr 29 min Beginner
YouTube The AASB -- It's function in our regulatory environment - Kevin Stevenson

Chairman of the Australian Accounting Standards Board (AASB), Kevin Stevenson discusses the AASB's current function in the Australian regulatory environment

Online Resource 4 min Beginner
Accelerate FBT Overview

Explores the various types of fringe benefits, identifies reportable fringe benefits and explains the employee declaration forms that need to be completed to minimise TMR's Fringe Benefits Tax.

Online Course 30 min Beginner
Accelerate GST overview

Understand what GST is, what the terminology means and how it is relevant to departmental operations.

Online Course 30 min Beginner
Accelerate GST tax codes

The course explains the different tax codes used within the department, and explains the type of transactions where the different codes apply.

Online Course 30 mins Beginner
Finance Hub TMR Vehicle Logging Trip Classification Guidelines

Taxation laws and TMR policy require that valid logbooks be maintained. From April 2020, TMR has replaced the manual logbook with an electronic (IVMS) solution in all QFleet vehicles. Logbooks will still be required for non-QFleet vehicles .

Online Resource 30 min Intermediate
YouTube Accounting Basics Explained Through a Story

This quick tutorial gives an introduction to accounting and explains the concepts of income statement (Profit & Loss), balance sheet and the accounting equation (Assets = Liabilities + Equity).

Online Resource 10 min Beginner
Finance Hub Managing Departmental assets

This resource explains what an asset is, asset master data and guidance on managing the life cycle of an a non-current asset.

Online Resource N/A Beginner
Finance Hub Managing and Improving Accounting processes – Accrual transactions

The purpose of this presentation is to introduce the accrual process. It outlines and discusses the different types of accruals and how each type is treated differently. The presentation is about 30 minutes in duration and moves automatically. Headphones or speakers are to be used as there is a commentary.

Online Resource 30 mins Beginner

Financial governance

Ensuring a foundation for sound decision making and high quality financial information

Provider Resource Location Type Time Skill level
Finance Hub Financial Delegations Manual

A component of the Project Management Foundations - Small Projects course defining how to draft a scope statement

Online Resource N/A Beginner
Finance Hub Financial Management Practice Manual

All Queensland Government departments are required to document their systems of internal control and other financial management practices in a Financial Management Practice Manual (FMPM)

Online Resource N/A Beginner
Accelerate Internal controls and financial responsibilities

This course aims to give you an understanding of the importance of Internal Controls and your role as a TMR employee in maintaining high standards of Internal Controls.

Online Course 30 min Beginner
Accelerate Financial Delegations and You

‘Financial Delegations and You’ aims to provide financial delegates with a comprehensive understanding of their responsibilities as a delegate and an overview of the TMR financial delegation framework and legislative requirements.

Online Course 31 min Beginner
LinkedIn Learning Internal Financial Controls

How to use internal controls to increase the integrity of your financial statements and look at the types of financial reporting problems that can occur and safeguards to minimise them.

Online Course 1hr 46min Beginner
Linkedin Learning Accounting Ethics

Ethical frameworks for accountants, the role of ethics in business finances, the differences between ethics, values, and beliefs. Defines ethics within accounting, ethics specifically for accountants, and ethics in legal structures and corporate cultures. The importance of professional competency, professional accountability, and internal controls in retaining public trust. Key aspects of corporate governance, concluding with some useful advice on ethics in practice.

Online Course 50 m Beginner

Planning, forecasting, and budgeting

Make strategic recommendations for management action based on asset accounting, financial reporting, estimates, broader trends and common issues and understand the strategic planning process for determining and detailing TMRs long- and short-term financial goals.

Provider Resource Location Type Time Skill level
LinkedIn Learning Corporate Finance: Robust Financial Modeling

Learn how to design a financial model and find out how it can benefit your business.

Online Course 30 min Intermediate
LinkedIn Learning Financial Modeling and Forecasting Financial Statements

Learn how to use past data such as cost of goods sold, depreciation expenses, and levels of inventory, and understand what caused those numbers to fluctuate over time. Then you can learn how to use the information as the basis for forecasting, applying a simple but powerful equation: assets = liability + equity

Online Course 30 min Intermediate
Accelerate Cost classification for transport infrastructure investments awareness session

This course aims to give you an understanding of the best practice approach to classifying costs into Capex vs Opex.

online Course 1 hour Beginner
Finance Hub TMR Budget Tool User Guide 2021-22

This document provides users with guidance on using two key Budget Tool files - the Control File and the Cost Centre Template file.

Online Resource 1 hour Beginner
Finance Hub How to prepare cost centre budgets, budget changes and standard rate costings in TMR

How document guides TMR staff in how to prepare cost centre budgets, budget changes and standard rate costings. This ensures consistency in budgeting and costing throughout the department and make the process as simple as possible for staff.

Online Resource 1 hour Beginner
Accelerate TMR Budgeting & Financial Planning

This course is designed to introduce you to the concepts and principles that apply to budgeting and planning across the department. It will explain how funding is allocated, how funding and resourcing should be managed in annual budget cycles and how additional funding can be requested.

Online Course 1 hour Beginner
Finance Hub Completing Forecasting Spreadsheet

Guidance for TMR staff on how to complete a variance analysis on monthly forecasting spreadsheets.

Online Resource 30 min Intermediate
Linkedin Learning Managerial accounting

Understand managerial accounting including costs and cost behaviors, cost-volume-profit (CVP) relationships, cost flows, standard costing and activity-based costing, and budgeting.

Online Course 2hr 25 min Beginner

Financial reporting and decision-making

Understand the financial implications of decisions and make informed financial decisions through the compilation and analysis of financial data.

Provider Resource Location Type Time Skill level
LinkedIn Learning Take a More Creative Approach to Problem-Solving

How do you get “unstuck”? Building on insights from improv, design thinking, comedy writing, and startup incubation, the lessons in this course offer you concrete tools for creative thinking.

Online Course 27 min Intermediate
LinkedIn Learning Crafting Problem and Solution Statements

Strategies for identifying and developing a compelling problem and solution statement, including how to identify customer pain points and highlight the tangible remedies your offering provides.

Online Course 37 min Intermediate
LinkedIn Learning Advanced Business Development: Communication and Negotiation

Learn how to get into the right mental space for strategic conversation. Discover how to engage sophisticated customers through high-level questioning and body language, as well as how to negotiate without damaging a relationship or descending to the lowest possible dollar.

Online Course 45 min Intermediate
LinkedIn Learning Strategic Agility

What it means to become an adaptive organization, including decisions made about who to hire, what the company values as important, how to align processes, how to think about risk, and what behavior senior leaders need to model for the rest of the organization

Online Course 1hr Advanced
Linkedin Learning Strategic Thinking

How to carve out time to think about strategy, gather data, learn from the past, create a vision for the future, and implement strategic thinking within your team.

Online Course 36 min Advanced
Accelerate Compiling Valid FBT logbooks

This course will provide you with a good understanding of why logbooks are required, how they are used and what you need to do to compile a logbook correctly.

Online Course 30 min Beginner
Accelerate My new corporate card

Being issued with a Queensland Government Corporate Purchasing Card (QGCPC) provides procuring flexibility for your business unit. This course will provide you with information on the policies and procedures you need to know to ensure you are using your QGCPC in a compliant and accountable way at all times.

Online Course 45 min Beginner
YouTube Financial Reporting 101

In this video tutorial you will learn the main financial reporting basics and fundamentals.

Online Resource 1h 25m Beginner

Financial systems

Understand financial accounting management and how data flows through Financial systems including SAP and Promaster EMS and understand the relationship between financial system and business processes, to compile and extrapolate SAP reports, and undertake data manipulation or analysis.

Provider Resource Location Type Time Skill level
Linkedin Learning Introduction to SAP BI/BW

Introduction to the Business Intelligence (BI) and Business Warehouse (BW) tools in SAP valuable to all who want to understand what is required to develop within the BI and BW solutions. Discover how to pull and organize data from sources, map data into InfoObjects, modify data, combine data from multiple sources, and store your data in memory with SAP HANA.

Online Course 1h 18m Intermediate
Linkedin Learning SAP Accounts Payable Boot Camp

Quickly learn how to manage accounts payable (AP) tasks and learn the fundamentals of basic AP reporting in the SAP suite of enterprise software. Get acquainted with the entry and review of non-purchase order and purchase order invoices in SAP.

Online Course 1h 50m Intermediate
YouTube What is SAP ? The absolute beginner's guide

Understand SAP system operations - an overview to learn what SAP is, why it is so important in today’s job market and what you can do to learn basic SAP skills

Online Resource 25 min Beginner
YouTube SAP reporting tips and tricks

Explore SAP Reporting Tips and Tricks including where you can find reports, how to set up variants, change layouts and download reports to Excel for further manipulation.

Online Resource 8 mins Intermediate
YouTube How to harness Power Query in Excel

Understand how to let a user interact with your datasets (through Power Query)

Online Resource 14 min Intermediate
Finance Hub Creating and changing asset master data in SAP

This resource explains how create and change asset master data in SAP.

Online Resource 60 min Beginner

Data visualisation

Ability to communicate and present complex financial terminology and activities, in simple terms to experienced finance and non-finance audiences.

Provider Resource Location Type Time Skill level
LinkedIn Learning Power BI Essential Training

Discover how to quickly glean insights from your data using Power BI.

Online Course 3hr 20min Beginner
LinkedIn Learning Power BI: Dashboards for Beginners

How Power BI dashboards work, including the building blocks of a dashboard, how to select the right data and connect it to your dashboard.

Online Course 29 min Beginner
LinkedIn Learning Learning Power BI Desktop

Discover how to conduct power pivots, import data, clean and shape data, as well as model data, perform calculations with Data Analysis Expressions (DAX), and visualize data with the variety of built-in charts and graphs in Power BI

48 min Course 48 min Intermediate
LinkedIn Learning Using Power BI with Excel

This is the second Australian Qualification Framework course offered in TMR. This course is focused on the role of the Project Manager.

48 min Course 48 min Intermediate
Linkedin Learning Data Dashboards in Power BI

How to design and customize the setup of visuals and charts to make it easy to use, understand, and interact with the dashboard model. Learn how to work with data from open-source websites, create visuals such as heatmaps and sparklines, compare multiple variables with trendlines and violin plots, and build engaging maps

Online Course 4hr 52min Advanced
Linkedin Learning Power BI and BIM: Analysis and Visualization

Learn what Microsoft Business Intelligence is and how it benefits the design communication process. Examine the differences between Power BI versions. Find out how to start a Power BI project, then explore the Power BI interface.

Online Course 2hr 29min Intermediate
Linkedin Learning Power BI Dataflows Essential Training

Using dataflows in Power BI, you can easily ingest, transform, integrate, and enrich data from a wide variety of sources.

Online Course 1hr 28min Intermediate
Linkedin Learning Advanced Microsoft Power BI

Advanced capabilities of the service. She shows how to work with calculations, leverage the DAX language, create advanced queries, and use the M language to improve the querying process.

Online Course 3hr 13min Advanced
Linkedin Learning Data Visualization: Storytelling

Presenting data and information in story form maximizes the effectiveness of our communication

Online Course 1hr 34min Beginner
Linkedin Learning Data Visualization: A Lesson and Listen Series

This series is perfect for anyone interested in how information is presented to the mass market, including professionals in all levels of analytics, data science, and communications.

Online Course 9hr 55min Beginner

Communicating financial data effectively

Presenting and communicating valuable and insightful financial information simply and effectively in a way that others can understand and will use.

Provider Resource Location Type Time Skill level
LinkedIn Learning Advanced Grammar

Review basic grammar rules and then focuses on more advanced grammar principles such as using correct words, locating incorrect grammar in sentences and paragraphs, and reviewing parts of speech, punctuation, and proper sentence structure.

Online Course 2hr 8min Beginner
LinkedIn Learning Business Writing Principles

Discover the secrets to effective business writing and crafting messages that others want to read and act on.

Online Course 1hr 32min Beginner
LinkedIn Learning Writing with Impact

This course shows how to give all your writing more impact, regardless of its purpose

Online Course 1hr 1min Beginner
LinkedIn Learning Creating and Giving Business Presentations

Learn how to prepare strong business presentations.

Online Course 1hr 8min Beginner
Linkedin Learning Presenting to Senior Executives

Learn methods you can use to communicate your message effectively to these key decision makers, resulting in buy-in and response. Discover the value of brevity and the importance of conveying the return on investment (ROI).

Online Course 49 min Intermediate
Linkedin Learning Master Confident Presentations

A series of tips and tricks, emphasizing practical techniques you can use before and during a presentation to maximize its effectiveness

Online Course 1hr 50min Intermediate
Linkedin Learning Managing Your Anxiety While Presenting

Explore what causes people to feel nervous and shares some common anxiety management pitfalls. He then offers anxiety management techniques to help you become more comfortable and confident when speaking in front of others.

Online Course 25 min Beginner
Linkedin Learning Keynote 6: Delivering Presentations

How to successfully export a Keynote deck and deliver a compelling presentation.

Online Course 1hr 49min Beginner
LinkedIn Learning Cost estimating

How to develop a cost estimate for all types of organizations. Covers topics including: various data types associated with cost estimating, how to report cost estimates, and tips for keeping the cost estimate accurate by validating data.

Online Course 1hr 15min Intermediate

Project management for Finance professionals

Increase capability to effectivley use financial software, systems and tools to communicate financial data and undertake financial analysis effectivley and efficently.

Provider Resource Location Type Time Skill level
Accelerate PMFT 110 - Introduction to Project Management

Basic project management concepts and is a pre-requisite course to more formal project management learning and development courses in TMR.

Online Course 1 Hr Intermediate
Accelerate BSB51415 Diploma of Project Management

This qualification is perfect for those wanting to enhance their skills in the workplace or those experienced in the project management field but just want to formalise their knowledge.

Face to Face or Virtual Course 6 - 7 Days Face to Face Intermediate
LinkedIn Learning Project Management Foundations: Small Projects

how to manage smaller scale projects with a simpler yet effective approach. She defines what "small" means in the context of project management and provides an overview of the life cycle of a small project, sharing the best techniques for planning, getting things done, tracking progress, and wrapping up.

Online Course 1hr 29min Intermediate

Continuous improvement

Ensures business activities and processes are effective and efficent, providing financial sustainability and value for money, and enables employees to identify, explore and implement improvements.

Provider Resource Location Type Time Skill level
LinkedIn Learning How to Innovate and Stay Relevant in Times of Change and Uncertainty

How to spot new opportunities, pivot, and innovate when the world around them has gone mad. Discover how to set the groundwork for innovation, encourage your teams to generate innovative ideas, and select the best ideas to prototype and launch into action.

Online Course 30 min Beginner
LinkedIn Learning A3 Problem Solving for Continuous Improvement

how to adopt the A3 process in order to approach problems, improve results, and drive organizational learning. Discover how to clarify the role of each stakeholder, identify and quantify the problem, find multiple contributing causes, and brainstorm countermeasures. 

Online Course 41 min Beginner

Financial software and tools

Increase capability to effectivley use financial software, systems and tools to communicate financial data and undertake financial analysis effectivley and efficently.

Provider Resource Location Type Time Skill level
Microsoft Introduction to Microsoft Excel

A free, 60-minute training on Microsoft Excel for the new or novice user. The training will focus on overall navigation, formatting, simple formulas, charts and tables and an overview of printing.

Online Resource 60 min Beginner
Microsoft Dive Deeper with Advanced features of Microsoft Excel

Take a dive into the intermediate features of Excel formatting, functions, and accessibility. 

Online Resource 60 min Advanced
LinkedIn Learning Excel: PivotTables for Beginners

Demystify PivotTables and understand how to use them to analyze your data. 

Online Course 23 min Beginner
LinkedIn Learning Excel: Introduction to Formulas and Functions

Demystify PivotTables and understand how to use them to analyze your data. 

Online Course 2hr 38 min Beginner
LinkedIn Learning Excel: Macros and VBA for Beginners

Understand the best times to use a macro, and then how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. 

Online Course 37 min Intermediate
LinkedIn Learning Excel: Introduction to Formatting

A crash course in Excel formatting to make your spreadsheets more readable and compelling

Online Course 59 min Intermediate
LinkedIn Learning Excel: Advanced Formulas and Functions

Learn critical formula shortcuts that will speed up your work, and explore a variet of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions

Online Course 4hr 41min Advanced
LinkedIn Learning Excel: Tips and Tricks

Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently

Online Course 4hr 24min Intermediate
LinkedIn Learning Excel PivotTables: Mastering PivotTables and PivotCharts

Learn how to prepare your raw data for analysis; leverage formatting, sorting, filtering, and grouping options; display values in multiple ways; create PivotCharts.

Online Course 4hr 7min Intermediate
LinkedIn Learning Excel: Introduction to Macros and VBA

A quick introduction to macros and VBA. Learn the steps of recording a basic macro, then demonstrates how to edit macros, including testing and adjusting, and making recorded macros dynamic

Online Course 37 min Advanced
LinkedIn Learning Excel: PivotTables in Depth

This course provides a thorough introduction to this powerful and overlooked feature and shows how to use macros and the data model to extend PivotTables even further.

Online Course 3hr 38min Advanced
LinkedIn Learning Excel: PivotTable Tips

Go from beginner to power PivotTable user.

Online Course 1hr 38min Intermediate
LinkedIn Learning Learning VBA in Excel

The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think.

Online Course 3hr 14min Advanced
YouTube Learn Pivot Tables in 6 Minutes

Learn basic pivot table skills.

Online Resource 6 min Beginner
YouTube VLOOKUP Tutorial for Excel - Everything You Need To Know

Everything you need to know to quickly get started with writing VLOOKUP and troubleshooting

Online Resource 21 min Beginner
YouTube Introduction to Pivot Tables, Charts, and Dashboards in Excel

Learn how to create an interactive dashboard using Pivot Tables and Pivot Charts.

Online Resource 15 min Beginner
arrow-up icon