Courses

Target Audience: This course is intended for Information Technology (IT) Professionals with hands on experience working in a Windows server 2008 or Windows Server 2012 environment who wish to acquire the skills and knowledge necessary to be able to manage and maintain the core infrastructure required for a Windows Server 2012 and Windows Server 2012 R2 environment. The key focus for students is to broaden the initial deployment of Windows Server 2012 services and infrastructure and provide the skills necessary to Manage and Maintain a domain based Windows Server 2012 environment, providing skills in areas such as User and Group management, Network Access and Data Security. Candidates typically interested in attending this course would be Windows Server Administrators experienced in working with Windows Server 2008 or Windows Server 2012 who wish to gain skills necessary to perform daily management and maintenance tasks in a Windows Server 2012 or Windows Server 2012 R2 environment. IT Professionals who are looking to take the 411, Administering Windows Server 2012 exam IT professional wishing to take the Microsoft Certified Solutions Expert (MCSE) exams in DataCenter, Desktop Infrastructure, Messaging, Collaboration and Communications will also be interested in taking this course as they prepare for the Microsoft Certified Solutions Associate (MCSA) exams, which are a pre-requisite for their individual specialties.

This course is aimed at users who need to administer and maintain their Dynamics 365 environment through the Office Portal and Dynamics 365 Administration center. The course is specifically designed for those users who are considering taking exam MB2-715. Note that some of this course is theoretical and therefore does not offer a hand on labs for all aspects.

This course is aimed at users who need to administer and maintain their Dynamics 365 environment through the Office Portal and Dynamics 365 Administration center. The course is specifically designed for those users who are considering taking exam MB2-715.

This course has been designed for candidates who want the benefit of using the advanced formulas and functions of Excel Pivot Tables.

Level: Intermediate/Advanced Objectives:  By the end of this workshop delegates will have gained an in-depth knowledge and experience of Tables, PivotTables and PivotCharts. The workshop will also look at some supporting tools, such as Conditional Formatting and Data Validation which can help when using PivotTables. Pre-requisites:  Delegates should have experience of using Excel to an intermediate level; ideally with knowledge of sorting and filtering data in lists.

Module 1: Excel Essentials - Getting started - 1½ Hours This Excel session is for anyone who is new to Excel (or any other spreadsheet package) or those who have some experience editing data but are not confident using Excel.

This session is for you if you want work with multiple workbooks and worksheets. Linking sheet tabs, Link cells from different worksheets and view multiple sheets from one workbook at the same time

If you are looking to work with templates and also gather together your data from separate worksheets into a master worksheet then this is the module for you.

Microsoft Excel combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Candidates learn the basics of creating, editing, and saving worksheets in this foundation level of training. We work with formulas and functions to calculate and return values ,learn to change the appearance of a page, to include adding headers and footers and format data.

The Intermediate Microsoft Excel course provides knowledge of the more advanced functions of Excel for anyone looking to develop their Excel skills further. From Advanced Formulas and Functions, Using Named Ranges and Charting you’ll be equipped with the knowledge and skills you need to work with Excel on a more advanced level.

Target student This course takes users to a high level of knowledge in using Microsoft Excel. Data Consolidation Advanced Database Options Outlining Pivot Tables & Pivot Charts Dashboards Working with MACROS

This course introduces users to the process of writing and editing Macros. No prior programming experience is assumed. Candidates should have an excellent working Knowledge of Excel or should have attended the Excel L3 training. FURTHER TRAINING: MS Excel MACRO PART 2 1 day course is available which builds on this training (Part1) The course can be run as a 2 day course or as separate 1 day courses.