Enable Technology

MIDLANDS TRAINING COURSES 

TRAINING COURSES MIDLANDS




Adobe Dreamweaver CC

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Fundamentals of HTML
    Adding Grain With the Add Noise Filter
    Understanding Adjustment Layers
    Adding a Nav Tag
    Previewing the Page Layout
    Understanding the Files Panel
    Sharpening Images With the Unsharp Mask
    Importing a Microsoft Word Document
    Checking Links and Validation
    Modifying a Linked Smart Object
    Correcting Perspective With Puppet Warp
    Uploading a Website
    Understanding Views
    Understanding the Bridge Workspace
    Inserting an Image
    Adjustment Layers in a Multi-Layered Image
    Understanding Site Structure
    Adobe Photoshop Mobile Applications
    Adjusting Colour Saturation Selectively
    Understanding Floating Elements

  • See Training Course Details...


Adobe Illustrator CC

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Understanding Vector Graphics
    Searching for Online Help The Adobe Account
    Saving a Gradient
    Reassigning Objects to Different Layers
    Naming Layers and Assigning Colours
    Copying Objects
    Threading Text
    Viewing a File in Creative Cloud
    Understanding the Tools Panel
    Navigating With the Navigation Panel
    Understanding Layers and Sublayers
    Applying the 3D Revolve Effect
    Drawing Paths With the Curvature Tool
    Selecting Multiple Objects
    Grouping Layers
    The Creative Profile Home Page
    Grouping and Ungrouping Objects
    Changing the Perspective of an Object
    Working With Isolation Mode

  • See Training Course Details...


Adobe InDesign CC

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Commenting on a Shared File
    Understanding TypeKit
    Working With Tracked Changes
    Opening an Existing Document
    Using Shortcut Menus
    Understanding InDesign
    Using New Document Preview
    Adding Colours to the Swatches Panel
    Soft Proofing
    Understanding Layers
    Working With Table Colour
    Fitting Graphics
    Defining a Print Preset
    Applying an Indent
    The Creative Profile Home Page
    Saving a New Document Working With a Workspace
    Adjusting the Units of Measure
    Adjusting Tracking
    Understanding Library Assets
    Adding Notes to a Shared File
    Applying Text Wrap

  • See Training Course Details...


Adobe Photoshop CC

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Understanding the Refine Edge Dialog Box
    Converting Colour Images to Greyscale
    Using the Lasso Tool
    Opening Images in Camera Raw
    Using Curves to Improve Contrast
    The Photoshop CC Workspace
    The Welcome Experience
    Accessing Online Tutorials The Adobe Account
    Using the Mixer Brush
    Working With Panels and Panel Groups
    Understanding the Raw Tool Bar
    Installing Adobe Bridge
    Saving a Document
    Using the Marquee Tools
    Understanding File Size
    Applying Colour to 3D Text
    Applying a Soft Focus Effect
    Understanding the Save for Web Dialog Box
    Adding Elliptical Motion With Spin Blur

  • See Training Course Details...


ASP.NET Core MVC

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Validation Attributes Routing
    The View in ASP.NET MVC
    Using Dynamic Objects
    Considerations in Using ASP.NET MVC
    A Windows Azure Testbed
    .NET Core
    Using Postman
    Introduction to ASP.NET Core MVC
    HTTP Services Using Web API
    Using Visual Studio
    Action Attributes
    Retrieving Data from a Request
    Input Validation The Model
    Unit Testing Getting Started with ASP.NET Core MVC
    Model Binding
    Html Helpers
    Filters The View
    Deploying an Application to Azure
    HTTP Response Codes
    REST and Web API
    Controller Base Class

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Midlands
  • 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 ...
  • LINQ to SQL 
    Introducing Cascading Style Sheets 
    ASP.NET 2.0 Themes 
    LINQ 
    Web Development Using Visual Studio
    Client-side Code Debugging in ASP.NET 
    Setting Up an Out-of-Process State Server 
    Master Pages 
    Writing Code to Interact with Membership and Roles 
    Validating User Input 
    Debugging Client-Side JavaScript 
    Introducing Data Source Controls 
    Programming Configuration Files 
    Using the Complex Validators 
    Client-Side and Advanced Debugging 
    LINQ to XML 
    Configuration 
    Introduction to Membership and Roles 

  • See Training Course Details...


ASP.NET using VB.NET

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Data Binding 
    A Review of Classic ASP 
    Using the Visual Debugger 
    Site Navigation 
    Introducing Cascading Style Sheets 
    Debugging .NET Framework Source Code
    Introduction to Web Controls 
    Language Integrated Query 
    Preserving State in Web Applications 
    Summarizing Results with the ValidationSummary Control 
    Introducing the GridView Control 
    Displaying XML Data Using the XmlDataSource Control 
    The Calendar Control 
    The AdRotator Control 
    Writing Code to Interact with Membership and Roles 
    Server-Side Code Debugging in ASP.NET 
    Introduction 
    Debugging Exceptions and Handling Errors 

  • See Training Course Details...


Crystal Reports 2008

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Changing Background Colors
    Working with the Page Commands 
    Using Group Selection toFilter the Records in the Report
    Separating Statements in Complex 
    Passing Data from the Main Report into a Subreport
    Using the Report Wizards 
    Parameter Fields Overview
    Customizing Cross-Tab Group Names
    Case Sensitive vs. Case Insensitive 
    Formulas
    Using a Parameter to set N in a Top N or 
    Adding Parameter Values to Text 
    Using an Edit Mask to Limit String 
    Understanding Crystal Formula Syntax 
    Creating Boolean (True/False) Formulas 
    Filter Types of the Select Expert 
    Working with Variables
    Creating On-Demand Subreports
    Sorting with a Parameter

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Moving and Aligning Objects 
    Managing Resources with Explorers 
    Selecting Records with Multiple Criteria 
    Customize Group Name Field 
    Using the Running Totals Feature
    Using Group Selection toFilter the Records in the Report
    Using a Parameter to set N in a Top N or 
    Processes the Data
    Understanding the Formula Evaluation 
    Choosing a Data Source 
    Using the Section Expert to Work with Sections
    Grouping and Sorting Data 
    Adding Parameter Values to Text 
    Customizing the Cross-Tab Format
    Assigning a Value to a Variable
    Group and Sort Direction 
    Using the Status Bar 
    Inserting Special Fields
    Prompting with Parameters

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Inserting Special Fields Selecting Specific Records from the Database
    Reordering Groups
    Inserting Lines and Boxes
    Conditionally Formatting Fields Creating Summary Reports and Charts
    Basing Report Formulas or Conditional Formatting on Report Alerts
    Customizing Cross-Tab Group Names Report Alerts
    When and Why to Group Records
    Exporting to Windows Applications
    Learning about Linking
    Formatting the Subreport
    Using the Sort Control
    Using Parameters in Conditional Formatting
    Customizing Group Sort Order
    Exploring the Toolbars
    Applying the Drill-Down Group Level
    Grouping Data in Date/Time Intervals
    Database Filtering with the Select Expert
    Creating String Formulas
    Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
    Using the Formula Editor
    Using a Parameter to Select Records

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Using the Parameter Panel
    Editing Charts
    Modifying Individual Objects in the Chart
    Charting Cross Tabs
    Modifying Individual Objects in the Chart
    The Summaries Dialog Box
    Adding Fields into a Text Object
    Conditionally Formatting Fields Creating Summary Reports and Charts
    Saving the Report
    The Data Dialog Box
    Customizing Cross-Tab Group Names Report Alerts
    Customizing the Cross-Tab Format
    Applying the Drill-Down Feature
    Understanding Subreports
    Understanding How Cross-Tabs Affect Your Data
    Crating a Cross-Tab with Multiple Rows or Columns
    Producing Charts
    The Template Dialog Box Power Formatting
    Adding Multiple Tables to a Report Creating and Using Formulas
    Variable Scope
    Parameter Fields Overview

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Creative Usage for Report Alerts Report Templates
    Crystal Reports XI Before You Begin
    Case Sensitive vs. Case Insensitive
    Understanding the Formula Evaluation Time Debugger Using Subreporting as a Workaround Solution
    Conditional Running Totals Prompting with Parameters
    Saving the Report
    Modifying Individual Objects in the Chart
    What is a Report Template
    Hiding and Suppressing Sections
    Organizing the Data for the Report
    Formatting Individual Cells
    Working with Arrays
    Using Group Selection to Filter the Records in the Report
    Pre-Pass #2
    Placing Fields on the Report
    Using a Parameter Field
    Template Considerations
    Database Links versus Subreports in One-to-Many Situations
    Standard Report Creation Wizard and Templates
    Using a Field Name to Customize the Group Name
    Exporting to Windows Applications

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Layout: Columns and Flexible Box
    Video Formats
    Box Shadow Transitions, Transforms, and Animations
    Word Wrapping Colors, Gradients, Background Images, and Masks
    UI Element States Pseudo-Classes
    The Opacity Property
    What Are Vendor Prefixes
    Transitions Layout: Columns and Flexible Box
    Browser Support
    Responsive Images and the viewport Metatag
    Rounded Corners
    The @font-face Rule
    Embedding Media
    The Target Pseudo-Class
    Fonts on the Web
    Structural Pseudo-Classes Fonts and Text Effects
    Modernizr
    Frameworks and Grid Systems
    Implementing CSS3 in the "Real World"

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Microsoft Logistic Regression Algorithm
    Offline Mode and Immediate Mode
    Exploring Data
    Saving Queries
    Cross Validation
    Microsoft Clustering Algorithm
    Creating Reports Using Reporting Services
    Microsoft Decision Trees Algorithm
    Data Preparation
    Microsoft Linear Regression Algorithm
    Microsoft Neural Network Algorithm
    Model Usage
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Microsoft Naïve Bayes Algorithm
    Microsoft Time Series Algorithm
    Testing and Validation of Mining Models
    Excel PowerPivot Data Mining Add-ins
    Introduction to SQL Server Data Tools

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Targeting Widths and Devices with CSS3 Media Queries
    Optimizing for Mobile
    Responsive Design: Good for All Devices
    The Flexible Grid: A More Responsive Layout Strategy
    Drag-and-Drop Code Builder
    Video Formats
    Foundation: A Responsive Grid Framework
    GeoLocation API
    The Viewport
    JavaScript Implementation
    Supported Platforms
    Other Devices
    Mobile Focus
    Consolidating the Web with Native Extensions
    Converting Video Formats
    Accessing Camera, Contacts, Calendar, and More - But Not Yet
    Using the Accelerometer

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Using the Cell Link to Display the Selection
    Exporting to Microsoft Word
    Creating Subtotals
    Creating Calculated Items
    Sorting in a PivotTable PivotCharts
    Relative Cell References
    Inserting a Timeline Filter PivotTable Features
    Counting in a PivotTable
    Navigating Worksheet Comments
    Moving PivotCharts to Chart Sheets Advanced Filters
    Understanding Text File Formats
    Understanding Types of Controls
    Setting Advanced Options Protecting Data
    Using the DCOUNT Function Validating Data
    Understanding How Controls Work
    Working With an Outline
    Using Formulas in Criteria
    Understanding Data Tables and What-If Models
    Copying Subtotals
    Enabling Tracked Changes
    Creating Scenarios

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Previewing Before You Print
    Selecting Contiguous Ranges
    Working With Multiple Worksheets
    Changing Font Colours
    Using Google to Get Help
    Starting Excel From the Desktop
    Printing an Embedded Chart
    Creating More Complex Formulas
    Moving Cells and Ranges
    Creating Formulas That Subtract
    Safely Closing a Workbook Working With Workbooks
    Relative Formulas
    Understanding Cell Alignment
    Changing Background Colours
    Understanding Copying in Excel
    Changing the Chart Type
    Checking the Spelling
    Creating Custom Filters
    Absolute Versus Relative Referencing
    Horizontal Cell Alignment
    Understanding Filling

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Sorting Tables
    Understanding the Format Pane
    Formatting
    Applying a Border to a Cell
    Centring on a Page
    Working With Icon Sets
    Understanding Format Codes
    Clearing Conditional Formatting
    Formatting Clock Time
    Creating the Base Formula
    Quick Totals
    Applying a Border to a Range
    Adding More Complexity
    Grouping Worksheets
    Changing WordArt Fill
    Scaling to a Percentage
    Showing Gridlines
    Using the Format Pane
    Drawing Borders
    Quick Sparklines
    More Cell Formatting Options

  • See Training Course Details...


Excel Power Pivot

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

  • Some of the training topics covered include ...
  • Rearranging and Sorting Fields
    Understanding the Query Editor
    Working With Time Settings
    Creating a Data Model PivotTable
    Working With the Data Model
    Using Calculated Fields
    Changing the Look
    Working With Scenes
    Editing Query Steps
    Switching Visualisations
    Creating a Power Map Tour
    Enabling Power Pivot
    Connecting to a Data Source
    Reducing Data Rows
    Working With Merged Queries
    Adding Power View to the Ribbon
    Updating a Power View Report
    Creating a New Query From a File
    Adding More Power Views
    Creating a Calculated Field
    Working With a Power View Object

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Using the For Each...Next Structure
    Using Visual Basic Help
    Understanding Constants
    Working with the Combo Box Control
    Understanding Errors
    Understanding the Development Environment
    Understanding VBA's Error Trapping Options
    Using Intrinsic Functions
    Understanding Procedures
    Working with the PivotTable Objects
    Using Input Boxes
    Understanding Modules
    Navigating the Excel Object Hierarchy
    Working with Methods
    Writing an Error-Handling Routine
    Understanding PivotTables
    Working with Properties
    Working with Procedures and Functions
    Using the Do...Loop Structure
    Creating a PivotTable Using Worksheet Data

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Working with Timers 
    Making the Stage a Class 
    Loading Content Dynamically Into a MovieClip 
    Using a MovieClip and Button's Properties 
    Arrays 
    Using the EX Operators 
    Types of Conditional Statements 
    XML with EX 
    Creating Visual Classes Through Inheritance 
    Declaring and Using Variables 
    Formatting the Player Score TextField 
    Using the Tween Class 
    Types of Loops 
    Using Functions and Methods 
    ActionScript Fundamentals 
    Tweening the Warp Animation
    Getting a Date with ActionScript 
    Accessing External XML Documents 
    ActionScript Event Types 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Midlands
  • 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 ...
  • The Range offset() Method
    SpreadsheetApp
    Sending An Email Using MailApp
    List Google Drive File And Folder Names
    Creating A Table
    Native And Host Objects
    JavaScript Scripting
    Connecting To The MySQL Database
    Built-in Versus User-Defined Functions
    Custom User-Defined
    Using List Boxes Google Drive, Folders, Files and Permissions
    Using Google Services Spreadsheets and Sheets
    Adding Users Building Simple Graphical Interfaces
    The Data Range Of A Sheet
    The Spreadsheet Object
    Named Ranges
    The Sheet Object
    Numeric Calculations
    Populating A Table
    Setting Up Google Cloud SQL
    Practical Examples  MySQL and JDBC

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Midlands
  • 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 ...
  • The title Attribute HTML Images
    External Style Sheets
    Hidden Fields
    Targeting New Windows
    TheElement TheElement
    Formatting Elements
    Id and Name Attributes
    Absolute vs. Relative Paths
    Points (pt)
    Benefits of Cascading Style Sheets
    Preformatted Text
    Blocks and Inline Elements
    Anchors with the id Attribute
    Making Images Accessible
    Get vs. Post
    The Inherit Value
    Start Attribute
    Long Descriptions
    Text Links
    Anchors with the name Attribute

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Midlands
  • 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 article Tag
    Colour and Transparency
    Some Other New Form Field Attributes
    Page Structure
    HTML5 Canvas
    Laying out a Page with HTML 4 - the "old" way
    Page Simplification
    Local Storage
    Overview of HTML5 Web Storage
    Outlining
    Display of HTML5 Structural Elements
    The Problems XHTML Addresses
    Prefixing your Keys
    novalidate
    Web Storage
    Web Database Storage
    The New More Flexible Approach of HTML5 - Paving the Cowpaths
    Audio Tag Attributes

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Methods
    Storing User-Entered Data
    JavaScript Objects, Methods and Properties
    Built-In JavaScript Objects
    Validating Select Menus
    Properties
    ParseFloat() and parseInt()
    while Loop Syntax
    if - else if - else Conditions
    Image Rollover Function
    Array Properties and Methods
    for in Loop Syntax
    A Loosely-typed Language
    The getElementById() Method
    Accessing Form Data
    do while Loop Syntax
    Image Rollovers
    Arrays

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Optimize Selectors
    Getting RequireJS
    Comparison Operators
    Saving Selections
    Attributes
    Checking Types
    Don't Treat jQuery as a Black Box
    Using CSS Classes for Styling
    Specificity
    jQuery's Ajax-related Methods
    Best Performance Practices-
    Removing Elements
    Managing Dependencies
    Data Types
    Functions
    Writing Plugins
    Creating New Elements
    Built-in Effects
    Managing Effects

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Supported Devices/OSs/Browsers
    Buttons and Linking Pages
    HTML5 and CSS3 Getting Started with jQuery
    Page Transitions
    Sliders
    Basic Page Template
    Collapsible Blocks Events
    Using Others' Plugins
    Dialogs Widgets and UI
    plugin Architecture
    Data-role
    Hosting vs. CDN
    Making Calls
    ThemeRoller
    Themes and Swatches
    Accessibility Support
    Lists and Buttons

  • See Training Course Details...


Microsoft Access 2007

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Working with Windows SharePoint Services Database management
    Sorting and filtering records Working with reports
    Using Design view
    Creating tables Fields and records
    Database concepts
    Creating and using queries
    Creating parameter queries
    Adding calculated values
    Summarizing and grouping values Advanced form design
    SQL and Access
    Planning and designing databases
    Attaching SQL queries to controls Advanced queries
    Organizing records Data entry rules
    Lookup fields
    Getting help Databases and tables
    Importing objects
    Optimizing resources
    Advanced form types Reports and printing
    Printing
    PivotCharts
    Adding calculated values

  • See Training Course Details...


Microsoft Access 2010

  • 2 day course
  • Location: Midlands
  • 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 ...
  • PivotTable forms Querying with SQL
    Performing operations in queries Using forms
    Creating lookup fields
    Database concepts
    Database normalization
    Attaching macros to the events of database objects Advanced macros
    Customized headers and footers
    Calculated values
    Labels Charts
    Attaching SQL queries to controls Advanced queries
    Creating macros to provide user interaction
    Summarizing and grouping values Advanced form design
    Protecting databases
    Creating, running, and modifying macros
    Adding calculated values
    Using calculated fields
    Advanced form types Reports and printing
    PivotCharts
    Setting options and properties
    Planning and designing databases
    Working with input masks

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Organizing records Data Entry rules
    Creating crosstab queries
    Planning and designing databases
    Using action queries  Macros
    Advanced form types Reports and printing
    Working with input masks
    Using Design view
    Creating reports
    Exploring the Access environment Databases and tables
    Creating macros that require user input
    Creating, running, and modifying macros
    Using hyperlink fields Database management
    Modifying and printing reports Relational databases
    Referential integrity Related tables
    Setting validation rules Basic queries
    Using calculated fields
    Performing operations in queries Using forms
    Charts in forms
    Label printing Charts
    Charts in reports Querying with SQL
    Getting started

  • See Training Course Details...


Microsoft Access 2016

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Modifying Table Structures
    Designing a Lookup Database
    Using a Navigation Form
    Calculations in Queries
    An Introduction to VBA
    Creating a Lookup Database
    Creating and Using Macros
    Modifying Forms
    Creating and Using Forms
    Creating a Relational Database
    Aggregation Queries
    Macro Techniques
    Database Security
    Adding Records to a Table
    Understanding VBA
    Querying Techniques
    Setting Table Relationships
    Relational Database Design
    Creating and Using Reports
    Multi Table Queries
    Data Validation

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Determining the Value of Expressions
    Using the With Statement
    Writing an Error-Handling Routine
    Using the For Each...Next Structure
    Calling Procedures
    Working with Procedures and Functions
    Understanding the DoCmd Object
    Using Break Mode during Run Mode
    Understanding VBA's Error Trapping Options
    Working with Variable Lifetime
    Understanding Modules
    Organizing Code and Procedures
    Working with Boolean Expressions
    Debugging Code
    Why Program in Access?
    Declaring Variables
    Understanding the Err Object
    Using the Object Browser
    Specifying a Recordset Cursor Location - Optional
    Understanding Expressions and Statements

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Performing Merges
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand Power Query formulas.
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Understanding the Issues
    Understand and utilize merges. LOADING YOUR DATA
    Working with Folders and Files
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Understand the M interface.
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Understanding and Handling Special Situations
    Loading into Power Pivot
    Introduction to Power BI Desktop
    Appending Operations
    Transforming Data
    Using Ranges in Excel
    Combining Worksheets
    Loading into Power BI Desktop
    Loading into Excel

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Power BI

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Direct connectivity from Power BI desktop
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Creating Power BI reports
    Using the Power BI mobile app
    Importing different data sources into Power BI
    Using databases as a data source for Power BI
    Create a Power BI dashboard
    The Power BI Interface
    Viewing reports from Excel files Shaping and Combining Data
    Shape data using formatting and transformations.
    Create relationships between data tables.
    Overview of the Power BI Data Model. Using Power BI
    Power BI embedded
    Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
    Connecting to Power BI data
    Direct connectivity from the Power BI service
    Using Excel as a data source for Power BI
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    Importing data into Power BI
    Managing a Power BI solution
    Combine data together from tables in your dataset. Modeling data

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Importing Large Datasets
    Perspectives Power Query
    Creating Charts
    Configuring Drill Through
    Calculated Columns and Calculated Fields
    Adding Slicers to Reports
    Hiding Columns, Change Data Type, Sorting, and Filtering
    Power Map
    Using Cards
    Creating PivotTables
    Navigate the Power Map interface.
    Merge datasets.
    Creating a Cascading Relationship
    Utilizing Matrix
    Perform data cleaning.
    Utilizing DAX Functions

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Visual reports Customizing the project environment
    Working with views
    Resolving resource conflicts
    Observing project progress Analyzing and adjusting the plan
    Creating base calendars
    Consolidating and sharing projects
    Printing views and reports
    Copying data
    Creating macros
    Importing data
    Tracking project work
    Working with groups
    Formatting a project file
    Sharing resources across projects Project communications
    Getting started
    Using drawing tools
    Working in Network Diagram view
    Creating custom views
    Exporting data
    Exploring the Project window
    Modifying a task list

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Customizing Project
    Creating a task list
     Setting baselines
    Exporting to Office applications
    Collaboration
    Task relationships
    Finalizing schedules
    Project files
    Working with templates Creating projects from other programs
    Analyzing the plan Delays and conflicts
    The base calendar
    Standard reports Visual reports  
    Handling resource conflicts Using templates and importing data
    Modifying a task list Task scheduling
    Team Planner view Working with reports
    Getting started
    Sharing resources among projects Exchanging project information
    Gantt chart formatting
    The Project window
    Updating an active project

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Standard reports
    Gantt chart formatting
    The Project window
    Modifying a task list
    Working with views
    Collaboration
    Creating projects from other programs Managing a project
    Project files Tasks
    Task links
    Hyperlinks
    Task relationships
    Working with templates
    Project costs
    Sharing resources among projects Exchanging project information
    Working with tables Filters, groups, and sorting
    Resources and calendars
    Creating a task list

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Saving an Existing View
    Understanding Tasks
    Understanding Lag Time
    Working With Progress Lines
    Working With the Legend
    Printing a Gantt Chart
    Understanding Graphical Reports
    Understanding Linked Projects
    Accessing the Help Window
    Creating a Custom Table for the View
    Creating Summary Tasks
    Assigning Resources in a Sheet
    Automatically Updating Tasks
    Setting a Combined Project Start
    Assignments
    Working With Split Screens
    Manipulating Report Data
    Checking Resource Usage
    Understanding Graphical Indicator
    Creating a Custom Group for the
    Entering Milestones

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Printing a Gantt Chart
    Checking Progress
    Using the Ribbon
    Creating a New Resource Calendar
    Entering Lead Time
    Creating a Simple Assignment
    Entering Tasks
    Understanding Tasks
    Printing Sheet Views
    Understanding Resource Availability
    Viewing the Critical Path
    Project Operations
    Automatically
    How Project 2016 Works
    Using Google to Get Help
    Entering Lag Time
    Simple Resource Assignments
    Auto Scheduling Tasks
    Making Multiple Assignments

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Displaying Progress Lines
    Contouring Materials Usage
    Assigning Overtime
    Applying a Different Cost Table
    Automatically Updating Tasks
    Consumption
    Understanding Constraints and
    Viewing Task Slippage Project Views
    Keeping New Views Local
    Exploring Tables
    Creating A Baseline
    Creating a New Table
    Saving an Existing View
    Formatting Table Fields
    Understanding Project Costs
    Rescheduling Tasks Assigning Materials
    Checking Work For Materials Costs
    Reviewing Current Costs
    Working With the Legend
    Assigning Per Usage Costs
    Creating an Over Allocation Report

  • See Training Course Details...


Microsoft Project 2016 Level 3

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Understanding Graphical Indicator
    Setting Project Links
    Inserting Task Links
    Adding a Contact as a Resource
    Copying Table Data
    Setting a Combined Project Start
    How Graphical Reports Work
    Understanding the Global Template
    Custom Fields
    Copying to Microsoft Excel
    Using the Personal Template Folder
    Understanding WBS Codes
    Opening Shared Resource Projects
    Understanding Graphical Reports
    Exporting to Excel Using a Map
    Filtering Report Data
    Understanding Excel Visual Reports
    Formatting Chart Objects
    Changing Data in a Combined Project
    Understanding Visual Reports
    Making Reports Global

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Future Directions & Integration with Office 12
    SQL RS & Report Builder 
    Modeling source schemas -stars and snowflakes 
    Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter 
    Excel Services 12 and AS (Web Services)
    Storage topics - basic aggregations, MOLAP 
    Security - roles and permissions 
    .NET Assemblies
    SharePoint 12 and AS 
    Using multiple fact tables 
    Processing mining models 
    Excel 2003 Pivot Tables 
    Clustering - high availability 
    Example cube as seen using Excel pivot table 
    Adding named sets 
    Modeling intermediate fact tables 
    Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network) 
    Intermediate MDX 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Variables Overview 
    Using variables in data flow 
    The Data Conversion Transformation 
    Deployment options 
    Configuration options 
    Deployment security 
    The Bulk Insert Task 
    The Conditional Split Transformation 
    The Merge and Merge Join Transformations 
    Managing packages with DTUtil 
    Debugging , Error Handling and Logging
    SSIS for DBAs: Using SQL Server Management Studio
    The package designer 
    The deployment utility 
    Configuration Overview 
    Breakpoints in SSIS 
    Introduction to Control Flow
    Using variables to pass information between packages 
    The Execute SQL Task 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
    Understand Performance Tuning and Optimization
    Create Data Source Views
    Deploy and View a Sample Cube
    Review Microsoft Office SharePoint Server 2007
    Understand Mining Structure Processing
    Understand the Development Environment
    View Aggregation Designs
    Introduction to Data Mining
    Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
    Use Excel 2007 as a Data Mining Client
    Customize Aggregation Designs
    Understand Basic MDX Syntax
    What Is Microsoft Business Intelligence?
    Discover how to add .NET Assemblies
    Introduction to MDX Queries
    Define Business Intelligence

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Using Integration Services Beyond ETL 
    Scripting in Control Flows with the Script Task 
    Control Flow
    Event Handling 
    Data Flows
    Custom Integration Services Components 
    Managing Integration Services Packages 
    Scripting in Data Flows with the Script Component 
    Advanced Data Flow
    Using Variables and Configurations between Packages 
    Precedence Constraints 
    Understanding Integration Services 
    Advanced Control Flow Overview 
    Executing Packages 
    Using Containers 
    Migrating and Maintaining SQL Servers with Integration Services 
    Overview of Package Management 
    Overview of Control Flow in Integration Services 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Querying the Solution and Understanding DAX
    Exploring Security
    Creating a Cube
    Introduction to Microsoft SQL Server Analysis Services
    Understanding Perspectives
    The Multidimensional Solution
    Understanding the Tabular Model
    Dissecting with Dimensions
    Examining Deployment Options
    Browsing Perspectives and Translations
    Analysis Services Tools.
    Relating with Relationships
    Utilizing Data Sources and Data Source Views
    Calculated Members.
    Maintaining and Optimizing
    Version Changes of SSAS from 2008-2014
    Developing Dimensions

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Managing with Control Flow
    Handling Errors Common SQL Server Integration Services Design Patterns
    Data Loading with the Analysis Services Tasks
    Performing Joins with the Lookup Transformation
    Performing Joins with the Merge Transformation
    SQL Server Integration Services Architecture
    Working in the Explore Window
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Understanding Packages
    Utilizing the Import/Export Wizard
    Understanding Variables
    Optimizing Sources for Extraction
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Utilizing SQL Server Integration Services Data Typing
    Managing SQL with the SQL Tasks
    Working with XML
    Designing to Troubleshoot: Using Precedence Constraints
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Looping and Sequence Tasks
    Moving Data with Data Flow
    Utilizing Container Loops Performing Joins

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Midlands
  • 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
    Introduction to SQL Server 2016 Report Builder
    SQL Server 2016 Report Builder Basic Reports
    SQL Server 2016 Report Builder Advanced Reporting
    Working with Map Wizard
    Examining Maps
    Examining Management
    Exploring Subscriptions
    Exploring Matrix
    Exploring Table or Matrix Wizard
    Formatting Reports
    Mastering Data Region(s)
    Utilizing Data Sources
    Utilizing Charts
    SQL Server 2016 Report Builder Wizards
    Understanding Visualizations
    Working with Datasets
    Examining Security

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Apply a Filter to a Mining Model
    Choose an Accuracy Chart Type and Set Chart Options
    Columns Data Types
    Apply Filters to Model Testing Data
    Training and Testing Data Sets
    Create a Singleton Query in the Data Mining Designer
    Microsoft Decision Trees
    Make a Copy of a Mining Model
    SystemGetClusterCrossValidationResults
    Data Mining Model Viewers
    Apply Prediction Functions to a Model
    Microsoft Time Series
    Export and Import Data Mining Objects Architecture
    Choose and Map Input Data for a Prediction Query
    Change the Properties of a Mining Model
    Process a Mining Model
    Browse a Model Using the Microsoft Naive Bayes Viewer
    Microsoft Logistic Regression Microsoft Logistic Regression
    Physical Architecture
    Microsoft Clustering
    SSAS Data Mining Tools

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Configure Measure Group Properties
    Define Named Queries in a Data Source View
    Create a Time Dimension by Generating a Time Table
    Processing Databases, Dimensions and Partitions
    Error Configuration Roles and Permissions
    Using SQL Server Data Tools (SSDT)
    Tools and Approaches for Processing
    Move an Analysis Services Database
    BI Wizard
    Designing Aggregations
    Deploy Analysis Services Projects
    Create User-Defined Hierarchies
    Delete a Data Source
    Overview of SSAS Multidimensional Modelling
    Create Calculated Members
    Test an Action
    Deploy Model Solutions Using the Deployment Wizard
    Define Semiadditive Behavior
    Define Time Intelligence
    Database permissions
    Deploy Model Solutions Using XMLA

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Hide or freeze columns
    Enable DirectQuery mode in SSDT
    Create a Calculated Column
    Version comparison
    Bi-directional cross filters  Calculations
    Delete Relationships
    Import data by using a native query
    Manage Roles by using SSMS
    Import from Power View
    Define partitions in DirectQuery models
    Create a Calculated Table
    Data sources supported in tabular 1400 models
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Tabular model designer
    Set the Data Type of a Column
    Add a table Delete a Table
    Impersonation
    Add sample data to DirectQuery models
    Specify Mark as Date Table for use with Time Intelligence

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Drillthrough in mobile reports
    Using Datasets Creating Paginated Reports
    Reporting services tools Reporting Services Data Sources
    Create a report using report builder or report designer.
    Topics include Introduction to Reporting Services
    Introduction to reporting services
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Reporting services components
    Report subscription and delivery Administering Reporting Services
    Schedules
    Extend reporting services functionality with external assemblies.
    Implementing report filters and parameters Visualizsng Data with Report Services
    Creating a report with the report wizard
    Publish a report to reporting services Working with Reporting Services Data
    Preparing data for mobile reports
    Work with expressions and embedded code.
    Formatting data
    Add a drillthrough to a custom URL
    Sorting and grouping
    Secure access to reports by using authentication, permissions, and SSL encryption.

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Oracle BI Architecture
    Filters View
    Variable References
    Warehouse Models and Schemas
    Saving and Reusing Filter Settings
    Legend View
    Column Formatting
    Pdf and Print Control
    Pivot Table Concepts
    Viewing Supplementary Content
    Downloading the Answers Report Formatting
    Customizing the Table View
    Narrative View
    Column Formulas Using Primary Views
    Controlling the Report Definition
    Managing the Views Using Secondary Views
    Ticker View
    Basic Navigation Using A Dashboard
    Creating a Dashboard
    Physical Data Models Data Warehousing and BI
    Sections and Pages

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Package Variables 
    The Cursor FOR Loop 
    The PL/SQL Execution Environment 
    Creating a Stored Function 
    The UTL_FILE Package 
    Nesting Blocks 
    Closing Cursors 
    Maintaining PL/SQL Code 
    Generating an Error 
    Cursor Parameters 
    Overloading Package Functions and Procedures 
    Record Variables 
    Stored Procedures and Functions
    User-Defined Exceptions 
    PL/SQL Syntax and Logic 
    Temporary LOBs 
    Triggers
    System Triggers 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Date Formats 
    Synonyms
    Choosing Rows with the WHERE Clause 
    SQL Functions 
    Sequences 
    Correlated Subqueries 
    SQL Queries - Joins 
    Grouping Rows 
    Relational Database and SQL Overview 
    The SQL Buffer 
    Defining Tables 
    Views 
    Loading Tables From External Sources 
    Outer Joins 
    Datatypes 
    Subqueries 
    The EXISTS Operator 
    Explicit Locking 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Reading from Arrays 
    How HTML Forms Work 
    Including Files 
    Form Processing 
    Start and End ( ^ $ ) 
    Adding a Header and Footer 
    Variable Types 
    A Database-less Login Form 
    preg_match() 
    Reusing Code and Writing Functions 
    Escape Character ( \ ) 
    PEAR:DB 
    By Reference vs. By Value 
    Session Functions 
    Variables 
    Shortcomings of mail() 
    Superglobal Arrays 
    Formatting Strings 
    mail() 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Slide masters
    Formatting text
    Adding shapes
    Using text in objects Working with graphics
    Running presentations
    Modifying text
    Transitions and timings
    Formatting paragraphs Using drawing objects
    Custom themes Using graphics and multimedia
    Interactive elements
    Building slides from Word outlines
    WordArt Pictures
    Rearranging and deleting slides
    Saving presentations
    Custom slide shows
    Broadcasting a slide show online Integrating Microsoft Office files
    Speaker notes
    Customizing SmartArt graphics
    Getting started
    Creating presentations

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Creating a basic presentation
    Editing efficiently Working with shapes
    Slide masters
    Customizing tables
    The PowerPoint interface Creating presentations
    Printing presentations
    Working with SmartArt graphics
    Action buttons
    Formatting text and lists
    Creating shapes
    Applying content to shapes Graphics
    Reviewing and finishing
    WordArt
    Media clips
    Distributing presentations
    Working with slides Editing slide content
    Animations
    Getting started
    SmartArt Preparing and printing presentations
    Pictures Tables and charts

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Modifying a Template
    Saving a Customised Theme
    Presentation
    Aligning Table Data
    Applying Colour Corrections
    Recolouring an Image
    Rotating and Flipping Images
    Creating Custom Theme Colours
    Resizing an Image
    Saving to a Storage Device
    Changing the Master Font
    Understanding Action Buttons
    Presenting a Slide Show Online
    Positioning an Image
    Enhancements
    Applying Multiple Effects
    Saving to OneDrive
    Working With PowerPoint Designer
    Understanding Templates
    Co-Authoring Documents
    Using Quick Layouts

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Brilliant Presentations
    Understanding Presentation Views
    Drawing Shapes
    Preparing for Presentations
    Reusing Slides
    The PowerPoint Screen
    Adding Shapes Before and After
    Inserting a SmartArt Graphic
    Adding Sections
    Opening a Presentation
    Using Tell Me
    Adding Shapes Below
    Using the Eyedropper
    Getting Help
    Converting Text to SmartArt
    Customising the Status Bar
    Creating a Presentation
    The Open Place
    Slide Shows

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Object positioning
    Catalog merge
    Text boxes
    Text box linking
    Table structure
    Finalizing and publishing a site
    The Publisher interface
    Mail merge and catalog merge
    Publisher Help
    Styles and font schemes
    Table basics
    Navigation and selection techniques
    Interactive forms
    The Graphics Manager pane
    Symbols and special characters
    Modifying form properties
    Typography
    Form letters

  • See Training Course Details...


Publisher 2013

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Inserting Headers
    Creating WordArt
    The Save As Place
    Picture Formatting And Effects
    Saving An Existing Publication
    Creating A Publication From A Template
    Inserting A Caption Working With Tables
    Creating Text Styles
    Opening An Existing Publication
    Text Columns
    Formatting Text
    Clearing A Filter Catalogue Merge
    Changing Margin Guides
    Cropping Pictures
    The Publisher 2013 Screen
    Modifying A Text Style Building Blocks
    Printing A Publication
    Applying Table Styles
    Previewing And Modifying A Catalogue Merge
    Deleting Shapes Working With Pictures
    Wrapping Text

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Publications
    Mail Merge
    Building Blocks
    Inserting a Caption
    Understanding Page Sizes
    Sorting a Merge
    Selecting Shapes
    Modifying a Text Box
    Working With Shapes
    Moving Shapes
    Creating Bulleted Lists
    Using a Master Page
    Modifying a Text Style
    Aligning Text
    Text Columns
    Using the Ribbon
    Cropping Pictures
    Formatting WordArt

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Creating Stored Procedures 
    Aggregate Functions
    Calculated Fields
    DELETE   
    Creating Tables
    Views  
    Adding and Dropping Columns
    WHERE and ORDER BY  
    The LIKE Operator   
    The IN Operator 
    Dropping Stored Procedures
    Primary Keys
    Selecting Specific Columns
    Common Date Functions  Subqueries, Joins and Unions
    CASE syntax
    Tables 
    Selecting Distinct Records
    Common String Functions
    Popular Databases  

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Entities
    Using the Reporting Services 2005 Graphical Query Designer
    Data Source Properties
    General
    Adding Fields to the Table Data Region
    Design Area
    Adding Reporting Services 2005 Users
    Create a Dataset
    Report Item Style Properties
    Shared Schedules
    Report Design Options
    Entity and Field Folders
    Choose the Table Layout
    Reporting Services 2005 Toolbars
    Reporting Services 2005 Security
    Parameters
    Static Subscription
    Model Statistics
    Reporting Services 2005 Data Processing Extensions
    Filters
    Reporting Services 2005 Security Model Concepts

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Introducing SQL Server Reporting Services
    Creating Matrix Reports and Charts
    Discover the many application programming interfaces of Reporting Services 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Security
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Managing Reporting Services
    Learn how to create custom functions using the Code window 
    Learn how to work with rich text to produce mail merge style reports 
    Snapshots and Subscriptions
    Investigate the scheduling of report snapshots 
    Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards 
    Explore the storing of credentials within a data source 
    Explore how to create expressions in your reports using 
    Find out how to use Report Manager to manage user accounts and roles 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Learn about report variables and when you might need to use them 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Troubleshoot Package Failures Deploying Packages
    Secure Databases Working with MDS and Windows Azure
    Work with MDS Databases
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Add Data Flow Components to a Data Flow Task
    Perform Transformation Tasks
    Configure MDS
    Create Dimensions
    Deploy SSIS Packages
    Create Expressions with Variables
    Overview of Data Warehouses
    Debug Package Execution Components
    Create Package Templates Implementing Data Flow
    Examine Data Warehousing Concepts
    Introduction to Data Warehouses
    Add Script Tasks and Script Components to an SSIS Package
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Securing Packages and Databases
    Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
    Execute Packages from Different Control Flow Working with Dynamic Variables

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Midlands
  • 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 ...
  • No Data Rows
    Interactive Sorting
    Report Builder vs. Report Designer
    Building a Report with Report Builder
    Groups before Row Headers
    Report Project Files and Folders
    Create a Shared Data Source and Two Data Sets
    The Tablix Properties Dialogue Box
    Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Creating Report Parameters
    Create a Matrix Report
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Create a Report with Interactive Sorting Dynamic Reports with Parameters
    Setting Report Project Properties
    Create A Shared DataSet for Northwind
    Native Mode Architecture
    Globals Collection
    Overview
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Group and Aggregate Data Programming in T-SQL
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Manage Triggers
    Combine Data Using Simple Joins
    Modifying Data
    Update Data
    Create Queries Using Built-in Functions
    Getting Started with SQL Server 2012
    Work with Set Operators
    Work with Grouping Sets Managing Error Handling and Transactions
    Work with SSMS Working with T-SQL
    Configure User-Defined Functions (UDF)
    Work with the XML Data Type Sorting and Filtering Data
    Create Queries Using Join Algorithms
    Manage Views
    Work with System Catalog Views Optimizing Query Performance
    Work with PIVOT and UNPIVOT
    Work with Window Functions
    Insert Data
    Work with Predicates
    Work with Date and Time Data Types

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Working with text
    Working with Web-enabling features
    Printing diagrams
    Block, tree, and onion diagrams
    Templates
    Editing objects
    Manipulating objects
    Manipulating stencils
    Custom stencils
    Documenting software systems
    Dimensioning
    Organization charts
    Database model diagrams
    Integration with Microsoft Outlook
    Working with links
    The Visio environment
    Custom properties
    Flowcharts

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Special drawing operations
    Organization charts
    Custom themes
    Formatting shapes and lines Working with pages
    Working with background pages
    Planning a diagram
    Web site maps Integrating Visio with other programs
    Reporting
    Shape behaviors
    Flowcharts
    Block, tree, and onion diagrams
    Documenting software systems
    Integration with Microsoft Outlook
    Working with Web-enabling features Software and database diagrams
    Editing objects Basic diagrams
    Integration with PowerPoint
    Brainstorming diagrams Customization and reporting
    Formatting text
    Working with text
    The Visio 2010 interface

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Drawing scales
    Database model diagrams
    Getting started
    Network and brainstorming diagrams
    Formatting text
    Block, tree, and onion diagrams
    The start page
    Formatting drawings
    Custom themes
    Drawing tools
    Web site maps
    Windows, stencils, and objects
    Software and database diagrams
    Custom shapes and stencils
    Flowcharts
    Organization charts
    Integration with Microsoft Word

  • See Training Course Details...


