Enable Technology

CANNOCK TRAINING COURSES 

TRAINING COURSES CANNOCK




Adobe Dreamweaver CC

  • 2 day course
  • Location: Cannock
  • Course Outline
  • In this course, students will learn how to use Dreamweaver Creative Cloud CC to plan, create, and modify a website. They will also learn how to create pages and format text; define structural elements; create and apply CSS style rules; insert and modify images and links; test and manage Web site files; and publish a site.

  • Some of the training topics covered include ...
  • Creative Cloud Libraries
    Understanding Adobe Colour CC
    Dodging and Burning
    Understanding Selecting Text
    Correcting a Colour Cast Automatically
    Working With Workspaces
    Checking Spelling
    Brightening Washed Out Colours
    Adding Grain With the Add Noise Filter
    Clearing Floats
    Creating a New Webpage
    Adding a Border
    Understanding Tone Colour and Channels
    Using Curves to Improve Contrast
    Working With Navigation
    Adobe Photoshop Mobile Applications
    Understanding Hyperlinks and URLs
    Searching for Online Help
    What Is Dreamweaver

  • See Training Course Details...


Adobe Illustrator CC

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive Adobe Illustrator Creative Cloud CC course.  No prior Illustrator knowledge is assumed

  • Some of the training topics covered include ...
  • Saving and Printing
    Starting Illustrator in Windows 8
    Understanding TypeKit
    Applying Gradients to Strokes
    Creating a Document
    Creating and Deleting Artboards
    Creating Polygons
    Editing Path Segments
    Using the Paintbrush Tool
    Importing Text
    Creative Cloud Libraries
    Understanding Panels
    Applying a Linear Gradient
    Working With Stroke Width
    Understanding Live Paint
    Using the Zoom Tool
    Creating an Art Brush
    Navigating With the Navigation Panel

  • See Training Course Details...


Adobe InDesign CC

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two-day intensive Adobe InDesign Creative Cloud (CC) training course.  No prior InDesign knowledge is assumed. Participants will acquire the skills necessary to produce and edit newsletters, leaflets,  publications and electronic documents.

  • Some of the training topics covered include ...
  • Working With the Status Bar Navigating InDesign
    Floating and Docking Panels
    Creating a Snippet
    The Libraries Panel
    Transforming Shapes
    Checking Your Fonts for EPUBS
    Selecting Colours Using the Eyedropper
    Using Selection Tools
    Placing Graphics in a Document
    Applying Corner Effects
    Exporting to PDF
    Viewing and Hiding the Grid
    Formatting a Table of Contents
    Packaging a Document Getting Help
    Inserting a Snippet Working With Styles
    Understanding Adobe Colour CC
    Creating Paragraph Styles
    The Welcome Experience
    Creating User Identification
    The EPUB Export Options Dialog box
    Creating a Table

  • See Training Course Details...


Adobe Photoshop CC

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive Adobe Photoshop Creative Cloud CC training course . The course assumes no prior Photoshop knowledge.

  • Some of the training topics covered include ...
  • Working With the Panel Dock
    Using Online Help
    Organising Layers Into Groups
    Signing in to Your Adobe Account
    Transforming Images
    Understanding the Preferences Dialog Box
    Working With the Light Source
    Understanding 3D Concepts
    Cropping Images to a Preset Size
    Saving PSD Images in Another Format
    The Creative Profile Home Page
    The Adobe Website
    Printing
    Editing an Embedded Smart Object
    Understanding the Help Menu
    Sculpting With Liquify
    Selecting Colours Using the Hue Cube
    Add to or Subtract From a Selection
    Arranging Multiple Documents
    Understanding the Refine Edge Dialog Box
    Navigating With the Hand Tool

  • See Training Course Details...


ASP.NET Core MVC

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This course covers the fundamentals of the Model-View-Controller design pattern and its implementation in ASP.NET Core MVC. This technology is compared with classical ASP.NET Web Forms. Visual Studio 2017 with ASP.NET Core 2.0 is used as a productive platform for creating MVC Web applications. After presenting the fundamentals of the technology with several examples, the main components of Model, Controller and View are covered in detail. The discussion of the Model incorporates Microsoft technologies for persisting data, including XML Serialization and ADO.NET with SQL Server 2016. The routing mechanism of ASP.NET MVC is covered. The course includes an introduction to ASP.NET Web API.

    The student should have a prior knowledge of C# and the .NET Framework. Basic knowledge of HTML and some prior exposure to .NET Core would also be helpful.

  • Some of the training topics covered include ...
  • HTTP Testing Tools
    NuGet Package Manager
    Using Visual Studio
    Model-View-Controller Pattern
    Using ViewBag
    Representational State Transfer
    Advantages and Disadvantages of Web Forms
    ASP.NET Web API Clients ASP.NET Core and Azure
    Using XML Serialization
    A Windows Azure Testbed
    Input Validation The Model
    Filters The View
    Review of ASP.NET Web Forms
    Serving Static Files
    Using ADO.NET The Controller
    View Responsibility
    HTTP Services Using Web API
    Form Submission
    Controller Base Class
    Unit Testing Getting Started with ASP.NET Core MVC
    REST and Web API

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Cannock
  • Course Outline
  • This course provides practical, hands-on expertise on developing Web Applications using ASP.NET 4 and C#. Numerous programming examples and exercises are examined. A working knowledge of HTML is however assumed.

  • Some of the training topics covered include ...
  • Managing State 
    Client-side Code Debugging in ASP.NET 
    Introduction to Web Controls 
    Filter Data in the GridView Control 
    ASP.NET Session State 
    Storing Session State in SQL Server 
    Creating a Consistent Web Site 
    Preserving State in Web Applications 
    Displaying XML Data Using the XmlDataSource Control 
    Using the Visual Debugger 
    Investigating Styles 
    Data Binding in ASP.NET 
    Writing Code to Interact with Membership and Roles 
    Configuration Overview 
    Debugging Stored Procedures 
    URL Mapping 
    Displaying and Editing Middle-Tier Data using the ObjectDataSource Control 
    Allow Users to Select from a DropDownList in the Grid 

  • See Training Course Details...


ASP.NET using VB.NET

  • 3 day course
  • Location: Cannock
  • Course Outline
  • This course provides a practical, hands-on overview of how to develop Web Applications using ASP.NET 4 and VB.NET. The course assumes a working knowledge of HTML and is suitable for anyone who wishes to use ASP.NET to develop dynamic web content.

  • Some of the training topics covered include ...
  • LINQ to XML 
    Using the Web Site Administration Tool 
    Security Trimming 
    Debugging Stored Procedures 
    List Controls 
    ASP.NET 2.0 Themes 
    Configuring Session State 
    Storing Objects in Session State 
    Data Binding 
    Introduction to Membership and Roles 
    Master Pages 
    Connecting to Data 
    Data Binding in ASP.NET 
    HyperLink and Button Controls 
    Preserving State in Web Applications 
    Introduction 
    Themes and Master Pages 
    Allow Users to Select from a DropDownList in the Grid 

  • See Training Course Details...


