22121 Courses

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Autism: Autism Diploma Are you concerned about the best course of action for treating the kids who have been diagnosed with autism? If so, you should enrol in the Autism Diploma program to acquire the skills and information required to help autistic children effectively. You will learn about the different types of autistic behaviour in this autism diploma program, as well as how to interact with them. With the help of this Autism: Autism Diploma program, you will learn how to help those who are having similar problems in their lives. Also, with the help of an Autism Diploma You will understand how to identify Autism. You will learn more about cognitive styles, functions, and awareness in autism by taking this Autism: Autism Diploma course. Autism Diploma will also broaden your understanding by learning about the English government's policies on autism. Enrol in our Autism: Autism Diploma today to pursue your goals and get the knowledge, experience, and skills necessary to further your career in the industry. Learning Outcomes of Autism: Autism Diploma After completing this Autism: Autism Diploma course, you will be able to: Know about a brief about Autism Spectrum Disorder (ASD), their behaviour and how to raise awareness for autism. The Autism: Autism Diploma will assist you in comprehending Autism Diagnosis and Communication. With the help of this Autism: Autism Diploma, you will get knowledge about cognitive styles and functions in autism. Autism: Autism Diploma course will help you to understand Organisation Systems with Autistic Individuals. Government Policies on Autism in England will be a learning part of Autism Diploma. Main Course: Autism Diploma Free Courses are including with this Autism: Autism Diploma Course Along with The Autism Diploma Course, We Offer a free Speech & Language Therapy Course Along with The Autism Diploma Course, We Offer a free SEN Teaching Assistant Course Along with The Autism Diploma Course, We Offer a free Early Years Level 4 Course Special Offers of this Autism: Autism Diploma Course This Autism: Autism Diploma Course includes a FREE PDF Certificate. Lifetime access to this Autism: Autism Diploma Course Instant access to this Autism: Autism Diploma Course Get FREE Tutor Support to this Autism: Autism Diploma Course [ Note: Free Digital certificate as soon as completing the Autism: Autism Diploma Course] Autism: Autism Diploma Since autism affects about one child out of every 100, educators need to equip themselves with the skills and knowledge necessary to support autistic students. You will learn about the different symptoms of autism as well as the challenges that people with autism have when it comes to socialization, education, communication, and forming relationships in this Autism Diploma course. This Autism Diploma course will also educate you how to help those with comparable challenges better their lives. Who is this course for? Autism: Autism Diploma This Autism: Autism Diploma is perfect for: Parents Students Teachers Job Seekers Requirements Autism: Autism Diploma To enrol in this Autism: Autism Diploma Course, students must fulfil the following requirements To join in our Autism: Autism Diplom Course, you must have a strong command of the English language. To successfully complete our Autism: Autism Diploma Course, you must be vivacious and self driven. To complete our Autism: Autism Diploma Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Autism: Autism Diploma Course. Career path Autism: Autism Diploma This Autism: Autism Diploma helps you progress professionally by offering pertinent knowledge, practical skills, and a certificate of completion.

Child Counselling: Child Counselling Course Get the expertise you need to advance your career in child counseling.- enrol now in our Level 4 Diploma in Child Counselling course. Are you eager to start a profession as a child counsellor or do you want to learn more sophisticated techniques? Then, this Level 4 Diploma in Child Counselling program in child counselling will further your professional goals. This Level 4 Diploma in Child Counselling helps you build the knowledge and abilities necessary for a fulfilling career. After completing Level 4 Diploma in Child Counselling course you will Get certifications and skills in child counselling that companies will value. You may greatly improve your knowledge and abilities by enrolling in our Level 4 Diploma in Child Counselling programme. Level 4 Diploma in Child Counselling Explain how to address and investigate real difficulties, making decisions and coping with crises. Throughout this Level 4 Diploma in Child Counselling Course you are also able to work through internal conflict, and improve interpersonal connections. Level 4 Diploma in Child Counselling Course helps youngsters focus on their interests and developmental challenges. However, this Level 4 Diploma in Child Counselling course will show you how to effectively address the suffering, grief, and attachment concerns of obstructive children. You will be qualified to work as a qualified child counsellor with a focus on working with children and adolescents after finishing this Level 4 Diploma in Child Counselling program. Enrol in our Level 4 Diploma in Child Counselling course right now and start learning! Main Course: Level 4 Diploma in Child Counselling Course Free Courses are including with this Child Counselling: Child Counselling Course Along with The Child Counselling: Child Counselling Course, We Offer a free Level 4 Diploma in Child Psychology Course Special Offers Of this Child Counselling: Child Counselling Course This Child Counselling: Child Counselling Course includes a FREE PDF Certificate. Lifetime access to this Child Counselling: Child Counselling Course Instant access to this Child Counselling: Child Counselling Course Get FREE Tutor Support from Monday to Friday in this Child Counselling: Child Counselling Course [ Note: Free Digital certificate as soon as completing the Child Counselling: Child Counselling Course] Child Counselling: Child Counselling Course However, this Level 4 Diploma in Child Counselling course will show you how to effectively address the suffering, grief, and attachment concerns of obstructive children. You will be qualified to work as a qualified child counsellor with a focus on working with children and adolescents after finishing this Level 4 Diploma in Child Counselling program. Who is this course for? Child Counselling: Child Counselling Course Child counsellors, parents, instructors, recent graduates, and child and youth professionals are all eligible to enrol in this Child Counselling: Child Counselling Course. Requirements Child Counselling: Child Counselling Course To enrol in this Child Counselling: Child Counselling Course, students must fulfil the following requirements. To join in our Child Counselling: Child Counselling Course, you must have a strong command of the English language. To successfully complete our Child Counselling: Child Counselling Course, you must be vivacious and self driven. To complete our Child Counselling: Child Counselling Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Child Counselling: Child Counselling Course. Career path Child Counselling: Child Counselling Course This Child Counselling: Child Counselling Course gives you new options to advance professionally and gain an edge over other applicants in your sector by adding your new skills to your resume.

Learn to Code HTML, CSS, Javascript: Guide for Beginners Course Overview This course offers a comprehensive introduction to HTML, CSS, and JavaScript, designed for those looking to build a strong foundation in web development. Covering the essential web technologies, it equips learners with the skills to create fully functional websites and interactive web pages. From understanding basic structure and styling to mastering advanced JavaScript concepts, this course ensures that learners develop a solid understanding of how modern websites are built and maintained. By the end of the course, learners will be confident in their ability to build, style, and add functionality to websites, preparing them for a variety of web development roles. Course Description "Learn to Code HTML, CSS, and JavaScript: Guide for Beginners" takes learners through every stage of web development, starting with the core technologies: HTML, CSS, and JavaScript. It covers the fundamentals and gradually advances to more sophisticated techniques, helping learners build their skills step by step. The course explores HTML structure, CSS styling, and JavaScript logic, covering essential areas such as strings, operators, and control flow. In addition to these core concepts, learners will delve into client-side validations, error handling, and data visualisation. By the end of the course, students will be equipped to create professional websites and publish them for live use, with a full understanding of front-end development. Learn to Code HTML, CSS, Javascript: Guide for Beginners Curriculum Module 01: Getting Started Module 02: Setting up Development Environment Module 03: HTML Fundamentals Module 04: HTML Intermediate Module 05: HTML Advanced Module 06: HTML Expert Module 07: HTML Website Project Module 08: CSS Fundamentals Module 09: CSS Intermediate Module 10: CSS Advanced Module 11: CSS Expert Module 12: CSS Website Project Module 13: JavaScript Getting Started Module 14: JavaScript Fundamentals Module 15: Strings Module 16: Operators Module 17: Conditional Statements Module 18: Control Flow Statements Module 19: Functions Module 20: Data Visualisation (Google Charts) Module 21: Error Handling Module 22: Client-side Validations Module 23: Publish Your Website for Live (See full curriculum) Who is this course for? Individuals seeking to learn web development. Professionals aiming to enhance their web development skills. Beginners with an interest in building websites. Anyone looking to enter the tech industry or web development field. Career Path Front-End Developer Web Developer Web Designer UI/UX Developer JavaScript Developer Full-Stack Developer Website Project Manager Digital Marketer

