Search
Microsoft Excel – Live Online Bitesize Training Modules 1 1/2 Hour Modules
1½ Hour Modules. 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
DetailsMICROSOFT EXCEL VBA ADVANCED DURATION: 2 DAYS
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
DetailsMicrosoft Excel Level 3 Advanced Duration: 1 Day
Data Consolidation Advanced Database Options Outlining Pivot Tables & Pivot Charts Dashboards Working with MACROS
DetailsMicrosoft Excel – Pivot Tables Masterclass Duration: 1 day
This course has been designed for candidates who want the benefit of using the advanced formulas and functions of Excel Pivot Tables.
DetailsExcel PivotTables and Dashboards
An Excel dashboard is a visual dynamic interface showing a summary of consolidated data on a single screen. On this course you will learn how to create Dashboards using the existing tools in Excel. You don’t need any knowledge of Visual Basic macros and there is no need for extra ‘add-ins’. Some experience of using Tables and basic PivotTables would be advantageous. Suitable for Excel 2013 and 2016 users.
DetailsMicrosoft Excel Level 1 Intro Duration: 1 Day
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
DetailsAdvanced Solutions of Microsoft Excel Server 2013 About this course Course code M20342 Duration5 Days
Target Audience: This course is intended for people aspiring to be enterprise-level messaging administrators. Others who may take this course include IT generalists and help desk professionals who want to learn about Exchange Server 2013. People coming into the course are expected to have at least 3 years of experience working in the IT field—typically in the areas of network administration, help desk, or system administration. Students are expected to have experience with Exchange Server 2013 or with previous versions of Exchange Server. In addition, this course is intended as preparation material for IT professionals who are looking to take the exam 70-342: Microsoft Exchange Server 2013, Advanced Solutions, as a stand-alone, or as part of the requirement for the MCSE: Microsoft Exchange Server 2013 certification. Please note this course is not suitable for those wishing to learn about Exchange Online as part of an Office 365 deployment, where we recommend our course Administering an Exchange Online In addition, please note this course is not suitable for delegates wishing to learn how to deploy a Hybrid Exchange Environment (On-Premise and Exchange Online integrated). Delegates wanting to have hands on exposure to planning and deploying an Exchange Hybrid Environment should attend the QA Deploying an Exchange Hybrid Environment course. Full details on any courses names above available on request. Prerequisites In addition to their professional experience, students who attend this training should already have the following technical knowledge: Passed 70-341: Core Solutions of Microsoft Exchange Server 2013, or equivalent Minimum of two years of experience working with Exchange Server Minimum of six months of experience working with Exchange Server 2010 or Exchange Server 2013 Minimum of two years of experience administering Windows Server, including Windows Server 2008 R2 or Windows Server 2012 Minimum of two years of experience working with Active Directory Minimum of two years of experience working with name resolution, including DNS Experience working with certificates, including public key infrastructure (PKI) certificates Experience working with Windows PowerShell Delegates will learn how to At the end of this course you will be able to: Design and implement Exchange Server 2013 Unified Messaging. Design and implement site resiliency for Exchange Server 2013. Plan a virtualization strategy for Exchange Server 2013 roles. Design and implement message transport security. Design and implement message retention in Exchange Server 2013. Design and implement messaging compliance. Design and implement administrative security in an Exchange Server 2013 environment. Use Windows PowerShell 3.0 to manage Exchange Server 2013. Design and implement integration with Exchange Online. Design and implement messaging coexistence. Design and implement Exchange Server migrations from non-Exchange messaging systems, and upgrades from previous Exchange Server versions.
DetailsMicrosoft Excel Macro/VBA (part2) Duration: 1 day
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.
DetailsMicrosoft Excel Macro/VBA (Part1) Duration: 1 day
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.
DetailsMicrosoft Excel Level 2 Intermediate Duration: 1 Day
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
DetailsMastering Financial Modelling in Excel Duration: 1 day
Objectives: Tutor led hands on training day covering Excel Formulae. In this course we concentrate on Excel Formulae from a basic level through to advanced – the exercises used through this training are designed to help the candidate master financial modelling whist showing shortcuts and tips to assist with effective use of this spreadsheet software. Who should attend? This course is beneficial for candidates who need a good understanding of formulas and functions.
DetailsMicrosoft Excel Analysing Data with Tables, PivotTables & Pivot Charts Duration: 1 day
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.
DetailsQuick contact…
How to find us…
JCS Training
34 Charter, Quarry Park Close,Moulton Park, Northampton, NN3 6QB
tel: 01604 495252
Fax: 01604 491799
email: training@jcstraining.com
2017 © JCS Group. All rights reserved.