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 ...
  • Add Colour to 3D Objects
    Understanding the CSS Designer Panel
    Creating a Web Photo Gallery
    Understanding CSS Rules
    Inserting an Image Using Element Quick View
    Sharpening Images With the Unsharp Mask
    Working With Images
    Sharing Libraries
    Opening a File From the Welcome Window
    Setting Element Width and Height
    Creative Cloud Libraries
    Saving Layer Effects as a Style
    Understanding the Help Menu
    Understanding the Internet
    Understanding Workspaces
    Copying and Pasting Text
    Understanding TypeKit
    Understanding Code View
    Understanding Site Structure
    Understanding Floating Elements
    Working With Views in Bridge

  • 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 ...
  • Expanding Paths in a Traced Image
    Making Marquee Selections
    Adobe Creative Cloud Application Manager
    Creative Cloud Libraries
    Packaging a Document
    Working With Files and Folders
    Understanding File Formats
    Swapping Fill and Stroke Colours
    Moving Objects
    Working Collaboratively
    Understanding Colour Themes
    Adobe Creative Cloud Mobile Apps
    Moving and Resizing Artboards
    Working With Workspaces
    Working With Objects
    Applying Live Paint Fill
    Drawing a Straight Path With the Pen Tool
    Copying Formatting With the Eyedropper Tool

  • 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 ...
  • Applying Character Styles
    Working With Tracked Changes
    Understanding Workspaces
    Applying Transparency
    Generating a Simple Index Creating a Simple E-Publication
    Arranging Objects
    Printing a Document
    Understanding Alternate Layouts
    Exporting to PDF
    Displaying and Hiding Rulers
    Creating a Style From Existing Formatting
    Placing Graphics in an Outline Working With Graphics
    Creating a Table of Contents Style
    Splitting the Document Window
    Adding People to Your Library
    Working With Tabbed Documents
    Navigating Pages
    Adjusting Tracking
    Creating a Gradient
    Using Online Help
    The Adobe Account

  • 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 ...
  • Using the Polygonal Lasso Tool
    Understanding the Properties Panel
    Creating a Web Photo Gallery
    Understanding the Print Dialog Box
    Colour Fundamentals
    Blending Images
    Printing Single Images
    Understanding the Tools Panel
    Using Smart Guides to Position Shapes
    Reducing Camera Shake
    Working With Text
    Editing a Smart Object in Illustrator
    Understanding Vector Based Text
    Adobe Creative Cloud Application Manager
    Understanding the Preferences Dialog Box
    Customising and Saving Workspaces
    Understanding the Save for Web Dialog Box
    Using Adjustment Presets
    Tonal and Colour Corrections

  • 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 ...
  • Configuring for ASP.NET Core MVC
    Routing in ASP.NET Core MVC
    HTTP Testing Tools
    Rendering Views
    REST and Web API
    ASP.NET Web API Clients ASP.NET Core and Azure
    Using Postman
    Using ADO.NET The Controller
    What Is Windows Azure?
    Unit Testing Getting Started with ASP.NET Core MVC
    HTTP Response Codes
    Serving Static Files
    Attribute Routing ASP.NET Core Web API
    Introduction to ASP.NET Core MVC
    Advantages and Disadvantages of Web Forms
    Validation Attributes Routing
    Controller Base Class
    Using ViewBag
    A Windows Azure Testbed
    Using Dynamic Objects
    Form Submission

  • 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 ...
  • Simple Input Controls 
    LINQ to DataSets 
    Security Trimming 
    Using the Web Site Administration Tool 
    Allow Users to Select from a DropDownList in the Grid 
    The Calendar Control 
    Using Rich Server Controls 
    Reading and Write Data Using the SqlDataSource Control 
    Using the Complex Validators 
    Writing Code to Interact with Membership and Roles 
    Add a Hyperlink to the Grid 
    Programming Configuration Files 
    Using the Visual Debugger 
    Language Integrated Query 
    Introducing Data Source Controls 

  • 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 ...
  • ASP.NET Web Applications 
    Programming Configuration Files 
    Displaying Data with the GridView Control 
    Encrypting Configuration Sections 
    Add a Hyperlink to the Grid 
    Deleting a Row and Handling Errors 
    CSS 
    Overview of ASP.NET Validation Controls 
    Using Cookies to Preserve State 
    Language Integrated Query 
    Simple Input Controls 
    Creating an XML Site Map File 
    Displaying XML Data Using the XmlDataSource Control 
    Configuration Overview 
    Server-Side Code Debugging in ASP.NET 
    Using Membership Controls 
    Writing Code to Interact with Membership and Roles 
    Application State 

  • 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 ...
  • Inserting Graphics 
    What are Report Alerts
    Grouping on a Formula Field
    Separating Statements in Complex 
    Understanding Crystal Formula Syntax 
    Learning about Linking 
    Creating a Cross-Tab with Multiple Rows or Columns
    Parameters
    Bottom N Report
    Working with Variables
    Creating Custom Groups
    Declaring a Variable
    The Fields Dialog Box 
    Using Multiple Parameter Fields in Reports
    Selecting Records with Multiple Criteria 
    Creating Text Objects 
    Filter Types of the Select Expert 
    Working with the Page Commands 
    Viewing and Editing the Select Formula 
    Grouping Hierarchically

  • 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 Subreports to Link "Unlinkable" Data 
    Sorting Records within a Group 
    Formatting Sections 
    Using Bookmarks to Navigate Through Formulas 
    Applying the DrillDownGroupLevel 
    Creating Report Alerts
    Choosing a Data Source 
    Creating Running Totals for a List of 
    Applying the Drill Down Feature 
    Creating a Cross-Tab Report
    Starting the Crystal Reports Program 
    Editing and Formatting Charts 
    Creating Text Objects 
    Understanding the Formula Evaluation 
    Selecting Records with Multiple Criteria 
    Adding Multiple Tables to a Report 
    Group Sorting with a Parameter
    Exporting Your Reports Within Your Organization
    Managing Resources with Explorers 

  • 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 ...
  • Creating Running Totals for a List of Numbers
    Inserting Graphics
    Parameter Fields Overview
    HTML Preview
    Inserting Lines and Boxes
    Formatting Sections
    Quick Formatting with the Template Expert
    Creating a Summary Report
    Creating a Dynamic Value List
    Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
    The Main Components of the Design  Window
    Working with Text Objects
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Using Multiple Sections in Reports
    Producing Charts
    Modifying Individual Objects in the Chart
    Creating Custom Groups
    Creating Report Alerts
    The Fields Dialog Box
    Formatting Part or All of an Object
    Starting the Crystal Reports Program

  • 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 a Group
    Grouping on a Formula Field
    Choosing a Data Source
    Unlinked versus Linked Subreports
    Exporting to Windows Applications
    Creating Multiple Groups in a Report
    Using the Chart Options
    Quick Formatting with the Template Expert
    Sorting with a Parameter
    Using a Parameter Field
    Parameter Field Considerations
    Creative Usage for Report Alerts    
    Case Sensitive vs. Case Insensitive
    Using Multiple Parameter Fields in Reports
    Customizing Group Sort Order
    Filter Types of the Select Expert
    Moving and Aligning Objects
    Conditionally Formatting Fields Creating Summary Reports and Charts
    Working with Arrays
    Using the Preview Panel
    Format Painter

  • 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 ...
  • Understanding Tables, Records, and Fields
    Crystal Reports XI Before You Begin
    Saving the Report
    Case Sensitive vs. Case Insensitive
    Using Parameters in Conditional Formatting
    Creating a Group
    Using a Formula to Customize the Group Name Field
    Declaring a Variable
    Sorting with a Parameter
    Selecting Certain Records
    Pass #1
    Creating Running Totals for a List of Numbers
    Learning about Linking
    Understanding How Crystal Reports Processes the Data
    Creating a Dynamic Value List for Parameter Values
    What are Report Alerts
    Creating Report Alerts
    Separating Statements in Complex Formulas
    Creating Summary Reports and Charts
    Using a Parameter to Select Records
    The Main Components of the Design Window

  • 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 ...
  • Flexible Box Model Vendor Prefixes
    Strategies
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Transitions Layout: Columns and Flexible Box
    Transitions and Transforms
    Attribute Selectors
    Browser Support
    UI Element States Pseudo-Classes
    Video Formats
    The CSS3 Speech Module
    What Are Vendor Prefixes
    HTML5 Selectors and Pseudo Classes
    The @font-face Rule
    The Target Pseudo-Class
    Preprocessors
    Responsive Images and the viewport Metatag
    Targeting Widths and Devices with CSS3 Media Queries

  • 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 ...
  • The Mining Model Prediction Tab
    The User Interface
    Microsoft Clustering Algorithm
    Concepts and Terminology
    Management
    Creating Reports Using Reporting Services
    Microsoft Logistic Regression Algorithm
    Microsoft Naïve Bayes Algorithm
    Topics include:
    Data View
    Visio Data Mining Add-In  
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Microsoft Linear Regression Algorithm
    Model Usage
    Introduction to SQL Server Data Tools
    Data Mining and Results
    Connection
    Compare Mining Structures
    Accuracy and Validation
    Offline Mode and Immediate Mode

  • 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 ...
  • Media Queries
    Handling Orientation Change
    Other Devices
    Using max-device-width
    A First Look at Foundation
    Consolidating the Web with Native Extensions
    Controlling the Video through JavaScript
    Hosting Your Own Videos
    jQuery Mobile
    Gestures
    Using data Attributes
    Flexible Background Images
    Hiding Browser UI
    The Case for Flexible
    Accessing Camera, Contacts, Calendar, and More - But Not Yet
    Media Queries
    GeoLocation API
    Swiping to Change Pages
    New HTML5 Features
    The Viewport

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Using One-Variable Data Tables
    Creating a Scenario Summary Report
    Understanding Data Linking
    Adding Option Button Controls
    Changing Control Properties
    Understanding Data Validation
    Creating Slicers
    Using the DCOUNT Function Validating Data
    Defining the PivotTable Structure
    Sharing Workbooks via the Network
    Creating an Error Message
    Importing Tab Delimited Text
    Accepting or Rejecting Changes
    Importing Comma Delimited Text
    Understanding Text File Formats
    Enabling Tracked Changes
    Setting Formula Options
    Switching PivotTable Fields
    Setting Macro Security
    Understanding Data Protection
    Using DSUM

  • 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 ...
  • Deleting Rows and Columns
    Other Sources of Assistance  
    Extracting With Flash Fill Moving Data
    Launching Dialog Boxes
    Sorting on More Than One Column Filtering Data
    Previewing Before You Print
    Setting Precise Columns Widths
    Specifying the Number of Copies
    What if Formulas
    Typing Dates
    Using Undo and Redo Selecting Ranges
    Inserting Cells Into a Worksheet
    Printing an Embedded Chart
    Creating Absolute References
    Adding Commands to the QAT
    Accessing the Help Window
    Setting the Default Column Width
    Growing and Shrinking Fonts
    Creating Formulas That Subtract
    Calculating an Average

  • 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 ...
  • Removing Borders
    Creating Names Using the Name Box
    Splitting Windows Page Setup
    Drawing Borders
    Using Shape Effects
    Scoping Names to a Worksheet
    Renaming a Table
    Changing the Colour of a Series
    Applying Alternate Date Formats
    Using the More Borders Command
    Sorting Tables
    Using Page Break Preview
    More Complex Flash Fill Extractions
    Selecting Chart Objects
    Setting the Print Area
    Inserting or Deleting Table Records
    The More Borders Command
    Adding a Trendline
    The LOOKUP Function

  • 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 ...
  • Creating a New Query From a File
    Enabling Power Pivot
    Filtering in Power View
    Creating a Timeline
    Creating a Power View Sheet
    Switching Visualisations
    Working With Scenes
    Adding Titles and Images
    Creating a Power Map Tour
    Power Map
    Rearranging and Sorting Fields
    Reducing Data Rows
    Working With Power View Fields
    Understanding Power View
    Creating a Data Model PivotTable
    Adding a Data Column
    Viewing and Editing a Tour
    Working With Merged Queries
    Understanding Power Map

  • 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 ...
  • Working with Option Button Controls
    Using the Select Case...End Select Structure
    Understanding Collections
    Using Break Mode during Run mode
    Understanding Objects
    Controlling Program Execution
    Creating a Standard Module
    Navigating the Excel Object Hierarchy
    Understanding Constants
    Understanding Procedures
    Using the For Each...Next Structure
    Recording a Macro
    Understanding the Development Environment
    Using Debugging Tools
    Understanding Error Handling
    Running a Macro
    Understanding Expressions and Statements
    Working with Variable Scope
    Using Message Boxes

  • 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 ...
  • Getting Started with Coding 
    Programmatically Formatting Text 
    Adding Methods to a Class 
    Exploring the ActionScript Class Library 
    Copy and Paste Tweens 
    ActionScript Event Types 
    Loops and Conditional Logic 
    Types of Loops 
    Determine your Current Age 
    XML with EX 
    Use Cos and Sin to maneuver the Space Ship and Create Random Asteroids 
    Creating a Custom Class 
    Introducing Symbols 
    Using Methods within a MovieClip 
    Getting a Date with ActionScript 
    Using Functions and Methods 
    Demonstration -: Using EX Operators 

  • 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 ...
  • Date Functions
    Sending An Email Using MailApp
    A Data Entry Form
    Methods Of Folder And File Objects
    Text Functions
    Range Objects Are Complex
    File And Folder Permissions
    Encapsulating A Complex Calculation
    Using A Function Callback
    Displaying Spreadsheet Values In A Web App
    Using JavaScript Library Methods
    My SQL Preliminaries
    The Spreadsheet Object
    Built-in Versus User-Defined Functions
    User-Defined Functions Versus JavaScript Functions
    List Google Drive File And Folder Names
    Menus And Dialogues
    JDBC Overview
    Numeric Calculations
    Creating A Table
    Writing Database Records To A Google Spreadsheet

  • 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 ...
  • Benefits of Cascading Style Sheets
    Phrase Elements
    XHTML vs. HTML
    HTML Elements
    The Inherit Value
    Empty vs. Container Tags
    External Style Sheets
    Points (pt)
    Ordered Lists
    Adding a Caption
    Default Pages
    Merging Cells HTML Forms
    Descendant Selectors
    CSS Rules
    Whitespace
    Type Selectors
    Pixels (px)
    Get vs. Post
    Picas (pc)
    Selectors
    Submit and Reset Buttons

  • 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 ...
  • autofocus
    Overview of HTML5 Web Storage
    The fill() Method
    Rectangles
    date/time input types
    New HTML5 Structural Tags
    Graceful Degradation
    Indexed Database API
    Display of HTML5 Structural Elements
    Additional Changes
    placeholder
    HTML5 Web Storage
    HTML5 Audio and Video
    Creating and Converting Video Files
    Multiple Sub-Paths
    Modernizr
    required

  • See Training Course Details...


