Enable Technology

MIDLANDS TRAINING COURSES 

TRAINING COURSES MIDLANDS




Adobe Dreamweaver CC

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

  • Some of the training topics covered include ...
  • Correcting Perspective With Perspective Crop
    Applying a Soft Focus Effect
    Linking to an External Style Sheet
    Sorting the Contents of the Library
    Getting Help
    Using Adobe Bridge
    Understanding the Dreamweaver CC Workspace
    The Adobe Account
    Understanding Design View
    Creating an Adjustment Layer
    Introduction to Camera Raw
    Layer Effects
    Understanding Floating Elements
    Styling Hyperlinks With CSS
    Creating a Navigation Bar With CSS Code
    Adobe Mobile Apps
    Setting Element Width and Height

  • See Training Course Details...


Adobe Illustrator CC

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

  • Some of the training topics covered include ...
  • The Creative Profile Home Page
    Understanding Document Presets
    The Illustrator Workspace
    Creating Layers and Sublayers
    Applying a Pattern Swatch
    Placing a Symbol Instance
    Simplifying Paths
    Understanding the Transform Tools
    Printing an Illustrator Document
    Understanding Save and Export Options
    Creating Lines and Spirals
    Understanding Layers and Sublayers
    Creating and Using Custom Views
    Understanding Effects
    Understanding Formatting Options
    Gradients
    Swapping Fill and Stroke Colours
    Viewing and Hiding the Grid

  • See Training Course Details...


Adobe InDesign CC

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

  • Some of the training topics covered include ...
  • Fixed Layout vs Reflowable
    Understanding Linked Graphics
    Generating a Simple Index Creating a Simple E-Publication
    Understanding MultiMedia Tools Alternate Layouts
    Creating an Alternate Layout
    Constraining Specific Objects
    Creating a New Layer
    The InDesign Workspace
    Commenting on a Shared File
    The Adobe Account
    Understanding TypeKit
    Add Fonts in Typekit
    Positioning Graphics Within a Frame
    Applying Text Wrap
    Creating a Caption
    Applying Paragraph Styles
    Using the Hand and Zoom Tools
    Selecting Colours Using the Swatches Panel
    Deleting Comments
    Creating a Table
    Understanding Document Presets

  • See Training Course Details...


Adobe Photoshop CC

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

  • Some of the training topics covered include ...
  • Removing Unwanted Objects and Wires
    Working With Layers
    Navigating With Keyboard Shortcuts
    Adding Motion With Path Blur
    Mobile Application Help and Support
    Making Basic Changes in Camera Raw
    Understanding Filters
    Using the Mixer Brush
    Understanding the Help Menu
    Removing Stray Hairs
    Understanding Layer Comps
    Editing an Embedded Smart Object
    The Bridge Menu and Tool Bar
    Understanding the Crop Tool Options Bar
    Working With Thumbnails
    Sharpening Images With Smart Sharpen
    Straightening Images Using the Ruler Tool
    Understanding Adjustment Layers
    Understanding Assets
    Changing the Font Family

  • See Training Course Details...


ASP.NET Core MVC

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

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

  • Some of the training topics covered include ...
  • Retrieving Data from a Request
    More Complex Models in MVC Programs
    HTTP Response Codes
    View Responsibility
    ASP.NET Web API Clients ASP.NET Core and Azure
    HTTP Testing Tools
    Html Helpers
    Model-View-Controller Pattern
    Controller Base Class
    Razor View Engine
    Attribute Routing ASP.NET Core Web API
    Using ADO.NET The Controller
    Filters The View
    ASP.NET Core MVC
    Updating an Application on Azure 
    Form Submission
    Input Validation The Model
    Properties of Routes
    REST and Web API
    Validation Attributes Routing
    Serving Static Files

  • See Training Course Details...


ASP.NET using C#

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

  • Some of the training topics covered include ...
  • Introduction to Web Controls 
    List Controls 
    Site Navigation 
    Site Navigation Controls 
    Introducing the GridView Control 
    Introduction to Rich Controls 
    Storing Objects in Session State 
    The Calendar Control 
    Managing Users with ASP.NET's Membership Features 
    Introduction to Membership and Roles 
    Working with Data 
    Creating a Consistent Web Site 
    Configuring Session State 
    Themes and Master Pages 
    Allow Users to Select from a DropDownList in the Grid 
    Overview of ADO.NET 
    ASP.NET Web Site Navigation 
    LINQ to SQL 
    Connecting to Data 

  • See Training Course Details...


ASP.NET using VB.NET

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

  • Some of the training topics covered include ...
  • Language Integrated Query 
    Master Pages 
    Using the Visual Debugger 
    Using the Complex Validators 
    Displaying XML Data Using the XmlDataSource Control 
    Introduction to Web Controls 
    ASP.NET Session State 
    HyperLink and Button Controls 
    Displaying and Editing Middle-Tier Data using the ObjectDataSource Control 
    Configuration Overview 
    Using Rich Server Controls 
    Using the Site Navigation API 
    Managing State 
    Introduction to Rich Controls 
    List Controls 
    Using Cookieless Session IDs 

  • See Training Course Details...


Crystal Reports 2008

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

  • Some of the training topics covered include ...
  • Allowing Multiple Values in Parameters
    Starting a New Report 
    Prompting with Parameters
    CurrentFieldValue 
    The Data Dialog Box 
    Creating and Using Formulas 
    Working with Arrays
    When and Why to Group Records 
    Creating Multiple Groups in a Report 
    Performing Simple Number Calculations 
    Working with Variables
    Understanding Crystal Formula Syntax 
    Sorting Records within a Group 
    Adding Multiple Tables to a Report 
    Filter Types of the Select Expert 
    Selecting Records with Multiple Criteria 
    Creating Hyperlinks

  • See Training Course Details...


Crystal Reports 2011

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

  • Some of the training topics covered include ...
  • Using an Edit Mask to Limit String 
    Formatting on Report Alerts
    Format Painter 
    Moving and Aligning Objects 
    Using Multiple Sections in Reports
    Customize Group Name Field 
    Formatting Sections 
    Viewing and Editing the Select Formula 
    Placing Fields on the Report 
    Quick Formatting with the Template 
    Allowing Multiple Values in Parameters
    Editing and Formatting Charts 
    Getting Help 
    Database Filtering with the Select Expert 
    Calculating Percentages 
    Unlinked versus Linked Subreports
    Basing Report Formulas or Conditional 
    Bottom N Report

  • See Training Course Details...


