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 complete education course will improve your Project Management Training.This wide curriculum gives you the skills and information you need to succeed in this fast-paced industry, and the highly desired CPD accreditation can further improve your resume. With this training, you'll be prepared for a quick rise rather than taking it step by step up the career ladder. Participate now to see how your project management skills increase significantly! Why Choose this Project Management Bundle? FREE Project Management CPD-accredited certificate Get a free student ID card with Project Management training (£10 applicable for international delivery) Lifetime access to the Project Management course materials The Project Management program comes with 24/7 tutor support Get instant access to this Project Management course Learn Project Management training from anywhere in the world The Project Management training is affordable and simple to understand The Project Management training is entirely online How will I get my Project Management certificate? Upon successful completion of the Project Management Training course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is This Project Management course for? There is no experience or previous qualifications required for enrolment on this Project Management Training. It is available to all students, of all academic backgrounds. Requirements Our Project Management Training course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. Career Path Having this Project Management qualification will enhance your CV and open you up to multiple sectors, such as : Project Manager: £45k - £90k per year Project Coordinator: £35k - £70k per year Program Manager: £50k - £95k per year Project Analyst: £30k - £65k per year Project Management Consultant: £55k - £100k+ per year Note: Salaries vary based on experience, location, and industry. Course Curriculum 12 sections • 86 lectures • 03:24:00 total length •1.1 Introduction to Project Management: 00:04:00 •1.2 6 Pathways of Project Management: 00:03:00 •1.3 Course Structure: Simplified Framework: 00:01:00 •1.4 System Thinking: 00:01:00 •1.5 Project Timeline: 00:01:00 •1.6 Pyramid Project: 00:03:00 •2.1 Project: 00:02:00 •2.2 Project Management mbmbmbm: 00:01:00 •2.3 The Matrix Environment: 00:04:00 •2.4 Enterprise Environmental Factors and Organisational Process Assets: 00:01:00 •2.5 Project Constraints: 00:01:00 •2.6 Process Groups: 00:03:00 •2.7 Integration Management: 00:02:00 •2.8 Stakeholder Management: 00:01:00 •2.9 Scope Management: 00:01:00 •2.10 Schedule Management: 00:01:00 •2.11 Cost, HR, Quality and Risk Management: 00:02:00 •2.12 Communication and Procurement Management: 00:01:00 •2.13 Knowledge Areas and Process Groups: 00:01:00 •3.1 Develop Project Charter: 00:05:00 •3.2 Project Charter Template: 00:06:00 •3.3 Timeline View of Project Documents: 00:01:00 •4.1 Identify Stakeholders: 00:04:00 •4.2 Stakeholder Register Template: 00:01:00 •4.3 Timeline View of Project Documents: 00:04:00 •5.1 Project Scope: 00:04:00 •5.2 Collect Requirements: 00:02:00 •5.3 Define Project Scope: 00:01:00 •5.4 Create WBS: Work Breakdown Structure: 00:03:00 •5.5 Project Scope Baseline: 00:06:00 •5.6 Timeline View of Project Documents: 00:01:00 •5.7 Microsoft Project: 00:02:00 •5.8 MS Project - User Interface Explained: 00:02:00 •5.9 MS Project - Entering Scope Items: 00:06:00 •6.1 Define Activities: 00:04:00 •6.2 Sequence Activities: 00:02:00 •6.3 Estimating Activity Durations: 00:02:00 •6.4 Develop Schedule Process: 00:01:00 •6.5 Critical Path Method: 00:03:00 •6.6 Compressing Schedule : Crashing and Fast-tracking: 00:03:00 •6.7 Timeline View of Project Documents: 00:01:00 •6.8 Microsoft Project - Entering Activities and Duration: 00:03:00 •6.9 Microsoft Project - Sequencing Activities & Creating Gantt Chart: 00:07:00 •6.10 Microsoft Project - The Project Schedule: 00:06:00 •7.1 Estimated Costs: 00:03:00 •7.2 Determined Budget: 00:01:00 •7.3 Timeline View of Project Documents: 00:01:00 •7.4 Estimate Activity Resources: 00:02:00 •7.5 Timeline View of Project Documents: 00:01:00 •7.6 Plan Quality: 00:04:00 •7.7 Timeline View of Project Documents: 00:01:00 •7.8 Introduction to Risks: 00:03:00 •7.9 Identify Risks: 00:02:00 •7.10 Perform Qualitative Risk Analysis: 00:04:00 •7.11 Perform Quantitative Risk Analysis: 00:01:00 •7.12 Plan Risk Responses: 00:02:00 •7.13 Timeline View of Project Documents: 00:01:00 •8.1 Plan Communication: 00:02:00 •8.2 Timeline View of Project Documents: 00:01:00 •8.3 Plan Procurement: 00:02:00 •8.4 Timeline View of Project Documents: 00:01:00 •9.1 HOW are things done on the project: 00:06:00 •9.2 Develop Project Management Plan: 00:01:00 •9.3 Individual Management Plans: 00:04:00 •9.4 Timeline View of Project Documents: 00:01:00 •9.5 Timeline View of Project Documents-2: 00:01:00 •9.6 Direct and Manage Project Work: 00:04:00 •9.7 Timeline View of Project Documents: 00:01:00 •9.8 Manage Project Knowledge: 00:02:00 •9.9 Timeline View of Project Documents: 00:01:00 •9.10 Monitor and Control Project Work: 00:02:00 •9.11 Timeline View of Project Documents: 00:01:00 •9.12 Perform Integrated Change Control: 00:04:00 •9.13 Steps to perform Change Control: 00:05:00 •9.14 Timeline View of Project Documents: 00:01:00 •9.15 Budget at Completion: BAC: 00:05:00 •9.16 Planned Value: PV: 00:02:00 •9.17 Earned Value: EV: 00:02:00 •9.18 Schedule Variance (SV) & Schedule Performance Index (SPI): 00:02:00 •9.19 Actual Cost(AC), Cost Variance and Cost Performance Index: 00:03:00 •9.20 Budget Forecasting - Estimate at & to completion: 00:06:00 •9.21 Close Project or Phase: 00:03:00 •9.22 Timeline View of Project Documents: 00:01:00 •Resources - Project Management Training: 00:00:00 •Assignment - Project Management Training: 3 days •Order Your Certificate: 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
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Digital Painting Masters - Alien Planet will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Digital Painting Masters - Alien Planet will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Digital Painting Masters - Alien Planet and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Digital Painting Masters - Alien Planet is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Digital Painting Masters - Alien Planet. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Digital Painting Masters - Alien Planet will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction Presentation One Alien Planet Michael Schutte 00:01:00 Exercise Files 00:00:00 How to Set Up a Composition and Drawing Setting Up a Document 00:02:00 Studying Dutch Masters, Andreas Schelfhout 00:07:00 Creating a Composition with Reference Photos and using the Gradient Tool for Atmospheric Effects 00:05:00 Basic sketch for the Background Painting 00:06:00 Underpainting in Grey tones 00:13:00 Sketching the Foreground - Painting the Sky and Clouds Section 2 Presentation Alien Planet 00:01:00 Foreground Sketch 00:08:00 Clouds in the Sky 00:07:00 Background Mountains 00:09:00 Placing the Planet 00:03:00 Background Mountains Part 2 00:05:00 Background Mountains Right 00:11:00 Creating Water and Special Effects Section 3 Presentation Alien Planet - Painting a sea, Rocks the river and the main Arch 00:01:00 Painting the Sea 00:08:00 The Balanced Rock 00:10:00 The Big Arch 00:08:00 The Foreground River 00:08:00 The Arch Complete 00:07:00 Painting a Spaceship with the Pen tool Section 4 Presentation Alien Planet - Pen Tool and Building Spaceships 00:01:00 The Pen Tool 00:06:00 Pen Tool Part 2-Few Techniques with the Pen Tool 00:03:00 Pen Tool Part 3-Handy Tricks with the Pen Tool for Illustrations 00:05:00 Creating a Space Patrol Cruiser 00:14:00 Spaceship Decoration 00:11:00 Placing the Spaceships and Astronauts 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Overview This comprehensive course on HTML and CSS Coding: Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This HTML and CSS Coding: Beginner to Advanced 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 HTML and CSS Coding: Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our HTML and CSS Coding: Beginner to Advanced 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 13 sections • 127 lectures • 11:50:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:07:00 •How to Get Course requirements: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:02:00 •How to ask a Great Questions: 00:01:00 •FAQ's: 00:01:00 •Introduction: 00:05:00 •Choosing Code Editor: 00:06:00 •Installing Code Editor (Sublime Text): 00:04:00 •Overview of a Webpage: 00:05:00 •Full HTML Code Page: 00:07:00 •First Hello World! Webpage: 00:09:00 •Introduction: 00:03:00 •Heading: 00:09:00 •Paragraph: 00:08:00 •Formatting Text: 00:12:00 •List Items Unordered: 00:05:00 •List Items Ordered: 00:04:00 •Classes: 00:09:00 •ID's in CSS: 00:06:00 •Comments in HTML: 00:04:00 •Summary: 00:04:00 •Introduction: 00:02:00 •Images: 00:12:00 •Forms: 00:05:00 •Form Actions: 00:04:00 •Br tag: 00:03:00 •Marquee: 00:06:00 •Text area: 00:06:00 •Tables: 00:06:00 •Links: 00:07:00 •Navbar - Menu: 00:04:00 •HTML Entities: 00:05:00 •Div tag: 00:06:00 •Google Maps: 00:07:00 •Summary: 00:02:00 •Introduction: 00:02:00 •HTML5 Audio: 00:07:00 •HTML5 Video: 00:05:00 •Progress Bar: 00:04:00 •Drag and Drop: 00:18:00 •Canvas: 00:06:00 •I frames: 00:05:00 •Input Types: 00:04:00 •Input Attributes: 00:06:00 •YouTube Video Linking: 00:04:00 •Creating Responsive Page: 00:05:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Registration Form: 00:04:00 •Login Form: 00:04:00 •About Us Form: 00:02:00 •Contact Us Form: 00:10:00 •Footer Form: 00:03:00 •Integrate All Together: 00:07:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Challenge - HTML 5 Clock Face with Numbers: 00:05:00 •Project overview: 00:03:00 •Conclusion on Project: 00:01:00 •Summary: 00:02:00 •Introduction: 00:03:00 •CSS Syntax: 00:05:00 •Creating a first page with CSS Style: 00:13:00 •Inline CSS: 00:06:00 •Internal CSS: 00:05:00 •CSS External: 00:10:00 •CSS Classes: 00:09:00 •CSS IDs: 00:06:00 •Colors: 00:08:00 •Backgrounds: 00:04:00 •Floating: 00:09:00 •Positioning: 00:06:00 •Margins: 00:07:00 •Padding: 00:04:00 •Borders: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Styling Text: 00:07:00 •Aligning Text: 00:04:00 •Styling Links: 00:10:00 •Font Family: 00:07:00 •Font Styles: 00:03:00 •Applying Google Fonts: 00:07:00 •Box Model: 00:09:00 •Icons: 00:09:00 •Tables: 00:16:00 •Navigation-Menu: 00:11:00 •Dropdowns: 00:15:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Advanced Selectors: 00:05:00 •Forms: 00:17:00 •Website Layout: 00:21:00 •Rounded Corners: 00:08:00 •Color Keywords: 00:06:00 •Animations: 00:08:00 •Pseudo Classes: 00:03:00 •Gradients: 00:03:00 •Shadows: 00:03:00 •Calculations: 00:05:00 •Creating Responsive Page: 00:06:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Button Styles: 00:06:00 •Flexbox: 00:14:00 •CSS Grid: 00:15:00 •Pagination: 00:07:00 •Multiple Columns: 00:06:00 •Image Reflection: 00:03:00 •UI - UX Design: 00:09:00 •Social Media Icons: 00:08:00 •External CSS Style adding: 00:06:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:03:00 •Summary: 00:02:00 •Introduction: 00:01:00 •CSS Project Getting: 00:05:00 •CSS Project Overview: 00:08:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Installing Free FTP Solution (FileZilla): 00:04:00 •Setting Up FTP (File Transfer Protocol): 00:03:00 •Publish Website to Hosting Server: 00:04:00 •Summary: 00:01:00
QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support
Overview This comprehensive course on VMware vSphere Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This VMware vSphere Course 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? 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 VMware vSphere Course. It is available to all students, of all academic backgrounds. Requirements Our VMware vSphere Course 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 11 sections • 109 lectures • 08:15:00 total length •Who's the Intended Audience?: 00:02:00 •Getting VMware Certified: 00:05:00 •What is Virtual Machine and Hypervisor?: 00:04:00 •vSphere Licensing Editions: 00:04:00 •What's the New in VMware vSphere7: 00:03:00 •vCenter and the Role: 00:03:00 •VMware Hands on Lab: 00:06:00 •What This Module Covers: 00:01:00 •Virtualization System Requirements: 00:04:00 •What do we need to start the course?: 00:05:00 •Download VMware workstation: 00:01:00 •Install VMware workstation: 00:02:00 •Download ESXi and vCenter server: 00:04:00 •Download ESXi and vCenter server: 00:04:00 •How to boot a VM from in VMware Workstation: 00:07:00 •Configure ESX Part 1: 00:09:00 •Configure ESX Part 2: 00:05:00 •ESXi by a Browser: 00:03:00 •ESXi Settings: 00:05:00 •Create a Datastore in ESXi: 00:04:00 •Upload a Windows ISO file to ESXi: 00:01:00 •Install a Virtual Machine in ESXi: 00:07:00 •Connect to an ESXi by VMware Workstation: 00:02:00 •What This Module Covers: 00:01:00 •Why Do We Need Active Directory: 00:01:00 •Prepare Active Directory Windows 2019: 00:06:00 •Create Virtual Machine Template for VMware Workstation: 00:06:00 •Install Active Directory Role: 00:05:00 •Creating DNS Record for vCenter: 00:02:00 •Deploy and install vCenter Appliance: 00:12:00 •Adding ESXis to VC: 00:03:00 •AUTO start VM: 00:02:00 •Verify AUTO Start VM: 00:03:00 •Take Snapshot from vSphere Lab: 00:03:00 •Enable SSH on ESX: 00:02:00 •ESXi DCUI Console: 00:01:00 •vCSA's Management Ul: 00:06:00 •Install ftp Server Using FileZilla Server: 00:05:00 •Backing up VCSA with ftp Server: 00:06:00 •Restore VCSA: 00:09:00 •Exploring vCSA with vSphere Client: 00:07:00 •Overview of VM Tools: 00:02:00 •Install VM Tools: 00:04:00 •Virtual Machine Files: 00:02:00 •Virtual Machine Power off: 00:04:00 •OVA and OVF Files: 00:03:00 •Demo OVF (Importing and Exporting): 00:04:00 •What This Module Covers: 00:01:00 •Virtual Switch (vSwitch) Overview: 00:03:00 •Standard vSwitches: 00:02:00 •Distributed vSwitches: 00:02:00 •Adding Network Adapter: 00:03:00 •vSwitch Creation and Configuration: 00:07:00 •Assign New Switch to the Virtual Machine: 00:02:00 •Verify New vSwitch Configuration: 00:06:00 •Adding VMkernel for Management and Vmotion Traffic: 00:03:00 •Create a vSphere Distributed Switch: 00:10:00 •What This Module Covers: 00:01:00 •Overview of Using ESXi with a SAN: 00:02:00 •Types of Storage: 00:03:00 •What Is Software-Defined Storage (SEIS): 00:04:00 •What is File Level Storage and Block Level Storage?: 00:03:00 •What is an iScsi Storage?: 00:08:00 •Adding vSwitch for iScsi Target: 00:05:00 •Adding Disk to Active Directory: 00:02:00 •Enable iScsi Target on Windows Server: 00:05:00 •Adding iSsci Disk as ESXi Datastore: 00:08:00 •Expand and Extend Datastore: 00:09:00 •Enable NFS on Windows Server: 00:05:00 •Creating an NFS Datastore: 00:03:00 •Migrate a VM to NFS Share: 00:04:00 •VM Add to Inventory: 00:02:00 •What This Module Covers: 00:01:00 •Update Sequence: 00:03:00 •vCenter 6.7 Upgrade to vCenter 7: 00:08:00 •Upgrade ESXi 6.7 ESXi 7: 00:04:00 •Upgrade ESXi 6.7 ESXi 7 using Bundle File: 00:07:00 •Introduction to vSphere 7 Lifecycle Management: 00:03:00 •Demo vSphere 7 Lifecycle Management: 00:17:00 •What This Module Covers: 00:01:00 •vCenter 7 MultiMorning: 00:02:00 •Demo Configure vCenter J MultiMorning: 00:04:00 •vCenter 7 PNID and FQDN Changes: 00:10:00 •vCenter Server Profiles: 00:04:00 •vSphere 7 Licensing: 00:03:00 •What the Module Covers: 00:01:00 •Manual Backup and restore from a VM: 00:06:00 •Backup a VM using Filezilla: 00:05:00 •Backup a VM using OVF Files: 00:06:00 •Clone and Snapshot: 00:08:00 •Installing Veeam Backup and Replication: 00:05:00 •Backup and Restore Using Veeam Backup Software: 00:09:00 •Upload VM from Workstation to ESXi: 00:04:00 •What This Module Covers: 00:01:00 •User Identity: 00:04:00 •Users and Poles: 00:11:00 •Define a New Role in vSphere: 00:04:00 •Account Policy and Message: 00:03:00 •Firewall and Service: 00:11:00 •Enable Lockdown Mode: 00:09:00 •What This Module Covers: 00:01:00 •Troubleshooting using ESXi Management Agents: 00:05:00 •Working with vCenter 7 Logs: 00:04:00 •ESXi Shell Power on and off Commands: 00:05:00 •What This Module Covers: 00:01:00 •Monitoring Virtual Machines in vSphere 7: 00:15:00 •Introduction to ESXTOP Command in ESXi: 00:03:00 •Using ESXTOP to Monitor an ESXi 6.0 Host: 00:07:00 •Monitor Vsphere with Veeam ONE: 00:07:00
Do you want to learn to use a sewing machine but don’t know where to start? YOUR SEWING JOURNEY STARTS HERE I’ve been teaching complete beginners to sew since 2009 LEARN A LIFE-SKILL, SAVE MONEY & BOOST FEELINGS OF WELLBEING I’ve created an online video course based on my successful classes running since 2009 using the easiest-to-follow methods. It’s been tried & tested by children as young as 8 years old for a whole year….They LOVED it & we guarantee you will too! THIS COURSE IS FOR ANYONE AGED 10-100 YEARS If you’re a beginner your age doesn’t matter! Both children & adults have used this course with ease. In fact the kids are often quicker learners! ✂️ THINKING ABOUT BUYING A SEWING MACHINE? My advice is to buy BASIC. No whistles & bells! As long as the machine can do a straight stitch & a zig zag stitch that’s all you’ll need. Most machines have a few embroidery stitches too. Avoid toy machines & go for the most basic version of a good brand. USING OUR HANDS CREATIVELY IS PROVEN TO MAKE US 🖐✂️🧵😃 FEEL HAPPY 😃🧵✂️🖐 You can do everything you need on a basic machine including free style embroyery Amanda Recommends… WHAT YOU’LL LEARN BLOCK 1 - FIRST THINGS FIRST ✔️Let’s look at a sewing machine ✔️Speed control & turning corners ✔️How to sew a seam ✔️How to pin, cut & place a template BLOCK 2 - THREADING UP ✔️Winding a bobbin ✔️The top thread-up ✔️Inserting a bobbin on top loaders ✔️Inserting a bobbin on front loaders BLOCK 3 - SEW A SUNGLASSES CASE ✔️Practise what you’ve learned & achieve your first little project make ✔️Learn all about backstitch & why it’s important BLOCK 4 - ALL THE HELP YOU'LL NEED ✔️How to solve stitching issues ✔️Choosing & changing needles ✔️Getting unstuck ✔️Looking after your machine LEARNING TO SEW HAS COUNTLESS BENEFITS….. Sewing helps to extend focus & concentration. As we must concentrate for longer periods of time. It’s great for those who struggle to stay focused. It reduces time spent on social media. Instead of scrolling we use our hands creatively making. Sewing promotes good mental health. It increases self-esteem through empowerment & creativity. It makes us happy! Dexterity & hand strength improve. Cutting, pinning & making are ways of strengthening hands our tools for life! We help to save the planet by extending the life of clothes. Clothing won’t end up in landfill if we upcycle it. Extending the life of clothes by 9 months reduces their carbon footprint by 20-30% It teaches us how to save money. It’s a useful life-skill we can use to alter, update, customise, remake or repair instead of buying new things. It’s such a great feeling to be able to say “ I made it myself” WHAT DO I NEED? Not that much! You’ve probably got most things at home already. ✂️🧵📍✏️🎧👖📄📏 You can learn at your own speed at home or sew with your friends It’s much cheaper than attending classes MEET YOUR INSTRUCTOR…..AMANDA RILEY Amanda Riley is a Fashion Designer & environmentalist. She has been teaching complete beginners the art of diy fashion and eco-sewing since 2009. After realising the horrendous environmental impact of fashion she started her masterclass workshops at The Fashion Factory, for 8-16 year olds as an antidote to fast fashion. “ I saw an increase in social media use & the reduction of practical & creative subjects in schools. Many children are missing out on life skills, creativity, dexterity & the ability to focus. I felt I had to do something” “My eco-sewing programme focuses on learning via upcycling unwanted textiles into cool new stuff. The products & video lessons are designed to keep young people engaged and coming back for more. I’ve ripped up the sewing rule books and introduced a new way of learning this hugely rewarding life skill.” Her students have appeared in Vogue, in the Fashion Factory book (Amazon) & many have gone on to study for creative careers. She was selected as a top 100 changemaker in 2021 by the Big Issue.
QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support
Overview This comprehensive course on Ethical Hacking with Kali Linux will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ethical Hacking with Kali Linux 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 Ethical Hacking with Kali Linux. It is available to all students, of all academic backgrounds. Requirements Our Ethical Hacking with Kali Linux 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 16 sections • 150 lectures • 05:54:00 total length •Introduction to the course: 00:05:00 •Virtual box installation: 00:16:00 •Kali linux installation: 00:14:00 •Enabling full screen: 00:18:00 •Basic commands part 1: 00:10:00 •Basic commands part 2: 00:21:00 •Basic commands part 3: 00:13:00 •Changing ip address and wireless adapter setup: 00:05:00 •Creating a bootable Kali USB drive: 00:05:00 •Essential networking terms: 00:10:00 •Essential hacking terms: 00:18:00 •Additional kali tools to install: 00:09:00 •Changing our MAC address with mac changer: 00:06:00 •Google hacking: 00:13:00 •Nikto basics: 00:11:00 •Whois tools: 00:07:00 •Email harvesting: 00:06:00 •Shodan: 00:10:00 •Zone transfer with Dig: 00:08:00 •Installing Metasploitable: 00:07:00 •Nmap part 1: 00:16:00 •Nmap part 2: 00:12:00 •Nmap part 3: 00:12:00 •Zen map: 00:08:00 •TCP scans: 00:16:00 •Nmap by passing defenses: 00:17:00 •Nmap scripts part 1: 00:09:00 •Nmap scripts part 2: 00:14:00 •Installing OWASP: 00:08:00 •HTTP request: 00:10:00 •HTTP response: 00:10:00 •Burpsuite configuration: 00:13:00 •Editing packets in Burpsuite: 00:12:00 •Whatweb and Dirb: 00:10:00 •Password recovery attack: 00:16:00 •Burpsuite login bruteforce: 00:11:00 •Hydra login bruteforce: 00:09:00 •Session fixation: 00:14:00 •Injection attacks: 00:06:00 •Simple command injection: 00:11:00 •Exploiting command injection vulnerability: 00:08:00 •Finding blind command injection: 00:14:00 •SQL basics: 00:10:00 •Manual SQL injection part 1: 00:13:00 •Manual SQL injection part 2: 00:21:00 •SQL map basics: 00:17:00 •XML injection: 00:16:00 •Installing XCAT and preventing injection attacks: 00:06:00 •Reflected XSS: 00:11:00 •Stored XSS: 00:13:00 •Changing HTML code with XSS: 00:07:00 •XSSer and XSS sniper: 00:14:00 •Wireless attacking theory: 00:11:00 •Enabling monitor mode: 00:05:00 •Capturing handshake with airodump: 00:15:00 •Rockyou.txt: 00:14:00 •Cracking with aircrack: 00:16:00 •Cracking with hashcat: 00:15:00 •Creating password lists with crunch: 00:18:00 •Creating password lists with cup: 00:07:00 •Rainbow tables part 1: 00:17:00 •Rainbow tables part 2: 00:06:00 •Installing fluxion: 00:06:00 •Finding and cracking hidden networks: 00:08:00 •Preventing wireless attacks: 00:08:00 •ARP protocol basics: 00:10:00 •Man in the middle attack theory: 00:07:00 •Installing MITMf: 00:07:00 •Manual ARP spoofing: 00:13:00 •Problems while installing MITMf: 00:06:00 •HTTP traffic sniffing: 00:08:00 •DNS spoofing and HTTPS password sniffing: 00:24:00 •Hooking browser with BEEF: 00:16:00 •Screenshotting targets browser: 00:11:00 •Cloning any webpage: 00:09:00 •Ettercap basics: 00:07:00 •MFS console environment: 00:16:00 •Metasploit modules explained: 00:12:00 •Bruteforcing SSH with Metasploit: 00:15:00 •Attacking tomcat with metasploit: 00:09:00 •Getting meterpreter with command injection: 00:25:00 •PHP code injection: 00:06:00 •Metasploitable exploits: 00:07:00 •Wine installation: 00:12:00 •Creating windows payloads with Msfvenom: 00:10:00 •Encoders and Hex editors: 00:19:00 •Windows 10 meterpreter shell: 00:12:00 •Meterpreter environment: 00:11:00 •Windows 10 privilege escalation: 00:11:00 •Preventing privilege escalation: 00:06:00 •Post exploitation modules: 00:14:00 •Getting Meterpreter over Internet with port forwarding: 00:11:00 •Eternalblue exploit: 00:20:00 •Persistence module: 00:13:00 •Hacking over the internet with Ngrok: 00:10:00 •Android device hacking with venom: 00:10:00 •The real hacking begins now!: 00:02:00 •Variables: 00:14:00 •Raw input: 00:11:00 •If else statements: 00:10:00 •For loops: 00:07:00 •While loops: 00:08:00 •Python lists: 00:08:00 •Functions: 00:15:00 •Classes: 00:10:00 •Importing libraries: 00:07:00 •Files in python: 00:12:00 •Try and except the rule: 00:05:00 •Theory behind reverse shells: 00:07:00 •Simple server code: 00:13:00 •Connection with reverse shell: 00:07:00 •Sending and receiving messages: 00:11:00 •Sending messages with while true loop: 00:08:00 •Executing commands on target system: 00:10:00 •Fixing backdoor bugs and adding functions: 00:20:00 •First test using our backdoor: 00:18:00 •Trying to connect every 20 seconds: 00:12:00 •Creating persistence part 1: 00:06:00 •Creating persistence part 2: 00:17:00 •Changing directory: 00:12:00 •Uploading and downloading files: 00:22:00 •Downloading files from the internet: 00:23:00 •Starting programs using our backdoor: 00:07:00 •Capturing screenshots on the target PC: 00:19:00 •Embedding backdoor in an image part 1: 00:13:00 •Embedding backdoor in an image part 2: 00:09:00 •Checking for administrator privileges: 00:12:00 •Adding help option: 00:09:00 •Importing Pynput: 00:10:00 •Simple keylogger: 00:10:00 •Adding report function: 00:11:00 •Writing key strokes to a file: 00:14:00 •Adding the keylogger to our reverse shell part 1: 00:23:00 •Adding the keylogger to our reverse shell part 2: 00:08:00 •Final project test: 00:14:00 •Printing banner: 00:11:00 •Adding available options: 00:11:00 •Starting threads for bruteforce: 00:08:00 •Writing function to run the attack: 00:11:00 •Bruteforcing router login: 00:10:00 •Bypassing antivirus with your future programs: 00:14:00 •Sending malware with spoofed email: 00:15:00 •What will you learn in this section?: 00:03:00 •Why is ethical hacking a valuable skill?: 00:23:00 •What is the best ethical hacking certification?: 00:17:00 •Tips for getting your first job as an ethical hacker: 00:18:00 •How I started my career as an ethical hacker: 00:14:00 •How to price your work: 00:11:00 •Bonuses. Enjoy the Benefits: 01:05:00 •Assignment - Ethical Hacking with Kali Linux: 00:00:00