• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1474 Courses

Level 3 Diploma in Adobe InDesign

4.5(3)

By Studyhub UK

Step into the realm of digital design with the Level 3 Diploma in Adobe InDesign, a meticulously structured course that transforms beginners into adept designers. Picture yourself bringing ideas to life with the sleek sophistication of Adobe InDesign, an indispensable tool in the creative industry. This programme offers a comprehensive exploration, from the fundamentals to intricate document creation techniques, ensuring a rich understanding of design principles and the software itself. With lessons such as 'Let's Start Creating!' and 'Master Text Frames', each module is an invitation to master InDesign's powerful features. Imagine crafting stunning multi-page documents, manipulating text to flow seamlessly across pages, and creating engaging tables and hyperlinks. The curriculum encourages you to not just learn, but apply your knowledge through practical assignments like creating a real estate listing and a mock setup document, culminating in a capstone final project. The final segments of the course concentrate on refining your work, emphasising the importance of preflighting and exporting settings for professional output. Your journey through the programme culminates in a 'Final Project', designed to be the synthesis of all you've learned, showcasing your newfound capabilities. By the end, you'll not only have a portfolio of work but also the confidence to apply your skills in a myriad of professional scenarios. Learning Outcomes of Level 3 Diploma in Adobe InDesign: Gain proficiency in the Adobe InDesign interface and customise it to enhance workflow efficiency. Acquire the ability to construct and manage complex documents, incorporating advanced text and image placement techniques. Develop expertise in styling text and objects, utilising master pages, and managing layers for sophisticated designs. Learn the process of preflighting documents to ensure they meet the rigorous standards of professional publishing. Master the art of finalising documents for distribution, including various exporting options and settings for print and digital mediums. Why buy this Level 3 Diploma in Adobe InDesign? 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 Level 3 Diploma in Adobe InDesign 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 Level 3 Diploma in Adobe InDesign course for? Individuals aspiring to become graphic designers or digital artists. Self-taught designers aiming to formalise and expand their skill set. Marketing professionals seeking to create compelling visual content. Entrepreneurs needing to design their own marketing materials. Educators and trainers looking to produce engaging educational resources. Career path Graphic Designer: £18,000 - £35,000 Creative Director: £35,000 - £75,000 Digital Media Specialist: £20,000 - £40,000 Marketing Coordinator: £20,000 - £30,000 Publishing Coordinator: £18,000 - £30,000 Freelance Designer: Variable depending on client and project scope. Prerequisites This Level 3 Diploma in Adobe InDesign does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 3 Diploma in Adobe InDesign 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. Course Curriculum Module: 01 1 Intro Indesign 00:02:00 2 - Course Downloadables 00:01:00 2 Conclusion InDesign 00:02:00 3 Let's Start Creating! 00:14:00 4 InDesign Workspace 00:08:00 5 The Workspace 00:06:00 6 Customize Your Workspace 00:08:00 7 Create a New Document 00:06:00 8 Navigating and Zooming 00:03:00 9 Setting up Your Document 00:10:00 10 Working with Pages 00:08:00 11 Working with Multiple Documents 00:03:00 12 Challenge: Create a Mock Setup Document 00:01:00 13 Assignment Solution 00:02:00 Module: 02 14 - Saving and Exporting 00:05:00 15 - Creating a Real Estate Listing 00:01:00 16- Placeing Image 00:12:00 17 - Placing Text 00:10:00 18 - Preflighting 00:05:00 19- Formatting and Flowing 00:09:00 20 Text Wrap 00:11:00 21 - Text on Paths 00:09:00 22 - Craislist Assignment 00:02:00 23 My Version 00:14:00 Module: 03 24 Intro Multi -Page Documents 00:03:00 25 - Master Pages 00:09:00 26 - Page Numbers 00:04:00 27 - Master Text Frames 00:04:00 28 - Threading Text 00:08:00 29 - Placeholder Frames 00:04:00 30 - Styles 00:11:00 31 - HyperLinks 00:06:00 32 - Layer Panel 00:13:00 33 - 4 Page Assignment 00:01:00 34 - My Version 5 Page 00:21:00 Module: 04 35 - Creating a Table 00:12:00 36 - Formatting table 00:16:00 37 - Assignment Report 00:01:00 38 - My Version 00:18:00 39 - Color Swatches 00:07:00 40 - Additional Tools 00:10:00 41- Shapes 00:05:00 42 - Keyboard Shortcuts 00:04:00 43 - Finishing Work 00:04:00 44 - Export Settings 00:07:00 45 - Final Project 00:01:00

Level 3 Diploma in Adobe InDesign
Delivered Online On Demand5 hours 21 minutes
£10.99

Visual Basic and VBScript Training

4.5(3)

By Studyhub UK

The 'Visual Basic and VBScript Training' course is a comprehensive program that equips learners with the skills to create and manipulate software applications using Visual Basic (VB) and VBScript. Participants will delve into the fundamental concepts, advanced techniques, and graphical user interface (GUI) development, enabling them to build interactive and user-friendly applications. This course covers a range of topics, from basic scripting to advanced resource management, empowering learners to harness the power of these programming languages for various software development needs. Learning Outcomes: Gain proficiency in creating and manipulating software applications using Visual Basic. Understand the core concepts of classes and their role in application development. Explore file handling techniques for efficient data management. Develop graphical user interfaces (GUI) for user-friendly application interaction. Implement dialog boxes to enhance user experience and gather input. Learn advanced scripting techniques to optimize application functionality. Utilize resource management techniques for efficient application design. Develop proficiency in VBScript for creating dynamic web pages and scripting actions. Why buy this Visual Basic and VBScript Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Visual Basic and VBScript Training 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. Who is this course for? This Visual Basic and VBScript Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Aspiring software developers looking to learn Visual Basic and VBScript. Programmers seeking to expand their knowledge of application development. Web developers interested in using VBScript for dynamic web content. IT professionals looking to enhance their scripting and programming skills. Prerequisites This Visual Basic and VBScript Training 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. Career path Software Developer - Median salary of $110,000 - $120,000 per year. Web Developer - Median salary of $75,000 - $85,000 per year. Application Developer - Median salary of $90,000 - $100,000 per year. Systems Analyst - Median salary of $80,000 - $90,000 per year. IT Consultant - Median salary of $90,000 - $100,000 per year. Course Curriculum Section 01: Introduction Introduction To This Course 00:02:00 Setup On Windows 00:06:00 Run Code Online 00:01:00 Section 02: Basics Console Output 00:04:00 Comments 00:03:00 Variables 00:03:00 Console Input 00:02:00 Data Types 00:08:00 Constants 00:03:00 Enumerations 00:04:00 Directives 00:05:00 Operators 00:06:00 If Statement 00:05:00 Switch Statement 00:04:00 Loops 00:08:00 Strings 00:05:00 Date & Time 00:04:00 Arrays 00:06:00 For Each Loop 00:04:00 ArrayList 00:04:00 Hashtable 00:05:00 SortedList 00:03:00 Stack 00:05:00 Queue 00:04:00 Subs 00:07:00 Functions 00:04:00 Exception Handling 00:05:00 Section 03: Classes Simple Class Example 00:09:00 Constructor 00:03:00 Destructor 00:03:00 Shared Properties 00:04:00 Inheritance 00:04:00 Scope 00:03:00 Section 04: File Handling File Handling 00:07:00 Section 05: GUI Setup A GUI Project 00:03:00 Forms 00:05:00 TextBox 00:06:00 Label 00:02:00 Button 00:04:00 ListBox 00:04:00 ComboBox 00:03:00 RadioButton 00:04:00 CheckBox 00:02:00 DateTimePicker 00:03:00 PictureBox 00:03:00 ProgressBar 00:03:00 GroupBox 00:04:00 TreeView 00:04:00 ListView 00:02:00 Events 00:03:00 Section 06: Dialog Box Color Dialog 00:03:00 Font Dialog 00:03:00 Open File Dialog 00:03:00 Save File Dialog 00:05:00 Print Dialog 00:03:00 Section 08: Resource Menus 00:02:00 Anchoring & Docking 00:04:00 Modals 00:03:00 Regular Expressions 00:09:00 Parsing an XML File 00:06:00 Section 07: Advanced Resource - Visual Basic and VBScript Training 00:00:00 Assignment Assignment - Visual Basic and VBScript Training 00:00:00

Visual Basic and VBScript Training
Delivered Online On Demand4 hours 9 minutes
£10.99

Crack Your Mechanical Engineer Interview

4.5(3)

By Studyhub UK

Unlock the secrets to landing your dream mechanical engineering job. Our Crack Your Mechanical Engineer Interview course equips you with the essential knowledge and interview techniques to impress employers. From fundamental mechanical engineering principles to in-demand industry specialisations, gain the confidence to ace your interview and launch a fulfilling career. Learning Outcomes: Master foundational mechanical engineering concepts. Explore diverse fields like manufacturing and material science. Gain a solid understanding of strength of materials and theory of machines. Delve into automotive engineering and fluid mechanics. Solidify your grasp of thermodynamics, RAC & HMT. Why buy this Crack Your Mechanical Engineer Interview course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments 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. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Crack Your Mechanical Engineer Interview 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. Who is this course for? Individuals seeking mechanical engineer jobs. Graduates with a mechanical engineering degree. Professionals aiming to transition into mechanical engineering. Aspiring engineers seeking a strong foundation in the field. Anyone interested in understanding mechanical engineering concepts. Prerequisites This Crack Your Mechanical Engineer Interview does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Crack Your Mechanical Engineer Interview 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. Career path Mechanical Engineer: £30,000 - £60,000 Per Annum Design Engineer: £35,000 - £70,000 Per Annum Production Engineer: £32,000 - £58,000 Per Annum Maintenance Engineer: £30,000 - £55,000 Per Annum Project Engineer: £40,000 - £80,000 Per Annum Manufacturing Engineer: £38,000 - £65,000 Per Annum Course Curriculum Section 01: Introduction Scope of the course 00:03:00 Section 02: Basic Mechanical Engineering (BME) Introduction to Basic Mechanical Engineering 00:02:00 Explain the term torque 00:03:00 State Archimedes Principle 00:02:00 What is the importance of tolerance in engineering? 00:04:00 Explain different types of fits 00:03:00 Section 03: Manufacturing & Material Science Introduction to Manufacturing & Material Science 00:01:00 Define pitting 00:03:00 Distinguish Between A Jig And Fixture 00:03:00 Explain knurling 00:03:00 Why is heat treatment of steel metal crucial? 00:03:00 What is extruded aluminium? 00:02:00 What do you mean by annealing? 00:04:00 How is martensite structure formed in steel? 00:04:00 Section 04: Strength Of Material (SOM) Introduction to Strength Of Material 00:01:00 Define a uniformly distributed load 00:04:00 Define Buckling Factor 00:02:00 Is it the stress that produces strain or vice-versa 00:04:00 What is the value of modulus of elasticity of steel? 00:03:00 What is Stress Concentration? 00:03:00 Section 05: Theory Of Machine (TOM) Introduction to Theory Of Machine 00:01:00 What is gear ratio? 00:01:00 What do you mean by cotter joint 00:04:00 What are the advantages of Gear drive? 00:04:00 What are the benefits of cycloidal gears? 00:03:00 Section 06: Automobile Engineering Introduction to automobile engineering 00:01:00 What are the various types of brakes? 00:03:00 Differentiate between scavenging and supercharging 00:03:00 In IC engine, which part is known as column? 00:03:00 What causes white smoke in two-stroke locomotive engines? 00:03:00 What is the difference between turbochargers and superchargers? 00:02:00 Section 07: Fluid Mechanics (FM) Introduction to Fluid Mechanics 00:01:00 Explain The Difference Between Rotational And Irrotational Flow? 00:03:00 Navier Stokes Equation Represents The Conservation Of Which Quantity? 00:03:00 What are major and minor head losses in a fluid flow system? 00:03:00 What is a Newtonian fluid? 00:05:00 What are the differences between elbows and bends? Which has greater head losses? 00:05:00 What is the ratio of the thickness of TBL to the thickness of HBL? 00:03:00 Section 08: Thermodynamics Introduction to Thermodynamics 00:01:00 What is the second law of thermodynamics? 00:04:00 What is the difference between the heat engine & heat pump? 00:05:00 Section 09: RAC & HMT Introduction to RAC & HMT 00:01:00 What is Refrigeration? What is the unit of refrigeration? 00:03:00 Which Cycle is used in Air Refrigeration System? 00:02:00 What do you mean by emissive power? 00:02:00 What is Under-cooling or Sub-cooling of refrigeration system? 00:03:00 Explain mechanical refrigeration 00:02:00 What is heat transfer co-efficient? 00:01:00 Section 10: Miscellaneous What is the advantage of using pneumatic? 00:03:00 Define least count and how to calculate for vernier callipers? 00:02:00 Why do you need a biological shield in nuclear plants? 00:03:00 What Is The Value Of Coefficient Of Friction For Ball Bearing? 00:02:00

Crack Your Mechanical Engineer Interview
Delivered Online On Demand2 hours 22 minutes
£10.99

Child Development and Teaching Assistant

By Compliance Central

Enjoy working with young people? Are you interested in children's mental, emotional, and physical growth in various settings through a profession in child development? If so, then this course is the perfect match for you. The domain of child development is expanding, and there are opportunities in teaching, clinical work, research, and professional development. This course provides an overview of child development by examining the scope and stages of development, exploring the areas of physical, cognitive, and emotional growth, and delving into influential theories such as Erikson's theory. Additionally, the course focuses on the social and emotional development of children and the factors that contribute to their developing personality and intellectual abilities.. Learning Outcome By the end of the course, the learners will have an understanding of: The theories and concepts of child development The stages and scope of child development The different areas of child development including physical, cognitive, and socio-emotional development Erikson's theory of psychosocial development and its application to child development The significance of social and emotional development in children The influence of personality and intellectual development on children's overall development. Along with the Child Development course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Those with aspirations in the field of child development should take the course. By the end of the course, you will have acquired the foundational knowledge and abilities necessary to become an expert in Child Development. As the course proceeds, we will cover more sophisticated concepts in child development, but we will begin with the fundamentals. Since this is a child development course, each lesson is straightforward. Therefore, by finishing the Child Development course, distinguish yourself in the job market. Curriculum Breakdown of the Child Development and Teaching Assistant Course Module 01: Understanding Child Development Module 02: The Scope and Stages of Child Development Module 03: The Areas of Child Development Module 04: Erikson's Theory of Child Development Module 05: Social and Emotional Development Module 06: Personality and Intellectual Development of Children CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is perfect for people who sincerely desire to see children succeed. For example, you feel the pull to work for the good of children, ensuring they have a place to live and learn and be protected from harm. One of the most satisfying professions is working with children. There are a lot of openings in the fields of teaching, social work, and child care, all of which can help you follow your passions and feel more at home in the world. Requirements To enrol in this Child Development course, all you need is a basic understanding of the English Language and an internet connection. Career path You will be prepared for a wide range of opportunities after completing our Child Development course. There are several job paths available to you. Teaching Assistant: £17,000 to £24,000 per year Nursery Worker: £16,000 to £20,000 per year Early Years Educator: £18,000 to £26,000 per year Childcare Coordinator: £20,000 to £28,000 per year Child Development Specialist: £24,000 to £32,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Child Development and Teaching Assistant
Delivered Online On Demand2 hours
£12

