Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.

This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.

Many of us use Outlook every day but that doesn't mean you're getting the most out of it. As the versions progress new features are introduced and there are also some hidden features too that you wouldn't stumble across unless you went looking for them. This course will help you work better, faster and more efficiently ensuring you get the most out of Microsoft Outlook.

This course is aimed at those new to PowerPoint, or who have limited knowledge of the package. During this course delegates will explore the PowerPoint environment and create presentations.

Delegates will format text on slides, add graphical objects to a presentation, modify objects on slides, add tables to a presentation, add charts to a presentation and prepare to deliver a presentation.

Microsoft Publisher is an easy to use desktop publishing application that helps you create, customise, and publish materials such as newsletters, brochures, flyers and catalogues.

In this Publisher course, delegates will create a publication from scratch as well as using some of the hundreds of business and personal designs available in Publisher. This course will enable delegates to create, design, and edit publications.

This course is for delegates who want to learn to be more productive with Microsoft Word. Delegates will learn how to use the essential day to day functions of Word including how to create and edit documents and use character and paragraph formatting. Delegates will also be shown ways to ensure word documents are consistent and engaging using headers and footers, SmartArt and many other design features.

This Word course covers the advanced features of Microsoft Word for delegates who need to work with forms, large or complex documents, and sharing documents among multiple team members.

This one day course is designed to familiarise the SharePoint user with the basics of creating, permissioning, populating and managing a SharePoint Team Site

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.

This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value

Visio provides a dedicated, familiar, Microsoft drawing environment, complete with a broad range of templates, shapes, and sophisticated tools designed to make creating a wide variety of business and technical diagrams easy, giving business and technical users the power to visualise and communicate ideas, information, and systems.

Delegates will learn basic concepts for creating flowcharts, cross-functional flowcharts, and organisation charts. This includes learning the basics for using and creating shapes, printing drawings, creating custom stencils, and many time-saving shortcuts and techniques designed to increase user productivity.

This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.

This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

In this 5-day course, the professional web developers will learn to develop advanced ASP.NET Core MVC applications using .NET Core tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application.

This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.

We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.

It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.

For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.

Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.

This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.

The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.

This course is split into 3 main areas:

1. Get and Transform (Power Query)
2. Power Pivot - Data Models and DAX calculations
3. Dashboard Creation with Pivot Tables, Charts and Slicers

It is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.
This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience.

This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user within the area of writing functions.

Microsoft MapPoint allows you to use powerful mapping and analysis features to produce detailed data-filled maps. Use MapPoint to find geographic locations, visually analyse your business data, and create, customise, and integrate maps into Microsoft Office documents. We can help you get the most from this specialist tool by offering a well-rounded course to see the range of MapPoint features.

As desktops has evolved, so have methods for deploying and updating them. In this course, you'll learn how to plan and implement an operating system deployment strategy. This course will help you understand the various methods available, the scenarios they're suited for, as well as how to deploy Windows using modern methods. This course will also cover planning and implementing an update strategy for Windows.

During this course, you’ll be introduced to key components of modern management and co-management strategies. You’ll examine what it takes to incorporate Microsoft Intune into your organization and how to use it to manage modern desktops and devices. You’ll also learn about methods for deployment and management of apps and browser-based applications.

In this course, the student will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as about how to protect these categories. The student will be introduced to Azure Active Directory and learn how to use Microsoft Intune to protect devices and data with compliance policies. Finally, this course will cover key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities.

This course is aimed at mobile workers who are new to using Microsoft Office on an Android tablet or phone.

This course is aimed at mobile workers who are new to using Microsoft Office on an Android tablet or phone.

Microsoft Power Apps let you build apps fast with a point-and-click approach to app design. You can choose from a large selection of templates or start from a blank canvas. You can easily connect your app to data and use Excel-like expressions to easily add logic. Apps can be published to the web, iOS, Android, and Windows 10.

This Level 1 course will be split into 4 main areas:
Creating and modifying an app from an Excel table
Adding screens and forms from separate tables
Creating drop down boxes from a reference table
Sharing the app via the admin centre and downloading the app onto a device ready to be used.

This two day course is designed for individuals who will use Microsoft Project as a tool to assist them in managing projects. The topics in this course cover the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments.

Microsoft Sway is a presentation program that allows you to create interactive reports, stories, presentations and more

Sway can include text, pictures and media, pulling content from a variety of locations, including your own device, network or internet source.

Sways are stored on Microsoft's servers and tied to a Microsoft account, although more content is available when accessing through an Office 365.

This course is for users wishing to acquaint themselves with the basic features of Microsoft Teams in Office 365. The course stresses the role of Teams, Channels, Files, Meetings and Chat.

In this course, students will learn how to support the installation tasks associated with Windows 10. Students will develop skills that include learning how to install and customize Windows 10 operating systems. Students will also learn about the new Windows servicing model and methods for keeping Windows up to date. The course will conclude with common post-installation tasks.

Students will learn how to support the configuration tasks associated with Windows 10. Students will develop skills that include managing storage, files, drivers, and printers as well as how to configure network connectivity for Windows 10. This course will also cover managing and deploying applications.

Students will learn how to secure the Windows 10 OS and protect the data on the device. Students will be introduced to common methods used for authentication and access control. This course will teach how to configure file and folder permissions and creating security policies. Students will also be introduced to the different types of external threats and how to leverage features like encryption and firewalls, as well as tools like Windows Defender.

