Enable Technology

SHROPSHIRE TRAINING COURSES 

TRAINING COURSES SHROPSHIRE




Adobe Dreamweaver CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Managing Your Adobe Account
    Opening Up Shadows
    Formatting Hyperlinks With Pseudo-Classes
    Floating and Docking Panels
    Understanding Live View
    Understanding the Raw Tool Bar
    Understanding Views
    Sharpening Images With Smart Sharpen
    The Creative Cloud Library and Mobile Apps
    Understanding the Properties Panel
    Changing Perspective With Perspective Warp
    Using CSS Inspect to Check Page Layout
    Understanding Camera Raw
    Creating an Adjustment Layer
    Creating a Custom Workspace
    Understanding the Dreamweaver CC Workspace
    Adding a Home Page
    Embedding Metadata in Your Image Files
    Using Curves to Improve Contrast

  • See Training Course Details...


Adobe Illustrator CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Working With Stroke Width
    Distorting Objects
    Creating Basic Shapes
    Exploring Colour Themes
    Understanding the Shape and Colour Tools
    Advanced Objects
    Text and Objects
    Setting Up a New Document
    Saving an Illustrator Document for the Web
    Navigating Illustrator
    Changing the Perspective of an Object
    Copying Formatting With the Eyedropper Tool
    Creating Other Shapes
    Add Fonts in Typekit
    Wrapping Text Around an Object
    The Adobe Website
    Editing Path Segments
    Distributing Objects
    Understanding Vector Graphics
    Exporting an Illustrator Document

  • See Training Course Details...


Adobe InDesign CC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Adding Colours to the Swatches Panel
    Aligning and Distributing Objects
    Fitting Graphics
    Adding Notes to a Shared File
    Selecting Colours Using the Swatches Panel
    Understanding Frames
    Exporting to PDF
    Creating a New Layer
    Setting Drop Caps
    Understanding Adding Animation
    Creating and Applying Object Styles
    Working With Files and Folders
    Arranging Objects
    Constraining Specific Objects
    Creating a Multi State Object
    Using New Document Preview
    Formatting Cells
    Running a Preflight Check
    Uploading a File to Creative Cloud
    Creating a Document Preset
    Using the Eyedropper to Copy Formatting

  • See Training Course Details...


Adobe Photoshop CC

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

  • Some of the training topics covered include ...
  • Understanding Tone and Histograms
    Selecting Colours Using the Swatches Panel
    Saving Layer Effects as a Style
    Using the Print Dialog Box to Resize Images
    Introduction to 3D
    Opening Images in Camera Raw
    Introduction to Camera Raw
    Modifying a Linked Smart Object
    Mobile Application Help and Support
    Applying Colour to 3D Text
    The Bridge Menu and Tool Bar
    Changing Layer Opacity
    Removing Blemishes
    Understanding Layer Comps
    Sharing Libraries
    Understanding Behance
    Growing a Selection
    Applying Colour With the Colour Panel

  • See Training Course Details...


ASP.NET Core MVC

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • HTTP Services Using Web API
    NuGet Package Manager
    Input Validation The Model
    Serving Static Files
    Attribute Routing ASP.NET Core Web API
    More Complex Models in MVC Programs
    Actions
    Advantages and Disadvantages of Web Forms
    Considerations in Using ASP.NET MVC
    Review of ASP.NET Web Forms
    Using ADO.NET The Controller
    The Controller in ASP.NET MVC
    View Responsibility
    HTTP Testing Tools
    Introduction to ASP.NET Core MVC
    The Model in ASP.NET MVC
    Properties of Routes
    Dynamic Output ASP.NET MVC Architecture
    ASP.NET Web API Clients ASP.NET Core and Azure
    Model-View-Controller Pattern
    Parameters in Routing

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • HyperLink and Button Controls 
    Validating User Input 
    Debugging Exceptions and Handling Errors 
    Preserving State in Web Applications 
    The XML Control 
    Filter Data in the GridView Control 
    Summarizing Results with the ValidationSummary Control 
    Creating a Consistent Web Site 
    LINQ to SQL 
    Simple Input Controls 
    Configuring Session State 
    Managing State 
    ASP.NET 2.0 Themes 
    Using Rich Server Controls 
    Executing Commands 
    Displaying XML Data Using the XmlDataSource Control 
    Setting Up an Out-of-Process State Server 
    Displaying Data with the GridView Control 
    Using Visual Studio 2008's Tools for Working with Styles 

  • See Training Course Details...


ASP.NET using VB.NET

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Creating an XML Site Map File 
    Introduction to Web Controls 
    Server Debugging 
    Debugging Stored Procedures 
    Allow Users to Select from a DropDownList in the Grid 
    Themes and Master Pages 
    ASP.NET Session State 
    Using the Complex Validators 
    Add a Hyperlink to the Grid 
    Site Navigation Controls 
    Introducing Data Source Controls 
    Controlling Focus 
    Introduction 
    Displaying Data with the GridView Control 
    LINQ 
    URL Mapping 
    Custom Data Visualizers 
    CSS 

  • See Training Course Details...


Crystal Reports 2008

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Choosing a Data Source 
    Sorting Records within a Group 
    Selecting and Sizing Objects 
    Inserting Graphics 
    Unlinked versus Linked Subreports
    Learning about Linking 
    Creating Running Totals for a List of 
    Report Alerts
    Creating and Using Formulas 
    Using the Preview Panel 
    Grouping Data in Date/Time Intervals 
    Creating Report Alerts
    Formatting Objects 
    Formatting the Subreport
    Creating Boolean (True/False) Formulas 
    Creating Custom Groups
    Understanding the Formula Evaluation 
    Performing Simple Number Calculations 
    Group Sorting with a Parameter

  • See Training Course Details...


Crystal Reports 2011

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

  • Some of the training topics covered include ...
  • Understanding How Crystal Reports 
    Creating Boolean (True/False) Formulas 
    Using the Running Totals Feature
    Using the Group Tree to Navigate the Report 
    Applying a Formatting Style to the 
    Creating a Cross-Tab Report
    Formulas
    Creating Report Alerts
    Creating Summary Reports and Charts 
    Filter Types of the Select Expert 
    Conditionally Formatting Multiple Sections
    Adding Parameter Values to Text 
    Repeating Row Heading for Multi-Page Cross-Tabs
    Exploring the Toolbars 
    Creating On-Demand Subreports
    Working with Cross-Tab Reports
    Creating Text Objects 

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Getting Help Formatting Features
    Creating a Cross-Tab Report
    Using the Section Expert to Work with Sections Using the Running Totals Feature
    Formatting the Subreport
    Using the Sort Control
    Working with the Page Commands
    Creating Running Totals for a List of Numbers
    Variable Scope
    Record Selection Formula Templates Grouping and Sorting Data
    Working with Variables
    Saving the Report
    Using the Preview Panel
    Using the Status Bar
    Using an Edit Mask to Limit String Parameters
    HTML Preview
    Create a Report Using the Standard Report Creation Wizard
    Case Sensitive vs. Case Insensitive
    Modifying Groups
    Exporting to Windows Applications
    Working with Arrays
    Creating Text Objects

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Shropshire
  • 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 Multiple Groups in a Report
    Creating Hyperlinks Creating Powerful Groups
    Conditional Running Totals Prompting with Parameters
    Creating a Cross-Tab Report
    Passing Data from the main Report into a Subreport
    Modifying Groups
    Customizing Group Sort Order
    Understanding Tables, Records, and Fields
    Database Filtering with the Select Expert
    Basing Report Formulas or Conditional Formatting on Report Alerts
    Working with Variables
    Formatting the Subreport
    Getting Help Formatting Features
    Customizing Cross-Tab Group Names Report Alerts
    Editing Charts
    Using the Formula Editor
    Formatting Sections Conditionally
    Exploring the Toolbars
    Formatting Sections
    Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
    Declaring a Variable

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Parameter Fields Overview
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Learning about Linking
    Getting Help Formatting Features
    Conditional Running Totals Prompting with Parameters
    Creating a Group
    Sorting Records within a Group
    The Summaries Dialog Box
    Pass #3
    The Fields Dialog Box
    Repeating Row Heading for Multi-Page Cross-Tabs
    Passing Data from the Main Report into a Subreport
    Using the Chart Options
    Selecting and Sizing Objects
    Using a Variable in a Formula
    Formatting the Subreport
    Formatting Part or All of an Object
    Using Parameters in Conditional Formatting
    Parameter Field Considerations
    The Template Expert
    Creating On-Demand Subreports

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Web Accessibility
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Modernizr
    The CSS3 Speech Module
    Backgrounds
    The @font-face Rule
    What Are Vendor Prefixes
    The History of CSS
    Styling Video
    Accessibility Features
    Introducing CSS3
    Media Queries
    Transitions and Transforms
    Responsive Images and the viewport Metatag
    Preprocessors
    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: Shropshire
  • 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 ...
  • Excel PowerPivot Data Mining Add-ins
    Data Modelling
    Types of Data Mining Algorithms
    Microsoft Linear Regression Algorithm
    The Mining Model Prediction Tab
    Named Calculation
    Cross Validation
    Data Mining and Results
    Multiple Nested Tables Microsoft Data Mining Algorithms
    Connection
    Introduction to SQL Server Data Tools
    Microsoft Neural Network Algorithm
    Concepts and Terminology
    Exploring Data
    Offline Mode and Immediate Mode
    Management
    Microsoft Logistic Regression Algorithm
    Data Preparation
    Data Mining Wizard

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Browser and Device Support
    JavaScript Implementation
    Foundation: A Responsive Grid Framework
    GeoLocation API
    Flexible Images and Other Media
    Google Maps
    A First Look at Foundation
    Media Queries
    Optimizing the Video Experience for Mobile
    Media Queries
    Targeting Widths and Devices with CSS3 Media Queries
    The Case for Flexible
    Gestures
    Other Devices
    Optimizing for Mobile
    Flexible Background Images
    The Viewport

  • See Training Course Details...


Excel Advanced

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

  • Some of the training topics covered include ...
  • Working With an Outline
    Setting Save Options
    Creating a Two-Variable Data Table Scenarios
    Creating Scenarios
    Accepting or Rejecting Changes
    Adding a Check Box Control
    Finding the Percentage of Total
    Saving to OneDrive
    Assigning a Keyboard Shortcut to a Macro
    Understanding Data Consolidation
    Setting Macro Security
    Creating Relative Names for Subtotals
    Changing Control Properties
    Using Compound Fields
    Importing Access Data
    Understanding Data Linking
    Counting in a PivotTable
    Creating a Drop Down List
    Sharing Workbooks via OneDrive
    Understanding Data Tables and What-If Models
    Formatting PivotTable Values

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Changing the Chart Layout
    Creating Compound Filters
    Understanding Dialog Boxes
    Using the Format Painter Cell Alignment
    Deleting Cells From a Worksheet
    Creating Formulas That Subtract
    Understanding How Help Works
    Applying and Using a Filter
    Overwriting Cell Contents
    Inserting Columns Into a Worksheet
    Increasing and Decreasing Decimals Row and Column Formatting
    Changing Fonts
    Number Formatting
    Selecting Rows
    Setting the Default Column Width
    Understanding Printing
    Calculating an Average
    Typing Dates
    Copying From One Cell to a Range
    Italicising Text
    Understanding the Excel Start Screen

  • See Training Course Details...


Excel Intermediate

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

  • Some of the training topics covered include ...
  • The DATE Function
    Deleting a Table Chart Elements
    Pasting Values From Formulas
    Custom Formatting Large Numbers
    Quick Formatting
    Strategies for Printing Worksheets
    Setting the Print Area
    The TODAY Function
    Quick Totals
    Applying Top and Bottom Borders
    Custom Formatting for Fractions
    Unhiding Rows and Columns
    Creating the Base Formula
    Creating a Custom Fill List
    The ROUND Function
    Inserting and Deleting Worksheets
    Quick Tables Worksheet Tables
    Scoping Names to a Worksheet
    Changing Individual Bar Colours
    Changing Worksheet Tab Colours
    Filling Data

  • See Training Course Details...


Excel Power Pivot

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

  • Some of the training topics covered include ...
  • Understanding Power Pivot
    Understanding Get & Transform
    Rearranging and Sorting Fields
    Viewing and Editing a Tour
    Changing a Power Pivot View
    Filtering Data
    Using Calculated Fields
    Reducing Data Rows
    Working With a Power View Object
    Power Map
    Displaying the Query Editor
    Creating a Power Map Tour
    Working With the Data Model
    Tiling Data in Power View
    Working With Scene Options
    Filtering in Power View
    Creating a Timeline
    Understanding Power Map
    Creating a Concatenated Field
    Creating a New Query From the Web

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Assigning a Macro to the Quick Access Toolbar
    Working with the Label Control
    Declaring Variables
    Using the With Statement
    Launching a Form in Code
    Displaying the Developer Tab in the Ribbon
    Creating an Event Procedure
    Closing the Visual Basic Editor
    Working with the Code Editor
    Understanding Error Handling
    Understanding PivotTables
    Setting the Tab Order
    Trapping Errors with the On Error Statement
    Understanding Controls
    Understanding Data Types
    Creating a Sub Procedure
    Understanding the Err Object
    Working with Inline Error Handling
    Understanding VBA's Error Trapping Options

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Adding Sound Effects to the SpaceShip 
    Object Oriented Programming 
    ActionScript Basics 
    Creating Visual Classes Through Inheritance 
    Using Functions and Methods 
    XML with EX 
    Use Cos and Sin to maneuver the Space Ship and Create Random Asteroids 
    Adding Symbols to the Stage at Run-Time 
    Exploring the ActionScript Class Library 
    Loading External XML Files and Filtering Books 
    Determine When Objects Overlap or Hit 
    Creating a Custom Class 
    Using the Tween Class 
    Tweening the Warp Animation
    Dispatching A Custom Event 
    Using the MouseEvent 
    Manipulating Symbols with ActionScript 
    Formatting the Player Score TextField 
    Animating with ActionScript 
    Using Functions 
    Creating a High Score List 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Numeric Calculations
    Text Functions
    Creating A Web App
    Encapsulating A Complex Calculation
    Populating A Table
    Database Metadata
    Native And Host Objects
    Writing Database Records To A Google Spreadsheet
    Sending An Email Using MailApp
    The Range offset() Method
    Calendars Web Apps With Html Service
    The Spreadsheet Object
    GmailApp
    Getting And Setting Range Properties
    List Google Drive File And Folder Names
    Layout and Panels
    Google Apps Script Examples
    Using JavaScript Library Methods
    Introducing JavaScript Functions
    SpreadsheetApp
    Form Example

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Inches (in), Centimeters (cm), and Millimeters (mm)
    CSS Comments
    HTML Elements
    Password Fields
    Selectors
    Points (pt)
    Preformatted Text
    Attributes
    How HTML Forms Work
    Breaks and Horizontal Rules
    Form Elements
    Benefits of Cascading Style Sheets
    Radio Buttons
    HTML Links
    Long Descriptions
    Adding a Caption
    Ems (em)
    Hidden Fields
    Whitespace
    Formatting Elements

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Page Structure
    Offline Application API
    placeholder
    New HTML5 Structural Tags
    Text Properties
    autofocus
    HTML5 - Background
    The Path Drawing Process
    Video Tag Attributes
    Browser Support
    Sections and Articles
    min, max, and step attributes
    Laying out a Page with HTML 4 - the "old" way
    Overview of HTML5 Web Storage
    New Input Types
    Other Storage Methods
    Sectioning

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • JavaScript Functions
    do while Loop Syntax
    Validating Radio Buttons
    Validating Text areas
    Passing Values to Functions
    String(object)
    Variables, Arrays and Operators
    Number(object)
    The this Object
    Conditionals and Loops
    Returning Values from Functions
    Strings
    Basic Rules
    for Loop Syntax
    Built-in Functions vs Methods
    Backward Compatibility
    JavaScript Basics

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Use Event Delegation
    Event Helpers
    Breaking and Continuing
    Conditional Variable Assignment with the Ternary Operator
    Key Concepts
    Don't Treat jQuery as a Black Box
    Manipulating Elements
    Dimensions
    Closures
    Using RequireJS with jQuery
    Getters and Setters
    Optimizing Your Code: The RequireJS Build Tool
    The while Loop
    $ vs $()
    Keep Things DRY
    Reserved Words
    Inside the Event Handling Function
    Getting and Setting Information about Elements
    Feature and Browser Detection
    Operations on Numbers and Strings
    Operators

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Buttons and Toolbars
    Overview
    Supported Devices/OSs/Browsers
    Basic Page Template
    Lists and Buttons
    Orientation (Portrait/Landscape)
    Dialogs Widgets and UI
    Using Others' Plugins
    Ajax-driven Page Navigation
    PhoneGap
    Sending SMS Texts
    Overriding Themes with Custom CSS Plugins
    Accessibility Support
    HTML5 and CSS3 Getting Started with jQuery
    Sending Emails
    Creating Your Own Plugin
    Collapsible Blocks Events

  • See Training Course Details...


Microsoft Access 2007

  • 2 day course
  • Location: Shropshire
  • 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 crosstab queries
    Adding combo boxes
    Creating and using queries
    Creating parameter queries
    Planning and designing databases
    Customized headers and footers
    Subdatasheets Complex queries
    Using Design view
    Working with input masks
    Joining tables in queries
    Linking Access objects
    Database concepts
    Creating the AutoKeys and AutoExec macros
    PivotTable forms Getting started
    Adding unbound controls
    Database normalization
    Labels Charts
    Charts in reports PivotTables and PivotCharts
    Summarizing and grouping values Advanced form design
    Modifying and printing reports Relational databases
    Relating tables

  • See Training Course Details...


Microsoft Access 2010

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Setting field properties
    Creating, running, and modifying macros
    Interacting with XML documents
    Exploring the Access environment
    Modifying query results and queries
    Creating and using queries
    Database normalization
    Complex queries
    Hyperlink fields Database management
    Creating forms
    Joining tables in queries
    Getting help Databases and tables
    Printing
    Database concepts
    Creating macros that require user input
    Modifying lookup fields
    PivotCharts
    Working with input masks
    Planning and designing databases
    Creating macros to provide user interaction
    Importing, exporting, and linking

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Exploring tables
    Creating crosstab queries
    Setting field properties
    Exporting objects
    Attaching SQL queries to controls Advanced queries
    Creating macros for data transfer Importing, exporting, and linking objects
    Subdatasheets Complex queries
    Advanced form types Reports and printing
    Planning and designing databases
    Sorting and filtering records Working with reports
    Creating parameter queries
    Organizing records Data Entry rules
    Working with XML documents
    Linking Access objects
    Charts in forms
    Creating lookup fields
    Referential integrity Related tables
    Creating forms
    Modifying lookup fields
    Creating AutoKeys and AutoExec macros
    Writing SQL statements

  • See Training Course Details...


Microsoft Access 2016

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • An Introduction to VBA
    Creating and Using Reports
    Querying Techniques
    Database Security
    Macro Techniques
    Understanding VBA
    Data Validation
    Relational Database Design
    Designing a Lookup Database
    Database Wellness
    Multi Table Queries
    Aggregation Queries
    Importing and Exporting Records
    Creating and Using Macros
    Working With Records
    Sorting and Filtering
    Creating Queries
    Modifying Table Structures
    Modifying Forms
    Creating a Relational Database
    DIY Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Working with Variable Scope
    Organizing Code and Procedures
    Using the CacheSize Property - Optional
    Setting Breakpoints
    Using the Select Case...End Select Structure
    Handling Errors
    Understanding Procedures
    Setting Break Expressions
    Understanding Error Handling
    Understanding Data Types
    Writing an Error-Handling Routine
    Understanding Constants
    Working with Events
    Introduction to Programming in Access
    Creating a Sub Procedure
    Using the For Each...Next Structure
    Understanding VBA's Error Trapping Options
    Understanding Classes and Objects
    Using Expressions, Variables, and Intrinsic Functions

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Transforming Data
    Appending Operations
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Working with Folders and Files
    Using Ranges in Excel
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Importing Data
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Understand the M interface.
    Using PivotTables CONNECTING TO DATABASES
    Performing Merges
    Loading Data
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Grouping Options
    Combining Worksheets
    Loading into Excel
    Understanding the Issues
    Understanding and Handling Special Situations
    Loading into Power Pivot
    Course topics include- INTRODUCTION TO POWER QUERY

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

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

  • See Training Course Details...


Microsoft Power BI

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

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Merge datasets.
    Introduction to the PowerPivot Interface
    Theming Reports
    Creating PivotTables
    Understanding Aggregations
    Hierarchies
    Configuring Drill Through
    Understanding DAX
    Working with Tables
    Utilizing DAX Functions
    PowerPivot
    Add time to a presentation.
    Navigate the Power Query interface.
    Utilize themes.
    Load data.
    Perform data cleaning.
    Power Map
    Visualizing Power View Reports
    Navigate the Power Map interface.

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Working with tables Filtering, grouping, and sorting
    Working with groups
    Managing a project
    Tracking project work
    Resolving resource conflicts
    Creating macros
    Analyzing the plan
    Project management concepts
    Creating custom views
    Copying data
    Customizing reports
    Modifying a task list
    Consolidating and sharing projects
    Updating the progress of tasks
    Working with resource costs Working with views and tables
    Creating a toolbar and a menu
    Setting up task links
    Importing data
    Creating base calendars
    Using drawing tools
    Rescheduling tasks Formatting and reporting

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Finalizing schedules
    Filters Groups Sorting tasks and resources Finalizing the task plan
    The base calendar
    Project costs Views and tables
    Consolidating and sharing projects
    Team Planner view Working with reports
    Custom fields Managing multiple projects
    Handling resource conflicts Using templates and importing data
    Hyperlinks
    Creating a task list
    Working with tables Filters, groups, and sorting
    Task relationships
    Sharing resources among projects Exchanging project information
    Analyzing the plan Delays and conflicts
    Project files
    Custom views
    Task links
    Gantt chart formatting
    Exporting to Office applications
    Managing a project

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Project management concepts
    Project costs
    Creating projects from other programs Managing a project
    Collaboration
    Custom fields Managing multiple projects
    Updating an active project
    Working with views
    Consolidating and sharing projects
    Getting started
    Exporting to Office applications
    The Project window
    Delays and conflicts
    Working with templates
    Handling resource conflicts
    Monitoring progress
    Custom views
    Sharing resources among projects Exchanging project information
    Task options Resource management
    Views and tables

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Renumbering WBS Codes
    Formatting for Non-Working Time
    Working With Fixed Duration Tasks
    Displaying Progress Lines
    Assigning Cost Resources
    Previewing Before You Print
    Using Google to Get Help
    Working With Project Files
    Setting Up Project Information
    Filtering Report Data
    Working in a Sheet View
    Linking a New Project File to the Pool
    Working With Views
    Highlighting a Range of Tasks
    Creating a New Report
    Understanding the Data Tools
    Changing Work Effort
    Creating a Custom View
    Resource Assignment Summary Assigning Resources
    Creating a New Table
    Creating WBS Codes

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Contouring Work Hours
    Examining Task Information
    Working With Fixed Duration Tasks
    Creating Summary Tasks
    More Resources in Multiple
    Understanding Resources
    Working With Tables
    Understanding Printing
    Entering Lag Time
    Working With Fixed Unit Tasks
    Assigning Calendars to Resources
    Assigning Resources You Do Not
    Starting Project in Windows
    Gantt Chart View
    Exiting From Project 2016 Project Management
    Understanding Lead Time
    Modifying the Standard Calendar
    Working With Split Screens
    Entering Task Durations
    Creating a New Project File
    Understanding the Gantt Chart

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Case Study Variable Costs
    Deleting an Unwanted Filter
    Adding To A Material Assignment
    Tracking Actuals On A Gantt Chart
    Working With Progress Lines
    Contouring Materials Usage
    Highlighting a Range of Tasks
    Adding Fields Using Add New Column
    More Highlight Filters
    Manually Updating Tasks
    Saving an Existing View
    Using Custom Views
    Creating an Over Allocation Report
    Resource Levelling
    Checking Resource Usage
    Changing Rates During a Project
    Adding Fields Using Insert Column
    Changing Gantt Chart Styles
    Adding Simple Custom Fields
    Assigning Fixed Costs
    Understanding Overtime

  • See Training Course Details...


Microsoft Project 2016 Level 3

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Using Only the Combined Project File
    Manipulating Report Data
    Preparing for the Custom View
    Understanding Collaboration Options
    Working With a Synced Task List Microsoft Project VBA
    Printing From a Combined Project
    Using a Lookup Table WBS Codes
    Exporting to Excel Using a Map
    Importing Data From Excel Working Collaboratively
    Saving a Visual Report as a Template
    Creating an Outline Code Mask
    Understanding Project Downsizing
    Copying to Microsoft Excel
    Adding a Contact as a Resource
    Specifying the Personal Templates
    Running a Localised Macro
    Components Graphical Reports
    Inserting Custom Fields
    Understanding the Global Template
    Understanding Project Templates
    Understanding Graphical Reports

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Introduction to Reporting Clients 
    .NET Assemblies
    Perspectives 
    Welcome to the Real Time - Proactive Caching 
    Excel 2003 Pivot Tables 
    Excel Services 12 and AS (Web Services)
    Disaster Recovery - backup / restore 
    Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions 
    Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 
    Creating cubes - using the UDM and the Cube Build Wizard 
    KPIs 
    Using the MDX query editor in SQL Server Management Studio 
    Intermediate MDX 
    Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter 
    Cube processing options 
    Actions - regular, drill-through and reporting 
    Using multiple fact tables 
    Data Mining clients 
    SPS RS web parts & .NET 2.0 report viewer controls 
    Intermediate SSAS

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Shropshire
  • 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 Lookup Transformation 
    Introduction to Control Flow
    Project templates 
    The package designer 
    The Execute Process Task 
    Data Viewers 
    Business Intelligence Development Studio
    Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations 
    The Web Service Task 
    Examining Database Maintenance Plan Packages 
    Configurations and deployment 
    The FTP Task 
    Using variables in data flow 
    The Aggregate Transformation 
    Containers – grouping and looping 
    Built-in log providers 
    Revisiting data sources and destinations 
    Introduction to Data Flow

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Explore Advanced Dimension Types
    Understand the Development Environment
    Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
    Implement XMLA Scripts in SSMS
    What Is Microsoft Business Intelligence?
    Use Excel 2007 as a Data Mining Client
    Implement Excel 2007 Pivot Tables and Charts
    Create Data Source Views
    Explore Scalability Options
    Consider Data Mining Clients
    Understand SSAS Database Backup and Restore
    Review Microsoft Office SharePoint Server 2007
    MDX Expressions
    Customize Aggregation Designs
    Deploy and View a Sample Cube
    Implement SSAS Security
    Understand Writeback in Dimensions
    Explore how to add MDX Script Commands

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Create a Package Deployment Utility 
    Best Practices for Package Development and Design 
    When Things Go Wrong 
    Data Flow Best Practices 
    Advanced Control Flow
    Packaging Logging 
    Advanced Control Flow Overview 
    Overview of Control Flow in Integration Services 
    Data Viewers 
    Event Handling 
    Synchronous and Asynchronous Transformations 
    Best Practices for Using Integration Services 
    Redeploying Updated Packages 
    Using Advanced Transformations 
    Advanced Data Flow
    Understanding Integration Services 
    Deploying Packages 
    Using Variables and Configurations between Packages 
    Scripting and Custom Components
    Error Handling and Logging 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Calculated Members.
    Maintaining and Optimizing
    Understanding Perspectives
    Relating with Relationships
    Dissecting with Dimensions
    Measures and Measure Groups
    Common Analysis Services Solutions
    Browsing the Model
    Deploy a multidimensional model.
    Understanding the Tabular Model
    Browsing Perspectives and Translations
    Utilizing Data Sources and Data Source Views
    Analysis Services Installation and Architecture: One Product, Two Models
    Choosing the Right Model
    Analysis Services Tools.
    Examining Deployment Options

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Using Expressions in Packages Containers
    Moving Data with Data Flow
    Optimizing Sources for Extraction
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Container Loops Performing Joins
    The SQL Server Integration Service
    Managing SQL with the SQL Tasks
    SQL Server Integration Services Architecture
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Creating Dynamic Packages
    Examining the SSIS Engine
    Coding the Script Task
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Data Loading with the Analysis Services Tasks
    Understanding Parameters SQL Server Integration Services Tools
    Using Destinations and Understanding choices
    Overview of Containers
    Utilizing Data Preparation Tasks
    Understanding Variables
    Utilizing SQL Server Integration Services Data Typing
    Performing Joins with the Lookup Transformation

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

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

  • Some of the training topics covered include ...
  • Understanding Variances Between SQL Versions
    Understanding HTML5 and Textboxes
    SQL Server 2016 Report Builder Basic Reports
    Working with Map Wizard
    Introduction to SQL Server 2016 Report Builder
    Using the List Object to Combine Other Items
    Mastering Data Region(s)
    Examining Management
    SQL Server 2016 Report Builder Advanced Reporting
    Utilizing Lists
    Utilizing Chart Wizard
    Utilizing Charts
    SQL Server 2016 Report Builder Graphics
    Examining Parameters
    Examining Security
    Using Tables
    Utilizing Data Sources
    Examining Maps
    Exploring the Report Builder Interface
    Working with Datasets

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Moving Data Mining Objects Processing
    Choose and Map Input Data for a Prediction Query
    Apply Prediction Functions to a Model
    Choose the Column to Use for Testing a Mining Model
    Browse a Model Using the Microsoft Naive Bayes Viewer
    Deployment of Data Mining Solutions
    Browse a Model Using the Microsoft Association Rules Viewer
    Browse a Model Using the Microsoft Tree Viewer
    Change the Properties of a Mining Model
    Export and Import Data Mining Objects Architecture
    Nested Tables
    Columns Data Types
    Make a Copy of a Mining Model
    Drillthrough on Mining Structures Create Mining Models
    Change the Discretization of a Column in a Mining Model
    Query the Parameters Used to Create a Mining Model
    Process a Mining Model
    SystemGetClusterCrossValidationResults
    Microsoft Neural Network
    Apply Filters to Model Testing Data
    Browse a Model Using the Microsoft Neural Network Viewer

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

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

  • Some of the training topics covered include ...
  • Define a Referenced Relationship and Referenced Relationship Properties
    Create a Dimension Using the Dimension Wizard
    Define Semiadditive Behavior
    View the XML for an Analysis Services Project Data Sources
    Use Aggregate Functions
    Create Calculated Members
    Define Assignments and Other Script Commands
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Edit or Delete Partitions Merge Partitions
    Create Local Partitions
    Define a Regular Relationship and Regular Relationship Properties
    Deploy Model Solutions Using XMLA
    Modify or Delete an Analysis Services Database
    Create a Time Dimension by Generating a Time Table
    Modify or Delete in Solution Explorer Database Dimensions
    Add or Remove Tables or Views in a Data Source View
    Calculations using the Business Intelligence Wizard
    Use a Template to Create an Action Deployment
    Define Logical Primary Keys in a Data Source View
    Create a Data Source
    Batch Processing Remote Processing

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Impersonation
    Bi-directional cross filters  Calculations
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Process Tabular Model Partitions
    Analyze in Excel
    Add sample data to DirectQuery models
    Create and Manage Perspectives Translations Roles
    Import data by using a native query
    Data types supported
    Tabular model designer
    Import from Power View
    Connect to a tabular model database
    Define partitions in DirectQuery models
    Data sources supported in tabular 1400 models
    Row filter mappings
    Create and Manage Partitions in the Workspace
    Add columns to a table
    Process Database, Table, or Partition
    Data sources supported in SSAS tabular 2017
    Sort Data in a Table

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Creating a report with the report wizard
    Schedules
    Introduction to reporting services
    Mobile report publisher
    Drillthrough in mobile reports
    Configuring data access with report builder
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Configuring data access with report designer
    Databars, sparklines, indicators, gauges, and maps
    Data filters
    Topics include Introduction to Reporting Services
    Drilldown and drill through Sharing Reporting Services Reports
    Use report services configuration manager to reconfigure SSRS servers.
    Sorting and grouping
    Publish a report to reporting services Working with Reporting Services Data
    Images and charts
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Reporting services components
    Using Datasets Creating Paginated Reports
    Preparing data for mobile reports
    Formatting data

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Pivot Table Concepts
    About Business Intelligence
    About Views
    Managing the Views Using Secondary Views
    Logical Data Models
    Gauge View
    Creating a New Request
    Understanding the Dashboard Structure
    Managing Saved Content
    Downloading the Answers Report Formatting
    Controlling the Report Definition
    Viewing Supplementary Content
    View Selector View
    OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
    Understanding The Dashboard Interface
    Chart View
    Prompts Column Formatting
    Using the Dashboard Editor
    Variable References
    Previewing the Answers
    Set Operations

  • See Training Course Details...