Solidworks: Beginner to Advanced

4.5(3)

By Studyhub UK

Step into the riveting realm of Solidworks, where imagination meets precision, and ideas transform into tangible designs. 'Solidworks: Beginner to Advanced' is a meticulously crafted journey tailored for curious minds keen to master the art and science of this software. Embark on a voyage starting from a foundational understanding, glide through sketches, part modelling, and eventually delve into intricate assemblies, drawings, and captivating animations. By the culmination, you'll possess the prowess to bring your creative visions to life with unparalleled precision. Learning Outcomes Acquire proficiency in navigating and utilising the core functionalities of Solidworks. Transform rudimentary sketches into detailed and precise 3D models. Master advanced part modelling, assembly techniques, and drawing intricacies. Immerse in the world of appearances, scenes, and produce realistic renderings. Execute captivating animations that showcase dynamic design components. Why choose this Solidworks: Beginner to Advanced course? 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 Solidworks: Beginner to Advanced 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 Solidworks: Beginner to Advanced course for? Novices keen to explore the intricacies of Solidworks. Engineers looking to enhance their design capabilities. Product designers aspiring to elevate their 3D modelling skills. Architecture and design students keen on a comprehensive software learning experience. Industry professionals aiming to stay abreast of cutting-edge design tools. Career path CAD Designer: £25,000 - £35,000 Mechanical Engineer: £30,000 - £50,000 Product Design Engineer: £28,000 - £48,000 Solidworks Draughtsperson: £24,000 - £34,000 Design Manager: £40,000 - £60,000 3D Visualisation Artist: £23,000 - £40,000 Prerequisites This Solidworks: Beginner to Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Solidworks: Beginner to Advanced 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. Course Curriculum Introduction About the course 00:02:00 Course concept 00:01:00 Getting to Know Solidworks Creating a New Document 00:01:00 User Interface 00:02:00 Mouse Movements - Sketch 00:02:00 Mouse Movements - Part 00:03:00 Sketch Creating a Sketch Document 00:02:00 Basic Sketch Tools 00:07:00 Dimensions and Relations 00:12:00 Mirror Entities 00:02:00 Linear and Circular Sketch Pattern 00:06:00 Units 00:02:00 Sketch to Part Conversion 00:03:00 Opening/Saving Part Document 00:01:00 Part Modeling Basics Extruded Boss Base 00:03:00 Extruded Boss Base Additional 00:04:00 Extruded Cut 00:03:00 Sketch on the Part 00:02:00 Sketch on the New Plane 00:05:00 Draft 00:03:00 Shell 00:02:00 Fillet and Chamfer 00:03:00 Convert and Offset Entities 00:02:00 Lofted Boss 00:03:00 Revolved Boss 00:02:00 Swept Boss 00:05:00 Part and Sketch Modification 00:02:00 Part Modeling Advanced 3D Sketch 00:03:00 Density and Material 00:02:00 Measuring Tools 00:03:00 Linked Dimensions 00:04:00 Equations 00:05:00 Mirror 00:03:00 Hole Wizard 00:03:00 Reference Geometry 00:03:00 Feature Scope 00:02:00 Configurations And Design Table Creating a Design Table 00:06:00 Adding Configurations 00:05:00 Assembly Basics Inserting Part Relative to the Origin 00:02:00 Inserting Parts Relative to Planes 00:02:00 Standard Mates 00:04:00 Move Components 00:02:00 Mirror Component 00:01:00 Assembly Advanced Distance and Angle 00:04:00 Profile Centre 00:04:00 Symmetry and Width 00:05:00 Path Mate 00:05:00 Linear Coupler 00:06:00 Collision Detection 00:02:00 Interference Detection 00:03:00 Assembly Features 00:02:00 Subassembly 00:03:00 Drawing Basics Creating a Drawing Sheet 00:01:00 Orthographic Views and Edit Sheet 00:04:00 Projected View and View Properties 00:02:00 Smart Dimension and Model Item 00:05:00 Saving Options 00:01:00 Relative to Model View 00:03:00 Section View 00:04:00 Auxiliary View 00:03:00 Detail View 00:02:00 Broken Out Section 00:02:00 Break View 00:02:00 Alternate Position View 00:02:00 View Focus 00:02:00 Drawing Advanced Bill of Materials (BOM) 00:03:00 Bom Sort 00:01:00 Missing Item in Bom 00:02:00 Custom Properties 00:02:00 Equations in Bom 00:03:00 Show/Hide Component 00:02:00 Linked Notes 00:02:00 Measuring Tool 00:02:00 Isometric Section View 00:01:00 Appearance, Scene and Rendering Applying Materials 00:08:00 Appearance 00:05:00 Working with Woods 00:05:00 Working with Glass 00:04:00 Scene 00:04:00 Light 00:07:00 Camera 00:04:00 Decals 00:07:00 Text 00:05:00 Options 00:04:00 Rendering Panel 00:03:00 Schedule Rendering 00:02:00 Animation Creating Motion Study 00:02:00 Animation Wizard 00:08:00 Applying Motor 00:04:00 Appearance and Camera Position 00:07:00 Walkthrough Part-1 00:09:00 Walkthrough Part-2 00:06:00 Resources Resources - Solidworks: Beginner to Advanced 00:00:00 Assignment Assignment - Solidworks: Beginner to Advanced 00:00:00