Overview This Power Electronics for Electrical Engineering course will unlock your full potential and will show you how to excel in a career in Power Electronics for Electrical Engineering. So upskill now and reach your full potential. Everything you need to get started in Power Electronics for Electrical Engineering is available in this course. Learning and progressing are the hallmarks of personal development. This Power Electronics for Electrical Engineering will quickly teach you the must-have skills needed to start in the relevant industry. In This Power Electronics for Electrical Engineering Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Power Electronics for Electrical Engineering skills to help you advance your career. Acquire a comprehensive understanding of various Power Electronics for Electrical Engineering topics and tips from industry experts. Learn in-demand Power Electronics for Electrical Engineering skills that are in high demand among UK employers, which will help you to kickstart your career. This Power Electronics for Electrical Engineering course covers everything you must know to stand against the tough competition in the Power Electronics for Electrical Engineering field.  The future is truly yours to seize with this Power Electronics for Electrical Engineering. Enrol today and complete the course to achieve a Power Electronics for Electrical Engineering certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Power Electronics for Electrical Engineering course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Power Electronics for Electrical Engineering course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Power Electronics for Electrical Engineering course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Power Electronics for Electrical Engineering is suitable for anyone aspiring to start a career in Power Electronics for Electrical Engineering; even if you are new to this and have no prior knowledge on Power Electronics for Electrical Engineering, this course is going to be very easy for you to understand.  And if you are already working in the Power Electronics for Electrical Engineering field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Power Electronics for Electrical Engineering course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Power Electronics for Electrical Engineering course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Power Electronics for Electrical Engineering course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Power Electronics for Electrical Engineering course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 1- Introduction to Power Electronics Components Module 1- Introduction to Power Electronics 00:13:00 Module 2- Uncontrolled Switches 00:17:00 Module 3- What is the Benefit of Diode 00:06:00 Module 4- Semi-Controlled Switches Part 1 00:09:00 Module 5- Semi-Controlled Switches Part 2 00:14:00 Module 6- Semi-Controlled Switches Part 3 00:05:00 Module 7- What is the Benefit of Thyristor 00:05:00 Module 8- Fully Controlled Switches Part 1 00:17:00 Module 9- Fully Controlled Switches Part 2 00:10:00 Module 10- Fully Controlled Switches Part 3 00:12:00 Unit 2- Fundamentals of Rectifier Circuits Module 1- Overview on Rectifiers 00:02:00 Module 2- Rectifier Definition 00:01:00 Module 3- Half Wave Uncontrolled Rectifier with R Load 00:21:00 Module 4- Example on Half Wave Uncontrolled Rectifier with R Load Part 1 00:06:00 Module 5- Example on Half Wave Uncontrolled Rectifier with R Load Part 2 00:07:00 Module 6- Half Wave Uncontrolled Rectifier with RL Load 00:10:00 Module 7- Derivation of the Discontinuous Current in R-L Load 00:08:00 Module 8- Freewheeling Diode (Commutation Diode) 00:03:00 Module 9- Half Wave R-L Load with FWD 00:09:00 Module 10- Difference Between Continuous and Discontinuous Mode in RL Load 00:07:00 Module 11- Half Wave RL Load with FWD Continuous Mode 00:06:00 Module 12- Example on Half Wave Rectifier with FWD 00:07:00 Module 13- Bridge Full Wave Uncontrolled Rectifier Part 1 00:07:00 Module 14- Bridge Full Wave Uncontrolled Rectifier Part 2 00:05:00 Module 15- Quick Revision on Bridge Full Wave Uncontrolled Rectifier 00:06:00 Module 16- Firing Angle 00:02:00 Module 17- Half Wave Controlled Rectifier R Load 00:05:00 Module 18- Half Wave Controlled Rectifier R-L Load 00:04:00 Module 19- Half Controlled R-L Load with FWD 00:06:00 Module 20- Example 1 00:07:00 Module 21- Example 2 00:08:00 Module 22- Example 3 00:13:00 Module 23- Example 4 00:09:00 Module 24- Example 5 00:05:00 Module 25- Fully Controlled Bridge Rectifier Part 1 00:06:00 Module 26- Fully Controlled Bridge Rectifier Part 2 00:06:00 Module 27- Quick Revision on Bridge Full Wave Controlled Rectifier 00:02:00 Module 28- Example 6 00:08:00 Module 29- Half Controlled Bridge Rectifier 00:08:00 Module 30- Half Controlled Bridge Rectifier with FWD 00:05:00 Module 31- Example 7 00:06:00 Module 32- Example 8 00:07:00 Module 33- Performance Parameters 00:04:00 Module 34- Power Factor 00:04:00 Unit 3- Fundamentals of AC Choppers Module 1- Introduction to AC Choppers 00:02:00 Module 2- Definition of AC Choppers 00:05:00 Module 3- Switching Techniques in AC Choppers 00:06:00 Module 4- Applications on AC Choppers 00:03:00 Module 5- Types of AC Choppers 00:02:00 Module 6- AC Chopper with R Load 00:14:00 Module 7- Example 1 on AC Chopper with R Load 00:06:00 Module 8- Example 2 on AC Chopper with R Load 00:04:00 Module 9- AC Chopper with L Load Part 1 00:13:00 Module 10- AC Chopper with L Load Part 2 00:06:00 Module 11- Example on AC Chopper with L Load 00:08:00 Module 12- AC Chopper with RL Series Load 00:20:00 Module 13- Example on AC Chopper with RL Series Load 00:07:00 Module 14- AC Chopper with RL Parallel Load 00:25:00 Module 15- Example on AC Chopper with RL Parallel Load 00:06:00 Module 16- AC Chopper with Pure Capacitive Load 00:14:00 Module 17- Example on AC Chopper with Pure Capacitive Load 00:04:00 Module 18- AC Chopper Loaded by Heavy Rectifier 00:06:00 Module 19- AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf 00:12:00 Module 20- Example on AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf 00:08:00 Module 21- Integral Cycle Control 00:11:00 Module 22- Example on Integral Cycle Control 00:04:00 Unit 4- Fundamentals of DC Choppers Module 1- Introduction to DC Choppers 00:02:00 Module 2- Definition and Application of DC Choppers 00:05:00 Module 3- Step down DC Chopper with R Load 00:12:00 Module 4- Example on Step Dwon DC Chopper with R Load 00:08:00 Module 5- Generation of Duty Cycle 00:09:00 Module 6- Switching Techniques 00:03:00 Module 7- Step Down DC Chopper with RLE Load Part 1 00:19:00 Module 8- Step Down DC Chopper with RLE Load Part 2 00:15:00 Module 9- Example 1 on Step Down DC Chopper with RLE Load 00:13:00 Module 10- Example 2 on Step Down DC Chopper with RLE Load 00:02:00 Module 11- Step Up DC Chopper with R or RL Load 00:09:00 Module 12- Step Up DC Chopper with RE Load 00:15:00 Module 13- Example on Step Up DC Chopper with RE Load 00:20:00 Module 14- Buck Regulator Part 1 00:16:00 Module 15- Buck Regulator Part 2 00:17:00 Module 16- Example on Buck Regulator 00:03:00 Module 17- Boost Regulator 00:23:00 Module 18- Example on Boost Regulator 00:06:00 Module 19- Buck Boost Converter 00:17:00 Module 20- Example on Buck-Boost Converter 00:05:00 Unit 5- Fundamentals of Inverters Module 1- Introduction to Inverters 00:02:00 Module 2- Definition of Inverters 00:04:00 Module 3- Importance and Applications of Inverters 00:08:00 Module 4- Single Phase Half Bridge R-Load 00:15:00 Module 5- Single Phase Half Bridge RL- Load 00:08:00 Module 6- Performance Parameters of an Inverter 00:05:00 Module 7- Example on Single Phase Half Bridge 00:10:00 Module 8- Single Phase Bridge Inverter R- Load 00:06:00 Module 9- Single Phase Bridge Inverter RL- Load 00:07:00 Module 10- Example on Single Phase Bridge Inverter 00:06:00 Module 11- Three Phase Inverters and Obtaining the Line Voltages 00:15:00 Module 12- Threee Phase Inverters and Obtaining The Phase Voltages 00:17:00 Module 13- Example on Three Phase Inverters 00:16:00 Module 14- Single Pulse Width Modulation 00:13:00 Module 15- Multiple Pulse Width Modulation 00:13:00 Module 16- Example on Multiple Pulse Width Modulation 00:04:00 Module 17- Sinusoidal Pulse Width Modulation 00:16:00 Module 18- Industrial Inverter 00:03:00

