3992 Courses in Cardiff delivered Online

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The demand for coding essential skills is skyrocketing. The average salary for a web developer in the United Kingdom is £65,824 per year. And that number is only going to go up as more and more businesses move their operations online. If you want to get ahead in the tech industry, you need to learn how to code. This Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML course will teach you the crucial skills you need to become a web developer. You'll learn HTML, JavaScript, C#, and ASP.NET. You'll also learn how to build interactive web applications and use JavaScript to add dynamic functionality to your pages. In this Coding Essentials course, we start with an introduction to HTML, where you'll learn the basics, intermediate to advanced level topics, and explore advanced HTML techniques. Next, we dive into JavaScript, a powerful scripting language used for web development. From the fundamentals to conditional statements, control flow, functions, and error handling, you'll gain a solid understanding of JavaScript and its role in creating dynamic web pages. But that's not all! We also dive into the world of C#, a versatile and widely-used programming language. Starting with the basics, you'll progress through operators, statements, control flow, and debugging techniques. You'll also master object-oriented programming (OOPs) concepts, such as class encapsulation, inheritance, polymorphism, abstract classes, and interfaces. Our comprehensive curriculum concludes with exploring error-handling techniques in C#, ensuring you can create robust and reliable applications. Join us on this exciting coding adventure, where our experienced and expert instructors will guide you every step of the way. Don't miss this opportunity to unlock a world of possibilities and take your coding skills to new heights. Enrol in our Coding Essentials course today and unleash your coding potential! Learning Outcomes: Upon completion of the Coding Essentials course, you should be able to: Master the fundamentals of HTML for creating web pages. Gain intermediate and advanced HTML skills for enhanced web development. Understand the core concepts and syntax of JavaScript. Learn to use JavaScript to create dynamic and interactive web content. Develop proficiency in JavaScript operators and conditional statements. Explore control flow statements and error handling in JavaScript. Acquire a solid foundation in C# programming language. Learn C# operators, statements, and control flow techniques. Understand object-oriented programming (OOPs) concepts in C#. Apply C# error handling techniques for creating robust applications. Who is this course for? This Coding Essentials course is perfect for: Beginners who want to learn coding essentials from scratch. Individuals interested in web development and programming languages. Professionals seeking to enhance their coding skills and expand career opportunities. Students or graduates looking to add valuable coding skills to their resumes. Anyone with a passion for coding and a desire to create innovative applications. Career Path  Our Coding Essentials course will help you to pursue a range of career paths, such as: Web Developer: £25,000 - £50,000 per year. Software Engineer: £30,000 - £60,000 per year. Full Stack Developer: £35,000 - £70,000 per year. Front-end Developer: £25,000 - £55,000 per year. Back-end Developer: £30,000 - £60,000 per year. C# Developer: £35,000 - £70,000 per year. JavaScript Developer: £30,000 - £60,000 per year. Certification After studying the course materials of the Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Course Curriculum Introduction Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask Great Questions 00:01:00 FAQ's 00:01:00 HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 HTML Basic Heading tag 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 IDs 00:06:00 Comments 00:04:00 HTML Intermediate Images 00:12:00 Forms 00:05: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 HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:06:00 String Formatting 00:05:00 JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statement 00:04:00 JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Solution for Coding Exercise 00:02:00 JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 C# Introduction Introduction to CSharp 00:07:00 CSharp vs NET 00:04:00 What is CLR 00:05:00 Architecture of NET Application 00:09:00 Getting Visual Studio 00:07:00 First CSharp Hello World Application 00:16:00 First CSharp Core Hello World Program 00:18:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 C# Basic Variables 00:24:00 CSharp Identifiers 00:08:00 Data Types 00:08:00 Type Casting 00:14:00 User Inputs 00:10:00 Comments 00:03:00 C# Operators Arithmetic Operators 00:09:00 Assignment Operators 00:03:00 Comparison Operators 00:03:00 Logical Operators 00:03:00 Strings 00:10:00 String Properties 00:08:00 Booleans 00:06:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 C# Statements If else Conditions and Statements 00:12:00 Switch-Case Statements 00:09:00 C# Control Flow statements While Loop Statement 00:07:00 Do-While Statement 00:03:00 For Loop Statement 00:07:00 Foreach Statement 00:06:00 Break and Continue 00:03:00 C# Built-in coding Arrays 00:13:00 Loop Through Arrays 00:10:00 Lists 00:07:00 SystemIO Namespace 00:03:00 Datetime 00:10:00 TimeSpan 00:06:00 C# Debugging techniques Debugging Tools in Visual Studio 00:13:00 Call Stack Window 00:04:00 Locals and Autos 00:04:00 C# Object-oriented programming [OOPs] Introduction to Class 00:03:00 Create a Class 00:15:00 Object Initializers 00:16:00 Parameters 00:12:00 Access Modifiers(theory) 00:13:00 C# Methods Introduction to methods 00:06:00 Create a method 00:16:00 Method with parameters 00:09:00 Method default and multiple parameters 00:09:00 Method return keyword 00:07:00 Method Over loading 00:08:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 C# Class Encapsulation Introduction to OOPs 00:04:00 Classes and Objects 00:11:00 Class Members 00:10:00 Class Constructors 00:14:00 Access Modifiers 00:11:00 Properties Get Set 00:06:00 Encapsulation 00:03:00 C# Inheritance and Polymorphism Intro Inheritance and Polymorphism 00:03:00 Inheritance 00:12:00 Polymorphism 00:13:00 Assessment Test 00:02:00 Solution for Assessment Test 00:03:00 C# Abstract and Interfaces Introduction 00:02:00 Abstraction 00:07:00 Interfaces 00:07:00 Enums 00:05:00 C# Error Handling Techniques Try Catch 00:10:00 Custom message on Errors 00:05:00 Finally 00:06:00 Throw keyword 00:09:00 Coding Exercise 00:02:00

Course Overview This course on Self Confidence & Self Esteem is designed to help individuals understand and enhance their self-belief. It focuses on practical methods and strategies to cultivate confidence and improve self-esteem. Learners will gain a deeper understanding of how confidence impacts personal and professional success, and they will explore tools to boost their confidence levels. By the end of the course, learners will be equipped with the knowledge and mindset needed to build lasting self-esteem and project confidence in various aspects of life. Course Description This course covers the fundamentals of self-confidence and self-esteem, providing a thorough understanding of the psychological aspects that influence these traits. Learners will explore various confidence-building strategies, with an emphasis on developing a positive mindset and maintaining self-belief in challenging situations. The course includes reflective activities to help individuals assess their current levels of confidence and implement effective methods to improve. Key areas of focus include overcoming self-doubt, setting personal goals, and learning how to build self-worth, all of which are integral to fostering lasting self-esteem. By the end of this course, learners will be able to apply their new skills to enhance their personal growth and professional success. Course Modules Module 01: Introduction Module 02: Understanding Confidence Module 03: Developing the Right Mindset to Gain Confidence Module 04: Build Confidence: Strategies That Work Module 05: Quick Activity to Build Your Confidence Module 06: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their self-confidence. Professionals aiming to develop stronger self-esteem for career growth. Beginners with an interest in personal development. Anyone wanting to overcome self-doubt and embrace positive self-image. Career Path Personal Development Coach HR Professional Sales Executive Leadership and Management Roles Motivational Speaker

Course Overview: This course provides a comprehensive introduction to cryptocurrencies, blockchain technology, and their broader implications in the financial world. Learners will gain an understanding of how cryptocurrencies work, the underlying technology of blockchain, and the variety of available cryptocurrencies. The course also explores the future potential of cryptocurrencies, including opportunities in decentralised finance (DeFi) and NFTs. Upon completion, learners will be equipped with the knowledge to navigate the rapidly evolving cryptocurrency market, make informed investment decisions, and understand the legal landscape in the UK. Course Description: This course covers a wide range of topics essential to understanding the world of cryptocurrencies. Learners will delve into the fundamentals of cryptocurrencies and blockchain technology, exploring how decentralised systems work. The course introduces various types of cryptocurrencies, their uses, and the role of NFTs in the digital space. Learners will also cover the critical aspects of cryptocurrency wallets, security measures, and how decentralised finance is reshaping financial systems. The course also includes modules on cryptocurrency investment strategies and the evolving legal frameworks in the UK. By the end of the course, learners will have a solid understanding of the cryptocurrency ecosystem and its future trajectory. Course Modules: Module 01: The Fundamentals of Cryptocurrencies Module 02: The Blockchain Module 03: Types of Cryptocurrencies Module 04: NFTs Module 05: Cryptocurrency Wallets Module 06: Cryptocurrency Security Module 07: Decentralised Finance Module 08: Investing in Cryptos Module 09: Opportunities and Future of Cryptocurrencies Module 10: Cryptocurrency Laws in the UK (See full curriculum) Who is this course for? Individuals seeking to understand the basics of cryptocurrencies Professionals aiming to expand their knowledge in blockchain technology Beginners with an interest in digital finance and investment opportunities Anyone looking to stay informed about future trends in cryptocurrency Career Path: Cryptocurrency Analyst Blockchain Developer DeFi Specialist Investment Advisor (Cryptocurrencies) Financial Consultant Legal Advisor for Cryptocurrency Regulations

Course Overview The CCTV Operator Course is designed to equip learners with the knowledge and skills required to operate CCTV systems effectively and efficiently. This comprehensive course covers the essential aspects of CCTV operations, focusing on the operational requirements, technical guidance, and regulatory standards. Learners will gain an understanding of how to monitor surveillance systems, ensure data protection compliance, and meet job requirements. By the end of the course, learners will be prepared to manage surveillance systems with confidence, supporting security operations across various industries. Course Description This course delves into the various aspects of CCTV operations, from understanding basic system components to applying data protection regulations in practice. Key topics include the operational requirements of CCTV systems, the technical aspects of monitoring and surveillance, and the necessary skills for effective performance in the role. Learners will also gain an understanding of data protection regulations, such as GDPR, and learn the requirements specific to CCTV operators. Throughout the course, learners will be introduced to the different job responsibilities and the critical competencies required to succeed in this field. Course Modules Module 01: Operational Requirement Module 02: CCTV Operator Skills and Ability Module 03: Basics of CCTV Module 04: Technical Guidance Module 05: Monitoring CCTV Cameras Module 06: Watch Surveillance Module 07: Data Protection Regulations Module 08: Job Requirements of a CCTV Operator (See full curriculum) Who is this course for? Individuals seeking to pursue a career in security operations. Professionals aiming to enhance their expertise in CCTV monitoring. Beginners with an interest in surveillance and security. Anyone interested in gaining qualifications in security operations. Career Path CCTV Operator Security Surveillance Specialist Security Manager Facility Security Supervisor Operations Manager in Security Systems Compliance Officer in Security Operations

Course Overview The "DIY Home Improvement" course provides an in-depth exploration of various home improvement projects, equipping learners with the knowledge to enhance their homes. Covering a wide range of topics from basic painting and wall repairs to more complex plumbing and electrical tasks, this course offers practical skills that are directly applicable to everyday home maintenance. Learners will gain the confidence to undertake home improvement projects, understand safety protocols, and manage issues such as damp and pest control effectively. The course aims to foster self-sufficiency in home care, empowering individuals to improve their living spaces efficiently. Course Description This course delves into the core aspects of DIY home improvement, beginning with an introduction to essential tools and techniques, followed by detailed lessons on painting, wall repairs, door and window installation, and electrical fixture adjustments. Learners will explore plumbing basics and how to address common issues like damp, rots, and pests. Safety is also emphasised, ensuring that learners understand how to safeguard themselves and their homes during projects. By the end of the course, participants will have developed a comprehensive understanding of home maintenance and improvement, allowing them to tackle a variety of domestic challenges with confidence and competence. Course Modules Module 01: Introduction to Home Improvement Module 02: Paint Job Module 03: Walls Module 04: Doors and Windows Module 05: Electrical Fixtures Module 06: Outdoor Projects Module 07: Plumbing Module 08: Damp, Rots, and Pests Module 09: Home Safety (See full curriculum) Who is this course for? Individuals seeking to improve their homes with cost-effective solutions. Professionals aiming to expand their home maintenance skills. Beginners with an interest in home improvement and maintenance. Homeowners looking to enhance their property value. Career Path Home Improvement Specialist Property Maintenance Manager DIY Consultant Home Renovation Project Manager Estate Agent or Property Manager (specialising in home improvements)

Course Overview "Stock Trading Analysis with Volume Trading" is designed to provide learners with a comprehensive understanding of how to leverage volume analysis in stock trading. This course covers essential volume indicators, strategies, and techniques, empowering learners to make informed trading decisions. The course aims to enhance trading skills by explaining how volume trends can influence stock price movements, offering learners practical insights into market behaviour. By the end of the course, learners will have the ability to interpret volume data, use it to spot market trends, and apply it within their trading strategies, enhancing their confidence and decision-making capabilities in stock trading. Course Description This course delves into the critical aspect of volume analysis in stock trading, providing a thorough exploration of how trading volume can provide valuable market insights. Learners will study various volume indicators and their applications, uncover trading strategies that incorporate volume as a key factor, and gain the skills necessary to identify profitable market movements. The course also includes practical examples and analysis to demonstrate how volume impacts stock trends, while familiarising learners with the tools used in volume trading. By completing this course, learners will develop the expertise to utilise volume trading strategies to enhance their trading performance and make more informed decisions in real-time market scenarios. Course Modules Module 01: Volume Analysis Module 02: Volume Studies and Indicators Module 03: Volume Trading Strategies and Techniques Module 04: Examples and Analysis Module 05: Trading Platform (See full curriculum) Who is this course for? Individuals seeking to enhance their stock trading skills Professionals aiming to develop expertise in volume trading strategies Beginners with an interest in stock market analysis Anyone looking to understand the role of volume in trading decisions Career Path Stock Trader Financial Analyst Investment Advisor Trading Platform Specialist Portfolio Manager

Course Overview This course on "Capital Budgeting & Investment Decision Rules" provides a comprehensive foundation in the key concepts and techniques used in evaluating long-term investments. Covering fundamental methods such as Net Present Value (NPV), Payback Period, and Internal Rate of Return (IRR), the course explores how businesses make critical decisions on capital allocation. Learners will gain a deep understanding of the tools used to assess the financial viability of projects, ensuring they can apply these methods in real-world situations. This course is designed to equip professionals with the knowledge to evaluate investment opportunities effectively and contribute to strategic decision-making. Course Description The "Capital Budgeting & Investment Decision Rules" course delves into essential financial decision-making techniques used by organisations to evaluate potential investments. Topics include the NPV method, Payback Period, IRR, and how to assess projects with varying timelines. Learners will explore the advantages and limitations of each method and understand their applications in different business contexts. The course also covers the evaluation of projects with different durations and how to select the best investment strategies to achieve organisational goals. Through this learning experience, participants will acquire the analytical skills necessary to make informed capital budgeting decisions, ultimately strengthening their financial decision-making acumen. Course Modules Module 01: Introduction Module 02: NPV Method Module 03: Payback Period Method Module 04: Internal Rate of Return (IRR) Module 05: Evaluating Projects in Different Lives Module 06: Conclusion (See full curriculum) Who is this course for? Individuals seeking to understand capital budgeting methods. Professionals aiming to enhance their financial analysis skills. Beginners with an interest in finance and investment decision-making. Anyone looking to develop their knowledge in investment evaluation techniques. Career Path Financial Analyst Investment Analyst Corporate Finance Professional Project Manager Risk Manager Business Consultant

A writing workshop to release stress, explore our shadows and reveal our creative force.

