18925 Courses

In this course, we take you step by step through the most common features and programming idioms of the Groovy programming language, enabling you to supercharge your developer productivity by harnessing the power of Groovy's lightweight and succinct programming syntax.

This course includes all of the tools you'll need to be successful with cryptocurrencies, and it's all based on real-world experience and knowledge rather than theory.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Description Documentary Films Diploma Introducing the Documentary Films Diploma: a comprehensive online course tailored for those with a passion for storytelling through film. This programme offers an unparalleled understanding of the documentary film landscape, from its historical origins to the modern tools and techniques that shape it today. The Documentary Films Diploma begins with a robust examination of the birth and evolution of documentary films. It's an exciting journey through time, charting the transformative moments and innovations that have moulded this powerful form of storytelling. From here, participants gain insight into the myriad of documentary genres, each with its unique voice and impact. Of course, the heart of a compelling documentary is its production. To this end, the Documentary Films Diploma provides a thorough exploration of documentary filmmaking techniques. Students gain the skills to craft narratives that not only inform but also resonate deeply with audiences. Documentaries, however, are not merely about capturing reality; they also possess the ability to sway opinions and instigate change. The power and influence of documentaries section will give students a glimpse into how films can serve as catalysts for societal shifts and personal revelations. Some documentary makers have had a pronounced effect on the art and have elevated it to levels hitherto unimagined. This course pays homage to notable documentarians, discussing their contributions and delving into their most seminal works. These narratives are not only about the films but also the indomitable spirits behind them. Creating a documentary film, however, is not without its challenges. One crucial aspect often overlooked is the funding and distribution of documentary films. The Documentary Films Diploma illuminates the paths to secure funding and the strategies for effective distribution, ensuring that a filmmaker's vision reaches its intended audience. Legal matters can also present a hurdle to many documentary filmmakers. With a dedicated section on legal aspects in documentary filmmaking, students gain a fundamental understanding of the rights, permissions, and legal considerations essential to the trade. Yet, documentaries are not limited to the silver screen or streaming platforms. Their importance stretches into classrooms and educational institutions. Through the Documentary Films Diploma, students learn about the role of documentaries in education, their importance as teaching aids, and their ability to foster critical thinking and empathy among viewers. Furthermore, as we live in an increasingly globalised world, documentaries often transcend borders, touching lives across continents. An understanding of documentary films in the international scene ensures that students appreciate the universal themes that make documentaries resonate worldwide. Lastly, where is this incredible art form headed? As technology evolves and global events shape our narratives, the future of documentary filmmaking becomes an exciting realm of possibility. This course, with its forward-thinking approach, provides a speculative yet informed glimpse into what the future holds. In sum, the Documentary Films Diploma offers a holistic and in-depth understanding of documentary films, making it indispensable for aspiring filmmakers and enthusiasts alike. Through this online course, one can harness the tools, insights, and knowledge to craft poignant documentaries that inform, inspire, and ignite change. What you will learn 1:The Birth and Evolution of Documentary Films 2:Understanding Documentary Genres 3:Documentary Filmmaking Techniques 4:The Power and Influence of Documentaries 5:Notable Documentarians and their Work 6:Funding and Distribution of Documentary Films 7:Legal Aspects in Documentary Filmmaking 8:The Role of Documentaries in Education 9:Documentary Films in the International Scene 10:The Future of Documentary Filmmaking Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Description Botanical Illustration Diploma The Botanical Illustration Diploma offers a comprehensive online journey for individuals passionate about the confluence of art and nature. This course beckons aspiring artists, horticultural enthusiasts, and nature lovers alike, paving a seamless path to the mastery of capturing the essence of the plant world in visual form. Starting with the 'Introduction to Botanical Illustration', students are familiarised with the realm of plant portrayal. This foundational unit sets the stage for the deeper exploration of the intricate details and wonders of plant life. 'The Anatomy of Plants' delves into the core structures and the subtleties that make every plant unique. By grasping the finer details of plant anatomy, learners will be equipped to represent them with authenticity and precision. The 'Sketching Techniques for Plants' module unlocks the secrets of rendering plants with finesse. Pencil strokes, shading nuances, and textural detailing - all are demystified here. A plant's allure isn't just in its form but also its colour. 'Understanding Colour in Plants' educates learners about the rich palettes that nature offers. From the verdant greens of leaves to the vibrant hues of flowers, this segment ensures artists accurately capture the essence of each shade. 'The Art of Watercolour in Botany' introduces the delicate dance of watercolours and their application in botanical art. The fluidity and transparency of watercolours make them a favoured choice for many botanical illustrators, and this section ensures students harness their full potential. However, botanical artistry isn't restricted to just watercolours. 'Exploring Different Mediums' broadens the horizon, shedding light on the myriad of mediums that can be employed to breathe life into illustrations. No illustration, no matter how detailed, can be truly captivating without the right composition. 'Composition and Layout in Botanical Art' provides the scaffolding on which illustrations can be built, ensuring a harmonious blend of elements that are both aesthetically pleasing and scientifically accurate. With a rich history spanning centuries, botanical art has evolved in myriad ways. 'The Evolution of Botanical Artistry' offers a panoramic view of this journey, allowing learners to appreciate the context of their current studies. In a world that's increasingly conscious of the environment, 'Ethical Considerations and Conservation' instils a sense of responsibility in budding illustrators. This module underscores the importance of ethical practices in sourcing and portraying plant life. Finally, for those who wish to convert their passion into a profession, 'Building a Career in Botanical Illustration' charts out potential avenues. Whether it's freelancing, collaborating with researchers, or exhibiting in galleries, this segment offers insights into turning one's artistic prowess into a lucrative career. In conclusion, the Botanical Illustration Diploma isn't just a course; it's a curated experience. It transforms novices into adept illustrators, capable of capturing the beauty of the botanical world with flair, precision, and respect. Enrol today and embark on an enlightening voyage into the world of botanical artistry. What you will learn 1:Introduction to Botanical Illustration 2:The Anatomy of Plants 3:Sketching Techniques for Plants 4:Understanding Colour in Plants 5:The Art of Watercolour in Botany 6:Exploring Different Mediums 7:Composition and Layout in Botanical Art 8:The Evolution of Botanical Artistry 9:Ethical Considerations and Conservation 10:Building a Career in Botanical Illustration Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

This course is aimed at those who would like to work as a learning support assistant in a school or further education setting. Level 3 Certificate in Supporting Teaching and Learning will give you an understanding of the skills and knowledge needed to support learners in the classroom.

Take your knowledge to the next level with EnergyEdge's course focusing on pipeline integrity management incorporating API 1160, 1173, and ASME B31.8S. Enroll now!

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Data Entry Administrator at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! In today's data-driven world, efficient data management is more crucial than ever. Our comprehensive Data Entry course offers an in-depth understanding of the most relevant tools and techniques to streamline your data entry tasks. From mastering the basics to leveraging powerful tools like Excel, Flash Fill, and Autofill, this course equips you with everything you need to increase your productivity and boost your career prospects. With a strong emphasis on practical application, each module of this course is designed to help you tackle real-world challenges faced by data entry professionals. Learn how to create a data entry form in Excel and explore the use of statistics packages to improve your overall data entry skills. This course provides a solid foundation to enhance your marketability in the competitive job market. Learning Outcomes: Gain an understanding of the data entry process and its importance. Develop competence in using computers for efficient data entry tasks. Learn common rules and guidelines for accurate data entry. Master the use of Excel for improved data entry efficiency. Understand the functions of Flash Fill and Autofill in automating data entry tasks. Acquire skills in creating data entry forms and using statistics packages. Why Prefer This Data Entry at QLS Level 3 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Data Entry at QLS Level 3 course: Module 1: Introduction to Data Entry Module 2: Using the Computer for Data Entry Module 3: Common Rules and Guidelines for Data Entry Module 4: Using Excel for Efficient Data Entry Module 5: Using Excel's Flash Fill and Autofill to Automate Data Entry Module 6: How to Create a Data Entry Form in Excel? Module 7: Using Statistics Packages in Data Entry Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Data Entry Administrator at QLS Level 3exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for: Individuals seeking to improve their data entry skills Professionals looking to enhance their productivity Office administrators and support staff Students exploring career options in data management Requirements No prior background or expertise is required. Career path The Data Entry at QLS Level 3 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Like as: Data Entry Clerk: £18,000 - £22,000 Administrative Assistant: £17,000 - £21,000 Office Administrator: £18,000 - £23,000 Customer Service Representative: £17,000 - £21,000 Data Analyst: £25,000 - £35,000 Document Controller: £22,000 - £28,000 Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Data Entry Administrator at QLS Level 3 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Data Entry Administrator at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

Writing Clear Business Communication: On-Demand This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. Effective writing seldom, if ever, 'magically materializes' on the spot. In reality, it is most often the product of planning, writing, and rewriting. This is why writing is called a process; it must go through a series of steps before it is clear and complete. This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. However, the ability to communicate in the written word, for whatever purpose, is an important part of our working and personal lives and can have a direct impact on our ability to persuade, gain commitment or agreement and enhance understanding. Good writing sounds like talking on paper, which is why this program is focused on getting the message across and achieving the desired results using the 'keep it simple and direct' approach. What you Will Learn At the end of this program, you will be able to: Write effective e-mails, letters, memos, and reports Clearly articulate the message Achieve desired results from correspondence Organize content for maximum impact Format for enhanced understanding Choose the appropriate communication medium for each document Revise documents to increase clarity and impact Foundations Concepts Business writing as a form of professional communication How business writing compares to other forms of writing Characteristics of good business writing Challenges with business writing The Project Environment Business writing in the project environment The concept of art, science, and optics of business writing Art Economy Precision Action Music Personality Science Purpose, simple, compound, and complex sentence structures Techniques to engage the reader Point of view: tone, attitude, and humor Organization: opening, body, and closing Support and coherence Optics Visual optics Sound optics Feel optics Effective optics Efficient optics Email Formal vs. informal emails Suggestions for improving email communication Instant and text messaging Reports Common types of reports created Formatting of reports Guidelines for meeting minutes Contracts Types of contracts Common agreements Procurement documents Templates, Forms, and Checklists Templates Forms Checklists Other Formatting Good Documentation Practices Good documentation practices Data integrity in business communication

Playing with Fire (safely) to create copper jewellery is an introduction into copper smithing where you will amaze yourself by using an age old technique to make unique jewellery.