Enable Technology

SANDWELL TRAINING COURSES 

TRAINING COURSES SANDWELL




Adobe Dreamweaver CC

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Floating and Docking Panels
    Adobe Creative Cloud Application Manager
    Understanding the New Document Dialog Box
    Creating a Custom Workspace
    Installing Adobe Bridge
    Using Adjustment Presets
    Understanding Images and Accessibility
    Understanding 3D in Photoshop
    Using Levels to Improve Contrast
    Understanding Website Coding
    Understanding the CSS Designer Panel
    Converting Line Breaks
    Managing Files and Folders
    Understanding Selecting Text
    Opening Images in Camera Raw
    Adobe Photoshop Mobile Applications
    Understanding the Document Window
    Using Online Help
    Preferences Dialog Box

  • See Training Course Details...


Adobe Illustrator CC

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Creating a New Pattern
    Understanding Colour Controls
    Applying the Outer Glow Effect
    Viewing and Hiding the Grid
    Understanding the Tools Panel
    Reshape Objects Using Envelopes
    Understanding Artboards
    Blending Shapes
    Wrapping Text Around an Object
    Colour, Fill and Stroke
    Moving Objects
    Inserting and Formatting Area Type
    Threading Text
    Grouping Layers
    Working With Workspaces
    Applying Pathfinder Effects
    Working With Options for Path Type
    Understanding Vector Graphics

  • See Training Course Details...


Adobe InDesign CC

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Opening an Existing Document
    Creating Frames and Shapes
    Applying a Master Page
    Assigning Objects to Layers
    Understanding Adobe Colour CC
    Working With Workspaces
    Interactive Objects
    The Find Change Dialog Box
    Using Keyboard Shortcuts
    Applying Text Wrap
    Setting Drop Caps
    Placing InLine Graphics
    Linking and Unlinking Files
    Applying a Fill Colour
    Creating a Colour Group
    Using Selection Tools
    Understanding Behance Creative Cloud Libraries
    Creating a Snippet
    Merging Shapes Using Pathfinder
    Understanding Styles
    Inserting a Table of Contents

  • See Training Course Details...


Adobe Photoshop CC

  • 2 day course
  • Location: Sandwell
  • 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 3D Concepts
    Organising Images in Bridge
    Working With Views in Bridge
    Using the Quick Selection Tool
    Investigating New Features
    Creating and Applying Character Styles
    Understanding Printing Marks
    Understanding the Preferences Dialog Box
    The Adobe Website
    Adobe Creative Cloud Application Manager
    Understanding Image Size Versus Resolution
    Flipping and Rotating Images
    Adding Images to Layers
    Selecting With Colour Range
    Understanding File Formats
    Understanding File Size
    Signing in to Your Adobe Account
    Using Adjustment Presets
    Adding Assets to the Libraries Panel

  • See Training Course Details...


ASP.NET Core MVC

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Action Attributes
    Dynamic Output ASP.NET MVC Architecture
    NuGet Package Manager
    Updating an Application on Azure 
    Parameters in Routing
    Unit Testing Getting Started with ASP.NET Core MVC
    Representational State Transfer
    Form Submission
    ASP.NET Core MVC Testbed
    Considerations in Using ASP.NET MVC
    Validation Attributes Routing
    The View in ASP.NET MVC
    Using XML Serialization
    Review of ASP.NET Web Forms
    Introduction to ASP.NET Core MVC
    Using Postman
    Using Visual Studio
    Routing in ASP.NET Core MVC
    Microsoft Technologies for Model Persistence
    The Controller in ASP.NET MVC
    What Is Windows Azure?

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • The Calendar Control 
    LINQ 
    Language Integrated Query 
    Introducing Data Source Controls 
    Custom Data Visualizers 
    Accessing Data 
    Debugging Client-Side JavaScript 
    Site Navigation 
    Managing Users with ASP.NET's Membership Features 
    Using Rich Server Controls 
    Site Navigation Controls 
    Reading and Write Data Using the SqlDataSource Control 
    Programming Configuration Files 
    Encrypting Configuration Sections 
    ASP.NET Web Applications 
    HyperLink and Button Controls 
    LINQ Syntax 
    Writing Code to Interact with Membership and Roles 

  • See Training Course Details...


ASP.NET using VB.NET

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Storing Session State in SQL Server 
    Using Rich Server Controls 
    Server Debugging 
    Custom Data Visualizers 
    Executing Commands 
    Site Navigation Controls 
    Client-Side and Advanced Debugging 
    Data Binding in ASP.NET 
    Deleting a Row and Handling Errors 
    Themes and Master Pages 
    LINQ to SQL 
    Introduction to Web Controls 
    Managing Users with ASP.NET's Membership Features 
    Security Trimming 
    Displaying and Editing Middle-Tier Data using the ObjectDataSource Control 
    List Controls 
    Language Integrated Query 
    Investigating Styles 
    Using the Visual Debugger 

  • See Training Course Details...