Crystal Reports 2008

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A  two day training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using Crystal Reports 2008. No prior Crystal Reports experience is assumed.

  • Some of the training topics covered include ...
  • Using Multiple Sections in Reports
    Database Filtering with the Select Expert 
    Using Guides and Guidelines to Move and Align Objects 
    Formatting Individual Cells
    Using Subreports to Link "Unlinkable" Data 
    Using the Report Wizards 
    Working with the Page Commands 
    Passing Data from the Main Report into a Subreport
    Adding Fields into a Text Object
    Formatting Features 
    Subtotals Using the Group Sort Expert
    Manipulating Dates with Formulas 
    Conditionally Formatting Multiple Sections
    Applying Chart Templates 
    Using the Group Tree to Navigate the Report 
    Autosaving the Report 
    Using the Running Totals Feature
    Understanding Crystal Formula Syntax 

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting,grouping, linking, formula creation and parameters using the Crystal Reports 2011 release.

  • Some of the training topics covered include ...
  • Parameter Field Considerations
    Using an Edit Mask to Limit String 
    Working with Variables
    Parameters
    Formatting
    Creating Running Totals for a List of 
    Using the Running Totals Feature
    Grouping Hierarchically
    Using the Preview Panel 
    Using the Group Tree to Navigate the Report 
    Using the Sort Control 
    Summarizing Groups 
    Creating Boolean (True/False) Formulas 
    Learning about Linking 
    Using the Formula Workshop and Editor 
    Editing and Formatting Charts 
    Using the Section Expert to Work with Sections

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using the Crystal Reports 2013. No prior knowledge of Crystal Reports is required.

  • Some of the training topics covered include ...
  • The Record Selection Dialog Box
    Grouping Hierarchically Working with Cross-Tab Reports
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Creating a Group
    Creating a Dynamic Value List
    Format Painter
    Exporting to Windows Applications
    Case Sensitive vs. Case Insensitive
    The Group Sorting Dialog Box
    Understanding Subreports
    Selecting Records with Multiple Criteria
    Using the Sort Control
    Inserting Graphics
    Starting a New Report
    Using Evaluation Time Functions
    Learning about Linking
    Parameter Fields Overview
    Understanding Crystal Formula Syntax
    Creating a Parameter Field
    The Data Dialog Box
    Using the Parameter Panel

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using Crystal Reports 2016. No prior knowledge of Crystal Reports is required.

  • Some of the training topics covered include ...
  • The Group Sorting Dialog Box
    Passing Data from the main Report into a Subreport
    Selecting Records with Multiple Criteria
    Grouping Data in Date/Time Intervals
    Editing Charts
    Importing a Pick List
    Using the Preview Panel
    Refreshing the Data
    Using Parameters in Conditional Formatting
    Understanding How Cross-Tabs Affect Your Data
    Changing the Summary Operation
    Understanding Export Formats and Destinations
    Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
    Applying a Formatting Style to the Cross-Tab
    Creating an Unlinked Subreport
    Conditional Running Totals Prompting with Parameters
    Understanding Crystal Formula Syntax
    Formatting Sections Conditionally
    Formatting Objects
    Creating Running Totals for a List of Numbers
    Starting the Crystal Reports Program

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day comprehensive Crystal Reports XI trainingcourse will prepare participants to build and distribute complex reports whichinclude sorting, grouping, linking, formula creation and parameters.

    Crystal Reports training courses are also available in Crystal Reports versions8.0, 8.5, 9.0 and 10. 

  • Some of the training topics covered include ...
  • Creating Running Totals for a List of Numbers
    Using an HTML Format
    Using Group Selection to Filter the Records in the Report
    Adding and Working with Text Objects
    Getting Help Formatting Features
    When and Why to Group Records
    Defining the Purpose of the Report
    Adding Multiple Tables to a Report Creating and Using Formulas
    Selecting Certain Records
    Pass #3
    The Template Dialog Box Review of Planning a Report
    Grouping on a Formula Field
    Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
    What are Report Alerts
    Understanding Crystal Formula Syntax without Being a Programmer
    Grouping Hierarchically Working with Cross-Tab Reports
    Setting the Default Layout for Design and Preview Views Using the Report Wizards
    Understanding How Cross-Tabs Affect Your Data
    Creating Custom Groups
    Modifying Individual Objects in the Chart
    Hiding and Suppressing Sections

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Cannock
  • Course Outline
  • This CSS3 course will expose students to new features in CSS3. Participants will learn how to use selectors and pseudo elements, font, color, and layout techniques; transforms, transitions, and animations. The course will explore how CSS media queries can be used to change how websites are presented on mobile devices.

  • Some of the training topics covered include ...
  • Frameworks and Grid Systems
    HTML5 Selectors and Pseudo Classes
    What is CSS3?
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Embedding Media
    Implementing CSS3 in the "Real World"
    Layout: Columns and Flexible Box
    Structural Pseudo-Classes Fonts and Text Effects
    Browser Support
    Backgrounds
    Box Shadow Transitions, Transforms, and Animations
    Text Shadow
    Accessibility Features
    Responsive Images and the viewport Metatag
    Web Accessibility
    What Are Vendor Prefixes
    Styling Video

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Cannock
  • Course Outline
  • This course is intended for Power Users, IT Professionals, Report Developers, BI Professionals and  Project Managers interested in exploring the Microsoft toolsets for data mining, machine learning and predictive analytics. Participants will fully explore the potential of Excel PowerPivot and Excel Data Mining Add-ins used in  conjunction with Microsoft  SQL Server Analysis Services (SSAS).

  • Some of the training topics covered include ...
  • Management
    Offline Mode and Immediate Mode
    Microsoft Time Series Algorithm
    Concepts and Terminology
    Microsoft Sequence Clustering Algorithm
    The User Interface
    Connection
    Testing and Validation of Mining Models
    CRISP-DM
    Microsoft Neural Network Algorithm
    Types of Data Mining Algorithms
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Microsoft Linear Regression Algorithm
    The Mining Model Prediction Tab
    Creating Reports Using Reporting Services
    Model Usage
    Data Mining Tab
    Introduction to SQL Server Data Tools
    Microsoft Naïve Bayes Algorithm
    Cross Validation

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day intensive course will demonstrate how to use HTML5, CSS, JavaScript, and other tools to create websites which adapt their layout to the client device, whether it be a smartphone, tablet computer or desktop computer. The course assumes prior knowledge of HTML, CSS and some familiarity with SQL.

  • Some of the training topics covered include ...
  • Local Storage
    Optimizing for Mobile
    The GeoLocation API
    GeoLocation API
    New HTML5 Features
    Local Storage Example
    Embedding from YouTube or Vimeo
    Media Queries
    Integrating with the Home Screen
    Foundation: A Responsive Grid Framework
    Flexible Grids
    Accessing Camera, Contacts, Calendar, and More - But Not Yet
    The Case for Flexible
    Swiping to Change Pages
    Optimizing the Video Experience for Mobile
    Linearizing the Layout
    Responsive Design: Good for All Devices

  • See Training Course Details...


Excel Advanced

  • 1 day course
  • Location: Cannock
  • Course Outline
  • A one-day course covering Microsoft Excel advanced topics.

  • Some of the training topics covered include ...
  • Understanding Data Validation
    Creating an Automatic Outline
    Using the DCOUNT Function Validating Data
    Creating Slicers
    Counting in a PivotTable
    Defining the PivotChart Structure
    Setting Excel Options
    Setting Macro Security
    Inserting a PivotChart
    Providing Restricted Access to Cells
    Protecting a Worksheet
    Sharing Workbooks via the Network
    Enabling Tracked Changes
    Understanding Text File Formats
    Extracting Records With Advanced Filter
    Preparing a Worksheet for Controls
    Defining the PivotTable Structure
    Inserting a Picture
    Setting the Default File Location
    Changing Control Properties
    Using a Subtotalled Worksheet

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Cannock
  • Course Outline
  • A one day course introducing Excel.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.

  • Some of the training topics covered include ...
  • Working With Multiple Worksheets
    Filling a Series
    Understanding Data Editing
    Using Tell Me
    Vertical Cell Alignment
    Creating Formulas That Subtract
    Formatting Percentages
    Approximating Column Widths
    Understanding Filling
    Typing Dates
    Selecting Contiguous Ranges
    Relative Formulas
    Changing the Chart Type
    Changing the Worksheet View
    Copying From One Cell to a Range
    Extracting With Flash Fill Moving Data
    Printing a Range
    Moving by Dragging Formulas and Functions
    Easy Formulas
    Formatting for Money
    Understanding Filtering

  • See Training Course Details...


Excel Intermediate

  • 1 day course
  • Location: Cannock
  • Course Outline
  • A one day course covering Microsoft Excel Intermediate topics.

  • Some of the training topics covered include ...
  • Copying a Worksheet
    Understanding Tables
    Creating Descriptive Custom Formats
    Custom Formatting Large Numbers
    Understanding Goal Seeking
    Custom Formatting for Fractions
    Setting a Background
    Applying a Border to a Cell
    Splitting a Table
    Adding Error Bars
    Using IF With Text
    Switching to Manual Recalculation
    Understanding the Format Pane
    Changing Margins by Dragging
    Workbook
    Adding a Chart Title
    Adding More Complexity
    Using Names in Typed Formulas
    Using the More Borders Command
    Exploding Pie Slices

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Cannock
  • Course Outline
  • A one day course introducing candidates to Power View and Power Pivot Excel tools.

  • Some of the training topics covered include ...
  • Understanding Power View
    Working With Time Settings
    Working With Data Model Fields
    Transforming Data
    Working With the Data Model
    Tiling Data in Power View
    Viewing and Editing a Tour
    Understanding Power Map
    Rearranging and Sorting Fields
    Creating a New Query From a File
    Understanding the Navigator Pane
    Switching Visualisations
    Understanding Relational Data
    Adding Slicers Get & Transform
    Editing Query Steps
    Working With Scene Options
    Exporting a Tour as a Video
    Working With Layers
    Working With Measure Fields
    Adding Power View to the Ribbon
    Creating a Power Map Tour

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day Excel VBA programming course which introduces advanced Excel users to the process of writing and editing Macros. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Adding Code to Controls
    Understanding Modules
    Navigating the Excel Object Hierarchy
    Working with Procedures and Functions
    Launching a Form in Code
    Using Visual Basic Help
    Working with the PivotFields Collection
    Creating an Event Procedure
    Declaring and Using Object Variables
    Closing the Visual Basic Editor
    Working with Properties
    Working with UserForm Properties, Events, and Methods
    Understanding Control-of-Flow Structures
    Working with the Combo Box Control
    Using the For...To...Next Structure
    Running a Macro
    Using Debugging Tools
    Populating a Control

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day Flash ActionScript 3.0 course will explore best practices when developing rich Flash applications, review important concepts such as syntax, object oriented programming, animating with ActionScript, and keyboard and mouse event handlers.

  • Some of the training topics covered include ...
  • Introducing Object Oriented Programming 
    XML with EX 
    Demonstration -: Using EX Operators 
    Using Functions 
    Using a MovieClip and Button's Properties 
    Programmatically Formatting Text 
    Static Methods and Properties 
    Creating Visual Classes Through Inheritance 
    Getting a Date with ActionScript 
    What is XML 
    Declaring Methods 
    Declaring and Using Variables 
    Using the MouseEvent 
    ActionScript Events 
    Using the Tween Class 
    Handling Events 
    Types of Loops 
    Making the Stage a Class 
    Determine when the SpaceShip Crashes 
    Adding Asteroids to the Screen 
    Getting Started with Coding 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Cannock
  • Course Outline
  • A three aday course introducing the fundamentals  Google Acript Programming.  Participants will learn the how to create and manipulate Googe documents, folders, calendars and spreadsheets.  The course will also demonstrate how to link google documents a a underlying database.

  • Some of the training topics covered include ...
  • Connecting To The MySQL Database
    Adding Users Building Simple Graphical Interfaces
    Creating And Removing Files And Folders
    File And Folder Permissions
    Adding Files To And Removing Files From Folders
    The Range offset() Method
    Calendars Web Apps With Html Service
    Menus And Dialogues
    The Spreadsheet Object
    Date Functions
    User-Defined Functions Versus JavaScript Functions
    Creating A Table
    Database Metadata
    Executing Code User Defined Functions
    Google Spreadsheet Limitations Getting Started
    A Data Entry Form
    JDBC Overview
    Using A Function Callback
    Using List Boxes Google Drive, Folders, Files and Permissions
    Object Hierarchies
    SpreadsheetApp

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day course introducing HTML (Hyper Text Markup Language). Delegates will learn to create and edit simple web pages containing text, lists, images, hyperlunks, forms and tables.

    No prior HTML or web development knowledge is assumed. 

  • Some of the training topics covered include ...
  • HTML Links
    CSS Comments
    Getting Started
    Making Images Accessible
    Some XML Stuff Paragraphs, Headings and Text
    Media Types and Units of Measurement
    Ordered Lists
    TheElement TheElement
    name vs. id
    Formatting Elements
    Radio Buttons
    Inserting Images
    Select Menus
    Selectors
    Introduction to HTML
    Alternative Text
    Preformatted Text
    Documenting Changes
    HTML Elements
    Id and Name Attributes

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Cannock
  • Course Outline
  • Participants on this two day courses will learn about HTML5 structural, semantic, and form tags, how to use Canvas to create drawings natively in the browser, how to work with HTML5 audio and video, the methods for storing variables client-side, and how you build applications that work offline. The course is aimed at delegates with an existing knowledge of HTML 4 or xhtml.

  • Some of the training topics covered include ...
  • Modernizr
    Multiple Sub-Paths
    placeholder
    New Form Elements
    required
    Additional Changes
    Colour and Transparency
    Managing ApplicationCache with JavaScript
    Sectioning
    Dealing with Non-Supporting Browsers
    Outlining
    Indexed Database API
    min, max, and step attributes
    HTML5 Canvas
    The article Tag
    New Input Types

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This introductory two day JavaScript training course aimed at Web Designers will enable participants to interpret, adapt and write their own JavaScript code.

    No prior programming knowledge is assumed.-

  • Some of the training topics covered include ...
  • Square Bracket Notation
    Working with Images
    Built-In JavaScript Objects
    Associative Arrays
    The HTML DOM
    Array Properties and Methods
    The this Object
    isNaN(object)
    Number(object)
    JavaScript Form Validation
    Built-in Functions vs Methods
    Preloading
    for in Loop Syntax
    A Loosely-typed Language
    Conditionals
    Basics of Form Validation
    if - else if - else Conditions
    Switch / Case
    Backward Compatibility
    Accessing Form Data

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Cannock
  • Course Outline
  • This intensive three day jQuery training course provides a comprehensive overview of the jQuery JavaScript library. Ideally candidates should have a working knowledge of HTML and CSS.

  • Some of the training topics covered include ...
  • Managing Effects
    The Module Pattern
    Specificity
    Manipulating Elements
    Syntax Basics
    Traversing
    Beware Anonymous Functions
    Functions as Arguments
    GET vs. Post
    Conditional Variable Assignment with the Ternary Operator
    $ vs $()
    Doing Something When an Effect Is Done
    Does My Selection Contain Any Elements?
    Cloning Elements
    Selecting Elements
    Self-executing Anonymous Functions

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course in which participants develop single sites for all popular smartphone, tablet, and desktop platforms. You'll learn how to use jQuery Mobile to handle touch events, build mobile-optimized forms and widgets, incorporate HTML5 features, leverage phone capabilities such as making calls and texting, and more. Along the way, we'll cover jQuery Mobile's extensive theme framework and plugin architecture.

    Prior knowledge of HTML, CSS and JavaScript is required.

  • Some of the training topics covered include ...
  • Using Others' Plugins
    plugin Architecture
    Buttons and Linking Pages
    Sending SMS Texts
    Video The Theme Framework
    Dialogs
    Making Calls
    What Is jQuery Mobile?
    Overriding Themes with Custom CSS Plugins
    Collapsible Blocks Events
    Accessibility Support
    Themes and Swatches
    ThemeRoller
    Levels of Support
    Ajax-driven Page Navigation
    Data-role
    Lists and Buttons

  • See Training Course Details...


Microsoft Access 2007

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Joining tables in queries
    Creating parameter queries
    Adding Graphics
    Summarizing and grouping values Advanced form design
    Optimizing resources
    Modifying and printing reports Relational databases
    Creating, running, and modifying macros
    Creating macros to provide user interaction
    PivotTable forms Querying with SQL
    Charts in reports PivotTables and PivotCharts
    Planning and designing databases
    Importing objects
    Modifying and printing reports Relational databases
    Interacting with XML documents
    Changing the design of a table
    Setting options and properties
    Changing the design of a table
    Getting started
    Creating tables Fields and records
    Adding unbound controls

  • See Training Course Details...


Microsoft Access 2010

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Database concepts
    Using Design view
    Exploring tables
    Modifying lookup fields
    Setting options and properties
    Setting field properties
    Modifying query results and queries
    Sorting and filtering records Working with reports
    Attaching SQL queries to controls Advanced queries
    Hyperlink fields Database management
    Modifying PivotTables
    Table relationships
    Exporting objects
    PivotTables
    Adding graphics
    Using calculated fields
    Importing objects
    Calculated values
    Getting help Databases and tables
    Organizing records Data entry rules
    PivotCharts

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Creating reports
    Creating lookup fields
    Using calculated fields
    Creating macros for data transfer Importing, exporting, and linking objects
    Modifying query results and queries
    Exploring the Access environment Databases and tables
    Writing SQL statements
    Planning and designing databases
    Creating parameter queries
    Setting options and properties  
    SQL and Access
    Referential integrity Related tables
    Calculated values and subreports
    Creating tables Fields and records
    Using hyperlink fields Database management
    Organizing records Data Entry rules
    Report formatting
    Creating macros to provide user interaction
    Changing the design of a table
    Summarizing and grouping values Advanced form design
    Setting field properties

  • See Training Course Details...


Microsoft Access 2016

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Designing a Lookup Database
    Relational Database Design
    Aggregation Queries
    Navigation Pane Protection
    Modifying Table Structures
    Creating Queries
    Formatting Tables
    Multi Table Queries
    DIY Forms
    Creating a Relational Database
    Sorting and Filtering
    Data Validation
    Working With Records
    Importing and Exporting Records
    Getting to Know Access 2016
    Creating and Using Forms
    Parameter Queries
    Modifying Forms
    Creating and Using Reports
    Database Security
    Macros on Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cannock
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding Recordset Cursor Properties - Optional
    Working with Inline Error Handling
    Understanding Collections
    Working with Boolean Expressions
    Considering Variable Scope and Lifetime Together
    Using the If...End If Decision Structures
    Using the Object Browser
    Understanding the Development Environment
    Using Break Mode during Run Mode
    Using the Do...Loop Structure
    Working with Recordsets
    Understanding the Err Object
    Understanding Classes and Objects
    Writing an Error-Handling Routine
    Stepping through Code
    Handling Errors
    Understanding Errors
    Using the CacheSize Property - Optional
    Working with Events
    Understanding Objects

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Cannock
  • Course Outline
  • This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel.  The course uses Excel 2016, however Power Query works with Excel 2010 and above.  

    Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.

  • Some of the training topics covered include ...
  • Importing, Transforming, and Loading Data into Excel and Power Pivot
    Introduction to Power BI Desktop
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Power Query Interface
    Loading into Power BI Desktop
    Appending Operations
    Performing Merges
    Understanding the Issues
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Importing Data
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand the M interface.
    Understand Power Query formulas.
    Combining Worksheets
    Using PivotTables CONNECTING TO DATABASES
    Using Ranges in Excel
    Understanding and Handling Special Situations
    Loading into Excel
    Understand and utilize merges. LOADING YOUR DATA
    Grouping Options

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This course is intended for Power Users, Business Intelligence Developers and IT Professionals who will be involved with the development of Excel PowerPivot queries and tabular modelling. The course is intended to expose the delegates to the technology of DAX and to familiarise them with functionality of DAX at an advanced level.

     Prior experience with Excel and Microsoft SQL query writing is useful.

  • Some of the training topics covered include ...
  • Mathematical Functions
    Introduction to DAX
    Exploring Data Types
    Information Functions
    Relational Functions Understanding Evaluation Contexts
    Many-to-Many Relationships
    Filter Functions
    Understanding Values
    Conversion Functions
    Date Functions
    Aggregation Functions
    Handling Errors Using DAX Functions
    PowerPivot Data Model
    The CALCULATE Function
    Single Table Evaluation Context
    Working with Calendars
    Utilizing Operators
    Introduction to DAX
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Text Functions

  • See Training Course Details...


Microsoft Power BI

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This course is intended for Managers, Report Developers and Data Participants who will learn how to use Microsoft Power BI to transform organisational data into rich visuals that facilitate new ways of thinking. This course covers both Power BI On Line and Power BI desktop. 

  • Some of the training topics covered include ...
  • Overview of the Power BI Data Model. Using Power BI
    The Power BI Interface
    The developer API
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Create a Power BI dashboard
    Direct connectivity from Power BI desktop
    Shape data using formatting and transformations.
    Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    Using databases as a data source for Power BI
    Create relationships between data tables.
    Topics covered include- Introducing Power BI
    Connecting to Power BI data
    Importing different data sources into Power BI
    Importing data into Power BI
    Using the Power BI mobile app
    Custom visuals Power BI mobile app
    Power BI desktop queries
    Managing a Power BI solution
    Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
    Combine data together from tables in your dataset. Modeling data

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Cannock
  • Course Outline
  • The course is targeted towards business analysts, business intelligence developers and reporting professionals. Participant will learn how to combine the functionality of Power View, PowerPivot, Power Query and Power BI into graphs, charts, KPIs, reports and other data visualisations.

  • Some of the training topics covered include ...
  • Applying Filters
    Using Cards
    Aggregations
    Understand querying with natural language
    Add time to a presentation.
    Theming Reports
    Visualizing Power View Reports
    Merge datasets.
    Understanding DAX
    Configure tours, scenes, and layers.
    Utilizing DAX Functions
    Manage modifications.
    Navigate the Power BI interface.
    Perspectives Power Query
    Topics include –
    Introduction to the PowerPivot Interface
    Perform data cleaning.
    Creating PivotTables
    Filter data.

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Observing project progress Analyzing and adjusting the plan
    Working with groups
    Exploring the Project window
    Working with filters
    Creating base calendars
    Visual reports Customizing the project environment
    Using drawing tools
    Creating macros
    Exporting data
    Customizing reports
    Using Help Working with tasks
    Managing a project
    Consolidating and sharing projects
    Creating a Work Breakdown Structure Scheduling tasks
    Project management concepts
    Working with hyperlinks Exchanging project data
    Working with resources and calendars
    Working with resource costs Working with views and tables
    Resolving resource conflicts
    Sharing resources across projects Project communications
    Finalizing schedules

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Working with views
    Task options Resource management
    Managing a project
    Getting started
    Hyperlinks
    Team Planner view Working with reports
    Custom views
    Customizing Project
    Working with tables Filters, groups, and sorting
    The Project window
    The base calendar
    Updating an active project
    Working with templates Creating projects from other programs
    Consolidating and sharing projects
    Custom fields Managing multiple projects
    Task relationships
    Modifying a task list Task scheduling
    Exporting to Office applications
     Macros
    Project management concepts

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Finalizing schedules
    Handling resource conflicts
    Gantt chart formatting
    Updating an active project
    Creating a task list
    Getting started
    Analyzing the plan
    Project files Tasks
    Working with tables Filters, groups, and sorting
    The Project window
    Custom fields Managing multiple projects
    Hyperlinks
    Filters
    Visual reports Customizing Project
    Working with templates
    Monitoring progress
    Analyzing and adjusting the plan
    Setting baselines

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A short intensive course covering Microsoft Project Levels 1, 2 and 3. This course teaches you everything you need to know to get up and running with using Microsoft Project competently.

  • Some of the training topics covered include ...
  • Understanding Task Dependencies
    Understanding Collaboration Options
    Working With a Contact Resource
    More Highlight Filters
    Auto Scheduling Tasks
    Setting a Combined Project Start
    Creating Smaller Projects
    Changing the Layout
    Working With Fixed Unit Tasks
    Changing Data in a Combined Project
    Breaking Subproject Links
    Adding Fields Using Insert Column
    Checking Resource Usage
    Saving a Visual Report as a Template
    Understanding Working With
    Understanding Scheduling Icons
    Checking for Resource Links
    Understanding Resource Levelling
    Creating Dependencies in Task
    Running a Macro
    Highlighting Date Ranges

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Cannock
  • Course Outline
  • The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

    At the completion of this course you should be able to:

    Start Microsoft Project and identify how it works
    Explain some of the key concepts associated with project management
    Create a new project file in Project
    Enter tasks into a project file
    Create relationships between tasks in a project
    Add resources, including labour, materials and equipment to a project
    Understand and use resource assignment calculations
    Assign resources to tasks using a number of different methods
    Print various aspects of a project
    Obtain help for Project whenever you need it

  • Some of the training topics covered include ...
  • Creating a Simple Assignment
    Working With Gantt Charts
    Assignments
    Printing Sheet Views
    The Project Work Area
    Entering Task Durations
    Tasks and Resources
    Creating Dependencies
    Understanding How Help Works
    Understanding Work Contouring
    Previewing Before You Print
    Selecting a Printer
    Printing Resources for Tasks Getting Help
    Modifying the Standard Calendar
    Simple Resource Assignments
    Starting Project in Windows
    Working With Project Files
    Using Tell Me
    The Case Study Resources Printing
    Examining Task Information

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Microsoft Project 2016 - Level 2 is designed for existing users of Microsoft Project who wish to extend their skills and knowledge beyond the creation of simple projects.

    At the completion of this course you should be able to:

    Use various techniques for levelling over allocation of resources
    Assign material resources in a project
    Assign and track costs within a project
    Apply constraints and deadlines to tasks in a project
    Track the progress of a project
    Work more productively with project views
    Work with tables in Project
    Work with some of the features that allow you to control your data
    Format projects to make them more appealing and relevant
    Print data from Gantt Charts in a variety of ways and presentations

  • Some of the training topics covered include ...
  • Printing Specific Dates and Pages
    Editing Existing Filters
    Automatically Updating Tasks
    Applying a Different Cost Table
    Understanding Resource Levelling
    Tracking Actuals On A Gantt Chart
    Understanding Project Costs
    Adding Simple Custom Fields
    Creating Resource Problems
    Checking Work For Materials Costs
    Using Another Cost Table
    Formatting for Non-Working Time
    Assigning Variable Usage Material
    Understanding Constraints and
    Applying Filters
    Resource Levelling
    Assigning Material Costs
    Adding a Constraint
    Creating a Custom Filter
    Assigning Fixed Costs

  • See Training Course Details...


Microsoft Project 2016 Level 3

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Microsoft Project 2016 - Level 3 aims to take the learner to more advanced levels of Microsoft Project. It covers a diverse range of topics including working simultaneously on multiple projects, sharing resources between several projects, downsizing very large projects, using templates, and automating operations with VBA.

    At the completion of this course you should be able to:

    Create and work with several types of custom fields
    Create and work with WBS Codes
    Create a custom view with a custom filter, group and table
    Run and modify standard graphical reports as well as create your own custom reports
    Create and work with visual reports
    Work with and create project templates
    Work with and link multiple projects in Project
    Create shared resources for use amongst multiple projects
    Downsize large project files into more manageable entities
    Export project data to other applications
    Collaborate on projects with others using Skype for Business and SharePoint
    Create VBA macros to automate operations in a project file

  • Some of the training topics covered include ...
  • Exporting to Microsoft Excel
    Changing the X Axis Categories
    Saving a Project as a Template
    Copying a Gantt Chart Image
    Understanding Linked Projects
    Combining Projects
    Recording a Macro
    Specifying the Personal Templates
    Understanding Excel Visual Reports
    Creating a Read Only Subproject
    Testing a Formula
    Preparing for the Master Project
    Using Only the Combined Project File
    How Graphical Reports Work
    Inserting Task Links
    Setting Project Links
    Checking for Resource Links
    Creating a Custom Table for the View
    Custom Fields
    Exporting to Excel Using a Map
    Linking Subprojects to Resources

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • In this course participants learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.

  • Some of the training topics covered include ...
  • XMLA scripting (SQL Mgmt Studio) 
    Modeling source schemas -stars and snowflakes 
    Intermediate SSAS
    Creating Data Sources and Data Source Views 
    Rapidly changing dimensions / ROLAP dimensions 
    Best practices - health monitoring 
    Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 
    Using the Add Business Intelligence Wizards - write-back, semi-additive measures, time intelligence, account intelligence 
    Clustering - high availability 
    Using the MDX query editor in SQL Server Management Studio 
    Using SSAS in BIDS
    Customizing Aggregation Design - Processing Design 
    Understanding the development environment 
    Cube processing options 
    MS BI is comprehensive - more than Analysis Services on SQL Server 
    Intermediate MDX 
    Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions 
    Actions - regular, drill-through and reporting 
    Translations - cube metadata and currency localization 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day course will familiarise participants with SQL Server Integration Services 2005 (SSIS) tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

  • Some of the training topics covered include ...
  • Deployment options 
    SSIS Package Management
    The Lookup Transformation 
    Data Transformations 
    The File System Task 
    Scheduling packages with SQL Server Agent
    The Variables window 
    The SSIS menu 
    Extending SSIS through Custom Code
    Configuring Package Logging 
    Creating Database Maintenance Plans using SSMS 
    Data Flow: Error data flow 
    Control Flow Overview 
    The Conditional Split Transformation 
    Advanced Control Flow
    Control Flow: The OnError event handler 
    Scheduling and Executing Plans 
    The Sort Transformation 
    Using variables in data flow 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • In this two day course participants learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services.

  • Some of the training topics covered include ...
  • Intermediate SSAS
    Understand Writeback in Dimensions
    See how to Create Translations for Cubes and Dimensions
    Understand Mining Structure Processing
    View a Cube by using Excel
    Implement Proactive Caching
    Explore Clustering
    Understand Common MDX Functions and Tasks
    Understand Basic OLAP Modeling (star schema)
    Understand Measure (fact) and Cube Modeling
    Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
    Learn how to use the Business Intelligence Wizard
    Review Semi-Additive Measures in OLAP Cubes
    What Is Microsoft Business Intelligence?
    Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
    Cube Storage and Aggregation
    Understand the Cube Structure
    Implement Excel 2007 Pivot Tables and Charts

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

  • Some of the training topics covered include ...
  • Best Practices for Package Development and Design 
    Scripting and Custom Components
    Using Variables in Data Flow 
    Using Advanced Transformations 
    Understanding Variables 
    Best Practices
    Advanced Control Flow Overview 
    Exploring and Executing a Package Outside of BIDS 
    Data Flow Transformations 
    Installing a Package 
    Scripting in Control Flows with the Script Task 
    Deploying Packages 
    Extending Integration Services Capabilities through Code 
    Synchronous and Asynchronous Transformations 
    Managing Integration Services Packages 
    Going Beyond ETL
    Configurations 
    Using Variables in Control Flow 
    Variables and Configurations
    Using Integration Services Beyond ETL 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This intensive instructor-led course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.

  • Some of the training topics covered include ...
  • Handling Hierarchies.
    Analysis Services Tools.
    Measures and Measure Groups
    Relating with Relationships
    Utilizing Translations
    The Multidimensional Solution
    Understanding the Tabular Model
    Utilizing Attributes
    Browsing Perspectives and Translations
    Understand and utilize security.
    Dissecting with Dimensions
    Deploy a multidimensional model.
    Understanding Perspectives
    Querying the Solution and Understanding DAX
    Managing Measures
    Understanding the Multidimensional Model
    Processing Strategies
    Common Analysis Services Solutions
    Deploying

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This two day intensive course introduces SQL Server Integration Services using the SQL Server 2012 or 2014 versions. No prior knowledge of Integration Services is assumed.

  • Some of the training topics covered include ...
  • Overview of Containers
    Performing Joins with the Merge Transformation
    The SQL Server Integration Service
    Performing Joins with the Lookup Transformation
    Managing SQL with the SQL Tasks
    Understanding Packages
    Using Package Hierarchies: Parent Child
    Creating Dynamic Packages
    Coding the Script Task
    Understanding Variables
    Utilizing Sequences in a Container
    Understanding Deployment Strategies 
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Utilizing Container Loops Performing Joins
    Utilizing the Import/Export Wizard
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Using the Workflow Tasks
    Handling Errors Common SQL Server Integration Services Design Patterns
    SQL Server Integration Services Architecture
    Designing to Troubleshoot: Using Precedence Constraints
    Using Destinations and Understanding choices

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.

  • Some of the training topics covered include ...
  • Examining Security
    SQL Server 2016 Report Builder Graphics
    Introduction to SQL Server 2016 Report Builder
    Understanding Visualizations
    Filtering, Grouping, and Sorting
    Using Tables
    Exploring Matrix
    Mastering Data Region(s)
    Visualizing Your Company Report Templates
    Understanding Report Parts
    Understanding HTML5 and Textboxes
    SQL Server 2016 Report Builder Basic Reports
    Examining Maps
    Creating Subreports and Drillthrough Reports
    Examining Parameters
    Utilizing Lists
    Utilizing Dynamic Headers and Footers
    Exploring the Report Builder Interface
    Using the List Object to Combine Other Items
    Examining Management

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day course demonstrating how to use SQL Server Data Mining tools. The course introduces delegates to the DMX language and Microsoft graphic validation tools. The intention is to give participants the skills necessary to data mine their own organisations data sets.

  • Some of the training topics covered include ...
  • View and Save the Results of a Prediction Query
    Change the Discretization of a Column in a Mining Model
    Browse a Model Using the Microsoft Naive Bayes Viewer
    Browse a Model Using the Microsoft Time Series Viewer
    Microsoft Time Series
    Microsoft Neural Network
    Apply Prediction Functions to a Model
    Microsoft Decision Trees
    Training and Testing Data Sets
    Query the Parameters Used to Create a Mining Model
    Physical Architecture
    Topics include- SSAS Data Mining
    SystemGetCrossValidationResults
    Microsoft Sequence Clustering
    Column Distributions
    SSAS Data Mining Tools
    Logical Architecture
    Microsoft Clustering
    View or Change Modeling Flags
    Deploy a Data Mining Solution to Previous Versions of SQL Server

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.

  • Some of the training topics covered include ...
  • Ragged Hierarchies
    Database permissions
    Define a Regular Relationship and Regular Relationship Properties
    Use a Template to Create an Action Deployment
    Define Attribute Relationships
    Define Logical Relationships in a Data Source View
    Define a Fact Relationship and Fact Relationship Properties
    Read Definition permissions
    Move an Analysis Services Database
    Configure Analysis Services Project Properties
    Delete a Data Source View Dimensions
    Delete a Data Source
    Create a Dimension Using the Dimension Wizard
    Add or Remove Tables or Views in a Data Source View
    Create a Time Dimension by Generating a Time Table
    Work with Diagrams in Data Source View Designer
    Attach and Detach Analysis Services Databases
    Define a Referenced Relationship and Referenced Relationship Properties
    Error Configuration Roles and Permissions
    Defined Linked Measure Groups Partitions
    Deploy Model Solutions Using the Deployment Wizard

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) 2016 – 2017. The course is aimed at Data Analysts and SQL professionals.  No prior knowledge of SSAS is assumed.

  • Some of the training topics covered include ...
  • Row filter mappings
    Add sample data to DirectQuery models
    Change table, column
    Import Data
    Import data by using a native query
    DirectQuery Mode
    Process Tabular Model Partitions
    Bi-directional cross filters  Calculations
    Add a table Delete a Table
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Specify Mark as Date Table for use with Time Intelligence
    Enable DirectQuery mode in SSDT
    Version comparison
    Create a Calculated Column
    Add columns to a table
    Restore from Power Pivot
    Tabular model designer
    Data sources supported in SSAS tabular 2017
    Set the Data Type of a Column

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Cannock
  • Course Outline
  • This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.

  • Some of the training topics covered include ...
  • Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Databars, sparklines, indicators, gauges, and maps
    Sorting and grouping
    Drilldown and drill through Sharing Reporting Services Reports
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Configuring data access with report builder
    Add a drillthrough to a custom URL
    Implementing report filters and parameters Visualizsng Data with Report Services
    Extend reporting services functionality with external assemblies.
    Schedules
    Preparing data for mobile reports
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Data filters
    Work with expressions and embedded code.
    Reporting services components
    Mobile report publisher
    Publish a report to reporting services Working with Reporting Services Data
    Topics include Introduction to Reporting Services
    Reporting services tools Reporting Services Data Sources
    Use report services configuration manager to reconfigure SSRS servers.
    Overview of mobile reports

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Cannock
  • Course Outline
  • Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated dashboards and reports.

  • Some of the training topics covered include ...
  • Narrative View
    Adding Columns to a Request
    Viewing the Request Results
    Variable References
    Filters View
    Oracle BI Architecture
    Customizing the Table View
    Reusing Filters
    Launch BI Presentation Services
    Miscellaneous Tasks Building a Dashboard
    Basic Navigation Using A Dashboard
    Warehouse Models and Schemas
    Sections and Pages
    Understanding The Dashboard Interface
    Chart View
    Defining the Pivot View
    Understanding the Dashboard Structure
    Pdf and Print Control
    Managing Dashboard Objects Creating a Report
    Creating a Dashboard
    BI and Presentation Catalog Security

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Cannock
  • Course Outline
  • This three day course gives participants a sound understanding of working with Oracle PL/SQL. The courses assumes no prior programming knowledge and is hands on in character.

  • Some of the training topics covered include ...
  • Stored Procedures and Functions
    LOB Locators 
    Calling a Stored Procedure 
    Temporary LOBs 
    Oracle-Supplied Packages 
    PL/SQL Stored Program Compilation 
    Declaring and Opening Cursors 
    Creating Packages 
    Comments and Labels 
    Dependencies and Validation 
    Cursors 
    Structure of a Package 
    User-Defined Exceptions 
    Networking Packages 
    Creating a Stored Function 
    Other Supplied Packages
    The Package Interface and Implementation 
    Iterating Through Collections 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.

  • Some of the training topics covered include ...
  • Selecting from Multiple Tables 
    Using Oracle SQL*Plus 
    Joining Tables 
    Date Functions 
    Interactive SQL*Plus Scripts 
    Controlling Access to Your Tables 
    The UPDATE Statement 
    The INSERT Statement 
    The CASE...WHEN Expression 
    SQL Queries - Joins 
    Logical and Physical Storage Structures 
    Outer Joins 
    Other Database Objects 
    Views 
    String Functions 
    Scalar Functions 
    Tailoring Your SQL*Plus Environment 
    Subqueries 
    Nulls and DISTINCT 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course introducing PHP and equipping candidates with the skills necessary to build PHP driven dynamic web sites. Participants should have a sound knowledge of HTML.

  • Some of the training topics covered include ...
  • Basic PHP Syntax 
    Variable Types 
    Form Validation and Presentation Functions 
    Variables 
    Working with Associative Arrays 
    Reusing Code and Writing Functions 
    mysqli Methods and Properties 
    Inserting and Updating Records 
    flock() 
    Querying a Database 
    Regular Expression Tester 
    The php.ini File 
    Using PEAR DB 
    PHP Statements and Whitespace
    Inserting Records 
    fopen() 
    Escape Character ( \ ) 
    Code Organization 
    Initializing Associative Arrays 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Equations Distributing presentations
    Slide masters
    Media clips
    Working with hyperlinks
    Creating presentations
    Custom slide shows
    The PowerPoint window
    Formatting paragraphs Using drawing objects
    Customizing SmartArt graphics
    Saving presentations
    Building slides from Word outlines
    Application settings
    Modifying objects
    Using text in objects Working with graphics
    Slide shows Proofing and delivering presentations
    Transitions and timings
    Custom themes Using graphics and multimedia
    Speaker notes
    Using slides from other presentations Formatting slides
    WordArt Pictures

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Formatting shapes
    Application settings
    Equations Integrating Microsoft Office files
    Working with charts
    Applying content to shapes Graphics
    Printing presentations
    Formatting text and lists
    Modifying graphics
    Photo albums Customizing slide elements
    Embedding and linking content Finalizing and distributing presentations
    Working with SmartArt graphics
    SmartArt Preparing and printing presentations
    Editing efficiently Working with shapes
    Applying content from a Word outline
    Slide masters and transitions
    Custom slide shows Graphics and media
    Transitions and timings
    Reviewing and finishing

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Microsoft PowerPoint 2016 - Advanced Level is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.

  • Some of the training topics covered include ...
  • Applying Slide Transitions to the
    Understanding Pictures
    Inserting Action Buttons
    Applying a Picture Style
    Inserting an Image
    Understanding Charts
    Adjusting Row Heights
    Rotating and Flipping Images
    Sending a Presentation via Email
    Setting a Custom Templates Location
    Sharing Presentations
    Modifying Slide Layouts
    Inserting an Online Video
    Inserting a Chart Using the Ribbon
    Template
    Slide Masters
    Understanding Action Buttons
    Animations and Transitions

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Cannock
  • Course Outline
  • The skills and knowledge acquired in Microsoft PowerPoint 2016  Basic Level are sufficient to be able to create real-world slide shows. You will learn how to create, print and publish presentations.

     

  • Some of the training topics covered include ...
  • Resizing SmartArt
    Applying Paragraph Formatting
    Converting Text to SmartArt
    SmartArt
    Customising the Status Bar
    Inserting and Formatting Text
    Creating a Hyperlink to Another
    Changing the SmartArt Layout
    The Open Place
    Understanding the Status Bar
    Inserting a Title and Content Slide
    Changing Presentation Views
    The Save As Place
    Applying Slide Transitions
    Getting Help
    Inserting a Chart
    Using the Ribbon
    Printing Slides
    Inserting a Picture With Caption Slide
    Using Shortcut Menus

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Mail merge and catalog merge
    Master pages
    Web site publishing
    Basic design options
    Layout and design techniques
    Catalog merge
    Multi-page publications
    Data sources for the recipient list
    Table basics
    Customizing the Ribbon
    Modifying form properties
    Publication output
    Finalizing and publishing a site
    Custom colors
    Multi-page layouts

  • See Training Course Details...


Publisher 2013

  • 1 day course
  • Location: Cannock
  • Course Outline
  • The skills and knowledge acquired in Microsoft Publisher 2013 are sufficient to be able to create publications such as flyers, newsletters and labels.

  • Some of the training topics covered include ...
  • Saving A New Publication On Your Computer
    Aligning Text
    Naming Pages
    Creating Envelopes
    Previewing A Publication
    Applying A Text Style
    The Open Place
    Creating Additional Master Pages
    Inserting Calendars
    Aligning Shapes
    Creating A Mail Merge Publication
    Grouping Shapes
    Adjusting Rows And Columns
    Inserting Online Pictures
    Zooming And Panning
    Filtering Data
    Selecting Text
    Inserting Page Numbers
    Resizing Shapes
    Navigating The Help Window
    Inserting Advertisements Working With Shapes

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Cannock
  • Course Outline
  • The skills and knowledge acquired in Microsoft Publisher 2016 are sufficient to be able to create publications such as flyers, newsletters and labels.

  • Some of the training topics covered include ...
  • Creating an Image Background
    Inserting Page Parts
    Adjusting Rows and Columns
    Using Colour Schemes
    Inserting Online Pictures
    Inserting Headers
    Master Pages
    Understanding the Status Bar
    Working With a Publication
    Working With Layouts
    Catalogue Merge
    The Save As Dialog Box
    Understanding Page Sizes
    Cropping Pictures
    Inserting Calendars
    Creating a Text Box
    Saving for a Commercial Printer
    Saving and Sharing
    Safely Closing a Publication

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Cannock
  • Course Outline
  • SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating  data,  joins,  subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.

  • Some of the training topics covered include ...
  • Adding and Dropping Columns
    Creating Tables
    Concatenation
    Whitespace and Semi-colons
    The IN Operator 
    Foreign Keys   
    Tables 
    Aggregate Functions
    Aliases
    Sorting By Column Position
    Popular Databases  
    Primary Keys
    Checking for NULL 
    Primary Keys
    Creating Views
    Grouping and Aggregating Data    
    Dropping Views
    Foreign Keys

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.

  • Some of the training topics covered include ...
  • Adding Data Fields to a Table Data Region
    Report Formatting Toolbar
    The Reporting Services 2005 Report Wizard
    Adding Textboxes
    Grouping Data
    Sorting
    Run the Sample Reports
    Current Classroom Folder Structure
    Design Area
    Understanding What Just Happened
    Perspectives
    Displaying Parameters in a Report
    Attributes
    Sorting
    Navigation
    Visual Studio 2005 and Development Studio
    Reporting Services 2005 Windows
    Launching Report Builder
    Understanding Report Builder
    SQL Server 2005 Reporting Services Features

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Cannock
  • Course Outline
  • A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.

  • Some of the training topics covered include ...
  • Learn how to work with rich text to produce mail merge style reports 
    Learn how to create data-driven report subscriptions 
    Investigate how to call a custom assembly from a report 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Investigate Reporting Services charts 
    Discover how to improve parameter prompts using drop-down list parameters 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Understand how to plan and configure for deployment 
    Calculation and Formatting
    Learn how to create custom functions using the Code window 
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Discover the many application programming interfaces of Reporting Services 
    Discover how to create standard report subscriptions 
    Snapshots and Subscriptions
    Learn how to solve common parameter issues 
    Explore the basic architecture of SQL Server Reporting Services 
    Find out how to display parameter values in report headers 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Ad-Hoc Reporting with Report Builder 2.0

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Cannock
  • Course Outline
  • Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.

    The course requires a working knowledge of SQL.

  • Some of the training topics covered include ...
  • Create Package Templates Implementing Data Flow
    Secure Databases Working with MDS and Windows Azure
    Overview of Data Warehouse Components
    Track Changed Data Managing Data Flow
    Add Data Flow Components to a Data Flow Task
    Create Fact Tables
    Create Expressions with Variables
    Perform Transformation Tasks
    Execute Packages from Different Control Flow Working with Dynamic Variables
    Troubleshoot Package Failures Deploying Packages
    Configure MDS
    Install Integration Services Working with Integration Services
    Examine Data Warehousing Concepts
    Add Script Tasks and Script Components to an SSIS Package
    Work with Windows Azure
    Overview of Data Warehouses
    Secure Packages
    Add Packages to an SSIS Project Managing Control Flow
    Deploy SSIS Packages
    Debug Package Execution Components

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Cannock
  • Course Outline
  • Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.

  • Some of the training topics covered include ...
  • Report Designer and Data Windows Configuring Report Projects
    Create a Tabular Report  Using the Tablix Report Type
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    No Data Rows
    Using Report Parts Shared Data Sets
    Rein in the Length of a Text Field
    Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Create a Drop-Down List Parameter
    Report Builder Installation and Execution Options
    Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Create a  Parameterised Report
    Using Charts in a Report
    Reordering Report Parameters Using Drop-Down List Parameters
    Service Architecture  Report Building Tools
    Variable Collection
    Building a List Report Configuring Tablix  Properties and Groups
    Create a Shared Data Source and Two Data Sets
    Using the Expression Editor  Using Built-in Report Operators and Functions
    User Collection
    Formatting Text Boxes from the Toolbars

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Cannock
  • Course Outline
  • In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database.  You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server 2012 error handling features.

    The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.

    The course uses a SQL Server 2012 database but is suitable for users of earlier SQL Server versions. For those interested in external accreditation the course materials are mapped against the Microsoft SQL Server 2012 Database Querying (70-461) exam syllabus.

  • Some of the training topics covered include ...
  • Update Data
    Overview of T-SQL
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Work with PIVOT and UNPIVOT
    Work with Window Functions
    Group and Aggregate Data Programming in T-SQL
    Combine Data Using Simple Joins
    Assign Aliases Using Queries
    Getting Started with SQL Server 2012
    Manage Transactions Querying SQL Server System Metadata
    Delete Data
    Configure Indexes
    Configure User-Defined Functions (UDF)
    Work with Predicates
    Create Queries Using Built-in Functions
    Manage Query Plans
    Implement Error Handling
    Work with SSMS Working with T-SQL
    Work with Binary Data Types
    Work with Date and Time Data Types
    Modifying Data

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Custom stencils
    Formatting text blocks
    Visio basics
    Creating shapes for a stencil
    Integration with Microsoft Outlook
    Themes and styles
    Working with background pages
    Formatting drawings
    Project management diagrams
    Special drawing operations
    Database model diagrams
    Advanced Layout and connection techniques
    Organization charts
    Editing objects
    Manipulating stencils
    Flowcharts
    Software and database diagrams
    Basic diagrams
    Brainstorming diagrams

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Flowcharts
    Creating a basic diagram
    Working with background pages
    Drawing scales
    Documenting software systems
    Compound lines
    The Visio 2010 interface
    Getting started
    Block, tree, and onion diagrams
    Rack diagrams
    Windows, stencils, and objects Drawing tools
    Network diagrams
    Custom themes
    Formatting shapes and lines Working with pages
    Displaying shape dimensions Custom themes and templates
    Editing objects Basic diagrams
    Special drawing operations
    Database model diagrams
    Custom templates Custom shapes and stencils
    Formatting text

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Getting started
    Software and database diagrams
    Working with text
    Drawing scales
    Integration with Microsoft Outlook
     Shape behaviors
    The start page
    Displaying shape dimensions
    Basic shapes and lines
    Shape properties
    Custom templates
    Formatting drawings
    Editing objects
    Web site maps
    Rack diagrams
    Presenting diagrams in Visio and HTML
    Business diagrams and Web site mapping

  • See Training Course Details...


Word 2010 Advanced

  • 1 day course
  • Location: Cannock
  • Course Outline
  • This course aims to provide the skill and knowledge to create more intricate and complex documents by using Microsoft Word at a more advanced level.

  • Some of the training topics covered include ...
  • Merging Table Cells
    Interactive Fields
    Indexing
    Building Blocks
    Inserting Subdocuments
    Using A Custom Template
    Electronic Forms
    Creating Subdocuments
    Deleting Records
    Understanding Indexing
    Applying Numbering
    AutoText
    Understanding Building Blocks
    Importing And Embedding Excel Data
    Importing
    Saving A Custom Theme
    Setting Field Properties
    The Field Dialog Box
    Adding Records
    Inserting A Preformatted Text Box

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Cannock
  • Course Outline
  • This course focuses on basic document production using Microsoft Word 2010 and is designed to give the learner a sound understanding of how documents are created, formatted, and printed.

  • Some of the training topics covered include ...
  • Understanding Shapes
    Counting Words Working With Text
    The Word Screen
    Arranging All
    Previewing The Merged Documents
    Template
    Quick Printing
    Changing Paper Sizing
    Inserting A Picture
    Previewing Your Document
    Keyboard
    Formatting
    Using Ribbon KeyTips
    Understanding Tables
    Understanding Font Formatting
    Creating Documents In Word
    Inserting A Blank Footer
    Accessing The Help Window
    Deleting WordArt Getting Help
    Editing Text In Insert Mode

  • See Training Course Details...


