269 Courses delivered On Demand

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Landing Page Design and Optimisation 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 Landing Page Design and Optimisation 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 Landing Page Design and Optimisation 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? This Landing Page Design And Optimisation is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of Landing Page Design & Conversion Rate Optimisation or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. 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 On successfully completing the Landing Page Design And Optimisation, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Digital Marketing Manager Campaign Executive Course Curriculum Module 01: Landing Page Design and Optimisation Fundamentals Download all Section One Slides 00:48:00 Welcome to this course! Let's lay the groundwork for good landing page design 00:13:00 The Myth Of The Perfect Landing Page Conversion Rate 00:12:00 The 3 Main Types of Landing Pages and How To Use Them Effectively 00:19:00 Common Business Models and Understanding Your Conversion Actions 00:19:00 The AIDA Sales Funnel and The Online Decision Making Process 00:17:00 The Awareness Stage of the Funnel: Where It All Begins 00:18:00 The Interest Stage of the Funnel Tell Me More 00:14:00 The Desire Stage of the Funnel I Want What You Sell 00:13:00 The Action Stage of the Funnel I'm Going to Buy What You Sell 00:09:00 The Fogg Behavior Model and how it Applies to Good Landing Page Design 00:20:00 Making Your Landing Page Design Memorable 00:14:00 Module 02: Principles of Good Landing Page Design: Examples, Case Studies & Best Practices Download all Section Two Slides 00:06:00 The Primacy of Product and The Concept of Usability in Landing Page Design 00:15:00 Eschew Obfuscation: Clarity and the Quest for Fewer Question Marks 00:11:00 The 5 Second Usability Test in Landing Page Design (and how you can use it now) 00:31:00 The Art and Science Behind Designing High-Converting Calls To Action (CTA's) 00:19:00 Readability and Visual Hierarchy Landing Page Design 00:20:00 Respecting Web Conventions in Landing Page Design 00:13:00 Using Videos, Graphics and Imagery to Increase Landing Page Conversion Rates 00:20:00 Information Architecture and Accessibility - Landing Page Design Best Practices 00:20:00 Trust, Safety and Credibility (Part 1) Landing Page Design Best Practices 00:16:00 Trust, Safety and Credibility (Part 2) Landing Page Design Best Practices 00:09:00 Dedicated Landing Page Design Best Practices (Part 1) 00:15:00 Dedicated Landing Page Design Best Practices (Part 2) 00:12:00 Module 03: Principles of Persuasion in Landing Page Design Download all Section Three Slides 00:32:00 Using Scarcity to Improve Conversion Rates on Your Landing Pages 00:10:00 Principles of Persuasion - Reciprocal Concessions & Reciprocity in Landing Pages 00:12:00 Principles of Persuasion Anchoring and Cognitive Dissonance Theory 00:19:00 Module 04: Designing and Building a Landing Page Step by Step in Unbounce My Favorite Landing Page Builders and Getting Started With Our Unbounce Page 00:10:00 Getting Familiar With the Unbounce Page Builder and Adding Our Header Section 00:07:00 Creating a Logo in Photoshop and Using the Unbounce Image Uploader Tool 00:16:00 Working With Background Imagery in Landing Pages and Developing Our Hero Section 00:16:00 Creating a Form, Action Block, and Finishing the Hero Section in Unbounce 00:19:00 Discussing Landing Page Design Changes and Creating our Primary Content Section 00:16:00 Finishing Page Content, Adding Icons, Footer and Working With Buttons Unbounce 00:11:00 Publishing Your Unbounce Landing Page on Your Custom Domain 00:04:00 Adding Custom CSS in Unbounce to Create Professional Drop Shadows 00:06:00 Making Your Landing Page Design Work Better With Custom Javascript Snippets 00:08:00 Mobile Site Layout in Unbounce Based on Mobile Landing Page Design Guidelines 00:03:00 Designing Your Form Confirmation Dialogue in Unbounce and Testing Your Live Form 00:03:00 Assigning A/B Testing Variants in Unbounce and Assigning Traffic Weights 00:12:00 Integrating Your Unbounce Form Submissions With Your Mailchimp Account 00:09:00 Module 05: Bonus Goodbye For Now I Will Miss You Dearly 00:03:00 Module 06: Bonus Content: Real-Life Audits - Landing Page Design Best Practices Western Computer Audit Part 1 00:08:00 Western Computer Audit Part 2 00:09:00 Western Computer Audit Part 3 00:15:00 Western Computer Audit Part 4 00:14:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK. Learning Outcomes Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface. Develop proficiency in advanced data transformation techniques and data model creation. Integrate Python with Power BI and harness the benefits of both for enhanced data analytics. Master the art of 'Storytelling with Data' to deliver impactful presentations and reports. Understand and implement Row-Level Security and harness Power BI Cloud services efficiently. Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for? Individuals keen on obtaining the Microsoft power bi certification UK. Analysts and data professionals aspiring to enhance their data visualisation skills. Business professionals wanting to leverage Power BI for insightful business decision-making. Tech enthusiasts aiming to amalgamate programming (Python) with data analytics. Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities. Career path Data Analyst: Average Salary £30,000 - £40,000 Annually Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually Power BI Developer: Average Salary £40,000 - £50,000 Annually Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually Prerequisites This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:03:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 00:00:00 Assignment Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This SEO Content Writing & Copy Writing course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The SEO Content Writing & Copy Writing course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to SEO Content Writing & Copy Writing 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 SEO Content Writing & Copy Writing course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this SEO Content Writing & Copy Writing course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The SEO Content Writing & Copy Writing will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:05:00 How to Navigate This Course - Watch This Video 00:03:00 Section 02: Free Taster 13 Copywriting and Sales Buttons You Need to Know How to Push 00:07:00 Copywriting to Sell 10 Steps you must know 00:06:00 14 Step Formula to Writing Great Sales Copy 00:06:00 Section 03: BASICS: 12 Essential Steps to Great Copy Writing AIDA is not just an Opera! 00:02:00 Have you any idea who you are talking to? 00:02:00 Who cares what format you use? 00:03:00 Hurting? Want someone to heal your pain? 00:02:00 I haven't got time or money for Objections! 00:02:00 Don't worry, there's always plenty of Scarcity to go round! 00:02:00 So, why are YOU reading my Headlines? 00:02:00 Why do you always want to know whats in it for you? 00:02:00 Endorsements? Pah! Prove it to me! 00:03:00 I Guarantee to you that I love Risk! Or do I? 00:02:00 Right it Wright to Be Red! or you won't be Readable! 00:03:00 Keep it Simple S. and throw away your Theasaurus 00:02:00 Section 04: BASICS: Copywriting Formulation - Understanding Copywriting Building Blocks Introduction to Copywriting Formulation 00:02:00 Starting with AIDA 00:06:00 PAS - Problem, Agitation, Solution 00:04:00 The 4 Ps 00:03:00 QUEST 00:04:00 Section 05: BASICS: How to Write Headline What You Need to Know to Write Great Headlines 00:06:00 Section 06: BASICS: Proofreading and Editing - How to Edit Sales Copy Writing Editing: Can You Write Better Copy? 00:06:00 Proof Reading and Editing: 20 Ways to Write Better Copy 00:11:00 Editing Writing: Seven Guidelines for Editing Writing 00:06:00 Section 07: PSYCHOLOGY: The Psychology behind Copywriting Get Your Copywriting Psychology Right! 00:06:00 What are the Eight Universal Motivators? 00:07:00 100 Motivations 00:05:00 Overcoming Objections 00:08:00 Section 08: COPYWRITING FOR Blogging - Web Posts Copywriting for Blogs 00:09:00 A Simple Formula for Blog Posts 00:04:00 Blog Post Copywriting Formula 00:09:00 Blog Post Editing Checklist 00:08:00 Section 09: COPYWRITING FOR Landing Pages Copywriting for Landing Pages 00:04:00 Copywriting for Testimonials 00:06:00 Copywriting for Bullet Points 00:05:00 Section 10: COPYWRITING FOR Sales Letters Five Formulations for Sales Letters 00:03:00 The Five Point Sales Letter Formula 00:03:00 The Seven Step Copywriting Formula for Sales Letters 00:05:00 The Nine Point Formula 00:05:00 The 18 Step Sales Letter 00:06:00 The 21 Part Sales Letter Formula 00:08:00 Bonus: 32 Step Power Copywriting Formula 00:08:00 Section 11: COPYWRITING FOR Video Sales Letters What is a Video Sales Letter 00:03:00 How to Write an Attention Grabbing Video Sales Letter Headline 00:03:00 Video Sales Letter Basics - Some Simple Guidance for Better VSLs 00:04:00 Video Sales Letter Outline - with Downloadable Templates 00:07:00 Section 12: COPYWRITING FOR Email Copywriting for Email 00:07:00 How to Write Effective Welcome Emails 00:10:00 ACTIVITY: Analysis of a Long Form Story Telling Email 00:07:00 Email Copywriting Analysis 1 00:05:00 Copywriting Formulas for Email Sequences 00:06:00 Section 13: COPYWRITING FOR Advertisements Copywriting for Advertisements 00:04:00 Section 14: COPYWRITING FOR Twitter Copywriting for Twitter - Engage, Entertain, Be Brief! 00:07:00 Section 15: COPYWRITING FOR Promotional Videos How to Create a High Converting Promotional Video 00:06:00 The Promotional Video for This Course Following the Script 00:02:00 The Promotional Video - Version 2 00:02:00 Promotional Video SlideDeck 00:20:00 Promotional Video Script Checklist 00:04:00 2018 Update: The Formula for an Effective Promotional Video 00:04:00 2018 New Copywriting Course Promo Video 00:03:00 Section 16: Conclusion and Course Wrap Up Conclusion and Course Wrap Up 00:03:00 Additional File Additional File 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

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

Embark on this course in web development with HTML, CSS, JS, and React for a comprehensive training program designed to empower beginners and experienced designers alike with the essential skills needed to create captivating and dynamic websites. Explore the power of React.js, HTML5, CSS3, JavaScript, and build scalable components with React.

It doesn't matter where you are in your web development journey, and you will benefit if you have at least a little knowledge of AJAX. If you have an interest in advancing in AJAX, getting better in the world of full-stack programming, and knowing how you can use AJAX in a practical way to perform CRUD operations-then this course is for you.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Content Writing & Copy Writing For SEO and Sales 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 Content Writing & Copy Writing For SEO and Sales 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 Content Writing & Copy Writing For SEO and Sales 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 Content Writing & Copy Writing For SEO and Sales 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 Content Writing & Copy Writing For SEO and Sales. 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 Content Writing & Copy Writing For SEO and Sales will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:05:00 How to Navigate This Course - Watch This Video 00:03:00 Section 02: Free Taster 13 Copywriting and Sales Buttons You Need to Know How to Push 00:07:00 Copywriting to Sell 10 Steps you must know 00:06:00 14 Step Formula to Writing Great Sales Copy 00:06:00 Section 03: BASICS: 12 Essential Steps to Great Copy Writing AIDA is not just an Opera! 00:02:00 Have you any idea who you are talking to? 00:02:00 Who cares what format you use? 00:03:00 Hurting? Want someone to heal your pain? 00:02:00 I haven't got time or money for Objections! 00:02:00 Don't worry, there's always plenty of Scarcity to go round! 00:02:00 So, why are YOU reading my Headlines? 00:02:00 Why do you always want to know whats in it for you? 00:02:00 Endorsements? Pah! Prove it to me! 00:03:00 I Guarantee to you that I love Risk! Or do I? 00:02:00 Right it Wright to Be Red! or you won't be Readable! 00:03:00 Keep it Simple S. and throw away your Theasaurus 00:02:00 Section 04: BASICS: Copywriting Formulation - Understanding Copywriting Building Blocks Introduction to Copywriting Formulation 00:02:00 Starting with AIDA 00:06:00 PAS - Problem, Agitation, Solution 00:04:00 The 4 Ps 00:03:00 QUEST 00:04:00 Section 05: BASICS: How to Write Headline What You Need to Know to Write Great Headlines 00:06:00 Section 06: BASICS: Proofreading and Editing - How to Edit Sales Copy Writing Editing: Can You Write Better Copy? 00:06:00 Proof Reading and Editing: 20 Ways to Write Better Copy 00:11:00 Editing Writing: Seven Guidelines for Editing Writing 00:06:00 Section 07: PSYCHOLOGY: The Psychology behind Copywriting Get Your Copywriting Psychology Right! 00:06:00 What are the Eight Universal Motivators? 00:07:00 100 Motivations 00:05:00 Overcoming Objections 00:08:00 Section 08: COPYWRITING FOR Blogging - Web Posts Copywriting for Blogs 00:09:00 A Simple Formula for Blog Posts 00:04:00 Blog Post Copywriting Formula 00:09:00 Blog Post Editing Checklist 00:08:00 Section 09: COPYWRITING FOR Landing Pages Copywriting for Landing Pages 00:04:00 Copywriting for Testimonials 00:06:00 Copywriting for Bullet Points 00:05:00 Section 10: COPYWRITING FOR Sales Letters Five Formulations for Sales Letters 00:03:00 The Five Point Sales Letter Formula 00:03:00 The Seven Step Copywriting Formula for Sales Letters 00:05:00 The Nine Point Formula 00:06:00 The 18 Step Sales Letter 00:06:00 The 21 Part Sales Letter Formula 00:08:00 Bonus: 32 Step Power Copywriting Formula 00:08:00 Section 11: COPYWRITING FOR Video Sales Letters What is a Video Sales Letter 00:03:00 How to Write an Attention Grabbing Video Sales Letter Headline 00:03:00 Video Sales Letter Basics - Some Simple Guidance for Better VSLs 00:04:00 Video Sales Letter Outline - with Downloadable Templates 00:07:00 Section 12: COPYWRITING FOR Email Copywriting for Email 00:07:00 How to Write Effective Welcome Emails 00:10:00 ACTIVITY: Analysis of a Long Form Story Telling Email 00:07:00 Email Copywriting Analysis 1 00:05:00 Copywriting Formulas for Email Sequences 00:06:00 Section 13: COPYWRITING FOR Advertisements Copywriting for Advertisements 00:04:00 Section 14: COPYWRITING FOR Twitter Copywriting for Twitter - Engage, Entertain, Be Brief! 00:07:00 Section 15: COPYWRITING FOR Promotional Videos How to Create a High Converting Promotional Video 00:06:00 The Promotional Video for This Course Following the Script 00:02:00 The Promotional Video - Version 2 00:02:00 Promotional Video SlideDeck 00:20:00 Promotional Video Script Checklist 00:04:00 2018 Update: The Formula for an Effective Promotional Video 00:04:00 2018 New Copywriting Course Promo Video 00:03:00 Section 16: Conclusion and Course Wrap Up Conclusion and Course Wrap Up 00:03:00 Additional File Additional File 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Prepare for success with the Microsoft PL-900 Certification Course, covering the fundamentals of Power Platform, including Power BI, Power Apps, Power Automate, Power Virtual Agents, and related topics such as Dataverse, AI Builder, Connectors, Dynamics 365, Teams, Security, and Administration. Suitable for beginners with no prerequisites.

Dealing with Difficult People: Dealing with Difficult People Online Are you struggling to deal with difficult people? Our Dealing with Difficult People: Dealing with Difficult People course can help improve your skills at work. Dealing with Difficult People: Dealing with Difficult People defy logic. Some are blissfully unaware of the negative impact they have on those around them, while others appear to derive satisfaction from causing chaos and pushing other people's buttons. In either case, they add unnecessary complexity, strife and worst of all stress. Stress has long been shown in studies to have a long-term negative impact on the brain. Stress is a formidable threat to your success; when it becomes uncontrollable, your brain and performance suffer. The majority of workplace stressors are easy to identify. Dealing with difficult people is always stressful. We've all been in situations where we had to interact with difficult people, whether at work, school, or over a business lunch. They do exist in the workplace, and the better you become at dealing with them, the happier you will be at work. Dealing with Difficult People: Dealing with Difficult People may take advantage of every opportunity to cause problems, or they may simply use passive resistance to waylay your best efforts to move your agenda forward. While you cannot control others, you can control and improve yourself by doing the following: Recognising your own attitudes and behaviours, creating coping strategies, managing your anger. Through this Dealing with Difficult People: Dealing with Difficult People course, you'll learn how to deal with aggressive, manipulative, undermining, prejudiced, or otherwise difficult people. Main Course: Dealing With Difficult People Course Free Courses included with Dealing with Difficult People: Dealing with Difficult People Course: Along with Dealing With Difficult People Course you will get free Level 5 Report Writing Course Along with Dealing With Difficult People Course you will get free Communication Skills Course Special Offers of this Dealing with Difficult People: Dealing with Difficult People Course: This Dealing with Difficult People: Dealing with Difficult People Course includes a FREE PDF Certificate. Lifetime access to this Dealing with Difficult People: Dealing with Difficult People Course Instant access to this Dealing with Difficult People: Dealing with Difficult People Course 24/7 Support Available to this Dealing with Difficult People: Dealing with Difficult People Course Dealing with Difficult People: Dealing with Difficult People Online Our Dealing with Difficult People: Dealing with Difficult People course has various modules to explain difficult people and their behaviours. How to communicate, solve problems and guide techniques are parts of this Dealing with Difficult People: Dealing with Difficult People course. You also know how to effectively deal with bosses and colleagues are explained in the Dealing with Difficult People: Dealing with Difficult People course. You will be able to make impossible situations possible with this Dealing with Difficult People: Dealing with Difficult People course. Who is this course for? Dealing With Difficult People: Dealing with Difficult People Online This Dealing with Difficult People: Dealing with Difficult People course is ideal for: Anyone involved in communication at work. Executive Assistants or Sales Reps Customer Support Agents Requirements Dealing with Difficult People: Dealing with Difficult People Online To enrol in this Dealing with Difficult People Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Dealing with Difficult People: Dealing with Difficult People Course. Be energetic and self-motivated to complete our Dealing with Difficult People: Dealing with Difficult People Course. Basic computer Skill is required to complete our Dealing with Difficult People Course. If you want to enrol in our Dealing with Difficult People Course, you must be at least 15 years old. Career path Dealing with Difficult People: Dealing with Difficult People Online The Dealing with Difficult People: Dealing with Difficult People course is intended to help you obtain the skills, knowledge, and career of your dreams!

Overview This comprehensive course on Ruby on Rails 5 - Become a Professional Developer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ruby on Rails 5 - Become a Professional Developer 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 Ruby on Rails 5 - Become a Professional Developer. It is available to all students, of all academic backgrounds. Requirements Our Ruby on Rails 5 - Become a Professional Developer 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 23 sections • 225 lectures • 16:47:00 total length •Course Introduction: 00:06:00 •The Application We're Going to Build: 00:09:00 •Section Introduction gg: 00:01:00 •Introduction to the Command Line Interface in Mac and Linux: 00:10:00 •Installing the X-Code Command Line Tools for Mac: 00:02:00 •Installing Git for Source Code Version Control: 00:03:00 •How to install Homebrew on a Mac: 00:04:00 •Installing GPG Security Systems on a Mac: 00:02:00 •Guide to RVM for Ruby Management: 00:09:00 •Configuring RubyGems and Installing Rails: 00:07:00 •Installing the Postgres Database on a Mac: 00:05:00 •Installing and Working with the Sublime Text Editor: 00:17:00 •Deep Dive into the Command Line - Part 1 of 2: 00:14:00 •Deep Dive into the Command Line - Part 2 of 2: 00:12:00 •PC Environment Setup: Installing Virtual Box: 00:03:00 •Guide to Installing Ubuntu Linux in VirtualBox: 00:10:00 •How to Reboot a Linux Virtual Machine from Terminal: 00:02:00 •Installing Desktop Applications and Ubuntu Navigation Tips and Tricks: 00:09:00 •How to Sign Up for a GitHub Account: 00:03:00 •How to install Git on Linux and Connect to GitHub via SSH: 00:20:00 •How to Securely Install Node and NPM on Linux via NVM: 00:09:00 •Installing the Heroku CLI and the Full Deployment Lifecycle: 00:14:00 •How to install and Work with Sublime Text in Linux: 00:08:00 •PC Setup: Guide for Ruby on Rails and Postgres on Linux - Part 1 of 2: 00:10:00 •PC Setup: Guide for Ruby on Rails and Postgres on Linux - Part 2 of 2: 00:15:00 •Fixing the Role Does Not Exist Error: 00:05:00 •Section Introduction ee: 00:01:00 •Signing Up for a Project Management Account: 00:03:00 •Managing the Project Management Dashboard: 00:08:00 •Importing Project Management Tasks into Pivotal Tracker: 00:01:00 •Creating a Rails Application: 00:11:00 •Generating a Blog for the Portfolio Application Using Rails Scaffolds: 00:11:00 •Analyzing the Rails Process: Index and Show Actions: 00:12:00 •Analyzing the Rails Process: New, Create, Update, Edit, and Destroy Actions: 00:14:00 •Analyzing the Rails Process: Routing with Resources: 00:07:00 •Rails File System Overview: 00:13:00 •Updating the Project Management Dashboard: 00:01:00 •Deep Dive: Analyzing the Application Generator - Part 1: 00:12:00 •Deep Dive: Analyzing the Application Generator - Part 2: 00:17:00 •Section Introduction bb: 00:02:00 •How to Sign Up for a Github Account: 00:03:00 •Generating SSH Keys to Securely Communicate with Github: 00:04:00 •Guide to GitHub: 00:12:00 •How to Update a .gitignore File to Securely Store Secret Credentials: 00:11:00 •Guide to the Markdown Syntax: 00:10:00 •Updating the Git Sprint in the Project Management Dashboard: 00:01:00 •Deep Dive: Analyzing Version Control and Git - Part 1: 00:18:00 •Deep Dive: Analyzing Version Control and Git - Part 2: 00:13:00 •Section Introduction aa: 00:01:00 •Guide to the Rails Controller Generator to Build Pages Part 1: 00:16:00 •Guide to the Rails Controller Generator to Build Pages Part 2: 00:05:00 •Guide to the Rails Model Generator to Build out Data Specific Features: 00:17:00 •Guide to the Rails Model Generator for Building Out the Portfolio Feature: 00:10:00 •Deep Dive: Analyze Rails Generators and How to Customize a Generator - Part 1: 00:15:00 •Deep Dive: Analyze Rails Generators and How to Customize a Generator - Part 2: 00:11:00 •Section Introduction SS: 00:02:00 •Building out a Seeds File for Generating Dynamic Sample Data: 00:15:00 •Implement an Index Action from Scratch in Rails: 00:12:00 •Build the New and Create Functionality from Scratch in Rails: 00:20:00 •Implement the Ability to Edit Database Records from Scratch in Rails: 00:13:00 •How to Use the Link to Method in Rails for Creating Dynamic Links: 00:13:00 •How to Implement the Show Action from Scratch in Rails: 00:12:00 •Building the Ability to Delete Items in Rails: 00:15:00 •How to Implement Custom Routes for Pages in Rails: 00:09:00 •How to Override the Rails Resources Routes for the Show Action: 00:07:00 •How to Implement Permalinks in a Rails Application - Part 1: 00:17:00 •How to Implement Permalinks in a Rails Application - Part 2: 00:05:00 •How to Use Enums in Rails to Manage Data Stages: 00:13:00 •How to Implement a Custom Action in Rails via a Button Click - Part 1: 00:12:00 •How to Implement a Custom Action in Rails via a Button Click - Part 2: 00:10:00 •Updating the Project Management Dashboard and Performing a Pull Request: 00:05:00 •Deep Dive: Rails Routing and Data Flow - Part 1: 00:13:00 •Deep Dive: Rails Routing and Data Flow - Part 2: 00:13:00 •Deep Dive: Rails Routing and Data Flow - Part 3: 00:16:00 •Section Introduction RR: 00:01:00 •Implementing Data Validations in Rails 5: 00:12:00 •Guide to Data Relationships in Rails: 00:16:00 •How to Implement Custom Scopes in Rails 5: 00:16:00 •How to Set Default Values in Rails 5: 00:13:00 •How to Use Concerns in Rails 5: 00:13:00 •Building an Additional Parent/Child Relationship in Rails 5: 00:10:00 •Rails 5 Complex Forms: Configuring Nested Attributes in the Model: 00:17:00 •Rails 5 Complex Forms: Configuring Nested Attributes in the Form: 00:17:00 •Deep Dive: Working with SQL and ActiveRecord in Rails 5 - Part 1: 00:16:00 •Deep Dive: Working with SQL and ActiveRecord in Rails 5 - Part 2: 00:14:00 •Deep Dive: Working with SQL and ActiveRecord in Rails 5 - Part 3: 00:15:00 •Section Introduction QQ: 00:01:00 •How to Install Devise in Rails 5: 00:08:00 •Using Devise to Implement Registrations and Login Functionality: 00:18:00 •Building Custom Routes for Authentication Pages with Devise in Rails 5: 00:03:00 •Enable Users to Logout and Dynamically Render View Content in Rails 5: 00:07:00 •How to Add Custom Attributes to a Devise Based Authentication System: 00:15:00 •How to Use Controller Concerns in Rails 5 for Devise Custom Attributes: 00:15:00 •Integrate Virtual Attributes to Extract First and Last Name Data from a User: 00:17:00 •Deep Dive: Using BCrypt to Implement Encryption in Ruby: 00:19:00 •Section Introduction PP: 00:01:00 •Rails Data Flow Review and Working with Params: 00:14:00 •Using Rails Sessions to Share Data between Pages: 00:19:00 •Refactoring the Session Tracker into a Controller Concern: 00:07:00 •Working with Strong Params in a Rails 5 Controller: 00:13:00 •Deep Dive: Building a Guest User Feature in Rails - Part 1: 00:14:00 •Deep Dive: Building a Guest User Feature in Rails - Part 2: 00:18:00 •Section Introduction OO: 00:03:00 •How to Customize the Rails Master Layout File - Part 1: 00:15:00 •How to Customize the Rails Master Layout File - Part 2: 00:09:00 •Guide to Using Multiple Layout Files in Rails 5: 00:14:00 •Introduction to Rendering Collections via Partials in Rails 5: 00:09:00 •Introduction to Partials in Rails 5: 00:08:00 •How to Send Data to Partials to Generate Custom Behavior in Rails 5: 00:15:00 •Guide to View Helpers in Rails 5: 00:17:00 •How to Use the Rails Content Tag Helper to Auto Generate HTML Code: 00:15:00 •Introduction to Rendering Collections via Partials in Rails 5: 00:09:00 •Guide to Manually Configuring Partials to Work with Collections in Rails: 00:07:00 •Guide to Helpful ActionView Helper Methods in Rails 5: 00:15:00 •Deep Dive: Tips and Tricks to Working with ActionView in Rails 5 - Part 1: 00:12:00 •Deep Dive: Tips and Tricks to Working with ActionView in Rails 5 - Part 2: 00:15:00 •Section Introduction NN: 00:01:00 •How to Utilize Puts Debugging in Rails: 00:08:00 •Guide to Byebug in Rails 5: 00:09:00 •Guide to Debugging with Pry in Rails 5: 00:19:00 •Proper Way to Implement Error Management in a Rails Application - Part 1: 00:15:00 •Proper Way to Implement Error Management in a Rails Application - Part 2: 00:06:00 •Section Introduction MM: 00:01:00 •How to Install Bootstrap 4 into a Rails 5 Application - Part 1: 00:10:00 •How to Install Bootstrap 4 into a Rails 5 Application - Part 2: 00:12:00 •Section Strategy for Building a Custom RubyGem: 00:11:00 •How to Build a RubyGem from Scratch - Part 1: 00:06:00 •How to Build a RubyGem from Scratch - Part 2: 00:15:00 •Section Introduction hh: 00:02:00 •Introduction to Authorization and How to Install the Petergate Gem: 00:08:00 •How to Add Roles to the User Model in Rails 5: 00:05:00 •Guide to Implementing Petergate in Rails 5 Application - Part 1: 00:15:00 •Guide to Implementing Petergate in Rails 5 Application - Part 2: 00:12:00 •Workplace Facilities: 00:35:00 •Portfolio Design Planning for Layout Specific Styles: 00:09:00 •Implementing the Initial Homepage Design in Rails 5 with Bootstrap 4: 00:09:00 •Building a Navigation Partial for the Master Application Layout with Bootstrap: 00:11:00 •Implement a Footer Along with Adding Method Arguments to a Rails View Helper: 00:14:00 •How to Embed a Google Map into a Rails Application: 00:06:00 •Guide to Updating the Styles for the Devise Edit Account Page in Rails: 00:16:00 •How to Override Default Bootstrap Styles for Text Alignment in the Card Class: 00:06:00 •Implementing Styles for the Devise Registration Page with Bootstrap 4: 00:14:00 •How to Design the Login and Password Pages with Bootstrap 4 Form Styles: 00:15:00 •How to Set Default Values for View Helper Method Arguments in Rails 5: 00:04:00 •Integrating a Different Design for a Separate Blog Layout in Rails 5: 00:04:00 •How to Use Bootstrap 4 to Add a Custom Nav Bar to a Blog Layout in Rails: 00:07:00 •Customizing the Design for the Blog Index Page with Bootstrap 4: 00:19:00 •Guide to Adding Styles to the Blog Show and Form Pages with Bootstrap 4: 00:12:00 •Implementing Partials, Pagination, and Font Awesome Icons - Part 1: 00:23:00 •Implementing Partials, Pagination, and Font Awesome Icons - Part 2: 00:23:00 •Initial Design for the Portfolio Index Page with Bootstrap 4: 00:17:00 •Integrating the Portfolio Animated Navigation Slider, Footer, and Index: 00:14:00 •Using the Bootstrap 4 Grid Layout to Style the Portfolio Show Page in Rails: 00:06:00 •Implementing Bootstrap 4 Forms for the Portfolio Form Pages: 00:13:00 •How to Build a View Helper to Dynamically Generate a Nav Bar - Part 1: 00:20:00 •How to Build a View Helper to Dynamically Generate a Nav Bar - Part 2: 00:19:00 •Deep Dive: Rails Asset Pipeline Part 1: 00:01:00 •Deep Dive: Rails Asset Pipeline Part 2: 00:19:00 •Section Introduction LL: 00:01:00 •How to Integrate a Position Attribute and Custom Scope in Rails: 00:12:00 •Installing the jQuery UI and html5sortable JavaScript Libraries in Rails 5: 00:09:00 •Initial Implementation of Drag and Drop Interface in Rails 5: 00:13:00 •Implementing Drag and Drop Functionality into a Ruby on Rails 5 App Part 1: 00:18:00 •Implementing Drag and Drop Functionality into a Ruby on Rails 5 App Part 2: 00:11:00 •Implementing Authorization Rules for Drag and Drop Feature with Petergate: 00:07:00 •Deep Dive: jQuery CoffeeScript in Rails: 00:19:00 •Section Introduction jj: 00:01:00 •Introduction to Using Images and the Rails Asset Pipeline: 00:12:00 •How to Set a Full Size Video Background in Rails with Bootstrap 4: 00:08:00 •Deep Dive: Installing and Configuring Carrierwave for Image Uploads in Rails 5: 00:20:00 •Deep Dive: Integrating Connection to AWS S3 for File Hosting with Carrierwave: 00:14:00 •Implementing File Upload Button Styles and Refactoring Placeholder - Part 1: 00:06:00 •Implementing File Upload Button Styles and Refactoring Placeholder - Part 2: 00:19:00 •Section Introduction ii: 00:01:00 •Difference Between form_form and form_tag in Rails - Part 1: 00:15:00 •Difference Between form_form and form_tag in Rails - Part 2: 00:16:00 •How to Integrate Cocoon in Rails 5 for jQuery Nested Forms: 00:20:00 •Guide to Integrating Alerts that Automatically Fade Away in Rails 5: 00:15:00 •Refactoring Alert Notifications to Use a Shared View Helper in Rails: 00:13:00 •Deep Dive: How to Build an HTML Form from Scratch the Works with Rails: 00:17:00 •Section Introduction ff: 00:03:00 •Integrating the Twitter Gem to Pull in Tweets in Rails 5: 00:20:00 •How to Render Tweets on a Rails View Page: 00:07:00 •Building a Parser View Helper Method to Make Twitter Links Clickable in Rails: 00:15:00 •Customizing the Styles for the Tech News Page with Bootstrap 4: 00:07:00 •Section Introduction cc: 00:01:00 •Running the Comment Generator and Installing the NoSQL Redis Database in Rails 5: 00:18:00 •Building the Comment Form and Required Controller Actions - Part 1: 00:14:00 •Building the Comment Form and Required Controller Actions - Part 2: 00:08:00 •Refactoring the Comment Form into a Partial and Implementing Data Validations: 00:05:00 •Building the jQuery Functions for Processing Comments - Part 1: 00:19:00 •Building the jQuery Functions for Processing Comments - Part 2: 00:05:00 •How to Create a Broadcast with ActionCable in Rails 5: 00:14:00 •Guide to Implementing Live Data Updates in a Rails 5 Application - Part 1: 00:15:00 •Guide to Implementing Live Data Updates in a Rails 5 Application - Part 2: 00:06:00 •Styling the Comment Section and Implementing Gravatar Based Thumbnails in Rails: 00:16:00 •Section Introduction dd: 00:01:00 •Planning Final Project Updates and Assignment: 00:11:00 •Building a Scope to Show the Most Recent Blog Posts and Hiding Draft Posts: 00:09:00 •Hiding the Show Page for Blogs in Draft Mode in Rails 5: 00:04:00 •How to Add a Drop Down Form Element in Rails 5 for Parent/Child Relationships: 00:09:00 •Using the Controller Generator to Build the Topic Features - Part 1: 00:10:00 •Using the Controller Generator to Build the Topic Features - Part 2: 00:11:00 •How to Build a Widget for the Blog to Render Topics in Rails 5: 00:17:00 •How to Implement Radio Buttons in a Rails Form to Update Enum Values: 00:09:00 •Guide to Integrating Markdown and Syntax Highlighting in a Rails 5 Application: 00:13:00 •Integrating Breadcrumbs and Icons for the Blog Show Pages: 00:12:00 •Building a Partial for Managing Admin Actions for Blog Posts: 00:15:00 •How to Implement a Responsive Navigation Bar with Bootstrap 4: 00:11:00 •Updating the Source/Session Tracking System for the New Layouts: 00:14:00 •How to Integrate a Favicon in Rails 5: 00:08:00 •Implementing Responsive Image Components for the Portfolio Layout: 00:06:00 •Adding Card Styles to the About and Contact Pages: 00:09:00 •How to Implement Collapsable Content Components in a Rails 5 Application: 00:09:00 •How to Integrate Bootstrap Progress Bars in a Rails Application: 00:13:00 •How to Integrate Custom Fonts in a Rails 5 Application: 00:17:00 •Updating the Seeds File in Rails: 00:07:00 •Signing Up for and Creating a New Heroku Application: 00:04:00 •How to Deploy a Rails 5 Application to Heroku: 00:13:00 •Working with the Rails Console on Heroku: 00:11:00 •Installing Redis on Heroku for ActionCable Commenting Feature: 00:04:00 •Configuring Action Cable to Work on Heroku: 00:11:00 •How to Implement the Typed.js Library into a Rails 5 Application: 00:12:00 •How to Install and Configure Webpack, Yarn, and jQuery into a Rails 5.1+ App: 00:19:00 •How to Work with Encrypted Credentials in Rails 5.2+: 00:24:00