The Diploma in Event Management is a comprehensive online course designed to equip you with the essential skills and knowledge to excel in the fast-paced event industry. Whether you dream of organizing corporate conferences, weddings, music festivals, or sporting events, this course covers event planning, budgeting, marketing, logistics, and risk management. You’ll learn from industry experts through real-world case studies, interactive modules, and hands-on projects. This course blends theoretical knowledge with practical insights, ensuring you understand the latest trends, digital tools (like event management software), and sustainability practices in events. By the end, you’ll be able to plan, execute, and evaluate successful events while managing clients, vendors, and teams efficiently. Perfect for aspiring event planners, entrepreneurs, or professionals looking to switch careers, this diploma provides a globally recognized certification to boost your credibility in the industry. With flexible online learning, you can study at your own pace and gain access to exclusive resources, networking opportunities, and career support. Start your journey towards becoming a skilled event manager today! Learning Outcomes Master end-to-end event planning, from concept to execution. Develop budgeting and financial management skills for profitable events. Learn effective marketing strategies, including social media & branding. Understand venue selection, logistics, and vendor management. Gain expertise in risk assessment and crisis management. Utilise event technology & software (e.g., Eventbrite, Cvent). Enhance client communication and negotiation skills. Explore sustainable and eco-friendly event practices. Build a professional portfolio with real-world projects. Who is This Course For? This course is ideal for aspiring event planners, hospitality professionals, marketing executives, entrepreneurs, and career changers seeking entry into the event industry. It’s also beneficial for small business owners who want to organize their own events or corporate professionals handling company meetings and conferences. No prior experience is required—just a passion for creating unforgettable experiences! Career Path Event Coordinator – £22,000 - £30,000 Wedding Planner – £25,000 - £40,000 Corporate Event Manager – £30,000 - £50,000 Festival Organizer – £28,000 - £45,000 Conference Producer – £35,000 - £55,000 Exhibition Manager – £32,000 - £48,000 Why Enroll? Industry-recognised certification Flexible online learning Expert-led training & case studies Career support & job placement guidance Start your journey in event management today and turn your passion into a thriving career! 🎉

Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who want to use more advanced functionalities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros. Overview In this course, you will learn to use the advanced capabilities of Word 2021. You will: Use images in a document. Create custom graphic elements. Collaborate on documents. Add reference marks and notes. Secure a document. Create and manipulate forms. Create macros to automate tasks. Microsoft© Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications. Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other Media Elements Using Custom Graphic Elements Topic A: Create Text Boxes and Pull Quotes Topic B: Add WordArt and Other Text Effects Topic C: Draw Shapes Topic D: Create Complex Illustrations with SmartArt Collaborating on Documents Topic A: Prepare a Document for Collaboration Topic B: Mark Up a Document Topic C: Review Markups Topic D: Merge Changes from Other Documents Adding Document References and Links Topic A: Add Captions Topic B: Add Cross-References Topic C: Add Bookmarks Topic D: Add Hyperlinks Topic E: Insert Footnotes and Endnotes Topic F: Add Citations and a Bibliography Securing a Document Topic A: Suppress Information Topic B: Set Formatting and Editing Restrictions Topic C: Restrict Document Access Topic D: Add a Digital Signature to a Document Using Forms to Manage Content Topic A: Create Forms Topic B: Modify Forms Automating Repetitive Tasks with Macros Topic A: Automate Tasks by Using Macros Topic B: Create a Macro