Students will learn how to manage and troubleshoot Windows 10. This course will deep-dive into the architecture and tools used for managing, monitoring, and troubleshooting the OS, Apps, and hardware. Students will learn about proactive and troubleshooting methodology, and how to identify and mitigate common issues.

This is a five-day instructor-led training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Microsoft Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and its users.

This Microsoft Office 365 course is aimed at the Office 365 user wishing to manage their Office 365 Tenancy and the major Applications within it as well as automating business processes in Office 365.

This course is aimed at those wishing to setup Office 365 and keep it running.

This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course stresses the role of Outlook as an "All in One" messaging, SharePoint for Team collaboration and Lync 2010 for unified communications.

This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course stresses the role of using the Office Online Applications to create, edit, comment and share documents.

This course is an introduction to the Visual Basic (VB.NET) programming language. It will cover the basic building blocks of the Visual Basic programming language, such as how .NET is different from traditional programming, defining variables, control structures (If..Else, loops etc) and operators, before moving on to key concepts such as classes, objects, properties and methods. It will then move on to more advanced subjects such as Shared and Abstract behaviour, enumerations and error handling. It will provide delegates with a skill base from which they can go on to develop .NET applications on either the Windows Forms or ASP.NET platforms.

Please note that this is the .NET version of Visual Basic (version 7 and above). It is not suitable if you want to learn VB6 or below, or Visual Basic for Applications (VBA). Please contact us if you are unsure if this is the right course for your VB requirements.

This programme is designed to further develop the skills of project managers. Developing and enhancing project management skills should not only strengthen the capabilities within the project teams but also facilitate a heightened awareness of the impact these skills have in all other internal working relationships. By training all project managers to the same level in the same methodology and practices it ensures there is clarity on their roles, responsibilities and objectives.

This highly interactive and practical programme will give delegates an opportunity to learn more about themselves and the different working styles of others to increase individual and team effectiveness. They will be working as individuals, in pairs or small groups, engaging with each other to explore the different approaches. Managing a project successfully requires awareness and understanding of the needs for a balanced team. This programme has been designed to give delegates both insight and time to explore their personal preferences, highlighting the benefits of getting the correct balance between both managing the task and leading the team.

This course is aimed at those already familiar with PowerPoint. During this course delegates will go beyond using the standard layouts and designs offered by PowerPoint, to creating their own designs.

Delegates will integrate current design trends into their presentations to create modern but professional slides and learn some of the tricks and short-cut methods for doing so. You will create a presentation containing a variety of slide layouts which can used as a template for future presentations.

Skype for Business is a communications platform which offers instant messaging, video calling, and contact and meeting management. Skype for Business seamlessly integrates with Office 365 enabling businesses to better communicate and share content, both internally and externally.

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

SQL is an industry-standard language for accessing mainframe, midrange and LAN-based, multi-user relational databases. This course will teach the delegate how to read and write good SQL for querying, updating and maintaining SQL databases. The course progresses through the elements of the language to build a thorough appreciation and understanding of SQL's capabilities and power. It covers ANSI-standard SQL and some of the common extensions.

This course is made up of a mix of theory and practical sessions. You will complete a series of exercises that cover all the important components of the language and allow you to practise your SQL.

Please Note: The course will use a Microsoft SQL Server platform and T-SQL in all labs and practices to illustrate the use of the SQL language

This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.

So, you've become adept at querying data in Microsoft SQL Server and now you're ready to take your skills to the next level. Aimed primarily at IT Pro's and developers, this 5 day course will enable you to gain much deeper insight into the inner workings of the database engine, write efficient queries that are built upon appropriate indexing structures, implement the various programmatic objects inherently supported by SQL Server, support less commonly used data-types, manage changing data and, essentially implement SQL Server in such a way as to get the maximum benefit and performance out of the product.

This is a very comprehensive and intensive course with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. To successfully complete this course you should already be proficient at querying data and writing Transact-SQL code and, be familiar with the SQL Server Management Studio (SSMS) working environment.

Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered to suit individual requirements. In fact, specific content from this course could also be combined with material from other related courses in order to produce a bespoke training package – just ask for details.

With some slight modification, this course can also be delivered on a SQL Server 2014 platform.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

This 3 day course is intended for delegates who need to learn the essential skills necessary to maintain a Microsoft SQL Server system infrastructure. Being concise and hands-on, it is aimed at quickly getting delegates familiar with the Microsoft SQL Server administration concepts, tools and utilities. This course is an abridged version of the full 5 day “Microsoft SQL Server System Administration” course. The installation of SQL Server, covered in the first module of the course, is optional and can be omitted to free up time for other topics if desired.

Attendees will gain insight into the infrastructure and architecture of SQL Server, enabling individuals to fully understand the product with which they are dealing. Configuration of server instances and databases is given full treatment, as are database transaction logs, and the creation and maintenance of indexes. Concise treatment is given to managing SQL Server security, including both at the server and database level. The focus then shifts to examining how best to move and protect data, such as when importing or exporting it between heterogeneous data sources, backing it up to external media, and restoring data from a backup. Many tasks involved in the day to day administration of a SQL Server instance can be performed automatically, making an administrators life potentially simpler, and such is the subject matter in the module dealing with SQL Server Automation. The final part of the course looks at monitoring and troubleshooting SQL Server performance and related issues.

This five-day instructor-led course teaches IT Pros how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2016. Additionally, this course teaches how to deploy other Active Directory server roles such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).

This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.

This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking.