37838 Sup courses

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification 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 Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Overview This comprehensive course on Web Design in Affinity Designer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Web Design in Affinity Designer 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Web Design in Affinity Designer. It is available to all students, of all academic backgrounds. Requirements Our Web Design in Affinity Designer 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 26 sections • 87 lectures • 07:29:00 total length •Introduction to the course: 00:02:00 •What is Affinity Designer and how to set it up for web design?: 00:03:00 •Affinity Designer's web design abilities: 00:09:00 •First 5 principles of good web design: 00:04:00 •The remaining 5 principles of good web design: 00:05:00 •The most important factor to consider before choosing colours: 00:04:00 •Mix colours for the best possible User Experience: 00:05:00 •Choose the 'psychologically right' colours: 00:05:00 •Easy tools for choosing errorproof colour schemes: 00:07:00 •A super short history of web typography: 00:03:00 •Choose the right fonts for body text: 00:05:00 •Choose the right fonts for headings: 00:04:00 •Mix fonts for headings and body text: 00:04:00 •The perfect font for User Interface design: 00:03:00 •Header, branding, navigation and Hero sections.: 00:04:00 •The centre and bottom sections of your website design: 00:04:00 •What are grids and how to use them: 00:03:00 •Design your very own grid: 00:04:00 •1-7 web design trends that rule the web design world: 00:09:00 •Where to find the RIGHT inspiration for your next design: 00:02:00 •Every website design needs scaffolding: 00:03:00 •Building your wireframe in Designer: 00:05:00 •Continue building the library: 00:10:00 •Use the assets to create a wireframe: 00:11:00 •Wireframing online: 00:04:00 •Talk about images and icons: 00:06:00 •Create font styles in Affinity Designer: 00:04:00 •The Design Part Overview: 00:06:00 •Create the Colour Swatches: 00:04:00 •Create the Text Styles: 00:08:00 •Take a Look at the Icons and Images: 00:03:00 •Start with Creating the Logo: 00:03:00 •Build the Menu Links: 00:04:00 •Add the Social Media Icons: 00:07:00 •Start by Adding the Main Image: 00:07:00 •Quickly Resize the Image: 00:03:00 •Make the Image a Bit Darker: 00:03:00 •Add the Main Text: 00:05:00 •Add the Slider Navigation: 00:04:00 •Start Creating the First Featured Section: 00:04:00 •Add the Featured Items: 00:10:00 •Add the Second Featured Item Section: 00:06:00 •Start Creating the Blog Section: 00:08:00 •Replace the Images: 00:03:00 •Start Building the Image Gallery: 00:07:00 •Create the First Column of the Footer: 00:04:00 •Finish the Design and the Whole Footer: 00:04:00 •Discover the Wireframe for the Design: 00:06:00 •Discover the Blog Design: 00:06:00 •Take a Look at Our Assets: 00:06:00 •Create the Logo and Nav: 00:08:00 •Add the Social Media Icons: 00:07:00 •Add the First Images: 00:07:00 •Add the Shading to the Images: 00:08:00 •Add the Navigation Buttons: 00:05:00 •Create a Container the Blog Post: 00:05:00 •Add the First Pieces of Text: 00:04:00 •Add the Remaining Pieces of Text: 00:06:00 •Start Creating the Blog Post Grid: 00:06:00 •Create the First Blog Post Card: 00:05:00 •Add the Remaining Cards: 00:07:00 •Add the Older Post Link: 00:04:00 •Explore the Sidebar Project: 00:03:00 •Create the Search Box: 00:04:00 •Create the About Me Section: 00:07:00 •Create the Text Section of the Sidebar: 00:05:00 •Create the First Container for the Most Popular Posts: 00:04:00 •Create the List of the Most Popular Blog Posts: 00:07:00 •Create the Ads Section: 00:03:00 •Start Creating the Footer: 00:04:00 •Explore Different Footer Concepts: 00:03:00 •Finish Creating the Footer: 00:07:00 •Explore the Single Post Design: 00:03:00 •Create the Featured Image and the Post Container: 00:06:00 •Add the Blog Post Title: 00:06:00 •Add the Paragraphs and Images: 00:10:00 •Add the Social Media Icons: 00:07:00 •Add the pre-Next Post Navigation: 00:08:00 •Add the Related Posts Section: 00:07:00 •Start Creating the Comments Section: 00:05:00 •Create the Texts for the Comments: 00:06:00 •Create the Post Comment Form: 00:09:00 •Delivering the design to the client: 00:04:00 •Delivering the file to the developer: 00:03:00 •Use the Export Persona to Export the Assets in Bulk: 00:02:00 •Thanks for Watching the Course: 00:01:00 •Assignment - Web Design in Affinity Designer: 00:00:00

Overview This comprehensive course on Healthy Fitness will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Healthy Fitness 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 Healthy Fitness . It is available to all students, of all academic backgrounds. Requirements Our Healthy Fitness 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 7 sections • 108 lectures • 05:35:00 total length •Day 01 -Leg Blast: 00:10:00 •Day 02 -Upper Body: 00:11:00 •Day 03 -Cardio Blast: 00:10:00 •Day 04 -Dynamic Upper Body: 00:10:00 •Day 05 -Dynamic Lower Body: 00:12:00 •Day 06 -Core: 00:09:00 •Day 07 -Stretching and Isometrics: 00:16:00 •Beginning High Intensity Training: 00:04:00 •HIT Recovery: 00:04:00 •Science of Body building: 00:04:00 •Foundations of HIT: 00:03:00 •Debunking Myths of Lifting: 00:04:00 •The Most Important Thing In Training: 00:04:00 •HIT Workout Day One: 00:04:00 •HIT Workout Day Two: 00:04:00 •HIT Diet: 00:04:00 •Beginning High Intensity Training: 00:04:00 •Foundations Of HIT: 00:03:00 •Debunking Myths Of Lifting: 00:04:00 •Science of Bodybuilding: 00:04:00 •The Most Important Thing In Training: 00:04:00 •HIT Recovery: 00:04:00 •HIT Workout Day One: 00:04:00 •HIT Diet: 00:04:00 •HIT Workout Day Two: 00:04:00 •Not All Strength is Created Equal: 00:06:00 •Body Weight Training: 00:04:00 •Gym Based Training: 00:07:00 •A Simple Workout You Can Do Anywhere: 00:07:00 •Crossfit: is it for you?: 00:05:00 •Stretching: Why It's So Important: 00:07:00 •HIIT and TABATA Explained: 00:05:00 •How to Hire A Personal Trainer: 00:10:00 •Paleo Diet Explained: 00:05:00 •Creating Your Own Training Program: 00:06:00 •Introduction: 00:01:00 •The Importance Of Joint Health: 00:07:00 •A Look At Common Joint Problems: 00:07:00 •Exercise Your Joints: 00:08:00 •Balance Your Diet: 00:08:00 •Watch Your Weight: 00:06:00 •Home Remedies For Easing Joint Pains: 00:07:00 •Best Supplements For Joint Health: 00:10:00 •Other Options To Treat Joint Pains: 00:07:00 •Conclusion: 00:01:00 •Clips Home Fitness Man: 00:02:00 •Workout Aid your Recovery: 00:01:00 •Workout Aim past your goal: 00:01:00 •Workout Air Your Dirty Laundry: 00:01:00 •Workout Avoid Tendinitis: 00:01:00 •Workout Back Flys: 00:01:00 •Workout Back to Comfort: 00:01:00 •Workout Be a Lightweight: 00:01:00 •Workout Be an Early Bird: 00:01:00 •Workout Be an Energizer Bunny: 00:01:00 •Workout Become a Better Runner: 00:01:00 •Workout Bike more Efficiently: 00:01:00 •Workout Bike Uphill Better: 00:01:00 •Workout Biking: 00:01:00 •Workout Break out the Cash: 00:01:00 •Workout Breathe as You Rise: 00:01:00 •Workout Build Your Back: 00:01:00 •Workout Catch Baseballs Better: 00:01:00 •Workout Catch the Spiral: 00:01:00 •Workout Chin-Ups: 00:01:00 •Workout Close Grip Bench: 00:01:00 •Workout Close Grip Lat Pull-Down: 00:01:00 •Workout Count Backwards from 100: 00:01:00 •Workout Create Constructive Sleep Habits: 00:01:00 •Workout Crumple and Crush: 00:01:00 •Workout Crunches: 00:01:00 •Workout Deadlift: 00:01:00 •Workout Dips: 00:01:00 •Workout Diversify for Ultimate Success: 00:01:00 •Workout Do it in Parts: 00:01:00 •Workout Elliptical: 00:01:00 •Workout Exercise Bike: 00:01:00 •Workout Incline Dumbbell Press: 00:01:00 •Workout Incline Reverse Flys: 00:01:00 •Workout Jump Rope: 00:01:00 •Workout Jumping Jacks: 00:01:00 •Workout Knee Push-Ups: 00:01:00 •Workout Leg Curls: 00:01:00 •Workout Leg Extensions: 00:01:00 •Workout Leg Press: 00:01:00 •Workout Leg Raises: 00:01:00 •Workout Lower Back Raises: 00:01:00 •Workout Lunges: 00:01:00 •Workout Military Press: 00:01:00 •Workout Oblique Crunches: 00:01:00 •Workout Oblique Sit-Ups: 00:01:00 •Workout Overhead Triceps Extension: 00:01:00 •Workout Preacher Curl: 00:01:00 •Workout Pull-Ups: 00:01:00 •Workout Push-Ups: 00:01:00 •Workout Runner: 00:01:00 •Workout Running Treadmill: 00:01:00 •Workout Seated Row: 00:01:00 •Workout Shoulder Press: 00:01:00 •Workout Side Dumbbell Raise: 00:01:00 •Workout Single Arm Curl: 00:01:00 •Workout Sit-ups: 00:01:00 •Workout Squats: 00:01:00 •Workout Triceps Kickback: 00:01:00 •Workout Upright Barbell Rows: 00:01:00 •Workout Walking: 00:01:00 •Workout Wide Grip Pull-Down: 00:01:00 •Assignment - Healthy Fitness: 00:00:00