Solidworks: Beginner to Advanced
Delivered Online On Demand5 hours 14 minutes
£10.99

ChatGPT for Marketing Content and Productivity with AI Tools

4.5(3)

By Studyhub UK

This ChatGPT for Marketing and Productivity with AI Tools course is your guide to using AI to boost your marketing results. Boost your marketing skills and productivity to the next level with our comprehensive ChatGPT for Marketing and Productivity with AI Tools course. Dive deep into the world of Artificial Intelligence (AI), its applications, and how it can revolutionise the way you work. This course is meticulously designed to empower marketing professionals, content creators, entrepreneurs, and anyone intrigued by the power of AI.  It's a blend of theoretical understanding, practical exposure, and foresight into the future of AI, particularly in the field of marketing and productivity. In Section 01, we unpack the 'AI Marketing Playbook'. Starting with an introduction to OpenAI's ChatGPT, its possibilities, and its limitations, you'll gain a fundamental understanding of AI capabilities. Following this, delve into practical aspects of using ChatGPT, from generating innovative ideas and content to cross-posting queries and simplifying complex information. Our experts will also guide you on how to leverage AI for business problem-solving and developing methodologies, wrapping up with insights on the future of ChatGPT. In Section 02 get teaching on how to use ChatGPT and other AI tools for effective marketing. Learn to work with Autonomous AI Agents and a variety of AI tools such as Durable, Eightify, Genei, and Ellicit, to name a few. By the end of this section, you'll be equipped with the skills to carry out high-quality research, build AI-based websites, determine research credibility, and clone voices. You'll also get an interesting perspective on the future of AI. Finally, Section 03 is all about enhancing your productivity with ChatGPT and AI tools. From meta-search sites to speech-to-text services, AI design tools, content improvement techniques, and more, this section aims to streamline your work processes. Learn to use tools like Microsoft Bing Search, Google Bard, Speechify, and Adobe for audio enhancements. Wrap up this course with an exploration of generative AI and a glance into the future of this exciting field. Whether you're a beginner or an experienced professional, this course promises to expand your horizons and make you proficient in harnessing AI's power for marketing and productivity. Unleash the potential of AI and transform your work efficiency with this ChatGPT for Marketing and Productivity with AI Tools course. Enrol today and start your AI journey with us! Learning Outcomes Upon completion of the ChatGPT for Marketing course, you will be able to: Understand the fundamentals of OpenAI's ChatGPT and its capabilities. Generate and qualify ideas effectively using ChatGPT. Learn to apply ChatGPT for solving specific business problems. Develop skills to connect with various Autonomous AI Agents. Learn to use AI tools for enhanced research and content creation. Understand how to determine research credibility using AI. Gain proficiency in utilising AI for website creation and voice cloning. Develop skills to leverage AI tools for improved productivity. Understand the future scope of generative AI in marketing. Master the use of various AI design and content improvement tools. Who is this course for? This ChatGPT for Marketing course is ideal for: Marketing professionals seeking to leverage AI in their strategies. Content creators interested in AI-powered idea generation and curation. Business owners looking to integrate AI into their operational processes. Individuals interested in exploring AI applications in marketing and productivity. Any tech enthusiast keen on understanding and applying AI tools. Career Path Our ChatGPT for Marketing course will help you to pursue a range of career paths, such as: AI Marketing Specialist: £45,000 - £70,000 Content Strategist: £35,000 - £55,000 Business Intelligence Analyst: £40,000 - £65,000 Productivity Consultant: £45,000 - £75,000 AI Research Analyst: £50,000 - £80,000 AI Application Developer: £55,000 - £90,000 Digital Transformation Consultant: £60,000 - £100,000 AI Solutions Architect: £65,000 - £110,000 Prerequisites This Photoshop Training for Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Photoshop Training for Beginners 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 of the Photoshop Training for Beginners 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. Course Curriculum Section 01: The AI Marketing Playbook Unit 01: Start an Account with ChatGPT 00:02:00 Unit 02: What the Company OpenAI Say About Itself 00:02:00 Unit 03: What OpenAI Say About The Limitations of the Chatbot 00:02:00 Unit 04: Chatbot Prompt Examples Given By Open AI 00:02:00 Unit 05: Will Chat GPT Be a Paid Application 00:01:00 Unit 06: Chat GPT Idea Generation 00:02:00 Unit 07: Chat GPT - Idea Qualification and Accuracy 00:03:00 Unit 08: ChatGPT - Accuracy and Citations 00:02:00 Unit 09: Chat GPT - Creating HTML Instances 00:01:00 Unit 10: Chat GPT - How to Solve Specific Business Problems 00:02:00 Unit 11: Chat GPT - Statistical Verification of Information 00:01:00 Unit 12: Chat GPT - Rewrite Content for Different Contexts 00:02:00 Unit 13: ChatGPT - Content Checked With AI 00:02:00 Unit 14: ChatGPT - Simplifying Information 00:01:00 Unit 15: ChatGPT - How to Ask the Chatbot about Context 00:01:00 Unit 16: ChatGPT - How to Cross-Post Queries 00:01:00 Unit 17: ChatGPT - How to Narrow Down the Context of Your Query 00:02:00 Unit 18: ChatGPT - How to Solve a Business Process 00:02:00 Unit 19: ChatGPT - Developing a Methodology From Experts 00:01:00 Unit 20: The Future of ChatGPT 00:01:00 Section 02: How to Use ChatGPT and AI for Marketing Unit 01: Autonous AI Agents 00:01:00 Unit 02: Connecting to Open AI 00:01:00 Unit 03: Getting an OpenAI Key 00:01:00 Unit 04: Agent GPT - Autonomous AI 00:02:00 Unit 05: GoalGPT - Autonomous Agents 00:01:00 Unit 06: Cognosis - Autonomous AI 00:02:00 Unit 07: Aomni - Autonomous Agent 00:01:00 Unit 08: Durable - Build a Website with AI 00:01:00 Unit 09: Eightify Summaries 00:02:00 Unit 10: Genei - Do Higher Quality Research with AI 00:01:00 Unit 11: Ellicit - Do Higher Quality Research with AI 00:01:00 Unit 12: Inciteful - Do Higher Quality Research with AI 00:02:00 Unit 13: SciteAI Determine the Credibility of Your Research 00:01:00 Unit 14: Eleven Labs - Voice Cloning 00:02:00 Unit 15: AgentGPT - Wrap Up and Return 00:01:00 Unit 16: Cognosys - Wrap Up and Return 00:01:00 Unit 17: Aomni - Wrap Up and Return 00:01:00 Unit 18: Goal GPT - Wrap Up and Return 00:01:00 Unit 19: Uploading Research Reports to Summarization Applications 00:01:00 Unit 20: Perspective on The Future of AI 00:01:00 Section 03: Productivity with AI Tools Unit 01: Meta Search Sites 00:02:00 Unit 02: SMMRY for Summarzing 00:01:00 Unit 03: ChatGPT Plugins Waitlist 00:01:00 Unit 04: Using Microsoft Bing Search 00:02:00 Unit 05: Using Google Bard 00:01:00 Unit 06: Microsoft Word Speech To Text 00:01:00 Unit 07: Transcribe Audio in Microsoft Word 00:02:00 Unit 08: Speechify 00:02:00 Unit 09: Exact Image Creation 00:01:00 Unit 10: AI Design Tools 00:02:00 Unit 11: Learn How to Prompt 00:01:00 Unit 12: Content Improvement 00:01:00 Unit 13: Idea Generation 00:01:00 Unit 14: Audio Enhancement with Adobe 00:02:00 Unit 15: Clean up Audio With Cleaanvoice 00:01:00 Unit 16: Notion-AI 00:01:00 Unit 17: Pictory 00:01:00 Unit 18: Lex 00:01:00 Unit 19: ChatPDF 00:01:00 Unit 20: Conclusion and the Future of Generatie AI - Searchie 00:01:00

ChatGPT for Marketing Content and Productivity with AI Tools
Delivered Online On Demand1 hour 24 minutes
£10.99

Principles of Marketing Theory Course

5.0(5)

By Online Training Academy

Unlock the core principles of modern marketing with our comprehensive Principles of Marketing Theory Course. Designed for aspiring marketers and seasoned professionals alike, this course delves into essential concepts and strategies that drive successful marketing campaigns in today's dynamic business environment. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In the Principles of Marketing Theory course, learners will explore essential concepts and practices to excel in marketing. They will understand how marketing can be socially responsible and its impact on sales and brand reputation. They will learn techniques to build customer loyalty and effectively use marketing data to segment markets. The course covers strategies to cluster customers based on their characteristics and how to align products with diverse market segments. Learners will discover the role of core values in marketing and methods to enhance product sales through effective marketing campaigns. They will also delve into Customer Relationship Management (CRM) systems and activities that foster strong customer relationships. Throughout the course, learners will grasp the importance of key performance indicators (KPIs) in evaluating marketing success and the requirements for conducting socially responsible marketing campaigns. Course Curriculum Module 01: Scope and Purpose of Socially Responsible Marketing Module 02: Significance of Brand and Reputation to Sales Performance Module 03: Significance of Customer Loyalty to the Achievement of Marketing Objectives Module 04: Valid and Reliable Marketing Data for Segmenting the Market Module 05: Marketing Data Collection Methods Module 06: Market Segmentation Module 07: Cluster Customers With Similar Characteristics Module 08: How Core Values Are Expressed Module 09: How a Range of Products May Appeal to Different Market Segments Module 10: Role of Marketing in Enhancing the Sale of Products and/or Services Module 11: Customer Relationship Management (CRM) Activities and Systems Module 12: Marketing Key Performance Indicators Module 13: The Requirements of Socially Responsible Marketing Campaigns Learning Outcomes: Understand the importance of socially responsible marketing strategies. Analyze the impact of brand reputation on sales performance metrics. Evaluate customer loyalty's role in achieving marketing objectives effectively. Apply valid and reliable methods for marketing data segmentation. Implement various marketing data collection techniques for business insights. Utilize market segmentation strategies to target diverse customer groups effectively. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Marketing professionals seeking advanced theoretical knowledge. Business students focusing on marketing theory and principles. Entrepreneurs aiming to enhance their marketing strategy skills. Individuals interested in understanding consumer behaviour and segmentation. Professionals looking to expand their knowledge in marketing analytics. Career path Market Research Analyst Brand Manager Digital Marketing Specialist Advertising Executive Public Relations Manager Customer Relationship Manager Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Principles of Marketing Theory Course
Delivered Online On Demand1 hour 12 minutes
£10

