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
Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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 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. 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? 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. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel 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
Face to Face training customised and bespoke. One to One Online or Face to Face
Revit face to face training customised and bespoke. Online or Face to Face
Managing Benefits™ Practitioner: In-House Training Managing Benefits™ provides generally applicable guidance encompassing benefits management principles, practices, and techniques. The purpose of the Practitioner-level qualification is to confirm whether you have achieved sufficient understanding of how to apply and tailor the Managing Benefits guidance and, specifically, the principles, practices, techniques, roles, and documentation in a scenario situation. A Practitioner candidate should, with suitable support, be able to plan, implement, sustain, and measure benefits management while adapting to different organizational environments. You should also be able to: Identify activities that should be undertaken during each of the practices of the Benefits Management Cycle, together with the accountabilities and responsibilities of each of the defined roles Evaluate examples of benefits management information (documents) Analyse the solutions adopted in relation to a given scenario This course will prepare you to take and pass the Practitioner exam, which is held on the afternoon of the second day. Using APMG-provided sample exam papers and additional project case studies, you will learn how to apply what you've learned during the Foundation course and how to approach the scenario-based Practitioner exam, which is aimed at testing your ability to apply Managing Benefits in an actual project environment (via simulated case study). What You Will Learn You'll learn how to: Plan for the implementation of benefits management Select appropriate strategies to sustain and measure progress Select and adapt principles, practices, and techniques to suit different organizational environments Identify activities that should be undertaken during each of the practices of the Benefits Management Cycle together with the accountabilities and responsibilities of each of the defined roles Evaluate examples of benefits management information (documents) Analyse the solutions adopted in relation to a given scenario Improve your ability to pass the APMG Managing Benefits Practitioner Certification exam Introductions Course structure Course goals and objectives Overview and Principles Review Managing Benefits Practices Managing Benefits Practitioner Exam Preparation Practitioner Exam Briefing Review of and practice with APMG sample questions and test papers Sample project case study scenarios to apply the concepts in practice and deepen the learning Sample Practitioner Exam Debrief Results from Sample Practitioner Exam APMG Managing Benefits Practitioner Exam
Managing Benefits™ Practitioner Managing Benefits™ provides generally applicable guidance encompassing benefits management principles, practices, and techniques. The purpose of the Practitioner-level qualification is to confirm whether you have achieved sufficient understanding of how to apply and tailor the Managing Benefits guidance and, specifically, the principles, practices, techniques, roles, and documentation in a scenario situation. A Practitioner candidate should, with suitable support, be able to plan, implement, sustain, and measure benefits management while adapting to different organizational environments. You should also be able to: Identify activities that should be undertaken during each of the practices of the Benefits Management Cycle, together with the accountabilities and responsibilities of each of the defined roles Evaluate examples of benefits management information (documents) Analyse the solutions adopted in relation to a given scenario This course will prepare you to take and pass the Practitioner exam, which is held on the afternoon of the second day. Using APMG-provided sample exam papers and additional project case studies, you will learn how to apply what you've learned during the Foundation course and how to approach the scenario-based Practitioner exam, which is aimed at testing your ability to apply Managing Benefits in an actual project environment (via simulated case study). What You Will Learn You'll learn how to: Plan for the implementation of benefits management Select appropriate strategies to sustain and measure progress Select and adapt principles, practices, and techniques to suit different organizational environments Identify activities that should be undertaken during each of the practices of the Benefits Management Cycle together with the accountabilities and responsibilities of each of the defined roles Evaluate examples of benefits management information (documents) Analyse the solutions adopted in relation to a given scenario Improve your ability to pass the APMG Managing Benefits Practitioner Certification exam Introductions Course structure Course goals and objectives Overview and Principles Review Managing Benefits Practices Managing Benefits Practitioner Exam Preparation Practitioner Exam Briefing Review of and practice with APMG sample questions and test papers Sample project case study scenarios to apply the concepts in practice and deepen the learning Sample Practitioner Exam Debrief Results from Sample Practitioner Exam APMG Managing Benefits Practitioner Exam
Oral Health Education is a very unique avenue of dentistry where we deal with influencing an individual’s dental behaviour, or on a broader scale, a whole community’s behavioural pattern, to keep the mouth free from disease. Oral Health Education course At London Waterloo Academy we look after you, we continually develop programmes to enhance your knowledge and skills as well as help guide you in your career pathway. Say ‘Ahh’ to a healthier smile with our professional, nationally recognised, fun and interactive oral health education course! Learn all the tips and tricks for maintaining a sparkling grin, from brushing and flossing techniques to the latest in dental technology. Say goodbye to boring lectures and hello to hands-on learning experiences. Enrol now and give your smile the attention it deserves! Oral Health Education is a very unique avenue of dentistry where we deal with influencing an individual’s dental behaviour, or on a broader scale, a whole community’s behavioural pattern, to keep the mouth free from disease. Oral health is of vital importance in maintaining one’s well being, hence becomes an essential component of overall health. Who is it for? Registered dental nurses who wish to further their knowledge and specialise in Oral Health Education, enabling them to take a more active role in the promotion of Oral Health. Aims In the context of lifelong learning for the dental care professional, the aims of this programme targets the provision of learning opportunities and invaluable experiences that will allow students to: Develop knowledge and the skill of the provision of oral health education Shape and form academic and practical skills in relation to promoting oral health Have first-hand experience and promote the role of oral health education in primary and secondary care environments Develop reflective skills to evaluate personal and professional growth Incorporate and deepen personal and professional development in one’s life. Provide OHE to patients at your practice, or even to groups of people There are other reasons why we encourage you to undertake the Oral Health Education programme, which include If you work within a Primary Health Care Trust you may be able to obtain a position as an Oral Health Educator which is one of the upcoming priorities of the NHS Trust Wider and better job prospects. i.e. Private or specialised dentistry Commitment to Continuous Professional Development (CPD) The Oral Health Education course will provide you with insight & skills associated in both becoming a tutor or a Dental Hygienist/therapist, and may prove to be a stepping stone into either of the courses Awarding body – National Examining Board for Dental Nurses (NEBDN) The Criteria for the Oral Health Education programme You are a qualified dental nurse (either National Certificate or NVQ level 3) Duration: 6 month Start Date: 16 September Classes: once a week Day – Monday classes Time – 6pm to 8:30pm Fees – £750 (we offer payment plan) Registration fee – £380 (NEBDN exam fee included) Location: The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk)) Call us +44 (0) 7484 014980 or email to info@waterlooacademy.co.uk or Facebook – London Waterloo Academy
PRINCE2® Practitioner Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach for project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is also used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefitting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guide to provide a robust project methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to take participants to the next level of understanding and application of the PRINCE2® methodology and to prepare them to sit the Practitioner exam. Using APMG provided sample exam papers and additional project case studies, participants will learn how to apply what they learned during the Foundation course and how to approach the OTE Practitioner exam, which is aimed at testing their ability to apply PRINCE2® in an actual project environment simulated via a case study provided as part of the exam. What you will Learn You'll learn how to: Tailor and apply the principles, themes, process structure, techniques, and management products of PRINCE2® within a work environment, via carefully selected case studies Define the PRINCE2® 6th Edition method at the Practitioner level Prepare for and take the Practitioner exam Getting Started Introductions Course structure Course goals and objectives Tailoring PRINCE2® Tailoring PRINCE2® Adopting PRINCE2® Tailoring PRINCE2® to suit different projects Adopting PRINCE2® in an organizational environment Controlled Start Recap management products Study business case and risk Study activities and responsibilities in: Starting up a project Initiating a project Controlled Progress Study management products and risk Study activities and responsibilities in: Getting work done Monitoring and reporting Issues and escalation Controlled Close Study Activities and Responsibilities in Closing a Project Activities and roles Roles and Responsibilities Principles Exercise Product-basedPlanning Producing a product breakdown structure (PBS) Producing a product flow diagram (PFD) Linking product breakdown structures and product flow diagrams to product descriptions
PRINCE2® Practitioner : In-House Training Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach for project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is also used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefitting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guide to provide a robust project methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to take participants to the next level of understanding and application of the PRINCE2® methodology and to prepare them to sit the Practitioner exam. Using APMG provided sample exam papers and additional project case studies, participants will learn how to apply what they learned during the Foundation course and how to approach the OTE Practitioner exam, which is aimed at testing their ability to apply PRINCE2® in an actual project environment simulated via a case study provided as part of the exam. What you will Learn You'll learn how to: Tailor and apply the principles, themes, process structure, techniques, and management products of PRINCE2® within a work environment, via carefully selected case studies Define the PRINCE2® 6th Edition method at the Practitioner level Prepare for and take the Practitioner exam Getting Started Introductions Course structure Course goals and objectives Tailoring PRINCE2® Tailoring PRINCE2® Adopting PRINCE2® Tailoring PRINCE2® to suit different projects Adopting PRINCE2® in an organizational environment Controlled Start Recap management products Study business case and risk Study activities and responsibilities in: Starting up a project Initiating a project Controlled Progress Study management products and risk Study activities and responsibilities in: Getting work done Monitoring and reporting Issues and escalation Controlled Close Study Activities and Responsibilities in Closing a Project Activities and roles Roles and Responsibilities Principles Exercise Product-basedPlanning Producing a product breakdown structure (PBS) Producing a product flow diagram (PFD) Linking product breakdown structures and product flow diagrams to product descriptions
RESILIA™ Foundation: In-House Training AXELOS RESILIA™: Cyber Resilience Best Practice is designed to help commercial and government organizations around the world prevent, detect, and correct any impact cyber attacks will have on the information required to do business. Adding RESILIA to the existing AXELOS global best practice portfolio, including ITIL® and PRINCE2®, brings a common cyber resilience best practice for security, IT service management, and business. Active cyber resilience is achieved through people, process, and technology. The RESILIA™ Foundation course starts with the purpose, key terms, the distinction between resilience and security, and the benefits of implementing cyber resilience. It introduces risk management and the key activities needed to address risks and opportunities. Further, it explains the relevance of common management standards and best practice frameworks to achieve cyber resilience. Subsequently, it identifies the cyber resilience processes, the associated control objectives, interactions, and activities that should be aligned with corresponding ITSM activities. In the final part of the course, it describes the segregation of duties and dual controls related to cyber resilience roles and responsibilities. What you will Learn At the end of this course, you will be able to: Demonstrate your knowledge of the purpose, benefits, and key terms of cyber resilience Demonstrate your knowledge of the risk management and the key activities needed to address risks and opportunities Demonstrate your knowledge of the purpose of a management system and how best practices and standards can contribute Demonstrate your knowledge of the cyber resilience strategy, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience design, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience transition, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience operation, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience continual improvement, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of the purpose and benefits of segregation of duties and dual controls Course Introduction Course Learning Objectives Course Agenda Activities Course Book Structure RESILIA Certification Introduction to Cyber Resilience What is Cyber Resilience? Defining Cyber Resilience Balancing in Cyber Resilience Characteristics of Cyber Resilience Risk Management Understanding Risk Management: Discussion Defining Risk Management Addressing Risks and Opportunities Managing Cyber Resilience Why and What of Management Systems? Management Systems Common Management Standards and Frameworks Cyber Resilience Strategy What is Strategy? Cyber Resilience Strategy and Activities Security Controls at Cyber Resilience Strategy Interaction Between ITSM Processes and Cyber Resilience Cyber Resilience Design Why Cyber Resilience Design? Cyber Resilience Design Activities Security Controls at Cyber Resilience Design Aligning ITSM Processes with Cyber Resilience Processes Cyber Resilience Transition Why Cyber Resilience Transition? Basics of Cyber Resilience Transition Cyber Resilience Transition: Controls Interaction Between ITSM Processes and Cyber Resilience Cyber Resilience Operation The Purpose of Cyber Resilience Operation Security Controls in Cyber Resilience Operation Interaction Between IT Processes and Cyber Resilience Interaction Between ITSM Functions and Cyber Resilience Cyber Resilience Continual Improvement Continual or Continuous Improvement Maturity Models Continual Improvement Controls The Seven-Step Improvement Process The ITIL CSI Approach Cyber Resilience Roles & Responsibilities Segregating Duties Dual Controls