Crystal Reports 2013

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

  • Some of the training topics covered include ...
  • Conditional Running Totals Prompting with Parameters
    Using the Section Expert to Work with Sections Using the Running Totals Feature
    Selecting Records with Multiple Criteria
    Modifying Groups
    Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
    Exporting to a Report Definition Format Using the Report Wizards
    Unlinked versus Linked Subreports
    Group and Sort Direction
    Formatting Sections
    Drawing a Line
    Using Multiple Parameter Fields in Reports
    Autosaving the Report
    Understanding Crystal Formula Syntax
    Group Sorting with a Parameter
    Working with the Page Commands
    Create a Report Using the Standard Report Creation Wizard
    Creating a Cross-Tab Report
    HTML Preview
    Moving and Aligning Objects
    Linking a Subreport
    Conditionally Formatting Fields Creating Summary Reports and Charts

  • See Training Course Details...


Crystal Reports 2016

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

  • Some of the training topics covered include ...
  • Creating Boolean (True/False) Formulas
    Producing Charts
    Grouping on a Formula Field
    Format Painter
    Creating on-demand Subreports
    Charting Cross Tabs
    Editing Charts
    Adding Multiple Tables to a Report Creating and Using Formulas
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Using the PDF Format for Crystal Reports
    Manipulating Dates with Formulas
    Inserting Graphics
    Applying the Drill-Down Group Level
    Creating Text Objects
    Inserting Lines and Boxes
    The Formula Editor Toolbar
    Creating Hyperlinks Creating Powerful Groups
    Understanding Export Formats and Destinations
    Creating a Simple Report
    Working with the Page Commands
    Grouping Hierarchically Working with Cross-Tab Reports

  • See Training Course Details...


Crystal Reports XI

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

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

  • Some of the training topics covered include ...
  • Using Guides and Guidelines to Move and Align Objects
    Sorting Records within a Group
    Moving and Aligning Objects
    Working with the Page Commands
    Formatting Template Fields
    Using a Formula to Customize the Group Name Field
    Creating a Cross-Tab with Multiple Rows or Columns
    Using a Variable in a Formula
    Working with Arrays
    Formatting Part or All of an Object
    Modifying Groups
    Refreshing the Data
    Finding the Data
    Displaying Parameter Fields
    Creating Hyperlinks
    The Group Sorting Dialog Box
    Using the Chart Options
    Using Group Selection to Filter the Records in the Report
    Standard Report Creation Wizard and Templates
    Additional Summary Options
    Passing Data from the Main Report into a Subreport

  • See Training Course Details...


CSS3

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

  • Some of the training topics covered include ...
  • The @font-face Rule
    Strategies
    Frameworks and Grid Systems
    Image Borders
    Targeting Widths and Devices with CSS3 Media Queries
    Preprocessors
    background-origin, and background-size Borders and Box Effects
    Fonts on the Web
    The Target Pseudo-Class
    Implementing CSS3 in the "Real World"
    Video Formats
    What is CSS3?
    The CSS3 Speech Module
    Attribute Selectors
    Backgrounds
    Flexible Box Model Vendor Prefixes
    Responsive Images and the viewport Metatag

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

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

  • Some of the training topics covered include ...
  • Model Usage
    Microsoft Linear Regression Algorithm
    Data Modelling
    Cross Validation
    Microsoft Logistic Regression Algorithm
    Management
    Accuracy and Validation
    Cross Validation
    Microsoft Association Algorithm
    Microsoft Clustering Algorithm
    Saving Queries
    Data View
    Visio Data Mining Add-In  
    CRISP-DM
    The User Interface
    Microsoft Decision Trees Algorithm
    Creating Reports Using Reporting Services
    Data Source
    Multiple Nested Tables Microsoft Data Mining Algorithms

  • See Training Course Details...


Developing Websites for Mobile Devices

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

  • Some of the training topics covered include ...
  • Foundation: A Responsive Grid Framework
    Video Formats
    Framework: Foundation
    jQuery Mobile
    The Case for Flexible
    Media Queries
    Hosting Your Own Videos
    A First Look at Foundation
    Using data Attributes
    Drag-and-Drop Code Builder
    Mobile Focus
    The Flexible Grid: A More Responsive Layout Strategy
    Targeting Widths and Devices with CSS3 Media Queries
    Flexible Grids
    jQuery Mobile
    Handling Orientation Change

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Removing a Password From a Workbook Importing and Exporting
    Setting Save Options
    Creating an Error Message
    Editing Worksheet Comments
    Saving to OneDrive
    Providing Custom Names
    Exporting to Microsoft Word
    Finding the Percentage of Total
    Formatting a PivotTable
    Using the PivotChart Filter Field Buttons
    Grouping by Columns Summarising and Subtotalling
    Moving PivotCharts to Chart Sheets Advanced Filters
    Grouping in PivotTable Reports
    Disabling Tracked Changes
    Copying a Macro
    Using Compound Fields
    Testing a Validation
    Working With PivotTable Grand Totals
    Sharing Workbooks via the Network
    Adding a Combo Box Control
    Setting Excel Options

  • See Training Course Details...


Excel Basic

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

  • Some of the training topics covered include ...
  • Understanding Printing
    Vertical Cell Alignment
    Selecting Contiguous Ranges
    Launching Dialog Boxes
    Selecting Non Contiguous Ranges
    Italicising Text
    Navigating a Workbook
    Moving by Dragging Formulas and Functions
    Using Tell Me
    Copying From One Cell to a Range
    Printing an Embedded Chart
    Understanding the Backstage View
    Inserting Columns Into a Worksheet
    Printing a Chart Sheet
    Approximating Row Height
    Creating Formulas That Subtract
    Number Formatting
    Formulas That Multiply and Divide
    Using the SUM Function to Add
    Setting the Default Column Width

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • Quick Totals
    The ROUND Function
    Quick Formatting
    Adding a Data Table Chart Object Formatting
    Preparing for Complex Formulas
    More Top and Bottom Formatting
    Sorting Tables
    Understanding Chart Formatting
    Filling Using Options
    Formatting Calculated Time
    Understanding Conditional
    Renaming a Table
    Manipulative Functions
    Inserting Table Columns
    The TODAY Function
    More Cell Formatting Options
    Showing Data Labels
    Formatting
    Working With Icon Sets
    Values Conditional Formatting
    Using Goal Seek The Quick Analysis Tools

  • See Training Course Details...


Excel Power Pivot

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

  • Some of the training topics covered include ...
  • Working With the Data Model
    Formatting Power View Data
    Working With a Power View Object
    Enabling Power Pivot
    Transforming Data
    Tiling Data in Power View
    Rearranging and Sorting Fields
    Understanding Get & Transform
    Managing Data Columns
    Working With Power View Fields
    Working With Merged Queries
    Displaying the Query Editor
    Formatting Data Model Fields
    Adding a Data Column
    Reducing Data Rows
    Filtering Data
    Working With Scene Options
    Enabling Power View
    Working With Data Model Fields

  • See Training Course Details...


Excel Programming Using VBA

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

  • Some of the training topics covered include ...
  • Setting the Tab Order
    Understanding Errors
    Using the Object Browser
    Editing a Macro in the Visual Basic Editor
    Using Input Boxes
    Working with the Command Button Control
    Working with Inline Error Handling
    Working with UserForm Properties, Events, and Methods
    Running a Macro
    Understanding Expressions and Statements
    Understanding Control-of-Flow Structures
    Understanding Macro Security
    Working with Boolean Expressions
    Introducing Visual Basic for Applications
    Working with Option Button Controls
    Declaring and Using Object Variables
    Working with Procedures and Functions
    Understanding PivotTables
    Adding Code to Controls
    Using the For Each...Next Structure

  • See Training Course Details...


Flash ActionScript 3.0

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

  • Some of the training topics covered include ...
  • Using the Tween Class 
    Copy and Paste Tweens 
    Adding Properties to a Class 
    Using the Sound Class 
    Dynamically Adding Symbols to the Stage 
    ActionScript Events 
    Adding Asteroids to the Screen 
    Operators and Expressions 
    Adding Symbols to the Stage at Run-Time 
    Determine your Current Age 
    Formatting the Player Score TextField 
    Types of Conditional Statements 
    XML with EX 
    ActionScript Fundamentals 
    Handling Events 
    Accessing External XML Documents 
    Getting Started with Coding 
    Loops and Conditional Logic 
    Using the Enter Frame Event 
    The ActionScript Class Library 
    ActionScript Event Types 

  • See Training Course Details...


Google Script Programming

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

  • Some of the training topics covered include ...
  • JDBC Overview
    Practical Examples Using Spreadsheet And Sheet Objects The Range Object
    Creating A Table
    Getting And Setting Range Properties
    Practical Examples  MySQL and JDBC
    Database Metadata
    Introducing JavaScript Functions
    Method Overloading In Google Apps Script
    Custom User-Defined
    Date Functions
    Adding Users Building Simple Graphical Interfaces
    Creating A Range Object
    Using List Boxes Google Drive, Folders, Files and Permissions
    Setting Up Google Cloud SQL
    File And Folder Permissions
    Built-in Versus User-Defined Functions
    User-Defined Functions Versus JavaScript Functions
    JavaScript Scripting
    The Spreadsheet Object
    Calendars Web Apps With Html Service
    Using A Function Callback

  • See Training Course Details...


HTML

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

    No prior HTML or web development knowledge is assumed. 

  • Some of the training topics covered include ...
  • Start Attribute
    Phrase Elements
    Relative Paths
    XHTML vs. HTML
    Introduction to HTML
    Making Images Accessible
    Closing Tags
    Alternative Text
    Anchors
    Media Types and Units of Measurement
    Ordered Lists
    Select Menus
    Radio Buttons
    Adding a Caption
    Form Elements
    Selectors
    Benefits of Cascading Style Sheets
    name vs. id
    Merging Cells HTML Forms

  • See Training Course Details...


HTML 5

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

  • Some of the training topics covered include ...
  • Additional Changes
    Integrated APIs
    HTML5 Web Storage
    HTML5 Canvas
    Text Properties
    Modernizr
    Page Simplification
    Display of HTML5 Structural Elements
    HTML5 Audio and Video
    Circles and Arcs
    Web Database Storage
    HTML5 - Background
    HTML5 Forms
    Sectioning
    The Problems HTML 4 Addresses
    Scripting Media Elements
    Laying out a Page with HTML5
    Creating and Converting Video Files
    datalist

  • See Training Course Details...


JavaScript

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

    No prior programming knowledge is assumed.-

  • Some of the training topics covered include ...
  • Preloading
    ParseFloat() and parseInt()
    Focus, Blur, and Change Events
    Conditionals
    The HTML DOM
    Working with Images
    JavaScript Objects, Methods and Properties
    Basic Rules
    Validating Radio Buttons
    for Loop Syntax
    Switch / Case
    Storing User-Entered Data
    Image Rollovers
    Array Properties and Methods
    Built-in Functions
    typeof Operator
    Passing Values to Functions
    A Loosely-typed Language

  • See Training Course Details...


JQuery

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

  • Some of the training topics covered include ...
  • The Object Literal
    Events-
    Switch Statements
    Closures
    Traversing
    Convenience Methods
    About Custom Events
    Don't Treat jQuery as a Black Box
    Code Organization-
    The Module Pattern
    Namespacing Events
    Connecting Events to Run Only Once
    Checking Types
    Selecting Form Elements
    Use Event Delegation
    Avoid the Universal Selector
    Utility Methods

  • See Training Course Details...


JQuery Mobile

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

    Prior knowledge of HTML, CSS and JavaScript is required.

  • Some of the training topics covered include ...
  • PhoneGap
    Levels of Support
    Sliders
    Dialogs Widgets and UI
    plugin Architecture
    Video The Theme Framework
    Collapsible Blocks Events
    Basic Page Template
    Buttons and Toolbars
    Orientation (Portrait/Landscape)
    Making Calls
    Accessibility Support
    Progressive Enhancement
    Ajax-driven Page Navigation
    Dialogs
    Sending SMS Texts
    What Is jQuery Mobile?
    Creating Your Own Plugin

  • See Training Course Details...


Microsoft Access 2007

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

  • Some of the training topics covered include ...
  • Working with Outlook 2007  
    Setting validation rules Basic queries
    Adding Graphics
    Planning and designing databases
    Protecting databases
    Changing the design of a table
    Creating parameter queries
    Customized headers and footers
    Calculated fields
    Creating the AutoKeys and AutoExec macros
    Creating forms
    Using Design view
    Adding calculated values
    Subdatasheets Complex queries
    Working with input masks
    Labels Charts
    Adding calculated values
    Changing the design of a table
    Getting help Databases and tables
    Setting validation rules Basic queries
    Relating tables

  • See Training Course Details...


Microsoft Access 2010

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

  • Some of the training topics covered include ...
  • Planning and designing databases
    Exploring tables
    Adding graphics
    Creating and using queries
    Joining tables in queries
    Creating reports
    Creating macros for data transfer
    Writing SQL statements
    Database normalization
    Attaching SQL queries to controls Advanced queries
    Creating forms
    Finding and editing records
    Using calculated fields
    PivotCharts
    Importing, exporting, and linking
    Customized headers and footers
    Creating parameter queries
    Modifying PivotTables
    Adding unbound controls
    Creating tables Fields and records
    Importing objects

  • See Training Course Details...


Microsoft Access 2013

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

  • Some of the training topics covered include ...
  • Subdatasheets Complex queries
    Adding combo boxes
    SQL and Access
    Getting started
    Charts in forms
    Joining tables in queries
    Adding unbound controls
    Summarizing and grouping values Advanced form design
    Creating macros for data transfer Importing, exporting, and linking objects
    Adding calculated values
    Calculated values and subreports
    Modifying query results and queries
    Exploring tables
    Protecting databases
    Charts in reports Querying with SQL
    Using hyperlink fields Database management
    Printing
    Referential integrity Related tables
    Using Design view
    Graphics
    Sorting and filtering records Working with reports

  • See Training Course Details...


Microsoft Access 2016

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

  • Some of the training topics covered include ...
  • Sorting and Filtering
    Adding Records to a Table
    Parameter Queries
    Creating and Using Macros
    DIY Forms
    Modifying Forms
    Action Queries
    Modifying Table Structures
    Calculations in Queries
    Relational Database Design
    Formatting Tables
    Database Security
    Multi Table Queries
    Designing a Lookup Database
    Navigation Pane Protection
    Database Wellness
    Creating Queries
    Understanding VBA
    Creating a Lookup Database
    Querying Techniques
    Getting to Know Access 2016

  • See Training Course Details...


Microsoft Access Programming Using VBA

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

  • Some of the training topics covered include ...
  • Understanding Procedures
    Writing an Error-Handling Routine
    Understanding the Development Environment
    Understanding the Order of Events
    Setting Break Expressions
    Locking Records for Updating
    Naming Procedures
    Using Intrinsic Functions
    Determining the Value of Expressions
    Using the Select Case...End Select Structure
    Introduction to Programming in Access
    Why Program in Access?
    Using the If...End If Decision Structures
    Calling Procedures
    Setting Breakpoints
    Specifying a Recordset Cursor Type
    Using the For...Next Structure
    Understanding Expressions and Statements
    Using the For Each...Next Structure
    Considering Variable Scope and Lifetime Together
    Understanding the DoCmd Object

  • See Training Course Details...


Microsoft Excel Power Query

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

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

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

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

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

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

  • See Training Course Details...


Microsoft Power BI

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

  • Some of the training topics covered include ...
  • Topics covered include- Introducing Power BI
    Managing a Power BI solution
    Importing data into Power BI
    Power BI embedded
    Using Excel as a data source for Power BI
    The developer API
    Overview of the Power BI Data Model. Using Power BI
    Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
    Direct connectivity from Power BI desktop
    Use Power BI direct connectivity to access data in Azure SQL data warehouse
    Creating Power BI reports
    Custom visuals Power BI mobile app
    Create relationships between data tables.
    Create a Power BI dashboard
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    Importing different data sources into Power BI
    Viewing reports from Excel files Shaping and Combining Data
    Using databases as a data source for Power BI
    The Power BI Interface
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Shape data using formatting and transformations.

  • See Training Course Details...


Microsoft Power Graphics

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

  • Some of the training topics covered include ...
  • Examine map data.
    Examining Tiles
    Introduction to the PowerPivot Interface
    Working with Tables
    Perform data cleaning.
    Perspectives Power Query
    Hiding Columns, Change Data Type, Sorting, and Filtering
    Applying Filters
    Add time to a presentation.
    Hierarchies
    PowerPivot
    Load data.
    Theming Reports
    Creating Charts
    Merge datasets.
    Adding Slicers to Reports

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Analyzing the plan
    Creating a toolbar and a menu
    Working with advanced task options Managing resources
    Rescheduling tasks Formatting and reporting
    Sharing resources across projects Project communications
    Creating a task list
    Copying data
    Working with project files
    Resolving resource conflicts
    Working with views
    Creating base calendars
    Creating a custom table Managing multiple projects
    Observing project progress Analyzing and adjusting the plan
    Sorting tasks and resources Finalizing the task plan
    Communicating among a project team
    Formatting a project file
    Exporting data
    Working with filters
    Creating custom views
    Creating a Work Breakdown Structure Scheduling tasks
    Exploring the Project window

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  •  Macros
    Managing a project
    Monitoring progress Analyzing and adjusting the plan
    Project costs Views and tables
    Analyzing the plan Delays and conflicts
    Getting started
    Modifying a task list Task scheduling
    Task options Resource management
    The Project window
    Collaboration
    Working with views
    Resources and calendars
    Task links
    Working with templates Creating projects from other programs
    Gantt chart formatting
    Filters Groups Sorting tasks and resources Finalizing the task plan
    Sharing resources among projects Exchanging project information
    Hyperlinks
    Working with tables Filters, groups, and sorting
    Custom views
     Setting baselines

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Using templates and importing data
    Custom views
    Delays and conflicts
    Consolidating and sharing projects
    Hyperlinks
    Creating projects from other programs Managing a project
    The Project window
    Finalizing schedules
    Project files Tasks
    Sorting tasks and resources Finalizing the task plan
    Collaboration
    Custom fields Managing multiple projects
    Working with templates
    Analyzing and adjusting the plan
    Task relationships
    Setting baselines
    Analyzing the plan
    Project management concepts
    Modifying a task list
    Views and tables

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

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

  • Some of the training topics covered include ...
  • Assigning Daily Costs
    Setting Project Links
    Working With Task Views
    Computers and Project Management Creating a New Project
    Using Tell Me
    Working With Fixed Unit Tasks
    Creating Dependencies in Task
    Creating an Outline Code Mask
    Working With Multiple Files
    Editing Existing Filters
    Using a Custom Table
    Reviewing the Project
    Grouping Tasks
    Entering Public Holidays
    Contouring Work Hours
    Assigning Fixed Costs
    Understanding Tasks
    Working in a Sheet View
    Changing Rates During a Project
    Filtering Report Data
    Choosing Fields to Display in a Visual

  • See Training Course Details...


