Enable Technology

DUDLEY TRAINING COURSES 

TRAINING COURSES DUDLEY




Adobe Dreamweaver CC

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Creating an Absolute Link
    Working With Libraries
    Opening Up Shadows
    Working With Camera Views
    Scaling, Skewing and Freeform Rotating Images
    Starting Dreamweaver From the Desktop
    Introduction to CSS Styles
    Understanding CSS Styles
    Understanding Camera Raw Panels
    Understanding Layouts
    Linking to an External Style Sheet
    Sorting and Filtering
    The Welcome Experience
    Getting to Know Dreamweaver
    Creating a PDF Presentation
    Creating a New Website
    Understanding Setting Up a Website
    Saving Layer Effects as a Style
    Understanding Views
    Editing a Smart Object in Illustrator
    Layer Effects

  • See Training Course Details...


Adobe Illustrator CC

  • 2 day course
  • Location: Dudley
  • 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 ...
  • The Adobe Capture Apps
    Reassigning Objects to Different Layers
    Understanding Effects
    Understanding Grids, Guides and Rulers
    The Illustrator Workspace
    Understanding Artboard Options
    Understanding Brush Libraries
    Rearranging Layers
    Inserting and Formatting Area Type
    Changing Colours in a Gradient
    Creating Lines and Spirals
    Understanding Layers and Sublayers
    Creating a Folder in Creative Cloud
    Using Offset Path
    Understanding the Distortion Tools
    Working With Apps

  • See Training Course Details...


Adobe InDesign CC

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Understanding Linked Graphics
    The Adobe Website
    Stroke and Fill
    Adding Colours to the Swatches Panel
    Transforming Shapes
    Fixed Layout vs Reflowable
    Starting With InDesign
    Understanding the Help Menu
    Adjusting Kerning
    Grouping Objects
    Working With Tabbed Documents
    Applying Liquid Layout Rules
    The EPUB Export Options Dialog box
    Interactive Navigation Tools
    Applying a First Line Indent
    Adjusting the Units of Measure
    Adding Notes to a Shared File
    Using Selection Tools
    Making Changes to a Shared File
    Deleting Comments
    Viewing and Navigating a File in Creative Cloud

  • See Training Course Details...


Adobe Photoshop CC

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

  • Some of the training topics covered include ...
  • Working With Layers
    Editing an Embedded Smart Object
    Creating a New Layer
    Working With the Panel Dock
    Resetting the Tools Panel
    Adding Motion With Path Blur
    The Bridge Menu and Tool Bar
    Add Fonts in Typekit
    Using the Crop Tool to Add a Border
    Creating a PDF Presentation
    Applying a Glow Effect
    Understanding the Retouch and Repair Tools
    Filling Text With an Image
    Understanding Colour
    Colour Fundamentals
    Your First Document
    Changing Text Colour
    The Adobe Capture Apps
    Editing a Smart Object in Illustrator

  • See Training Course Details...


ASP.NET Core MVC

  • 2 day course
  • Location: Dudley
  • 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
    Using XML Serialization
    A Windows Azure Testbed
    Routing in ASP.NET Core MVC
    Using Postman
    Using ADO.NET The Controller
    Advantages and Disadvantages of Web Forms
    Microsoft Technologies for Model Persistence
    .NET Core
    Using ViewBag
    Model Binding
    Input Validation The Model
    Attribute Routing ASP.NET Core Web API
    Model-View-Controller Pattern
    Html Helpers
    Rendering Views
    Configuring for ASP.NET Core MVC
    ASP.NET Core MVC
    Form Submission
    The Model in ASP.NET MVC
    Introduction to ASP.NET Core MVC

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Dudley
  • 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 ...
  • ASP.NET Web Site Navigation 
    Introducing Data Source Controls 
    Accessing Data 
    Debugging .NET Framework Source Code
    Programming Configuration Files 
    LINQ Syntax 
    Creating an XML Site Map File 
    Reading and Write Data Using the SqlDataSource Control 
    Master Pages 
    Language Integrated Query 
    LINQ 
    Preserving State in Web Applications 
    Storing Objects in Session State 
    Using the Web Site Administration Tool 
    ASP.NET Session State 
    Separating Validation into Validation Groups 

  • See Training Course Details...


ASP.NET using VB.NET

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

  • Some of the training topics covered include ...
  • Using Cookieless Session IDs 
    Working with Controls 
    Themes and Master Pages 
    Overview of ADO.NET 
    Using Membership Controls 
    Reading and Write Data Using the SqlDataSource Control 
    Using the Site Navigation API 
    Preserving State in Web Applications 
    LINQ to XML 
    Introduction to Web Controls 
    Managing State 
    ASP.NET Web Applications 
    Custom Data Visualizers 
    Displaying and Editing Middle-Tier Data using the ObjectDataSource Control 
    Programming Configuration Files 
    Introducing Data Source Controls 
    Site Navigation Controls 

  • See Training Course Details...


Crystal Reports 2008

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

  • Some of the training topics covered include ...
  • Using a Parameter to set N in a Top N or 
    Time Debugger
    Exporting Your Reports Within Your Organization
    Exploring the Toolbars 
    Formatting Individual Cells
    Grouping on a Formula Field
    Getting Help 
    Creating a Summary Report 
    Understanding the Formula Evaluation 
    Performing Simple Number Calculations 
    Creating a Cross-Tab Report
    Selecting Records with Multiple Criteria 
    Importing a Pick List
    When and Why to Group Records 
    Customizing the Cross-Tab Format
    Understanding How Cross-Tabs Affect Your Data
    Combining Multiple Tables 
    Moving and Aligning Objects 
    Formatting Sections Conditionally 
    Inserting Graphics 
    Producing Charts 

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Window 
    Moving and Aligning Objects 
    Understanding Running Totals
    Report Alerts
    Exploring the Toolbars 
    Power Formatting with Multiple Sections
    Using a Parameter to set N in a Top N or 
    Formatting Objects 
    Applying a Formatting Style to the 
    Displaying Parameter Fields
    Using Multiple Sections in Reports
    Previewing the Report 
    Creating and Using Formulas 
    Customize Group Name Field 
    Understanding How Cross-Tabs Affect Your Data
    Using Subreports to Link "Unlinkable" Data 
    Browsing Field Data 
    Selecting Specific Records from the Database 
    Additional Summary Options 
    Conditionally Formatting Fields 
    Using the Section Expert to Work with Sections

  • See Training Course Details...


Crystal Reports 2013

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

  • Some of the training topics covered include ...
  • The Formula Editor Toolbar
    Understanding Export Formats and Destinations
    Creating Report Alerts
    Using the Parameter Panel
    Modifying Individual Objects in the Chart
    Understanding the Formula Evaluation Subreports
    Using Evaluation Time Functions
    Using the Formula Editor
    Customizing Cross-Tab Group Names Report Alerts
    Using a Parameter to Select Records
    Using a Parameter Field
    Record Selection Formula Templates Grouping and Sorting Data
    Separating Statements in Complex Formulas
    Creating Running Totals for a List of Numbers
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Charting Cross Tabs
    Producing Charts
    Autosaving the Report
    The Grouping Dialog Box
    Selecting Records with Multiple Criteria
    Parameter Field Considerations

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Passing Data from the main Report into a Subreport
    Producing Charts
    Exporting to Windows Applications
    Using the Formula Editor
    Working with the Page Commands
    Using the Sort Control
    Inserting Lines and Boxes
    When and Why to Group Records
    Creating String Formulas
    Conditionally Formatting Fields Creating Summary Reports and Charts
    Working with Arrays
    Previewing the Report
    Using an Edit Mask to Limit String Parameters
    Cascading Parameter Fields Using Advanced Formula Features
    The Chart Dialog Box
    Using Multiple Parameter Fields in Reports
    Formatting Sections
    Placing Fields on the Report
    Linking a Subreport
    Conditional Running Totals Prompting with Parameters
    Understanding How Crystal Reports Processes the Data

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Placing Fields on the Report
    Quick Formatting with the Template Expert
    Grouping Data in Date/Time Intervals
    Saving the Report
    Creating Multiple Groups in a Report
    Viewing and Editing the Select Formula
    Using Alias Names for Column and Row Headings
    The Chart Dialog Box
    Guidelines
    HTML Preview
    Creating String Formulas
    Defining the Purpose of the Report
    Unlinked versus Linked Subreports
    Using Parameters in Conditional Formatting
    The Summaries Dialog Box
    Editing Charts
    CurrentFieldValue Report Alerts
    Linking a Subreport
    Creating Hyperlinks
    Working with Arrays
    Displaying Parameter Fields

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Dudley
  • 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 ...
  • The @font-face Rule
    Text Shadow
    The Target Pseudo-Class
    Modernizr
    HTML5 Selectors and Pseudo Classes
    Font Services
    Media Queries
    Flexible Box Model Vendor Prefixes
    background-origin, and background-size Borders and Box Effects
    Rounded Corners
    Box Shadow Transitions, Transforms, and Animations
    Attribute Selectors
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Image Borders
    Styling Video
    The History of CSS
    Strategies
    Negation Pseudo-Class

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Visio Data Mining Add-In  
    Concepts and Terminology
    Data Preparation
    Accuracy and Validation
    Microsoft Time Series Algorithm
    Cross Validation
    Cross Validation
    Model Usage
    Topics include:
    Microsoft Sequence Clustering Algorithm
    Excel PowerPivot Data Mining Add-ins
    Connection
    Microsoft Neural Network Algorithm
    Compare Mining Structures
    Data Mining Concepts
    Microsoft Logistic Regression Algorithm
    Introduction to SQL Server Data Tools
    Microsoft Linear Regression Algorithm
    Data Mining and Results
    Data Source

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Drag-and-Drop Code Builder
    Flexible Images and Other Media
    Foundation: A Responsive Grid Framework
    Video Formats
    The Flexible Grid: A More Responsive Layout Strategy
    GeoLocation API
    Embedding from YouTube or Vimeo
    Hosting Your Own Videos
    Other Devices
    Controlling the Video through JavaScript
    Local Storage
    The Viewport
    Swiping to Change Pages
    New HTML5 Features
    Flexible Grids
    The Case for Flexible
    Linearizing the Layout

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Inserting a Timeline Filter PivotTable Features
    Understanding Excel Macros
    Understanding Grouping and Outlining
    Moving PivotCharts to Chart Sheets Advanced Filters
    Displaying Scenarios
    Creating a Manual Group
    Extracting Records With Advanced Filter
    Finding the Difference From
    Sorting in a PivotTable PivotCharts
    Finding the Percentage of Total
    Consolidating From Different Layouts
    Assigning a Macro to the Toolbar
    Working With PivotTable Grand Totals
    Creating Relative Names for Subtotals
    Understanding PivotTables
    Disabling Worksheet Protection
    Creating Calculated Fields
    Changing the PivotChart Type
    Understanding Text File Formats
    Creating Subtotals
    Setting the Default File Location

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Creating Absolute References
    Creating a Chart Sheet
    Viewing Worksheet Gridlines
    Safely Closing a Workbook Working With Workbooks
    Approximating Row Height
    Multiple Value Filters
    Understanding Data Editing
    Number Formatting
    Changing the Worksheet View
    Filling a Series
    Using Shortcut Menus
    Selecting Non Contiguous Ranges
    Formatting Percentages
    Editing Formulas
    Using Go To
    Deleting Data
    Specifying the Number of Copies
    Changing the Chart Style
    Checking the Spelling
    Summing Non-Contiguous Ranges
    Deleting a Chart Getting Help

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Showing Data Labels
    Adding More Operations
    Quick Sparklines
    Using Names in Typed Formulas
    Quick Formatting
    Removing Table Columns
    Scoping Names to a Worksheet
    Clearing the Print Area
    Using Shape Effects
    Formatting the Drawing Pencil Essential Functions
    Removing Duplicates
    Copying a Worksheet
    Padding Numbers Using Custom
    Setting the Print Area
    Filling a Series Backwards
    The DATE Function
    Changing Individual Bar Colours
    Removing Borders
    Formatting Cells Containing Values
    Applying Alternate Date Formats

  • See Training Course Details...