Duration 2 Days 12 CPD hours This course is intended for The target audience for the DevOps Test Engineering course is anyone involved in defining a DevOps Testing strategy, such as: Delivery Staff DevOps Engineers IT Managers Project Managers Lab Staff Maintenance and Support Staff Quality Assurance Managers Quality Assurance Teams Release Managers Testers Software Engineers Overview The learning objectives for DTE include a practical understanding of: The purpose, benefits, concepts and vocabulary of DevOps testing How DevOps testing differs from other types of testing DevOps testing strategies, test management and results analysis Strategies for selecting test tools and implementing test automation Integration of DevOps testing into Continuous Integration and Continuous Delivery workflows How DevOps testers fit with a DevOps culture, organization and roles This comprehensive course addresses testing in a DevOps environment and covers concepts such as the active use of test automation, testing earlier in the development cycle, and instilling testing skills in developers, quality assurance, security, and operational teams. The course is relevant for every modern IT professional involved in defining or deploying a DevOps testing strategy for their organization, as test engineering is the backbone of DevOps and the primary key for successful DevOps pipeline to support digital transformation. This course prepares you for the Continuous Testing Foundation(CTF) certification. Course Objectives and Modules, Logistics What is DevOps Testing and its Business Benefits?Relation of DevOps Testing in other Test MethodologiesDevOps Testing Best Practices DevOps Testing Terminology Culture changes Organization changes Process and team friction Motivation strategies Measuring Success Continuous Evolution Troubleshooting What is the DevOps pipeline? DevOps Testing on the pipeline Test strategy choices Pre-Flight strategies Continuous Integration Testing System, Delivery and Customer Testing Test Environments Lab Management Topology orchestration Test Automation Frameworks Test Tools Selection criterion Automated metrics Key concepts Test Case Best Practices & Design Exercise Test Suite Best Practices & Design Exercise Principles of DevOps Management DevOps Test Management Metrics DevOps Management Tools DevOps Test Results Analysis Integrating DevOps Results Analysis Test Management Exercise Fictitious Product Test Requirements Individual Exercise Class discussion Exam Preparation

