59724 Courses

Practical Excel training that will turn you into a certified Excel master About course Become a master of Excel Learn how to use the crucial Excel functions and tools. Learn from the experts The course is conducted by an Excel specialist with many years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you want to master Excel quickly and efficiently? We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas. Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period. You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic. On top of everything, after completion of the course, you will receive certificate confirming your skills. Join the Excel course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Lewis Hardin Excel expert The Excel course is conducted by an MS Excel expert and trainer. He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program. Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way. Overview of the course: The Excel course program: I. Module 1 – Editing Basic issues Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts. Editing and formatting Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit. Graphic and special elements Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments. II. Module 2 – Analysis and modeling Create charts and tables Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts. Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts. Filters (Slicer and Timeline): PivotTables and Plain Tables. Use formulas Rules for working on formulas. Review and application of formulas. Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking. Working on data (databases) Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis). III. Module 3 – Review, view and print Review and data protection Checking: spelling; thesaurus; workbook statistics. Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink. View, printing and formats View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros. Printing: print area; page settings; margin settings; sheet adjustment. File formats and saving. IV. Module 4 – Advanced issues Advanced features Work with other apps Tools and plugins for professionals V. Tests Tests and repetitions of acquired knowledge The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training. Final test After completing the final test at the end of the Excel course, you will get certified. VI. Tasks Practical tasks and exercises Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level. VII. Bonus materials for the course Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more. Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert 

Overview Explore the fascinating connection between humans and plants with our comprehensive Ethnobotany Course. This course is designed to help the learners understand how human societies and cultures have captivated the power of nature. The course will help you understand the concepts of ethnobotany. Here, you will learn about the relationship between our societies and plants. The course will provide you with a detailed understanding of ethnological research methods. In addition, you will be able to explore the traditional uses of places. Along with that, the course will educate you on biodiversity conservation and sustainability. You will also get a clear view of the future of ethnobotany. Join now! Course Preview Learning Outcomes Understand the definition and concepts of ethnobotany Learn about the connection between plants and human society Enhance your understanding of ethnobotanical research methods Deepen your understanding of traditional plant uses Learn about biodiversity conservation and sustainability Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Ethnobotany research Biodiversity conservation Who Should Take This Ethnobotany Course ? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Ethnobotany Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Ethnobotany Course will equip you with effective skills and abilities and help you explore career paths such as  Ethnobotanist Agriculture Officer Community Development Specialist Researcher Module 01: Introduction to Ethnobotany Introduction to Ethnobotany 00:17:00 Module 02: Plants and Human Societies Plants and Human Societies 00:18:00 Module 03: Botanical Foundations Botanical Foundations 00:19:00 Module 04: Ethnobotanical Research Methods Ethnobotanical Research Methods 00:16:00 Module 05: Traditional Plant Uses Traditional Plant Uses 00:17:00 Module 06: Biodiversity Conservation and Sustainability Biodiversity Conservation and Sustainability 00:18:00 Module 07: Future Horizons in Ethnobotany Future Horizons in Ethnobotany 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

https://www.internationalcollegeofprofessionalcelebrants.org/residential-celebrant-training Celebrant training

About this Course Batteries are going to play an increasingly important role in the energy grid. An increasing number of developers are looking to add battery storage systems (BESS) into their existing projects. However future cash flows are highly uncertain and they are often unsure exactly how battery technology can be monetised. A strong revenue model requires stacking of different revenue sources. As the share of variable renewable sources in electricity systems further increase, battery systems are expected to play a growing role by providing frequency control and operational reserves as well as for wholesale arbitrage, while helping reduce grid integration costs. The more volatile electricity prices are, the greater the earning potential of batteries trading electricity on various electricity markets. BESS can generate revenue streams in several different ways; through a frequency response contract with the TSO, by providing grid services in other ways or by arbitrage through buying cheap power and selling power for a higher price in a liquid wholesale market. Because batteries are efficient, the round trip efficiency is also high. They can spread arbitrage trading much better than other storage types and in many cases, other asset classes. For companies that combine a battery with other tasks, for example to store power from their own panels, or to avoid a costly heavy power connection, the investment is less risky than for those that purely focus on arbitrage trading. It is uncertain whether electricity prices will fluctuate more violently in the coming years, or whether the peaks will actually level off. During this highly interactive training, the trainer will provide you with the latest insights and best practices on how to obtain the maximum economic benefits when participating with BESS in the electricity market. Training Objectives By the end of this course, the participants will be able to: Discover the different BESS battery technologies and their impact on the grid Understand the role of storage in providing flexibility to the power system Examine the potential revenue streams from BESS models Learn how profit can generated with BESS trading strategies Determine how to optimize the value from BESS projects Find out how to combine BESS with renewable PPAs Target Audience Professionals and executives from Power Utilities, Energy Companies, Financial & Investment Banks, Renewable Power Project Developers, Transmission System Operators and Energy Industry Regulators will find this training course useful. Electricity Marketing and Traders New Venture or Business Development Executives Corporate Finance and Treasury Executives Audit and Risk Management Executives Power or Utility Market Research Analysts Investment Managers for Renewable Power Projects Origination Professionals Regulation, Compliance and Documentation Officers Lawyers and Accountants Power Transmission and Distributions Engineers Trainer Our key expert is a skilled and accomplished professional with over 25 years' of extensive senior management / board level experience in the energy markets worldwide. Next to advising energy companies, banks, consultants and regulators regarding PPAs, our key expert has also conducted several highly successful training courses about Power Purchase Agreements, Power Project Finance, IPPs, and Project Risk Management to over 1,000 high level participants from Asia, Africa, Europe and Middle East. He was a member of the expert commission of the Dutch Government for 2 offshore wind parks, Hollandse Kust (zuid) Wind Farm Zone Sites 3 and 4 that advised on which of the 5 applicants did provide the best security and solutions associated with the electricity and green certificate prices, the construction and operational risks of the project. 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