Crystal Reports 2008

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Browsing Field Data 
    Using a Variable in a Formula
    Variable Scope
    Starting a New Report 
    When and Why to Group Records 
    Reordering Groups 
    Creating String Formulas 
    Additional Summary Options 
    Creating Custom Groups
    Group Sorting with a Parameter
    Using a Parameter Field
    Learning about Linking 
    Sorting with a Parameter
    Grouping and Sorting Data 
    Combining Multiple Tables 
    Selecting and Sizing Objects 
    Prompting with Parameters

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Understanding the Formula Evaluation 
    Formatting Features 
    Creating a Simple Report 
    Grouping Hierarchically
    Formatting Individual Cells
    Saving the Report 
    Customizing Group Sort Order
    Refreshing the Data 
    Database Links versus Subreports in One-to-Many Situations
    Exploring the Toolbars 
    Inserting Special Fields
    Understanding Tables, Records, and Fields 
    Applying the Drill Down Feature 
    Creating Report Alerts
    Customize Group Name Field 
    Using Multiple Parameter Fields in Reports
    Window 
    Processes the Data
    Database Filtering with the Select Expert 
    Parameter Fields Overview

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Exporting to a Report Definition Format Using the Report Wizards
    The Chart Dialog Box
    Formatting Sections
    Creating Text Objects
    Formatting Sections Conditionally
    Adding Fields into a Text Object
    Using a Parameter Field
    Reordering Groups
    Editing Charts
    Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
    Creating String Formulas
    Formatting Objects
    Modifying Individual Objects in the Chart
    Group and Sort Direction
    The Formula Editor Toolbar
    Using the Group Tree to Navigate the Report
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Managing Resources with Explorers
    Charting Cross Tabs
    Understanding Crystal Formula Syntax
    Creating Boolean (True/False) Formulas

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Editing Charts
    Adding Fields into a Text Object
    Refreshing the Data
    Creating Running Totals for a List of Numbers
    Modifying Groups
    Getting Help Formatting Features
    Creating an Unlinked Subreport
    The Fields Dialog Box
    Drawing a Line
    Variable Scope
    Browsing Field Data
    Previewing the Report
    Using Parameters in Conditional Formatting
    Separating Statements in Complex Formulas
    Using Evaluation Time Functions
    Using a Parameter to Select Records
    Understanding the Formula Evaluation Subreports
    Using Multiple Parameter Fields in Reports
    Importing a Pick List
    Understanding Tables, Records, and Fields
    Creating a Group

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Sandwell
  • 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 a Group
    The Chart Dialog Box
    Conditionally Formatting Multiple Sections Using the Running Totals Feature
    Format Painter
    What Is a Pass
    Applying the Drill Down Feature
    Creating Boolean (True/False) Formulas
    Conditional Running Totals Prompting with Parameters
    Creating Hyperlinks
    Understanding How Cross-Tabs Affect Your Data
    Creating Multiple Groups in a Report
    Formatting Template Fields
    Applying Chart Templates Exporting Your Reports Within Your Organization
    Modifying Individual Objects in the Chart
    Inserting Special Fields Selecting Specific Records From the Database
    The Summaries Dialog Box
    Hiding and Suppressing Sections
    The Workbench Creating a Simple Report
    Creating a Cross-Tab Report
    Create a Report Using the Standard Report Creation Wizard
    The Main Components of the Design Window

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Fonts on the Web
    Embedding Media
    Rounded Corners
    The History of CSS
    Negation Pseudo-Class
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Browser Support
    The @font-face Rule
    Attribute Selectors
    Transitions Layout: Columns and Flexible Box
    Box Shadow Transitions, Transforms, and Animations
    Font Services
    Frameworks and Grid Systems
    Flexible Box Model Vendor Prefixes
    The Target Pseudo-Class
    HTML5 Selectors and Pseudo Classes

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Data Mining Concepts
    Exploring Data
    Cross Validation
    Connection
    Model Usage
    Cross Validation
    Data Source
    Visio Data Mining Add-In  
    Microsoft Logistic Regression Algorithm
    The Mining Model Prediction Tab
    Excel PowerPivot Data Mining Add-ins
    Microsoft Neural Network Algorithm
    Microsoft Linear Regression Algorithm
    Concepts and Terminology
    Microsoft Time Series Algorithm
    Microsoft Sequence Clustering Algorithm
    Microsoft Naïve Bayes Algorithm
    Compare Mining Structures
    Data View
    Named Calculation

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Video Formats
    Local Storage
    Supported Platforms
    Consolidating the Web with Native Extensions
    Flexible Images and Other Media
    A First Look at Foundation
    Integrating with the Home Screen
    Flexible Images and Other Media
    Building Responsive Sites
    Controlling the Video through JavaScript
    Flexible Background Images
    Handling Orientation Change
    Hiding Browser UI
    Framework: Foundation
    Hosting Your Own Videos
    Designing for Mobile Devices
    HTML5: Mobile Specific

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Removing Invalid Circles
    Understanding Types of Controls
    Setting the Default File Location
    Adding a List Box Control
    Importing From an Earlier Version
    Using Subtotals With AutoFilter
    Defining the PivotTable Structure
    Exporting to Microsoft Word
    Sharing Workbooks via the Network
    Understanding Excel Macros
    Opening Shared Workbooks
    Circling Invalid Data
    Sharing Workbooks via OneDrive
    Importing Tab Delimited Text
    Updating Links Between Workbooks Grouping and Outlining
    Creating a Number Range Validation
    Assigning a Macro to the Toolbar
    Deleting a Macro
    Importing Space Delimited Text
    Navigating Worksheet Comments
    Creating a One-Variable Table

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Exiting Safely From Excel Creating a New Workbook
    Applying General Formatting
    Changing Font Colours
    Creating a New Chart From Scratch
    Editing Formulas
    Changing the Chart Type
    Performing a Numerical Sort
    Specifying the Number of Copies
    Inserting Columns Into a Worksheet
    Previewing Before You Print
    Opening an Existing Workbook
    Understanding Cells and Ranges
    Finding a Minimum Value
    Navigating Using the Keyboard
    Filling a Series
    Approximating Column Widths
    Formatting as Fractions
    Understanding Number Formatting
    Selecting Non Contiguous Ranges
    Worksheet Zooming
    Setting Precise Columns Widths

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Workbook
    Changing Individual Bar Colours
    Repositioning the Legend
    Freezing Rows and Columns
    Key Worksheet Functions
    Understanding the Format Pane
    Formatting Calculated Time
    Working With Table Styles
    Understanding Goal Seeking
    Quick Charting
    Customising the Display of Negative
    Drawing a Border Grid
    Exploding Pie Slices
    Understanding Chart Formatting
    The CHOOSE Function
    The NOW Function
    Creating Names From a Selection
    Colouring the Chart Background
    Custom Formatting Large Numbers
    Formulas
    Grouping Worksheets

  • See Training Course Details...