Delve into the world of data analysis with 'R Programming for Data Science,' a course designed to guide learners through the intricacies of R, a premier programming language in the data science domain. The course opens with a broad perspective on data science, illuminating the pivotal role of R in this field. Learners are then introduced to R and RStudio, equipping them with the foundational tools and interfaces essential for R programming. The curriculum progresses with an introduction to the basics of R, ensuring learners grasp the core principles that underpin more complex operations. A highlight of this course is its in-depth exploration of R's versatile data structures, including vectors, matrices, factors, and data frames. Each unit is crafted to provide learners with a comprehensive understanding of these structures, pivotal for effective data handling and manipulation. The course also emphasizes the importance of relational and logical operators in R, key elements for executing data operations. As the course advances, learners will engage with the nuances of conditional statements and loops, essential for writing efficient and dynamic R scripts. Moving into more advanced territories, the course delves into the creation and usage of functions, an integral part of R programming, and the exploration of various R packages that extend the language's capabilities. Learners will also gain expertise in the 'apply' family of functions, crucial for streamlined data processing. Further units cover regular expressions and effective strategies for managing dates and times in data sets. The course concludes with practical applications in data acquisition, cleaning, visualization, and manipulation, ensuring learners are well-prepared to tackle real-world data science challenges using R. Learning Outcomes Develop a foundational understanding of R's role in data science and proficiency in RStudio. Gain fluency in R programming basics, enabling the handling of complex data tasks. Acquire skills in managing various R data structures for efficient data analysis. Master relational and logical operations for advanced data manipulation in R. Learn to create functions and utilize R packages for expanded analytical capabilities. Why choose this R Programming for Data Science course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this R Programming for Data Science course for? Beginners in data science eager to learn R programming. Data analysts and scientists looking to enhance their skills in R. Researchers in various fields requiring advanced data analysis tools. Statisticians seeking to adopt R for more sophisticated data manipulations. Professionals in finance, healthcare, and other sectors needing data-driven insights. Career path Data Scientist (R Expertise): £30,000 - £70,000 Data Analyst (R Programming Skills): £27,000 - £55,000 Bioinformatics Scientist (R Proficiency): £35,000 - £60,000 Quantitative Analyst (R Knowledge): £40,000 - £80,000 Research Analyst (R Usage): £25,000 - £50,000 Business Intelligence Developer (R Familiarity): £32,000 - £65,000 Prerequisites This R Programming for Data Science does not require you to have any prior qualifications or experience. You can just enrol and start learning.This R Programming for Data Science was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Data Science Overview Introduction to Data Science 00:01:00 Data Science: Career of the Future 00:04:00 What is Data Science? 00:02:00 Data Science as a Process 00:02:00 Data Science Toolbox 00:03:00 Data Science Process Explained 00:05:00 What's next? 00:02:00 Unit 02: R and RStudio Engine and coding environment 00:03:00 Installing R and RStudio 00:04:00 RStudio: A quick tour 00:04:00 Unit 03: Introduction to Basics Arithmetic with R 00:03:00 Variable assignment 00:04:00 Basic data types in R 00:03:00 Unit 04: Vectors Creating a vector 00:05:00 Naming a vector 00:04:00 Arithmetic calculations on vectors 00:07:00 Vector selection 00:06:00 Selection by comparison 00:04:00 Unit 05: Matrices What's a Matrix? 00:02:00 Analyzing Matrices 00:03:00 Naming a Matrix 00:05:00 Adding columns and rows to a matrix 00:06:00 Selection of matrix elements 00:03:00 Arithmetic with matrices 00:07:00 Additional Materials 00:00:00 Unit 06: Factors What's a Factor? 00:02:00 Categorical Variables and Factor Levels 00:04:00 Summarizing a Factor 00:01:00 Ordered Factors 00:05:00 Unit 07: Data Frames What's a Data Frame? 00:03:00 Creating Data Frames 00:20:00 Selection of Data Frame elements 00:03:00 Conditional selection 00:03:00 Sorting a Data Frame 00:03:00 Additional Materials 00:00:00 Unit 08: Lists Why would you need lists? 00:01:00 Creating a List 00:06:00 Selecting elements from a list 00:03:00 Adding more data to the list 00:02:00 Additional Materials 00:00:00 Unit 09: Relational Operators Equality 00:03:00 Greater and Less Than 00:03:00 Compare Vectors 00:03:00 Compare Matrices 00:02:00 Additional Materials 00:00:00 Unit 10: Logical Operators AND, OR, NOT Operators 00:04:00 Logical operators with vectors and matrices 00:04:00 Reverse the result: (!) 00:01:00 Relational and Logical Operators together 00:06:00 Additional Materials 00:00:00 Unit 11: Conditional Statements The IF statement 00:04:00 IFELSE 00:03:00 The ELSEIF statement 00:05:00 Full Exercise 00:03:00 Additional Materials 00:00:00 Unit 12: Loops Write a While loop 00:04:00 Looping with more conditions 00:04:00 Break: stop the While Loop 00:04:00 What's a For loop? 00:02:00 Loop over a vector 00:02:00 Loop over a list 00:03:00 Loop over a matrix 00:04:00 For loop with conditionals 00:01:00 Using Next and Break with For loop 00:03:00 Additional Materials 00:00:00 Unit 13: Functions What is a Function? 00:02:00 Arguments matching 00:03:00 Required and Optional Arguments 00:03:00 Nested functions 00:02:00 Writing own functions 00:03:00 Functions with no arguments 00:02:00 Defining default arguments in functions 00:04:00 Function scoping 00:02:00 Control flow in functions 00:03:00 Additional Materials 00:00:00 Unit 14: R Packages Installing R Packages 00:01:00 Loading R Packages 00:04:00 Different ways to load a package 00:02:00 Additional Materials 00:00:00 Unit 15: The Apply Family - lapply What is lapply and when is used? 00:04:00 Use lapply with user-defined functions 00:03:00 lapply and anonymous functions 00:01:00 Use lapply with additional arguments 00:04:00 Additional Materials 00:00:00 Unit 16: The apply Family - sapply & vapply What is sapply? 00:02:00 How to use sapply 00:02:00 sapply with your own function 00:02:00 sapply with a function returning a vector 00:02:00 When can't sapply simplify? 00:02:00 What is vapply and why is it used? 00:04:00 Additional Materials 00:00:00 Unit 17: Useful Functions Mathematical functions 00:05:00 Data Utilities 00:08:00 Additional Materials 00:00:00 Unit 18: Regular Expressions grepl & grep 00:04:00 Metacharacters 00:05:00 sub & gsub 00:02:00 More metacharacters 00:04:00 Additional Materials 00:00:00 Unit 19: Dates and Times Today and Now 00:02:00 Create and format dates 00:06:00 Create and format times 00:03:00 Calculations with Dates 00:03:00 Calculations with Times 00:07:00 Additional Materials 00:00:00 Unit 20: Getting and Cleaning Data Get and set current directory 00:04:00 Get data from the web 00:04:00 Loading flat files 00:03:00 Loading Excel files 00:05:00 Additional Materials 00:00:00 Unit 21: Plotting Data in R Base plotting system 00:03:00 Base plots: Histograms 00:03:00 Base plots: Scatterplots 00:05:00 Base plots: Regression Line 00:03:00 Base plots: Boxplot 00:03:00 Unit 22: Data Manipulation with dplyr Introduction to dplyr package 00:04:00 Using the pipe operator (%>%) 00:02:00 Columns component: select() 00:05:00 Columns component: rename() and rename_with() 00:02:00 Columns component: mutate() 00:02:00 Columns component: relocate() 00:02:00 Rows component: filter() 00:01:00 Rows component: slice() 00:04:00 Rows component: arrange() 00:01:00 Rows component: rowwise() 00:02:00 Grouping of rows: summarise() 00:03:00 Grouping of rows: across() 00:02:00 COVID-19 Analysis Task 00:08:00 Additional Materials 00:00:00 Assignment Assignment - R Programming for Data Science 00:00:00