Excel Power Pivot

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

  • Some of the training topics covered include ...
  • Tiling Data in Power View
    Understanding Relational Data
    The Advanced Editor
    Working With Mapping Confidence
    Merging Queries
    Creating a New Query From the Web
    Working With Time Settings
    Updating a Power View Report
    Filtering in Power View
    Creating a Timeline
    Using Related Power Pivot Fields
    Changing the Look
    Working With the Data Model
    Creating a Power Map Tour
    Understanding the Navigator Pane
    Power Pivot
    Changing a Power Pivot View
    Reducing Data Rows
    Viewing and Editing a Tour

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Launching a Form in Code
    Working with the Code Editor
    Understanding VBA's Error Trapping Options
    Working with the Command Button Control
    Working with the PivotTable Object
    Working with Control Appearance
    Working with the PivotFields Collection
    Running a Macro
    Recording a Macro
    Assigning a Macro to the Quick Access Toolbar
    Working with UserForm Properties, Events, and Methods
    Working with Inline Error Handling
    Using the Do...Loop Structure
    Creating a PivotTable Using Worksheet Data
    Displaying the Developer Tab in the Ribbon
    Understanding Controls
    Using the For Each...Next Structure
    Working with Procedures and Functions
    Saving a Macro-Enabled Workbook
    Using the Select Case...End Select Structure

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Dudley
  • 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 
    Dispatching A Custom Event 
    Declaring and Using Variables 
    ActionScript Event Types 
    Using Methods within a MovieClip 
    Using Functions 
    Creating Visual Classes Through Inheritance 
    Determine when the SpaceShip Crashes 
    Using the Keyboard and Enter Frame Events 
    Operators and Expressions 
    Tweening the Warp Animation
    Adding Properties to a Class 
    Using a MovieClip and Button's Properties 
    Programmatically Formatting Text 
    Declaring Methods 
    ActionScript Events 
    Determine your Current Age 
    Loading External XML Files and Filtering Books 
    Using the Sound Class 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Executing Code User Defined Functions
    SpreadsheetApp
    GmailApp
    JDBC Overview
    Adding Files To And Removing Files From Folders
    Sending An Email Using MailApp
    The Sheet Object
    Database Metadata
    Text Functions
    Using Google Services Spreadsheets and Sheets
    Encapsulating A Complex Calculation
    User-Defined Functions Versus JavaScript Functions
    Menus And Dialogues
    Creating And Removing Files And Folders
    Writing Database Records To A Google Spreadsheet
    Extracting Useful Information About The Spreadsheet
    Calendars Web Apps With Html Service
    Populating A Table
    Numeric Calculations
    A Data Entry Form
    Built-in Versus User-Defined Functions

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Form Elements
    Textareas Crash Course in CSS
    The Cascade
    Radio Buttons
    Descendant Selectors
    Nesting Unordered Lists
    Grouping
    CSS Rules
    Nesting Ordered Lists
    Default Pages
    HTML Links
    ID Selectors
    Absolute vs. Relative Paths
    Get vs. Post
    Closing Tags
    Ems (em)
    Type Selectors
    Quoted Text
    name vs. id

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Web Database Storage
    Some Other New Form Field Attributes
    Sections and Articles
    Display of HTML5 Structural Elements
    Browser Support
    drawImage() - Basic
    Cache Manifest File
    The Path Drawing Process
    Local Storage
    autocomplete
    Managing ApplicationCache with JavaScript
    Multiple Sources
    Accessibility
    Laying out a Page with HTML5
    Modernizr
    progress and meter
    HTML5 Canvas
    Creating and Converting Video Files

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Dudley
  • 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 ...
  • isNaN(object)
    JavaScript Basics
    Dot Notation
    ParseFloat() and parseInt()
    The getElementById() Method
    Preloading
    Validating Checkboxes
    Conditionals and Loops
    Image Rollover Function
    Validating a Registration Form
    Validating Select Menus
    JavaScript Objects, Methods and Properties
    JavaScript Operators
    Accessing Form Data
    Array Properties and Methods
    Image Rollovers
    Variables, Arrays and Operators
    Function Syntax
    JavaScript Form Validation

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Key Concepts
    The for Loop
    How to Create a Basic Plugin
    Reserved Words
    A Is for Asynchronous
    Connecting Events to Elements
    Cloning Elements
    Avoid the Universal Selector
    $.ajax Options
    Manipulating Elements
    Manipulating Attributes
    Changing the Duration of Built-in Effects
    ID-based Selectors
    $.fn.toggle
    Optimizing Your Code: The RequireJS Build Tool
    $.fn.hover
    Saving Selections
    Keep Things DRY
    Checking Types

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Dudley
  • 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
    Collapsible Blocks Events
    ThemeRoller
    Basic Page Template
    Sending Emails
    Ajax-driven Page Navigation
    Overriding Themes with Custom CSS Plugins
    What Is jQuery Mobile?
    Themes and Swatches
    Sliders
    Lists and Buttons
    Using Others' Plugins
    Supported Devices/OSs/Browsers
    Hosting vs. CDN
    Video The Theme Framework
    Levels of Support

  • See Training Course Details...


Microsoft Access 2007

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

  • Some of the training topics covered include ...
  • Database normalization
    Database normalization
    Modifying and printing reports Relational databases
    Using Design view
    PivotTables
    Getting started
    Performing operations in queries Using forms
    Exploring tables
    Planning and designing databases
    Charts in forms
    Using Design view
    Working with Windows SharePoint Services Database management
    Working with input masks
    PivotTable forms Querying with SQL
    Exploring tables
    Finding and editing records
    Creating tables Fields and records
    Changing the design of a table
    Adding calculated values
    Protecting databases

  • See Training Course Details...


