426 Icon courses in Cardiff delivered Online

Embarking on a Barista Skills: Coffee Training Course is essential in the modern world, whether for personal enrichment or professional growth. Mastering barista skills equips you with comprehensive knowledge about coffee, from understanding coffee beans and roasting techniques to perfecting brewing methods and latte art. These skills are highly valued in today's coffee culture, making you an attractive candidate for employment in the UK's thriving caf�� scene, where baristas can earn an average salary of £18,000 to £25,000 annually. With the coffee industry growing by 7% each year, proficiency in barista techniques opens up abundant job opportunities. Beyond job prospects, barista skills enhance daily life by enabling you to craft exquisite coffee at home, impressing friends and family. This Barista Skills: Coffee Training course covers everything from the classic coffees to the latest trends, ensuring you stay ahead in a dynamic sector. Whether aiming to become a professional barista or simply elevate your coffee-making abilities, this course offers invaluable insights and practical skills that are increasingly sought after in both personal and professional realms. Key Features: CPD Certified Barista Skills: Coffee Course Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Coffee Module 02: Coffee Beans Module 03: Coffee Roasting Module 04: Brewing Methods Module 05: Barista Skills and Techniques Module 06: The Classic Coffees Module 07: Mastering Latte Art Module 08: Coffee Menu Design and Trends Module 09: Working as a Professional Barista Learning Outcomes: Understand coffee origins, varieties, and processing techniques. Master the art of roasting beans to perfection. Explore various brewing methods for optimal flavour extraction. Develop precision and finesse in barista skills and techniques. Create iconic coffee beverages with flair and creativity. Craft intricate latte art designs to enhance customer experience. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Barista Skills: Coffee course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Barista Skills: Coffee. Moreover, this course is ideal for: Aspiring baristas seeking comprehensive coffee knowledge. Coffee enthusiasts eager to refine their brewing skills. Hospitality professionals looking to expand their expertise. Caf�� owners aiming to enhance their coffee offerings. Individuals passionate about the art and science of coffee. Requirements There are no requirements needed to enrol into this Barista Skills: Coffee course. We welcome individuals from all backgrounds and levels of experience to enrol into this Barista Skills: Coffee course. Career path After finishing this Barista Skills: Coffee course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Barista Skills: Coffee are: Barista - £17K to 25K/year. Caf�� Manager - £20K to 30K/year. Coffee Roaster - £22K to 32K/year. Coffee Trainer - £25K to 35K/year. Latte Artist - £18K to 28K/year. Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started 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 Section 02: Excel 2021: Basics 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 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools 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 Section 11: Excel 2021: Formatting data and tables 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 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts 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 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics 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 Section 16: PowerPoint 2021: Text and Bullet Options 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 Section 17: PowerPoint 2021: Adding Graphic Assets 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 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics 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 Section 28: Word 2021: Word Formatting 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 Section 29: Word 2021: Tables 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 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout 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 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing 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

Capture the cobb Lyme Regis in watercolour easily, using minimal colours and learning unusual techniques in a fun way.

Enter the creative arena of digital design with the Adobe Illustrator Diploma Course — a smartly designed programme for anyone looking to shape ideas with precision and flair. Whether you’re designing logos, illustrations, or icons, this course takes you through the essentials and advanced tools of Adobe Illustrator in a refreshingly structured way. You’ll journey through layers, paths, type tools, shapes, brushes, and more — all without getting tangled in jargon or lost in the toolbar maze. Expect an easy-to-follow format that balances clarity with cleverness. From understanding vector graphics to mastering the pen tool, this course keeps your attention with straight-talking guidance and real design know-how. If you’ve got an eye for design (or just like the idea of creating sleek visuals without drawing everything by hand), Illustrator can quickly become your favourite creative companion. No fluff. Just a solid course designed for learners who want to sharpen their digital artistry on their own time — and maybe even impress a few people along the way. Learning Outcomes: Learn to use Adobe Illustrator to create stunning digital designs Understand the fundamentals of drawing with shapes and lines Discover how to use brushes, gradients, and patterns effectively Learn how to manipulate compound paths and masks Master the techniques of vectorizing images Gain the confidence to create logos, illustrations, and graphics for print or web Course Curriculum: Module: 01 Welcome to the Course - Illustrator Essentials 2018 Download the Course Project Files Getting Started with Adobe Illustrator Drawing with Shapes and Lines The Shape Builder Tool Draw a Modern Fox with the Shape Builder Tool Draw an Impossible Shape Logo with the Shape Builder Tool The Curvature Tool The Pen Tool The Pencil Tool and Advanced Stroke Options Module: 02 Using Brushes The Width Tool Type and Font Curve Type on a Path Break Apart and Destroy Text What is RGB & CMYK Using the Eye Dropper Tool The Color Theme Tool Gradients Masking Module: 03 Compound Paths CC Libraries The Liquify Tool Bend and Warp Repeating Shapes Patterns Vectorize Images Adobe Capture App Free Templates from Adobe Saving for Print Module: 04 Exporting for Web Redrawing the Mastercard Logo Redrawing the Instagram Logo Redrawing the Kadak Logo Redrawing the eHarmony Logo Redrawing the Tinder Logo Redrawing the BP Logo Adobe Illustrator Cheat Sheet and Shortcuts Conclusion Module: 05 Activity 0 - Intro to Activities Activity 1 - Solution Activity 2 - Swan Solution Activity 3 - Colouring the Impossible Triangle Activity 4 - Drawing and Coloring the Owl Activity 5 - Drawing the Owl with the Pen Tool Activity 6 - Drawing with the Pencil Tool Activity 7 - Width Tool Love Activity 8 - Badge Activity 9 - Liquify Activity 10 - Repeating Shapes Activity 11 - Patterns Activity 12 - Vectorizing Images 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? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Graphic Designer: £22,000 - £40,000 Illustrator: £18,000 - £40,000 Art Director: £25,000 - £65,000 Web Designer: £20,000 - £45,000 Creative Director: £35,000 - £110,000 Visual Designer: £25,000 - £55,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.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Dive into the world of crochet with our Crochet Basics course. From foundational stitches to creating home accessories and fashion wearables, learn the art of crochet while prioritizing ergonomic practices. Perfect for beginners, this course is your gateway to the creative realm of crochet.

Course Overview: This course on "Flat Design in Adobe Illustrator" is designed to introduce learners to the fundamental concepts of flat design and how to apply them using Adobe Illustrator. The course covers the essential tools, techniques, and strategies needed to create visually engaging, modern flat design illustrations. Learners will explore the creation of various designs, from simple icons to complex landscapes, while developing a keen understanding of colour schemes, vector shapes, and design principles. By the end of the course, students will be able to confidently create flat design graphics, suitable for use in digital marketing, UI/UX design, and illustration projects. Course Description: In this course, learners will delve deep into the world of flat design, starting with the basics of Adobe Illustrator and progressing through to more complex design concepts. Key topics include creating diverse scenes, such as a garden, landscape, and camping scene, and designing flat icons for smartphones and apps. The course will cover essential tools and workflows in Illustrator, focusing on clean, minimalist design that is effective for web and app environments. Learners will also gain insights into balancing colour, shapes, and negative space to achieve professional and aesthetically pleasing results. Upon completion, learners will have a well-rounded skill set for designing contemporary flat style graphics in Illustrator. Course Modules: Module 01: Introduction Module 02: Create a Flat Design Garden and Barbecue Module 03: Create a Flat Design Landscape Scene Module 04: Create a Modern Flat Design Night Camping Scene Module 05: Create a Modern Flat Design Terminal and Luggage Module 06: Design a Flat Design Smartphone and App Icons (See full curriculum) Who is this course for? Individuals seeking to master flat design techniques in Adobe Illustrator. Professionals aiming to enhance their design portfolios with modern graphic styles. Beginners with an interest in graphic design and digital illustration. Anyone looking to build skills for creating digital assets like icons and visuals. Career Path: Graphic Designer UI/UX Designer Web Designer Digital Illustrator App Designer Visual Content Creator

Overview: 'Web Design for Non-Designers: A Practical Guide'   Are you a non-designer looking to create stunning websites? Look no further! Our comprehensive course, 'Web Design for Non-Designers: A Practical Guide,' is tailored just for you. With six meticulously crafted modules, this course will empower you to master the art of web design and create visually captivating websites that leave a lasting impression.   Module 1: Introduction to Web Design Dive into the fundamentals of web design, understanding its importance, principles, and basic terminology. Learn how to conceptualize your website and lay a solid foundation for your design journey.   Module 2: User Experience (UX) Design Discover the key elements of user experience design and how they impact the effectiveness of your website. From navigation to usability, learn how to create seamless experiences that keep your visitors engaged and satisfied.   Module 3: Layout and Composition Unlock the secrets of effective layout and composition in web design. Explore different grid systems, balance, and hierarchy to create visually appealing and organized layouts that enhance user engagement.   Module 4: Color Theory and Psychology Delve into the fascinating world of color theory and psychology. Understand the impact of color on emotions and behaviors, and learn how to choose the perfect color palette to evoke the desired response from your audience.   Module 5: Typography in Web Design Master the art of typography and its role in web design. Explore different font types, sizes, and styles, and learn how to use typography to enhance readability, convey hierarchy, and create a unique brand identity.   Module 6: Visual Elements in Web Design Explore the use of visual elements such as images, icons, and illustrations to enhance the visual appeal of your website. Learn how to choose and manipulate visuals effectively to convey your message and engage your audience.   With a perfect blend of theory and hands-on practical exercises, 'Web Design for Non-Designers: A Practical Guide' equips you with the knowledge and skills needed to create professional-looking websites with confidence. Whether you're a business owner, marketer, or aspiring web designer, this course is your gateway to unlocking the secrets of successful web design. Enroll now and unleash your creativity on the digital canvas! Course Curriculum Module 1_ Introduction to Web Design Introduction to Web Design 00:00 Module 2_ User Experience (UX) Design User Experience (UX) Design 00:00 Module 3_ Layout and Composition Layout and Composition 00:00 Module 4_ Color Theory and Psychology Color Theory and Psychology 00:00 Module 5_ Typography in Web Design Typography in Web Design 00:00 Module 6_ Visual Elements in Web Design Visual Elements in Web Design 00:00

Overview: Logo Design for Startups Building Strong Brand Identities   Welcome to our comprehensive Logo Design course tailored specifically for startups aiming to establish a powerful brand identity. In this program, we delve deep into the intricacies of logo creation, equipping you with the knowledge and skills necessary to craft a memorable and impactful emblem for your brand. Let's take a look at the modules included in this course:   Module 1: Introduction to Logo Design In this foundational module, we introduce you to the fundamental concepts of logo design. You'll learn about the importance of logos in branding, the key elements that make up a successful logo, and the various types of logos commonly used by businesses.   Module 2: Research and Concept Development Effective logo design begins with thorough research and concept development. In this module, we guide you through the process of conducting market research, understanding your target audience, and generating creative concepts that align with your brand's identity and values.   Module 3: Typography in Logo Design Typography plays a crucial role in logo design, conveying the personality and tone of your brand. In this module, you'll explore different types of fonts, learn about the principles of typography, and discover how to select and customize fonts to create a visually appealing and cohesive logo.   Module 4: Color Psychology and Logo Design Color has a profound impact on human emotions and perceptions, making it a powerful tool in logo design. In this module, we delve into the psychology of color, explore the meanings and associations of different colors, and teach you how to use color effectively to evoke the desired response from your audience.   Module 5: Shape, Symbolism, and Visual Elements Shapes and symbols can convey powerful messages and meanings in a logo. In this module, you'll learn about the significance of shapes and symbols in logo design, explore different visual elements such as icons and illustrations, and discover how to use them creatively to enhance your logo's impact.   Module 6: Composition and Layout The composition and layout of a logo are critical factors that contribute to its overall effectiveness. In this final module, we cover the principles of composition and layout, teach you how to create balanced and harmonious designs, and provide practical tips for optimizing your logo for various applications and platforms.   By completing this course, you'll not only gain a deep understanding of logo design principles and techniques but also acquire the practical skills needed to create a standout logo that reflects the essence of your startup and helps you build a strong brand identity in the competitive marketplace. Enroll now and take the first step towards crafting a compelling visual identity for your business! Course Curriculum Module 1_ Introduction to Logo Design Introduction to Logo Design 00:00 Module 2_ Research and Concept Development Research and Concept Development 00:00 Module 3_ Typography in Logo Design Typography in Logo Design 00:00 Module 4_ Color Psychology and Logo Design Color Psychology and Logo Design 00:00 Module 5_ Shape, Symbolism and Visual Elements Shape, Symbolism and Visual Elements 00:00 Module 6_ Composition and Layout Composition and Layout 00:00

Flash. Pose. Click. Welcome to the Fashion Photography Techniques Course, where style meets storytelling through the lens. Whether you fancy the fast pace of fashion editorials or the flair of runway drama, this course is stitched together for those who want to sharpen their eye and frame fashion in all its glory. We explore lighting tricks, visual composition, and the subtle art of guiding models to capture timeless images—no catwalk needed. Think of it as learning the language of fashion, fluently, in pixels. From iconic poses to backstage secrets of seasoned fashion photographers, this course delves into everything that makes a photo more than just a picture. It’s not just about snapping beauty—it’s about telling the story behind the outfit, capturing texture, movement, and mood. If you've ever wondered how a still image speaks volumes in a magazine spread or campaign, this is where the shutter clicks into clarity. Ideal for photography enthusiasts, fashion lovers, or anyone with a soft spot for a good snapshot—this is your digital runway to mastering the finer techniques of fashion photography. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 1: Introduction to Fashion Photography Module 2: Fashion Photography Equipment and Gear Module 3: Preparing for Fashion Photography Module 4: Fashion Styling and Art Direction Module 5: Posing and Directing Models Module 6: Fashion Shoot Production and Planning Module 7: Fashion Editing and Retouching Module 8: Fashion Photography Business and Marketing Module 9: Fashion Editorial and Commercial Photography Module 10: Fashion Photography Ethics and Sustainability Module 11: Fashion Photography Portfolio Development Learning Outcomes: Craft compelling narratives through visually stunning fashion photography. Master the technical intricacies of photography equipment and gear. Execute seamless fashion shoots with effective pre-planning strategies. Hone the skills of styling, directing, and posing models for impactful visuals. Navigate the business side of fashion photography, from marketing to ethics. Develop a standout portfolio, ready to launch a successful career in the industry. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Photography enthusiasts seeking a specialization in fashion. Aspiring fashion photographers looking to refine their skills. Creatives aiming to enter the dynamic field of fashion photography. Individuals with a passion for storytelling through visual imagery. Stylists eager to understand the visual language of fashion shoots. Students aspiring to build a solid foundation in photography. Career path Fashion Photographer Editorial Photographer Commercial Photographer Studio Photographer Freelance Photographer Fashion Stylist Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.