18527 Courses delivered Online

AI Short Video Creation | Turn Long Videos into Engaging Shorts

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

Spring flowers in watercolour and gouache using strong colours to capture the vibrancy of springtime.

Welcome to a brand-new course where you can learn about how to build a personal portfolio website from scratch with only three core technologies-HTML, CSS, and JS-and host the website and see it go live.

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.

Overview This comprehensive course on HTML and CSS Coding: Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This HTML and CSS Coding: Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this HTML and CSS Coding: Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our HTML and CSS Coding: Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 127 lectures • 11:50:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:07:00 •How to Get Course requirements: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:02:00 •How to ask a Great Questions: 00:01:00 •FAQ's: 00:01:00 •Introduction: 00:05:00 •Choosing Code Editor: 00:06:00 •Installing Code Editor (Sublime Text): 00:04:00 •Overview of a Webpage: 00:05:00 •Full HTML Code Page: 00:07:00 •First Hello World! Webpage: 00:09:00 •Introduction: 00:03:00 •Heading: 00:09:00 •Paragraph: 00:08:00 •Formatting Text: 00:12:00 •List Items Unordered: 00:05:00 •List Items Ordered: 00:04:00 •Classes: 00:09:00 •ID's in CSS: 00:06:00 •Comments in HTML: 00:04:00 •Summary: 00:04:00 •Introduction: 00:02:00 •Images: 00:12:00 •Forms: 00:05:00 •Form Actions: 00:04:00 •Br tag: 00:03:00 •Marquee: 00:06:00 •Text area: 00:06:00 •Tables: 00:06:00 •Links: 00:07:00 •Navbar - Menu: 00:04:00 •HTML Entities: 00:05:00 •Div tag: 00:06:00 •Google Maps: 00:07:00 •Summary: 00:02:00 •Introduction: 00:02:00 •HTML5 Audio: 00:07:00 •HTML5 Video: 00:05:00 •Progress Bar: 00:04:00 •Drag and Drop: 00:18:00 •Canvas: 00:06:00 •I frames: 00:05:00 •Input Types: 00:04:00 •Input Attributes: 00:06:00 •YouTube Video Linking: 00:04:00 •Creating Responsive Page: 00:05:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Registration Form: 00:04:00 •Login Form: 00:04:00 •About Us Form: 00:02:00 •Contact Us Form: 00:10:00 •Footer Form: 00:03:00 •Integrate All Together: 00:07:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Challenge - HTML 5 Clock Face with Numbers: 00:05:00 •Project overview: 00:03:00 •Conclusion on Project: 00:01:00 •Summary: 00:02:00 •Introduction: 00:03:00 •CSS Syntax: 00:05:00 •Creating a first page with CSS Style: 00:13:00 •Inline CSS: 00:06:00 •Internal CSS: 00:05:00 •CSS External: 00:10:00 •CSS Classes: 00:09:00 •CSS IDs: 00:06:00 •Colors: 00:08:00 •Backgrounds: 00:04:00 •Floating: 00:09:00 •Positioning: 00:06:00 •Margins: 00:07:00 •Padding: 00:04:00 •Borders: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Styling Text: 00:07:00 •Aligning Text: 00:04:00 •Styling Links: 00:10:00 •Font Family: 00:07:00 •Font Styles: 00:03:00 •Applying Google Fonts: 00:07:00 •Box Model: 00:09:00 •Icons: 00:09:00 •Tables: 00:16:00 •Navigation-Menu: 00:11:00 •Dropdowns: 00:15:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Advanced Selectors: 00:05:00 •Forms: 00:17:00 •Website Layout: 00:21:00 •Rounded Corners: 00:08:00 •Color Keywords: 00:06:00 •Animations: 00:08:00 •Pseudo Classes: 00:03:00 •Gradients: 00:03:00 •Shadows: 00:03:00 •Calculations: 00:05:00 •Creating Responsive Page: 00:06:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Button Styles: 00:06:00 •Flexbox: 00:14:00 •CSS Grid: 00:15:00 •Pagination: 00:07:00 •Multiple Columns: 00:06:00 •Image Reflection: 00:03:00 •UI - UX Design: 00:09:00 •Social Media Icons: 00:08:00 •External CSS Style adding: 00:06:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:03:00 •Summary: 00:02:00 •Introduction: 00:01:00 •CSS Project Getting: 00:05:00 •CSS Project Overview: 00:08:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Installing Free FTP Solution (FileZilla): 00:04:00 •Setting Up FTP (File Transfer Protocol): 00:03:00 •Publish Website to Hosting Server: 00:04:00 •Summary: 00:01:00

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.

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

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

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.