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:
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |