Enable Technology

SHROPSHIRE TRAINING COURSES 

TRAINING COURSES SHROPSHIRE




Adobe Dreamweaver CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Repairing Photos That Needed Fill Flash
    Applying a Glow Effect
    Understanding Assets
    Understanding the Assets Panel
    Understanding the CSS Designer Panel
    Understanding the Position Property
    Flipping and Rotating Images
    Inserting an Image
    Understanding the Bridge Workspace
    Creating a Web Photo Gallery
    Adobe Photoshop Mobile Applications
    Fundamentals of CSS
    Creating a Custom Workspace
    Using CSS Inspect to Check Page Layout
    The Creative Profile Home Page
    Sharpening Images With Smart Sharpen
    Clearing Floats
    Preferences Dialog Box
    Adobe Mobile Apps
    Creating Preset 3D Shapes

  • See Training Course Details...


Adobe Illustrator CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Blending Shapes
    Creating Lines and Spirals
    Preparing the Workspace
    Understanding Clipping Masks
    The Status Bar
    Locking and Unlocking Layers
    Creating Columns of Text
    The Brushes Panel
    Editing a Pattern
    Selecting With the Magic Wand Tool
    Viewing a File in Creative Cloud
    Creating Layers and Sublayers
    Creating Different Types of Patterns
    Drawing Objects With Curved Paths
    Transforming Path Type Objects
    Moving Objects
    Adding People to Your Library
    Understanding Save and Export Options

  • See Training Course Details...


Adobe InDesign CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Creating an Outline
    Inserting Pages
    Using Selection Tools
    The Adobe Website
    Applying a Stroke Colour
    Previewing Liquid Layout
    Understanding Graphic File Formats
    Understanding InDesign
    Understanding Indexes
    Fitting Graphics
    Placing Graphics in a Document
    Navigating Pages
    Changing Font Size and Leading
    Editing Text With the Story Editor Preparing for Printing
    Running a Preflight Check
    Applying Rules to Other Pages
    Creating Frames and Shapes
    Placing InLine Graphics
    Formatting Cells
    Applying Space Before and After Paragraphs
    Opening an Existing Document

  • See Training Course Details...


Adobe Photoshop CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • The Creative Cloud Library and Mobile Apps
    Changing the Font Family
    Sharpening Images With Smart Sharpen
    Understanding the Crop Tool Options Bar
    Making Basic Changes in Camera Raw
    Resetting the Tools Panel
    Organising Images in Bridge
    Saving a Selection
    Straightening Images Using the Ruler Tool
    Accessing Online Tutorials The Adobe Account
    Editing an Embedded Smart Object
    Understanding Blending Modes
    Understanding the Print Dialog Box
    Selecting and Editing Shape Layers
    Getting to Know Adobe Photoshop
    Working With Tabbed Documents
    Introduction to Camera Raw
    Understanding Guides
    Understanding Vector Based Text
    Opening Images in Camera Raw

  • See Training Course Details...


ASP.NET Core MVC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Dynamic Output ASP.NET MVC Architecture
    Unit Testing Getting Started with ASP.NET Core MVC
    What Is Windows Azure?
    Registering Routes
    Rendering Views
    Validation Attributes Routing
    NuGet Package Manager
    ASP.NET Core MVC
    Review of ASP.NET Web Forms
    The View in ASP.NET MVC
    Using ViewBag
    Filters The View
    Configuring for ASP.NET Core MVC
    Retrieving Data from a Request
    Using Dynamic Objects
    Serving Static Files
    Parameters in Routing
    ASP.NET Web API Clients ASP.NET Core and Azure
    Using Visual Studio
    Attribute Routing ASP.NET Core Web API
    Razor View Engine

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Client-Side and Advanced Debugging 
    The AdRotator Control 
    Debugging .NET Framework Source Code
    Configuration 
    Custom Data Visualizers 
    Web Development Using Visual Studio
    Connecting to Data 
    Storing Objects in Session State 
    Managing State 
    Configuring Session State 
    ASP.NET Web Applications 
    Displaying and Editing Middle-Tier Data using the ObjectDataSource Control 
    ASP.NET 2.0 Themes 
    LINQ 
    Data Binding in ASP.NET 
    Client-side Code Debugging in ASP.NET 
    Reading and Write Data Using the SqlDataSource Control 

  • See Training Course Details...


ASP.NET using VB.NET

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Using the Web Site Administration Tool 
    A Review of Classic ASP 
    Creating a Consistent Web Site 
    Using the Simple Validators 
    Server-Side Code Debugging in ASP.NET 
    CSS 
    Debugging Client-Side JavaScript 
    Configuration Overview 
    Application State 
    ASP.NET 2.0 Themes 
    ASP.NET Web Site Navigation 
    Working with Data 
    Using the Site Navigation API 
    Choosing an ADO.NET Provider 
    Writing Code to Interact with Membership and Roles 
    LINQ to DataSets 
    Custom Data Visualizers 

  • See Training Course Details...


Crystal Reports 2008

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Format Painter 
    Customizing the Cross-Tab Format
    Customizing Group Sort Order
    Charting Cross-Tabs
    Grouping Data in Date/Time Intervals 
    Using Group Selection toFilter the Records in the Report
    Calculating Percentages 
    Using the Section Expert to Work with Sections
    Creating a Dynamic Value List for Parameter Values
    The Fields Dialog Box 
    Selecting and Sizing Objects 
    Grouping and Sorting Data 
    When and Why to Group Records 
    The Grouping Dialog Box 
    Modifying Individual Objects in the 
    Using a Parameter to set N in a Top N or 
    What are Report Alerts
    Creating Boolean (True/False) Formulas 
    Grouping on a Formula Field
    Browsing Field Data 

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Working with Text Objects 
    Expert 
    Using the Running Totals Feature
    Parameter Fields Overview
    Selecting Specific Records from the Database 
    Editing and Formatting Charts 
    Working with the Page Commands 
    Suppressing Rows, Columns or Totals
    Exporting to Windows Applications 
    CurrentFieldValue 
    Formatting Part or All of an Object 
    Creating a Dynamic Value List for Parameter Values
    Exploring the Toolbars 
    Conditionally Formatting Fields 
    Variable Scope
    Parameter Field Considerations
    Charting Cross-Tabs
    What are Report Alerts
    Filter Types of the Select Expert 

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Using the Formula Workshop
    Using the Sort Control
    Displaying Parameter Fields
    Choosing a Data Source
    Quick Formatting with the Template Expert
    Inserting Graphics
    Conditionally Formatting Fields Creating Summary Reports and Charts
    Using a Parameter to Select Records
    Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
    Creating a Dynamic Value List
    Creating Boolean (True/False) Formulas
    Customize Group Name Field
    Refreshing the Data
    Summarizing Groups
    Conditional Running Totals Prompting with Parameters
    Using the Status Bar
    Using the Chart Options
    Previewing the Report
    Parameter Fields Overview
    Understanding Crystal Formula Syntax
    Charting Cross Tabs

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Customizing Group Sort Order
    Using Evaluation Time Functions
    Refreshing the Data
    Calculating Percentages
    The Grouping Dialog Box
    Understanding Export Formats and Destinations
    Case Sensitive vs. Case Insensitive
    Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
    HTML Preview
    Sorting Records within a Group
    The Template Dialog Box Power Formatting
    Formatting Charts
    Using Parameters in Conditional Formatting
    Understanding Running Totals
    Record Selection Formula Templates Grouping and Sorting Data
    Conditional Running Totals Prompting with Parameters
    Unlinked versus Linked Subreports
    Modifying Groups
    Separating Statements in Complex Formulas
    Autosaving the Report
    Modifying Individual Objects in the Chart

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Shropshire
  • 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 On-Demand Subreports
    Customizing Group Sort Order
    Understanding Export Formats and Destinations
    Autosaving the Report
    Using a Field Name to Customize the Group Name
    The Template Dialog Box Review of Planning a Report
    Adding Parameter Values to Text Objects
    Sorting with a Parameter
    Creating Text Objects
    The Data Dialog Box
    Creative Usage for Report Alerts Report Templates
    Customizing the Group Name Field
    Charting Cross-Tabs
    Pre-Pass#1
    Conditional Running Totals Prompting with Parameters
    Using a Formula to Customize the Group Name Field
    Template Considerations
    The Main Components of the Design Window
    Filtering Data with the Select Expert
    Using the Section Expert to Work with Sections
    Linking a Subreport

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Structural Pseudo-Classes Fonts and Text Effects
    Backgrounds
    The Target Pseudo-Class
    background-origin, and background-size Borders and Box Effects
    Negation Pseudo-Class
    Image Borders
    Strategies
    Introducing CSS3
    Transitions and Transforms
    Styling Video
    HTML5 Selectors and Pseudo Classes
    Box Shadow Transitions, Transforms, and Animations
    Responsive Images and the viewport Metatag
    Text Shadow
    Attribute Selectors
    Rounded Corners
    Word Wrapping Colors, Gradients, Background Images, and Masks

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Topics include:
    Microsoft Linear Regression Algorithm
    Data Mining Tab
    Microsoft Neural Network Algorithm
    Creating Reports Using Reporting Services
    The User Interface
    Data Preparation
    Connection
    Microsoft Time Series Algorithm
    Data Mining Concepts
    Types of Data Mining Algorithms
    Named Calculation
    The Mining Model Prediction Tab
    Microsoft Decision Trees Algorithm
    Microsoft Logistic Regression Algorithm
    Microsoft Association Algorithm
    Compare Mining Structures
    Visio Data Mining Add-In  

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Flexible Images and Other Media
    The Case for Flexible
    Supported Platforms
    A Simple Example
    Using the Accelerometer
    Browser and Device Support
    Designing for Mobile Devices
    Controlling the Video through JavaScript
    Hiding Browser UI
    Swiping to Change Pages
    Integrating with the Home Screen
    Flexible Images and Other Media
    Optimizing for Mobile
    PhoneGap
    Local Storage Example
    Flexible Background Images
    Accessing Camera, Contacts, Calendar, and More - But Not Yet
    Consolidating the Web with Native Extensions
    A First Look at Foundation

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Merging Scenarios PivotTables
    Creating Scenarios
    Understanding Data Protection
    Understanding Scenarios
    Importing Tab Delimited Text
    Creating a Default Scenario
    Understanding Excel Options
    Circling Invalid Data
    Grouping by Columns Summarising and Subtotalling
    Creating Subtotals
    Enabling Tracked Changes
    Creating a Manual Group
    Sharing Workbooks via OneDrive
    Understanding Excel Macros
    Setting Formula Options
    Setting Macro Security
    Using the DMAX Function
    Consolidating With Identical Layouts
    Creating an Error Message
    Understanding Text File Formats
    Running a Recorded Macro

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Setting Precise Columns Widths
    Opening an Existing Workbook
    Selecting Non Contiguous Ranges
    Summing Non-Contiguous Ranges
    Applying and Using a Filter
    Editing Formulas
    Understanding Lists
    Understanding Font Formatting
    Italicising Text
    Typing Formulas
    Navigating Using the Keyboard
    Formatting as Dates
    Understanding the Charting Process
    Other Sources of Assistance  
    Using Google to Get Help
    Typing Text
    Understanding Number Formatting
    Understanding Moving in Excel
    Creating Mixed References Font Formatting
    Printing an Entire Workbook
    Copying From One Range to Another Filling Data

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Working With Data Bars
    Changing Margins by Dragging
    Creating Descriptive Custom Formats
    Understanding Borders
    Inserting Page Breaks
    Filling Using Options
    Key Worksheet Functions
    Copying a Worksheet
    Drawing a Border Grid
    Colouring the Chart Background
    Using Names to Select Ranges
    Changing WordArt Fill
    Formatting Calculated Time
    The TODAY Function
    Removing Duplicates
    Working With Table Styles
    Creating a Table From Scratch
    Creating a Custom Fill List
    Setting Custom Margins
    Editing Sparklines Goal Seeking

  • See Training Course Details...


Excel Power Pivot

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

  • Some of the training topics covered include ...
  • Power View
    Transforming Data
    Adding Slicers Get & Transform
    Understanding Relational Data
    Working With Location Fields
    Power Map
    Understanding Power View
    Managing Data Columns
    Creating a Concatenated Field
    Creating a Timeline
    Saving and Sharing Queries
    Changing a Power Pivot View
    Understanding Power Map
    Working With Power View Fields
    Adding Titles and Images
    Understanding Get & Transform
    Adding a Data Column
    Using Calculated Fields
    Reducing Data Rows
    Updating a Power View Report

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Working with UserForm Properties, Events, and Methods
    Getting Started
    Introducing Visual Basic for Applications
    Using Input Boxes
    Assigning a Macro to the Quick Access Toolbar
    Working with the Label Control
    Handling Errors
    Working with Forms and Controls
    Using Visual Basic Help
    Using Message Boxes
    Understanding the Err Object
    Understanding Control-of-Flow Structures
    Using Intrinsic Functions
    Understanding Controls
    Working with Inline Error Handling
    Understanding Data Types
    Navigating the Excel Object Hierarchy
    Naming Procedures
    Working with the Command Button Control
    Working with the Combo Box Control
    Using the Select Case...End Select Structure

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • What is XML 
    Loops and Conditional Logic 
    Using the MouseEvent 
    Making the Stage a Class 
    XML with EX 
    Loading External Images 
    ActionScript Event Types 
    Demonstration -: Using EX Operators 
    Getting Started with Coding 
    Using Functions 
    Dynamically Adding Symbols to the Stage 
    Using TextField Properties 
    Static Methods and Properties 
    The ActionScript Class Library 
    Using a MovieClip and Button's Properties 
    Getting a Date with ActionScript 
    Creating Visual Classes Through Inheritance 
    Introducing Object Oriented Programming 
    Controlling the SpaceShip 
    Converting Data Types and Operators 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Method Overloading In Google Apps Script
    Native And Host Objects
    Extracting Useful Information About The Spreadsheet
    Displaying Spreadsheet Values In A Web App
    The Sheet Object
    JavaScript Scripting
    Methods Of Folder And File Objects
    Transferring Values Between JavaScript Arrays And Ranges
    Using List Boxes Google Drive, Folders, Files and Permissions
    The Spreadsheet Object
    Creating A Web App
    Practical Examples Using Spreadsheet And Sheet Objects The Range Object
    Calendars Web Apps With Html Service
    Building A Data Entry Form
    Creating And Removing Files And Folders
    Adding Users Building Simple Graphical Interfaces
    Connecting To The MySQL Database
    The Range offset() Method
    Introducing JavaScript Functions
    Writing Database Records To A Google Spreadsheet
    Layout and Panels

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Id and Name Attributes
    Adding a Caption
    Creating Tables
    Media Types and Units of Measurement
    Start Attribute
    Inline Styles
    Targeting New Windows
    Class Selectors
    Blocks and Inline Elements
    Inserting Images
    Password Fields
    Closing Tags
    Picas (pc)
    Benefits of Cascading Style Sheets
    Making Images Accessible
    Formatting Elements
    Absolute Paths
    ID Selectors
    The Tag
    HTML Elements
    Grouping

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • The HTML5 Spec(s)
    Additional Changes
    The section Tag
    The Path Drawing Process
    HTML5 - Background
    The New More Flexible Approach of HTML5 - Paving the Cowpaths
    New Form Elements
    The article Tag
    Getting and Creating Audio Files
    Practice
    datalist
    The HTML5 Way
    Browser Support
    HTML5 Web Storage
    Laying out a Page with HTML 4 - the "old" way
    HTML5 Forms
    drawImage() - Sprites
    Text Properties
    Offline Application API
    Creating and Converting Video Files

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Shropshire
  • 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
    Conditionals
    Number(object)
    A Loosely-typed Language
    Conditionals and Loops
    Built-in Functions
    String(object)
    typeof Operator
    for Loop Syntax
    while Loop Syntax
    The HTML DOM
    Built-in Functions vs Methods
    The this Object
    Variables, Arrays and Operators
    Focus, Blur, and Change Events
    ParseFloat() and parseInt()
    Validating a Registration Form
    Returning Values from Functions
    JavaScript Objects, Methods and Properties

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Conditional Code
    Logical Operators
    Dimensions
    Basic Operators
    Getting RequireJS
    Refining and Filtering Selections
    Feature and Browser Detection
    Use Stylesheets for Changing CSS on Many Elements
    Effects-
    How to Create a Basic Plugin
    Operations on Numbers and Strings
    Getters and Setters
    jQuery.fx.speeds
    Avoiding Conflicts with Other Libraries
    Keep Things DRY
    Choosing Selectors
    Ajax and Firebug
    jQuery Core-
    Comparison Operators

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Sending Emails
    Levels of Support
    Video The Theme Framework
    Creating Your Own Plugin
    Sliders
    Virtual Integration with the Phone
    Basic Page Template
    What Is jQuery Mobile?
    Ajax-driven Page Navigation
    Using Others' Plugins
    Progressive Enhancement
    Making Calls
    Page Transitions
    Dialogs Widgets and UI
    ThemeRoller
    Overview
    PhoneGap
    Buttons and Linking Pages

  • See Training Course Details...


Microsoft Access 2007

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Charts in reports PivotTables and PivotCharts
    Attaching SQL queries to controls Advanced queries
    Calculated fields
    Adding calculated values
    Exporting objects
    Adding unbound controls
    Creating forms
    Creating and using queries
    Database concepts
    Adding unbound controls
    Setting field properties
    PivotTables
    Organizing records Data entry rules
    Creating parameter queries
    Modifying PivotTables
    Labels Charts
    Advanced form types Reports and printing
    Creating tables Fields and records
    Database normalization
    Printing
    Planning and designing databases

  • See Training Course Details...


Microsoft Access 2010

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Complex queries
    Customized headers and footers
    Table relationships
    Database concepts
    Calculated values
    Creating lookup fields
    Organizing records Data entry rules
    Exploring tables
    Linking Access objects
    Creating and using queries
    Charts in forms
    Exploring the Access environment
     Charts in reports PivotTables and PivotCharts
    Protecting databases
    Setting options and properties
    Modifying query results and queries
    Changing the design of a table
    Advanced form types Reports and printing
    Using action queries Macros
    Setting validation rules Basic queries
    Using Design view

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Performing operations in queries Using forms
    Exporting objects
    Creating AutoKeys and AutoExec macros
    Setting options and properties  
    Creating tables Fields and records
    Using hyperlink fields Database management
    Creating macros that require user input
    Subdatasheets Complex queries
    Modifying query results and queries
    Finding and editing records
    Attaching SQL queries to controls Advanced queries
    Table relationships
    Linking Access objects
    Referential integrity Related tables
    Using Design view
    Sorting and filtering records Working with reports
    Using calculated fields
    Working with input masks
    Using action queries  Macros
    Creating macros for data transfer Importing, exporting, and linking objects
    SQL and Access

  • See Training Course Details...


Microsoft Access 2016

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Adding Records to a Table
    Setting Table Relationships
    Creating and Using Reports
    Creating and Using Forms
    Getting to Know Access 2016
    Sorting and Filtering
    Importing and Exporting Records
    Relational Database Design
    Database Wellness
    Creating a Lookup Database
    Creating a Relational Database
    Aggregation Queries
    Macro Techniques
    Querying Techniques
    Macros on Forms
    DIY Forms
    Parameter Queries
    Working With Records
    Formatting Tables
    Using a Navigation Form
    Modifying Table Structures

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Shropshire
  • 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 Errors
    Understanding Objects
    Using Break Mode during Run Mode
    Controlling Program Execution
    Understanding VBA's Error Trapping Options
    Understanding Control-of-Flow Structures
    Debugging Code
    Using the With Statement
    Naming Procedures
    Declaring Variables
    Understanding the Order of Events
    Using the Immediate Window to Call Procedures
    Why Program in Access?
    Using Visual Basic Help
    Organizing Code and Procedures
    Specifying a Recordset Cursor Location - Optional
    Working with Recordsets
    Using the If...End If Decision Structures
    Stepping through Code

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Understand the M interface.
    Course topics include- INTRODUCTION TO POWER QUERY
    Appending Operations
    Performing Merges
    Transforming Data
    Using PivotTables CONNECTING TO DATABASES
    Understanding the Issues
    Working with Folders and Files
    Combining Worksheets
    Loading into Power BI Desktop
    Loading into Excel
    Importing Data
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Loading Data
    Understanding and Handling Special Situations
    Using Ranges in Excel
    Understand Power Query formulas.
    Loading into Power Pivot
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Power Query Interface

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Logical Functions
    Conversion Functions
    Exploring Data Types
    Utilizing Operators
    Multiple Table Evaluation Context Working with Dates
    Aggregation Functions
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Introduction to DAX
    Date Functions
    Explaining Syntax
    Statistical Functions
    Mathematical Functions
    Filter Functions
    Many-to-Many Relationships
    Single Table Evaluation Context
    PowerPivot Data Model
    The CALCULATE Function
    Text Functions
    Introduction to DAX
    Relational Functions Understanding Evaluation Contexts
    Information Functions

  • See Training Course Details...


Microsoft Power BI

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
    Using the Power BI mobile app
    The Power BI Interface
    Custom visuals Power BI mobile app
    Importing different data sources into Power BI
    Direct connectivity from Power BI desktop
    Managing a Power BI solution
    Connecting to Power BI data
    Shape data using formatting and transformations.
    Using Excel as a data source for Power BI
    Direct connectivity from the Power BI service
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Power BI embedded
    Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
    Topics covered include- Introducing Power BI
    Viewing reports from Excel files Shaping and Combining Data
    Create relationships between data tables.
    Overview of the Power BI Data Model. Using Power BI
    Create a Power BI dashboard
    Importing data into Power BI
    The developer API

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Examining Tiles
    Power Map
    Understanding Aggregations
    Manage modifications.
    Understanding DAX
    Examine map data.
    Adding Slicers to Reports
    Using Cards
    Use Bing maps.
    Calculated Columns and Calculated Fields
    Utilizing DAX Functions
    Topics include –
    Importing Data with a Query
    Perspectives Power Query
    Importing Data
    Filter data.
    Navigate the Power BI interface.

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Modifying a task list
    Working with hyperlinks Exchanging project data
    Customizing reports
    Exporting data
    Communicating among a project team
    Working with tables Filtering, grouping, and sorting
    Managing a project
    Observing project progress Analyzing and adjusting the plan
    Updating the progress of tasks
    Finalizing schedules
    Working with project files
    Tracking project work
    Creating custom views
    Project management concepts
    Resolving resource conflicts
    Printing views and reports
    Working with views
    Creating macros
    Using drawing tools
    Using Help Working with tasks
    Getting started

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Resources and calendars
    Task relationships
    Handling resource conflicts Using templates and importing data
    Monitoring progress Analyzing and adjusting the plan
    Custom views
    Project costs Views and tables
    Team Planner view Working with reports
    Customizing Project
    Consolidating and sharing projects
    Updating an active project
    Creating a task list
    Analyzing the plan Delays and conflicts
    Task options Resource management
    The Project window
    Managing a project
    Sharing resources among projects Exchanging project information
     Setting baselines
    Collaboration
    Getting started
    Hyperlinks
    The Help window Tasks

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Visual reports Customizing Project
    Hyperlinks
    Task links
    Getting started
    Gantt chart formatting
    Modifying a task list
    Working with tables Filters, groups, and sorting
    Working with views
    The Project window
    The Work Breakdown Structure
    Working with templates
    Delays and conflicts
    Updating an active project
    Analyzing the plan
    Exporting to Office applications
    Filters
    Project files Tasks
    Task options Resource management
    Creating a task list

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Shropshire
  • 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 the Timescale
    Printing From a Combined Project
    Understanding Effort Driven
    Task Types and Work Effort
    Creating a New Table
    Assigning Specific Work Times
    Editing a Macro
    Enhancing Report Appearance
    Adding a Constraint
    Assigning Resources in a Sheet
    Understanding the Backstage
    Checking Work For Materials Costs
    Creating WBS Codes
    Understanding Working With
    Using The Tracking Box
    Creating a Custom Table for the View
    Automatically Updating Tasks
    Using a Custom Visual Report
    Entering Lookup Table Values
    Exploring Tables

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Using Tell Me
    Entering Tasks
    Printing Resources for Tasks Getting Help
    Modifying a Schedule Using
    Creating Dependencies in a Sheet
    Assigning Part Time Resources
    Assignment – Creating Summary
    Printing Sheet Views
    Entering Task Durations
    Working With Calendars
    The Importance of Planning
    Adjusting Resource Availability
    Adding Additional Resources
    Simple Resource Assignments
    Examining Task Information
    Changing the Unit Display Resourcing Concepts
    Understanding How Help Works
    Working With Fixed Unit Tasks
    Using Google to Get Help

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Case Study Variable Costs
    Switching Work Assignments
    Contouring Materials Usage
    Using a Hyperlink Field Controlling Project Data
    Using The Tracking Box
    Automatically Updating Tasks
    Understanding Overtime
    Changing Text Styles
    Changing the Layout
    Creating Resource Problems
    Understanding the Data Tools
    Modifying Specific Tiers
    Entering Delayed Tasks
    Tracking Down Over Allocations
    Understanding Gantt Chart Bars
    Rescheduling Tasks Assigning Materials
    Saving an Existing View
    Customising the View Menus
    Basic Data Highlighting
    Creating a New Table
    Working With Multiple Files

  • See Training Course Details...


Microsoft Project 2016 Level 3

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Setting Project Links
    Understanding WBS Codes
    Template Linking and Combining Projects
    Opening Shared Resource Projects
    Managing Shared Resources
    Linking a New Project File to the Pool
    Manipulating Report Data
    Modifying a Template
    Working With a Synced Task List Microsoft Project VBA
    Printing From a Combined Project
    Creating Smaller Projects
    Understanding Visual Reports
    Understanding the Global Template
    Applying a Newly Organised Item
    Adding a Contact as a Resource
    Accessing the Developer Tab
    Exporting to Microsoft Excel
    Examining the Templates
    Filtering Report Data
    Inserting Custom Fields

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Other Documentation methods 
    Intermediate MDX 
    Understanding the development environment 
    Adding scripts 
    Core concept - BI is the cube or UDM 
    Basic syntax 
    Perspectives 
    Intermediate SSAS
    Modeling changing dimensions - Dimension Intelligence w/ Wizard 
    Rapidly changing dimensions / ROLAP dimensions 
    SharePoint 12 and AS 
    .NET Assemblies
    SQL RS & Report Builder 
    KPIs 
    Best practices - health monitoring 
    Most-used Functions & Common tasks 
    What Is Microsoft BI? 
    Security - roles and permissions 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Data Flow Overview 
    The Web Service Task 
    The Import and Export Wizard 
    Configuration options 
    Variables Overview 
    Deploying and Managing SSIS Packages 
    Script in Control flow: The Script Task 
    The SSIS menu 
    Advanced Data Flow
    Built-in log providers 
    The Conditional Split Transformation 
    The Lookup Transformation 
    Working with Packages 
    The package designer 
    SSIS debugging windows 
    Using variables in data flow 
    SSIS for DBAs: Using SQL Server Management Studio
    Source Control for SSIS Packages 
    The SSIS script editor 
    The deployment utility 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Cube Storage and Aggregation
    Explore Advanced Dimension Types
    OLAP Modeling
    Introduction to MDX Queries
    Understand Data Mining Concepts
    Using SSAS in BIDS
    Discover how to add .NET Assemblies
    Explore Clustering
    Implement SSAS Security
    Model with SQL Server Business Intelligence Development Studio (BIDS)
    Understand Basic MDX Syntax
    Advanced Administration and Optimization
    Learn how to add Calculated Members
    Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Package Deployment
    Handling Errors and Debugging 
    Overview of Package Management 
    Handling Slowly Changing Dimensions 
    Using Variables in Control Flow 
    Working with Analysis Services 
    Exploring and Executing an Integration Services Package in BIDS 
    Control Flow
    Using Integration Services Beyond ETL 
    Package Management
    Transactions Support in Integration Services
    Working with Windows Management Instrumentation
    Migrating and Maintaining SQL Servers with Integration Services 
    Data Flows
    Understanding Integration Services 
    Exploring and Executing a Package Outside of BIDS 
    Deployment and Management Best Practices 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Deploying
    Understanding the Multidimensional Model
    Examining Deployment Options
    Configuring Cube Options
    Deploying
    Developing Dimensions
    Dissecting with Dimensions
    The Multidimensional Solution
    Processing Strategies
    Common Analysis Services Solutions
    Utilizing Data Sources and Data Source Views
    Managing Measures
    Creating a Cube
    Understanding Perspectives
    Understanding the Tabular Model
    Utilizing Attributes
    Creating a Tabular Project

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Coding the Script Task
    Designing to Troubleshoot: Using Precedence Constraints
    Utilizing SQL Server Integration Services Data Typing
    Creating SQL Server Integration Services Packages
    Managing with Control Flow
    Understanding Variables
    Define and Use Variables and Parameters
    Working with Advanced Logging and Reporting
    Utilizing Sequences in a Container
    Examining the SSIS Engine
    Understanding Parameters SQL Server Integration Services Tools
    The SQL Server Integration Service
    Utilizing the Import/Export Wizard
    Moving Data with Data Flow
    Handling Errors Common SQL Server Integration Services Design Patterns
    Looping and Sequence Tasks
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Utilizing Data Preparation Tasks
    Using Package Hierarchies: Parent Child
    Utilizing Container Loops Performing Joins

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Shropshire
  • 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 Parameters
    Filtering, Grouping, and Sorting
    Examining Management
    Exploring Gauges
    Understanding Variances Between SQL Versions
    Creating Subreports and Drillthrough Reports
    Utilizing Dynamic Headers and Footers
    Working with Expressions
    Exploring Table or Matrix Wizard
    Planning Your Reports
    Exploring Matrix
    SQL Server 2016 Report Builder Basic Reports
    Working with Map Wizard
    SQL Server 2016 Report Builder Wizards
    SQL Server 2016 Report Builder Advanced Reporting
    Utilizing Chart Wizard
    Visualizing Your Company Report Templates

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Shropshire
  • 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
    View or Change Modeling Flags
    SystemGetClusterAccuracyResults
    Algorithms
    Delete a Mining Model from a Mining Structure
    Make a Copy of a Mining Model
    Manually Edit a Prediction Query
    Create a Cross-Validation Report
    Microsoft Neural Network
    Enable Drillthrough for a Mining Model View or Change Algorithm Parameters
    Browse a Model Using the Microsoft Tree Viewer
    Specify a Column to Use as Regressor in a Model
    Export and Import Data Mining Objects Architecture
    Add a Mining Model to an Existing Mining Structure
    Create a Data Mining Query by Using XMLA
    Column Distributions
    Using Nested Table Data as an Input for an Accuracy Chart Queries
    Microsoft Association
    Create a Content Query on a Mining Model
    Microsoft Logistic Regression Microsoft Logistic Regression

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Using SQL Server Data Tools (SSDT)
    Modify or Delete in Solution Explorer Database Dimensions
    Tools and Approaches for Processing
    Edit or Delete Partitions Merge Partitions
    Set Data Source Properties
    Processing Options and Settings
    Modify or Delete an Analysis Services Database
    Work with Diagrams in Data Source View Designer
    Create Calculated Members
    Create Local Partitions
    Define Logical Primary Keys in a Data Source View
    Define a Referenced Relationship and Referenced Relationship Properties
    Define a Fact Relationship and Fact Relationship Properties
    Configure Analysis Services Project Properties
    Define Named Calculations in a Data Source View
    Deploy Analysis Services Projects
    Designing Aggregations
    Multidimensional models
    Read Definition permissions
    View the XML for an Analysis Services Project Data Sources
    Document and Script an Analysis Services Database

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Define partitions in DirectQuery models
    Impersonation
    Create and Manage Tabular Model Partitions
    Create and Manage Roles
    Topics include- Overview of SSAS Tabular models
    Add a table Delete a Table
    Create and Manage KPIs Hierarchies
    Import Data
    Change table, column
    Create and Manage Partitions in the Workspace
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Add sample data to DirectQuery models
    Bi-directional cross filters  Calculations
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Tabular model designer
    Import from Power Pivot
    Restore from Power Pivot
    Delete a Column
    Enable DirectQuery mode in SSMS

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Configuring data access with report designer
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Publish a report to reporting services Working with Reporting Services Data
    Topics include Introduction to Reporting Services
    Extend reporting services functionality with external assemblies.
    Overview of mobile reports
    Work with expressions and embedded code.
    Use report services configuration manager to reconfigure SSRS servers.
    Preparing data for mobile reports
    Formatting data
    Reporting services components
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Create a report using report builder or report designer.
    Reporting services tools Reporting Services Data Sources
    Drillthrough in mobile reports
    Using Datasets Creating Paginated Reports
    Sorting and grouping
    Data filters
    Mobile report publisher
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Column Selector View
    Prompts Column Formatting
    Basic Navigation Using A Dashboard
    Pdf and Print Control
    Managing Dashboard Objects Creating a Report
    Defining the Pivot View
    Sorting Data
    Databases and Data Models
    Gauge View
    About Business Intelligence
    Column Formatting
    Reusing Filters
    Chart View
    Creating a Dashboard
    Oracle BI Architecture
    Downloading the Answers Report Formatting
    Warehouse Models and Schemas
    Narrative View
    BI and Presentation Catalog Security
    Launch BI Presentation Services

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Declaring and Opening Cursors 
    Record Variables 
    Assignment and Conversions 
    Cursor Parameters 
    Closing Cursors 
    Subtypes 
    Passing Parameters and Default Arguments 
    Stored Subprograms 
    Multi-Row Queries 
    The Implicit (SQL) Cursor
    The UTL_FILE Package 
    Dates and Timestamps 
    PL/SQL Variables and Datatypes 
    Maintaining Triggers 
    Privileges for Stored Programs 
    The Package Interface and Implementation 
    Triggers 
    Overloading Package Functions and Procedures 
    VARRAY and Nested TABLE Collections 
    Using Nested TABLEs 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Scalar Functions 
    SQL*Plus LOB Support 
    Controlling Access to Your Tables 
    Date Functions 
    Viewing Table Characteristics 
    The SELECT Statement 
    Views 
    Sample Database 
    Updatable Views 
    Joining Tables 
    The Aggregate Functions 
    Graphical Clients 
    Creating Views 
    Deleting a Table Definition 
    Combining SELECT Statements 
    Choosing Rows with the WHERE Clause 
    Datatypes 
    Using Oracle SQL*Plus 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Variable Scope 
    mysqli Prepared Statements 
    Creating Dynamic Pages 
    Form Validation Functions with Regular Expressions 
    auto_prepend_file and auto_append_file 
    PHP and HTML Forms 
    Sending a Password by Email 
    Writing to a File 
    Advantages and Disadvantages of PEAR DB 
    Sessions 
    File System Management 
    PEAR:DB 
    More File Functions 
    How HTML Forms Work 
    Variable Scope 
    Creating a Customer Report 
    Cookies 
    Conditional Processing 
    Arrays 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Custom themes Using graphics and multimedia
    Working with hyperlinks
    Equations Distributing presentations
    Customizing SmartArt graphics
    WordArt Pictures
    Saving presentations
    Modifying text
    Clip art
    Animations
    Using slides from other presentations Formatting slides
    Media clips
    Clip art Using tables and charts
    Printing presentations Customizing PowerPoint
    Speaker notes
    Formatting text
    Adding shapes
    Formatting paragraphs Using drawing objects
    Working with Chart Tools Action buttons, custom slide shows, and equations
    Interactive elements
    Using text in objects Working with graphics

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Action buttons and equations
    Customizing tables
    Animations
    Slide masters
    Equations Integrating Microsoft Office files
    Pictures Tables and charts
    SmartArt Preparing and printing presentations
    Preparing a presentation
    WordArt
    Formatting shapes
    Creating shapes
    Photo albums Customizing slide elements
    Creating a basic presentation
    Working with SmartArt graphics
    Working with charts
    Printing presentations
    The PowerPoint interface Creating presentations
    Action buttons
    Applying content from a Word outline
    Media clips

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Inserting a Screen Clip
    Inserting a Picture From File
    Understanding Media in PowerPoint
    Sharing Presentations
    About Self Running Presentations
    Applying Picture Effects
    Animating Text
    Understanding Pictures
    Creating Custom Slide Layouts
    Adjusting Row Heights
    Aligning Table Data
    Understanding Slide Masters
    Applying a Theme
    Applying Shading
    Using a Custom Template
    The Format Picture Pane
    Setting a Custom Templates Location
    Recolouring an Image

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Switching SmartArt Right to Left
    SmartArt
    About Hyperlinks
    Exiting Safely From PowerPoint
    The Save As Dialog Box
    The Save As Place
    Formatting Shapes
    Presentation
    Inserting a Chart
    Using the Ribbon
    Switching Between Open
    Launching Dialog Boxes
    Understanding Backstage View
    Application
    Closing a Presentation
    Previewing Slides
    The Four Pillars of Great Design
    Grouping Shapes
    Rotating Shapes

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Styles and font schemes
    Catalog merge
    Customizing Publisher
    Typography
    Web site publishing
    Finalizing publications
    Table basics
    Adding elements to a Web site
    Publication setup
    Modifying form properties
    Graphics adjustments
    Publisher Help
    Interactive forms
    Object positioning
    Navigation and selection techniques
    Text box linking

  • See Training Course Details...


