Content is loading...
IT Skills Pathway
Quality assured Digital Skills and Microsoft Office learning and assessment content. From basic digital literacy and skills through to advanced Microsoft Excel and Word training.
Courses
27 matching results
27 matching results. Page 1 of 3.Digital Literacy for the Workplace
| Section | Tutorials |
|---|---|
|
Section Getting started |
Tutorials Digital literacy Digital citizenship |
|
Section Digital devices |
Tutorials Introducing digital devices |
|
Section Apps, applications and files |
Tutorials Manufacturers, operating systems and applications Managing files Using external devices and storage Sharing information |
|
Section Staying safe |
Tutorials Viruses, malware and virus checkers Phishing and unverified links Your digital footprint Password security |
|
Section Communication |
Tutorials Using email and webmail Online chat Blogs and podcasts Social networks Etiquette and ethics |
|
Section The Internet |
Tutorials Connecting to the internet Web browsers Using search engines The Internet of Things |
Digital Skills for the Workplace
| Section | Tutorials |
|---|---|
|
Section Mouse skills |
Tutorials Moving the mouse, clicking and dragging Scrolling |
|
Section Keyboard skills |
Tutorials Letters and numbers Capital letters The insertion point / text entry cursor Punctuation and symbols The return key Backspace and delete The tab key |
|
Section Switching on and off |
Tutorials Power switches and switching on Logging on Changing your password Locking the computer Logging off Restarting Shutting down |
|
Section Working with windows |
Tutorials The desktop The Start menu Parts of a window Maximise, minimise, close and restore Moving a window Resizing a window |
|
Section Working with applications |
Tutorials Starting applications Working with dialogue boxes and task panes Switching between windows Selecting text Overtyping Using the clipboard cut, copy and paste Copyright images Using task manager Snipping tool The problem steps recorder Opening files |
|
Section File management |
Tutorials Introducing the computer filing system The 'This PC' window Locating your network drive Working with folder explorer view Finding and opening files and folders Sorting files Creating folders Moving and copying files and folders Renaming files and folders File compression Deleting files Emptying the recycle bin |
|
Section Web skills |
Tutorials Using web addresses Searching the web Finding and following links Using web forms Introducing web browsers |
Excel 2013 for the Workplace
| Section | Tutorials |
|---|---|
|
Section Workbooks and worksheets |
Tutorials Working with Workbooks Managing Worksheets Freeze panes Split panes Add headers and footers to worksheets |
|
Section Entering data |
Tutorials Entering data in the Worksheet Copying, moving and Auto-Filling data Define names for cells and cell ranges Using absolute and relative addresses Insert and delete rows, columns and cells Hide and unhide rows or columns Use pick lists Use comments |
|
Section Sorting and filtering |
Tutorials Sorting data Filter data using AutoFilter |
|
Section Formatting data |
Tutorials Formatting cells Format worksheets Visualise data with conditional formatting |
|
Section Working with charts |
Tutorials Understanding charts Changing the chart layout |
|
Section Formulas and functions |
Tutorials Create and edit simple formulas Trace formula precedents and dependents Using common built in functions Understand error messages |
Excel 2016 for the Workplace
| Section | Tutorials |
|---|---|
|
Section Workbooks and worksheets |
Tutorials Working with workbooks Managing worksheets Freeze panes Split panes Add headers and footers to worksheets |
|
Section Entering data |
Tutorials Entering data in the worksheet Copying, moving and auto-filling data Define names for cells and cell ranges Using absolute and relative addresses Insert and delete rows, columns and cells Hide and unhide rows or columns Use pick lists Use comments |
|
Section Sorting and filtering |
Tutorials Sorting data Filter data using AutoFilter |
|
Section Formatting data |
Tutorials Formatting cells Format worksheets Visualise data with conditional formatting |
|
Section Working with charts |
Tutorials Understanding charts Changing the chart layout |
|
Section Formulas and functions |
Tutorials Create and edit simple formulas Trace formula precedents and dependents Using common built in functions Understand error messages |
Excel 365 for the Workplace
| Section | Tutorials |
|---|---|
|
Section Workbooks and worksheets |
Tutorials Working with workbooks Managing worksheets Freeze panes Split panes Add headers and footers to worksheets |
|
Section Entering data |
Tutorials Entering data in the worksheet Copying, moving and auto-filling data Define names for cells and cell ranges Using absolute and relative addresses Insert and delete rows, columns and cells Hide and unhide rows or columns Use pick lists Use comments |
|
Section Sorting and filtering |
Tutorials Sorting data Filter data using AutoFilter |
|
Section Formatting data |
Tutorials Formatting cells Format worksheets Visualise data with conditional formatting |
|
Section Working with charts |
Tutorials Understanding charts Changing the chart layout |
|
Section Formulas and functions |
Tutorials Create and edit simple formulas Trace formula precedents and dependents Using common built in functions |
Excel for the Workplace
| Section | Tutorials |
|---|---|
|
Section Workbooks and worksheets |
Tutorials Working with Workbooks Managing Worksheets Freeze panes Split panes Add headers and footers to worksheets |
|
Section Entering data |
Tutorials Entering data in the Worksheet Copying, moving and Auto-Filling data Define names for cells and cell ranges Using absolute and relative addresses Insert and delete rows, columns and cells Hide and unhide rows or columns Use pick lists Use comments |
|
Section Sorting and filtering |
Tutorials Sorting data Filter data using AutoFilter |
|
Section Formatting data |
Tutorials Formatting cells Format worksheets Visualise data with conditional formatting |
|
Section Working with charts |
Tutorials Understanding charts Changing the chart layout |
|
Section Formulas and functions |
Tutorials Create and edit simple formulas Trace formula precedents and dependents Using common built in functions Understand error messages |
Level 1 - MS Excel 365
| Section | Tutorials |
|---|---|
|
Section Workbooks and worksheets |
Tutorials Working with workbooks Add headers and footers to worksheets Working with workbooks |
|
Section Entering data |
Tutorials Entering data in the worksheet Copying, moving and auto-filling data Insert and delete rows, columns and cells |
|
Section Sorting and filtering |
Tutorials Sorting data |
|
Section Formatting data |
Tutorials Formatting cells |
|
Section Working with charts |
Tutorials Understanding charts |
|
Section Formulas and functions |
Tutorials Create and edit simple formulas |
| Section | Tutorials |
|---|---|
|
Section |
Tutorials Intro to Social Media What is LinkedIn? Creating a Profile Finding Connections Managing your Feed Finding Groups LinkedIn Messaging |
Microsoft 365 Overview
| Section | Tutorials |
|---|---|
|
Section Introduction to Microsoft 365 |
Tutorials What is Microsoft 365? Accessing Microsoft 365 My 365 profile Personalising your launcher and 365 experience 365 online, desktop and mobile |
|
Section Overview of Microsoft Apps |
Tutorials What are Microsoft 365 Apps? Microsoft OneNote Microsoft Teams Microsoft Yammer Microsoft Stream Microsoft Forms Microsoft Planner |
|
Section SharePoint |
Tutorials What is SharePoint? Navigation in SharePoint Uploading files to SharePoint Using the view functionality in SharePoint Sharing in SharePoint Document management and version control in SharePoint |
|
Section OneDrive |
Tutorials What is OneDrive? Creating and saving documents in OneDrive Document collaboration and co-authoring in OneDrive Sharing files and folders in OneDrive Syncing and versions in OneDrive |
|
Section 365 Accessibility |
Tutorials Screen Readers Microsoft Search Request accessibility content Real time subtitles Captions Dictate |
Microsoft Teams
| Section | Tutorials |
|---|---|
|
Section Getting started with Teams |
Tutorials What is Teams? The Teams interface Joining a Teams call Microphone and video settings Meeting etiquette |
|
Section Interacting with Teams |
Tutorials Raising hands Chat Sharing your screen Posts (Conversations) Calendar - joining a meeting |
|
Section Scheduling Teams meetings |
Tutorials Scheduling a meeting in Teams Scheduling a meeting in Outlook Inviting other people to call or chat Meet Now |
|
Section Managing a Teams meeting |
Tutorials Admit from lobby Attendance Lists Mute others Recording and sharing a meeting Enable and share the Whiteboard Breakout rooms - use of and monitoring |
|
Section Administering Teams |
Tutorials Adding Channels Sending emails to a channel Saving posts Setting up your Team Adding and removing members Joining a Team |
|
Section Going further |
Tutorials How to structure your Team (Channels) Files - adding documents Sharing and co-authoring "@" mentions Edit and Delete messages Meeting Notes Controlling notifications Find and add Apps Wikis |
Content is loading...