Microsoft Project 2016 Level 1

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

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

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

  • Some of the training topics covered include ...
  • Printing a Gantt Chart
    Starting Project in Windows
    Using Tell Me
    Entering Public Holidays
    Understanding Work Contouring
    Understanding the QAT
    Entering Lead Time
    Dependencies
    Understanding Resources
    Information
    Working With Task Views
    Tasks and Resources
    Modifying a Schedule Using
    Creating Dependencies in a Sheet
    Printing Sheet Views
    Understanding Lag Time
    Assignment – Creating Summary
    Resource Assignment Summary Assigning Resources
    Critical Path and Project Slack
    Creating Dependencies in Task Entry
    Understanding Task Durations

  • See Training Course Details...


Microsoft Project 2016 Level 2

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

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

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

  • Some of the training topics covered include ...
  • Deleting Unwanted Views
    Understanding the Data Tools
    Assigning Fixed Material
    Assigning Fixed Costs
    Placing Printing Commands on the
    Changing Bar Styles Advanced Printing
    Working With Multiple Files
    Applying a Different Cost Table
    Customising the View Menus
    Deleting an Unwanted Filter
    Changing Text Styles
    Working With the Legend
    Case Study Variable Costs
    Using Another Cost Table
    Adding Simple Custom Fields
    Creating a Deadline
    Using a Custom Table
    Creating a Simple Lookup Table
    Highlighting Tasks With Specific
    Changing Rates During a Project
    Highlighting a Range of Tasks

  • See Training Course Details...


Microsoft Project 2016 Level 3

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

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

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

  • Some of the training topics covered include ...
  • Understanding Visual Reports
    Template Linking and Combining Projects
    Custom Fields
    Creating a Lookup Custom Field
    Checking for Resource Links
    Understanding Project Templates
    Editing a Macro
    Understanding Project VBA
    Custom Fields
    Creating the Custom View
    Setting Project Links
    Creating the Downsized Master File
    Opening Shared Resource Projects
    Cloning an Existing Report
    Creating a Custom Filter for the View
    Creating a Read Only Subproject
    Manipulating Report Data
    Understanding Project Downsizing
    Running an Edited Macro
    Adding a Contact as a Resource

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

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

  • Some of the training topics covered include ...
  • XMLA scripting (SQL Mgmt Studio) 
    Advanced SSAS
    OLAP Modeling 
    Example cube as seen using Excel pivot table 
    Intermediate SSAS
    Data Mining clients 
    Other Documentation methods 
    Customizing Aggregation Design - Processing Design 
    Introduction to Data Mining
    Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions 
    Demonstration of SQL Reporting Services with cube as data source 
    Rapidly changing dimensions / ROLAP dimensions 
    Welcome to the Real Time - Proactive Caching 
    Security - roles and permissions 
    Introduction to Reporting Clients 
    Adding named sets 
    Business Scorecards 2005 & ProClarity 
    SPS RS web parts & .NET 2.0 report viewer controls 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

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

  • Some of the training topics covered include ...
  • The Execute SQL Task 
    SSIS Package Management
    Script in Control flow: The Script Task 
    Data Viewers 
    Data Sources 
    The Copy Column Transformation 
    The Data Mining Query Transformation 
    The Slowly Changing Dimension Transformation 
    Debugging , Error Handling and Logging
    Revisiting data sources and destinations 
    The Data Mining Model Training Destination 
    Scheduling packages with SQL Server Agent
    Configuration Overview 
    The SSIS script editor 
    SSIS for DBAs: Using SQL Server Management Studio
    Data Transformations 
    Breakpoints in SSIS 
    Introduction to Data Flow
    The Merge and Merge Join Transformations 
    The Lookup Transformation 
    Deploying and Managing SSIS Packages 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

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

  • Some of the training topics covered include ...
  • Design Reports using Reporting Services
    Consider Data Mining Clients
    Understand the Cube Structure
    Learn how to Create Key Performance Indicators (KPIs)
    Implement Proactive Caching
    Customize Cube and Dimension Processing
    Understand the Development Environment
    Understand Performance Tuning and Optimization
    Explore how to add MDX Script Commands
    Design Reports by using Report Builder
    Customize Aggregation Designs
    Using SSAS in BIDS
    Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
    Create Cubes by using the Cube Wizard
    Cube Storage and Aggregation
    Intermediate SSAS
    Introduction to SSAS Clients
    Create Data Source Views
    Introduction to MDX Queries

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

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

  • Some of the training topics covered include ...
  • Scripting and Custom Components
    Handling Slowly Changing Dimensions 
    Create a Package Deployment Utility 
    Using Integration Services Beyond ETL 
    Deploying Packages 
    Best Practices for Package Development and Design 
    Deployment and Management Best Practices 
    Data Flow Best Practices 
    Working with Workflow Tasks 
    Variables and Configurations
    Packaging Logging 
    Data Flows
    Using Variables in Control Flow 
    Understanding Variables 
    Synchronous and Asynchronous Transformations 
    Migrating and Maintaining SQL Servers with Integration Services 
    Understanding Integration Services 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

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

  • Some of the training topics covered include ...
  • Deploy a multidimensional model.
    Creating a Cube
    Introduction to Microsoft SQL Server Analysis Services
    Utilizing Attributes
    Understanding the Tabular Model
    Handling Hierarchies.
    Deploying
    Relating with Relationships
    Configuring Cube Options
    Understanding the Multidimensional Model
    Choosing the Right Model
    Processing Strategies
    Analysis Services Installation and Architecture: One Product, Two Models
    Analysis Services Tools.
    Understand and utilize security.
    Browsing Perspectives and Translations
    Examining Deployment Options
    Managing Measures
    Version Changes of SSAS from 2008-2014

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

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

  • Some of the training topics covered include ...
  • Understanding Parameters SQL Server Integration Services Tools
    Working with XML
    Managing with Control Flow
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Performing Joins with the Merge Transformation
    Utilizing Container Loops Performing Joins
    Utilizing Data Preparation Tasks
    Examining the SSIS Engine
    Working with Advanced Logging and Reporting
    Understanding Packages
    Coding the Script Task
    Moving Data with Data Flow
    Data Loading with the Analysis Services Tasks
    Version Changes of SSIS From 2008-2012
    Understanding Variables
    SQL Server Integration Services Architecture
    Creating SQL Server Integration Services Packages
    Choosing the Script Task or Script Component
    Optimizing Sources for Extraction
    Handling Errors Common SQL Server Integration Services Design Patterns
    Understanding Deployment Strategies 

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

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

  • Some of the training topics covered include ...
  • Mastering Data Region(s)
    Utilizing Lists
    Examining Maps
    Working with Expressions
    Exploring Table or Matrix Wizard
    Examining Parameters
    Visualizing Your Company Report Templates
    Working with Datasets
    Using Tables
    Examining Security
    Understanding HTML5 and Textboxes
    Formatting Reports
    Understanding Visualizations
    Planning Your Reports
    Exploring Matrix
    SQL Server 2016 Report Builder Advanced Reporting
    Examining Management
    Understanding Report Parts
    SQL Server 2016 Report Builder Graphics
    Utilizing Chart Wizard

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

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

  • Some of the training topics covered include ...
  • Browse a Model Using the Microsoft Association Rules Viewer
    View or Change Modeling Flags
    Browse a Model Using the Microsoft Naive Bayes Viewer
    Delete a Mining Model from a Mining Structure
    Browse a Model Using the Microsoft Sequence Cluster Viewer
    Topics include- SSAS Data Mining
    Create a Data Mining Dimension Testing and Validation
    Create a Lift Chart, Profit Chart or Classification Matrix
    Microsoft Time Series
    Create a Data Mining Query by Using XMLA
    Microsoft Linear Regression Microsoft
    Deploy a Data Mining Solution to Previous Versions of SQL Server
    SSAS Data Mining Tools
    Microsoft Clustering
    Microsoft Naive Bayes
    Browse a Model Using the Microsoft Time Series Viewer
    Create a Prediction Query Using the Prediction Query Builder
    Import a Data Mining Project using the Analysis Services Import Wizard
    Nested Tables
    Create a Cross-Validation Report

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

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

  • Some of the training topics covered include ...
  • Define Attribute Relationships
    Create Measures and Measure Groups
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Create a Dimension by Using an Existing Table
    Dimension permissions
    Rename a Multidimensional Database Processing a multidimensional model
    Create an Analysis Services Project
    Change a Partition Source
    Create a Data Source
    Error Configuration Roles and Permissions
    Define Semiadditive Behavior
    Modify or Delete an Analysis Services Database
    Define a Referenced Relationship and Referenced Relationship Properties
    Deployment Requirements and Considerations for Analysis Services Deployment
    Create Named Sets
    Supported Data Sources
    Designing Aggregations
    Tools and Approaches for Processing
    Delete a Data Source View Dimensions
    Add a Standard Action
    Database permissions

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

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

  • Some of the training topics covered include ...
  • Tabular model designer
    Sort Data in a Table
    Create and Manage KPIs Hierarchies
    Create a Relationship Between Two Tables
    Create a New Tabular Model Project
    Create and Manage Tabular Model Partitions
    Topics include- Overview of SSAS Tabular models
    Rename a Table or Column
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Object-level security
    Define partitions in DirectQuery models
    Add a table Delete a Table
    Delete a Column
    Delete Relationships
    Create and Manage Roles
    Row filter mappings
    Import from Power View
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create and Manage Hierarchies Partitions
    Process Tabular Model Partitions
    Manage Roles by using SSMS

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

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

  • Some of the training topics covered include ...
  • Data filters
    Use report services configuration manager to reconfigure SSRS servers.
    Introduction to reporting services
    Preparing data for mobile reports
    Work with expressions and embedded code.
    Overview of mobile reports
    Schedules
    Databars, sparklines, indicators, gauges, and maps
    Mobile report publisher
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Configuring data access with report builder
    Sorting and grouping
    Configuring data access with report designer
    Report caching, snapshots, and comments
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Topics include Introduction to Reporting Services
    Reporting services components
    Reporting services tools Reporting Services Data Sources
    Implementing report filters and parameters Visualizsng Data with Report Services
    Creating a report with the report wizard
    Use databars, sparklines, and indicators in reports Summarising Report Data

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

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

  • Some of the training topics covered include ...
  • Creating a New Request
    Narrative View
    Understanding the Dashboard Structure
    Reusing Filters
    View XML and SQL Calls Administering The Presentation Catalog
    About Business Intelligence
    Basic Navigation Using A Dashboard
    Variable References
    No Results View Using Pivot Table Views
    Databases and Data Models
    Column Selector View
    Defining the Pivot View
    Totals within Pivot Tables Advanced Formatting
    Using Prompts to Filter Data
    Managing Dashboard Objects Creating a Report
    Managing the Views Using Secondary Views
    Oracle BI Architecture
    Navigating the Answers Interface
    Creating a Dashboard
    Managing Presentation Catalog Objects Deploying Requests to Dashboards
    Managing Saved Content

  • See Training Course Details...