Oracle PL/SQL

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

  • Some of the training topics covered include ...
  • PL/SQL Syntax and Logic 
    User-Defined Exceptions 
    Passing Parameters and Default Arguments 
    Beyond Declarative Integrity 
    Assignment and Conversions 
    Record Variables 
    Multi-Row Queries 
    Associative Array Collections 
    Anchored Types 
    Subtypes 
    LOB Locators 
    Maintaining Stored Programs
    Overloading Package Functions and Procedures 
    Scope and Name Resolution 
    VARRAY and Nested TABLE Collections 
    Comments and Labels 
    The DBMS_LOB Package
    Procedures and Functions 
    Other Supplied Packages
    Working with LOBs 
    Nesting Blocks 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • The SELECT Statement 
    Choosing Rows with the WHERE Clause 
    The UPDATE Statement 
    Intervals 
    Relational Database and SQL Overview 
    Updatable Views 
    NULL Values 
    The DELETE statement 
    Interactive SQL*Plus Scripts 
    Logical and Physical Storage Structures 
    Data Definition and Control Statements 
    Sample Database 
    Correlated Subqueries 
    Combining SELECT Statements 
    The Aggregate Functions 
    Introduction to SQL 
    Other Database Objects 
    Using SQL Functions 
    Explicit Locking 
    IN and BETWEEN 
    Self Joins 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • mail() 
    Opening a File 
    PHP Tags 
    Using PEAR DB 
    Cookies 
    Looping through Arrays 
    How HTML Forms Work 
    By Reference vs. By Value 
    Reading from Two-dimensional Arrays 
    Form Validation and Presentation Functions 
    Start and End ( ^ $ ) 
    auto_prepend_file and auto_append_file 
    Looping through Associative Arrays 
    The php.ini File 
    Creating a Resume Management Page
    Variable Scope 
    PHP Basics
    Flow Control 
    Including Files 
    Concatenation 
    User Functions 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Application settings
    Getting help New presentations
    Transitions and timings
    Proofing presentations
    Adding shapes
    Custom slide shows
    Interactive elements
    Custom themes Using graphics and multimedia
    WordArt Pictures
    Slide shows Proofing and delivering presentations
    Slide masters
    Photo albums Customizing SmartArt graphics, tables, and charts
    Clip art
    Embedding and linking content
    The Ribbon
    Getting started
    Formatting paragraphs Using drawing objects
    Diagrams Modifying presentations
    Printing presentations Customizing PowerPoint
    Clip art Using tables and charts

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Slide masters
    Action buttons and equations
    Pictures Tables and charts
    Working with slides Editing slide content
    Applying content to shapes Graphics
    Customizing tables
    Transitions and timings
    Proofing presentations
    Creating shapes
    WordArt
    Action buttons
    Embedding and linking content Finalizing and distributing presentations
    Custom slide shows Graphics and media
    Working with charts
    Formatting shapes
    Editing efficiently Working with shapes
    Application settings
    Equations Integrating Microsoft Office files

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Creating Custom Slide Layouts
    Hiding Data Series
    Inserting a Chart Using the Ribbon
    Presenting a Slide Show Online
    Formatting Media Clips
    Viewing the Slide Master
    Modifying Slide Layouts
    Rehearsing Timings
    Understanding Online Pictures
    Understanding Animation
    Formatting Table Data
    Saving to OneDrive
    Animating Text
    Animating Objects
    Applying Borders
    Setting Up a Self Running
    Applying a Theme
    Changing the Chart Type
    The Animation Pane

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Shropshire
  • 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 Dialog Boxes
    Printing Notes Pages
    Using Google to Get Help
    The Save As Place
    Inserting Text Into SmartArt
    Creating a Hyperlink to Another
    Inserting a Section Header Slide
    Rotating Shapes
    Changing the Slide Layout
    Using Tell Me
    Using Slide Sorter View
    Slide Shows
    Adding an Assistant
    Showing and Collapsing the Ribbon
    Presentations
    Changing Bullet and Numbering
    Typing Text Into a Slide
    Adding Shapes Below
    Starting PowerPoint From the

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Master pages
    Data sources for the recipient list
    Styles and font schemes
    The Graphics Manager pane
    Customizing the Ribbon
    Table formatting
    Multi-page layouts
    Graphics adjustments
    Basic publications
    Finalizing publications
    Publication output
    Table structure
    Building blocks
    Long publications
    Layout and design techniques
    Multi-page publications
    Publication basics
    Text box linking

  • See Training Course Details...


