"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

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
hey this is here

This 1 day course builds on the MS Excel Macro/VBA (part 1). Here where we look at topics such as Forms, error Handling and Office Automation. Prerequisites: Candidates should have an excellent working knowledge of Excel or should have attended MS Excel Macro/VBA (part 1) training day.

FURTHER DETAILS
hey this is here
hey this is here

Overview: This course is for those who have attended the Excel Macro/VBA Part 1 and 2 courses and wish to further advance their knowledge of VBA. Excel will be used as the main application, but the topics can be applied to any application that uses the VBA language (such as Word, PowerPoint, and Access). Duration: 2 days

FURTHER DETAILS
hey this is here

This course applies to the following platforms: SharePoint On-Premise, SharePoint Online The goal of this course is to provide you with the knowledge required to design and publish forms for users to fill in. The course emphasizes hands-on experience, with a series of self-guided exercises integrated into the training. You will discover how InfoPath forms are constructed and be given a clear plan on how to create form templates. You will be shown how to design and create complete form templates to support your business needs. You will implement data integrity and rules into forms to manage data entry, and publish InfoPath forms to e-mail, network locations and to databases.

FURTHER DETAILS
hey this is here

This course applies to the following platforms: SharePoint On-Premise, SharePoint Online The goal of this course is to provide you with the knowledge required to design and publish forms that work within SharePoint. The course emphasises hands-on experience, with a series of self-guided exercises. You will discover how to publish form templates to SharePoint for local and global use and to define content management. You will connect InfoPath forms to various data sources such as SharePoint lists and libraries and also SOAP and REST Web Services. You will be shown how to design and create forms that can vastly improve SharePoint lists such as Tasks and Contacts, also how to customise the document library items' properties to control workflow of documents. You will be able to grab user information from SharePoint and use it to control process and functionality using workflow processes in InfoPath with and without SharePoint workflows. Target Audience: This course is aimed at users who have full control permissions in a SharePoint site and will be working with InfoPath and SharePoint Server Enterprise / Office 365 E3 or E4 plan solutions to improve data control and process.

FURTHER DETAILS
hey this is here

End User Training Overview Further training is available on all of the Office Web Apps and software. Overview: In this course the candidate will use Office Web Apps, SharePoint Online and Skype for Business Online to gain a better understanding of how they all interact with one another in the cloud. This training is suitable for users migrating to Office 365. Course Aims: Understand and navigate within the cloud and OneDrive Use WebApps e.g. Outlook, Excel, Word Use Skype for simple collaboration Work within SharePoint as a user Prerequisites: Knowledge of an earlier version of Microsoft Office. Course Content: Office 365 Overview What is Cloud Computing? We look at Outlook Web App, Office Online Apps, OneDrive, SharePoint online and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365

FURTHER DETAILS
hey this is here

Office 365 Administering and Exchange Online Environment. This three-day instructor-led course will provide delegates with the knowledge and skills to configure and manage Exchange Online, a key component of Office 365. In this course, delegates learn how to configure all aspects of an Exchange Online deployment, and also provide an overview of hybrid deployments for Exchange Online.

FURTHER DETAILS
hey this is here

Course outcome During this half-day course, delegates will learn how to: Store and share files using OneDrive Manage files View photos Share files using links and the Public folder Find the files and information needed Create documents with Office Online

FURTHER DETAILS