Course Overview: Embark on an exhilarating journey into modern web designing with our captivating Counselling Course - Modern Web Designing - Level 2. This course presents an invaluable opportunity to explore the latest techniques and trends in web design, providing you with the skills to create visually stunning and user-friendly websites that captivate audiences.The Modern Web Designing - Level 2 course is meticulously designed to equip learners with a profound understanding of contemporary web design. It dives deep into essential components, ranging from the foundational pillars of HTML and CSS to the flexible utilities of Bootstrap, culminating in creating engaging landing pages and professional business sites. Enrol today and unlock your potential in the exciting world of modern web design. Key Features of the Course: CPD Certificate: Upon completing this course, you will receive a Continuing Professional Development (CPD) certificate, adding a valuable credential to your portfolio. 24/7 Learning Assistance: We will be available round the clock to provide comprehensive learning support, ensuring your success throughout the course. Who is This Course For? This course is tailored for individuals passionate about web design and those seeking to enhance their knowledge in this field. Whether you are a freelancer, entrepreneur, or aspiring web designer, this course will give you the essential skills and knowledge to excel in modern web design. What You Will Learn: In this comprehensive Counselling Course - Modern Web Designing - Level 2, you will undergo a transformative journey to become a skilled web designer. Starting with the fundamentals of HTML and CSS, you will learn to create and structure web pages, manipulate text and images, and create hyperlinks for seamless navigation. Building on this foundation, you will delve deeper into CSS, mastering the art of styling web pages with colours, borders, fonts, and backgrounds. You will also gain expertise in positioning, padding, and margin to achieve precise layout control. The course then introduces you to Bootstrap, a widely-used framework that enhances your design process. You will learn to install and utilise Bootstrap, harnessing its grid system to create responsive layouts adaptable to various screen sizes. Furthermore, you will incorporate interactive elements like images and buttons into your web pages using Bootstrap. As the course progresses, you will focus on creating specific types of websites. You will learn to design compelling landing pages that entice visitors and drive action. Techniques for showcasing key information, incorporating eye-catching images, and collecting user data through opt-in forms will be explored. Additionally, you will master the creation of business websites, implementing advanced techniques such as fancy fonts, dynamic carousels, Google Maps integration, and Font Awesome icons. Why Enrol in This Course: Top Reviewed Course: Our Counselling Course - Modern Web Designing - Level 2, has garnered rave reviews from learners worldwide, attesting to its effectiveness in delivering helpful and actionable knowledge. Recently Updated: This course has been meticulously updated to incorporate the latest trends, techniques, and best practices in modern web designing, ensuring you receive the most relevant and up-to-date training. Trending Skill: Web design is a highly sought-after skill in the digital era, with a growing demand for talented designers who can create captivating online experiences. By mastering this skill, you will be a valuable asset in the job market. Requirements: To enrol in this course, you only need a basic understanding of computer operations and access to a computer with an internet connection. No prior experience in web design is required. Career Path: Upon completing this course, you can pursue various rewarding careers in the field of web design, including: Web Designer - Average UK Salary: £30,000 to £45,000 Front-end Developer - Average UK Salary: £25,000 to £50,000 UI/UX Designer - Average UK Salary: £35,000 to £55,000 Freelance Web Designer - Average UK Salary: £200 to £400 Digital Agency Designer - Average UK Salary: £25,000 to £40,000 E-commerce Website Designer - Average UK Salary: £30,000 to £45,000 Graphic Designer - Average UK Salary: £20,000 to £35,000 Certification: Upon completing this course, you will receive a CPD certificate, demonstrating your proficiency in modern web design. This certificate will testify to your skills and enhance your credibility in the field. Don't miss out on this exciting opportunity to master the art of modern web design. Enrol in our Counselling Course - Modern Web Designing - Level 2 today and unlock your potential in the captivating world of web design. Course Curriculum 8 sections • 66 lectures • 08:06:00 total length •1.1 Intro: 00:03:00 •1.2 Install the Tools and Get Started: 00:05:00 •2.1 Intro to HTML: 00:01:00 •2.2 What is HTML: 00:11:00 •2.3 Start a New HTML File & Use Tags: 00:12:00 •2.4 Header Tags: 00:05:00 •2.5 Edit Text: 00:09:00 •2.6 Links: 00:09:00 •2.7 Images: 00:10:00 •2.8 Lists: 00:04:00 •2.9 Challenge 1: 00:16:00 •2.10 HTML Outro: 00:01:00 •3.1 CSS Intro: 00:04:00 •3.2 Add CSS Styles: 00:16:00 •3.3 Classes and IDs: 00:07:00 •3.4 Borders: 00:06:00 •3.5 Sizing: 00:04:00 •3.6 Padding and Margin: 00:07:00 •3.7 Text Styles: 00:04:00 •3.8 DIVs: 00:08:00 •3.9 Postioning: 00:08:00 •3.10 Hover: 00:03:00 •3.11 Easily Center Elements: 00:02:00 •3.12 Fonts: 00:06:00 •3.13 Challenge: 00:23:00 •3.14 CSS Outro: 00:01:00 •4.1 Intro to Bootstrap: 00:02:00 •4.2 Install Bootstrap: 00:10:00 •4.3 Indenting and Containers: 00:07:00 •4.4 The Grid System: 00:16:00 •4.5 Images: 00:07:00 •4.6 Buttons: 00:06:00 •4.7 Challenge 3: 00:11:00 •4.8 Bootstrap Outro: 00:01:00 •5.1 Landing Page Intro: 00:01:00 •5.2 Sketch Your Landing Page: 00:05:00 •5.3 The Top Section: 00:16:00 •5.4 Polish the Top Section: 00:06:00 •5.5 Adding Images: 00:11:00 •5.6 The Main Points Section: 00:14:00 •5.7 Collecting Emails With an Opt-In Form: 00:11:00 •5.8 Challenge 4: 00:03:00 •5.9 Landing Page Outro: 00:02:00 •6.1 Business Site Intro: 00:01:00 •6.2 Sketch Up: 00:03:00 •6.3 Using Fancy Font Logo: 00:07:00 •6.4 Carousel Basics: 00:10:00 •6.5 Carousel Extras: 00:09:00 •6.6 Text on Images: 00:15:00 •6.7 Phone Number Icon: 00:04:00 •6.8 Google Maps: 00:13:00 •6.9 Font Awesome: 00:09:00 •6.10 Challenge 4: 00:08:00 •6.11 Business Site Outro: 00:01:00 •7.1 Intro: 00:01:00 •7.2 Portfolio Sketch: 00:08:00 •7.3 Jumbotron: 00:10:00 •7.4 Nav Bar: 00:24:00 •7.5 Panels: 00:11:00 •7.6 Challenge 5: 00:13:00 •7.7 Portfolio Outre: 00:01:00 •8.1 Hosting: 00:01:00 •8.2 Bluehost: 00:06:00 •8.3 Uploading: 00:05:00 •8.4 Tips: 00:11:00 •8.5 Hosting Outro: 00:01:00