Microsoft Access 2010

  • 2 day course
  • Location: Dudley
  • 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 macros to provide user interaction
    Exploring tables
    Organizing records Data entry rules
    Creating forms
    Modifying lookup fields
    Working with input masks
    Creating lookup fields
    Adding graphics
    Importing objects
    Customized headers and footers
    Database concepts
    Joining tables in queries
    Protecting databases
    PivotCharts
    Creating and using queries
    Advanced form types Reports and printing
    Creating the AutoKeys and AutoExec macros
    Hyperlink fields Database management
    Subdatasheets
    Interacting with XML documents
    Summarizing and grouping values Advanced form design

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Writing SQL statements
    Exploring the Access environment Databases and tables
    Subdatasheets Complex queries
    Creating macros that require user input
    Referential integrity Related tables
    Adding calculated values
    Summarizing and grouping values Advanced form design
    Changing the design of a table
    Using calculated fields
    Report formatting
    Setting field properties
    Working with XML documents
    Creating, running, and modifying macros
    Attaching macros to the events of database objects Advanced macros
    Creating tables Fields and records
    Creating macros for data transfer Importing, exporting, and linking objects
    Creating reports
    Advanced form types Reports and printing
    Using action queries  Macros
    Charts in reports Querying with SQL
    Modifying and printing reports Relational databases

  • See Training Course Details...


Microsoft Access 2016

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Querying Techniques
    Modifying Forms
    Sorting and Filtering
    Action Queries
    Adding Records to a Table
    Database Wellness
    Getting to Know Access 2016
    Navigation Pane Protection
    Modifying Table Structures
    Creating and Using Reports
    Using a Navigation Form
    Aggregation Queries
    DIY Forms
    Data Validation
    Creating a Relational Database
    Database Security
    Creating a Lookup Database
    Macro Techniques
    Importing and Exporting Records
    Designing a Lookup Database
    Creating and Using Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

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

  • Some of the training topics covered include ...
  • Understanding Constants
    Debugging Code
    Setting Break Expressions
    Understanding the Order of Events
    Organizing Code and Procedures
    Using the Immediate Window to Call Procedures
    Understanding Recordset Cursor Properties - Optional
    Working with Variable Scope
    Using Intrinsic Constants
    Using the For Each...Next Structure
    Working with the ADODB Recordset Object
    Specifying a Recordset Cursor Location - Optional
    Handling Errors
    Using the CacheSize Property - Optional
    Guidelines for use of Branching Structures
    Using the Select Case...End Select Structure
    Controlling Program Execution
    Using Message Boxes
    Working with Events

  • See Training Course Details...


Microsoft Excel Power Query

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

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

  • Some of the training topics covered include ...
  • Importing, Transforming, and Loading Data into Excel and Power Pivot
    Appending Operations
    Understand Power Query formulas.
    Grouping Options
    Course topics include- INTRODUCTION TO POWER QUERY
    Importing Data
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Understand the M interface.
    Using PivotTables CONNECTING TO DATABASES
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understanding and Handling Special Situations
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand working with relational data.
    Understanding the Issues
    Loading into Excel
    Introduction to Power BI Desktop
    Loading into Power Pivot
    Power Query Interface
    Transforming Data
    Loading into Power BI Desktop
    Performing Merges

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Power BI

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

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Theming Reports
    Navigate the Power Query interface.
    Configure tours, scenes, and layers.
    Hierarchies
    Configuring Drill Through
    Working with Tables
    Introduction to the PowerPivot Interface
    Power Map
    Understanding Aggregations
    Utilizing Matrix
    Examine map data.
    Importing Large Datasets
    Creating PivotTables
    Utilise data sources.
    Drill Through
    Importing Data with a Query
    Exploring the Power View Interface

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Working with groups
    Managing a project
    Working with resource costs Working with views and tables
    Consolidating and sharing projects
    Project management concepts
    Working with tables Filtering, grouping, and sorting
    Using Help Working with tasks
    Working with project files
    Sorting tasks and resources Finalizing the task plan
    Creating a custom table Managing multiple projects
    Working with resources and calendars
    Resolving resource conflicts
    Creating a Work Breakdown Structure Scheduling tasks
    Setting up task links
    Working with views
    Tracking project work
    Visual reports Customizing the project environment
    Customizing reports
    Communicating among a project team
    Working with filters
    Creating macros

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Finalizing schedules
    Modifying a task list Task scheduling
    Managing a project
    The base calendar
    Working with templates Creating projects from other programs
    Custom views
    Task options Resource management
    Project management concepts
    Analyzing the plan Delays and conflicts
    Collaboration
     Setting baselines
    Filters Groups Sorting tasks and resources Finalizing the task plan
    The Project window
    The Help window Tasks
    Custom fields Managing multiple projects
    Customizing Project
    Project costs Views and tables
    Exporting to Office applications
    Working with views
    Standard reports Visual reports  
    Hyperlinks

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Working with templates
    Views and tables
    Standard reports
    Creating projects from other programs Managing a project
    Working with tables Filters, groups, and sorting
    Resources and calendars
    Project files Tasks
    The Project window
    Visual reports Customizing Project
    The Work Breakdown Structure
    Consolidating and sharing projects
    Project costs
    Hyperlinks
    Task links
    Custom views
    Using templates and importing data
    Custom fields Managing multiple projects
    Handling resource conflicts
    Gantt chart formatting
    Sharing resources among projects Exchanging project information

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Working With Effort Driven Tasks
    Information
    Preparing for the Master Project
    Using Elapsed Time
    Highlighting a Range of Tasks
    Filtering a Visual Report
    Adding Simple Custom Fields
    Computers and Project Management Creating a New Project
    Assigning Overtime
    Making Reports Global
    Examining Task Information
    Modifying a Schedule Using
    Understanding the QAT
    Using Print Preview
    Understanding Task Durations
    Checking Resource Usage
    The Project Work Area
    Problem Assignments
    Template Project Templates

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Working in a Sheet View
    Modifying the Standard Calendar
    Understanding Lead Time
    Understanding the Project Start
    Understanding Tasks
    Getting to Know Project 2016
    Showing and Collapsing the Ribbon
    Reviewing the Project
    Specifying Resource Usage
    Starting Project in Windows
    Assignments
    Assigning a Calendar to a Task Scheduling
    Assigning Resources in a Sheet
    Case Study Tasks
    Working With Task Views
    Auto Scheduling Tasks
    Understanding the Backstage
    Printing a Help Topic
    The Case Study Resources Printing

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Switching Work Assignments
    Reviewing Current Costs
    Adding Simple Custom Fields
    Using AutoFilters Formatting Projects
    Deleting Unwanted Views
    Creating a Custom Filter
    Tracking Actuals On A Gantt Chart
    Consumption
    Using The Tracking Box
    Using a Custom Table
    Changing Bar Text
    Printing Headers
    Understanding the Timescale
    Setting Page Breaks
    Entering Delayed Tasks
    Reviewing Our Project
    Exploring Tables
    Resource Levelling
    Assigning Fixed Material
    Entering Variable Costs
    Changing Text Styles

  • See Training Course Details...