Principles of Marketing Theory Course

5.0(5)

By Online Training Academy

Unlock the core principles of modern marketing with our comprehensive Principles of Marketing Theory Course. Designed for aspiring marketers and seasoned professionals alike, this course delves into essential concepts and strategies that drive successful marketing campaigns in today's dynamic business environment. Key Features: CPD Certified Developed by Specialist Lifetime Access In the Principles of Marketing Theory course, learners will explore essential concepts and practices to excel in marketing. They will understand how marketing can be socially responsible and its impact on sales and brand reputation. They will learn techniques to build customer loyalty and effectively use marketing data to segment markets. The course covers strategies to cluster customers based on their characteristics and how to align products with diverse market segments. Learners will discover the role of core values in marketing and methods to enhance product sales through effective marketing campaigns. They will also delve into Customer Relationship Management (CRM) systems and activities that foster strong customer relationships. Throughout the course, learners will grasp the importance of key performance indicators (KPIs) in evaluating marketing success and the requirements for conducting socially responsible marketing campaigns. Course Curriculum Module 01: Scope and Purpose of Socially Responsible Marketing Module 02: Significance of Brand and Reputation to Sales Performance Module 03: Significance of Customer Loyalty to the Achievement of Marketing Objectives Module 04: Valid and Reliable Marketing Data for Segmenting the Market Module 05: Marketing Data Collection Methods Module 06: Market Segmentation Module 07: Cluster Customers With Similar Characteristics Module 08: How Core Values Are Expressed Module 09: How a Range of Products May Appeal to Different Market Segments Module 10: Role of Marketing in Enhancing the Sale of Products and/or Services Module 11: Customer Relationship Management (CRM) Activities and Systems Module 12: Marketing Key Performance Indicators Module 13: The Requirements of Socially Responsible Marketing Campaigns Learning Outcomes: Understand the importance of socially responsible marketing strategies. Analyze the impact of brand reputation on sales performance metrics. Evaluate customer loyalty's role in achieving marketing objectives effectively. Apply valid and reliable methods for marketing data segmentation. Implement various marketing data collection techniques for business insights. Utilize market segmentation strategies to target diverse customer groups effectively. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Marketing professionals seeking advanced theoretical knowledge. Business students focusing on marketing theory and principles. Entrepreneurs aiming to enhance their marketing strategy skills. Individuals interested in understanding consumer behaviour and segmentation. Professionals looking to expand their knowledge in marketing analytics. Career path Market Research Analyst Brand Manager Digital Marketing Specialist Advertising Executive Public Relations Manager Customer Relationship Manager Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Principles of Marketing Theory Course
Delivered Online On Demand1 hour 12 minutes
£10

How to be a Creative Writer

4.5(3)

By Studyhub UK