Oracle PL/SQL

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

  • Some of the training topics covered include ...
  • Selecting into a Variable 
    Compile-Time Warnings 
    Dates and Timestamps 
    Iterating Through Collections 
    Using Packages 
    Collection Methods 
    Assignment and Conversions 
    Row-Level Triggers 
    Anchored Types 
    The DBMS_METADATA Package 
    Large Object Types 
    Temporary LOBs 
    FOR UPDATE Cursors 
    Calling a Stored Function 
    Stored Procedures and Functions
    Maintaining PL/SQL Code 
    Calling a Stored Procedure 
    Cursor Parameters 
    PL/SQL Variables and Datatypes 
    Package Variables 

  • See Training Course Details...


Oracle SQL

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

  • Some of the training topics covered include ...
  • Using Oracle SQL*Plus 
    The SELECT Statement 
    SQL*Plus Substitution Variables 
    Self Joins 
    Aggregate Functions and Advanced Techniques 
    Interactive SQL*Plus Scripts 
    Graphical Clients 
    Review of Relational Database Terminology 
    SQL*Plus LOB Support 
    Using SQL Functions 
    SQL Functions 
    IN and BETWEEN 
    Selecting from Multiple Tables 
    Relational Database and SQL Overview 
    Relational Database Management Systems 
    The SQL Buffer 
    Pattern Matching: LIKE and REGEXP_LIKE 
    Data Definition and Control Statements 
    String Functions 
    Updatable Views 

  • See Training Course Details...