Excel Power Pivot

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

  • Some of the training topics covered include ...
  • Power Pivot
    Adding Power View to the Ribbon
    Viewing and Editing a Tour
    Tiling Data in Power View
    Understanding Power View
    Creating a Concatenated Field
    Editing Query Steps
    Adding Titles and Images
    Working With the Data Model
    Working With Scene Options
    Working With Measure Fields
    Understanding Relational Data
    Enabling Power View
    Working With Data Model Fields
    Working With Merged Queries
    Working With Mapping Confidence
    Exporting a Tour as a Video
    Changing a Power Pivot View
    Displaying the Query Editor
    Adding a Data Column
    Creating a New Query From a File

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Sandwell
  • 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 Debugging Tools
    Controlling Program Execution
    Declaring and Using Object Variables
    Understanding Error Handling
    Using Expressions, Variables, and Intrinsic Functions
    Navigating the Excel Object Hierarchy
    Creating a Function Procedure
    Working with the Command Button Control
    Working with Control Appearance
    Working with Inline Error Handling
    Using the Object Browser
    Setting Control Properties in the Properties Window
    Understanding Modules
    Understanding Errors
    Declaring Variables
    Working with the Text Box Control
    Understanding Control-of-Flow Structures
    Using the Toolbox
    Understanding the Development Environment
    Debugging Code
    Stepping through Code

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • ActionScript Events 
    Declaring and Using Variables 
    Creating a High Score List 
    Loops and Conditional Logic 
    Using the Tween Class 
    Accessing External XML Documents 
    Adding Methods to a Class 
    Types of Loops 
    Operators and Expressions 
    Working with MovieClip Methods 
    Determine when the SpaceShip Crashes 
    Use Cos and Sin to maneuver the Space Ship and Create Random Asteroids 
    Creating a Custom Class 
    Copy and Paste Tweens 
    ActionScript Fundamentals 
    Getting Started with Coding 
    Exploring the ActionScript Class Library 
    Determine When Objects Overlap or Hit 
    XML with EX 
    Using the EX Operators 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Writing Database Records To A Google Spreadsheet
    Native And Host Objects
    Building A Data Entry Form
    Object Hierarchies
    JDBC Overview
    Built-in Versus User-Defined Functions
    Date Functions
    GmailApp
    Layout and Panels
    Google Apps Scripting
    Database Metadata
    Creating And Removing Files And Folders
    Connecting To The MySQL Database
    Practical Examples Using Spreadsheet And Sheet Objects The Range Object
    Named Ranges
    The Data Range Of A Sheet
    A Data Entry Form
    Executing Code User Defined Functions
    Introducing JavaScript Functions
    My SQL Preliminaries
    Adding Files To And Removing Files From Folders

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Class Selectors
    Breaks and Horizontal Rules
    Empty vs. Container Tags
    Unordered Lists
    TheElement TheElement
    Default Pages
    Inches (in), Centimeters (cm), and Millimeters (mm)
    Creating Tables
    CSS Rules
    DOCTYPE Declarations
    Formatting Elements
    Select Menus
    Getting Started
    The HTML Skeleton
    Checkboxes
    Whitespace
    CSS Comments
    Text Fields
    HTML Links
    ID Selectors

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Browser Support
    datalist
    Prefixing your Keys
    Sectioning
    drawImage() - Basic
    Offline Application API
    min, max, and step attributes
    Drawing Lines
    The HTML 4 Way
    Additional Changes
    The New More Flexible Approach of HTML5 - Paving the Cowpaths
    Local Storage
    Audio Formats
    Page Simplification
    Dealing with Non-Supporting Browsers
    The HTML5 Spec(s)
    Accessibility
    The HTML5 Way

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Returning Values from Functions
    Passing Values to Functions
    Built-In JavaScript Objects
    Dot Notation
    while Loop Syntax
    Basic Rules
    Conditionals and Loops
    A Loosely-typed Language
    Switch / Case
    Conditionals
    Validating a Registration Form
    Associative Arrays
    Array Properties and Methods
    Image Rollovers
    if - else if - else Conditions
    Storing User-Entered Data
    Function Syntax

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Sandwell
  • 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
    jQuery.fx.off
    The Object Literal
    Using CSS Classes for Styling
    Custom Effects with $.fn.animate
    Specificity
    The for Loop
    Working with Selections
    Selecting Elements
    Keep Things DRY
    Writing Plugins
    Data Methods
    Avoiding Conflicts with Other Libraries
    Inside the Event Handling Function
    Basic Operators
    Traversing
    Using Functions
    Saving Selections
    Ajax and Forms

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Dialogs
    plugin Architecture
    Dialogs Widgets and UI
    Video The Theme Framework
    Levels of Support
    Buttons and Linking Pages
    Collapsible Blocks Events
    Using Others' Plugins
    Basic Page Template
    HTML5 and CSS3 Getting Started with jQuery
    Creating Your Own Plugin
    Overview
    Sending Emails
    Hosting vs. CDN
    Themes and Swatches
    What Is jQuery Mobile?
    Sliders

  • See Training Course Details...


Microsoft Access 2007

  • 2 day course
  • Location: Sandwell
  • 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 combo boxes
    Writing SQL statements
    Charts in forms
    Adding Graphics
    Creating macros that require user input
    Database normalization
    Creating macros for data transfer Importing, exporting, and linking
    Finding and editing records
    Modifying query results and queries
    Adding calculated values
    Charts in reports PivotTables and PivotCharts
    Summarizing and grouping values Advanced form design
    Importing objects
    Working with input masks
    Attaching SQL queries to controls Advanced queries
    Performing operations in queries Using forms
    Creating tables Fields and records
    Exploring tables
    Modifying PivotTables
    Setting field properties

  • See Training Course Details...


Microsoft Access 2010

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

  • Some of the training topics covered include ...
  • Creating forms
    Linking Access objects
    Using calculated fields
    Attaching macros to the events of database objects Advanced macros
    Subdatasheets
    Exporting objects
    Creating reports
    Labels Charts
    Creating crosstab queries
    Organizing records Data entry rules
    Hyperlink fields Database management
    Getting started
    Performing operations in queries Using forms
    Summarizing and grouping values Advanced form design
    Modifying query results and queries
    Importing, exporting, and linking
    Calculated values
    Creating lookup fields
    Complex queries
    Writing SQL statements
    Adding calculated values

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • SQL and Access
    Sorting and filtering records Working with reports
    Getting started
    Setting options and properties  
    Setting field properties
    Using hyperlink fields Database management
    Using Design view
    Writing SQL statements
    Attaching macros to the events of database objects Advanced macros
    Changing the design of a table
    Printing
    Modifying and printing reports Relational databases
    Exporting objects
    Database normalization
    Importing objects
    Summarizing and grouping values Advanced form design
    Referential integrity Related tables
    Creating macros for data transfer Importing, exporting, and linking objects
    Creating macros to provide user interaction
    Modifying query results and queries
    Working with XML documents

  • See Training Course Details...


Microsoft Access 2016

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

  • Some of the training topics covered include ...
  • Creating and Using Forms
    Getting to Know Access 2016
    Creating a Lookup Database
    Adding Records to a Table
    Formatting Tables
    Understanding VBA
    Importing and Exporting Records
    Calculations in Queries
    Modifying Table Structures
    Macro Techniques
    An Introduction to VBA
    Parameter Queries
    Working With Records
    Navigation Pane Protection
    Aggregation Queries
    Macros on Forms
    Database Wellness
    Setting Table Relationships
    Using a Navigation Form
    Creating a Relational Database
    Database Security

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Using the If...End If Decision Structures
    Understanding Classes and Objects
    Using the Object Browser
    Working with Events
    Working with Methods
    Understanding Expressions and Statements
    Introduction to Programming in Access
    Using the Immediate Window to Call Procedures
    Trapping Errors with the On Error Statement
    Understanding Constants
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Objects
    Navigating the Access Object Hierarchy
    Understanding the Err Object
    Using Debugging Tools
    Debugging Code
    Understanding Modules
    Working with the Code Editor

  • See Training Course Details...


Microsoft Excel Power Query

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

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Power BI

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Power BI desktop queries
    Use Power BI direct connectivity to access data in Azure SQL data warehouse
    Using databases as a data source for Power BI
    Importing data into Power BI
    Connecting to Power BI data
    Viewing reports from Excel files Shaping and Combining Data
    Overview of the Power BI Data Model. Using Power BI
    Direct connectivity from the Power BI service
    Create relationships between data tables.
    The developer API
    Combine data together from tables in your dataset. Modeling data
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Direct connectivity from Power BI desktop
    Managing a Power BI solution
    Using Excel as a data source for Power BI
    Custom visuals Power BI mobile app
    Creating Power BI reports
    Power BI embedded
    Importing different data sources into Power BI
    Using the Power BI mobile app

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Using Cards
    Aggregations
    Filter data.
    Topics include –
    Understanding Aggregations
    Drill Through
    Utilizing Matrix
    Importing Data with a Query
    Utilize themes.
    Perform data cleaning.
    Perspectives Power Query
    Creating Relationships
    Navigate the Power BI interface.
    Visualizing Power View Reports
    Manage modifications.
    Introduction to the PowerPivot Interface
    Add time to a presentation.
    Introduction to Power BI
    PowerPivot

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Modifying a task list
    Working with resource costs Working with views and tables
    Working with project files
    Printing views and reports
    Updating the progress of tasks
    Communicating among a project team
    Sharing resources across projects Project communications
    Creating a task list
    Tracking project work
    Working with views
    Resolving resource conflicts
    Setting up task links
    Working with advanced task options Managing resources
    Working with groups
    Working in Network Diagram view
    Project management concepts
    Creating a Work Breakdown Structure Scheduling tasks
    Getting started
    Observing project progress Analyzing and adjusting the plan
    Importing data
    Copying data

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Creating a task list
    Project files
    Working with templates Creating projects from other programs
    Modifying a task list Task scheduling
    Collaboration
    The base calendar
    Managing a project
    Handling resource conflicts Using templates and importing data
    Customizing Project
    Working with views
    Finalizing schedules
    Hyperlinks
    Gantt chart formatting
    Standard reports Visual reports  
    Consolidating and sharing projects
    Exporting to Office applications
    Custom views
    Filters Groups Sorting tasks and resources Finalizing the task plan
     Setting baselines
     Macros

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Handling resource conflicts
    Views and tables
    The base calendar
    Setting baselines
    Project files Tasks
    Getting started
    Creating projects from other programs Managing a project
    Filters
    Team Planner view Working with reports
    Monitoring progress
    Finalizing schedules
    Task relationships
    Consolidating and sharing projects
    Task links
    Updating an active project
    Task options Resource management
    Custom fields Managing multiple projects
    Using templates and importing data

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Sandwell
  • 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 Resources
    Understanding Constraints and
    Choosing Fields to Display in a Visual
    Inserting Custom Fields
    Adding Simple Custom Fields
    Working With a Resource Master Downsizing Larger Projects
    Entering Material Resources
    Tasks and Resources
    Getting to Know Project 2016
    Assigning Calendars to Resources
    Preparing for the Custom View
    Understanding Project Downsizing
    Placing Printing Commands on the
    Using Google to Get Help
    Working With Views
    Working With the Standard Views
    How Project 2016 Works
    Understanding Project VBA
    Assigning Resources You Do Not
    Printing Footers

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Understanding Effort Driven
    Working With Effort Driven Tasks
    Creating a New Resource Calendar
    Making Multiple Assignments
    Setting Up Project Information
    Printing Resources for Tasks Getting Help
    Modifying a Schedule Using
    Case Study Tasks
    Understanding the QAT
    Entering Cost Resources
    Assigning Resources in Task
    Creating Dependencies in a Sheet
    Working With Gantt Charts
    Working With Fixed Unit Tasks
    Reviewing the Project
    Problem Assignments
    Other Sources of Assistance
    Understanding Resource Availability
    Creating Summary Tasks
    Understanding Tasks

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Working With Multiple Files
    Understanding Project Views
    Changing Text Styles
    Reviewing Current Costs
    Tracking Down Over Allocations
    Assigning Fixed Costs
    Creating Resource Problems
    Rescheduling Tasks
    Using Custom Views
    Using Elapsed Time
    Hiding Open Files Tables
    Assigning Variable Usage Material
    Assigning Fixed Material
    Placing Printing Commands on the
    Exploring Tables
    Changing Rates During a Project
    Moving a Project’s Start Date Project Tracking
    Highlighting Date Ranges
    Basic Data Highlighting
    Resources

  • See Training Course Details...


Microsoft Project 2016 Level 3

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

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

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

  • Some of the training topics covered include ...
  • Exporting to Microsoft Excel
    Creating a Common Resource Pool
    Creating the Downsized Master File
    Applications
    Editing a Macro
    Understanding Custom Fields
    Using the Personal Template Folder
    Understanding Visual Reports
    Creating the Resource File
    Specifying the Personal Templates
    Altering Tasks With Custom WBS
    How Graphical Reports Work
    Creating the Custom View
    Working With a Contact Resource
    Creating a Custom Filter for the View
    Formatting Chart Objects
    Using a Custom Visual Report
    Organising the Global Template
    Managing Shared Resources
    Creating a Formula in a Custom Field

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Security - roles and permissions 
    Using SSAS in BIDS
    Example cube as seen using Excel pivot table 
    Cube processing options 
    Other Documentation methods 
    Welcome to the Real Time - Proactive Caching 
    MS BI is comprehensive - more than Analysis Services on SQL Server 
    Actions - regular, drill-through and reporting 
    Disaster Recovery - backup / restore 
    Data Mining clients 
    Intermediate MDX 
    Partitions - relational and Analysis Services partitions 
    New MDX functions 
    Refining Dimensions and Measures in BIDS 
    Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 
    Cube Storage and Aggregation 
    Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Configurations and deployment 
    Managing packages with SQL Server Management Studio 
    Advanced Data Flow
    Precedence Constraints 
    Source Control for SSIS Packages 
    SSIS system variables 
    Development and Management Tools 
    Introduction to Data Flow
    Advanced Control Flow
    The Execute SQL Task 
    Built-in log providers 
    The Variables window 
    The Copy Column Transformation 
    The Send Mail Task 
    Executing packages – DTExec and DTExecUI 
    Variables and Configurations
    The Merge and Merge Join Transformations 
    Using variables to pass information between packages 
    Debugging , Error Handling and Logging

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Discover how to add .NET Assemblies
    Understand the Cube Structure
    Explore how to add MDX Script Commands
    Define Business Intelligence
    Review MDX Functions New to SSAS 2008
    What Is Microsoft Business Intelligence?
    Learn how to add Calculated Members
    View a Cube by using Excel
    Understand Performance Tuning and Optimization
    View a Cube by using SQL Reporting Services
    Deploy and Synchronize Databases
    Advanced Administration and Optimization
    Implement Proactive Caching
    Consider Data Mining Clients
    Understand Basic MDX Syntax
    Implement Excel 2007 Pivot Tables and Charts

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Overview of Control Flow in Integration Services 
    Configurations 
    A Guided Tour of Integration Services
    Data Flows
    Control Flow
    Using Variables and Configurations between Packages 
    Best Practices for Package Development and Design 
    Scripting in Data Flows with the Script Component 
    Working with Windows Management Instrumentation
    Installing a Package 
    Deployment and Management Best Practices 
    Package Management
    Scripting in Control Flows with the Script Task 
    Data Flow Best Practices 
    Exploring and Executing a Package Outside of BIDS 
    Working with Analysis Services 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Creating a Tabular Project
    Browsing the Model
    The Multidimensional Solution
    Analysis Services Installation and Architecture: One Product, Two Models
    Common Analysis Services Solutions
    Understanding Perspectives
    Deploying
    Processing Strategies
    Utilizing Translations
    Introduction to Microsoft SQL Server Analysis Services
    Understanding the Multidimensional Model
    Measures and Measure Groups
    Deploy a multidimensional model.
    Understanding the Tabular Model
    Examining Deployment Options
    Version Changes of SSAS from 2008-2014

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

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

  • Some of the training topics covered include ...
  • Overview of Containers
    Version Changes of SSIS From 2008-2012
    Managing with Control Flow
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    The SQL Server Integration Service
    Looping and Sequence Tasks
    Understanding Packages
    Creating Dynamic Packages
    Handling Errors Common SQL Server Integration Services Design Patterns
    Managing SQL with the SQL Tasks
    Utilizing Container Loops Performing Joins
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Optimizing Sources for Extraction
    Utilizing the Import/Export Wizard
    Using Destinations and Understanding choices
    Utilizing Data Preparation Tasks
    Designing to Troubleshoot: Using Precedence Constraints
    Working in the Explore Window
    Using Package Hierarchies: Parent Child
    Utilizing Sequences in a Container
    Data Loading with the Analysis Services Tasks

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Creating Subreports and Drillthrough Reports
    Using the List Object to Combine Other Items
    Utilizing Charts
    Formatting Reports
    Understanding HTML5 and Textboxes
    Exploring Subscriptions
    SQL Server 2016 Report Builder Graphics
    Examining Management
    SQL Server 2016 Report Builder Basic Reports
    Visualizing Your Company Report Templates
    Working with Datasets
    Examining Security
    Examining Parameters
    Understanding Variances Between SQL Versions
    Exploring Gauges
    Filtering, Grouping, and Sorting
    Utilizing Lists
    Utilizing Dynamic Headers and Footers

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Data Mining Concepts
    Create a Cross-Validation Report
    Browse a Model Using the Microsoft Neural Network Viewer
    Browse a Model Using the Microsoft Naive Bayes Viewer
    Manually Edit a Prediction Query
    Algorithms
    Deploy a Data Mining Solution to Previous Versions of SQL Server
    Drillthrough on Mining Structures Create Mining Models
    Change the Properties of a Mining Model
    Create a Content Query on a Mining Model
    SystemGetAccuracyResults
    Deployment of Data Mining Solutions
    Process a Mining Model
    Change the Time-out Value for Data Mining Queries Data Mining Projects
    SystemGetClusterCrossValidationResults
    Exclude a Column from a Mining Model
    Data Mining Model Viewers
    Using Nested Table Data as an Input for an Accuracy Chart Queries
    View or Change Modeling Flags
    View and Save the Results of a Prediction Query

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Define a Regular Relationship and Regular Relationship Properties
    Set Data Source Properties
    Add or Remove Tables or Views in a Data Source View
    Error Configuration Roles and Permissions
    Set Impersonation Options for a Data Source Connection
    Database permissions
    Overview of SSAS Multidimensional Modelling
    Explore Data in a Data Source View
    Cube or model permissions Process permissions
    Define Named Queries in a Data Source View
    Set Partition Storage
    Dimension permissions
    Attach and Detach Analysis Services Databases
    Backup and Restore of Analysis Services Databases
    Create Measures and Measure Groups
    Data Source object permissions
    Replace a Table or a Named Query in a Data Source View
    Define Attribute Relationships
    Backup Options Restore Options
    Authorizing access to objects and operations
    Deploy Analysis Services Projects

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Set the Data Type of a Column
    Tabular model designer
    Database Process Partitions in the Workspace Database Perspectives
    Change table, column
    Add a table Delete a Table
    Delete Relationships
    Data sources supported in SSAS tabular 2017
    Object-level security
    Add sample data to DirectQuery models
    Create and Manage Perspectives Translations Roles
    Import from Power View
    Bi-directional cross filters  Calculations
    Create and Manage Measures KPIs
    Create a Calculated Column
    Specify Mark as Date Table for use with Time Intelligence
    Create and Manage Roles
    Create a Relationship Between Two Tables
    Topics include- Overview of SSAS Tabular models

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Drilldown and drill through Sharing Reporting Services Reports
    Preparing data for mobile reports
    Creating a report with the report wizard
    Report parameters
    Report subscription and delivery Administering Reporting Services
    Publish a report to reporting services Working with Reporting Services Data
    Implementing report filters and parameters Visualizsng Data with Report Services
    Sorting and grouping
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Extend reporting services functionality with external assemblies.
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Drillthrough in mobile reports
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Schedules
    Reporting services tools Reporting Services Data Sources
    Work with expressions and embedded code.
    Databars, sparklines, indicators, gauges, and maps
    Configuring data access with report designer
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Use report services configuration manager to reconfigure SSRS servers.
    Data filters

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Totals within Pivot Tables Advanced Formatting
    Accessing The Presentation Catalog
    Managing Saved Content
    Using Dashboard Prompts
    Managing the Views Using Secondary Views
    Column Formulas Using Primary Views
    Saving and Reusing Filter Settings
    Column Selector View
    Creating a New Request
    Managing Presentation Catalog Objects Deploying Requests to Dashboards
    Customizing the Table View
    Understanding The Dashboard Interface
    Launch BI Presentation Services
    Legend View
    Defining the Pivot View
    Column Formatting
    Basic Navigation Using A Dashboard
    OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
    Warehouse Models and Schemas
    Logical Data Models
    About Database Technologies

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • PL/SQL Blocks and Programs 
    Maintaining PL/SQL Code 
    Dependencies and Validation 
    Privileges for Stored Programs 
    Subtypes 
    Closing Cursors 
    Scope and Name Resolution 
    Packages 
    Declaring Variables 
    Selecting into a Variable 
    PL/SQL Stored Program Compilation 
    The DBMS_LOB Package
    Collection Methods 
    BULK COLLECT Clause
    SQLCODE and SQLERRM 
    FOR UPDATE Cursors 
    The DBMS_UTILITY Package 
    Maintaining Triggers 
    Nesting Blocks 
    Conditional Statements CASE 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Other Database Objects 
    Graphical Clients 
    Correlated Subqueries 
    Date Functions 
    Numeric Functions 
    IN and BETWEEN 
    Grouping Rows 
    Modifying Table Definitions 
    Oracle Versioning and History 
    SQL Functions 
    Regular Expression Functions 
    The Aggregate Functions 
    Literal Values 
    Transaction Management 
    Data Definition and Control Statements 
    Using Oracle SQL*Plus 
    The EXISTS Operator 
    SQL Queries - Joins 
    The SQL Buffer 
    Oracle Pseudocolumns 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Array Manipulation Functions 
    Working with String Manipulation Functions 
    preg_replace() 
    Working with Conditions 
    mail() 
    Using PEAR DB 
    The php.ini File 
    Appending to an Array 
    Processing Form Input 
    Variable Types 
    Session Functions 
    PHP Tags 
    Configuring Sessions 
    Including Files 
    Number of Occurrences ( ? + * {} ) 
    Passing Variables via the Query String 
    require_once 
    Working with Associative Arrays 
    preg_match() 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Using text in objects Working with graphics
    Interactive elements
    Rearranging and deleting slides
    Broadcasting a slide show online Integrating Microsoft Office files
    Slide masters
    Formatting text
    Using slides from other presentations Formatting slides
    Getting help New presentations
    Embedding and linking content
    WordArt Pictures
    Distributing presentations
    Animations
    Printing presentations Customizing PowerPoint
    Using comments
    Saving presentations
    Adding shapes
    Diagrams Modifying presentations
    Modifying text
    Formatting paragraphs Using drawing objects
    Modifying objects

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Creating shapes
    Slide masters
    Slide masters and transitions
    Proofing presentations
    Applying content from a Word outline
    Formatting shapes
    WordArt
    Working with charts
    Creating a basic presentation
    Reviewing and finishing
    Printing presentations
    Formatting text and lists
    Action buttons
    Customizing PowerPoint
    Pictures Tables and charts
    Photo albums Customizing slide elements
    SmartArt Preparing and printing presentations
    Working with SmartArt graphics
    The PowerPoint interface Creating presentations
    Editing efficiently Working with shapes

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Sandwell
  • 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
    Presentation
    Animations and Transitions
    Changing the Master Font
    Rotating and Flipping Images
    Applying Motion Paths
    Removing an Image Background
    Saving a Custom Template
    Understanding Pictures
    Creating a Photo Album
    Inserting an Online Picture
    Understanding Animation
    Understanding Action Buttons
    Saving a Presentation as a PDF
    Resizing and Positioning a Table
    Understanding Chart Buttons
    Changing the Layout of Chart

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Slide Layouts
    Showing and Collapsing the Ribbon
    Previewing a Slide Show
    Inserting a Section Header Slide
    Changing the Office Theme
    Adding Shapes Before and After
    Customising the Status Bar
    Adding Shapes Above
    Opening Multiple Presentations
    Understanding Backstage View
    Previewing Slides
    Understanding Font Formatting
    Launching Dialog Boxes
    Using the Zoom Tool
    How Microsoft PowerPoint 2016
    Understanding Printing
    Aligning Objects Using Smart Guides
    Inserting New Slides
    Using Shortcut Menus

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Finalizing publications
    Layout and design techniques
    Working with text
    Publication output
    Table structure
    Modifying form properties
    Publication setup
    The Publisher interface
    Finalizing and publishing a site
    Table formatting
    Stacking and grouping objects
    Table basics
    The Graphics Manager pane
    Web site publishing
    Sections
    Editing Web forms
    Basic publications
    Symbols and special characters

  • See Training Course Details...


