3374 Management courses in Linlithgow delivered Live Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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 classroom, one to one, tailored and bespoke courses. Tailored In company training: 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

Health and safety awareness training is mandatory for staff at all levels of an organisation. This is the ideal course to satisfy that requirement - a stimulating 'entry-level' programme explaining how health and safety should be managed in any working environment. The course outlines the basics of health and safety law and how organisations and individuals can become liable for health and safety offences. Roles and responsibilities for health and safety are discussed by reference to the key legislation and the expert trainer will explore with the delegates how these responsibilities are managed in practice in different types of organisation. The principles of risk assessment will be considered and their practical implementation discussed in relation to the management of the various hazards that are likely to be present in a typical workplace. This course will give staff: An understanding of health and safety law, liability and enforcement An explanation of the principles of health and safety management in the workplace and an understanding of who should be responsible for different aspects of health and safety A practical explanation of risk assessment and what constitutes a suitable and sufficient assessment A broad knowledge of the typical hazards in a workplace and how these should be managed 1 Overview of health and safety law Statute and civil law Liability and enforcement Statutory duties Contract law 2 Legislative framework The workplace - extent of responsibility / shared responsibility Relevant legislation 3 Management of Health and Safety Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Workplace (Health, Safety and Welfare) Regulations 1992 Accident Reporting (RIDDOR) Consultation with Employees and Safety Committees 4 Risk management within your organisation Business risk management Health and safety risk management The principles of risk assessment Transferring the risk to contractors and third parties 5 Risk assessment exercise - 'Challenge Anneka' 6 Managing the hazards in the workplace Work equipment Lifting equipment Display screens Manual handling Fire Chemicals (COSHH) Personal protective equipment (PPE) 7 Practical exercise - Workplace inspection 8 Questions, discussion and review

On this webinar, we will discuss strategies that can assist managers in overcoming various challenges critical for inspiring and motivating teams to achieve extraordinary results. We’ll kick off by addressing the transition into a management role, emphasizing the art of delegating tasks and harnessing team capabilities effectively. Key areas such as delegation techniques, time management, and methods to motivate remote teams will be thoroughly discussed. We will begin by addressing the transition to a management role, which entails delegating tasks from one’s previous job to focus more on leveraging team skills. Topics covered will include effective delegation, time management, and strategies for motivating remote teams. Additionally, we will delve into the importance of staff feedback and how to leverage it to enhance your leadership style and clarify your sense of purpose. If you’re new to management and eager to acquire practical tips on cultivating impactful leadership skills, this webinar is tailored for you.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for anyone who is responsible for day-to-day management of many FortiGate devices via the FortiManager platform. Overview Describe capabilities of FortiManager Add FortiGate devices to Device Manager and import their running configuration Use provisioning templates and scripts for device-level changes across many devices Identify the synchronization states Manage the revision history of managed devices Offer a local FortiGuard Distribution Server to your Fortinet devices Deploy administrative domains (ADOMs) to support multiple customers on a single FortiManager Manage firewall policies across multiple FortiGate devices using policy packages with shared and dynamic objects Deploy policies and objects from the global ADOM to multiple ADOMs Explain high availability, backup, and recovery options for FortiManager Compare methods for centrally managing IPsec VPNs Explain the restricted ''admin'' profile and API high-level usage Use workspaces and workflow mode Identify steps to replace a managed FortiGate device Manage FortiGate devices' firmware centrally In this 2-day class, you will learn the fundamentals of using FortiManager for centralized network administration of many FortiGate devices. Example use cases include large enterprise and carrier networks. Course Outline Module1 - Introduction and Initial Configuration Module2 - Administration and Management Module3 - Device Registration Module4 - Device Level Configuration and Installation Module5 - Policy and Objects Module6 - Manager Panes Module7 - Diagnostics and Troubleshooting Module8 - Advanced Configuration Additional course details: Nexus Humans FortiManager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the FortiManager course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.

Duration 5 Days 30 CPD hours This course is intended for Administrators, implementers and managers who are responsible for implementing, configuring and administering Service Manager 9.30. Overview At the end of the course, you will be able to:? Describe Service Manager environment andarchitecture? Install the various components of Service Manager? Learn the various implementation options (i.e.default ports, load balancing, components)? Perform tasks and set-up activities that are generallyperformed prior to moving the system to Production.? Perform daily administrative tasks such asperforming backups and monitoring log files,background processor activity, email activity, andschedule record activity.? Perform weekly administrative tasks such asarchiving and purging data? Perform monthly administrative tasks such ascleaning up the audit record, monitoring serverperformance statistics? Perform quarterly and annual administrative taskssuch as regenerating the work and holiday schedulerecords.? Additional administrative tasks, such as importing orexporting records.RECOMMENDED This class is targeted at system administrators responsible for the day to day management of the Service Manager application. The course focuses on the daily, weekly, monthly, quarterly, and annual tasks required to keep the system running efficiently. This class is targeted at system administrators responsible for the day to day management of the Service Manager application. The course focuses on the daily, weekly, monthly, quarterly, and annual tasks required to keep the system running efficiently. Additional course details: Nexus Humans SM320 - Service Manager 9.x Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SM320 - Service Manager 9.x Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for Participants interested in a general overview of SAP ERP Financials; Project team members in the organization and design phase of an SAP ERP Financials implementation In this course, students will identify the areas of the SAP ERP Financials solution, describe the capabilities of the SAP ERP Financials solution using business processes, & apply the SAP NetWeaver Business Client (NWBC) in the SAP ERP Financials solution. Course Outline SAP ERP Financials - Introduction & Overview Positioning SAP ERP Financials Business processes (and their integration) in the SAP ERP Financials solution Financial Accounting: General Ledger Accounting Financial Accounting: Accounts Payable Management Accounting: Internal Order Financial Accounting: Asset Accounting Financial Accounting: Accounts Receivable Improving the End-To-End Process of Receivables Management

Duration 2 Days 12 CPD hours This course is intended for Agile professionals, Project Managers and aspiring Project Managers who want to be able to combine PRINCE2 and Agile in the most effective way when using PRINCE2, Agile behaviours, concepts, frameworks, and techniques Other key delivery team staff, including Product Owners, Scrum Masters, and Developers Business professionals with an interest in iterative and incremental project delivery by collaborating working Overview At the end of this course, you will be able to: Understand the key concepts relating to PRINCE2. Understand the key concepts relating to projects and PRINCE2 Agile. Understand how PRINCE2 principles, themes, processes and management products are tailored and applied in an Agile context. Understand the agile ways of working, key terms and techniques. Understand the focus areas in an Agile context. PRINCE2 Agile is the world?s most complete project management solution, combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2©. As a PRINCE2© Accredited Training Organization of PeopleCert, all students attending this training will be provided with the exam voucher as a part of delivery. Course Outline Course Introduction and Agile Overview PRINCE2 Summary Culture Blending PRINCE2 and Agile Combining PRINCE2 and Agileÿ Combining PRINCE2 and Agile (Contd.) Homework Day 1ÿ PRINCE2 Agile Themes PRINCE2 Agile Processes Agile frameworks, Concepts, and Techniques Agile Focus Areas Mock Exam PRINCE2© is a registered trademark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved. Additional course details:Notes New Horizons is an Authorised Training Organisation (ATO) for Peoplecert for ITIL4 and PRINCE2 Nexus Humans PRINCE2 Agile Foundation with Exam training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the PRINCE2 Agile Foundation with Exam course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Accredited through APMG International, certified in the UK by the National Cyber Security Centre (NCSC) and listed as qualified cyber training by Department of Homeland Security Cybersecurity and Infrastructure Security Agency (DHS CISA) in the USA, the NIST Cyber Security Professional (NCSP®) training program teaches individuals and organizations how to engineer, operationalize, and continually improve a NIST Cybersecurity Framework program. This introductory level, non-examinable NCSP® Digital Business Risk Awareness Certificate course takes learners on a journey to understand how the ever-changing cyber threat landscape impacts an organization's ability to secure the value of its digital business services. The course will allow participants to apply what they learn in a real-world environment.

Gain insights into how to master the dynamics of the opposite colour energies and see the dynamics within your team shift towards healthy relationships. Watch as your bottom line improves as suddenly more is getting done in a smarter way.