PHP

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

  • Some of the training topics covered include ...
  • Form Validation and Presentation Functions 
    Defining and Calling Functions 
    File System Management 
    Alternatives ( | ) 
    for 
    PHP Statements and Whitespace
    Magic Quotes
    If Conditions 
    Reading from Two-dimensional Arrays 
    How PHP Works 
    Escape Character ( \ ) 
    Authentication with PHP and SQL 
    Working with Loops 
    Arrays 
    Start and End ( ^ $ ) 
    Reading from a File 
    Inserting Records 
    PHP Operators 
    Looping through Arrays 
    PHPMailer 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Modifying objects
    Diagrams Modifying presentations
    Getting help New presentations
    Slide shows Proofing and delivering presentations
    Adding shapes
    Animations
    Formatting paragraphs Using drawing objects
    Slide masters
    Media clips
    Speaker notes
    Formatting text
    Building slides from Word outlines
    Getting started
    Clip art Using tables and charts
    Printing presentations Customizing PowerPoint
    Finishing a presentation
    Embedding and linking content
    Creating presentations
    Using text in objects Working with graphics

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Working with slides Editing slide content
    Preparing a presentation
    SmartArt Preparing and printing presentations
    Working with charts
    Applying content to shapes Graphics
    Getting started
    Embedding and linking content Finalizing and distributing presentations
    Distributing presentations
    Working with SmartArt graphics
    Reviewing and finishing
    Printing presentations
    Transitions and timings
    Applying content from a Word outline
    Creating a basic presentation
    Application settings
    Customizing tables
    Customizing PowerPoint
    Media clips
    Formatting shapes

  • See Training Course Details...


PowerPoint 2016 Advanced

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

  • Some of the training topics covered include ...
  • Aligning Table Data
    Saving a Presentation as a PDF
    Merging and Splitting Cells
    Saving a Custom Template
    Applying a Chart Style
    Inserting a Picture From File
    Applying Shading
    Creating a Template From a Theme
    Presenting a Slide Show Online
    Inserting a Table Using the Ribbon
    Animating Objects
    Understanding Templates
    Adjusting Column Widths
    Understanding Picture
    Chart Elements
    Working With PowerPoint Designer
    Resizing and Positioning a Table
    Slide Masters
    Using an Existing Template
    Changing the Layout of Chart

  • See Training Course Details...


PowerPoint 2016 Basic

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

     

  • Some of the training topics covered include ...
  • Understanding Font Formatting
    Inserting New Slides
    SmartArt
    Moving and Resizing Placeholders
    Inserting and Formatting Text
    Changing the SmartArt Layout
    Using Tell Me
    Working With Text
    Adding Sections
    Changing the Slide Layout
    Brilliant Presentations
    Presentations
    Launching Dialog Boxes
    Applying a Colour Scheme
    Printing the Outline
    Editing Shapes
    Presentation
    Creating a New Blank Presentation
    Inserting a Picture With Caption Slide

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Publication setup
    Building blocks
    Typography
    Navigation and selection techniques
    Object positioning
    Text boxes
    Publisher Help
    Modifying form properties
    Getting started
    Web site publishing
    Customizing the Ribbon
    Catalog merge
    Form letters
    Stacking and grouping objects
    Graphics in typography
    Table structure

  • See Training Course Details...


Publisher 2013

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

  • Some of the training topics covered include ...
  • Changing The File Type
    Creating Folded Cards
    Previewing A Publication
    Inserting Text
    Linking Text Boxes
    Applying A Text Style
    Inserting Online Pictures
    Inserting Pages
    Picture Formatting And Effects
    Selecting A Merge Area Layout
    Creating Ruler Guides
    Entering Text In A Table
    Understanding How Help Works
    Inserting Page Numbers
    Safely Closing A Publication Working With a Publication
    Grouping Shapes
    Selecting Text
    Adjusting Rows And Columns
    Using The Pages Navigation Pane
    Formatting Text Fields
    Accessing The Backstage View

  • See Training Course Details...


Publisher 2016

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

  • Some of the training topics covered include ...
  • Checking Spelling
    Getting Help
    Working With Pictures
    Text Effects
    Cropping Pictures
    Moving Pages
    Accessing the Help Window
    Creating a Product List
    Selecting Text
    Applying a Text Style
    Deleting Pages
    Safely Closing a Publication
    Naming Pages
    Resizing Shapes
    Adjusting Rows and Columns
    Drawing Text Boxes Accurately
    Sorting a Merge
    Previewing a Publication
    Saving for Photo Printing
    Modifying a Text Style

  • See Training Course Details...


SQL

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

  • Some of the training topics covered include ...
  • Relational Databases
    Common Math Functions    
    Benefits of Views 
    Sorting By Multiple Columns  
    The NOT Operator 
    Common String Functions
    Creating Tables
    Simple SELECT Statements
    Data Types
    DELETE   
     Using the WHERE clause to check for greater or less than
    Foreign Keys   
    Primary Keys
    Table Aliases  
    Mathematical Calculations
    Comments
    Sorting By a Single Column

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

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

  • Some of the training topics covered include ...
  • Current Classroom Folder Structure
    Reporting Services 2005 Toolbars
    Sorting
    Create a Dataset
    Report Design Options
    Building a Table Report
    Understanding System-level Roles
    Modifying the Data Source View
    Reporting Services 2005 Query and Report Parameters
    Previewing a Report
    Security
    Data Output
    Identifying Field
    Building a Matrix (Cross-tab) Report
    Auditing and Management Reports
    Adding Groups to Reporting Services
    Deploying a Report Model
    Server Management Reports

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

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

  • Some of the training topics covered include ...
  • Investigate how Reporting Services secures access to reports and other Reporting Services resources 
    Discover how to add textboxes and other controls to reports 
    Investigate how to manage Reporting Services projects using Report Manager 
    Managing Reporting Services
    Learn how to enable basic authentication for reports and how to require SSL for report operations 
    Grouping and Sorting
    Explore the storing of credentials within a data source 
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    Find out how you can use conditional formatting to make your reports more dynamic 
    Explore the use of Reporting Services gauges 
    Snapshots and Subscriptions
    Understand how to plan and configure for deployment 
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Gain a basic understanding of the components behind SQL Server Reporting Services 
    Security
    Introducing SQL Server Reporting Services
    Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

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

    The course requires a working knowledge of SQL.

  • Some of the training topics covered include ...
  • Profile OLTP Data
    Troubleshoot Package Failures Deploying Packages
    Create an SSIS Project
    Deploy SSIS Packages
    Create Expressions with Variables
    Overview of Data Warehouses
    Work with Windows Azure
    Add Packages to an SSIS Project Managing Control Flow
    Overview of Data Warehouse Components
    Install Integration Services Working with Integration Services
    Add Data Flow Components to a Data Flow Task
    Add Script Tasks and Script Components to an SSIS Package
    Secure Packages
    Configure MDS
    Secure Databases Working with MDS and Windows Azure
    Introduction to Data Warehouses
    Debugging and Troubleshooting Packages
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Perform Transformation Tasks

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

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

  • Some of the training topics covered include ...
  • The Tablix Properties Dialogue Box
    Introduction to SQL Server Reporting Services
    Providing a Drop-Down List for a Report Parameter
    Building a Tabular Report
    Sparkline
    A Tour of the Report Builder Interface
    Create a Pie Chart with Point Labels
    No Data Rows
    Create a Data Source Connection
    User Collection
    Create a Drop-Down List Parameter
    Drilldown Reports Managing Page Layout and Adding Interactivity
    Multivalued Parameters Dynamic Reports with Parameters
    Formatting Tablix Rows and Columns Making Reports Interactive
    Installing and Configuring Reporting Services Reporting Services Architecture
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Report Parameters
    Building a Matrix Report
    Introducing SQL Server Data Tools
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Globals Collection Creating Custom Functions

  • See Training Course Details...