Publisher 2013

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

  • Some of the training topics covered include ...
  • Inserting Calendars
    Saving A New Publication On Your Computer
    Inserting Advertisements Working With Shapes
    Inserting A Caption Working With Tables
    Using Baseline Guides
    Changing The File Type
    Selecting Text
    Creating Bulleted Lists
    Working With Layouts
    The Open Dialog Box
    Merge Printing
    Creating A Text Box
    Previewing And Modifying A Catalogue Merge
    Googling Help
    Using Colour Schemes
    Selecting Shapes
    Safely Closing A Publication Working With a Publication
    Picture Formatting And Effects
    Applying Colour To Text
    Inserting Tables
    Inserting Online Pictures

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Inserting Pictures
    Inserting Footers
    Moving Shapes
    Creating Grid Guides
    Deleting Pages
    Modifying a Text Style
    Creating a Data Source
    Drawing Lines
    Creating a Mail Merge Publication
    Inserting a Caption
    Working With Text
    Formatting Text
    Inserting Borders and Accents
    Changing Margin Guides
    Picture Formatting and Effects
    Changing Fill
    Using Colour Schemes
    Using the Ribbon
    Naming Pages

  • See Training Course Details...


SQL

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

  • Some of the training topics covered include ...
  • Creating Views
    Creating Tables
    Using CASE  Inserting, Updating and Deleting Records
    Columns 
    Views  
    Comments
    Creating Stored Procedures 
    Grouping and Aggregating Data    
    Adding and Dropping Columns
    Common Math Functions    
    The BETWEEN Operator   
    Relationships 
    Outer Joins
    Case Sensitivity
    Selecting All Columns in All Rows
    The NOT Operator 
    Primary Keys
    Subqueries      

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Grouping Data
    Select the Data Source Dialog
    Deploying the Auditing and Management Reports
    Report Model Generation Rules
    Query tab
    Shared Schedules
    Creating a Report Model Project
    Interactive Sort
    Visibility
    Creating Formulas
    The Main Components of the Design Environment
    Parameters
    The Reporting Services 2005 Report Wizard
    Sorting
    Web Folder Properties
    Data Source Properties
    Getting Started Pane
    Adding System-level Roles
    Toolbar
    Displaying Parameters in a Report

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Shropshire
  • 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 what SQL Server Reporting Services can do 
    Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place 
    Learn how to create a tabular report from scratch 
    Learn how to create custom functions using the Code window 
    Investigate how to manage Reporting Services projects using Report Manager 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Security
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Discover the many application programming interfaces of Reporting Services 
    Find out how to use Report Manager to manage user accounts and roles 
    Learn how to solve common parameter issues 
    Explore creating groups 
    Learn about report variables and when you might need to use them 
    Master the Reporting Services Grouping pane 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

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

    The course requires a working knowledge of SQL.

  • Some of the training topics covered include ...
  • Create Expressions with Variables
    Profile OLTP Data
    Execute SSIS Packages on the Server
    Troubleshoot Package Failures Deploying Packages
    Debugging and Troubleshooting Packages
    Deploy SSIS Packages
    Work with Windows Azure
    Configure the Package Execution Strategy
    Perform Transformation Tasks
    Cleanse Data Using DQS Managing SSIS Package Execution
    Overview of Data Warehouse Components
    Securing Packages and Databases
    Install Integration Services Working with Integration Services
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Secure Databases Working with MDS and Windows Azure
    Add Script Tasks and Script Components to an SSIS Package
    Secure Packages
    Work with MDS Databases
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Examine Data Warehousing Concepts

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
    Designing the Page Layout
    Multivalued Parameters Dynamic Reports with Parameters
    Installing SQL Server Data Tools
    Page Headers and Footers Report Formatting Options
    Creating a Shared Data Source and Data Sets
    Formatting Text Boxes from the Toolbars
    Providing a Drop-Down List for a Report Parameter
    Preview Performance
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Formatting Tablix Rows and Columns Making Reports Interactive
    Create a  Parameterised Report
    The Global Collections
    Create a Tabular Report  Using the Tablix Report Type
    Introducing SQL Server Data Tools
    Groups before Row Headers
    The Report Designer Creating Reports with SQL Server Data Tools
    Create Shared Data Sources and Data Sets
    Interactive Sorting
    Report Definition Language (RDL)

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Delete Data
    Configure Indexes
    Manage Transactions Querying SQL Server System Metadata
    Work with Variables and Batches
    Modifying Data
    Combine Data Using Simple Joins
    Work with Set Operators
    Work with PIVOT and UNPIVOT
    Insert Data
    Implement Error Handling
    Merge Data Working with SQL Server Built-in Functions
    Work with Date and Time Data Types
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Manage Triggers
    Work with Subqueries
    Work with System Databases
    Assign Aliases Using Queries
    Write CASE Expressions Working with SQL Data Types
    Manage Query Plans
    Work with Grouping Sets Managing Error Handling and Transactions
    Work with Predicates

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Creating a basic diagram
    Integration with Microsoft Outlook
    Editing objects
    Block, tree, and onion diagrams
    Basic shapes and lines
    Shape behavior and events
    Organization charts
    Advanced Layout and connection techniques
    Integration with Microsoft Word
    Themes and styles
    Software and database diagrams
    Creating shapes for a stencil
    Working with links
    Rack diagrams
    Dimensioning
    Flowcharts
    Using windows and stencils
    Compound lines
    Printing diagrams

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Organization charts
    Project management diagrams
    Rack diagrams
    Windows, stencils, and objects Drawing tools
    Displaying shape dimensions Custom themes and templates
    Reporting
    Working with background pages
    Integration with Microsoft Outlook
    Brainstorming diagrams Customization and reporting
    Web site maps Integrating Visio with other programs
    Documenting software systems
    Formatting text
    Block, tree, and onion diagrams
    Network diagrams
    Editing objects Basic diagrams
    Basic shapes and lines
    Custom stencils Business diagrams and Web site mapping
    Special drawing operations
    Organization charts Formatting drawings
    Integration with Microsoft Word
    Getting started

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Custom themes and templates
    Brainstorming diagrams
    Organization charts
    Creating technical layouts
    Working with Web-enabling features
    Custom stencils
    Block, tree, and onion diagrams
    Integration with Microsoft Word
    Rack diagrams
    Custom templates
    Working with links
    Reporting
    Network and brainstorming diagrams
    Formatting text
    Basic diagrams
    Displaying shape dimensions

  • See Training Course Details...