Level 2 Microsoft Office Essentials

Overview This comprehensive course on Train the Trainer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Train the Trainer comes with accredited certification, 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? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Train the Trainer. It is available to all students, of all academic backgrounds. Requirements Our Train the Trainer 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 35 sections • 98 lectures • 18:47:00 total length •Introduction to Trainer Bootcamp: 00:13:00 •What Makes a Great Trainer?: 00:18:00 •Make Them Feel Safe Before Class Introduction: 00:05:00 •Make Comfortable Small Talk - Part 1: 00:17:00 •Make Comfortable Small Talk - Part 2: 00:20:00 •Make Comfortable Small Talk - Activity Feedback: 00:09:00 •Make an Impressive First Impression: 00:15:00 •Give Last Minute Reminders - Part 1: 00:19:00 •Give Last Minute Reminders - Part 2: 00:15:00 •Give Your Introduction - Part 1: 00:18:00 •Give Your Introduction - Part 2: 00:20:00 •Give Your Introduction - Part 3: 00:00:00 •Find Out About Them: 00:18:00 •Reveal the Takeaways: 00:13:00 •Set Boundaries and Expectations - Part 1: 00:18:00 •Set Boundaries and Expectations - Part 2: 00:06:00 •Give the Lesson Hook: 00:07:00 •Do an Oral Review - Part 1: 00:17:00 •Do an Oral Review - Part 2: 00:04:00 •Send Them to Break: 00:04:00 •Walk and Talk During Break: 00:11:00 •Bring Them Back From Break: 00:13:00 •Workbook - Train the Trainer - Part 1: 00:00:00 •Introduction: 00:11:00 •Build Pre-Activity Credibility and Rapport: 00:15:00 •Hook the Trainees on the Activity - Part 1: 00:15:00 •Hook the Trainees on the Activity - Part 2: 00:12:00 •Craig Czarnecki - 1-3 Get Buy-In for the Activity: 00:06:00 •Craig Czarnecki - 1-1 Part 1 Activity - Get Buy In for the Activity: 00:11:00 •Craig Czarnecki - 2-1 Find Trainees Who Need Help: 00:10:00 •Craig Czarnecki - 2-2 Find Trainees Who Need Help: 00:19:00 •Craig Czarnecki - 2-3 Activity Find Trainees Who Need Help: 00:18:00 •Craig Czarnecki - 3-1 Activity Tutor Effectively During Activities: 00:17:00 •Craig Czarnecki - 3-2 Tutor Effectively During Activities: 00:11:00 •Craig Czarnecki - 3-3 Tutor Effectively During Activities: 00:20:00 •Craig Czarnecki - 3-4 Activity Tutor Effectively During Activities: 00:19:00 •Craig Czarnecki - 3-5 Activity Tutor Effectively During Activities: 00:09:00 •Craig Czarnecki - 4-1 Manage the Activity Pace: 00:17:00 •Craig Czarnecki - 4-2 Activity Manage the Activity Pace: 00:14:00 •Craig Czarnecki - 5 Activity Prepare to Lead an Activity: 00:18:00 •Craig Czarnecki - Activity Highlight Video: 00:00:00 •Workbook - Training on Facilitating Classroom Activity: 00:00:00 •0.1 Craig Czarnecki - Coach Intro Part 1: 00:19:00 •0.2 Craig Czarnecki - Coach Intro Part 2: 00:07:00 •1.1 Craig Czarnecki - Coach Learn About the Trainer - Recognize the Trainers Strengths: 00:13:00 •1.2 Craig Czarnecki - Coach Learn About the Trainer - Gauge areas for improvement: 00:07:00 •1.3 Craig Czarnecki - Coach Learn About the Trainer - Identify what's Important to the trainer: 00:03:00 •1.4 Craig Czarnecki - Coach Identify the Trainers Style: 00:01:00 •2.1 Craig Czarnecki - Coach Create Initial Value for the Trainer - Create Deliverables for the kickoff meeting: 00:08:00 •2.2 Craig Czarnecki - Coach Create Initial Value for the Trainer - Create a hook for the kickoff meeting: 00:10:00 •2.3 Craig Czarnecki - Coach Create Initial Value for the Trainer - Prepare for the kickoff meeting: 00:07:00 •3.1.1 Craig Czarnecki - Make a Good First Impression - Build a Teammate Relationship Immediately Part 1: 00:10:00 •3.1.2 Craig Czarnecki - Make a Good First Impression - Build a Teammate Relationship Immediately Part 2: 00:14:00 •3.1.3 Craig Czarnecki - Make a Good First Impression - Build a Teammate Relationship Immediately Part 3: 00:16:00 •3.2.1 Craig Czarnecki - Make a Good First Impression - Discuss the Process for Trainer Growth Part 1: 00:12:00 •3.2.2 Craig Czarnecki - Make a Good First Impression - Discuss the Process for Trainer Growth part 2: 00:12:00 •4.1 Craig Czarnecki - Observe the Trainer in the Classroom - Prepare for the Classroom Observation: 00:15:00 •4.2.1 Craig Czarnecki - Observe the Trainer in the Classroom - Master 7 Keys to Effective Note-Taking Part 1: 00:14:00 •4.2.2 Craig Czarnecki - Observe the Trainer in the Classroom - Master 7 Keys to Effective Note-Taking Part 2: 00:14:00 •4.3 Craig Czarnecki - Observe the Trainer in the Classroom - Apply 4 Quick Steps to Classroom Oberserations: 00:09:00 •4.4.1 Craig Czarnecki - Observe trainer activity part 1: 00:19:00 •4.4.2 Craig Czarnecki - Observe trainer activity part 2: 00:18:00 •5.1.1 Craig Czarnecki - Write a Classroom Observation Summary - Identify Strengths and Areas for Improvement Part 1: 00:12:00 •5.1.2 Craig Czarnecki - Write a Classroom Observation Summary - Identify Strengths and Areas for Improvement part 2: 00:13:00 •5.2.1 Craig Czarnecki - Write a Classroom Observation - Record Strengths and Areas for Improvement Part 1: 00:19:00 •5.2.2 Craig Czarnecki - Write a Classroom Observation - Record Strengths and Areas for Improvement Part 2: 00:17:00 •5.2.3 Craig Czarnecki - Write a Classroom Observation - Record Strengths and Areas for Improvement Part 3: 00:18:00 •5.3 Craig Czarnecki - Write a Classroom Observation - Record the Main Strength of the Trainer: 00:35:00 •Introduction and Welcome: 00:00:00 •Open Well: 00:27:00 •Communicate Effectively: 00:15:00 •Provide In Class Support: 00:17:00 •Workbook - Train the Trainer Coliseum: How to Train Very Large Classes: 00:00:00 •Introduction and Welcome: 00:19:00 •Take Good Care Of Yourself: 00:06:00 •Manage Your Stress: 00:09:00 •Anticipate Unexpected Issues: 00:08:00 •Get Help And Make It Helpful: 00:00:00 •Help Them Get It: 00:14:00 •Manage Large Classes: 00:09:00 •Have Fun Your Way: 00:13:00 •Control Tough Customers: 00:10:00 •Engage Adult Students With Ease: 00:02:00 •Interpret Your Feedback: 00:02:00 •Wrap Up Questions And Answers: 00:04:00 •Introduction and Welcome: 00:06:00 •Hog-Tie the Talk Hogs: 00:20:00 •Give the Experts the Spotlight: 00:12:00 •Simmer Down the Know-it-Alls: 00:11:00 •Placate Resenters - Part 1: 00:11:00 •Placate Resenters - Part 2: 00:14:00 •Handle the Fault-Finders: 00:11:00 •Shut Down the Hecklers: 00:10:00 •Stimulate Stubborn Passivists: 00:06:00 •Engage the Distracted Inefficient: 00:07:00 •Workbook - Train the Trainer Serenity Course: 00:00:00 •Assignment - Train the Trainer: 00:00:00 •Order Your Certificate: 00:00:00

