306 Mac courses in Esher

MICROBLADING HAS BECOME ONE OF THE MOST POPULAR TREATMENTS IN RECENT YEARS, BUT RESULTS ARE LIMITED TO HAIRSTROKE BROWS AND FREQUENTLY CLIENTS WILL REQUEST SOME SHADING WHICH IS MORE EASILY ACHIEVED WITH DIGITAL PERMANENT MAKEUP.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & 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. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Introduction to Virtualization course description A comprehensive tour of virtualization. The course concentrates on the actual technologies involved as opposed to any one vendor solution. What will you learn Explain the concepts of virtualization. Partition servers. Create Virtual Machines. Introduction to Virtualization course details Who will benefit: Anyone looking for an introduction to Virtualization. Prerequisites: None. Duration 2 days Introduction to Virtualization course contents Virtualization Concepts What is Virtualisation? What are virtual machines (VMs)? Virtualisation Landscape. Network Virtualisation. Suitability for Organisations. Advantages of deploying Virtualisation. Downsides of deploying Virtualisation. Overview of Virtualisation products. Hypervisors What is a hypervisor? Difference between type 1 and 2 hypervisors. Available hypervisors. Hypervisors and device drivers. Hands on: Installing Oracle VirtualBox on Windows. Creating/Importing/Configuring VMs. Virtualization Hosts Hardware and resource requirements. Installation of the hypervisor. Hands on: Installing Hyper-V role into Windows Server. Creating/Importing/Configuring VMs. Virtual Machines Creating virtual machines. Resource requirements. Settings. Installation of the guest OS. Additional tools/ extensions for hypervisor integration. VM files and their uses. Virtual hard disk and their formats. Hardware pass through. Hands on: Connecting to VMWare ESXi via WebGUI and using ESXi to create/import/configure VMs. VM Snapshots/Checkpoints What is a snapshot? How to use them and how they impact performance? Creating/deleting/merging of snapshots. Hands on: Using ESXi to create/manage snapshots. Command Line use on the Hypervisor Interacting with the hypervisor through the command line. Simple commands to configure the hypervisor and VMs. Simple scripts. Hands on: Connecting to VMWare ESXi via PowerCLI to manipulate VMs and snaphshots. Virtualization Storage Different types of storage: local vs remote. Local and remote storage technologies. Configuring storage. Hands on: Using ESXi to deploy VMs on remote NFS storage. Virtual Networking How is networking done in virtualization environments. What is a virtual switch and vNIC and what are their performance characteristics? NIC teaming and trunking in the virtual world. Port groups and isolation. Physical NICs and their use in virtual switches. Hands on: Using ESXi to create and configure vswitches and networking. Templates and clones What is a template? What is a clone? When to use templates and clones to optimize VM deployment. Migrating/Importing VMs What is migration? Migrating compute and storage. Importing VMs from files or physical machines. Hands on: Using VMWare vCenter Server to clone/ template/migrate VMs, tag resources, create local user accounts and assign permissions. VMs and Backups Taking backups of your VMs. Restoring your VMs from backups. Virtualization and Licensing Different licensing models and costs. Containerization Concepts What is a container and how is it different from a virtual machine. When to use containers. Docker and Kubernetes

SCALP MICROPIGMENTATION (SMP) IS BECOMING ONE OF THE MOST SOUGHT-AFTER TREATMENTS IN THE HAIR LOSS INDUSTRY AND IS THE FASTEST GROWING SECTOR OF THE PERMANENT MAKEUP INDUSTRY.

Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.

About this Training Course This intermediate to advanced level 3 full-day training course has been designed to provide participants with a detailed and up-to-date overview of the fluid mechanic fundamentals and operating practice of pumps, compressors and gas and steam turbines. Upon the successful completion of this course, participants will have acquired the practical knowledge to enable them not only to choose the correct device for a particular application but also be in a position to resolve many commonly occurring operating problems. Troubleshooting is an important part of this course and will cover the important topics of Machinery Root Cause Failure Analysis (RCFA) together with Vibration Analysis. This course is ideal for those personnel in the oil, gas, petrochemical, chemical, power and other process industries who require a wider and deeper appreciation of pumps, compressors and turbines, including their design, performance and operation. The participants will be taken through an intensive primer of turbo-machinery principles, using the minimum of mathematics, and will learn how to solve the many and varied practical industrial problems that are encountered. The course makes use of an extensive collection of VIDEO material together with case studies and numerical exercises. Training Objectives Upon the successful completion of this course, each participant will be able to: Apply a comprehensive knowledge of pumps, compressors & turbines and troubleshoot rotating equipment in a professional manner Identify the different types of turbomachinery including basic design aspects and highlighted problem areas Minimise compressor work by understanding the processes involved and identifying their efficiency Understand the flow through turbomachines and the corresponding velocity triangles including torque and power calculations Analyse the different types of centrifugal machines including their design, installation, operation, maintenance, re-rate/retrofit, troubleshooting and control Recognise the various beneficial design aspects of turbomachines and understand the crucial process of cavitation Carry out proper methods of device installation, operation, maintenance and troubleshooting Understand and apply the powerful methods of Machinery Root Cause Failure Analysis Understand the various methods of vibration analysis applied to device diagnostics Target Audience This course provides an overview of all significant aspects and considerations of pumps, compressors and turbines for those who are involved in the design, selection, maintenance or troubleshooting of such equipment. This includes maintenance, reliability, integrity, engineering, production and operations managers, engineers and other technical staff. Course Level Intermediate Advanced Trainer Your expert course leader is a Senior Mechanical & Instrumentation Engineer (UK, B. Sc., M.Eng., Ph D) with over 45 years of industrial experience in Process Control & Instrumentation, Pumps, Compressors, Turbines and Control Valve Technology. He is currently a Senior Independent Consultant to various petrochemical industries in the UK, USA, Oman, Kuwait and KSA where he provides consultancy services on both the application and operational constraints of process equipment in the oil & gas industries. During his early career, he held key positions in Rolls Royce (UK) where he was involved in the design of turbine blading for jet engines, subject to pre-specified distributions of pressure. During this period and since, he has also been closely involved in various aspects of Turbomachinery, Thermodynamics and Fluid Mechanics where he has become a recognised authority in these areas. Later, he joined the academic staff of University of Liverpool in the UK as a Professor in Mechanical Engineering Courses. A substantial part of his work has been concerned with detailed aspects of Flowmetering - both of single & multiphase flows. He has supervised doctoral research students in this area in collaboration with various European flowmeter manufacturers. He joined Haward Technology Middle East in 2002 and was later appointed as European Manager (a post which has since lapsed) and has delivered over 150 training courses in Flowmeasurement (single- and multi-phase), Control, Heat Exchangers, Pumps, Turbines, Compressors, Valve and Valve Selection as well as other topics throughout the UK, USA, Oman and Kuwait. During the last two years, he has delivered courses with other training companies operating in the Far and Middle East. He has published about 150 papers in various Engineering Journals and International Conferences and has contributed to textbooks on the topics listed above. POST TRAINING COACHING SUPPORT (OPTIONAL) 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. Request for further information post training support and fees applicable Accreditions And Affliations

NFV training course description Network Functions Virtualization (NFV) brings many benefits, this training course cuts through the hype and looks at the technology, architecture and products available for NFV. What will you learn Explain how NFV works. Describe the architecture of NFV. Explain the relationship between NFV and SDN. Recognise the impact NFV will have on existing networks. NFV training course details Who will benefit: Anyone wishing to know more about NFV. Prerequisites: Introduction to Virtualization. Duration 2 days NFV training course content Introduction What is NfV? What are network Functions? NfV benefits, NfV market drivers. ETSI NfV framework. Virtualization review Server, storage and network virtualization and NfV. Virtual machines, containers and docker. Data centres, clouds, SaaS, IaaS, PaaS. Virtualization of Network Functions Network virtualization versus Network Function virtualization. ETSI NfV architecture ETSI documents, Architecture overview, compute domain, hypervisor domain, infrastructure network domain. IETF and NfV Creating services, Service Functions, Service Function Chaining. SPRING and source packet routing. YANG and NetConf. RESTCONF. VLANs, VPNs, VXLAN. MANO Management and Orchestration. OpenStack, OpenDaylight PaaS and NfV. The VNF domain. Service graphs, MANO descriptors, Open orchestration. The virtualization layer VM centric model, containers versus hypervisors, FD.io. Summary Deploying NfV, performance, testing. Futures.

