Deepen your knowledge and understanding of the oil and gas industry through the Oil and Gas Industry Level 2 course. Whether you want to pursue a career in these industries or wish to invest in oil or gas, this course will come in handy. From the Oil and Gas Industry Level 2 course, you will learn about the core principles and characteristics of the oil and gas industry. The easy to follow modules will help you develop a clear understanding of energy resources. You will also receive detailed lessons on energy consumption forecasts. This course will provide you with deep insight into the process of oil and gas production. In addition, you will get introduced to the financial aspects of these industries. This Oil and Gas Industry Level 2 course is the perfect training ground for aspiring professionals in the oil and gas industry. So, if you are one of them, enrol on the course and start preparing for a promising career. Learning Objectives Learn about the essential characteristics of the oil industry Enrich our knowledge of energy resources Develop your skills in energy consumption forecast Understand the basic principles of oil and gas production Familiarise yourself with the facts and figures of the oil and gas industry Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Oil and Gas Industry Level 2 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 Oil and Gas Industry Level 2 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 Upon successfully completing the Oil and Gas Industry Level 2 course, 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: Refinery operators Refinery technicians Business Owners Investor Course Curriculum Module 01: About the Course Introduction 00:02:00 Module 02 Oil in Our Economic Life Oil in our economic life: Introduction 00:02:00 The role of oil in our economic life 00:03:00 Module 03: The Characteristics of the Oil Industry Centers of production and demand 00:02:00 Exploration risks 00:01:00 The importance of capital investment 00:03:00 Associations between companies 00:01:00 The concentration of production 00:01:00 Module 04: A Brief History of the Oil Industry and Petroleum Refining The beginnings of the oil industry 00:04:00 The Rockefeller era 00:05:00 The development of the oil industry 00:02:00 The world oil order before 1960 00:02:00 The formation of the OPEC and the 2 oil shocks 00:07:00 The consequences of the 2 oil shocks 00:03:00 The 1986 oil counter shock 00:05:00 The Gulf Crisis 00:02:00 The current situation 00:06:00 Module 05: Energy, Oil and Economic Development Energy equivalence 00:05:00 The world energy balance 00:04:00 Regional energy balances 00:01:00 Energy consumption and wealth 00:03:00 Energy consumption and price 00:02:00 Module 06: Energy Consumption Forecast Energy consumption forecast 00:06:00 Module 07: Energy Resources Energy resources 00:06:00 Module 08: Production of Oil and Gas The historical development 00:05:00 The current position 00:03:00 Future prospects 00:01:00 The production of natural gas 00:02:00 Module 09: The Players of the Oil Scene The consuming countries 00:04:00 OPEC 00:07:00 The major oil companies 00:09:00 Module 10: Investments Facts and figures 00:03:00 Module 11: Profitability Facts and figures 00:02:00 Module 12: Conclusion Conclusion 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Welcome to the Blender to Unreal Engine 3D Props Medieval Gallows course. In this course, we will be creating a set of medieval gallows with aged wooden planks and rope. These medieval gallows game assets also incorporate animated elements such as a collapsible platform that was used to run the executions in the medieval age.
Ready to turn your tech interest into a job-ready CV? This 20-in-1 Computer Programming & IT bundle brings together the high-demand digital skills and professional proficiencies that employers across tech, marketing, and finance are actively looking for. With versatile topics spanning programming, cybersecurity, and even communication and freelancing essentials, this is your one-stop shortcut to becoming highly employable in a competitive digital job market—without spending thousands. Description Whether you're eyeing a junior developer role, digital marketing assistant, or want to become a freelance tech consultant, this bundle is purpose-built to unlock opportunities. It doesn’t matter if you’re changing careers, stepping into IT for the first time, or adding programming to your skill stack—this all-in-one collection will help you stand out. Don’t miss the opportunity to future-proof your profile. With employers favouring adaptable candidates who can code, collaborate, and communicate effectively, the smart money is on building a toolkit that spans more than just code. Secure lifetime access today—before the next wave of applicants get ahead. FAQ Who is this bundle for? Aspiring programmers, IT support enthusiasts, digital marketers, freelancers, and career changers looking to break into tech-based roles. Is this bundle suitable for absolute beginners? Yes. It’s structured to be accessible to those with no background, while still being valuable for those refining their skill set. How does this make me more hireable? By covering both technical and workplace competencies, it positions you as a multi-skilled candidate ready for dynamic roles across multiple industries. What kind of jobs can this help with? Think: Junior Developer, IT Technician, Data Entry Officer, Network Support, Web Assistant, Freelance Programmer, and more. Is there a time limit to complete the bundle? No. Once enrolled, you get lifetime access to all 20 courses—study when it suits you. Why should I act now? Opportunities in tech are growing fast. Don’t let hesitation be the reason someone else gets the job you wanted.
If you still haven't found the exact information about becoming a professional Graphic Designer, this course is all you need! This unique course is designed to provide you with a detailed overview and direction to become an expert Graphic Designer. You will gain a holistic understanding of this creative industry and develop the skills you oblige to work as a Graphic Designer. Graphic Designing is a dynamic, challenging, creative and fast-growing industry. It has the potential to be an incredibly rewarding career path. This course presents easy to understand modules, where you will find information about the job role, the type of work involved with it, the importance of software skills and many more. If you've always dreamed of taking that crucial step into Graphic Designing, taking this course will be ideal for you! Learning Outcomes: Discover a complete guide you on your journey to become a designer. Get answers to all your queries about becoming and being a graphic designer. Gain insider information about this creative industry. Explore all the essential tools that designers need and become familiar with the essential applications used by professional designers to get the work done. Improve your understanding of the best practices to boost earnings. Get a thorough understanding of jobs you can get after completing a graphic designing course. Who is the course for? Business professionals who need to learn about workplace health and safety methods People who have an interest in knowing how to handle health and safety Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of 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 This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Should I be a Designer? Promo 00:02:00 What do I need to become a Designer? 00:05:00 What is it like to be a Designer? 00:02:00 How much can I earn as a Designer? 00:03:00 Costs of being a Designer 00:05:00 Freelancing vs Full time job 00:04:00 Where should I work? 00:04:00 Lifelong learning 00:02:00 Workspace Chair 00:02:00 Desk 00:03:00 Bookshelf 00:01:00 Pinboard 00:01:00 Desktop 00:01:00 Tools Computer and Screen 00:02:00 Storage and Backup 00:01:00 Wacom tablets and Pen displays 00:03:00 Camera 00:01:00 Mobile phones and Tablets 00:01:00 Applications Photoshop 00:05:00 Illustrator 00:01:00 InDesign 00:02:00 Acrobat 00:01:00 Lightroom 00:01:00 Bridge 00:01:00 Essential Skills Intro 00:01:00 Composition and Layout 00:02:00 Digital Image Theory 00:03:00 Layers 00:02:00 Colors 00:02:00 Selections 00:02:00 Masking 00:01:00 Pen tool 00:02:00 Adjustments 00:01:00 Image Editing and Filters 00:02:00 Brush Tool 00:01:00 Typography 00:02:00 Images in InDesign 00:01:00 Tracing Images 00:01:00 Camera RAW 00:03:00 Specialization Intro 00:01:00 Print Design 00:02:00 Web, Tablet and Mobile design 00:02:00 Photo Retouch 00:01:00 Digital Art 00:02:00 Getting Recognized Intro 00:01:00 Getting Inspired 00:04:00 Keep track of your tasks 00:02:00 Crowd-sourcing and contests 00:03:00 Sharing your work 00:01:00 Screen-casting and Blogging 00:02:00 Portfolio 00:04:00 Internship 00:02:00 Certfication 00:02:00 Creative CV 00:02:00 Applying for jobs and attending Interviews 00:03:00 Conclusion What's next? 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Welcome to the Blender to Unreal Engine 3D Props Medieval Market Stall course. In this course, we will be creating a medieval market stall game asset incorporating cloth simulation. One of the best parts of the course is finding out a clever way of distributing numerous vegetables in a crate using an emitter.
In this Advanced Diploma in User Experience UI/UX Design course, you will learn everything you need to know to become an expert UI/UX designer. We will start by teaching you the basics of UX and UI design and then move on to more advanced topics like wireframing prototyping, and usability testing. We will also teach you how to use Adobe XD, a powerful design tool professionals use worldwide. UI/UX design is the process of creating products that are user-centred. It is all about understanding user demands and building goods to fulfil those goals. This User Experience Design course will begin with an overview of the web industry, with an emphasis on essential concepts and trends. You will then learn about the fundamentals of graphic design, understanding the principles and techniques that underpin visually appealing designs. You will explore the exciting world of UX design with a solid foundation, concentrating on building user-centred experiences that meet users' requirements and aspirations. The course will also teach you how to integrate your UX design thoughts into aesthetically appealing user interfaces. To bring your ideas to life, you will use Adobe XD, a sophisticated design tool. You will find optimisation tactics along the way to improve the performance and usability of your designs. Furthermore, this course offers useful insights on how to begin a career in UI/UX design, as well as resources and support to help you excel in the sector. Practical assignments will allow you to put your newly learned abilities to use and receive feedback, ensuring that you obtain experience throughout your learning journey. Join us in the User Experience Design from A-Z: Adobe XD UI/UX Design course to realise your full potential as a UI/UX designer. Begin by developing memorable and user-friendly digital experiences that engage users and create a lasting impression. Enrol now and start your path to a successful career in UI/UX design! Learning Outcomes: Upon completion of the User Experience Design course, you will be able to: Understand the main concepts and trends in the web industry. Apply the principles of graphic design to create visually appealing designs. Properly design user-centred experiences that meet users' needs and goals. Translate UX design concepts into visually engaging user interfaces. Utilise Adobe XD to bring your designs to life with interactive prototypes. Optimise designs for improved performance and usability. Gain valuable insights and resources for starting a career in UX/UI design. Who is this course for? This User Experience Design course is ideal for: Beginners interested in entering the UX/UI design field. Graphic designers looking to expand their skill set into UX/UI design. Web designers seeking to enhance their understanding of user experience. Product managers and developers aiming to collaborate effectively with designers. Individuals passionate about creating intuitive and impactful digital experiences. Career Path Our course will prepare you for a range of careers, including: Junior UX/UI Designer: £25,000 - £40,000 per year. UX/UI Designer: £35,000 - £70,000 per year. Senior UX/UI Designer: £50,000 - £100,000 per year. UX/UI Design Lead: £80,000 - £90,000 per year. UX/UI Design Manager: £95,000 - £120,000 per year. UX/UI Design Director: £120,000+ per year. Certification After studying the course materials of the Advanced Diploma in User Experience UI/UX Design there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Advanced Diploma in User Experience UI/UX Design does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced Diploma in User Experience UI/UX Design 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. Course Curriculum UX/UI Course Introduction Learn UX/UI Course Overview 00:05:00 Section Overview 00:04:00 UX vs UI 00:04:00 UX/UI Designer Marketplace 00:05:00 Overview of UX Roles 00:06:00 Introduction To The Web Industry Web Industry Section Overview 00:03:00 The Phases of Web Development 00:13:00 Designer Responsibilities (working in a team) 00:09:00 Roles & Descriptions (working in a team) 00:05:00 Agile Approach To Project Management 00:12:00 Scrum - Flexible Framework 00:06:00 Project Management Apps 00:13:00 XD Lesson - Introduction 00:13:00 Foundations of Graphic Design Graphic Design Section Overview 00:02:00 The Psychology of Color 00:13:00 Color Wheel & Color Schemes 00:06:00 Working with Fonts 00:10:00 Working With Icons 00:04:00 XD Lesson - Tools, Object Manipulation and Components 00:13:00 XD Lesson - Font Styles and Artboard Settings 00:07:00 Graphic Design Software Tools 00:03:00 Adobe XD lesson 4 - Icons & Vector Graphics 00:14:00 UX Design (User Experience Design) UX Design Section Overview 00:04:00 What is User Experience Design? (UX) 00:09:00 UX Design Process 00:03:00 The UX Analysis Process 00:08:00 Working with User Profiles 00:03:00 Understanding User Pain Points 00:03:00 XD Lesson 5 Class Project: Сompetitive Analysis 00:10:00 Developing a Persona Part 1 00:05:00 Developing a Persona Part 2 00:05:00 Customer Journey 00:04:00 Customer Journey vs Sales Funnel 00:04:00 3 Phases of a Sales Funnel 00:07:00 4 Stages of a Sales Funnel 00:06:00 Macro/Micro Conversions 00:05:00 Stages of Market Sophistication 00:06:00 Lead Generation Funnel 00:06:00 Digital Product Sales Funnel 00:05:00 7 Principles of Influence 00:12:00 Age Based Influence Triggers 00:06:00 Gender Influence Triggers 00:06:00 Interest Based Marketing 00:04:00 Understanding User Flow 00:08:00 XD Lesson 6 Class Project: Userflow - Your first UX deliverable 00:07:00 Working with Story Boards 00:05:00 XD Lesson 7 Class Project: Crafting a Story board 00:09:00 Working with Moodboards 00:04:00 XD Lesson 8 Class Project: Creating Moodboard 00:11:00 Sitemap & Information Architecture 00:07:00 XD Lesson - Class Project: App Architecture 00:09:00 Low and Hi Fidelity Wireframes 00:03:00 XD Lesson - Class Project: Login Screen Wireframe Using Material Design 00:08:00 Working with Prototypes 00:04:00 XD Lesson - Class Project: Home Screen Wireframe and Linking 00:07:00 XD Lesson - Class Project: Adding Interaction to Wireframes 00:10:00 Testing and Evaluating 00:11:00 UX Deliverables 00:03:00 UX Design Conclusion 00:01:00 UI Design (User Interface Design) UI Design Section Overview 00:03:00 UI Design Overview 00:03:00 Types of Interfaces 00:10:00 Landing Pages Overview 00:10:00 XD Lesson - Using Grids in XD 00:08:00 XD Lesson - Single Card design 00:13:00 UI Controls 00:07:00 UI Navigational Components 00:12:00 Header Design Overview 00:07:00 XD Lesson - Mobile & Desktop: Header Design 00:10:00 XD Lesson - Mobile & Desktop: Dropdown Design 00:06:00 Common Layouts Overview 00:08:00 XD Lesson - Common Layouts 00:07:00 Mobile & Desktop Footer Design Overview 00:07:00 XD Lesson - Mobile & Desktop: Footer Design 00:06:00 Mobile & Desktop Button Design Overview 00:05:00 XD Lesson - Mobile & Desktop: Button Design 00:10:00 XD Lesson - Mobile & Desktop: Input Design 00:07:00 Mobile & Desktop Filter Search Bar Design Overview 00:06:00 Adobe XD Lesson - Mobile & Desktop: Filter Design 00:07:00 Adobe XD Lesson - Mobile & Desktop: Search Design 00:03:00 UI Kit Overview 00:05:00 Adobe XD Lesson - Desktop and Mobile: UI Kit 00:06:00 Microinteractions Overview 00:05:00 Adobe XD lesson - Microinteractions 00:07:00 Optimization Optimization Section Overview 00:02:00 Feedback Review & Getting Referrals 00:04:00 'Above the Fold' Rule 00:04:00 Adobe XD lesson - Designing a Powerful Above the Fold 00:08:00 Using Analytics For Optimization 00:05:00 Heat Maps & Element Placements 00:04:00 Crafting A Usability Report Overview 00:08:00 Adobe XD lesson - Crafting Reports in XD 00:20:00 Starting a Career in UX/UI Design Careers in UX/UI Section Overview 00:06:00 Your Daily Productivity Hub 00:14:00 How To Start Freelancing 00:08:00 Client Consulting 00:04:00 Building a Brand 00:10:00 Personal Branding 00:06:00 The Importance of Having a Website 00:08:00 Creating a Logo 00:05:00 Step by Step Website Setup 00:17:00 UI Templates 00:06:00 Logo Templates 00:04:00 Creating a Business Email 00:06:00 Networking Do's and Don'ts 00:04:00 Top Freelance Websites 00:10:00 UX/UI Project Scope Questions 00:10:00 Laser Focus & Productivity Tools 00:06:00 The Places to Find UX Jobs 00:05:00 Resources Resources - Advanced Diploma in User Experience UI/UX Design 00:00:00 Assignment Assignment - Advanced Diploma in User Experience UI/UX Design 00:00:00
Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst 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:04: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:04: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 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 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:07: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 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 Excel's 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 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:14: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 Lopps 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 Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Looking for a fast-track into remote work, freelancing, or online business support roles? The Virtual Assistant and Social Media Manager Mini Bundle is your career catalyst. With courses like Virtual Assistant, Administrative Assistant, Data Entry, GDPR, and Report Writing, this bundle is laser-focused on the skills today’s digital employers demand. Whether you're pivoting into remote work or seeking virtual job roles in marketing, customer service, or executive support, this is your all-in-one hiring-ready toolkit. Description This isn’t just another online course bundle — it’s a job-winning shortcut into a booming industry. With key training in Virtual Assistant, Administrative Assistant, Data Entry, GDPR, and Report Writing, you’re setting yourself up for real work in the fastest-growing segment of today’s economy: remote and hybrid work. Whether you want to support entrepreneurs, manage digital clients, handle sensitive data, or assist executives, these courses give you skills that translate directly into opportunities. The demand for Virtual Assistant and Administrative Assistant roles has never been higher, and businesses now expect strong Data Entry, compliance with GDPR, and professional Report Writing from all hires — even freelancers. This bundle isn’t just about training — it’s about getting work. And the best part? These are roles you can do from anywhere. Don’t get left behind — the digital job market rewards those who act fast. FAQ Q: Is this bundle remote-work friendly? A: 100%. These roles — Virtual Assistant, Administrative Assistant, Data Entry, GDPR, Report Writing — are built for remote, freelance, and hybrid careers. Q: What jobs can I apply for with this? A: Virtual assistant, executive assistant, social media manager, compliance support, content assistant, data entry specialist, client success associate — and many more. Q: Is it suitable for beginners? A: Absolutely. The bundle is designed to help you enter the job market, no matter your background. Q: What’s the job outlook like? A: Remote work isn’t slowing down — and demand for Virtual Assistant, Administrative Assistant, Data Entry, GDPR, and Report Writing skills is exploding across industries.
Retargeting helps to promote brand awareness and sales. It involves reconnecting with the website visitors and persuading them to take action. This Retargeting Ads - The Complete Guide course will explain the steps to run a successful retargeting campaign. This Retargeting Ads - The Complete Guide course will provide you with valuable insights into remarketing and retargeting and their objectives. You'll learn the techniques to create intelligent retargeting and remarketing strategies for better advertising. Furthermore, you'll know how to use Google Analytics to develop your audience segments and build your remarketing audiences in a Google Analytics account. You'll also learn to configure your remarketing campaigns and make your retargeting audience with Google Adwords. Learning Objectives Know the difference between retargeting and remarketing Understand how retargeting works Learn the remarketing strategies to re-engage your prior customers Gain an excellent understanding of Google Analytics Tag Understand the benefits of using Google Tag manager Know how to use Google Analytics to develop and build your audience segments Explore the process of remarketing with Google Analytics Understand how Google ads audience manager works Who is this Course for? This Retargeting Ads - The Complete Guide course 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 retargeting ads 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career Path On successfully completing the Retargeting Ads - The Complete Guide course, 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: Paid Media Manager PPC Manager Digital Marketing Assistant Course Curriculum Module 01: Welcome and Introduction Welcome to the retargeting ad masterclass (plus a sneak preview) Don't Skip! 00:07:00 What is remarketing and retargeting? Defining our objectives and purpose 00:17:00 Module 02: The Digital Advertising Ecosystem: Understanding How Retargeting Works The Digital Advertising Ecosystem 00:08:00 Understanding Ad Exchanges And How They Work 00:20:00 What Remarketing Looks Like On The Inside 00:10:00 Module 03: Developing Your Remarketing and Retargeting Strategies Audiences and Segments: The Foundation Of Your Remarketing Strategy 00:07:00 Understanding Intent Signals and Visitor Engagement 00:12:00 Behavioural Characteristics - The Composition Of Your Segments 00:15:00 Combining Characteristics - Infinite Possibilities! 00:07:00 Characteristics That Matter To You Your First Assignment 00:02:00 Module 04: Planning Your Retargeting Campaigns Like A Pro Funnel Based Segmentation - Funnel Mapping 00:10:00 Funnel Based Segmentation - Using The Funnel To Develop Your Lists 00:14:00 Using Your Website To Plan Your Remarketing Lists 00:19:00 Mapping Your Ad Groups Using Your Lists and Values (Part 1) 00:13:00 Mapping Your Ad Groups Using Your Lists and Values (Part 2) 00:14:00 Module 05: Using Google Analytics To Develop and Build Your Audience Segments Introduction To The Google Analytics Tag 00:05:00 Logging In To Google Analytics Account & Retrieving Your Analytics Tracking Tag 00:04:00 Adding Your Google Analytics Tag To Your Website And Verifying That It's Working 00:13:00 Module 06: Tips, Tricks & Shortcuts Using Google Tag Manager as Your Tag Management System The Benefits Of Using Google Tag Manager 00:10:00 Signing Into Your Google Tag Manager Account 00:08:00 Adding Your Basic Google Analytics Tag Through Google Tag Manager 00:11:00 Setting Up Custom Button and Link Click Tracking In Google Tag Manager 00:20:00 Adding Page-Level Scroll Depth Tracking In Google Tag Manager 00:15:00 Adding Custom User Engagement Timers In Google Tag Manager 00:13:00 Adding Google Adwords Conversion Tracking Through Google Tag Manager 00:10:00 Setting Up Your Google AdWords Remarketing Tag Using Google Tag Manager 00:10:00 Module 07: Building Your Remarketing Audiences In Your Google Analytics Account Linking Your Google AdWords and Google Analytics Accounts 00:10:00 Introduction To The Google Analytics Audience Builder 00:17:00 Building Remarketing Audiences In Google Analytics Based On URL Attributes 00:18:00 Developing Remarketing Audiences Using Your AdWords Campaigns and AdWords Data 00:22:00 Setting Up Sequences In The Google Analytics Audience Builder Using AdWords Campaigns Final 00:05:00 Setting Up Goal-Based Remarketing Audiences In Google Analytics 00:14:00 Setting Up Event-Based Audiences Using The Google Analytics Display Builder 00:17:00 Importing Remarketing Audiences From The Google Analytics Solutions Gallery 00:11:00 Data Drilldown- Using Affinity Categories To Enhance Your Remarketing Campaigns 00:19:00 Data Drilldown - Using In-Market Segments To Enhance Your Remarketing Audiences 00:12:00 Module 08: Introduction To Configuring Your Remarketing Campaigns In Google AdWords How Google Analytics and AdWords Talk To Each Other 00:09:00 Importing Google Analytics Goals into AdWords For Conversion Tracking 00:06:00 Viewing and Analysing Google Analytics Remarketing Audiences in Google AdWords 00:14:00 Module 09: Using The Google AdWords Audience Builder To Build Your Retargeting Audiences Introduction To Building Retargeting Ads Lists In Google AdWords 00:05:00 Building and Configuring New Retargeting ads lists inside Google AdWords 00:10:00 Using Custom Combinations To Effectively Sculpt Your Retargeting Ads Traffic 00:11:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00