Publisher 2013

  • 1 day course
  • Location: Sandwell
  • 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 Data Source
    Using Baseline Guides
    Entering Text In A Table
    Inserting Pages
    Googling Help
    Using Font Schemes
    Printing A Publication
    Understanding Publisher 2013
    Using The Office Website
    Checking Spelling
    Previewing And Modifying A Catalogue Merge
    Zooming And Panning
    Formatting WordArt
    Navigating The Help Window
    Selecting Text
    Creating A Product List
    Opening An Existing Publication
    Swapping Pictures
    Working With Layouts
    Printing A Help Topic
    The Save As Place

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Printing a Publication
    Selecting a Merge Area Layout
    Using the Scratch Area
    Saving an Existing Publication
    Using Colour Schemes
    Formatting WordArt
    Creating a Fill Background
    Using Fills and Tints
    Mail Merge
    Entering Text in a Table
    Naming Pages
    Text Effects
    The Open Dialog Box
    Creating a Product List
    Aligning Text
    Understanding Master Pages
    Inserting Advertisements
    Adjusting Rows and Columns
    Master Pages
    Inserting Footers

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Calculated Fields
    Dropping Stored Procedures
    Concatenation
    Creating Tables
    Order of Evaluation   Advanced SELECTs    
    Relationships 
    Checking Multiple Conditions 
    Primary Keys
    Renaming Tables    
    Aggregate Functions
    Common Math Functions    
    Adding and Dropping Columns
    Multi-table Joins  
    Common String Functions
    Sorting By Column Position
    Data Types
    DELETE   

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Filters
    The Main Components of the Design Environment
    Table Data Region Record Sorting
    Getting Started Pane
    Security
    Displaying Parameters in a Report
    Understanding Security Settings
    Entity and Field Folders
    Report Server Components
    Creating a Chart Report
    The Toolbox
    Designing the Layout
    Reporting Services 2005 Security
    Parameters
    Deploying a Report Model
    Reporting Services 2005 Windows
    Creating a Report Model Project
    Usability Features
    Data Output

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Grouping and Sorting
    Investigate how to call a custom assembly from a report 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Programming Reporting Services
    Advanced Reporting Services Programming
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    Investigate what SQL Server Reporting Services can do 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Gain a basic understanding of the components behind SQL Server Reporting Services 
    Working with Parameters
    Discover how to add textboxes and other controls to reports 
    Dig into the use of unbound, multivalued, and cascading parameters 
    Learn how to calculate group totals and percentages 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Calculation and Formatting
    Explore the basic architecture of SQL Server Reporting Services 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

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

    The course requires a working knowledge of SQL.

  • Some of the training topics covered include ...
  • Create Dimensions
    Configure MDS
    Create Package Templates Implementing Data Flow
    Overview of Data Warehouse Components
    Configure the Package Execution Strategy
    Add Script Tasks and Script Components to an SSIS Package
    Create an SSIS Project
    Deploy SSIS Packages
    Secure Databases Working with MDS and Windows Azure
    Add Packages to an SSIS Project Managing Control Flow
    Install Integration Services Working with Integration Services
    Perform Transformation Tasks
    Cleanse Data Using DQS Managing SSIS Package Execution
    Execute SSIS Packages on the Server
    Examine MSI Packages
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Track Changed Data Managing Data Flow
    Examine Data Warehousing Concepts
    Deploy a Control Flow
    Introduction to Data Warehouses
    Profile OLTP Data

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Globals Collection
    Create A Shared DataSet for Northwind
    Writing and Using Report Expressions
    Creating a Columnar Report
    Shared Data Sources
    Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
    Groups before Row Headers
    Designing the Page Layout
    Variable Collection
    Tablix Cell Content and Scope Building a Tablix Report
    Page Headers and Footers Report Formatting Options
    Introduction to SQL Server Reporting Services
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Globals Collection Creating Custom Functions
    Building a Report with Report Builder
    Create a Tabular Report  Using the Tablix Report Type
    Parameters and Stored Procedures
    Report Definition Language (RDL)
    Create a Map Report
    Field Collection
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Sandwell
  • 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 Date and Time Data Types
    Manage Views
    Control Program Flow
    Modifying Data
    Group and Aggregate Data Programming in T-SQL
    Insert Data
    Delete Data
    Work with the XML Data Type Sorting and Filtering Data
    Merge Data Working with SQL Server Built-in Functions
    Work with Grouping Sets Managing Error Handling and Transactions
    Write SELECT Statements
    Work with System Catalog Views Optimizing Query Performance
    Overview of SQL Server
    Configure User-Defined Functions (UDF)
    Perform Advanced Filtering Querying Data from Multiple Tables
    Manage Query Plans
    Assign Aliases Using Queries
    Combine Data Using Simple Joins
    Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
    Manage SQL Server Constraints Writing SELECT Queries
    Manage Transactions Querying SQL Server System Metadata

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Custom properties
    Shape behavior and events
    Block, tree, and onion diagrams
    Integration with PowerPoint
    Basic shapes and lines
    Business diagrams and Web site mapping
    Visio basics
    Integration with Microsoft Word
    Network diagrams
    Editing objects
    Using windows and stencils
    Custom stencils
    Working with text
    Manipulating objects
    Organization charts
    Advanced Layout and connection techniques

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Windows, stencils, and objects Drawing tools
    Network diagrams
    Custom themes
    Brainstorming diagrams Customization and reporting
    Block, tree, and onion diagrams
    Flowcharts
    Displaying shape dimensions Custom themes and templates
    Special drawing operations
    Formatting text
    Rack diagrams
    Creating a basic diagram
    Custom templates Custom shapes and stencils
    Documenting software systems
    Working with links Network and brainstorming diagrams
    The Visio 2010 interface
    Editing objects Basic diagrams
    Shape properties
    Project management diagrams
    Organization charts Formatting drawings
    Reporting
    Basic shapes and lines

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Basic shapes and lines
    Creating a basic diagram
    Compound lines
    Brainstorming diagrams
    Documenting software systems
    Basic diagrams
    Project management diagrams
    File and print properties
     Shape behaviors
    Custom themes
    Working with Web-enabling features
    Flowcharts
    Database model diagrams
    Presenting diagrams in Visio and HTML
    Rack diagrams
    Working with links
    Custom themes and templates
    Organization charts
    The Visio 2013 interface

  • See Training Course Details...


