8906 Courses

Description Learn to create a Sway from start to finish with the Microsoft Sway Online Training course. Microsoft Sway is an easy-to-use digital storytelling app for creating and sharing interactive reports, newsletters, presentations, personal stories and more. Throughout the course, you will learn how to use Microsoft Sway to create newsletters, presentations, documentation, or for doing communication. The course teaches you where to access, and how to start building your own Sways such as presentations, tutorials, newsletters, stories, and more. Sway's design engine allows you to bring your content together nicely and helps you to finish it. You will learn how to share any Sway or co-edited it with a simple URL. In short, the course illustrates the techniques of using the program to create interactive reports, newsletters, presentations, etc. You will also know how to use Sway to collaborate on projects and share them with others. Certification: After completing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Sway Online Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Sway Online Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 TOPIC A: Launch Sway 00:30:00 TOPIC B: Create a New Sway Project 00:45:00 TOPIC C: Create Cards 00:30:00 TOPIC D: Manage Cards 00:30:00 TOPIC E: Manage Sway Projects 00:30:00 Module: 02 TOPIC A: Format Text 00:30:00 TOPIC B: Add Media 00:45:00 Module: 03 TOPIC A: Work with Images 00:45:00 TOPIC B: Customize Image Display 00:45:00 TOPIC C: Set Design Options 00:30:00 Module: 04 TOPIC A: Edit Sway Projects 00:30:00 TOPIC B: Share a Sway Project 00:45:00 TOPIC C: Set Sway Project Options 00:30:00 Order Your Certificate Order Your Certificate 00:00:00