Transact SQL

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

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

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

  • Some of the training topics covered include ...
  • Work with the XML Data Type Sorting and Filtering Data
    Manage Views
    Work with PIVOT and UNPIVOT
    Sort the Queried Data
    Manage Transactions Querying SQL Server System Metadata
    Work with Binary Data Types
    Manage Query Plans
    Update Data
    Getting Started with SQL Server 2012
    Implement Error Handling
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
    Overview of T-SQL
    Manage Stored Procedures
    Work with SSMS Working with T-SQL
    Analyze Data from Query Plans
    Modifying Data
    Work with Variables and Batches
    Merge Data Working with SQL Server Built-in Functions
    Write CASE Expressions Working with SQL Data Types
    Create Queries Using Built-in Functions

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Network diagrams
    Introduction to advanced features
    Creating and setting up a drawing
    Software and database diagrams
    Reporting Creating technical layouts
    Integration with PowerPoint
    Special drawing operations
    Web site maps
    Formatting shapes and lines
    Basic diagrams
    Documenting software systems
    Custom properties
    Organization charts
    Formatting drawings
    Working with Web-enabling features
    Database model diagrams

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Working with Web-enabling features Software and database diagrams
    Layout and connection techniques
    Brainstorming diagrams Customization and reporting
    Integration with PowerPoint
    Network diagrams
    Custom themes
    Web site maps Integrating Visio with other programs
    Integration with Microsoft Word
    Rack diagrams
    Formatting shapes and lines Working with pages
    Basic shapes and lines
    Working with links Network and brainstorming diagrams
    Organization charts
    Integration with Microsoft Outlook
    Compound lines
    The Visio 2010 interface
    Documenting software systems
    Shape properties
    Creating a basic diagram
    Creating technical layouts
    Working with text

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Custom shapes and stencils
    Business diagrams and Web site mapping
    Integration with Microsoft Word
    Formatting shapes and lines
    Windows, stencils, and objects
    Working with pages
    Shape properties
    with background pages
    Brainstorming diagrams
    Documenting software systems
    Layout and connection techniques
    Displaying shape dimensions
    Working with text
    Presenting diagrams in Visio and HTML

  • See Training Course Details...


Word 2010 Advanced

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

  • Some of the training topics covered include ...
  • Applying Numbering
    Applying Right Indents
    Defining A Number Format
    Bookmarks
    Saving Building Blocks
    Understanding Styles
    Sorting Table Data
    Renumbering A List
    Applying First Line Indents
    Applying A Theme
    Inserting A Building Block
    Typing Text Into A Text Box
    Saving AutoText
    Templates
    Customising The Columns
    Understanding Tables Of Contents
    Understanding Lists

  • See Training Course Details...


Word 2010 Basic

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

  • Some of the training topics covered include ...
  • Formatting
    Minimising The Ribbon
    Counting Words Working With Text
    Understanding Font Formatting
    Page Layout
    Showing Paragraph Marks
    Using The Blank Document
    Launching Dialog Boxes
    Inserting Mail Merge Fields
    Understanding Headers And
    Modifying Tabs On The Ruler
    Previewing The Merged Documents
    Quick Printing
    Understanding Dialog Boxes
    The Save As Dialog Box
    Positioning The Drawing Canvas

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Spelling and grammar
    Find and replace Formatting text
    New documents
    Working with styles
    Headers and footers
    Character formatting
    Working with text
    The Word window
    The Undo and Redo commands
    Examining formatting
    Working with table content
    Tab settings
    Working with graphics Styles and outlines
    Page setup
    Table data Page layout
    Changing the table structure
    Getting started
    Adding graphics and clip art
    Table design options
    Cut, copy, and paste

  • See Training Course Details...


Word 2016 Level 1

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

  • Some of the training topics covered include ...
  • Understanding Paragraph Formatting
    Saving a New Document on Your
    Autofitting Columns
    Using Tell Me
    Adding Bullets to Existing Paragraphs
    Setting Tab Leaders
    MICROSOFT WORD 2016 LEVEL 1
    Creating a Recipient List
    Removing Page Breaks
    Quick Printing
    Inserting a Date
    Inserting an Online Picture
    Setting Mixed Tabs
    The Open Place
    Page Zooming
    Underlining Text
    Using the Font Dialog Box
    Setting Tabs in the Tabs Dialog Box
    Removing Page Numbers
    Increasing and Decreasing Font Size

  • See Training Course Details...


Word 2016 Level 2

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

  • Some of the training topics covered include ...
  • Selecting the Recipients
    Colouring Pictures
    Challenge Exercise Data
    Sorting Table Data
    Linking Text Boxes
    Inserting a Page Break
    Completing the Merge
    Moving Shapes
    Inserting a Preformatted Text Box
    Editing Headers and Footers
    Customising the Columns
    Applying Effects to Text Boxes
    Attaching a Template to a Document
    Inserting a Continuous Section Break
    Splitting Table Cells
    Arranging All
    Changing Text Direction
    Understanding File Locations
    Inserting a Next Page Section Break

  • See Training Course Details...


Word 2016 Level 3

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

  • Some of the training topics covered include ...
  • Using Comments in Tracked Changes
    Setting the Default Language
    Password
    Footnotes and Endnotes
    Indexing
    Inserting a Drop Down List Control
    Protecting Documents
    Understanding Footnotes and
    Customising the Grammar Checker
    Comparisons
    Working With Formatting
    The Field Dialog Box
    and All Markup
    Modifying the Index Format
    Working With Master Document
    Inserting Text
    Customising a Table of Contents

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730