Word 2010 Advanced

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Inserting A Document Information Field
    Creating A Table From Text
    Inserting A Building Block
    Using A Sample Template
    Applying A Theme
    Inserting A FILLIN Field
    Inserting A Table Of Contents
    Saving To PDF
    Downloading An Online Template
    Modifying Theme Colours
    Modifying A Bullet
    Creating Bookmarks
    Aligning Data In Cells
    Importing
    Inserting Subdocuments
    Creating A Recipient List

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Formatting
    Setting Custom Margins
    Using The Ribbon
    Understanding Shapes
    Understanding Tables
    Using Paste Special Multiple Documents
    Exiting Safely From Word Creating A New Document
    Template
    Navigating With The Keyboard
    Typing Text
    Saving A New Document
    Editing Text In Overtype Mode
    Documents
    Creating A Table
    Inserting A Blank Footer
    Opening Multiple Documents
    Typing Numbers
    Selecting Text Using The Mouse
    Understanding Font Formatting

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Sandwell
  • Course Outline
  • Some of the training topics covered include ...
  • Working with styles
    Working with outlines Proofing, printing, and exporting
    AutoCorrect
    Getting started
    Paragraph formatting
    Table design options
    Working with text
    Printing and exporting documents
    Paragraph spacing and indents Tables
    The Undo and Redo commands
    Creating tables
    Tab settings
    New documents
    Examining formatting
    Adding graphics and clip art
    The Word window
    Spelling and grammar
    Table data Page layout
    Changing the table structure
    Working with graphics Styles and outlines

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Adding Data to a Table
    Splitting the Window
    Understanding Find and Replace
    Changing Paper Sizing
    Selecting Text Using the Mouse
    Removing Existing Numbers
    Inserting a Picture
    Setting Custom Paper Sizes
    Modifying Borders
    Changing Page Margins
    Understanding Document Views
    Understanding Font Formatting Tools
    Viewing Gridlines
    Setting Bar Tabs
    Perfect Page Layouts
    Removing Tabs
    Setting Mixed Tabs
    Borders and Shading Dialog Box

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Header and Footer Techniques
    Changing Text Direction
    Understanding Picture
    Spacing
    Typing the Letter
    Arranging Shapes
    Typing Text Into a Text Box
    Editing a Recipient List
    Completing Mailing Labels
    Inserting a Drop Cap
    Inserting Different Odd and Even
    Viewing Advanced Properties
    Understanding Templates
    Repositioning Pictures

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Sandwell
  • 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 ...
  • Adding Words to the Custom
    Creating a Master Document
    Creating a MacroButton Field
    Deleting Cross-References
    Understanding Interactive Fields
    Document Proofing Features
    Co-Authoring Documents
    Understanding Master Documents
    Working With a Read Only Document
    Using AutoFormat as You Type
    Printing
    Stopping Document Protection
    Inserting Footnotes
    Using REF to Display Bookmarks
    Password
    Marking Index Entries
    Changes
    Accepting and Rejecting Changes
    Inserting a Drop Down List Control

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730