Name: Microsoft Excel in Depth: In-House Training
Price: 850 GBP
Availability: InStock

Redhill

<h3><b>Complete Visual BASIC training course description</b></h3>
      <p>    A hands-on introduction to programming in Visual BASIC V6.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	   <li>Build Visual BASIC applications.</li>
					<li>Build simple components. </li>
                    <li>Debug Visual BASIC programs.</li>
                    <li>Examine existing code and determine its function.</li>
                  </ul>
        <h5>
        <b>Complete Visual BASIC training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to program in Visual BASIC.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Complete Visual BASIC training course contents</b></h3>
      <ul>
				<li>Application development using VB </li><p>

VB features. VB editions, VB terminology. Working in the Development Environment. Event-Driven Programming. Creating a program in VB. Project and executable files. VB reference materials.
</p><li>Visual Basic fundamentals </li><p>
Objects. Controlling objects. Introduction to forms. Introduction to controls. Basic controls.

</p><li>Working with code and forms </li><p>
Modules. Working with code. Interacting with the user. Working with code statements. Managing forms.

</p><li>Variables and procedures </li><p>
Introduction to variables and constants. Working with Procedures and Functions.

</p><li>Controlling program execution </li><p>
Common VB functions. Comparison and relational operators. Conditional structures. Looping structures.

</p><li>Debugging </li><p>
Error types. Debugging logic errors in VB.

</p><li>Working with controls </li><p>
Control types. Standard controls. Advanced standard controls. ActiveX controls. Insertable controls.

</p><li>Data access using the ADO data control </li><p>
Overview of ActiveX Data Objects. VB data access features. Relational database concepts. Using the ADO data Control to access data. SQL. Manipulating data. Using the data form wizard.

</p><li>Input validation </li><p>
Field-Level validation. The masked edit control. Form-Level validation. Form events used when validating data.

</p><li>Error trapping </li><p>
Trapping run time errors. Error handling overview. Enabling an error trap. Errors and the calling chain. In line error handling.

</p><li>Enhancing the User Interface </li><p>
Menus. Status bars. Toolbars.

</p><li>Drag and Drop </li><p>
Overview of Drag and Drop. Mouse events Drag and Drop basics.

</p><li>More about controls </li><p>
Using control arrays. Using the controls collection. Working with object variables. Collections.

</p><li>Finishing touches </li><p>
User Interface design principles. Distributing an application. Creating a default project.</p>
			
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Complete Visual BASIC

General Admission

<h3><b>Advanced Python training course description</b></h3>
      <p> This course caters to network engineers aiming to
enhance both their Python proficiency and network
automation skills. Delving deeper into key areas such
as netmiko, Nornir, and ncclient, we also focus on
automating network testing and validation. Participants
gain greater confidence working with Python functions,
classes, objects, and error handling. The course
additionally introduces more libraries like Scrapli, TTP,
pyATS, Genie, pybatfish, and Suzieq, which cover
parsing strategies, automation testing, validation,
network analysis, observability, and telemetry. The
curriculum also encompasses concurrency techniques.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
   <li>Write Python modules and functions.</li>
<li>Evaluate techniques to parse unstructured data.</li>
<li>Use NETCONF filters.</li>
<li>Handle Python errors effectively (try, assertâ¦).</li>
<li>Use postman.</li>
<li>Automate testing and validation of the network.</li>
<li>Use scrapli, Genie, batfish and Suzieq. </li>
                  </ul>
        <h5>
        <b>Advanced Python training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Network engineers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Python for network engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Advanced Python training course contents</b></h3>
      <ul>
		<li>Review</li><p>
CLI, NETCONF, RESTCONF, structured versus
unstructured data, gNMI and when to use which.
PEP 8. Naming conventions. Packages, modules,
Classes and methods. The scrapli library. Netmiko
versus scrapli. <br /><span>Hands on:</span> scrapli, Dictionaries
versus Regular Expressions.

		  </p><li>Modules and Functions</li><p>
Writing your own modules, containers versus
packages, virtual environments. Best practices,
calling functions, writing your own functions.
Parameters, arguments. Named arguments,
dictionaries as arguments. Builtins. Docstrings.
Main. __name__, __main__ . Program arguments.
<br /><span>Hands on:</span> Getting interfaces, showing interface
status using Netmiko and functions. Using
dictionaries as arguments. Writing your own
modules.

		  </p><li>Parsing strategies</li><p>
Turning unstructured data into structured data.
textfsm, PyATS Genie parser, NAPALM getters,
Template Text Parser. <br /><span>Hands on:</span> Genie parser,
TTP. Accessing structured data with lists and
dictionaries.

				</p><li>Classes, objects and Python</li><p>
Python classes in Genie, PyEZ and others .
<br /><span>Hands on:</span> studying network automation classes,
objects, methods and attributes.

			</p><li>Configuration management - more nornir, ncclient,
requests</li><p>
Nornir tasks. Nornir results, Nornir functions,
Nornir plugins. Nornir processors. YANG, YANG
models, pyang. NETCONF hello. Capabilities.
Schemas. Filters. Subtrees. XPATH. Exploring
available YANG data models. NETCONF and
network wide transactions. Asserting NETCONF
capabilities. Configuration types. Locking
configurations, commits. NETCONF data stores.
Netconf-console. RESTCONF differences from
NETCONF. URI construction. Postman. More XML
and JSON. Git and configuration versions. <br /><span>Hands
on:</span> Nornir and Jinja2. Exploring available models,
NETCONF filters. Using postman.

		</p><li>Python error handling and debugging</li><p>
Context handlers, try, assert, logging, pdb, pytest,
unit testing, chatgpt. <br /><span>Hands on:</span> Writing code with
each of the error handling methods, investigating
what happens on an error. Use chatgpt to debug
your code.

	</p><li>Python Automation Testing</li><p>
Testing and validation. pyATS, Genie. Testbed
file. Genie parse, genie learn, genie diff. Genie
conf, Genie ops, Genie SDK, Genie harness.
Xpresso. <br /><span>Hands on:</span> Using Genie for state
comparisons of the network.

	</p><li>Network analysis</li><p>
Batfish, pybatfish, configuration analysis,
analysing routing, analysing ACLs. Pandas.
Pandas dataframe. Filtering and selecting values
of interest. <br /><span>Hands on:</span> Use Batfish to analyse
network snapshots, find network adjacencies, flow
path analysis.

	</p><li>Network observability</li><p>
Suzieq, using docker, using as a package. Sqpoller, suzieq-gui, suzieq-cli, sq-rest-server.
Namespaces and seeing devices, network state
and Asserts. Time based analysis, snapshots and
changes. <br /><span>Hands on:</span> Suzieq: Gathering data from
the network, analysing data from the network.
Network state assertion.

	</p><li>Telemetry</li><p>
gRPC, gNMI. CAP, GET, SET. Subscriptions.
Model Driven telemetry.<br /><span> Hands on:</span> Analysing
telemetry data with Python.

		</p><li>Concurrency</li><p>
asyncio, threads, processes. Nornir concurrency.
Scrapli and netmiko concurrency. <br /><span>Hands on:</span>
Multiple SSH connections to devices at same
time. Scarpli asyncio.
		

</p>
      </ul>

Advanced Python for network engineers

<h3><b>CWDP training course description</b></h3>
        <p>The CWDP course consists of instructor-led training
applicable to the design of wireless LANs using the
latest technologies including 802.11n and 802.11ac.
The course goes in-depth into the design process and
provides attendees with the knowledge needed to plan,
deploy and test modern 802.11-based networks. It also
prepares students for the CWDP examination.
Students who complete the course will acquire the
necessary skills for preparing, planning performing and
documenting site surveys and wireless LAN design
procedures.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
       <li>Design enterprise WiFi networks.</li>
						<li>Select appropriate antennas and Access points.</li>
						<li>Perform site surveys.</li>
						<li>Describe the security requirements required for enterprise networks.</li>
						<li>Test, validate and troubleshoot installations.</li></ul>
                        
                        
        <h5>
        <b>CWDP training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone looking for the skills to analyze, troubleshoot, and
