"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Courses


hey this is here

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.

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

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

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

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

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

Course Objectives · Identify basic worksheet and workbook concepts and terms · Enter and edit data · Modify the worksheet · Use functions to calculate and return values · Change the page set-up to define how the printed worksheet appears · Format cells to enhance the appearance of your worksheet

FURTHER DETAILS
hey this is here

Course Objectives Using multiple worksheets, workbooks and workspaces Working with advanced functions Use advanced formatting techniques Using charts to display data Using Excel as a Database

FURTHER DETAILS
hey this is here

Data Consolidation Advanced Database Options Outlining Pivot Tables & Pivot Charts Dashboards Working with MACROS

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS