Find training courses on Training and Courses.com
> UK

JCS Training training courses

8 training courses found

Microsoft Excel MACROS/VBA ( Part 1 of 2)
Audience aimed at: Corporate training only

This course introduces user to the process of writing and editing MACROS. No previosu experience is assumed.

  • Study level: Not applicable
  • Duration of training: 1 day
  • Study mode: Full time
Microsoft Office Excel 2010 Level 1
Audience aimed at: Corporate training only

This course will provide the skills needed to create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. It covers: looking at the excel environment, working with an excel worksheet, modifying a worksheet, performing calculations, formatting a worksheet, developing a workbook and customizing layout.

  • Study level: Beginner
  • Duration of training: 1 day
  • Study mode: Part time day
Microsoft Excel MACROS/VBA ( Part 2 of 2)
Audience aimed at: Corporate training only

This 1 day course builds on the topics covered in part 1. In part 2 we look at topics scuh as Forms, Erroe Handling and Office Automation.

  • Study level: Intermediate
  • Duration of training: 1 day
  • Study mode: Full time
Microsoft Office Access 2013 Level 2
Audience aimed at: Corporate training only

In this course, participants will have the basic skills within Microsoft Office Access 2013 databases, including creating and working with Access tables, relationships, queries, forms, and reports. It covers: cover data, queries, reports and sharing, controlling data entry, joining tables, manipulating flexible queries, form design and enhancement, customizing reports and sharing data across applications.

  • Study level: Intermediate
  • Duration of training: 1 day
  • Study mode: Part time day
Microsoft Office Access 2007/2010 or 2013 Level 1
Audience aimed at: Corporate training only

In this course, participants will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access relational database application. It covers: access environment, database design, building a database, managing data in a table, querying a database, designing forms and creating reports.

  • Study level: Beginner
  • Duration of training: 1 day
  • Study mode: Part time day
Microsoft Office Access 2013 Level 3
Audience aimed at: Corporate training only

During this Intermediate/Advanced training day we concentrate on Macros, Database Utilities, Security and create a Switchboard. Topics we cover include MACROS - creating, editing and deleting submacros.

  • Study level: Intermediate
  • Duration of training: 1 day
  • Study mode: Full time
Understand & Create Pivot Tables
Audience aimed at: Corporate training only

In this training course we look at all of the aspects of creating and manipulating Pivot Tables. A Pivot table is an interactive table that quickly summarizes large amounts of numeric data so you can analyse it in detail.

  • Study level: Not applicable
  • Duration of training: 1 day
  • Study mode: Part time day
Microsoft Office Excel 2010 Level 2
Audience aimed at: Corporate training only

In this course, participants will develop their skills to streamline, enhance spreadsheets by using template, charts and graphics. It covers: enhancing workbooks, creating workbooks using templates, presenting data using charts, pivot tables and pivot charts, calculating data with advanced formulas, sorting and filtering data.

  • Study level: Intermediate
  • Duration of training: 1 day
  • Study mode: Part time day