Overview Learn about How to be a Creative Writer from industry experts and boost your professional skill. This How to be a Creative Writer course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of How to be a Creative Writer. You'll also gain the skills of How to be a Creative Writer to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of How to be a Creative Writer professionals and gain first-hand experience of How to be a Creative Writer problem-solving. The How to be a Creative Writer  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the How to be a Creative Writer, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This How to be a Creative Writer will provide you with the latest information and updates of How to be a Creative Writer. It will keep you one step ahead of others and increase your chances of growth. Why buy this How to be a Creative Writer? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the How to be a Creative Writer you will be able to take the MCQ test that will assess your knowledge. 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. Who is this course for? This How to be a Creative Writer does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This How to be a Creative Writer 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This How to be a Creative Writer is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum 01. Creative Writing Course: Writing Storybooks For Children Introduction Introduction to Children's Writing 00:02:00 Crucial Information 00:02:00 Keys to Success 00:02:00 A.I.M 00:04:00 Coming Up With Ideas Getting Ideas 00:02:00 Character Creation 00:02:00 Characters and Plotting 00:04:00 The Mechanics of Writing Planning Your Story 00:03:00 Storytelling 00:03:00 Important Technical Issues Point of View 00:04:00 Technical Writing Issues 00:04:00 Types of Children's Books Story Structure 00:02:00 Picture Books 1 00:03:00 Picture Books 2 00:03:00 Picture Books 3 00:02:00 Easy Readers 00:03:00 Transition Books 00:01:00 Chapter Books 00:02:00 Junior Novels 00:02:00 Young Adult Fiction 00:04:00 Advanced Fiction Techniques Dialogue 00:05:00 Show don't Tell 00:05:00 Conclusion Conclusion 00:02:00 02. Creative Writing Course - Short Stories Introduction Introduction to Short Story Writing 00:06:00 Foreword Who Am I to Run This Course? 00:06:00 It's All About Mindset 00:07:00 What Tools Do You Need To Succeed? 00:05:00 Part One: Mindset Mental Preparation 00:06:00 Time Management 00:06:00 Self Belief 00:02:00 Goal Setting 00:01:00 Part Two: The Basics Subject Matter 00:04:00 Genre 00:07:00 Scope 00:02:00 Getting Ideas 00:02:00 Part Three: Construction Time The 7-Step Story Generator 00:02:00 Characters & Character Creation 00:03:00 Creating Protagonists 00:07:00 Character Motivation & Interactions 00:03:00 Story & Setting 00:03:00 The 5-Point Story Structure 00:02:00 Style & Tone 00:02:00 Point of View & Tense 00:03:00 Plotting & The Twist 00:05:00 Building a Short Story Template 00:03:00 Building a Short Story Template 00:03:00 Introduction to Scrivener All Hail Scrivener! 00:04:00 Part Four: Writing Your Story The Opening Paragraph 00:03:00 Fast Writing 00:05:00 The Second Draft 00:04:00 Polishing 00:04:00 Part Five: Submitting Your Work 6 Lectures It's All About Presentation 00:04:00 Dealing With Rejection 00:02:00 Rights and Payment 00:01:00 Kindle Publishing 00:04:00 Conclusion Short Stories 00:02:00 03. Creative Writing Course - Fiction Module 1 Part 1 - Getting Ideas and How to Develop Them 00:30:00 Module 1 Part 2 - Inspiration and Finding The Time 00:30:00 Module 2 - What It Means To Be A Writer 00:30:00 Module 3 - Characters 00:30:00 Module 4 - Plotting and Story Construction 00:30:00 Module 5 - Theme, Templates & Outlining 00:30:00 Module 6 - Show Don't Tell 00:30:00 Module 7 - Punctuation, Grammar and some Basic Writing Rules 00:30:00 Module 8 - Scene Structure, Exposition and Story Rules 00:30:00 Module 9 - Chapter Structure, Vision and Focus 00:30:00 Module 10 - Fast Writing Without Fear or Censure 00:30:00 Module 11 - Editing, Re-writing & Polishing 00:30:00 Module 12 - Finishing, Submission & Publication 00:30:00 04. Creative Writing Course - Horror Lesson One: The History of Horror 01:00:00 Lesson Two: Characters and Concepts 01:00:00 Lesson Three: Location and Backdrop 01:00:00 Lesson Four: Story and Plotting 01:00:00 Lesson Five: Writing Issues 01:00:00 Lesson Six: Horror Markets 01:00:00 05. Creative Writing Course - Novel Introduction to Writing Fantasy 01:00:00 Writing Fantasy - Lesson One - Imagining Fantasy 01:00:00 Writing Fantasy - Lesson Two - World Building, Maps and Visualization 01:00:00 Writing Fantasy - Lesson Three - Characters, Races and Societies 01:00:00 Writing Fantasy - Lesson Four - Plotting, Questing and Traveling 01:00:00 Writing Fantasy - Lesson Five - Point of View, Artifacts and Magic 01:00:00 Writing Fantasy - Lesson Six - Resolutions and Sequels 01:00:00 Amusing Article About Fantasy Writing (because it's true!) 01:00:00 Fantasy: Recommended Author & Book List 01:00:00 Fantasy Societies Listing 01:00:00 Mythological Creature Listing 01:00:00 06. Creative Writing Course - Thriller Introduction to Writing the Thriller 00:30:00 The Thriller: Form and Function 00:30:00 Writing the Thriller: Lesson One 00:30:00 Writing the Thriller: Lesson Two 00:30:00 Exercise 1 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Three 00:30:00 Exercise 2 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Four 00:30:00 Exercise 3 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Five 00:30:00 Exercise 4 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Six 00:30:00 07. Diploma in Drama and Comedy Writing Welcome to the Writer's Greatest Untapped Income Source 00:15:00 Introduction to Writing for TV, Cable and Satellite Networks 01:00:00 Your Ideas and How to Present Them 01:00:00 What's Different About TV Writing? 01:00:00 Scripting, Editing and the Story Bible 00:30:00 A Special Masterclass On Comedy Writing 00:30:00 The Money and How You Get Paid 00:30:00

How to be a Creative Writer
Delivered Online On Demand37 hours
£10.99

Excel VBA/Macros Foundations

4.5(3)

By Studyhub UK

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations 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. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Excel VBA/Macros Foundations
Delivered Online On Demand8 hours 52 minutes
£10.99