Word 2010 Advanced

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Updating Formulas In A Table
    Defining A Number Format
    Saving Building Blocks
    Templates
    Aligning Data In Cells
    Understanding Section Breaks
    Marking Index Entries
    Applying Hyphenation To Text
    Creating A Template
    Saving A Custom Theme
    Macros
    Defining A Bullet
    Creating A Master Document
    Controlling Widows And Orphans
    Understanding Text Boxes
    Formatting Techniques
    Inserting A Watermark
    Inserting A Blank Cover Page

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Checking Spelling And Grammar
    Techniques For Selecting Text
    Using The Blank Document
    Inserting A Blank Header
    Using Ribbon KeyTips
    Changing Page Margins
    Selecting Text Using The
    Saving An Existing Document
    The Word Screen
    Inserting A Picture
    Creating A Table
    Footers
    How Microsoft Word 2010 Works
    Deleting WordArt Getting Help
    Understanding Font Formatting
    Launching Dialog Boxes
    WordArt
    Saving A New Document
    Understanding Headers And

  • See Training Course Details...


Word 2013 Advanced

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

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Shropshire
  • Course Outline
  • Some of the training topics covered include ...
  • Paragraph spacing and indents Tables
    Page setup
    Working with outlines Proofing, printing, and exporting
    The Word window
    Spelling and grammar
    Working with graphics Styles and outlines
    The Undo and Redo commands
    Adding graphics and clip art
    Cut, copy, and paste
    Working with table content
    Working with styles
    Getting started
    Working with text
    Examining formatting
    Table design options
    Graphics
    Paragraph formatting
    Character formatting
    Headers and footers
    Document navigation Editing text

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Creating a Table
    Underlining Text
    The Save As Place
    Using the Clipboard Task Pane
    Understanding How Help Works
    Making Text Bold
    Creating the Starting Document
    Viewing Multiple Pages
    Understanding Online Pictures
    Deleting Columns and Rows
    Using the Font Dialog Box
    Changing Text Alignments
    Understanding Find and Replace
    Outdenting Paragraphs
    Showing Paragraph Marks
    Drag and Drop Cutting
    Borders and Shading Dialog Box
    Modifying Tabs on the Ruler
    Viewing Documents
    Product Code: INF1650

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Splitting Table Cells
    Personalising Word
    Specifying Column Widths and
    Mail Merge Techniques
    Inserting Date Information
    Inserting Headers and Footers
    Resizing a Text Box
    Softening and Bevelling Edges
    Selecting Shapes
    Switching Between Open Documents
    Setting Up Mailing Labels
    Inserting the Greeting Line
    Applying Effects to Text Boxes
    Headers and Footers
    Aligning Data in Cells
    Product Information
    Tips for Developing Templates
    Applying a Solid Fill to Shapes

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Shropshire
  • 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 ...
  • Removing a Custom Dictionary
    Comparisons
    Comparing Documents
    Building Blocks
    Using AutoFormat
    Understanding SmartArt
    Understanding Subdocuments
    Using AutoCorrect
    Inserting Prompt Text
    Adding Words to the Custom
    Checker
    Updating Fields Automatically When
    Creating Subdocuments
    Inserting a Drop Down List Control
    Inserting a Combo Box Control
    Inserting Footnotes
    Opening and Editing a PDF in Word

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730