Microsoft Project 2016 Level 3

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Inserting Task Links
    Creating a Custom Table for the View
    Setting Project Links
    Saving a Visual Report as a Template
    Understanding Project Downsizing
    Linking Subprojects to Resources
    Enhancing Report Appearance
    Running an Edited Macro
    Linking to Microsoft Excel
    Inserting Subprojects
    Using Only the Combined Project File
    Copying Table Data
    Formatting Chart Objects
    Understanding Graphical Reports
    Formatting a Visual Report
    Checking for Resource Links
    Creating a Custom Filter for the View
    Examining the Templates
    Linking a New Project File to the Pool
    Linking to an External Pool

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Modeling changing dimensions - Dimension Intelligence w/ Wizard 
    Using multiple fact tables 
    Creating cubes - using the UDM and the Cube Build Wizard 
    Rapidly changing dimensions / ROLAP dimensions 
    Welcome to the Real Time - Proactive Caching 
    Perspectives 
    Security - roles and permissions 
    Introduction to Data Mining
    Processing mining models 
    Actions - regular, drill-through and reporting 
    Understanding fact (measures) and cube modeling 
    What Is Microsoft BI? 
    SQL RS & Report Builder 
    Data Mining dimensions 
    Using SSAS in BIDS
    .NET Assemblies
    Excel 2003 Pivot Tables 
    Other Documentation methods 
    Customizing Aggregation Design - Processing Design 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • The deployment utility 
    Working with Packages 
    Control Flow: The OnError event handler 
    Advanced Control Flow
    Data Transformations 
    Executing packages – DTExec and DTExecUI 
    Introduction to SSIS component development 
    Configuration options 
    Business Intelligence Development Studio
    Importing and Exporting Data 
    Creating Database Maintenance Plans using SSMS 
    The Bulk Insert Task 
    Introduction to Data Flow
    The Execute Package Task 
    The Aggregate Transformation 
    Scheduling and Executing Plans 
    Configuration Overview 
    Data Viewers 
    Revisiting data sources and destinations 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Using SSAS in BIDS
    Design Reports using Reporting Services
    Create Data Sources
    Design Reports by using Report Builder
    OLAP Modeling
    Deploy and Synchronize Databases
    View a Cube by using SQL Reporting Services
    Model with SQL Server Business Intelligence Development Studio (BIDS)
    Use the MDX Query Editor in SSMS
    Customize Cube and Dimension Processing
    Understand Mining Structure Processing
    View a Cube by using Excel
    Understand Measure (fact) and Cube Modeling
    Implement SSAS Security
    Review MDX Functions New to SSAS 2008
    Discover how to add .NET Assemblies
    Explore Scalability Options

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Exploring and Executing a Package Outside of BIDS 
    Data Flow Best Practices 
    Configurations 
    Redeploying Updated Packages 
    Migrating and Maintaining SQL Servers with Integration Services 
    Data Viewers 
    Event Handling 
    Best Practices for Using Integration Services 
    Advanced Data Flow
    Handling Slowly Changing Dimensions 
    Executing Packages 
    Extending Integration Services Capabilities through Code 
    Checkpoints 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Maintaining and Optimizing
    Querying the Solution and Understanding DAX
    Measures and Measure Groups
    The Multidimensional Solution
    Choosing the Right Model
    Configuring Cube Options
    Creating a Cube
    Utilizing Translations
    Browsing Perspectives and Translations
    Version Changes of SSAS from 2008-2014
    Analysis Services Installation and Architecture: One Product, Two Models
    Developing Dimensions
    Common Analysis Services Solutions
    Exploring Security
    Creating a Tabular Project
    Relating with Relationships
    Handling Hierarchies.
    Understand and utilize security.

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Examining the SSIS Engine
    Working with XML
    Using Expressions in Packages Containers
    Overview of Containers
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Data Loading with the Analysis Services Tasks
    Managing SQL with the SQL Tasks
    Utilizing the Import/Export Wizard
    Understanding Variables
    Handling Errors Common SQL Server Integration Services Design Patterns
    Optimizing Sources for Extraction
    The SQL Server Integration Service
    SQL Server Integration Services Architecture
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Performing Joins with the Lookup Transformation
    Utilizing Container Loops Performing Joins
    Performing Joins with the Merge Transformation
    Version Changes of SSIS From 2008-2012
    Creating SQL Server Integration Services Packages
    Using Destinations and Understanding choices

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Understanding HTML5 and Textboxes
    Filtering, Grouping, and Sorting
    Understanding Visualizations
    Exploring Subscriptions
    Understanding Variances Between SQL Versions
    Formatting Reports
    Using the List Object to Combine Other Items
    Using Tables
    Exploring Matrix
    Examining Security
    Utilizing Lists
    Mastering Data Region(s)
    Examining Maps
    Working with Map Wizard
    SQL Server 2016 Report Builder Graphics
    Creating Subreports and Drillthrough Reports
    Exploring the Report Builder Interface

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Create a DMX Query in SQL Server Management Studio
    Choose an Accuracy Chart Type and Set Chart Options
    Nested Tables
    Create a Singleton Prediction Query from a Template
    Apply a Filter to a Mining Model
    Using Nested Table Data as an Input for an Accuracy Chart Queries
    Microsoft Neural Network
    Choose the Column to Use for Testing a Mining Model
    SystemGetClusterCrossValidationResults
    Logical Architecture
    Make a Copy of a Mining Model
    Export and Import Data Mining Objects Architecture
    Browse a Model Using the Microsoft Naive Bayes Viewer
    Drillthrough on Mining Structures Create Mining Models
    Choose and Map Input Data for a Prediction Query
    Create a Data Mining Query by Using XMLA
    Exclude a Column from a Mining Model
    Add a Mining Model to an Existing Mining Structure
    View and Save the Results of a Prediction Query
    Column Distributions
    Browse a Model Using the Microsoft Tree Viewer

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Calculations using the Business Intelligence Wizard
    Edit or Delete Partitions Merge Partitions
    Modify or Delete an Analysis Services Database
    Test an Action
    Create Remote Partitions
    Ragged Hierarchies
    Use Aggregate Functions
    Using SQL Server Data Tools (SSDT)
    Define a Referenced Relationship and Referenced Relationship Properties
    Create a Dimension by Using an Existing Table
    Define Named Calculations in a Data Source View
    Define a Data Source View
    Define a Fact Relationship and Fact Relationship Properties
    Processing Options and Settings
    Explore Data in a Data Source View
    Deploy Model Solutions Using XMLA
    Define Logical Relationships in a Data Source View
    Define Assignments and Other Script Commands
    Backup and Restore of Analysis Services Databases
    Add or Remove Tables or Views in a Data Source View
    Delete a Data Source View Dimensions

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Create and Manage Tabular Model Partitions
    Topics include- Overview of SSAS Tabular models
    Row filter mappings
    Analyze in Excel
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Object-level security
    Restore from Power Pivot
    Import Data
    Create and Manage Hierarchies Partitions
    Create a Calculated Table
    Create and Manage Measures KPIs
    Import from Power Pivot
    Specify Mark as Date Table for use with Time Intelligence
    Bi-directional cross filters  Calculations
    Create a Relationship Between Two Tables
    Analyze a tabular model in Excel Deploy tabular model solutions
    Hide or freeze columns
    Delete a Column
    Connect to a tabular model database
    Database Process Partitions in the Workspace Database Perspectives

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Preparing data for mobile reports
    Data filters
    Creating a report with the report wizard
    Databars, sparklines, indicators, gauges, and maps
    Configuring data access with report designer
    Mobile report publisher
    Images and charts
    Drilldown and drill through Sharing Reporting Services Reports
    Schedules
    Using Datasets Creating Paginated Reports
    Add a drillthrough to a custom URL
    Reporting services components
    Formatting data
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Report parameters
    Extend reporting services functionality with external assemblies.
    Report caching, snapshots, and comments
    Publish a report to reporting services Working with Reporting Services Data
    Work with expressions and embedded code.
    Use report services configuration manager to reconfigure SSRS servers.

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Filtering Data
    Managing the Views Using Secondary Views
    Warehouse Databases
    Customizing the Table View
    Set Operations
    Databases and Data Models
    Reusing Filters
    Column Formatting
    Controlling the Report Definition
    Accessing The Presentation Catalog
    Viewing Supplementary Content
    Chart View
    Managing Dashboard Objects Creating a Report
    About Business Intelligence
    Viewing the Request Results
    Pivot Table Concepts
    View Selector View
    Navigating the Answers Interface
    Using Prompts to Filter Data
    OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
    Physical Data Models Data Warehousing and BI

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Using the %ROWTYPE Attribute 
    Using Nested TABLEs 
    Assignment and Conversions 
    Declaring and Opening Cursors 
    Other Supplied Packages
    Local Procedures and Functions 
    Collection Methods 
    Triggers 
    PL/SQL Syntax and Logic 
    PL/SQL Blocks and Programs 
    The DBMS_UTILITY Package 
    BULK COLLECT Clause
    Working with LOBs 
    Overloading Package Functions and Procedures 
    Maintaining PL/SQL Code 
    Subtypes 
    Maintaining Stored Programs
    Generating an Error 
    Stored Procedures and Functions
    Oracle Directories 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Dudley
  • 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 ...
  • NULL Values 
    Selecting from Multiple Tables 
    Compound Expressions 
    SQL Functions 
    IN and BETWEEN 
    Pattern Matching: LIKE and REGEXP_LIKE 
    SQL Queries 
    Synonyms
    Sequences 
    Data Definition and Control Statements 
    Graphical Clients 
    Updatable Views 
    Views 
    Deleting a Table Definition 
    Concurrency 
    Literal Values 
    The UPDATE Statement 
    SQL*Plus LOB Support 
    Choosing Rows with the WHERE Clause 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Authentication with PHP and SQL 
    Using PEAR DB 
    Querying a Database 
    Subpatterns ( () ) 
    Constants 
    mysqli Prepared Statements 
    require 
    Reading from Two-dimensional Arrays 
    Magic Quotes
    Looping through Arrays 
    Form Variables 
    PHP Tags 
    Formatting Strings 
    Code Organization 
    If Conditions 
    fopen() 
    Uploading Files via an HTML Form 
    File Locking 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Interactive elements
    Working with Chart Tools Action buttons, custom slide shows, and equations
    Using comments
    Formatting paragraphs Using drawing objects
    Media clips
    Formatting text
    Diagrams Modifying presentations
    Distributing presentations
    Saving presentations
    Equations Distributing presentations
    Broadcasting a slide show online Integrating Microsoft Office files
    Building slides from Word outlines
    Custom themes Using graphics and multimedia
    Modifying text
    Finishing a presentation
    Embedding and linking content
    Customizing SmartArt graphics
    Using slides from other presentations Formatting slides
    Animations
    Working with hyperlinks

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Editing efficiently Working with shapes
    Preparing a presentation
    Animations
    Distributing presentations
    Getting started
    Formatting shapes
    Creating a basic presentation
    Equations Integrating Microsoft Office files
    Modifying graphics
    Creating shapes
    Photo albums Customizing slide elements
    Custom slide shows Graphics and media
    The PowerPoint interface Creating presentations
    Embedding and linking content Finalizing and distributing presentations
    Working with SmartArt graphics
    Applying content from a Word outline
    Slide masters and transitions
    Customizing PowerPoint
    Reviewing and finishing

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Resizing an Image
    Applying Shading
    Inserting an Audio Clip
    Understanding Themes
    Creating Custom Theme Colours
    Formatting Media Clips
    Inserting a Table Using the Ribbon
    Applying a Picture Style
    Creating a Custom Show
    Saving to a Storage Device
    Applying a Table Style
    Opening Shared Presentations
    Working With Pie Charts
    Document
    Saving a Presentation as a Video
    Applying Slide Transitions to the
    Applying Picture Effects
    Understanding Charts
    Inserting an Online Video

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Inserting a Picture With Caption Slide
    Editing Shapes
    Planning a Presentation
    Previewing a Slide Show
    The Four Pillars of Great Design
    Inserting and Formatting Text
    Changing Bullet and Numbering
    Navigating the Help Window
    SmartArt
    Adding Commands to the QAT
    The Open Place
    Adding Notes to Your Slides
    Using the Zoom Tool
    Presenting a Slide Show
    Rotating Shapes
    Inserting a Section Header Slide
    Showing and Collapsing the Ribbon
    Positioning Shapes
    Working With Text
    Using the Eyedropper
    Editing Text

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Customizing the Quick Access toolbar
    Print preparation
    Multi-page layouts
    Customizing the Ribbon
    Symbols and special characters
    Publication setup
    Graphics adjustments
    Paragraph formatting
    The Publisher interface
    Typography
    Getting started
    Master pages
    Table structure
    Form letters
    Interactive forms
    Precise spacing control

  • See Training Course Details...


