Courses

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.

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.

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

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

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.

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

Microsoft Outlook – Live Online Bitesize Training Session 1½ Hour Module. Training will include the following. Delivered by a JCS Senior Microsoft Trainer – examples (Video and audio) Question and answers via chat window Work through selected short exercises (assumption that delegates have training application on their PC/device) Downloadable post course support material/telephone and email support

Course objectives: We introduce the candidate to Outlook then move to look at the Outlook Windows and using address books. Concentrating on sending and receiving mail and mail options we then cover organising mail in folders, work on calendars and how to create Outlook tasks and notes. This course gives the delegate the confidence to use the fundamentals of this communication software. Target Audience: This course is designed for new users of MS Outlook. If you are self-taught, then the course will also help bridge any gaps in your knowledge.

Course objectives: We introduce the candidate to Outlook then move to look at the Outlook Windows and using address books. Concentrating on sending and receiving mail and mail options we then cover organising mail in folders, work on calendars and how to create Outlook tasks and notes. This course gives the delegate the confidence to use the fundamentals of this communication software. Target Audience: This course is designed for new users of MS Outlook. If you are self-taught, then the course will also help bridge any gaps in your knowledge. Course Prerequisite: You should have a basic knowledge of Outlook and basic Microsoft Windows, This course is designed for new users of MS Outlook. If you are self-taught, then the course will also help bridge any gaps in your knowledge

Course objectives: In this training day we use more advanced contacts features like distribution lists and V cards and advanced calendar features like group schedules and recurring appointments, we address the more advanced functions such as how to share your mailbox and calendars with other and use Outlook Journal. Target Audience: This course is designed for Existing users of Microsoft Outlook. . If you are self-taught, then the course will also help bridge any gaps in your knowledge Prerequisites: Ideally you would have basic Outlook skills equivalent to JCS Outlook level 1 training.

This advanced 2-day course is intended for anyone who has existing experience working with Power BI and who wants to extend and enhance their knowledge beyond the basics. You will gain deeper insights into the inner workings of Power BI by implementing your own code in Power Query using the M language, further enhance the data model using the DAX expression language and get a better understanding of your data using advanced capabilities and features in Power BI. In addition to understanding the technical workings of Power BI, it is also intended to demonstrate best practices and highlight practical solutions to common data analytic scenarios. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.