Word 2010 Advanced

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Displaying The Developer Tab
    Building Blocks
    Understanding Macros In Word
    Importing Text
    Inserting A Blank Cover Page
    Understanding PDF
    Inserting A Watermark
    Keeping Lines Together
    Inserting A Document Information Field
    Importing
    Viewing A PDF File Text Boxes
    Understanding Text Boxes
    Understanding Templates
    Updating Formulas In A Table
    Understanding Lists
    Setting Macro Security
    Inserting A Hyperlink To External Data

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Footers
    Inserting A Drawing Canvas
    Footers
    Understanding How Help Works
    Understanding Font Formatting
    Understanding Paragraph
    Understanding Dialog Boxes
    Using Click And Type
    Drawing Shapes
    Techniques For Selecting Text
    Deleting Text
    Template
    Page Zooming
    Documents
    Creating Documents In Word
    Minimising The Ribbon
    Saving An Existing Document

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Working with text
    Printing and exporting documents
    Examining formatting
    Graphics
    Table design options
    Working with graphics Styles and outlines
    AutoCorrect
    Creating tables
    The Word window
    Adding graphics and clip art
    Headers and footers
    The Undo and Redo commands
    Paragraph formatting
    Working with table content
    Table data Page layout
    Spelling and grammar
    Getting started
    Find and replace Formatting text
    New documents
    Working with styles

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Using Go To
    Adding Data to a Table
    Choosing a Table Style
    Inserting Page Numbers
    Selecting a Printer
    Setting Tab Leaders
    Accessing the Help Window
    Starting a Numbered List
    Highlighting Text
    Setting Custom Margins
    Resetting Pictures
    Understanding Font Formatting Tools
    Safely Closing a Document
    Removing Tabs
    Changing Page Orientation
    NFOCUS COURSEWARE
    Your First Document
    Applying Borders to Paragraphs
    Changing the Picture
    Changing Text Alignments
    Making Basic Changes

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Midlands
  • 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 and Formatting Text
    Inserting Hard and Soft Returns
    Resizing a Text Box
    Understanding Templates
    Personalising Word
    Converting a Table to Text
    Applying 3D Rotation Effects
    Displaying Table Gridlines
    Opening Multiple Documents
    Applying Reflection Effects
    Removing a Picture Background
    Mail Merge Recipient Lists
    Headers and Footers in Long
    Style Techniques
    Sorting Recipients
    Footers

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Midlands
  • 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 ...
  • AutoText Versus Quick Parts
    Resizing SmartArt
    Understanding Master Documents
    Indexing
    Creating the Form Layout
    Working With Formatting
    Cross Referencing
    Dictionary
    Activating Fields Automatically
    Bookmarks
    Printing a Master Document
    Recording a Macro
    Displaying the Developer Tab
    Dictionary
    Inserting Text
    Showing and Hiding Markup
    Running a Macro
    Advanced Tracking Options

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730