25794 Courses in Cardiff delivered Online

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 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 Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 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 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00

Course Overview Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers. In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text.  This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user. Learning Outcomes Learn how to navigate between worksheets using shortcut keys Understand the process of creating a custom autofill list and importing data from webpages Build the skills to hide workbook elements Enrich your understanding of advanced transpose Grasp the techniques of moving cell directions and deleting data Know how to convert text to numbers Who is this course for? This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills. 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. Certification After you have successfully completed the course, 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 hardcopy 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 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Administrative Assistant Data Analyst Accountants Financial Analyst Retail Store Manager Project Manager Business Analyst Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

HACCP course aims to provide learners with an understanding of HACCP (Hazard Analysis and Critical Control Points) principles and practical applications in the food industry through classroom learning and hands-on activities.

“Empower yourself with our Cybersecurity: Understand Threats and Prevent Attacks course. Gain vital insights into cybersecurity threats and effective prevention strategies to safeguard your digital assets.”

Master derivative calculus with ease in our “Engineering Calculus Made Simple (Derivatives)” course. Dive into essential concepts and applications, empowering yourself to solve engineering problems with confidence.

Master the art of ESL teaching with our comprehensive guide. Explore teaching methods, phonics, and classroom management, plus insights on teaching and traveling in Asia.

Master symmetrical components for precise three-phase power analysis in our Electrical Engineering Course. Gain expertise in analyzing and interpreting complex power systems with hands-on training in symmetrical components.

Course Overview The Professional Photography course provides a comprehensive journey into the world of photography, blending creative techniques with technical understanding. This course covers everything from mastering exposure and digital photography to exploring specialist scenarios such as portraits, landscapes, macro, and aerial photography. Learners will gain an in-depth understanding of camera anatomy, lighting, white balance, and post-production editing using industry-standard tools like Photoshop and Lightroom. Whether learners wish to enhance personal skills or pursue professional ambitions, this course equips them with the expertise to produce high-quality photographic work. By the end of the course, learners will be able to demonstrate proficiency across diverse photography styles, effectively manage photography equipment, and refine their editing capabilities. In addition, guidance on starting a photography business and selling work will support those looking to monetise their skills. This course offers valuable knowledge for both career development and personal enrichment in the creative industry. Course Description This course delves deeply into the art and science of photography, providing learners with a structured pathway to master both foundational principles and advanced techniques. Beginning with an introduction to camera settings, exposure, and digital photography, it progresses through specialised topics including focus and depth of field, lighting control, and the use of various photographic equipment. Learners will engage with diverse photography scenarios such as street photography, events, wildlife, and product shoots, developing a versatile skill set suitable for a range of professional contexts. The curriculum also explores post-processing with software such as Photoshop CC, Lightroom Classic CC, and mobile editing tools like Snapseed and Photoshop Express. Furthermore, modules on business development and stock photography sales offer valuable insights into potential income streams. Delivered in an engaging and accessible format, this course ensures that learners acquire both creative and technical expertise, setting a strong foundation for future opportunities in photography. Course Modules Module 01: Introduction Module 02: Exposure Module 03: Digital Photography Masterclass Module 04: Focus and Depth of Field Module 05: Camera Anatomy Module 06: White Balance and Colour Module 07: Lighting Module 08: Mobile Photography Module 09: Equipment – Cameras Module 10: Equipment – Lenses Module 11: Equipment – Accessories Module 12: Photo Scenario – Portrait Module 13: Photo Scenario – Long Exposure Module 14: Photo Scenario – Landscape Module 15: Photo Scenario – Product Module 16: Photo Scenario – Low Light Module 17: Photo Scenario – Sports & Action Module 18: Photo Scenario – Macro Module 19: Photo Scenario – Street & Architecture Module 20: Photo Scenario – Events Module 21: Photo Scenario – Aerial Module 22: Photo Scenario – Night Module 23: Introduction to Photo Editing Module 24: Photoshop CC Module 25: Lightroom Classic CC Module 26: Lightroom CC Module 27: Mac Photos Module 28: Google Photos Module 29: Photoshop Express Module 30: Snapseed Module 31: Sharing Your Photos Module 32: Starting a Photo Business Module 33: Selling Stock Photos Module 34: Printing Module 35: Wildlife Module 36: Conclusion (See full curriculum) Who is this course for? Individuals seeking to develop creative and technical photography skills. Professionals aiming to expand their visual media expertise. Beginners with an interest in photography and digital editing. Entrepreneurs wishing to build a photography business. Hobbyists looking to refine their photographic techniques. Career Path Professional Photographer Freelance Photojournalist Event and Wedding Photographer Wildlife Photographer Digital Content Creator Stock Photography Contributor Photography Business Owner Visual Media Consultant

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Video Animation With Vyond - Basics will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Video Animation With Vyond - Basics will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Video Animation With Vyond - Basics and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Video Animation With Vyond - Basics is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Video Animation With Vyond - Basics. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Video Animation With Vyond - Basics will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Video Animation With Vyond - Basics Lesson 01: Overview 00:02:00 Lesson 02: Pricing 00:02:00 Lesson 03: Vyond Resources 00:02:00 Lesson 04: Interface and Timeline 00:03:00 Lesson 05: Adding Templates 00:03:00 Lesson 06: Character Library 00:03:00 Lesson 07: Character Properties - Part1 00:03:00 Lesson 08: Character Properties - Part 2 00:03:00 Lesson 09: Character Properties - Part 3 00:03:00 Lesson 10: Prop Library 00:03:00 Lesson 11: Prop Properties 00:02:00 Lesson 12: Chart Properties - Part 1 00:02:00 Lesson 13: Chart Properties - Part 2 00:03:00 Lesson 14: Text Library 00:02:00 Lesson 15: Text Properties 00:02:00 Lesson 16: Scene Transitions 00:02:00 Lesson 17: Differences with Whiteboard Animation - Part 1 00:04:00 Lesson 18: Differences with Whiteboard Animation - Part 2 00:03:00 Lesson 19: Adding in the Camera to Zoom In 00:04:00 Lesson 20: Conclusion 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Advanced Digital Painting Course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Advanced Digital Painting Course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Advanced Digital Painting Course and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Advanced Digital Painting Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Advanced Digital Painting Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Advanced Digital Painting Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Document in Photoshop, make a basic Sketch and Make an underpainting. Set up a new document 00:02:00 Studying Dutch Masters 00:07:00 Creating a Composition with reference photos 00:05:00 Basic sketch for Background Painting 00:06:00 Underpainting in Grey tones 00:13:00 Section 02: Painting the River, Sea and Sky with Clouds Foreground Sketch 00:08:00 Painting the Clouds in the sky 00:07:00 Background Mountains Part 1 00:09:00 Placing the Planet 00:03:00 Background Mountains Part 2 00:05:00 Background Mountains Right 00:11:00 Section 03: Paint a sea, Rocks the River and the Main Arch. Painting the Sea 00:08:00 Balanced Rock 00:10:00 The River 00:08:00 The Arch Completed 00:07:00 Section 04: Create some life in our Sci-Fi World and Paint a Spaceship with the Pentool Pentool Part 1 00:06:00 Pentool Part 2 00:03:00 Pentool Part 3 00:05:00 Building a Spaceship 00:14:00 The Spaceship 00:11:00 Placing the Spaceship and Astronauts 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00