optimize any enterprise level Wi-Fi network, no matter
which brand of equipment your organization deploys.
Anyone looking to become a CWNP.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>
                CWNA</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>CWDP training course contents</b></h3>
      <ul>
				<li>WLAN design overview</li><p>
Importance of good design, Impact of bad
design, Design process, Design skills, Design
toolkit.
				</p><li>Requirements analysis</li><p>
Pre-planning, Customer interaction,
Requirements gathering, Discovering existing
systems, Documenting the environment, Defining
constraints, Creating documentation.
</p><li>Designing for clients and applications</li><p>
Client Device types, Application types,
Application-specific design, High density design
issues.
</p><li>Designing for industry</li><p>
Standard corporate networks, Industry-specific
designs, Government, Healthcare, Hospitality,
Retail, Public hotspots, Transportation, Mobile
offices, Outdoor and mesh, Remote networks
and branch offices, Last-miles / ISP and bridging.
</p><li>Vendor selection processes</li><p>
Defining vendor issues, Operational planes,
Design models, Understanding architectures.
</p><li>Radio Frequency (RF) planning</li><p>
RF spectrum, RF behaviors, Modulation and
coding schemes, RF accessories, Throughput
factors.
WLAN hardware selection
Antennas, 802.11n and antennas, Choosing Aps,
Powering Aps.
</p><li>Site surveys</li><p>
Site survey tools, Site survey preparation,
Predictive site surveys, Manual site surveys, Site
survey principles and processes.
</p><li>Designing for Quality of Service (QoS)</li><p>
QoS overview, QoS application points, Roaming
support.
</p><li>Designing for security</li><p>
Bad security, Authentication solutions,
Encryption solutions, Security best practices,
Intrusion prevention.
</p><li>Installation testing, validation and troubleshooting</li><p>
Network health status, Troubleshooting and
validation process, Troubleshooting and
validation tools, Common problems.
</p><li>Hands-on lab exercises</li><p>
Hands-on labs depend on the audience and can
include use of: Spectrum analyzers, Protocol
analyzers, Site Survey software, Diagramming
software, Various wireless access points,
Various wireless adapters and antennas.
 </p>

      </ul>

CWDP

<h3><b>Windows certificates training course description</b></h3>
        <p>
         A hands-on training course concentrating solely on PKI using Windows certificates.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
          <li>Explain how PKI works.</li>
                   		 <li>Install windows certificates.</li>
                   		 <li>Configure windows certificates.</li>
                   		 <li>Troubleshoot windows certificates.</li>
                  </ul>
				
        <h5><b>Windows certificates training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical security staff.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Windows server.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Windows certificates training course contents</b></h3>
				<ul>	<li>PKI</li><p>
Symmetric encryption, asymmetric encryption,
authentication, digital signing, hashing,
certificates, Certification Authorities, Root CA,
Intermediate CA, policy CA, Issuing CA,
Certificate Revocation Lists. <br /><span>Hands on</span>
Inspecting a certificate.
					</p><li>Policies and PKI</li><p>
Security policy, certification policy.
</p><li>CA hierarchy</li><p>
Impact of CAs on Active Directory, CA
architecture, number of tiers, issuing CA
organisation, CA configuration files. CA security.
<br /><span>Hands on</span> CA installation PKI health tool,
monitoring.
</p><li>Certificate revocation</li><p>
When to revoke, OCSP. <br /><span>Hands on</span> Revoking
certificates.
</p><li>Certificate validation</li><p>
Discovery, validation, checks, revocation
checking, certificate chains, certification
publication. <br /><span>Hands on</span> Event viewer.


</p><li>Certificate templates</li><p>
Version 1, version 1, default, modifying
templates. <br /><span>Hands on</span> Template management.
</p><li>Roles</li><p>
Criteria roles, CA administrator, Certificate
manager, Backup operator, Auditor. Other PKI
management roles.
	</p><li>Disaster recovery</li><p>
Backups, recovery. <br /><span>Hands on</span> certutil.
</p><li>Issuing certificates</li><p>
The certificate enrolment process, enrolment
methods, manual enrolment, automatic
enrolment.
</p><li>Trust between organisations</li><p>
Creating Trust, CTLs, common root CA, cross
certification, bridge CA.
</p><li>Web servers and certificates</li><p>
SSL encryption, certificate authentication. <br /><span>Hands on</span> Web servers.
</p><li>VPN</li><p>
<br /><span>Hands on</span> Certificate deployment for VPN.
</p><li>WiFi</li><p>
<br /><span>Hands on</span> 802.1X
</p>
				</ul>

Windows certificates for engineers

London

<h2>Writing and Managing Requirements Documents: In-House Training</h2>
 <p>This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA™ Certification exam to become a Certified Business Analysis Professional (CBAP™). Learn more at www.iil.com/bacp.</p>
 <p>Once a business analyst has completed the information gathering and analysis to produce the solution to a business problem, the results must be documented for all stakeholders to see and understand. This course will enhance the skill set needed for writing and managing the complex readership that business analysts interact with on a day-to-day basis.</p><h3>What you will Learn</h3>
 <p>Upon completion, participants will be able to:</p>
 <ul>
 <li>Write an understood requirements document that is approvable and acceptable</li>
 <li>Validate a requirements document</li>
 <li>Manage the changes to requirements documents through the SDLC</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>The role of the business analyst</li> <li>An introduction to the BABOK® Guide</li> <li>The business analyst and the product/project life cycle</li> <li>The requirements documentation process</li> </ul> <h3>Planning for Effective Requirements Documentation</h3> <ul> <li>Overview of requirements planning</li> <li>Planning for validation</li> <li>Planning for verification: well-formed criteria</li> <li>Planning for verification: understood and usable criteria</li> </ul> <h3>Writing Effective Requirements Documents</h3> <ul> <li>Overview of writing requirements documents</li> <li>Using a standard structure / template</li> <li>Applying formatting techniques</li> <li>Meeting the challenge of writing non-functional requirements</li> </ul> <h3>Baselining Requirements Documents</h3> <ul> <li>Overview of the requirements baseline process</li> <li>Validation</li> <li>Verification</li> <li>Approval</li> </ul> <h3>Managing Requirements Change through the Product Life Cycle</h3> <ul> <li>Overview of requirements change management</li> <li>Establishing a formal change management process</li> <li>Tracing requirements through design and development (build, test, and implementation)</li> <li>Following through to post-implementation (transition and early production)</li> </ul>


                </section>

IIL Europe Ltd

Writing and Managing Requirements Documents: In-House Training

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Excel Advanced - In-company

<h3><b>Web development training course description</b></h3>
      <p>This three-day course helps build a foundation in the
development of Web applications. This is not a HTML
course but covers the technologies needed to develop
web applications. Technologies covered include:
ASP.NET, XML, AJAX and HTTP error codes.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                       <li>Program Web applications.</li>
				  	                <li>Work with data and services.</li>
                       <li>Troubleshoot and debug Web applications.</li>
                      	<li>Work with client side scripting.</li>
                       <li>Configure and deploy web applications.</li>
                  </ul>
        <h5>
        <b>Web development training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone looking for an introduction to web development.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Web development training course contents</b></h3>
      <ul>
				<li><span>Programming web applications</span></li><p>
</p><li>Customise the layout and appearance of a web page </li><p>
CSS; tables; embedding images; page layout for navigation.

</p><li>Understand ASP.NET intrinsic objects </li><p>
Request; Server; Application; Session; Response; HttpContext.

</p><li>Understand state information in web applications </li><p>
Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state.

