519 Icon courses

Web applications shape the digital world we interact with daily—from the simplest online form to complex platforms driving entire businesses. This course is designed for those who are eager to specialise in building, maintaining, and optimising web-based systems. Whether you're familiar with HTML or curious about frameworks and database logic, this course steadily guides you through the layers of modern web application architecture. You’ll explore front-end and back-end development concepts, delve into programming essentials, and gain insights into how dynamic web environments function behind the scenes. If you're aiming to deepen your understanding and sharpen your development capabilities in a focused, structured format—this is your route. Delivered entirely online, it's tailored for learners who appreciate flexibility without compromising depth. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: CSS Introduction Introduction How to ask a great questions Introduction CSS Choosing Code Editor Installing Code Editor (Sublime Text) CSS Syntax Creating a first page with CSS Style Section 02: CSS Basic Inline CSS Internal CSS External CSS CSS Classes CSS IDs Colors Backgrounds Floating Positioning Margins Padding Borders Section 03: CSS Intermediate Styling Text Aligning Text Styling Links Font Family Font Styles Applying Google Fonts Box Model Icons Tables Navigation-Menu Dropdowns Section 04: CSS Advanced Advanced Selectors Forms Website Layout Rounded Corners Color Keywords Animations Pseudo Classes Gradients Shadows Calculations Creating Responsive Page Section 05: CSS Expert Button Styles Pagination Multiple Columns Image Reflection UI - UX Design Social Media Icons External CSS Style adding Section 06: PHP Introduction What is PHP Installing XAMPP for PHP, MySQL and Apache Installing Code Editor(Visual Studio Code) Creating PHP Project on XAMPP Hello World Program Section 07: PHP Basic Variables Echo and Print Data Types Numbers Boolean Arrays Multi-Dimensional Array Sorting Arrays Constants Section 08: PHP Strings Strings String Formatting String Methods Coding Exercise Solution for Coding Exercise Section 09: PHP Operators Arithmetic operators Assignment operators Comparison operators Increment - decrement operators Logical operators Ternary operator Section 10: PHP Decision making system If statement If-else statement If-elseif-else statement Switch-case statement Section 11: PHP Control flow statements Flow Chart While loop Do-while loop For loop For each loop Coding Exercise Solution for Coding Exercise Section 12: PHP Functions Creating a Function Function with Arguments Default Argument Function return values Call-by-value Call-by-reference Section 13: PHP Super globals $_POST Method $_GET Method Section 14: PHP Advanced Form Handling Date and Time Include Require Sessions File Reading File Upload Section 15: PHP Object oriented programming[OOPs] What is OOP Class and Objects Constructor Destructor Access Modifiers Inheritance Method overriding Abstract Class Interface Section 16: PHP - MySQL Application [CRUD] MySQL Basic PhpMyAdmin Creating Database and Table Database Connection PHP Form Create records PHP Form Reading records PHP Form Update Data PHP Form Delete records Section 17: PHP Real world code forms Registration Form MD5 Algorithm for Encrypting Sha Algorithm Login Form Section 18: PHP Validations On Submit Validation Input Numeric Validation Login Form Validation Form Server-side all Data Validation Form Server-side Validation Section 19: PHP Error handling Try-throw-catch Try-throw-catch-finally Section 20: MYSQL introduction Overview of Databases MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Section 21: MySQL basic Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT function Section 22: MySQL filtering data SELECT WHERE Clause - One SELECT WHERE Clause - Two ORDER BY LIMIT BETWEEN IN Operator LIKE and ILIKE Section 23: MySQL functions Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Section 24: MySQL joins Overview Assessment Overview of JOINS Introduction to JOINS AS Statement table INNER JOIN FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Section 25: MySQL advanced commands Advanced SQL Commands Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Section 26: MySQL structure creation Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Section 27: MySQL data queries Insert Update Delete Section 28: MySQL structure queries Alter Table Drop Table Section 29: MySQL constraints NOT NULL Constraint UNIQUE Constraint Section 30: MySQL backup and restore Overview of Databases and Tables Backup database using phpMyAdmin Restoring a Database Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. 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 £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Web Applications for Specialisation on Development course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Web Applications for Specialisation on Development course is open to all, with no formal entry requirements. Career path Upon successful completion of The Web Applications for Specialisation on Development Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

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