Publisher 2013

  • 1 day course
  • Location: Dudley
  • 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 Pictures
    Using The Scratch Area
    Previewing And Modifying A Catalogue Merge
    Understanding Different Types Of Publications
    Importing Text
    Opening An Existing Publication
    Inserting Headers
    Wrapping Text
    Creating A Fill Background
    Showing And Collapsing The Ribbon
    Aligning Shapes
    Merge Printing
    Moving Pages
    Creating A Publication From A Template
    Filtering Data
    Using Multiple Master Pages Mail Merge
    Navigating The Help Window
    Using Baseline Guides
    Showing Merge Results
    Tips For Planning A Publication
    Creating A Data Source

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Importing Text
    Page Orientation
    Using Undo and Redo
    Sorting a Merge
    How Publisher 2016 Works
    Understanding Page Sizes
    Inserting Borders and Accents
    Mail Merge
    Inserting a Caption
    Creating a Publication From a
    Inserting Pictures
    Entering Text in a Table
    Catalogue Merge
    Adding and Editing Business
    Changing Margin Guides
    Information
    Saving for a Commercial Printer
    Understanding How Help Works
    Checking Spelling
    Understanding the Start Screen

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Data Types
    Checking Multiple Conditions 
    Comments
    CASE syntax
    Multi-table Joins  
    Aliases
    The LIKE Operator   
    Relational Database Management System 
    Dropping Views
    Selecting Distinct Records
    Conditional Processing with CASE
    WHERE and ORDER BY  
    Dropping Stored Procedures
    Views  
    Common String Functions
    DELETE   

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

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

  • Some of the training topics covered include ...
  • Server Management Reports
    Static Subscription
    Report Filters
    Deploying the Auditing and Management Reports
    Report Builder Design Layout
    Clickthrough Reports
    Creating a Report Model Project
    Building Report Models in Reporting Services 2005
    Adding or Deleting
    Design the Query Dialog
    Reporting Services 2005 Menus
    A Closer Look at Preview
    Creating Formulas
    Reporting Services 2005 Query vs. Report Parameters
    Reporting Services 2005 Security Model Concepts
    Default Folder Structure
    Quick Formatting using Toolbar and Menu Options
    Modifying the Data Source View
    Drawing Lines and Rectangles
    Reporting Services 2005 Web Components

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Investigate what SQL Server Reporting Services can do 
    Explore the use of Reporting Services gauges 
    Learn how to call the Report Server Web Service 
    Learn how to create custom functions using the Code window 
    Security
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Ad-Hoc Reporting with Report Builder 2.0
    Learn how to create a tabular report from scratch 
    Grouping and Sorting
    Understand scope as it applies to aggregate functions 
    Investigate how Reporting Services secures access to reports and other Reporting Services resources 
    Discover the various global collections that you can reference in your expressions 
    Learn how to create parameters in ad-hoc SQL 
    Explore the maintenance of report history 
    Explore creating groups 
    Find out how you can use conditional formatting to make your reports more dynamic 
    Dig into the use of unbound, multivalued, and cascading parameters 
    Investigate the list data region 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Dudley
  • 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 ...
  • Debug Package Execution Components
    Install Integration Services Working with Integration Services
    Deploy SSIS Packages
    Create an SSIS Project
    Secure Databases Working with MDS and Windows Azure
    Examine MSI Packages
    Configure MDS
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Add Data Flow Components to a Data Flow Task
    Perform Transformation Tasks
    Debugging and Troubleshooting Packages
    Overview of Data Warehouses
    Profile OLTP Data
    Add Packages to an SSIS Project Managing Control Flow
    Execute Packages from Different Control Flow Working with Dynamic Variables
    Securing Packages and Databases
    Work with Windows Azure
    Work with MDS Databases
    Secure Packages
    Create Dimensions
    Track Changed Data Managing Data Flow

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Native Mode Architecture
    Globals Collection Creating Custom Functions
    Overview
    Report Project Configurations  Creating a New Report in the Report Designer
    Reporting Services Modes
    The Report Designer Creating Reports with SQL Server Data Tools
    Rein in the Length of a Text Field
    Data Set Parameters
    Report Parameters
    Introduction to SQL Server Reporting Services
    User Collection
    Create a Form-Like Report from a list Calculations Using Expressions And Functions
    Create a  Parameterised Report
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    Designing the Page Layout
    Using Unbound Parameters Understanding Report And Data Set Parameters
    Create a Data Source Connection
    Create Shared Data Sources and Data Sets
    Building a Report with Report Builder
    Globals Collection

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Dudley
  • 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 ...
  • Manage Views
    Configure User-Defined Functions (UDF)
    Manage Query Plans
    Insert Data
    Work with System Catalog Views Optimizing Query Performance
    Work with Variables and Batches
    Work with System Databases
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Create Queries Using Join Algorithms
    Work with Data Access Technologies Implementing Stored Procedures
    Merge Data Working with SQL Server Built-in Functions
    Configure Indexes
    Assign Aliases Using Queries
    Manage Transactions Querying SQL Server System Metadata
    Work with T-SQL Statements
    Work with SSPs and SMOs
    Combine Data Using Simple Joins
    Work with Subqueries
    Write SELECT Statements
    Sort the Queried Data
    Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Planning your diagram
    Working with links
    Manipulating objects
    Creating a basic diagram
    Formatting text blocks
    Rack diagrams
    Printing diagrams
    Creating shapes for a stencil
    Database model diagrams
    Introduction to advanced features
    Using windows and stencils
    Network and brainstorming diagrams
    Web site maps
    Formatting text
    Working with organization charts
    Reporting Creating technical layouts
    Custom shape design
    Integration with Microsoft Word
    Shape behavior and events

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Getting started
    Database model diagrams
    Creating a basic diagram
    Compound lines
    Organization charts Formatting drawings
    Drawing scales
    Integration with Microsoft Word
    Working with links Network and brainstorming diagrams
    Integration with Microsoft Outlook
    Formatting shapes and lines Working with pages
    Layout and connection techniques
    Special drawing operations
    Displaying shape dimensions Custom themes and templates
    Project management diagrams
    Custom stencils Business diagrams and Web site mapping
    Editing objects Basic diagrams
    Network diagrams
    Block, tree, and onion diagrams
    Working with background pages
    File and print properties
    Formatting text

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Business diagrams and Web site mapping
    with background pages
    Shape properties
    Planning a diagram
    Working with links
    Reporting
    Web site maps
    Network and brainstorming diagrams
    Network diagrams
    Editing objects
    Windows, stencils, and objects
    Custom templates
    Compound lines
    Sharing diagrams using a browser
    The Visio 2013 interface
    Customization and reporting
    Block, tree, and onion diagrams
    Special drawing operations
    Working with pages
    Custom themes

  • See Training Course Details...