JavaScript

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

    No prior programming knowledge is assumed.-

  • Some of the training topics covered include ...
  • Methods
    Returning Values from Functions
    for in Loop Syntax
    Validating Checkboxes
    Focus, Blur, and Change Events
    Passing Values to Functions
    JavaScript Syntax
    Dot Notation
    Conditionals
    Validating Radio Buttons
    Image Rollover Function
    Strings
    Associative Arrays
    The HTML DOM
    Built-in Functions
    Validating a Registration Form
    Storing User-Entered Data
    Basic Rules

  • 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 ...
  • Convenience Methods
    Use Stylesheets for Changing CSS on Many Elements
    Append New Content outside of a Loop
    Operations on Numbers and Strings
    Inside the Event Handling Function
    Conditional Variable Assignment with the Ternary Operator
    Don't Act on Absent Elements
    Detach Elements to Work with Them
    The for Loop
    Getting and Setting Information about Elements
    Namespacing Events
    Use $.data Instead of $.fn.data
    GET vs. Post
    Objects
    Getting RequireJS
    Conditional Code
    Utility Methods
    Code Organization-

  • 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 ...
  • Progressive Enhancement
    HTML5 and CSS3 Getting Started with jQuery
    Hosting vs. CDN
    Dialogs Widgets and UI
    Collapsible Blocks Events
    Using Others' Plugins
    plugin Architecture
    Themes and Swatches
    Creating Your Own Plugin
    What Is jQuery Mobile?
    Buttons and Linking Pages
    Levels of Support
    Data-role
    Accessibility Support
    Orientation (Portrait/Landscape)
    Video The Theme Framework
    Virtual Integration with the Phone
    Lists and Buttons

  • See Training Course Details...