Word 2013 Advanced

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Tables of contents and captions
    Creating diagrams
    Mailing labels and envelopes Illustrations
    Form letters
    Working with columns
    Indexes, bibliographies, and footnotes Document sharing
    Web pages Working in Word efficiently
    Advanced document formatting
    Mail Merge
    Document design Document References
    Macros  
    Creating forms
    Document properties
    Data sources for the recipient list
    Finalizing documents Document interactivity
    Formatting text graphically
    Creating and formatting sections
    Tracking changes
    Customizing the ribbon
    Inserting objects and charts

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Some of the training topics covered include ...
  • Working with graphics Styles and outlines
    Character formatting
    Working with styles
    Paragraph spacing and indents Tables
    Examining formatting
    Table data Page layout
    Graphics
    Tab settings
    Printing and exporting documents
    Working with table content
    The Word window
    Headers and footers
    The Undo and Redo commands
    Adding graphics and clip art
    Creating tables
    Document navigation Editing text
    Page setup
    Paragraph formatting
    Working with outlines Proofing, printing, and exporting
    Cut, copy, and paste
    Find and replace Formatting text

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Cannock
  • Course Outline
  • This hands-on beginner’s course aims to give the learner a sound grounding in the use of Microsoft Word 2016 to create everyday documents required either at work or at home. Particular emphasis is placed on developing accurate and well-designed documents. The course begins by showing the learner how to navigate around Microsoft Word 2016. It then quickly gets the learner to create a new document before moving onto features such as text manipulation and enhancement, creating and using tabs and tables, embellishing documents with clip art and pictures, creating multiple documents through merging and printing documents

  • Some of the training topics covered include ...
  • ISBN: 978-1-925349-18-4
    Using Undo
    Adding Custom Borders
    Changing Page Orientation
    Cutting and Copying
    Understanding Cutting and Copying
    The Open Dialog Box
    Printing a Help Topic
    Changing Text Colour
    Showing Paragraph Marks
    Selecting in Tables Using the Ribbon
    Product Information
    Changing the Picture
    Outdenting Paragraphs
    Making Text Bold
    Cutting and Pasting
    Page Breaks
    Finding Words
    Using Tell Me
    Numbering Existing Paragraphs
    Setting Custom Margins

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Cannock
  • Course Outline
  • This course aims to enhance existing skills by covering more specific documentation creation aspects such as working with multiple documents, formatting tables, tabs, lists, merging, section breaks, templates and more.

  • Some of the training topics covered include ...
  • Understanding Styles
    Applying a Picture Fill to a Shape
    Setting Display Options
    Resizing a Text Box
    Attaching a Template to a Document
    Synchronised Scrolling
    Adding Records
    Keeping Lines Together
    Applying Picture Styles to Images
    Inserting the Date
    Applying Character Styles
    Typing the Letter
    Applying an if Then Else Rule
    Tips for Developing Templates
    Applying Hyphenation to Text
    Changing Shape Outlines
    Enhancing Shapes
    Multiple Documents
    Revealing Formatting

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Cannock
  • Course Outline
  • Microsoft Word 2016 - Level 3 is designed for Microsoft Word users who are keen to extend their understanding and knowledge of the software beyond basic document creation so that they can create and work with features such as SmartArt, indexes, master documents, interactive fields and much more.

  • Some of the training topics covered include ...
  • Opening and Editing a PDF in Word
    Converting Footnotes and Endnotes
    Adding Words to the Custom
    Creating a Master Document
    Showing Revisions Inline and in
    Using AutoCorrect
    Locking and Unlocking Fields
    Removing a Custom Dictionary
    Understanding Interactive Fields
    Formatting a Table of Contents
    Understanding Subdocuments
    Setting a Different Proofing Language
    Working With a Read Only Document
    Resizing SmartArt
    Document Commenting
    Understanding Building Blocks
    Opening Shared Documents

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730