Photoshop CS6 Certification Level 1 Photoshop is an astounding device for taking a picture to the following level. It lift the nature of a photograph and can totally change a picture. Notwithstanding, before you can get familiar with every one of the high level subtle strategies, it's fundamental to comprehend Photoshop's essential and most normally utilized devices. In addition to the fact that this allows for appropriate use of devices, however its advantages range across numerous businesses. Photoshop is incredible for making site formats and illustrations, rehabilitating old pictures and creatively changing a picture. Regardless of whether you're an expert architect or basically into altering selfies, the imaginative potential outcomes with Photoshop are unending. How about we take a gander at what you will realize in this course and what a portion of the advantages are. What you will realize in this course: Instructions to communicate inventively utilizing Photoshop How to manage a picture whenever altering is done The various approaches to upgrade a photograph and find out about the fundamental instruments of Photoshop Instructions to see distinctive angle proportions Instructions to apply overlays About the setting choices of the stuff instrument The distinction among print and web alternatives Step by step instructions to customize individual and business reports Comprehend about various record types and how to import a picture You will comprehend the significance of record size, picture size and material size Course Benefits: Upgrades vocation choices Figure out how to adequately utilize layers Find out about the advantages of the distinctive document types Comprehend which document type is most usually utilized Expertise to improve photographs utilizing the spot recuperating brush and clone stamp device Fantastic instrument for business as it is a usually utilized stage for altering, promoting and making business cards

Unlock your screenwriting potential with our Online Screenwriting for Film & Television (UK) course. Learn essential techniques, understand industry standards, and enhance your scriptwriting skills. Perfect for aspiring and experienced screenwriters alike. Get CPD accredited and boost your career in the UK film and TV industry.