Register on the Flat Design in Adobe Illustrator today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Flat Design in Adobe Illustrator is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Flat Design in Adobe Illustrator Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Flat Design in Adobe Illustrator, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Module 01: Introduction Introduction to the Course 00:01:00 Module 02: Create a Flat Design Garden and Barbecue Introduction to the Project 00:01:00 How to Set up the Document 00:13:00 One Smart Way of Adding Gradients 00:06:00 Start with the Background 00:07:00 Create the Sky and the Clouds 00:06:00 Adding the Lawn and the Bushes 00:12:00 Need Some Shade in the Garden 00:08:00 Rounding Selected Corners in Older Illustrators 00:04:00 Who Wants Lemonade 00:10:00 Add the Chairs 00:05:00 Creating the First BBQ 00:10:00 Finish the Project 00:04:00 Module 03: Create a Flat Design Landscape Scene Explore the Project 00:01:00 Start with the Background 00:07:00 Add the Sun 00:08:00 Second Way of Creating the Sun 00:05:00 Scream it from the Mountain Top 00:07:00 Planting the Trees 00:04:00 Creating the Forest 00:04:00 Add the Hut 00:08:00 Add the Side Blocks 00:05:00 Add the Roof 00:06:00 Add the Windows 00:04:00 Finish the Project 00:04:00 Module 04: Create a modern Flat Design Night Camping Scene Introduction to the project88 00:02:00 Creating a New Document 00:03:00 Adding Panels and Colours 00:07:00 Create the sky 00:05:00 Add the stars 00:07:00 Add the moon 00:08:00 Create the mountains 00:11:00 Plant Some trees 00:07:00 Add the entrance 00:06:00 Create the tent 00:04:00 Finish the Tent 00:06:00 Add the backpack 00:05:00 Add the Straps and the Handle 00:03:00 Create the stove 00:07:00 Build Some Fire 00:06:00 Create the Wheels of the Camper 00:04:00 Add the Mudguard 00:02:00 Add the Bumpers 00:03:00 Add the Paint Job 00:04:00 Add the Door Knobs 00:03:00 Add the Windows 00:07:00 Add the Reflections and Finish the Project 00:09:00 Module 05: Create a Modern Flat Design Terminal and Luggage Discover the Project 00:01:00 Start with the Background 00:10:00 Add the Chairs 00:06:00 Add the sign and the Arrows 00:07:00 Add the Escalator 00:06:00 Start Creating the Luggage 00:03:00 Add the Handle 00:03:00 Add the Straps 00:03:00 Add the Wheels and the Shading 00:05:00 Adding the Bokeh Effect and Finishing the Project 00:03:00 Module 06: Design a Flat Design Smartphone and App Icons Introduction to the class 00:01:00 Create a new document 00:02:00 Create the smartphone shape 00:04:00 Add the gradient wallpaper 00:04:00 Create the buttons 00:04:00 Add the system buttons 00:04:00 Add the hour and notification icons 00:04:00 Create the signal strength icon 00:03:00 Create the wifi icon 00:07:00 Add the battery icon 00:03:00 Create the app drawer 00:09:00 Create a new document 00:01:00 Create the main telephone shape 00:06:00 Add the gradient background 00:03:00 Create the main compass shape 00:04:00 Add the pointers and start adding colour 00:04:00 Add the gradient background 00:03:00 Create the messages icon 00:06:00 Add the background 00:03:00 How to create an iOS inspired music app icon 00:07:00 Coming up with colour schemes for the projects 00:06:00 Create the main shape of the retro TV 00:03:00 Add the screen 00:03:00 Create the reflections 00:02:00 Add the legs and the antenna 00:04:00 Add the buttons 00:05:00 Finish the retro TV app icon 00:02:00 Create the second TV app icon 00:08:00 Create the contacts app icon 00:05:00 Create the body and the lens 00:03:00 Add the reflections and finish the icon 00:05:00 Create the envelope 00:05:00 Add the letter 00:03:00 Finish the icon 00:02:00 Create the main wallet shape 00:07:00 Round the corners in older version of illustrator 00:03:00 Add the stitching 00:03:00 Create the bottom edge 00:03:00 Add the button 00:02:00 Put the money in the wallet 00:04:00 Finish the icon 00:02:00 Create the main book shape 00:06:00 Add the text and a bookmark 00:04:00 Create the hand and the background 00:09:00 Create the cloud 00:05:00 Create the sun and finish the icon 00:07:00 Create the bun icon 00:03:00 Add the lettuce, cheese and ketchup 00:04:00 Add sesame, background and finish 00:03:00 Create the main app background 00:05:00 Add the navigation pointer 00:04:00 Create the base of the microphone 00:06:00 Add the diaphragm and finish the icon 00:06:00 Introduction to the project 00:01:00 Add the background first 00:03:00 Create the main piece 00:07:00 Add the padding 00:03:00 Attach the earpiece 00:02:00 Add the earpiece 00:04:00 Add the cable 00:02:00 Finish the icon 00:02:00 Create the main cog shapes 00:04:00 Join the cogs and finish the icon 00:05:00 Create the world map 00:06:00 Add the magnifying glass and finish the icon 00:07:00 Create the main clock shape 00:04:00 Add the markers 00:02:00 Add the pointers 00:03:00 Create the bells and finish the icon 00:06:00 Create the main notes shape 00:03:00 Add the bend and the background 00:03:00 Create another version of the icon 00:03:00 How to create a calculator app icon 00:05:00 How to create a file manager app 00:06:00 Create the main flashlight shape 00:04:00 Add the rotating mechanism 00:05:00 Summary 00:01:00

Are you ready to lead your organization through the complexities of change with confidence and competence? Our comprehensive Change Management Training course is designed to equip you with the knowledge, tools, and strategies to navigate and thrive in today's dynamic business environment. With a curriculum that covers every critical aspect of change management, this course is your gateway to mastering the art of change. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access The Change Management Training course helps learners understand how to effectively manage and adapt to change within an organization. Participants will explore the impact of change on individuals and organizations, learning strategies to engage and communicate with stakeholders. They will gain skills in human resource management, crisis management, and conflict resolution, ensuring they can handle challenges that arise during change processes. The course also covers techniques for managing attention, stress, and performance, helping learners maintain productivity and well-being. Additionally, learners will develop project management skills and learn how to assess and manage risks effectively. By the end of the course, participants will be equipped with practical tools and knowledge to lead and support change initiatives successfully, fostering a positive and adaptable work environment. Course Curriculum Module 01: Change Management Module 02: Change and the Individual Module 03: Change and the Organisation Module 04: Communication and Stakeholder Engagement Module 05: Human Resource Management Module 06: Crisis Management Module 07: Conflict Management Module 08: Attention Management Module 09: Performance Management Module 10: Project Management Module 11: Risk Assessment and Management Module 12: Stress Management Learning Outcomes: Understand key principles and processes in change management. Analyse how individuals respond to organisational change. Evaluate organisational strategies for effective change implementation. Develop communication plans for stakeholder engagement. Assess human resource strategies in managing organisational change. Identify techniques for managing stress during change initiatives. CPD 10 CPD hours / points Accredited by CPD Quality Standards Change Management Training 2:53:38 1: Module 01: Change Management 15:19 2: Module 02: Change and the Individual 21:13 3: Module 03: Change and the Organisation 21:38 4: Module 04: Communication and Stakeholder Engagement 12:06 5: Module 05: Human Resource Management 14:22 6: Module 06: Crisis Management 17:35 7: Module 07: Conflict Management 07:49 8: Module 08: Attention Management 20:01 9: Module 09: Performance Management 11:55 10: Module 10: Project Management 11:35 11: Module 11: Risk Assessment and Management 10:06 12: Module 12: Stress Management 08:59 13: CPD Certificate - Free 01:00 Who is this course for? Managers leading organisational change initiatives. HR professionals handling change impacts on staff. Team leaders managing change in their departments. Consultants advising on change management strategies. Executives overseeing organisational transformations. Career path Change Manager HR Manager Organisational Development Consultant Project Manager Risk Manager Performance Manager Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

***Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 12-in-1 extensive bundle that has everything you need to succeed in Work from Home Essentials and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Work from Home Essentials bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Work from Home Essentials course that will enhance your skills and prepare you for the competitive job market. Also, our Work from Home Essentials experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Work from Home Essentials, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Work from Home Essentials Bundle Consists of the following Premium courses: Course 01: Working from Home Essentials Course 02: Online Course - A Perfect Guide to Home Business Course 03: Online Meeting Management Course 04: Using Zoom Meeting Effectively Course 05: ZOOM: Master Video Conferencing in Just 40 minutes! Course 06: Business Writing Course 07: Level 2 Microsoft Office Essentials Course 08: Touch Typing Essentials Course 09: Effective Communication Skills Diploma Course 10: Stress Management Training Course 11: Freelancing on UpWork Course 12: Time Management Benefits you'll get choosing Apex Learning for this Work from Home Essentials: Pay once and get lifetime access to 12 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum: Course 01: Working from Home Essentials Module 1: Introduction to Work from Home Module 2: Online Meeting Tools Module 3: Project Management Tools Module 4: Project Planning Tools Module 5: Communication Tools How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Work from Home Essentials bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Work from Home Essentials is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Embark on a journey to mastery in construction management with the 'Advanced Diploma in Construction Management at QLS Level 6.' This course is a gateway to understanding the multifaceted world of construction management, encapsulating a broad spectrum of knowledge spread across 18 detailed modules. From the fundamentals in construction management to the intricacies of health and safety protocols, this programme is meticulously structured to provide a comprehensive learning experience. The curriculum begins with an introduction to the field, progressively delving into more complex topics such as project life cycle, cost management, and site organisation. As learners progress, they will explore the nuances of site management, equipment planning, construction materials management, and the critical aspects of vendor analysis in construction management. The course also includes an in-depth look at construction procurement, stock control, and supply chain management. The latter modules focus on the essential components of quality assurance, legal aspects of contracting, human resources, risk and value management, and effective communication in the construction industry. Each module is designed to build on the knowledge acquired in the previous, ensuring a holistic and thorough understanding of construction management. Learning Outcomes Develop a deep understanding of construction management fundamentals. Gain insight into effective cost management and project life cycle in construction. Acquire skills in site organisation and management of construction materials. Learn the principles of human resources and risk management in construction. Master the legal and safety aspects relevant to the construction industry. Why choose this Advanced Diploma in Construction Management at QLS Level 6 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 course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Advanced Diploma in Construction Management at QLS Level 6 course for? Individuals aspiring to become construction managers. Professionals in the construction industry aiming to elevate their management skills. Project coordinators seeking advanced knowledge in construction processes. Site supervisors wanting to enhance their managerial capabilities. Construction consultants looking to deepen their understanding of construction management. Career path Construction Manager: £35,000 - £55,000 Project Coordinator (Construction): £28,000 - £45,000 Site Supervisor: £30,000 - £50,000 Construction Consultant: £32,000 - £48,000 Health and Safety Manager (Construction): £34,000 - £52,000 Quality Assurance Manager (Construction): £33,000 - £51,000 Prerequisites This Advanced Diploma in Construction Management at QLS Level 6 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £125 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Advanced Diploma in Construction Management at QLS Level 6 Module 01: Introduction to Construction Management 00:19:00 Module 02: Project Life Cycle and Success 00:28:00 Module 03: Cost Management 00:22:00 Module 04: Preliminary Site Investigation and Site Organisation 00:24:00 Module 05: Site Management 00:19:00 Module 06: Planning and Management of Equipment 00:32:00 Module 07: Construction Materials Management 00:22:00 Module 08: Vendor Analysis in Construction Management 00:24:00 Module 09: Construction Procurement 00:18:00 Module 10: Stock Control 00:22:00 Module 11: Supply Chain Management 00:21:00 Module 12: The Main Participators 00:21:00 Module 13: Quality Assurance and Customer Care 00:21:00 Module 14: Legal Aspects of Contracting 00:19:00 Module 15: Human Resources Management 00:22:00 Module 16: Risk and Value Management 00:21:00 Module 17: Communications, Information and Documentation of Construction 00:24:00 Module 18: Health and Safety in Construction Management 00:24:00 Mock Exam Mock Exam - Advanced Diploma in Construction Management at QLS Level 6 00:20:00 Final Exam Final Exam - Advanced Diploma in Construction Management at QLS Level 6 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Overview Learn how to apply the elementary principles of quality management and instil a culture of quality in your construction projects by enrolling in our Construction Management and Procurement course. This information-packed course educates you on quality management fundamentals for construction projects, equipping you with the skills to develop an efficient project quality management plan. A project must meet the expected quality of client satisfaction. This course includes all the knowledge and skills you need to investigate quality management methods and establish a framework with detailed procedures and practices to ensure that the completed product meets the quality requirements. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Construction Management and Procurement. It is available to all students, of all academic backgrounds. Requirements Our Construction Management and Procurement is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 18 lectures • 06:43:00 total length •Module 01: Introduction to Construction Management: 00:19:00 •Module 02: Project Life Cycle and Success: 00:28:00 •Module 03: Cost Management: 00:22:00 •Module 04: Preliminary Site Investigation and Site Organisation: 00:24:00 •Module 05: Site Management: 00:19:00 •Module 06: Planning and Management of Equipment: 00:32:00 •Module 07: Construction Materials Management: 00:22:00 •Module 08: Vendor Analysis in Construction Management: 00:24:00 •Module 09: Construction Procurement: 00:18:00 •Module 10: Stock Control: 00:22:00 •Module 11: Supply Chain Management: 00:21:00 •Module 12: The Main Participators: 00:21:00 •Module 13: Quality Assurance and Customer Care: 00:21:00 •Module 14: Legal Aspects of Contracting: 00:19:00 •Module 15: Human Resources Management: 00:22:00 •Module 16: Risk and Value Management: 00:21:00 •Module 17: Communications, Information and Documentation of Construction: 00:24:00 •Module 18: Health and Safety in Construction Management: 00:24:00