SNMP training course description A hands-on generic look at the technical operation of SNMP. The course starts with an overview of all the components, which make up SNMP. Hands on starts early with configuration of a managed network. The major versions of SNMP are then put into perspective followed by a look at the SNMP protocol. MIBs are then studied both from the perspective of reading MIBs and writing MIBs. The course finishes with a look at the security implications of SNMP. What will you learn Describe the SNMP architecture. Analyse SNMP packets. Recognise the MIB structure. Describe the SMI. Recognise the strengths and weaknesses of SNMPv2 and SNMPv3. SNMP training course details Who will benefit: Network administrators. Network operators. Programmers writing MIBs and agents. Prerequisites: TCP/IP Foundation for engineers Hands on experience of an SNMP management station would also be beneficial. Duration 3 days SNMP training course contents Network management What is network management? Benefits, issues. What is SNMP? SNMP architecture, SNMP MIBs, SMI, the SNMP protocol, polling security, alternatives to SNMP: CMIP, web based management. Configuring SNMP Auto discovery for management stations, NMS configuration, agent configuration, traps. Hands on Configuring agents and an NMS. SNMP background SNMP history, RFCs, standards, SNMP protocol versions, SNMPv1, SNMPv2, SNMPv3, SNMP SMI versions, which version should you use? Futures. SNMPv1 packets SNMP in the 7 layer model, port numbers, general packet format, BER, GET, GET-NEXT, tables, SET, TRAP, bandwidth issues, in band versus out of band management. Hands on Analysing SNMPv1 packets. SNMPv2 packets SNMPv2 improvements, error handling, GETBULK, v2traps, INFORM. Hands on Analysing SNMPv2 packets. SNMPv3 packets SNMPv3 packet format, use of SNMPv2 messages, REPORT PDU. MIB structure The internet MIB branch, standard mib-2, extra parts of mib-2, private enterprise MIBs, loading extra MIBs. Hands on MIB browsing. mib-2 The mib-2 groups, system group, interfaces group, IP group, ICMP group, TCP group, UDP group, transmission group, SNMP group, RMON. Hands on mib-2 browsing in detail. SMI The MIB layout, obtaining a private enterprise number, MIB definitions, IMPORT, Module identity, Textual conventions, object definitions, notifications, compliance statements, object groups, base SMI data types, application data types, scalars, instances, tables, table definition, writing agents, SMIng. SNMP security Community strings, SNMPv1 and SNMPv2c security practices, SNMPv3 security, SNMPv3 architecture, SNMP applications, the SNMP engine, the EngineID, security fields in SNMPv3 packets, USM, authentication, encryption, timeliness, VBAC, SNMPv3 configuration.

Our NEBOSH Health and Safety Management for Construction (UK) course is aligned to the CDM regulations and is established as a leading award in construction health and safety.

Total QoS training course description An advanced technical hands on course focusing on Quality of Service issues in IP networks. What will you learn Explain the difference between Integrated services and differentiated services. Explain how DiffServ works. Explain how RSVP works. Design networks supporting QoS. Total QoS training course details Who will benefit: Network administrators. Network operators. Prerequisites: TCP/IP Foundation for engineers Duration 3 days Total QoS training course contents What is QoS QoS and CoS, throwing bandwidth at the problem, Best effort services, Differentiated services, Integrated services, guarantees, the need for QoS, IETF working groups. Application issues Video, Voice, other applications, Jitter, delay, packet loss. Flows, per flow and per aggregate QoS, Stateful vs. stateless QoS, applications vs. network QoS. 'Traditional' IP QoS The TOS field and precedence, the obsolete OSPF use of the TOS field, TCP congestion avoidance. Queuing Where to use queuing, FIFO, Priority queuing, Custom queuing, Weighted Fair Queuing, CBWFQ, PQWFQ, LLQ, RED and WRED. DiffServ Architecture, DSCP, CU, packet classification and marking, meters and conditioners, Bandwidth brokers and COPS, Per Hop Behaviours, best effort PHB, Assured Forwarding PHB, Expedited forwarding PHB, Network Based Application Recognition (NBAR). Layer 2 issues Fragmentation and interleaving, compression (codecs, MPEG formats, header compression…), 802.1p, Subnet bandwidth management, Bandwidth allocators and requestor modules, the use of MPLS, traffic engineering, traffic shaping. RSVP What is RSVP? architectures, paths, path messages, reservations, traffic specifications, tear downs, guaranteed and controlled load, token buckets, Call Admission Control in voice networks, gatekeepers. Other issues Policy based routing, the Resource Allocation Protocol, QoS management tools, baselining networks, design issues, QoS in IPv6, QoS and multicasts.

