Data, Digital & Information Technology training courses

48 training courses
See all

Excel Essentials

Do you need to get up to speed with the basics in Excel? This course is designed for people who are new to spreadsheets or converting from another program. Develop your skills and confidence by learning from experienced Excel certified instructors who will work with you at your pace, make sure you are not overwhelmed and give you handy tips. This course covers the basic day to day tasks required to work with an Excel spreadsheet to produce basic reports. Courses are conducted on ...
By:
Corporate Training Solutions Australia
Duration:
1 day

Word: Word Styles and Tables of Content

Learn how to create and use Word Styles to format headings and paragraph layouts consistently and quickly. You will also use Styles to generate a Table of Contents for a long document. Learning outcomes: Understand Styles Apply a style to a heading Modify a style Create a custom style Create a Table of Contents using styles
By:
MCI Solutions
Duration:
1.5 hour

Word: Mastering Templates

Learn how to save time by using the built-in templates provided in Word and by creating your own customised, re-usable document templates Learning outcomes: Understand templates Use a standard template Create a custom template
By:
MCI Solutions
Duration:
1.5 hour

Word: Mastering Tables

Learn to easily insert, edit and format Tables in Word documents to improve readability and document effectiveness. Learning outcomes: Create a table Edit table layout Apply table formatting Repeat headings
By:
MCI Solutions
Duration:
1.5 hour

Word: Mastering Macros

Learn how to save time by automating routine tasks and processes in Word using the Macro recorder. Learning outcomes: Understand Macros Record a Macro Run a Macro Assign a Macro to a keyboard key and ribbon command Create a Macro button
By:
MCI Solutions
Duration:
1.5 hour

Word: Mastering images and shapes

Learn how to insert and edit images into your Word documents and how to illustrate documents with shapes and drawn objects. Learning outcomes: Insert pictures into Word documents Position a picture on a page Apply text wrapping around a picture Resize a picture Draw a shape in a document Edit and format a shape Use SmartArt
By:
MCI Solutions
Duration:
1.5 hour

Word: Collaborating on documents with Track Changes

Learn how to collaborate on a Word document with co-workers by using Track Changes and other reviewing and document protection tools. Learning outcomes: Understand how to use Track Changes Mark up a document Accept and reject changes Compare edited documents Protect a document
By:
MCI Solutions
Duration:
1.5 hour

Powerpoint: Images, tables, charts and shapes

Learn how to insert and use images, tables, charts and shapes to improve the appearance and effectiveness of your PowerPoint presentation. Learning outcomes: Insert and edit an image Insert and edit a table Insert and edit a chart Insert and edit a shape
By:
MCI Solutions
Duration:
1.5 hour

Powerpoint: Creating your first slide presentation

Learn how to create a dynamic, engaging slide show presentation using PowerPoint. Learning outcomes: Create a slide show presentation Enter and edit slide content Play a presentation
By:
MCI Solutions
Duration:
1.5 hour

Powerpoint: Animation and transition effects

Learn how to use animation and slide transitions to make your presentations more dynamic and engaging. You will learn how to animate bullet points and other shapes and how to use engaging transition effects to move from one slide to the next during your presentation. Learning outcomes: Understand animation and transition Create animations Create slide transitions
By:
MCI Solutions
Duration:
1.5 hour

Office 365: Planner

Learn how to use Planner with Office 365 to establish and manage small projects, share files and assign and track group tasks. Learning outcomes: Create a plan Add tasks Add team members Edit a plan
By:
MCI Solutions
Duration:
1.5 hour

Office 365: OneNote

Learn how to use OneNote with Office 365 to create digital notebooks for capturing, organising and sharing information including meeting minutes, workshop notes and other important reminders. Learning outcomes: Understand OneNote Create notes Using Pages and Sections
By:
MCI Solutions
Duration:
1.5 hour

Office 365: Getting Started

Get started with the core Office 365 applications and services. The session will focus on using Office 365 in the cloud, on the desktop and on mobile devices with an emphasis on how to get up and running with the core office applications. Learning outcomes: Understand cloud computing Use Office 365 online applications Use Email, Calendar and People Use OneDrive for Business
By:
MCI Solutions
Duration:
1.5 hour

Excel: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use Excel. Learning outcomes: AutoCalculate AutoFit AutoFill & FlashFill Custom Fill lists Ctrl * to select regions Freeze windows Drag & drop to copy cells & sheets Group sheets Format Painter Conditional formatting
By:
MCI Solutions
Duration:
1.5 hour

Excel: Sorting and Filtering Lists and Database

Learn how to turn raw data into useful business information to help you make more informed decisions. Work with built-in, easy to use database and list management tools in Excel to analyse large sets of business data quickly and efficiently. Learning outcomes: Use Sort and Filter tools Use Subtotals Remove duplicates Clean up imported data
By:
MCI Solutions
Duration:
1.5 hour

Excel: Pivot Tables and Pivot Charts

Learn how to create and edit Pivot Tables and Pivot Charts to quickly visualise and analyse large Excel data sets and make better business decisions. Learning outcomes Introduction to Pivot Tables Creating a Pivot Table Rearranging Fields and Items in a Pivot Table Creating Pivot Charts Creating a Pivot Chart
By:
MCI Solutions
Duration:
1.5 hour

Excel: Math Functions

Learn to use Excel Functions for complex mathematical operations. Math functions are used for many mathematical operations including adding up totals, multiplying values and rounding numbers. Learning outcomes: Understand Math Functions Use Functions to round numbers Use Functions to perform conditional sums Use Functions for complex adding and multiplying
By:
MCI Solutions
Duration:
1.5 hour

Excel: Mastering VLOOKUP formulas

Learn how to create and edit VLOOKUP and other Lookup formulas to extract data from Excel lists and tables based on variable conditions and criteria. Learning outcomes: Understand when to use lookup formulas Understand cell references with Excel formulas Create named ranges Use LOOKUP and VLOOKUP
By:
MCI Solutions
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.