UIS Self Taught Training 2018-19

The skills and knowledge acquired in Microsoft Access 2016 - Level 1 (with Challenge Exercises) are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

The skills and knowledge acquired in Microsoft Access 2016 - Level 3 (with Challenge Exercises) are sufficient to design and create a multitable database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

This course aims to give the learner the skills and knowledge to be able to use and browse the internet using the Microsoft Edge browser

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2013. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like PivotTables and goal seeking.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 3 (with Challenge Exercises) are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

Microsoft Excel 2016 - Data Analysis Add-Ins will show you how to use the data analyis add-ins of Microsoft Excel 2016, including using Power View to create interactive data visualisations, using Power Pivot to create a data model for use with Excel tools such as pivot tables and pivot charts, using Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic data.

Microsoft Excel 2016 - Functions will show you how to use a variety of Excel functions, including logical functions, math functions, date and time and financial functions. It is a reference manual and is designed to be used by someone already familiar with how functions are used in Excel.

Microsoft Excel 2016 - Level 1 is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Microsoft Excel 2016 - Level 2 enables users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

Microsoft Excel 2016 - Level 3 enables users to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

The skills and knowledge acquired in Microsoft Lync Online are sufficient to be able to work with the basic elements of Lync including adding and working with contacts, sending and receiving calls and instant messages, using the presenting features and working with Lync settings.

Microsoft Office 2013 - Upgrading provides skills and knowledge in a wide range of new features, enhancements and changes found in Microsoft Office 2013.

The skills and knowledge acquired in Microsoft Office 365 - For Business - Level 1 are sufficient to be able to understand how Office 365 works and perform basic tasks.

The skills and knowledge acquired in Microsoft Office 365 - For Business - Level 2 are sufficient to be able to use and operate the software effectively.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for the range of applications included in the Microsoft Office 365 package.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Access.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Excel.

• Please note: The majority of the training available is also applicable to Microsoft Excel 2016.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Planner.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Teams.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Visio.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft OneDrive.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft OneNote.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Outlook.

• Please note: The majority of the training available is also applicable to Microsoft Outlook 2016.