</p><li>Understand events and control page flow </li><p>
Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup.

</p><li>Understand controls </li><p>
Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario.

</p><li>Understand configuration files </li><p>
Understanding the usage of web.config and machine.config, and the settings that can be made.

	</p><li><span>Working with data and services </span></li><p>
</p><li>Read and write XML data </li><p>
Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager.

</p><li>Distinguish between DataSet &amp; DataReader objects </li><p>
The ability to choose the proper data object to use based on application requirements/design.

</p><li>Call a service from a web page </li><p>
Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration.

</p><li>Understand DataSource controls </li><p>
LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource.

</p><li>Bind controls to data by using data binding syntax </li><p>
Ensure that data is updated and displayed in data-aware controls.

</p><li>Manage data connections and databases </li><p>
Database connections; connection objects; connection pools; transaction objects.

	</p><li><span>Troubleshooting and debugging web applications</span> </li><p>
</p><li>Debug a web application </li><p>
Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive.

</p><li>Handle web application errors </li><p>
HTTP error codes.

</p><li><span>Working with client-side scripting </span></li><p>
</p><li>Understand client-side scripting </li><p>
Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions.

</p><li>Understand AJAX concepts </li><p>
ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls.

	</p><li><span>Configuring and deploying web applications </span></li><p>
</p><li>Configure authentication and authorisation </li><p>
Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication.

</p><li>Configure projects, solutions and reference assemblies </li><p>
Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings.

</p><li>Publish web applications </li><p>
Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration.

</p><li>Understand application pools </li><p>
Purpose of application pools; effect of application pools on web applications.</p>
			
      </ul>

Web development fundamentals

<h3><b>HTML5 development training course description</b></h3>
      <p> This three-day MTA Training course helps you prepare
for Microsoft Technology Associate Exam 98-375, and
build an understanding of these topics: Manage the
Application Life Cycle, Build the User Interface by
Using HTML5, Format the User Interface by Using
CSS, Code by Using JavaScript. This course leverages
the same content as found in the Microsoft Official
Academic Course (MOAC) for this exam.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                      <li>Manage the Application Life Cycle.</li>
				  	                <li>Build the User Interface by Using HTML5.</li>
                       <li>Format the User Interface by Using CSS.</li>
                      	<li>Code by Using JavaScript.</li>
                  </ul>
        <h5>
        <b>HTML5 development training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with HTML5.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>HTML5 development training course contents</b></h3>
      <ul>
				<li><span>Managing the Application Life Cycle</span></li><p>
</p><li>Platform fundamentals </li><p>
Packaging and the runtime environment: app package, app container, credentials/permission sets, host process, leverage existing HTML5 skills and content for slate/tablet applications.

</p><li>Manage the state of an application </li><p>
Manage session state, app state and persist state information; understand states of an application; understand the differences between local and session storage.

</p><li>Debug and test a HTML5 touch-enabled application </li><p>
Touch gestures; gestures you test on a device.


</p><li>HTML5 UI: Text, Graphics, and Media </li><p>
</p><li><span>HTML5 tags for text content and graphics.</span> </li><p>
When, why and how to use Canvas; when, why and how to use scalable vector graphics (SVG).

</p><li>HTML5 tags to play media. </li><p>	
Video and audio tags.


</p><li>HTML5 UI: Organization, Input, and Validation </li><p>
</p><li><span>HTML5 tags to organise content and forms</span> </li><p>
Tables, lists, sections; semantic HTML.

</p><li>HTML5 tags for input and validation </li><p>

</p><li>CSS Essentials: Content Flow, Positioning, styling </li><p>
</p><li><span>Core CSS concepts</span> </li><p>
Separate presentation from content (create content with HTML and style content with CSS); manage content flow (inline versus block flow); manage positioning of individual elements( float versus absolute positioning); manage content overflow (scrolling, visible and hidden); basic CSS styling.


	</p><li>CSS Essentials: Layouts </li><p>
</p><li><span>Arrange UI content by using CSS </span></li><p>
Use flexible box and grid layouts to establish content alignment, direction and orientation; proportional scaling and use of "free scale" for elements within a flexible box or grid; order and arrange content; concepts for using flex box for simple layouts and grid for complex layouts; grid content properties for rows and columns; use application templates.


</p><li>Managing Text Flow by Using CSS </li><p>
Regions and using regions to flow text content between multiple sections (content source, content container, dynamic flow, flow-into, flow-from, msRegionUpdate, msRegionOverflow, msGetRegionContent); columns and hyphenation and using these CSS settings to optimise the readability of text; use "positioned floats" to create text flow around a floating object


</p><li>Managing the Graphical Interface by Using CSS </li><p>
Graphics effects (rounded edges, shadows, transparency, background gradients, typography and Web Open Font Format); 2-D 3-D transformations (translate, scale, rotate, skew and 3-D perspective transitions and animations); SVG filter effects; Canvas.


</p><li>JavaScript and coding essentials </li><p>
Manage and maintain JavaScript, Create and use functions; jQuery and other third-party libraries. Update the UI by using JavaScript Locate/access elements; listen and respond to events; show and hide elements; update the content of elements.


</p><li>Animations, Graphics, and Accessing Data </li><p>
</p><li><span>Code animations with JavaScript</span> </li><p>
animation; manipulate the canvas; work with images, shapes and other graphics.

</p><li>Access data access by using JavaScript </li><p>
Send and receive data; transmit complex objects and parsing; load and save files; App Cache; datatypes; forms; cookies; localStorage


 </p><li>JavaScript coding for Touch Interface, Device and Operating System Resources, and More </li><p>
Respond to the touch interface, Gestures, how to capture and respond to gestures, Code additional HTML5 APIs, GeoLocation, Web Workers, WebSocket; File API, Access device and operating system resources, In- memory resources, such as contact lists and calendar; hardware capabilities, such as GPS, accelerometer and camera.</p>
			
      </ul>

HTML5 development fundamentals

<div>
</div>
<section>
<div>
<h2><strong>About this training course</strong></h2>
<p>This 5 full-day course will cover all aspects of steam turbines including design and features of modern turbines, material, rotor balancing, features enhancing the reliability and maintainability of steam turbines, rotor dynamic analysis, Campbell, Goodman and SAFE diagrams, Blade failures: causes and solutions, maintenance and overhaul of steam turbines, and modeling of steam turbines. This course will also cover in detail all the components of these turbines, instrumentation, control systems, governing systems, and selection criteria.</p>
<p>The main focus of this course will be on the failure modes of steam turbine components, causes and solutions for component failure, maintenance, refurbishment and overhaul, rotor dynamic analysis of steam turbines, and computer simulation of steam turbine rotor dynamics. All possible failure modes of steam turbine components and the maintenance required to prevent them will be discussed in detail. Examples of rotor dynamic analysis, and stability criteria will be covered thoroughly.</p>
<p>This course will also provide up-dated information in respect to all the methods used to enhance the availability, reliability, and maintainability of steam turbines, increase the efficiency and longevity of steam turbines, and improve the rotor dynamic stability. This course will also cover in detail all steam turbine valves, jacking oil system, turning gear, turbine supervisory system, steam turbine monitoring technology, validation, and verification tests, performance testing of steam turbines and steam turbine codes especially ASME PTC6.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<ul>
<li><strong><span>Steam Turbine Components and Systems:</span></strong><span> Learn about all components and systems of the various types of steam turbines such as: stationary and rotating blades, casings, rotor, seals, bearings, and lubrication systems</span></li>
<li><strong><span>Steam Turbine Failure Modes, Inspection, Diagnostic Testing, and Maintenance:</span></strong><span> Understand all the failure modes of steam turbine components, causes and solutions of steam turbine component failure, inspection, diagnostic testing, and all maintenance activities required for steam turbines to minimize their operating cost and maximize their efficiency, reliability, and longevity.</span></li>
<li><strong><span>Steam Turbine Instrumentation and Control Systems:</span></strong><span> Learn about the latest instrumentation, control systems, and governing systems of steam turbines</span></li>
<li><strong><span>Steam Turbine Reliability and Maintainability:</span></strong><span> Increase your knowledge about all the methods used to enhance the reliability and maintainability of steam turbines as well as the predictive and preventive maintenance required for steam turbines</span></li>
<li><strong><span>Steam Turbine Selection and Applications:</span></strong><span> Gain a detailed understanding of the selection considerations and applications of steam turbines in steam power plants, co-generation, combined-cycle plants, and drivers for compressors pumps, etc</span></li>
<li><strong><span>Steam Turbine Valves, Load-Frequency Control, Turbine Bypass Systems, and Steam Turbine Superheater Attemperators:</span></strong><span> Gain a thorough understanding of all steam turbine valves, load-frequency control, turbine bypass systems, and steam turbine superheater attemperators</span></li>
<li><strong><span>Jacking Oil System and Turning Gear:</span></strong><span> Learn about the turbine jacking oil system and turning gear operation</span></li>
<li><strong><span>Turbine Supervisory System:</span></strong><span> Gain a thorough understanding of the turbine supervisory system</span></li>
<li><strong><span>Steam Turbine Monitoring Technology, Validation, and Verification Tests for Power Plants:</span></strong><span> Learn about steam turbine monitoring technology, validation, and verification tests for power plants</span></li>
<li><strong><span>Steam Turbine Codes:</span></strong><span> Learn about steam turbine codes including ASME PTC6, DIN Test Code, and International Electrotechnical Commission (IEC) Doc 1, IEC Doc B</span></li>
<li><strong><span>Steam Turbine Rotor Dynamic Analysis, Campbell, Goodman, and SAFE Diagrams: </span></strong><span>Gain a thorough understanding of steam turbine rotor dynamic analysis, Campbell, Goodman, and SAFE diagrams</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<ul>
<li><span>Engineers of all disciplines</span></li>
<li><span>Managers</span></li>
<li><span>Technicians</span></li>
<li><span>Maintenance personnel</span></li>
<li><span>Other technical individuals</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization.</span></p>
<p><span>Each delegate will receive a copy of the following materials written by the instructor:</span></p>
<ul>
<li><span>Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by</span> <span>McGraw-Hill in 2012 (800 pages)</span></li>
<li><span>STEAM TURBINE TECHNOLOGY MANUAL (includes practical information about steam turbines maintenance, testing, and refurbishment - 500 pages)</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him;</p>
<ul>
<li>Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011.</li>
<li>Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003.</li>
<li>Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012.</li>
<li>Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999).</li>
<li>Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999).</li>
</ul>
<p>Furthermore, he has received the following awards:</p>
<ul>
<li>The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016</li>
<li>The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996).</li>
<li>The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East).</li>
<li>Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983).</li>
</ul>
<p>Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Steam Turbine Technology

Team of 10, pp

Normal Fee, pp

<h2>Microsoft Excel® in Depth: In-House Training</h2>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li> 
 <li>Create meaningful charts</li> 
 <li>Use pivot tables</li> 
 <li>Use Conditional Formatting, Data Validation</li> 
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li> 
 </ul><section>
                    <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


                </section>

Educators providing Courses in Glasgow

Courses matching "Validation"

Complete Visual BASIC

By Systems & Network Training

Advanced Python for network engineers

By Systems & Network Training

CWDP

By Systems & Network Training

Windows certificates for engineers

By Systems & Network Training

Writing and Managing Requirements Documents: In-House Training

By IIL Europe Ltd

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Web development fundamentals

By Systems & Network Training

HTML5 development fundamentals

By Systems & Network Training

Steam Turbine Technology

By EnergyEdge - Training for a Sustainable Energy Future

Microsoft Excel in Depth: In-House Training

By IIL Europe Ltd

Search By Location