Property Law for Estate Agents and Letting Supervisors Diploma Enter the world of property management and real estate with our Property Law for Estate Agents and Letting Supervisors Diploma. Gain a solid foundation in Property Law for real estate success. Learning Outcomes: Develop a foundational understanding of Property Law. Evaluate the legal aspects of Joint Ownership in Property. Demonstrate knowledge of Property Licensing and its compliance. Apply the core responsibilities of a Property Manager. Explain the fundamental concepts of Property Law. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Property Law for Estate Agents and Letting Supervisors Diploma: Basics of Property Law: Embark on a foundational understanding of Property Law, setting the cornerstone for more specialised subjects. Property Law and Land Law Principles: Become proficient in the cardinal rules and regulations of Land Law, central to property management and estate agency. Joint Ownership and Property Law: Delve into the legal frameworks that define joint ownership, including the intricacies of tenancies in common and joint tenancies. Property Licensing in the Context of Property Law: Master the compliance aspects of Property Licensing, a critical factor for lawful property management. Property Law for Managers: Understand the multi-dimensional roles and duties of a Property Manager, covering all facets from tenancy agreements to maintenance. Investment Opportunities and Property Law in the UK: Identify promising trends and areas of growth within the UK property market, equipping you to make informed decisions.

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Overview of The Care Certificate Preparation Join our The Care Certificate Preparation 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 The Care Certificate Preparation course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The The Care Certificate Preparation 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! This The Care Certificate Preparation Course will help you to learn: 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 The Care Certificate Preparation. 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 Certificate of Completion – Digital / PDF Certificate After completing the The Care Certificate Preparation course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This The Care Certificate Preparation 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 You don’t need any educational qualification or experience to enrol in the The Care Certificate Preparation 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 The Care Certificate Preparation Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Step into the fascinating world of children’s growth, thought processes and play behaviour with this insightful Child Development, Psychology and Playwork Course. Whether you're working with children already or looking to build your understanding, this course takes you through how young minds develop emotionally, socially and cognitively—wrapped up in a fun yet purposeful look at play and its psychological role in early years. With a solid foundation in theory and everyday application, you'll gain valuable knowledge to support children in a range of environments. Designed to balance scientific understanding with playful interaction, this course explores how children form relationships, express emotion, and make sense of their surroundings through structured and imaginative play. You’ll get to grips with key psychological concepts, developmental milestones, and the frameworks professionals use to observe and support children’s learning journeys. All content is delivered online, making it easy to fit around your schedule while gaining insight that matters. Key Features of Child Development, Psychology and Playwork Bundle CPD Accredited Child Development, Psychology and Playwork Course Instant PDF certificate Fully online, interactive Child Development, Psychology and Playworkcourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Child Development, Psychology and Playwork Bundle course to excel! To become successful in your profession, you must have a specific set of Child Development, Psychology and Playwork skills to succeed in today's competitive world. In this in-depth Child Development, Psychology and Playworktraining course, you will develop the most in-demand Child Development, Psychology and Playwork skills to kickstart your career, as well as upgrade your existing knowledge & skills. Child Development, Psychology and Playwork Curriculum Course 01: Child Psychology & Development Course 02: Child Playwork Accreditation This Child Development, Psychology and Playwork bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Child Development, Psychology and Playwork course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Child Development, Psychology and Playwork basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Child Development, Psychology and Playwork Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.