Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge
This is an accredited course with the International practitioners of Holistic medicine for women personally or professionally to transform their life. Relax, be calm, you've got this!
Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.
About this Training Course A few decades ago, the purchasing function in an Oil & Gas company was seen only as a procurement function in charge of supplying goods and services defined by the end user. Over the years, the purchasing function has won its letters of nobility and has proven to be a powerful leverage of savings and cost reduction. In the upstream Oil & Gas sector, where production sites are spread everywhere and sometimes in very isolated areas, purchasing & procurement performs an important mission to secure the supply of high-tech equipment which will travel all over the world before being installed offshore or in remote areas. These two objectives, cost saving and securing of supply, make the purchasing & procurement a strategic function and an essential segment of the supply chain as it drives the other steps in the chain. Training Objectives By the end of the course, the participants will feel confident in their understanding of: The supply chain functions in the upstream Oil & Gas industry and its objectives. The purchasing process from the identification of a need to its satisfaction within the specifications, planning and budget. The strategic tools of the buyer: The category management and market analysis, the definition of the frame agreement and contracts. The creation of value for their organization by using the leverages of the purchasing process from the selection of supplier, the cost analysis and the negotiation. Target Audience This course is primarily designed for purchasers or head of purchasing/procurement. It is also necessary for other stake holders in the supply chain, including expediters, stock controllers and cost controllers. This course is also recommended for the participants in the logistics function who want to enlarge their knowledge domain of the supply chain. Finally, the supply chain administrators from the technical departments may also find this course necessary in order to facilitate their interaction with the purchasing department. Course Level Basic or Foundation Trainer Your expert course leader has 25 years of experience in management positions in Contracting, Procurement and Logistics, mainly in the Oil & Gas Industry. He was a Lecturer for IFP Training for 5 years. During his Oil & Gas industry experience, he has worked on major Oil and Gas development projects like the Yadana project in Myanmar, Akpo project in Nigeria and YLNG in Yemen. His international experience allows him to adapt very easily and integrate the multicultural specificities of the Oil & Gas industry in his teaching. 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
Local authorities are being encouraged to seek the views of young people in relation to the services they receive. Schools and the whole range of support services (e.g. behaviour support, youth offending teams, social services, CAMHS etc.) are being expected to routinely ask young people for their views. This goes beyond involving young people in plans that concern them e.g care plans, individual education plans, pastoral support plans etc. Online Course now available via Teachable Platform – Ask the Children Learn at your own pace… lots of text and video support Course Category Peer Support Description Local authorities are being encouraged to seek the views of young people in relation to the services they receive. Schools and the whole range of support services (e.g. behaviour support, youth offending teams, social services, CAMHS etc.) are being expected to routinely ask young people for their views. This goes beyond involving young people in plans that concern them e.g care plans, individual education plans, pastoral support plans etc. This training will focus on how young people can be effectively engaged in giving their views and will present a model for use in evaluating services to young people based on the concept of resilience. This model enables young people to be clear about what has helped and hindered them in being able to overcome difficulties. It also provides a framework for evaluating the extent to which services are reducing risk and increasing protective factors to enable young people to develop the resilience. Testimonials ‘Yet again inspiring and opening more doors than I can go through’? ‘This opened a lot of avenues for thought and reflection. It will help me to help colleagues to see where they can improve practice to create a more inclusive environment within the whole school.’ ‘Some great ideas and restored my self belief! Fantastic’ Learning Objectives Strategies for engaging young people Knowledge and Understanding of resilience In relation to system and environmental factors Strategies for reducing risk and increasing protective factors In relation to Individual young people and services Evaluation framework for services to young people Who Is It For ? Youth offending teams Social services CAMHS Primary and secondary teachers Heads and Deputies SENCOs Learning Support and Guidance staff Advanced Skills Teachers Parents Local Authority Support Services Community Development workers Early Years and School based Practitioners Social work staff Health Services Course Content The course answers the questions : How can we truly involve pupils? Practically how do we go about listening to pupils views? What if we do not like what they tell us? How can we involve our most disaffected young people? Key themes Tools for engaging young people and gaining their views The concept of resilience System and environmental risk and protective factors that impact on young people’s resilience Reducing risk and Increasing protective factors Resilience planning for Individuals and services Evaluating services to young people If you liked this course you may well like: CIRCLES OF FRIENDS
Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included
Dive into the world of purchasing and procurement in the upstream oil & gas sector with EnergyEdge's specialized classroom training program.
Enhance your knowledge with EnergyEdge's course on Floating Liquefied Natural Gas (FLNG) design technology. Sign up now!
Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - ACER ' 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included
Agile is not what you do, Agile is what you become! An introduction to the essentials of Agile Scrum as a delivery method. The same learning objectives as used in central government & public sector digital delivery projects. Agile is not what you do, Agile is what you become! Since 2012, all government departments have been required to use the Agile approach to project management, to build and run new digital services. As you begin your Agile journey, one of your first challenges will be understanding the rules and roles that support Agile delivery, some of the most frequently asked questions are "Which Agile framework is applicable to our business operating model?" or, "Is the Project Manager role equivalent to that of theProduct Owner?" and, "What does a Scrum Master do?" A strong corporate culture not accustomed to the Agile mindset can also be a difficult environment in which to implement Agile methods. In some cases, the company’s culture and practices may reward non-Agile milestones while inadvertently discouraging Agile success. This intensive two-day training course combines PowerPoint presentations, informal discussions and practical exercises to introduce you to Agile Scrum as a Delivery Method, without the impending pressure of having to pass a formal certification examination. Previous experience of Agile delivery is not a pre-requisite to attending this course, although it is assumed delegates have previously attended the Primer course, or have some understanding of Agile Scrum terms and practices. This course, designed by Agile Scrum practitioners and coaches with specialist experience of working on GDS (Government Digital Service) Service Standards compliant government and public sector projects has been accredited by The CPD Certification Service and is now available outside its usual central government and public sector digital delivery setting. Who this course is for Service and Programme Managers If you are a Service Manager or Programm Manager who wants to explore the benefits of transitioning to Agile ways of working and want to understand how your existing business processes and resource landscape will fit into an Agile delivery model, then this course aims to provide you with enough information to enable you to make an informed decision. Career ambitions If you are new to Agile and your intention is to pursue a career either as an Agile Scrum Master or Agile Product Owner, you will hopefully be provided with enough knowledge to enable you to determine which role best suits your Agile career ambitions. Frequently Asked Questions How this course differs from other Agile courses Delegates will learn the 'How', not just the 'What'! This course has been designed by highly experienced Agile practitioners and coaches with specialist real-life experience of working on GDS (Government Digital Service) Service Design Standard projects. Delegates will find that the learning objectives are significantly more detailed than with other Agile courses which only focus on teaching the learning objectives of The Scrum Guide. Delegates must take the certification assessment. No! During enrolment, delegates can opt out of taking the C-ASDM certification assessment. The online Agile Scrum as a Delivery Method – Essentials course quiz is optional Absolutely! Delegates are provided access to the online Agile knowledge quiz which accompanies the Agile Scrum as a Delivery Method – Essentials course. The quiz helps delegates gauge their level of attainment but is entirely optional. Delegates can take the certification assessment without enrolling on the course. Yes! Delegates with existing Agile project delivery experience can choose to take the certification assessment without enrolling on the course. I will receive my certificate as soon as I have completed the course You will initially receive an Assessment Completion report after completing the assessment. The report details the certification status: 'Pass' or 'Fail', and includes information on which questions were answered incorrectly. Your certificate is issued by the CPD Certification Service approximately four-to six-weeks after successfully completing and passing the C-ASDM Certification Assessment. A CPD certification is recognised by employers Yes! CPD certification is recognised by private and public sector employers, and in central government departments as a valuable way to evaluate the skills of an individual, and the quality of the learning activities. Listing your CPD certification as well as the number of CPD Points you have achieved on your CV is essentially showcasing your achievements in continuing your professional development. One CPD Point is equivalent to an hour of training CPD points are units that quantify time, and the quality of learning and development activities. Delegates will earn 3 CPD Points upon successful completion of the C-ASDM Certification Assessment or 13 CPD Points after completing the two-day course. My CPD certificate will expire after three years Your certificate will not expire however, best practice suggests a renewal after three years. You can do this by enrolling on the C-ASDM course to ensure your knowledge of Agile as a Delivery Method is up to date. Service features Two-day Agile Scrum training course The course uses eCommerce and other Business Case examples for context Optional online CPD certification assessment Optional Agile knowledge quiz to help delegates gauge level of attainment Online Retrospective feedback to enable continuous course improvements. Service benefits Delegates will understand the concepts and benefits of Agile Scrum development Scrum team roles and role accountabilities INVEST-compliant User Stories and BDD formatted Acceptance Criteria Agile approach to incremental project delivery Agile artefacts and Agile reports (burn-down & burn-up charts) Agile Events & Scrum rules Comparison: Agile methodologies (Lean, XP, SAFe & Scrum) Use of Kanban for workflow management Government Digital Service (GDS) Service Standards and Service Assessment Be able to communicate the ideals of Agile to stakeholders Service Agenda General knowledge Agile Delivery 101 Scrum process and sprints Applicability of Scrum Agile Manifesto Scrum roles and accountabilities Overview of Scrum roles (Core & Ancillary) Scrum Master role and role responsibilities Scrum Product Owner role and role responsibilities Scrum team Scrum events Sprint Planning Daily Scrums Sprint Reviews Sprint Retrospectives Scrum artefacts Product Backlog Sprint Backlog Increments Scrum Reports Burn-down and Burn-up Charts Scaling Scrum Working with multiple Scrum teams Working with distributed Scrum teams GDS (Government Digital Service) Service Standards Service Assessments Risks and challenges Risks and challenges of transitioning to Agile delivery Frequently asked questions Discussion on frequently asked Agile questions Agile knowledge quiz Examples of the multiple-choice questions in the optional online quiz On-going support Email support No Telephone support No Webchat support No Online support No Community Support Yes! Delegates are offered access to our private online 'Community of Agile Scrum Practitioners'. Delegates who achieve the pass mark for CPD certification are additionally offered access to our private 'Certified Scrum Practitioners’ Guild', a private Slack community of like-minded Agile professionals.