Publisher 2013

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Creating A Text Box
    Creating A Mail Merge Publication
    Saving An Existing Publication
    Getting Started With Publisher 2013
    Understanding Page Sizes
    Changing Fill
    Inserting Pictures
    Using Fills And Tints
    Inserting Headers
    Safely Closing A Publication Working With a Publication
    Previewing And Modifying A Catalogue Merge
    Text Columns
    Creating Numbered Lists
    Linking Text Boxes
    Sorting A Merge
    Saving For Photo Printing
    Adding And Editing Business Information
    Formatting WordArt
    Merge Printing
    Understanding The Merge Area
    Aligning Text

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Text Box Margins
    Mail Merge
    Inserting Text
    Drawing Text Boxes Accurately
    Text Techniques
    Understanding Publisher 2016
    Previewing and Modifying a
    Working With Tables
    Swapping Pictures
    Using a Master Page
    Drawing and Inserting Shapes
    The Save As Place
    Inserting Advertisements
    Understanding Different Types of
    Merge Printing
    Saving for Photo Printing
    Modifying a Text Style
    Understanding How Help Works
    Text Columns

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • The BETWEEN Operator   
    Using CASE  Inserting, Updating and Deleting Records
    Checking for Inequality    
    Ascending and Descending Sorts         The WHERE Clause and Operator Symbols 
    The NOT Operator 
    WHERE and ORDER BY  
    Checking for NULL 
    Mathematical Calculations
    Calculated Fields
    Common String Functions
     Using the WHERE clause to check for greater or less than
    Conditional Processing with CASE
    Checking Multiple Conditions 
    Common Math Functions    
    Order of Evaluation   Advanced SELECTs    
    Subqueries      
    The WHERE Clause and Operator Words    
    Adding and Dropping Columns

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Server Properties
    Accessing Reports via the Report Manager
    Filters
    Creating a Data Source View
    Identifying Field
    Reporting Services 2005 Subscriptions, Snapshots, and Caching
    Changing Columns and Rows
    Reporting Services 2005 Diagram Pane
    General
    Data Output
    The Reporting Services 2005 Layout View
    Drawing Lines and Rectangles
    General
    Tools for Managing Reports
    Creating Formulas
    Execution Reporting Services 2005 Log Reports
    Design the Query Dialog
    Adding Groups and Users
    Clickthrough Reports
    Launching Report Builder

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Creating Matrix Reports and Charts
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Programming Reporting Services
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Explore creating linked reports 
    Gain a basic understanding of the components behind SQL Server Reporting Services 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Investigate the list data region 
    Explore the use of Reporting Services gauges 
    Learn how to create parameters in ad-hoc SQL 
    Learn how to call the Report Server Web Service 
    Explore the basic architecture of SQL Server Reporting Services 
    Discover how to create standard report subscriptions 
    Calculation and Formatting
    Understand scope as it applies to aggregate functions 
    Discover the many application programming interfaces of Reporting Services 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
    Examine Data Warehousing Concepts
    Create Fact Tables
    Configure the Package Execution Strategy
    Cleanse Data Using DQS Managing SSIS Package Execution
    Install Integration Services Working with Integration Services
    Overview of Data Warehouses
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Create Dimensions
    Add Script Tasks and Script Components to an SSIS Package
    Create an SSIS Project
    Troubleshoot Package Failures Deploying Packages
    Securing Packages and Databases
    Profile OLTP Data
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Deploy SSIS Packages
    Execute Packages from Different Control Flow Working with Dynamic Variables
    Examine MSI Packages
    Work with Windows Azure
    Debug Package Execution Components

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Creating a Shared Data Source and Data Sets
    Using Unbound Parameters Understanding Report And Data Set Parameters
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Introduction to Report Builder
    Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Multivalued Parameters Dynamic Reports with Parameters
    No Data Rows
    Tablix Cell Content and Scope Building a Tablix Report
    Considering Report Layout Options
    Building a Matrix Report
    Interactive Sorting
    Create a Drop-Down List Parameter
    Reordering Report Parameters Using Drop-Down List Parameters
    Field Collection
    Introduction to SQL Server Reporting Services
    Null Handling
    A Tour of the Report Builder Interface
    Report Designer and Data Windows Configuring Report Projects
    Introducing SQL Server Data Tools

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Work with PIVOT and UNPIVOT
    Work with Data Access Technologies Implementing Stored Procedures
    Update Data
    Work with Set Operators
    Create Queries Using Join Algorithms
    Work with SSMS Working with T-SQL
    Manage Query Plans
    Work with String and Numeric Data Types
    Assign Aliases Using Queries
    Create Queries Using Built-in Functions
    Manage SQL Server Constraints Writing SELECT Queries
    Combine Data Using Simple Joins
    Getting Started with SQL Server 2012
    Configure User-Defined Functions (UDF)
    Work with T-SQL Statements
    Filter the Queried Results
    Manage Views
    Work with Dynamic SQL Working with Subqueries and Table Expressions
    Work with SSPs and SMOs
    Control Program Flow
    Work with Window Functions

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Network diagrams
    Web site maps
    Working with links
    Drawing tools
    Formatting drawings
    Planning your diagram
    Integration with Microsoft Outlook
    Formatting text blocks
    Advanced Layout and connection techniques
    Business diagrams and Web site mapping
    Printing diagrams
    Manipulating stencils
    Dimensioning

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Network diagrams
    Project management diagrams
    Basic shapes and lines
    Planning a diagram
    Working with links Network and brainstorming diagrams
    Organization charts Formatting drawings
    Compound lines
    Special drawing operations
    Rack diagrams
    Web site maps Integrating Visio with other programs
    Editing objects Basic diagrams
    Getting started
    Formatting text
    Reporting
    Displaying shape dimensions Custom themes and templates
    Working with background pages
    Integration with Microsoft Word
    Integration with PowerPoint
    Flowcharts
    Drawing scales
    Custom themes

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Formatting text
    Rack diagrams
    The start page
    Layout and connection techniques
    File and print properties
    Web site maps
    Integration with PowerPoint
    Project management diagrams
    Creating technical layouts
    Special drawing operations
    Presentation Mode
    Organization charts
    Software and database diagrams
    Organization charts
    Planning a diagram
    Integration with Microsoft Outlook
    Custom templates

  • See Training Course Details...