Business Relationship Management Professional (BRMP)® Business Relationship Management (BRM) embodies a set of competencies (knowledge, skills, and behaviors) to foster an effective business value-producing relationship between a service provider and its business partners. The BRM Discipline rests on solid research-based foundations verified and enhanced over a decade of successful implementations in leading organizations across the world. Proven to be equally effective for shared services including Human Resources, Finance, Legal, external service providers and others, BRM practices have enjoyed widespread adaptation in IT. The Business Relationship Management Professional (BRMP) training and certification program provides a foundational understanding of business relationship management (BRM) for individuals at every experience level, with the training and certification designed to provide a solid baseline level of knowledge. In other words, this course provides the 'why' and the 'what' - 'why' business relationship management is important to your organization and 'what' a BRM capability does to add value to your organization. This interactive course, with discussions, partnering activities, and periodic knowledge checks, will provide you with the opportunity to apply learning to your unique organizational situations, creating solutions that you can use immediately upon returning to your workplace. This practical knowledge will allow you to demonstrate immediate value in your role, as well as prepare you for the BRMP Certification exam. What You Will Learn This course provides a foundational understanding of Business Relationship Management. Upon completion of the BRMP® course, participant will be able to demonstrate their understanding: Explain what business relationship management is and the value it provides to an organization Articulate the need for an organization to move beyond traditional goals of profit and products to encompass those that are appropriate for a relationship-centered organization Describe the importance of integrating business relationship management into every element of their organization Define the importance of educating their organization that a mature BRM capability will evolve culture, build partnerships, drive value, and satisfy purpose Apply business relationship management to their organization's triple bottom line of people, purpose, and planet Explain the basic knowledge, skills, and mindsets of the business relationship management role Clarify the core business relationship management approaches, tools, and templates used to achieve results Illustrate the value and impact the BRM capability has on an organization by completing a draft of the BRM Capability Workbook BRM Introduction - The Bigger Picture Why BRM = why now? Relationship-centered organization Theory of 'relationshipism' Triple bottom line BRM defined Activity domains BRM challenges BRM Capability BRM capability framework Organizational purpose and strategy Now-to-new Evolve culture Build partnerships Drive value Satisfy purpose Limitless growth and improvement BRM Capability - Evolve culture Evolve culture framework Purposeful narrative Desired behaviors Influential relationships Personal growth BRM Capability - Build partnerships Build partnerships framework BRM role competency model Relationship maturity and quality Partnering mindsets Relationship discovery Relationship nurturing BRM Capability - Drive value What is value? Types of value Sources of value Drive value framework BRM role competency model Value discovery Value realization Value results BRM Capability - Satisfy purpose Satisfy purpose framework BRM role competency model Through the BRM capability Through the triple bottom line Social value BRM Capability - Wrap-up Evolve culture capability framework Build partnerships capability framework Drive value capability framework Satisfy purpose capability framework BRM Role Our purpose and what we believe Role clarity Single point of focus BRM Code of Ethics BRM Role Competency Model BRM mindset Scope of BRM role BRM role with organizational factors BRM Team Our purpose and what we believe BRM team definition BRM team purpose, mission, and vision Assessing the value of a BRM team Organizing a BRM team Leading a BRM team Transition management Coaching BRMs Closing - BRM Key Learnings Key learnings from each module Closing - BRMP Course Wrap-Up What to do in the next 30/60/90/365 days Digital badge After passing the exam Recap learning objectives Review learning objectives Review expectations Course feedback