Explore cutting-edge power system training with EnergyEdge. Learn about integrating solar, storage, and DERs for efficient energy management. Enroll now!

Voice over LTE training course description This course provides a basic understanding of the 3G LTE Air Interface, SAE, as well as Voice over LTE options and LTE Advanced features. Investigating the standards for the EPS , formulated by the 3GPP standards body, the course will set out to examine and explain the 4G environment from user equipment to border gateway and beyond. This course will ensure the delegate has a grasp of all aspects of the current global deployments, the next steps in upgrades and the promise of things to come. What will you learn Describe the complete EPC architecture. Explain the use of QoS within the air interface & core network. Explore the features of LTE advanced. Describe the various methods of supporting voice services with 3G LTE. Describe IMS structure and control entities. Explain an IMS session. Voice over LTE training course details Who will benefit: Any engineers who are assisting in the deployment of voice services within their LTE networks. Prerequisites: Intro to Data comms & networking Telecommunications Introduction Duration 3 days Voice over LTE training course contents 3GPP standards body Release 8 - Release 12, Supported and expected features. The EPC revisited EPC revisited 3G LTE & EPC Architecture, NB, MME, SGW, PDNGW, PCRF, Interworking capabilities, Protocol stack explored, NAS signalling, Default EPS bearer, Slot allocation algorithms, Scheduling algorithms, Quality of Service requirements, Dedicated EPS bearers. VoLTE deployment strategies Common networks everywhere, GSM/WCDMA view, CDMA view. VoLTE system architecture LTE radio, LTE Radio background, LTE radio architecture, Evolved packet core, EPC entities & functions, EPS mobility management, MS entities, Home subscriber server, Policy & charging rules function. VoLTE functionality Radio functionality, Bearers & schedulers, Mobility, Circuit switched fall back handover, Mobility from 2G/3G back to LTE, Power Saving Features, Positioning services, UE radio access capabilities for VoLTE users. EPC functionalities, LTE subscriber identification, PDN connectivity establishment, EPS dedicated bearer setup, IMS identification, IP multimedia identification module, Public user identity, Private user identity, Relationship between public & private identity, identification of users device, identification of network entities, identification of services, identification without ISIM. IMS service provisioning, Enforcement of allowed services, Service triggering information, Selection of the AS, AS behaviour, Service provisioning in action. VoLTE end-to-end & signalling VoLTE subscription & device configuration. EPS attach for CSFB/IMS VoIP & default bearer. IMS registration, Constructing the REGISTER request, From UE to P-CSCF, From P-CSCF to I-CSCF, From I-CSCF to S-CSCF, S-CSCF challenges the UE, UE's response to the challenge, Registration at the S-CSCF, The 200 OK response, Third-party registration to application servers, Subscription to registration event package, Re-registration & re-authentication, De-registration, Related standards. IMS VoIP session, Constructing the INVITE request, Routing, Media negotiation, Media resource reservation & policy control, Charging, Session release. Voice continuity, PS - PS intersystem handover, Single radio voice call continuity. IMS emergency session, PDN Connection setup for emergency session, Emergency registration, Emergency session. CS fallback for EPS call case, Architecture of CS fallback in EPS, Description of SGs interface, Idle mode signalling reduction, Idle mode vs active mode, CS fallback attachment, Mobile originating call using CSFB, Mobile terminating call using CSFB, Call unrelated CSFB procedures, Mobile terminating roaming retry & forwarding. VoLTE Messaging, Native IMS messages, SMS interworking, Multimedia messaging service. Unstructured supplementary services data simulation in IMS. IMS services VoLTE radio performance Coverage, Latency, Capacity. LTE advanced features Carrier aggregation, Coordinated mMulti-point Operation (CoMP), ICIC & eICIC, Relay node deployment & donor eNBs, Improved cell edge coverage, Reduced control plane latency, Heterogeneous networks, HeNB, security gateways, HeNB gateways.

Register on the Dealing With Difficult People Training Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Dealing With Difficult People Training Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Dealing With Difficult People Training Course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Dealing With Difficult People Training Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Dealing With Difficult People Training Course Module 01: Difficult Promo 00:06:00 Module 02: Fundamentals 00:08:00 Module 03: Foundational Tips and Tools 00:16:00 Module 04: Difficult People - Relationships 00:13:00 Module 05: Difficult People - Solutions 00:13:00 Module 06: Problem - Solving 00:14:00 Module 07: Final Notes and Tips 00:10:00 Module 08: Bonus Video - dealing With Emotions & Anger 00:10:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.