Word 2010 Advanced

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Creating Bookmarks
    Templates
    Modifying Theme Colours
    Inserting A FILLIN Field
    Modifying A Bullet
    Using A Custom Template
    Running A Macro
    Applying Paragraph Styles
    Navigating With Bookmarks
    Inserting A Cover Page
    Macros
    Customising The Columns
    Understanding Tables Of Contents
    Inserting Text
    The Field Dialog Box
    Inserting A Blank Cover Page
    Understanding Interactive Fields
    Understanding Electronic Forms In Word
    Inserting Subdocuments

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Checking Spelling And Grammar
    Copying
    Navigating With The Keyboard
    Using Shortcut Menus
    Cutting And Pasting
    Understanding Shapes
    Using The Ribbon
    Inserting A Drawing Canvas
    Opening Multiple Documents
    Inserting A Date
    Typing Numbers
    Setting Tabs On The Ruler
    Inserting Headers And Footers
    The Word Screen
    Viewing The Ruler
    Launching Dialog Boxes
    Understanding Printing
    Understanding Font Formatting

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Table data Page layout
    Spelling and grammar
    AutoCorrect
    Document navigation Editing text
    Find and replace Formatting text
    Tab settings
    Working with outlines Proofing, printing, and exporting
    Table design options
    The Word window
    Getting started
    Adding graphics and clip art
    Examining formatting
    Working with text
    Working with styles
    Headers and footers
    Paragraph spacing and indents Tables
    Paragraph formatting
    Working with graphics Styles and outlines
    New documents
    Printing and exporting documents
    Graphics

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Making Basic Changes
    Pictures Tell a Story
    Accessing the Help Window
    Selecting a Printer
    Deleting Columns and Rows
    Setting Bar Tabs
    Resizing a Picture
    Changing Paragraph Spacing
    Highlighting Text
    Setting Custom Margins
    Understanding Read Mode
    Making Text Bold
    Changing Fonts
    Working With Paragraphs
    Working With Text
    Selecting Text Using the Mouse
    Using Go To
    Perfect Page Layouts
    Cutting and Pasting
    Changing Font Size
    Using the Paragraph Dialog Box

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Inserting First Page Headers and
    Synchronised Scrolling
    Typing Text Into a Text Box
    Applying 3D Rotation Effects
    COURSEWARE
    Resetting a Theme
    Setting Up Mailing Labels
    Templates
    Applying a Picture Fill to a Shape
    Controlling Widows and Orphans
    Applying Hyphenation to Text
    Inserting a Drop Cap
    Applying Character Styles
    Modifying a Template
    Enhancing Shapes
    Adjusting Header and Footer
    Importing and Exporting Styles
    Linking Text Boxes
    Saving a Recipient List

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Editing a Protected Form
    Inserting Formulas
    Document Commenting
    Checker
    Inserting Text Controls
    Balloons
    Making a Document Read Only
    Proofreading Your Document
    Customising the Grammar Checker
    Master Documents
    Inserting Text
    The Field Dialog Box
    Updating a Table of Contents
    Running a Macro
    Understanding SmartArt
    Understanding PDF Documents
    Creating a Master Document
    Changing the Number Format
    Sharing Documents
    Tips for Developing Macros
    Changing the SmartArt Style

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730