Are you tired of feeling overwhelmed by your schedule? Do you find yourself constantly chasing deadlines or struggling to prioritize tasks effectively? It's time to take control of your time and maximize your productivity with our comprehensive Diploma in Time Management (Level 3) course. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this diploma course, learners will gain essential skills for managing their time effectively. They'll learn how to plan wisely, set achievable goals using the SMART criteria, and prioritize tasks to focus on what's most important. Organizational techniques will be covered, including how to organize their workspace for maximum efficiency and strategies for overcoming procrastination. They'll also learn how to delegate tasks efficiently, handle crises effectively, and manage meetings with confidence. Additionally, the course will cover phone etiquette for professional communication and provide alternatives to traditional meetings when necessary. Overall, learners will develop the ability to manage their time efficiently, increase productivity, and navigate various work-related situations with ease. Course Curriculum Module 01: Planning Wisely Module 02: Setting SMART Goals Module 03: Prioritizing Your Time Module 04: Organizing Your Workspace Module 05: Tackling Procrastination Module 06: Delegating Made Easy Module 07: Crisis Management Module 08: Meeting Management Module 09: Phone Etiquette Module 10: Alternatives to Meetings Learning Outcomes: Efficiently plan tasks to maximise productivity and minimise time wastage. Establish SMART goals for effective time management and goal achievement. Prioritise tasks based on urgency and importance for optimal efficiency. Organise workspace to enhance productivity and reduce clutter-induced distractions. Overcome procrastination through effective strategies and time management techniques. Master delegation techniques to streamline workload and improve time management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Diploma in Time Management (Level 3) 52:20 1: Module 01: Planning Wisely 06:32 2: Module 02: Setting SMART Goals 07:04 3: Module 03: Prioritizing Your Time 04:57 4: Module 04: Organizing Your Workspace 05:27 5: Module 05: Tackling Procrastination 05:13 6: Module 06: Delegating Made Easy 06:32 7: Module 07: Crisis Management 03:48 8: Module 08: Meeting Management 04:23 9: Module 09: Phone Etiquette 03:42 10: Module 10: Alternatives to Meetings 03:42 11: CPD Certificate - Free 01:00 Who is this course for? Professionals seeking to enhance time management skills for career advancement. Students looking to improve study habits and time management techniques. Entrepreneurs aiming to maximise productivity and efficiency in business operations. Individuals wanting to strike a better work-life balance through effective time management. Anyone interested in honing time management skills for personal development. Career path Time Management Consultant Executive Assistant Project Coordinator Office Manager Personal Assistant Administrative Officer Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

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

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included