2533 Courses in Cardiff delivered On Demand

Description: As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an edge in your professional career. This Microsoft Excel 2010 complete course is created to help you in learning all the functions and features of this program. Whether you are a beginner, intermediate and advanced level user, this course will help you in learning all the necessary skills, knowledge, and information about the Microsoft Excel. You will learn how to plan and organise your data using the tools in this program. You will know how to use the functions of Microsoft Excel that will help you in finishing your tasks effectively.This course will provide you with the necessary skills, knowledge and information of Microsoft Excel.  Who is the course for? Professionals who want to learn all about Microsoft Excel 2010 program. People who have an interest in knowing all the functions and features of Microsoft Excel. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel 2010 - Beginners, Intermediate, Advanced course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accountant Account Assistant Administrative Assistant Administrator Bookkeeper Office Manager Personal Assistant Secretary. Microsoft Excel 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 for Beginners 00:00:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel 2010 Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Merge the worlds of Electrical Engineering and Trigonometry with our comprehensive course. Gain practical skills and theoretical knowledge to excel in the field.

The main outcome of this training course is to provide you with the knowledge to carry out the functions of a fire marshal. - Please note, this course also contains all of the content in the Basic Fire Awareness and Fire Extinguisher courses.

Whether you're a beginner looking to start your coding journey or an experienced developer aiming to dive into data science and machine learning, this comprehensive course has you covered. In this Python bundle, you'll embark on a transformative learning journey through 11 carefully curated courses. First, you'll lay the foundation with "Python Programming: Python Coding Essential Training," where you'll grasp the fundamentals of Python coding. Then, you'll advance into the world of data with the "Data Structures Complete Course," equipping you with the skills to manipulate and manage data efficiently. But that's just the beginning. With courses spanning data science, machine learning, cloud computing, SQL programming, business intelligence, and critical thinking, this bundle is your passport to a versatile skill set that's in high demand. By enrolling in this course, you're investing in a brighter future, gaining the knowledge and expertise that will open doors to exciting career opportunities and enable you to tackle real-world challenges. Don't miss out on this chance to become a Python powerhouse and shape your professional destiny. This Python Powerhouse: Python Bundle Course for All Levels Bundle Consists of the following Premium courses: Course 01: Python Programming: Python Coding Essential Training Course 02: Data Structures Complete Course Course 03: Data Science with Python Course 04: Data Science & Machine Learning with Python Course 05: Python for Data Analysis Course 06: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 07: SQL Programming Complete Bundle Course 08: Higher Order Functions in Python - Level 03 Course 09: Basic Google Data Studio Course 10: Business Intelligence and Data Mining Masterclass Course 11: Decision Making and Critical Thinking Learning Outcomes Upon completion of this bundle, you should be able to: Develop a solid foundation in Python programming, enabling them to apply coding skills efficiently. Acquire a deep understanding of data structures and their applications in healthcare data management. Master the use of Python for data science, allowing them to analyse healthcare data and extract valuable insights. Explain SQL programming, which is crucial for handling healthcare databases and managing patient information securely. Explore higher-order functions in Python, enhancing their problem-solving skills and programming capabilities. Develop basic proficiency in Google Data Studio, a valuable tool for visualising healthcare data. Master business intelligence and data mining techniques are specific to the healthcare industry. "Python Powerhouse: Python Bundle Course for All Levels" is your gateway to mastering Python and unleashing its potential across various domains. This comprehensive course comprises 11 meticulously designed modules, each geared towards equipping learners with essential skills and knowledge. Starting with "Python Programming: Python Coding Essential Training," you'll build a strong foundation in Python, a programming language known for its versatility and widespread use. As you progress through the "Data Structures Complete Course," you'll delve into the world of efficient data manipulation, a fundamental skill applicable in numerous professional settings. One of the highlights of this bundle is "Data Science with Python," which empowers learners to harness Python's capabilities for data analysis. In "Data Science & Machine Learning with Python," you'll take the next step, exploring advanced techniques that are vital in today's data-driven world. Furthermore, "Python for Data Analysis" enhances your proficiency in making data-driven decisions. Beyond data, you'll gain expertise in cloud computing, SQL programming, higher-order functions in Python, Google Data Studio, business intelligence, and critical thinking - all essential skills that can open doors to a multitude of career opportunities. This course is your passport to a fulfilling career by providing a comprehensive toolkit to excel in various domains and industries. Don't miss the chance to become a Python powerhouse and shape your professional destiny. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is tailored for: Data Enthusiasts Intermediate Python Developers Data Visualisation Enthusiasts Aspiring Business Analysts Anyone interested in Python Requirements No requirements to enrol this Python Powerhouse: Python Bundle Course for All Levels course. Career path Upon completion, various career opportunities include: Software Developer (Average salary range of £35,000 to £70,000) Data Analyst (Average salary range of £25,000 and £60,000.) Machine Learning Engineer (Average salary range of £45,000 to £80,000) Web Developer (Average salary range of £30,000 to £65,000) Research Scientist (Average salary range of £40,000 to £75,000) Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Python Programming: Python Coding Essential Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Take your Python programming knowledge several notches higher with this advanced training course designed for learners who already speak Python fluently—but want to speak it better. This course delves into deeper aspects of the language, brushing aside the basics and stepping into the more elegant, expressive, and efficient use of Python. From working confidently with decorators, generators, and closures, to understanding asynchronous programming and advanced data structures—this course is tailored for those who want their code to do more, with less. Python may be known for its simplicity, but once you scratch beneath the surface, there’s an entire world of finesse waiting to be explored. Whether you’re brushing up for senior-level roles, fine-tuning your automation skills, or aiming to make your code leaner and smarter—this course offers a structured approach to tackling the tricky bits of Python with a touch of confidence and a dash of clarity. Let’s just say, if Python had an upper crust, you’re about to join it. Learning Outcomes: Gain a deeper understanding of advanced-level Python concepts. Learn how to work with files and handle advanced file operations. Discover how to create and use Python classes to write efficient and maintainable code. Understand how to use library functions to streamline your workflow and take your Python development skills to the next level. Learn how to use Python to build real-world projects and applications. The Python Advanced Training course is designed to provide you with the skills and knowledge you need to become a proficient Python developer. Whether you're a beginner or an experienced programmer looking to enhance your Python skills, this course is perfect for you. Starting with the basics of file handling and moving on to more advanced topics, such as classes and library functions, this course covers everything you need to know to become a master Python developer. You'll learn how to handle advanced file operations, create and use Python classes to write efficient and maintainable code and use library functions to streamline your workflow and take your Python development skills to the next level. Python Advanced Training Course Curriculum Section 01: Introduction Section 02: File Handling Section 03: Python Classes Section 04: Library Functions How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Python developers who want to expand their knowledge of advanced Python concepts. Programmers who want to enhance their Python skills and build real-world projects. Entrepreneurs who want to develop their own Python-based applications. Students who want to enhance their Python skills and prepare for a career in programming. Anyone who wants to take their Python programming skills to the next level. Career path Python Developer: £28,000 - £55,000 Data Analyst: £24,000 - £45,000 Software Engineer: £28,000 - £60,000 Technical Lead: £40,000 - £90,000 Chief Technology Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: Acquire a foundational understanding of SQL, its role, and importance in database management. Master the creation, organization, and manipulation of databases. Implement constraints to ensure data integrity and enforce business rules. Utilize SQL functions to transform and manipulate data effectively. Employ SQL clauses to filter, sort, and analyze data for specific purposes. Perform alterations on databases and tables to accommodate evolving data needs. Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. Harness the power of wild cards to perform flexible and dynamic data searches. Why buy this SQL Database Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL Database Management 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. Who is this course for? This SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring Database Administrators and SQL Developers. Software Engineers Seeking Proficiency in SQL for Application Development. Data Analysts and Business Intelligence Professionals. IT Professionals Looking to Enhance Their Database Management Skills. Prerequisites This SQL Database Management 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. Career path SQL Developer - $70,000 to $110,000/year. Database Administrator - $60,000 to $100,000/year. Data Analyst - $60,000 to $90,000/year. Business Intelligence Developer - $70,000 to $120,000/year. Database Manager - $80,000 to $130,000/year. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00

The course helps you learn Snowflake from scratch and explore a few of its important features. You will build automated pipelines with Snowflake and use the AWS cloud with Snowflake as a data warehouse. You will also explore Snowpark to be worked on the data pipelines.

In this practical, hands-on course, you'll learn how to use R for effective data analysis and visualization and how to make use of that data in a practical manner. You will learn how to install and configure software necessary for a statistical programming environment and describe generic programming language concepts as they are implemented in a high-level statistical language.

Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.   In this Microsoft SQL Server Development for Everyone! course, you'll learn the basics of SQL Server development. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write SQL queries to manipulate data.   Starting with a solid Introduction to SQL, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.   But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.   To become a well-rounded SQL Server developer, we'll conclude the course with Advanced SQL Server Objects and Concepts. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.   By the end of this Microsoft SQL Server Development for Everyone! course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!   Learning Outcomes: Through this comprehensive course, you should be able to:   Understand core concepts and gain a strong foundation in SQL Server development. Acquire skills to effectively manipulate tables and data. Establish relationships and enforce data integrity using foreign keys. Utilise group by and aggregate functions for efficient data analysis. Explore advanced SQL Server objects and concepts like stored procedures and views. Gain proficiency in implementing triggers and optimising database performance. Develop the ability to create robust and reliable databases.   Who is this course for? This Microsoft SQL Server Development for Everyone! course is perfect for:   Aspiring developers looking to enhance their programming skills. Professionals seeking to expand their knowledge of SQL Server development. Individuals interested in exploring the world of databases and data management. Students or graduates pursuing a career in database administration or development. Curious learners eager to harness the power of SQL Server.   Career Path Our course will help you to pursue a range of careers, including:   Database Administrator: £25,000 - £60,000 per year. SQL Developer: £30,000 - £65,000 per year. Data Analyst: £25,000 - £55,000 per year. Business Intelligence Developer: £35,000 - £70,000 per year. Software Engineer: £30,000 - £70,000 per year. Data Engineer: £40,000 - £80,000 per year. Database Architect: £45,000 - £90,000 per year. Certification After studying the course materials of the Microsoft SQL Server Development for Everyone! 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 Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft SQL Server Development for Everyone! 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 to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Assignment Assignment - Microsoft SQL Server Development for Everyone! 00:00:00

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!