Microsoft Access 2007

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

  • Some of the training topics covered include ...
  • Creating parameter queries
    Database normalization
    Linking Access objects
    Customized headers and footers
    Database concepts
    Adding calculated values
    Modifying PivotTables
    Planning and designing databases
    Creating forms
    Subdatasheets Complex queries
    PivotTable forms Getting started
    Working with input masks
    Creating crosstab queries
    Adding unbound controls
    Labels Charts
    Getting started
    Implementing referential integrity Related tables
    Printing
    Sorting and filtering records Working with reports
    Finding and editing records
    Finding and editing records

  • 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 ...
  • Exporting objects
    Adding combo boxes
    Changing the design of a table
    Creating macros to provide user interaction
    Creating and using queries
     Charts in reports PivotTables and PivotCharts
    PivotTables
    Creating macros for data transfer
    Importing objects
    Creating macros that require user input
    Creating forms
    Working with input masks
    Interacting with XML documents
    Adding calculated values
    Performing operations in queries Using forms
    Adding graphics
    Database concepts
    Exploring the Access environment
    Using action queries Macros
    Adding unbound controls
    Setting validation rules Basic queries

  • 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 ...
  • Planning and designing databases
    Referential integrity Related tables
    Setting field properties
    Adding calculated values
    Creating, running, and modifying macros
    Subdatasheets Complex queries
    Using Design view
    Linking Access objects
    Attaching macros to the events of database objects Advanced macros
    Changing the design of a table
    Summarizing and grouping values Advanced form design
    Advanced form types Reports and printing
    Label printing Charts
    Joining tables in queries
    Modifying and printing reports Relational databases
    Performing operations in queries Using forms
    Using hyperlink fields Database management
    Setting options and properties  
    Creating forms
    Exploring tables
    Creating macros that require user input

  • 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 ...
  • Action Queries
    Setting Table Relationships
    Multi Table Queries
    Designing a Lookup Database
    Formatting Tables
    Adding Records to a Table
    Understanding VBA
    DIY Forms
    Parameter Queries
    Macro Techniques
    Creating and Using Forms
    Creating a Relational Database
    Creating and Using Macros
    Creating Queries
    Navigation Pane Protection
    Database Wellness
    Calculations in Queries
    Data Validation
    Creating a Lookup Database
    Modifying Forms
    Using a Navigation Form

  • 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 ...
  • Using the Object Browser
    Handling Errors
    Locking Records for Updating
    Calling Procedures
    Specifying a Recordset Cursor Location - Optional
    Creating a Sub Procedure
    Understanding Data Types
    Debugging Code
    Understanding Modules
    Working with Methods
    Why Program in Access?
    Working with Inline Error Handling
    Declaring Variables
    Understanding the Development Environment
    Using Break Mode during Run Mode
    Using the Do...Loop Structure
    Writing an Error-Handling Routine
    Trapping Errors with the On Error Statement
    Determining the Value of Expressions
    Working with Boolean Expressions
    Working with Events

  • 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 BI Desktop
    Loading into Excel
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Course topics include- INTRODUCTION TO POWER QUERY
    Understand Power Query formulas.
    Transforming Data
    Introduction to Power BI Desktop
    Understanding the Issues
    Grouping Options
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Combining Worksheets
    Appending Operations
    Loading into Power Pivot
    Importing Data
    Working with Folders and Files
    Using Ranges in Excel
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Using PivotTables CONNECTING TO DATABASES
    Understand working with relational data.
    Power Query Interface

  • 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 ...
  • Date Functions
    Conversion Functions
    PowerPivot Data Model
    Statistical Functions
    Explaining Syntax
    Handling Errors Using DAX Functions
    Single Table Evaluation Context
    Working with Calendars
    Exploring Data Types
    Introduction to DAX
    The CALCULATE Function
    Relational Functions Understanding Evaluation Contexts
    Aggregation Functions
    Introduction to DAX
    Many-to-Many Relationships
    Understanding Values
    Multiple Table Evaluation Context Working with Dates
    Mathematical Functions
    Text Functions
    Logical Functions

  • 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 ...
  • Importing data into Power BI
    Importing different data sources into Power BI
    Using databases as a data source for Power BI
    The developer API
    Create relationships between data tables.
    Create a Power BI dashboard
    Use Power BI direct connectivity to access data in Azure SQL data warehouse
    Using the Power BI mobile app
    Topics covered include- Introducing Power BI
    Connecting to Power BI data
    Shape data using formatting and transformations.
    Creating Power BI reports
    Power BI desktop queries
    Custom visuals Power BI mobile app
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    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
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    The Power BI Interface
    Using Excel as a data source for Power BI
    Direct connectivity from Power BI desktop

  • 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 ...
  • Applying Filters
    Hiding Columns, Change Data Type, Sorting, and Filtering
    Drill Through
    Importing Large Datasets
    Adding Slicers to Reports
    Perform data cleaning.
    Introduction to the PowerPivot Interface
    Using Cards
    Utilizing Matrix
    Theming Reports
    Understanding DAX
    Creating PivotTables
    Navigate the Power BI interface.
    PowerPivot
    Introduction to Power BI
    Exploring the Power View Interface
    Examining Tiles

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Creating base calendars
    Working in Network Diagram view
    Creating a toolbar and a menu
    Working with hyperlinks Exchanging project data
    Modifying a task list
    Working with project files
    Rescheduling tasks Formatting and reporting
    Copying data
    Getting started
    Customizing reports
    Updating the progress of tasks
    Working with resources and calendars
    Setting up task links
    Analyzing the plan
    Creating a task list
    Using drawing tools
    Working with views
    Observing project progress Analyzing and adjusting the plan
    Working with groups
    Exploring the Project window
    Working with filters

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Filters Groups Sorting tasks and resources Finalizing the task plan
    Handling resource conflicts Using templates and importing data
    Analyzing the plan Delays and conflicts
    Exporting to Office applications
    Collaboration
    Gantt chart formatting
    Creating a task list
     Macros
    Standard reports Visual reports  
    Task options Resource management
    The base calendar
    Working with tables Filters, groups, and sorting
    Monitoring progress Analyzing and adjusting the plan
    Hyperlinks
    The Help window Tasks
    Task relationships
    Consolidating and sharing projects
    Managing a project
    Project management concepts
    Modifying a task list Task scheduling
    Working with views

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Analyzing the plan
    Using templates and importing data
    The Project window
    Creating projects from other programs Managing a project
    Delays and conflicts
    Exporting to Office applications
    Hyperlinks
    Task links
    The base calendar
    Filters
    Getting started
    Working with templates
    Custom fields Managing multiple projects
    Modifying a task list
    Standard reports
    Visual reports Customizing Project
    Finalizing schedules
    Project files Tasks
    Working with tables Filters, groups, and sorting
    Task relationships

  • 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 ...
  • Reviewing Our Project
    Printing From a Combined Project
    Understanding Graphical Indicator
    Deleting an Unwanted Filter
    Making Reports Global
    Creating the Downsized Master File
    Creating a Custom Group for the
    Automatically Updating Tasks
    Combining Projects
    Creating Split Views
    Printing Footers
    Copying to Microsoft Excel
    Printing Sheet Views
    Assigning Resources From the Pool
    Assigning Material Costs
    Assigning Resources in Task
    Opening Shared Resource Projects
    Understanding the QAT
    Adding Additional Resources

  • 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 ...
  • Project Operations
    Dependencies
    The Case Study Resources Printing
    Modifying the Standard Calendar
    Creating a New Project File
    Viewing the Critical Path
    Critical Path and Project Slack
    Making Multiple Assignments
    Entering Lag Time
    Accessing the Help Window
    Auto Scheduling Tasks
    Problem Assignments
    Simple Resource Assignments
    Entering File Properties Creating Tasks
    Information
    Understanding Task Durations
    Creating Summary Tasks
    Examining Task Slack
    Specifying Resource Usage

  • 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 ...
  • Assigning Variable Usage Material
    Changing Work Effort
    Creating a Deadline
    Adding More Material Assignments
    Creating Split Views
    Viewing Project Costs Constraints and Deadlines
    Moving a Project’s Start Date Project Tracking
    Working With the Standard Views
    Understanding the Timescale
    Switching Work Assignments
    Tracking Actuals On A Gantt Chart
    Highlighting a Range of Tasks
    Highlighting Date Ranges
    Using Another Cost Table
    Getting the Right Report Fit
    Modifying Specific Tiers
    Using AutoFilters Formatting Projects
    Contouring Materials Usage
    Understanding the Data Tools
    Adding Fields Using Insert Column
    Formatting Selected Bars

  • 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 ...
  • Assigning Resources From the Pool
    Understanding Graphical Indicator
    Running a Localised Macro
    Working With a Synced Task List Microsoft Project VBA
    Setting a Combined Project Start
    Removing Items From the Global
    Inserting Subprojects
    Assembling a Resource Master
    Choosing Fields to Display in a Visual
    Understanding WBS Codes
    Linking a New Project File to the Pool
    Working With Shared Resources
    Enhancing Report Appearance
    Testing a Formula
    Using the Personal Template Folder
    Inserting Task Links
    Renumbering WBS Codes
    Working With a Contact Resource
    Adding a Contact as a Resource
    Creating Custom Fields

  • 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) 
    SharePoint 12 and AS 
    Example cube as seen using Excel pivot table 
    Modeling source schemas -stars and snowflakes 
    What Is Microsoft BI? 
    Creating cubes - using the UDM and the Cube Build Wizard 
    Demonstration of SQL Reporting Services with cube as data source 
    Adding named sets 
    Introduction to Data Mining
    Processing mining models 
    KPIs 
    Creating Data Sources and Data Source Views 
    MS BI is comprehensive - more than Analysis Services on SQL Server 
    Adding calculated members 
    New MDX functions 
    SQL RS & Report Builder 
    Excel Services 12 and AS (Web Services)

  • 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 ...
  • Importing and Exporting Data 
    The Toolbox 
    Working with Packages 
    The SSIS object model 
    Examining Database Maintenance Plan Packages 
    Revisiting data sources and destinations 
    The FTP Task 
    Introduction to Data Flow
    The Execute Package Task 
    Built-in log providers 
    Property expressions 
    Configurations and deployment 
    Using variables in data flow 
    The deployment utility 
    Script in Data flow: The Script Component 
    Using variables to pass information between packages 
    Extending SSIS through Custom Code
    The Data Mining Model Training Destination 
    Precedence Constraints 
    Data Destinations 
    Data Flow: Error data flow 

  • 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 ...
  • Implement XMLA Scripts in SSMS
    Implement SSAS Security
    View Aggregation Designs
    OLAP Modeling
    What Is Microsoft Business Intelligence?
    Deploy and View a Sample Cube
    Explore how to add MDX Script Commands
    Design Reports using Reporting Services
    Introduction to MDX Queries
    Understand Basic OLAP Modeling (star schema)
    Customize Cube and Dimension Processing
    Review MDX Functions New to SSAS 2008
    Understand Data Mining Concepts
    Introduction to Data Mining
    Understand Writeback in Dimensions
    Create Data Source Views
    Learn how to Create Key Performance Indicators (KPIs)
    Intermediate SSAS
    Implement Proactive Caching

  • 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 ...
  • Understanding Integration Services 
    Understanding Variables 
    Working with Workflow Tasks 
    Control Flow
    Exploring and Executing an Integration Services Package in BIDS 
    Installing a Package 
    Data Flow Best Practices 
    Advanced Data Flow
    Overview of Package Management 
    Using Variables and Configurations between Packages 
    Create a Package Deployment Utility 
    Checkpoints 
    Using Variables in Data Flow 
    Handling Slowly Changing Dimensions 
    Best Practices
    Extending Integration Services Capabilities through Code 
    Deployment and Management Best Practices 
    Packaging Logging 

  • 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 ...
  • Examining Deployment Options
    Browsing the Model
    Creating a Tabular Project
    Handling Hierarchies.
    Deploying
    Understanding the Tabular Model
    Exploring Security
    Utilizing Attributes
    Version Changes of SSAS from 2008-2014
    Utilizing Translations
    Deploy a multidimensional model.
    Calculated Members.
    Deploying
    Common Analysis Services Solutions
    Configuring Cube Options
    Creating a Cube
    Querying the Solution and Understanding DAX
    Choosing the Right Model
    Utilizing Data Sources and Data Source Views

  • 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 ...
  • Designing to Troubleshoot: Using Precedence Constraints
    Overview of Containers
    Understanding Variables
    Utilizing the Import/Export Wizard
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Working in the Explore Window
    Define and Use Variables and Parameters
    Utilizing SQL Server Integration Services Data Typing
    Understanding Deployment Strategies 
    Handling Errors Common SQL Server Integration Services Design Patterns
    Looping and Sequence Tasks
    Understanding Parameters SQL Server Integration Services Tools
    Creating SQL Server Integration Services Packages
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Data Loading with the Analysis Services Tasks
    Coding the Script Task
    Creating Dynamic Packages
    Utilizing Data Preparation Tasks
    Utilizing Sequences in a Container
    Utilizing Container Loops Performing Joins

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

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

  • Some of the training topics covered include ...
  • Examining Security
    Exploring Gauges
    Utilizing Dynamic Headers and Footers
    Understanding Visualizations
    Understanding Report Parts
    Mastering Data Region(s)
    Working with Expressions
    Formatting Reports
    Using Tables
    Utilizing Lists
    SQL Server 2016 Report Builder Advanced Reporting
    Examining Maps
    SQL Server 2016 Report Builder Graphics
    Introduction to SQL Server 2016 Report Builder
    Utilizing Data Sources
    Examining Parameters
    Utilizing Charts
    Visualizing Your Company Report Templates
    Exploring Matrix

  • 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 ...
  • Microsoft Neural Network
    Nested Tables
    Apply Filters to Model Testing Data
    Create a DMX Query in SQL Server Management Studio
    Discretization Methods
    Microsoft Sequence Clustering
    Create a Cross-Validation Report
    Algorithms
    Choose and Map Input Data for a Prediction Query
    Deploy a Data Mining Solution to Previous Versions of SQL Server
    Process a Mining Model
    Specify a Column to Use as Regressor in a Model
    View or Change Modeling Flags
    Browse a Model Using the Microsoft Tree Viewer
    Make a Copy of a Mining Model
    SystemGetCrossValidationResults
    Microsoft Naive Bayes
    Browse a Model Using the Microsoft Association Rules Viewer
    Drillthrough on Mining Structures Create Mining Models
    Create a Content Query on a Mining Model

  • 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 ...
  • Replace a Table or a Named Query in a Data Source View
    Define a Fact Relationship and Fact Relationship Properties
    KPIs Actions
    Create Named Sets
    Error Configuration Roles and Permissions
    Set Data Source Properties
    Define Semiadditive Behavior
    Processing Databases, Dimensions and Partitions
    Test an Action
    Add or Remove Tables or Views in a Data Source View
    Define a Data Source View
    Configure Measure Group Properties
    Work with Diagrams in Data Source View Designer
    Ragged Hierarchies
    Processing Options and Settings
    Add a Standard Action
    Edit or Delete Partitions Merge Partitions
    Set Impersonation Options for a Data Source Connection
    Overview of SSAS Multidimensional Modelling
    Authorizing access to objects and operations
    Define a Regular Relationship and Regular Relationship Properties

  • 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 ...
  • Test a model in DirectQuery mode
    Data sources supported in tabular 1200 models
    Manage Roles by using SSMS
    Sort Data in a Table
    Filter Data in a Table Relationships
    Import from Power View
    Connect to a tabular model database
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Tabular model designer
    Create and Manage Perspectives Translations Roles
    Analyze in Excel
    Bi-directional cross filters  Calculations
    Change table, column
    Enable DirectQuery mode in SSMS
    Version comparison
    Import from Analysis Services
    Set the Data Type of a Column
    Create and Manage Hierarchies Partitions
    Data sources supported in SSAS tabular 2017

  • 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 ...
  • Add a drillthrough to a custom URL
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Creating a report with the report wizard
    Formatting data
    Extend reporting services functionality with external assemblies.
    Report caching, snapshots, and comments
    Publish a report to reporting services Working with Reporting Services Data
    Drillthrough in mobile reports
    Drilldown and drill through Sharing Reporting Services Reports
    Configuring data access with report designer
    Work with expressions and embedded code.
    Report sub-reports
    Reporting services tools Reporting Services Data Sources
    Implementing report filters and parameters Visualizsng Data with Report Services
    Using Datasets Creating Paginated Reports
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Reporting services components
    Sorting and grouping
    Databars, sparklines, indicators, gauges, and maps
    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: 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 ...
  • Saving and Reusing Filter Settings
    Pdf and Print Control
    Viewing the Request Results
    OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
    Understanding the Dashboard Structure
    Pivot Table Concepts
    Narrative View
    Defining the Pivot View
    Managing Presentation Catalog Objects Deploying Requests to Dashboards
    Ticker View
    Column Selector View
    Customizing the Table View
    Set Operations
    About Database Technologies
    Basic Navigation Using A Dashboard
    Downloading the Answers Report Formatting
    Report Attributes
    Legend View
    About Views
    Filters View

  • 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 ...
  • The DBMS_LOB Package
    Creating a Stored Function 
    The PL/SQL Execution Environment 
    Scope and Name Resolution 
    Stored Subprograms 
    Package Variables 
    Overloading Package Functions and Procedures 
    Calling a Stored Function 
    The UTL_FILE Package 
    Maintaining PL/SQL Code 
    Nesting Blocks 
    User-Defined Exceptions 
    Packages 
    Working with LOBs 
    Dates and Timestamps 
    Types of Triggers 
    Cursor Parameters 
    Declaring Variables 
    PL/SQL Variables and Datatypes 
    Using VARRAYs 

  • 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 ...
  • Logical and Physical Storage Structures 
    Creating Views 
    Combining SELECT Statements 
    Connecting to a SQL Database 
    Subqueries 
    The EXISTS Operator 
    Buffer Manipulation Commands 
    Data Inconsistencies 
    Interactive SQL*Plus Scripts 
    The SQL Buffer 
    Selecting from Multiple Tables 
    IN and BETWEEN 
    Synonyms
    Outer Joins 
    Self Joins 
    Datatypes 
    Data Definition and Control Statements 
    Conversion Functions 

  • 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 ...
  • Alternatives ( | ) 
    Default Values 
    require_once 
    Regular Expression Syntax 
    Common Characters ( . \d \D \w \W \s \S ) 
    Magic Quotes
    Initializing Arrays 
    PHP Operators 
    Sending Email with PHP 
    Grouping ( [] ) 
    mysqli Prepared Statements 
    Superglobals 
    Type Strength 
    Passing Variables on the URL 
    File Locking 
    Arrays 
    Conditional Processing 
    Reading from Two-dimensional Arrays 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Adding shapes
    Printing presentations Customizing PowerPoint
    Rearranging and deleting slides
    Templates and themes
    Running presentations
    Saving presentations
    Embedding and linking content
    Formatting paragraphs Using drawing objects
    Getting help New presentations
    Application settings
    Formatting text
    The PowerPoint window
    Speaker notes
    Customizing SmartArt graphics
    Modifying text
    Finishing a presentation
    Creating presentations
    Using text in objects Working with graphics
    Custom slide shows

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Customizing tables
    Creating a basic presentation
    Modifying graphics
    Reviewing and finishing
    Transitions and timings
    Applying content from a Word outline
    Distributing presentations
    Formatting shapes
    Editing efficiently Working with shapes
    Printing presentations
    Getting started
    Pictures Tables and charts
    Applying content to shapes Graphics
    Slide masters and transitions
    Custom slide shows Graphics and media
    Preparing a presentation
    Creating shapes
    Customizing PowerPoint
    Working with slides Editing slide content

  • 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 ...
  • Rotating and Flipping Images
    Setting Up the Show
    Understanding Themes
    Media and Action Buttons
    Using a Customised Theme
    Applying Picture Effects
    Editing Audio Clips
    Applying a Table Style
    Opening Shared Presentations
    Modifying Bullets
    Working With Pie Charts
    Removing an Image Background
    Changing the Chart Type
    Applying Artistic Effects
    Inserting Slide Numbers
    Resizing and Positioning a Table
    Saving to a Storage Device
    Setting Up a Speaker-Led Show
    Recolouring an Image
    Understanding Templates
    Understanding Media in PowerPoint

  • 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 ...
  • The Four Pillars of Great Design
    Presentation Methods and Hardware
    Applying Font Formatting
    Understanding Dialog Boxes
    Creating a Hyperlink to Another
    Resizing Shapes
    Understanding Printing
    Understanding How Help Works
    Adding Shapes Below
    Positioning Shapes
    Printing Your Presentation
    Creating a Presentation
    Creating Presentations in PowerPoint
    Adding Commands to the QAT
    Inserting Text Into SmartArt
    Understanding Slide Layouts
    Using Slide Sorter View
    Creating an Internal Hyperlink

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Finalizing and publishing a site
    Modifying form properties
    Basic publications
    Multi-page publications
    Table structure
    Styles and font schemes
    Mail merge and catalog merge
    Bookmarks
    Building blocks
    Publication output
    Long publications
    Catalog merge
    The Graphics Manager pane
    Layout and design techniques
    Master pages
    Custom colors
    Paragraph formatting

  • 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 ...
  • Previewing And Modifying A Catalogue Merge
    Aligning Text
    Formatting Text
    Inserting Pictures
    Changing Fill
    Creating A Fill Background
    Creating Labels
    Safely Closing A Publication Working With a Publication
    Using The Scratch Area
    Inserting Advertisements Working With Shapes
    Using Multiple Master Pages Mail Merge
    Paragraph Spacing
    Inserting Text Fields
    Deleting Pages Working With Text
    Creating Text Styles
    Changing The File Type
    Tips For Planning A Publication
    Applying Colour To Text
    Creating Numbered Lists
    Inserting Text
    Accessing The Help Window

  • 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 ...
  • Creating Grid Guides
    Using the Ribbon
    Entering Text in a Table
    Filtering Data
    Understanding Publisher 2016
    Resizing Shapes
    Getting Started With Publisher
    Applying Table Styles
    The Save As Place
    Your First Publication
    Creating a Mail Merge Publication
    Linking Text Boxes
    Inserting Text
    Importing Text
    Previewing a Publication
    Moving Pages
    Text Techniques
    The Save As Dialog Box
    Understanding the Start Screen
    The Open Place

  • 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 ...
  • Checking Multiple Conditions 
    Conditional Processing with CASE
    Sorting By Column Position
    Outer Joins
    Aliases
    Views  
    Using CASE  Inserting, Updating and Deleting Records
    Common Math Functions    
    Foreign Keys   
    Primary Keys
    Renaming Tables    
    Multi-table Joins  
    Comments
    The WHERE Clause and Operator Words    
    Simple SELECT Statements
    Aggregate Functions
    Case Sensitivity
    Benefits of Views 
    Dropping Stored Procedures

  • 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 ...
  • Usability Features
    Execution Properties
    History Properties
    Building a Table Report
    Server Management Reports
    Reporting Services 2005 Deployment Options
    A Closer Look at Preview
    Chart Options
    Perspectives
    Data Output
    The Management Studio Object Explorer
    Creating a Report Model File
    Understanding Report Builder
    Reporting Services 2005 Web Components
    Adding Groups and Users
    Building a Matrix (Cross-tab) Report
    Report Item Style Properties
    Installing Auditing and Management Reports
    The Reporting Services 2005 Layout View
    Current Classroom Folder Structure

  • 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 ...
  • Ad-Hoc Reporting with Report Builder 2.0
    Learn about datasets and data regions 
    Investigate Reporting Services charts 
    Investigate how Reporting Services secures access to reports and other Reporting Services resources 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Creating Tabular and List Reports
    Explore how to create expressions in your reports using 
    Learn how to create data-driven report subscriptions 
    Explore creating linked reports 
    Learn how to work with rich text to produce mail merge style reports 
    Security
    Learn how to call the Report Server Web Service 
    Find out how to use Report Manager to manage user accounts and roles 
    Master the Reporting Services Grouping pane 
    Explore the maintenance of report history 

  • 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 ...
  • Secure Packages
    Examine Data Warehousing Concepts
    Cleanse Data Using DQS Managing SSIS Package Execution
    Create an SSIS Project
    Execute SSIS Packages on the Server
    Secure Databases Working with MDS and Windows Azure
    Examine MSI Packages
    Debug Package Execution Components
    Debugging and Troubleshooting Packages
    Add Data Flow Components to a Data Flow Task
    Work with Windows Azure
    Create Dimensions
    Configure the Package Execution Strategy
    Deploy a Control Flow
    Overview of Data Warehouses
    Work with MDS Databases
    Create Package Templates Implementing Data Flow
    Add Packages to an SSIS Project Managing Control Flow
    Overview of Data Warehouse Components
    Configure MDS

  • 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 ...
  • Creating a Columnar Report
    Setting Report Project Properties
    Indicators
    Variable Collection
    Data Set Parameters
    Report Project Files and Folders
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
    Create a Tabular Report  Using the Tablix Report Type
    Introduction to SQL Server Reporting Services
    Using Unbound Parameters Understanding Report And Data Set Parameters
    Shared Data Sources
    Native Mode Architecture
    Interactive Sorting
    Formatting Text Boxes from the Toolbars
    Sparkline
    Designing the Page Layout
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Create a Map Report
    A Tour of the Report Builder Interface
    Report Project Types  Working with Report Server Projects

  • 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 ...
  • Assign Aliases Using Queries
    Work with Binary Data Types
    Manage Query Plans
    Merge Data Working with SQL Server Built-in Functions
    Work with Dynamic SQL Working with Subqueries and Table Expressions
    Work with Date and Time Data Types
    Delete Data
    Work with Set Operators
    Manage Triggers
    Work with PIVOT and UNPIVOT
    Work with Predicates
    Work with Grouping Sets Managing Error Handling and Transactions
    Update Data
    Modifying Data
    Create Queries Using Join Algorithms
    Work with System Catalog Views Optimizing Query Performance
    Control Program Flow
    Configure Indexes
    Implement Error Handling
    Work with String and Numeric Data Types
    Work with Subqueries

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Special drawing operations
    Integration with PowerPoint
    Working with links
    Brainstorming diagrams
    Rack diagrams
    Formatting drawings
    Introduction to advanced features
    Compound lines
    Project management diagrams
    Software and database diagrams
    Drawing tools
    Advanced Layout and connection techniques
    Web site maps
    Shape behavior and events
    Block, tree, and onion diagrams
    Custom stencils
    Business diagrams and Web site mapping

  • 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
    Brainstorming diagrams Customization and reporting
    Planning a diagram
    Special drawing operations
    Custom themes
    Web site maps Integrating Visio with other programs
    Project management diagrams
    Working with text
    Network diagrams
    Shape behaviors
    Formatting shapes and lines Working with pages
    Rack diagrams
    Layout and connection techniques
    Custom templates Custom shapes and stencils
    Working with background pages
    The Visio 2010 interface
    Formatting text
    Compound lines
    Drawing scales
    Basic shapes and lines
    Reporting

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Integration with Microsoft Outlook
    Software and database diagrams
    Block, tree, and onion diagrams
    Working with Web-enabling features
    Displaying shape dimensions
    Layout and connection techniques
    Special drawing operations
    Integrating Visio with other programs
    Integration with Microsoft Word
    Formatting drawings
    Basic diagrams
    Custom shapes and stencils
    Organization charts
    Business diagrams and Web site mapping
    Getting started
    Database model diagrams

  • 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 ...
  • Modifying Theme Colours
    Understanding Content Controls
    Creating A Recipient List
    Importing Text
    Creating A Quick Style
    Downloading An Online Template
    Understanding Tables Of Contents
    Merging Table Cells
    Understanding Recipient Lists
    Saving A Custom Theme
    Applying A Theme
    Inserting A Blank Cover Page
    Setting Macro Security
    Assigning A Keyboard Shortcut To A Macro
    Using A Sample Template
    Understanding Templates
    Marking Index Entries

  • 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 ...
  • Scrolling Through A Document
    The Word Screen
    Inserting A Blank Footer
    Using The Ribbon
    Resizing A Picture
    Changing Fonts
    Counting Words Working With Text
    Starting Word
    Mail Merging
    Inserting A Blank Header
    Page Layout
    Showing Paragraph Marks
    Printing A Document Working With A Document
    Saving An Existing Document
    Techniques For Selecting Text
    Understanding Printing
    Adding Data To A Table
    Using Ribbon KeyTips
    Browsing For Help

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Working with outlines Proofing, printing, and exporting
    Document navigation Editing text
    Printing and exporting documents
    Graphics
    New documents
    Creating tables
    Examining formatting
    Find and replace Formatting text
    Page setup
    Tab settings
    Table design options
    AutoCorrect
    Character formatting
    Changing the table structure
    The Undo and Redo commands
    Getting started
    Table data Page layout
    Spelling and grammar
    Working with styles
    Paragraph spacing and indents Tables
    Headers and footers

  • 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 ...
  • Finding Words
    Autofitting Columns
    Page Zooming
    Selecting in Tables Using the Ribbon
    Using the Clipboard Task Pane
    Applying Picture Styles to Pictures
    Working With Pages
    Starting the Mail Merge Wizard
    Changing Document Views
    Indenting Paragraphs
    Counting Words
    Computer
    Using the Paragraph Dialog Box
    Deleting Columns and Rows
    Perfect Page Layouts
    Understanding Read Mode
    The Paragraph Dialog Box Indents
    Changing Page Orientation

  • 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 ...
  • Deleting Shapes
    Aligning Tables
    Inserting a Next Page Section Break
    Inserting Date Information
    Removing Returns
    Inserting an Address Block
    Understanding Headers and Footers
    Inserting the Greeting Line
    Changing Text Direction
    Aligning Data in Cells
    Resetting a Theme
    Footers
    Footers
    Understanding Word Options
    Controlling Widows and Orphans
    Attaching a Template to a Document
    Product Code: INF1611
    Creating a Template From a

  • 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
    Saving Building Blocks
    Comparing Documents
    Protecting and Saving the Form
    Creating a Custom Dictionary
    Changing a SmartArt Layout
    Changing the Default Custom
    Applying a Number Format
    Showing and Hiding Field Codes
    Building a Table of Contents
    Copying a Macro
    Adding Words to the Custom
    Printing a Master Document
    Opening and Editing a PDF in Word
    Table of Contents
    Using an Electronic Form
    Deleting Words From the Custom
    Stopping Document Protection

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730