Word 2010 Advanced

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

  • Some of the training topics covered include ...
  • Creating AutoText
    Macros
    Aligning Data In Cells
    Modifying A Bullet
    Importing And Embedding Excel Data
    Templates
    Typing Text Into A Text Box
    Applying Character Styles
    Adding Records
    Inserting A Hyperlink To External Data
    Applying Hanging Indents
    Inserting A Watermark
    Creating An AutoMark File
    Keeping Paragraphs Together

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Scrolling Through A Document
    The Word Screen
    Understanding Headers And
    Using Shortcut Menus
    Page Zooming
    Counting Words Working With Text
    Working With Live Preview
    The Save As Dialog Box
    Adding Data To A Table
    The Open Dialog Box
    Using The Blank Document
    Using Click And Type
    Accessing The Help Window
    Understanding The Quick Access
    Modifying Tabs On The Ruler
    Toolbar
    Saving A New Document

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Dudley
  • Course Outline
  • Some of the training topics covered include ...
  • Table data Page layout
    AutoCorrect
    Working with table content
    Tab settings
    Adding graphics and clip art
    Graphics
    Character formatting
    Creating tables
    Printing and exporting documents
    Working with graphics Styles and outlines
    Paragraph spacing and indents Tables
    The Word window
    Find and replace Formatting text
    Working with text
    Document navigation Editing text
    Examining formatting
    Changing the table structure
    New documents
    Spelling and grammar
    Table design options

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Setting Tab Leaders
    Pictures
    Clearing Font Formatting
    Changing Paragraph Spacing
    Splitting the Window
    Previewing the Merged Documents
    The Save As Place
    Understanding Pictures
    Drag and Drop Copying
    Using the Format Painter
    Selecting Text Using the Mouse
    Inserting Mail Merge Fields
    Product Information
    Typing Numbers
    and Spacing

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Applying Text Wrapping to a Canvas
    Enhancing Shapes
    Specifying Column Widths and
    Applying an Outline to Shapes
    Mail Merge Techniques
    Cropping Pictures Accurately
    Renaming and Deleting Styles
    Product Code: INF1611
    Understanding Picture
    Customising the Columns
    Deleting Document Property Data
    Changing Shape Outlines
    Understanding Columns
    Understanding Section Breaks
    Section Breaks
    Inserting a Blank Header
    Removing Returns

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Dudley
  • 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 ...
  • Creating Bookmarks
    Inserting Prompt Text
    Setting a Different Proofing Language
    Inserting a Document Information
    Updating a Table of Contents
    Recording a Macro
    Custom Dictionaries
    Editing Subdocuments
    Setting Field Properties
    Footnotes and Endnotes
    Assigning a Macro to the Toolbar
    Showing and Hiding Markup
    Viewing a PDF File in Reader
    Using AutoFormat
    Understanding SmartArt
    Setting the Default Language

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730