Don’t lose track.
Sign up to save your shortlist.
Data, Digital & Information Technology training courses
48 training courses
See all
Excel: Formulas for working with text
Learn to use Excel Text Functions to clean up imported text and manipulate how textual data is stored and displayed. Learning outcomes: Understanding when to use Text Functions Use Text Functions to manipulate text based Excel data Use Text Functions to ‘clean up’ imported text
Duration:
1.5 hour
Excel: Formulas for What-if analysis
Learn how to write and edit IF formulas to return results based on variable conditions in your spreadsheet data. Learning outcomes: Understand how dynamic formulas work in Excel Use simple Functions – Excel’s built-in formulas Use IF Functions to calculate and return results based on conditional tests Use nested IF Functions for complex conditional tests
Duration:
1.5 hour
Excel: Formulas for statistical analysis
Learn how to use Excel Statistical Functions to calculate averages, standard deviations and other useful statistical information for analytical and reporting purposes. Learning outcomes: Understand statistical Functions Use Functions for statistical analysis
Duration:
1.5 hour
Excel: Formulas for finance analysis
Learn to use Excel formulas that work on financial data. Financial functions are used to calculate many finance related operations including loan repayments, depreciation of assets and rates of return on investments. Learning outcomes: Understand when to use financial functions Use Functions to calculate loan repayments Use Functions to calculate rates of return
Duration:
1.5 hour
Excel: Formulas for everyday
Learn how to write and edit simple formulas in Excel to calculate results. You will learn how to write formulas that add totals and calculate averages and how to use built-in formulas called Functions. Learning outcomes: Understand formulas Create a simple formula to add numbers Use formulas to perform common calculated results Understand cell referencing in formulas Use simple Functions – Excel’s built-in for...
Duration:
1.5 hour
Excel: Error-proofing your spreadsheet
Learn how to find and fix common errors in spreadsheets and how to create models that have built-in error prevention mechanisms to help maintain data integrity. Learning outcomes: Understand error types Use Auditing tools to trace errors in spreadsheets Use Data Validation to prevent data input errors Protect workbook data to prevent data input errors
Duration:
1.5 hour
Excel: Data modelling with scenarios, goal seek & solver.
Learn how to use Scenario Manager, Goal Seek and Solver to perform complex spreadsheet modelling and how to quickly analyse options and make better decisions. Learning outcomes: Understand spreadsheet modelling Create a simple what-if model Create models with captured scenarios Use Goal Seek to model simple scenarios Use Solver to model complex scenarios
Duration:
1.5 hour
Excel: Dashboards
Learn how to create a dashboard in Excel to help you keep a visual track of important performance measures and targets in your spreadsheet models. Learning outcomes: Understand when to use a dashboard Create a simple KPI dashboard Edit and update the dashboard
Duration:
1.5 hour
Excel: Collaboration and shared workbooks
Learn to share and co-author Excel workbooks and collaborate with team members online. Learning outcomes: Protecting data Sharing a workbook via a network Sharing a workbook on OneDrive Using Track Changes to review shared edits
Duration:
1.5 hour
Excel: Charts and Graphs
Learn how to display Excel data graphically using a variety of compelling charts. Learning outcomes: Understand chart types and uses Create a chart Format chart elements Change chart types
Duration:
1 week
Excel: Automation with Macros
Learn to record, run and edit Macros to automate routine Excel tasks using the Macro Recorder and Visual Basic for Applications (VBA) programming code. Learning outcomes: Understand macros Record a simple macro Run a macro Edit a macro in the VBA Editor
Duration:
1.5 hour
Excel: Advanced Filters for Databases and Lists
Learn to use Advanced Filters in Excel to summarise and analyse large data lists and complex data sets. Learning outcomes: Sort and filter lists Use worksheet tables Use advanced filters
Duration:
1.5 hour
Most important skills for Digital Information technology
As the world we live in continues to accelerate into a digital world, digital and information technology skills have become more important than ever. If you don’t know how to use the standard applications in business, whether microsoft or cloud based, then you should probably add technology training courses to your ‘to do list’!.
It’s forecasted that in 2025 the world we live in will look dramatically different to what it does today. That’s why understanding the importance of information technology / digital, various software skills such as Microsoft, processing, transmitting and storing data – to building, developing and maintaining systems is vital. But the list of skills does not stop there, architecture, application development, coding, AI, UX design and so much are becoming top Digital Skills Training Courses to be certified in.
How Digital Information technology training courses work
Information technology training can form part of a degree, diploma, certificate or short course. Whether you’re looking for an end to end course, or refining a particular skill, Digital Skills Training Courses are broad and extensive. Often these courses are delivered by RTO’s, Universities or expert Training Providers.
Benefits of Digital Information technology training
It’s pretty much a given that digital skills will future proof your career, you don’t just have to be a tech head to benefit from learning upto date digital skills. Digital Information roles are some of the highest paid careers, so one thing you’ll benefit from is earning more cash in your pocket, but in light of some more potentially unknown benefits, you’ll be more efficient and effective in your job role, executing certain projects will be easier, your network will be broader and more savvy, and you might even be seen as an authoritative figure in your company with a suite of modern and sharp skills.
Results you might see
The results you will see vary from course to course depending on the core skill of the training. You can check out training courses here, to get you started on your digital journey of success, and start to enjoy the ease of your role as a more effective and efficient operator.
Common job titles related to this category: Digital Analyst, Test Lead, Manager Operations – Information Technology, Digital Learning Officer, Customer Care Officer, Technical Support, IT Consultant, IT Manager, Software Manager, Software Engineer, Delivery Lead, Solutions Consultant, Developer.