Intro to containers training course description This course looks at the technologies of containers and microservices. The course starts with a look at what containers are, moving onto working with containers. Networking containers and container orchestration is then studied. The course finishes with monitoring containers with Prometheus and other systems. Hands on sessions are used to reinforce the theory rather than teach specific products, although Docker and Kubernetes are used. What will you learn Use containers. Build containers. Orchestrate containers. Evaluate container technologies. Intro to containers training course details Who will benefit: Those wishing to work with containers. Prerequisites: Introduction to virtualization. Duration 2 days Intro to containers training course contents What are containers? Virtualization, VMs, What are containers? What are microservices? Machine containers, application containers. Benefits. Container runtime tools Docker, LXC, Windows containers. Architecture, components. Hands on Installing Docker client and server. Working with containers Docker workflow, Docker images, Docker containers, Dockerfile, Building, running, storing images. Creating containers. Starting, stopping and controlling containers. Public repositories, private registries. Hands on Exploring containers. Microservices What are microservices? Modular architecture, IPC. Hands on Persistence and containers. Networking containers Linking, no networking, host, bridge. The container Network Interface. Hands on Container networking Container orchestration engines Docker swarm: Nodes, services, tasks. Apache Mesos: Mesos master, agents, frameworks. Kubernetes: Kubectl, master node, worker nodes. Openstack: Architecture, containers in OpenStack. Amazon ECS: Architecture, how it works. Hands on Setup and access a Kubernetes cluster. Managing containers Monitoring, logging, collecting metrics, cluster monitoring tools: Heapster. Hands on Using Prometheus with Kubernetes.

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

About this Training Course One of the main challenges for today's managers is effectively leading and successfully communicating vision that inspires employees to perform. Good leadership engages people and employees who feel both engaged and enabled contribute to higher levels of growth and productivity. They will remain longer with the organisation, perform better and ultimately deliver better service to your customers. This popular 3 full-day course will equip you with key skills that you can utilise to maximise your staff's performance in line with the company's objectives. This interactive course will also empower you with strategic approaches to overcome the people challenges that you may encounter while enabling you to optimise your business strategies successfully. An ILM Recognised programme. Training Objectives What are the benefits that you will gain from attending this course? * Enhance your personal effectiveness and decision-making * Learn how to boost your influencing capability * Inspire enthusiasm, motivation and commitment * Communicate effectively across a multi-cultural team * Nurture your relationships and strengthen your team * Develop an empowering partnership team culture Target Audience Who should attend this course? Anyone involved in leading a business unit or a project team can attend. It covers relationships with host governments, contractors, suppliers and local communities which constitute critical alliances for the development of a project. This course is essential for team leaders, supervisors or managers from the following functions: Project management engineers from various technical disciplines Ad-hoc or special project team leaders in legal, technical & financial disciplines Country managers or business development officers of contractors JV management executives or officers Government officials or industry liaison officers Procurement or contracts executives or officers   Trainer Your course leader is the author of Spirit IntelligenceTM and specialises in executive leadership facilitation and management development. He gained a first class honours degree in chemical engineering from Edinburgh University in Scotland and has undertaken postgraduate studies in psychology at Macquarie University in Sydney, Australia. Your course leader's corporate career spanned 14 years in Oil and Gas with BP, Amoco and AGL. Since 1993, he has worked across five continents with more than 170 clients including Rothschild, QBE, AT&T, Intel, Towers Perrin, Thomas Cook, Fujitsu, Nortel, Frank Russell, Electrolux, Arab Bank, Cable and Wireless, GSK, Merck, Sharpe and Dome, World Vision, Ericsson, IBM, Placer Dome Gold, Jim Beam, Ernst & Young and Commonwealth Bank of Australia. He focuses on what he calls tapping The Hidden Advantage to unleash the power of the whole person - the power of the body and mind, the passion of the emotions and the enthusiasm, motivation, commitment, initiative, creativity, resilience and persistence of the spirit in business. He is very experienced internationally in both skills enhancement and the strategic facilitation of tough and intractable client challenges. His approach is pragmatic. He provides his clients with a powerful range of practical tools and approaches to enable management to tap The Hidden Advantage latent in their staff and achieve optimum performance and results. A powerful and compelling speaker, he combines humour, energy and passion. He draws on a wealth of personal experience and thorough research. POST TRAINING COACHING SUPPORT (OPTIONAL) 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. Request for further information post training support and fees applicable Accreditions And Affliations