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

25521 Management courses delivered Online

Warehouse Associate Training

4.7(26)

By Academy for Health and Fitness

Limited Time Offer is Active, Save Now: £403! Offer Ends Soon, Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Warehouse Associate Course might help you get there! Expand your expertise with high-quality training - study the course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through online training. This online training is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training in around 5 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our Warehouse Associate course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this Warehouse Associate course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with this program. Learning Outcomes: Instant access to verified and reliable information Participation in inventive and interactive training exercises Quick assessment and guidance for all subjects CPD accreditation for proof of acquired skills and knowledge Freedom to study in any location and at a pace that suits you Expert support from dedicated tutors committed to online learning Experts created the Warehouse Associate course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now, and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: Warehousing: Function, Benefits and Types of Warehousing Module 02: Challenges Module 03: Technology in The Warehouse Module 04: Order Picking in The Warehouse Module 05: Managing Inventory Module 06: Organise the Storage of Inventory Module 07: Inventory Management Techniques Module 08: Inventory Classification Module 09: Logistics Management and Organisation Module 10: Process Management Module 11: Improve Efficiency and Reduce Costs Module 12: Operating Forklifts Safely Module 13: Moving and Handling Loads Safely Module 14: Health and Safety Management Module 15: General Hazards Module 16: Manual and Mechanical Handling CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This Warehouse Associate will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path After completing this Course, you are to start your career or begin the next phase of your career in this field. Our entire course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Warehouse Associate Training
Delivered Online On Demand5 hours
£12

Medieval History Diploma Course

4.7(26)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Have you ever wondered about life in a castle, the impact of medieval battles, or the treasures buried beneath our feet? Medieval history continues to captivate the imagination and interest of many in the UK, as evidenced by the nearly 15% increase in museum visits to medieval collections over the past decade. This comprehensive Medieval History bundle offers a fascinating exploration of this period, equipping you with a range of valuable skills! This course bundle will equip you with a deep understanding of medieval history, from the fall of the Roman Empire to the rise of the Renaissance. You'll learn about military history, exploring the tactics and strategies of medieval warfare. You'll also gain insights into medieval society, culture, and art through courses on archaeology, arts management, and gemology. With a single payment, you will gain access to Medieval History course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Medieval History Bundle Package includes: Course 01: Diploma in Medieval History at QLS Level 5 10 Additional CPDQS Accredited Premium Courses - Course 01: Military History Course 02: Archaeology Course 03: Arts Management Course 04: Gemology Course 05: Egyptology Course 06: Politics Course 07: Media and Public Relations Diploma Course 08: Touch Typing Masterclass Course 09: Report Writing Course 10: Effective Methods of Public Speaking and Presentation Skill Whether you're a history buff or seeking to enhance your professional skillset, this bundle provides a unique opportunity to learn from experts and unlock the secrets of the medieval world. Enrol now! Learning Outcomes of Medieval History Analyze key events and developments of the Medieval Era. Explore the social, political, and economic structures of medieval society. Examine the role of warfare and military strategy in the Middle Ages. Uncover the fascinating world of medieval art, architecture, and culture. Develop critical thinking skills to evaluate historical evidence. Enhance your communication skills through report writing and public speaking. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Medieval History Get a free student ID card with Medieval History Training program (£10 postal charge will be applicable for international delivery) The Medieval History is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Medieval History course materials The Medieval History comes with 24/7 tutor support Start your learning journey straight away with this Medieval History bundle and take a step toward a brighter future! *** Course Curriculum: *** Main Course: Diploma in Medieval History at QLS Level 5 Module 01: Timeline of the Middle Ages Module 02: The Kings and the Vikings Module 03: Byzantine Empire: Survival, Revival and Collapse Module 04: The Christian World Module 05: Heresy to Christianity Module 06: The Islamic World Module 07: Medieval Life and Means of Living Module 08: Women in the Medieval Era Module 09: Literature Module 10: Art and Architecture Module 11: Magic and Science Module 12: Military and Warfare Module 13: The Emergence of State Power Module 14: Medieval Calamities: The Great Famine and the Black Death Course 01: Military History Module 1: Introduction To Military History Module 2: Theories Of Warfare Module 3: Military Weaponry And Aviation Module 4: Naval Warfare Module 5: Ground Warfare And Military Technology Module 6: The World Wars Module 7: The British Military History Module 8: Leadership And Command In War Course 02: Archaeology Module 01: Introduction To Archaeology Module 02: Different Types Of Archaeology Module 03: Archaeological Time Period Module 04: Archaeological Site Surveying And Features Module 05: Pre-Excavation Research: Dimensions Of Excavation And Safety Measures Module 06: Methods Of Excavation Module 07: The Process Of Excavation And Documentation Module 08: Post-Excavation Analysis Module 09: Understanding Dating In Archaeology Module 10: Archaeological Interpretation Module 11: Conservation: Protecting The World's Heritage =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Wish to gain a better understanding of relevant topics. Already working in this field and want to learn more about the topics. Is a student pursuing a relevant field of study? Requirements The Medieval History Bundle has no formal entry criteria, and everyone is welcome to enrol! Anyone with a desire to learn is welcome to this course without hesitation. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Entry-level Auctioneer (£20,000 to £24,000 per annum). Creative or Technical Writer (£22k to £49k annually), Collections Manager( £31,116 per annum) Teacher (entry level starts at around £31,570 per year). Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Medieval History at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Medieval History Diploma Course
Delivered Online On Demand3 weeks
£129

Diploma in Personal Development

4.3(43)

By John Academy

Description: This course is for individuals who are willing to develop talent and potential within themselves. This personal development course will help to believe in yourself. It will also help you understand what do you want to achieve in this life which will also help you achieve your dreams. It will also help you gain skills and abilities to enhance your thinking powers. It will also inform you programs, methods, tools, and techniques that support human development. Who is the course for? This course is for individuals who are looking forward to developing skills and abilities within themselves. This course is for individuals who are willing to become future personal development instructor or trainer. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Diploma in Personal Development is a useful qualification to possess, and would be beneficial for the following careers: Counsellor Stress management instructor Time management mentor Self-development instructor. Diploma in Personal Development Tony Robbins-Learn How to Achieve Bigger Things 00:30:00 Steve Pavlina-Quit Griping 00:30:00 Brian Tracy-Eat A Toad 00:30:00 Why Network Marketing Is Good 01:00:00 Deepak Chopra- Synchrodestiny 00:30:00 Jim Rohn-Work More Efficiently 01:00:00 Stephen Covey-Communicating 00:15:00 Dani Johnson-Facing Fear 01:00:00 Bob Proctor-No Limits 00:30:00 Abraham Maslow-Theory of Personality 01:00:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Diploma in Personal Development 00:20:00 Final Exam Final Exam- Diploma in Personal Development 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Personal Development
Delivered Online On Demand7 hours 40 minutes
£25

Beyond Software: How John Deere Used Scrum - Transform Innovation

By IIL Europe Ltd

Beyond Software: How John Deere Used Scrum to Transform Innovation This session will share the amazing results of John Deere's Scrum for Hardware implementation, including analysis as to why their efforts were so successful. Parts of success which will be covered are the Scrum framework and how it fits within the John Deere product development process, and the role of leadership, management, and workers in the change process. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Beyond Software: How John Deere Used Scrum - Transform Innovation
Delivered Online On Demand45 minutes
£15

Service Helpdesk & Technical Support

5.0(10)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Are you looking to enhance your Service Helpdesk & Technical Support Skills and make yourself a valuable asset in today's job market? Look no further, because our online course is designed to help you achieve just that! Our Service Helpdesk & Technical Support Skills course is ideal for professionals who want to enhance their existing skill set, beginners who want to kickstart their career, or even freelancers who want to start a new business on housekeeping. With this course, you'll gain practical knowledge and skills that are essential for anyone working in customer service and technical support. Learning Outcome of Service Helpdesk & Technical Support: Effective communication skills: Learn how to communicate clearly and effectively with customers and colleagues. Phone etiquette: Master the art of answering and making calls, and build a positive rapport with customers. Active listening: Learn how to listen actively and respond appropriately to customer needs. Problem-solving: Develop problem-solving skills to help you quickly and effectively resolve customer issues. Organisational skills: Learn how to manage your workload and stay organised in a fast-paced work environment. Customer relationship management: Learn how to build and maintain strong customer relationships over time. Business writing skills: Develop effective business writing skills to create clear, concise, and professional written communications. This Service Helpdesk & Technical Support Skills Bundle Consists of the following Premium courses: Course 01: Service Helpdesk & Technical Support Course Course 02: IT Support Technician Training Course 03: Email Writing Training Course 04: Workplace Safety Course 05: Dealing With Difficult People Training Course Course 06: Document Control Course 07: GDPR Course 08: Level 2 Microsoft Office Essentials Course 09: Minute Taking Essentials Level 2 Course 10: Workplace Confidentiality Course 11: Customer Relationship Management Service Helpdesk & Technical Support Skills Curriculum of Service Helpdesk & Technical Support Skills Bundle Course 01: Service Helpdesk & Technical Support Course Module 01: Managing Interoffice Calls and Voicemail Module 02: Aspects of Phone Etiquette Module 03: Business Telephone Skills Module 04: Building Rapport Over the Phone Module 05: Inbound and Outbound Calls module 06: Active Listening and Managing Tough Callers Module 07: Mail Services and Shipping Module 08: Intra Organisation Dealings Module 09: Problem Solving over the Phone Module 10: Record Keeping and Filing Systems Module 11: Business Writing Skills Module 12: Organisational Skills Module 13: Communication Skills Module 14: Customer Relationship Management Module 15: Effective Planning and Scheduling Module 16: Invoicing/Petty Cash How will I get my Certificate? After successfully completing the Service Helpdesk & Technical Support Skills course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificates: Free (Previously it was £10*11= £110) Hard Copy Certificates: Free (Previously it was £20*11= £220) So, enrol now in this Service Helpdesk & Technical Support Skills course to advance your career! CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Service Helpdesk & Technical Support Skills Anyone from any background can enrol in this Service Helpdesk & Technical Support Skills bundle. Requirements Service Helpdesk & Technical Support Skills Our Service Helpdesk & Technical Support Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. Career path Service Helpdesk & Technical Support Skills Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Service Helpdesk & Technical Support
Delivered Online On Demand
£49

Boundaries in the VCSE Workplace

By The Peer Partnership

This workshop is designed to support staff and organisations in the voluntary, community, and social enterprises (VCSEs) to consider, plan, and implement personal and professional boundaries in the workplace.

Boundaries in the VCSE  Workplace
Delivered OnlineFlexible Dates
£50

Sports Marketing

5.0(1)

By LearnDrive UK

Sports Marketing course will teach you how to use marketing principles to gain a better understanding of the sports industry and how to capitalize on it.

Sports Marketing
Delivered Online On Demand1 hour
£5

HR Administrator Training

By Compliance Central

Being an HR Administrator isn't just about managing people; it's about understanding the intricate details of recruitment, training, and performance and ensuring the overall well-being of the workforce. In the UK, HR administrators can earn an average salary of £25,000 to £35,000 annually, with senior roles commanding even higher. Furthermore, with a projected job demand increase in the coming years, it's a career worth exploring. Our HR Administrator Training course covers a comprehensive range of topics, from the foundational understanding of HR to the nuances of UK employment law. Whether you're kickstarting your HR career or seeking to refine your existing skills, this course offers essential theoretical knowledge to bolster your professional journey. Why would you choose the HR Administrator course from Compliance Central: Lifetime access to HR Administrator course materials Full tutor support is available from Monday to Friday with the HR Administrator course Learn HR Administrator skills at your own pace from the comfort of your home Gain a complete understanding of HR Administrator course Accessible, informative HR Administrator learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the HR Administrator bundle Study HR Administrator in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your HR Administrator Course Improve your chance of gaining in demand skills and better earning potential by completing the HR Administrator HR Administrator Curriculum Breakdown of the HR Administrator Course Module 01: Introduction to Human Resource Module 02: Employee Recruitment and Selection Procedure Module 03: Employee Training and Development Process Module 04: Performance Appraisal Management Module 05: Employee Relations Module 06: Motivation and Counselling Module 07: Ensuring Health and safety at the Workplace Module 08: Employee Termination Module 09: Employer Record and Statistics Module 10: Essential UK Employment Law Learning Outcomes Understand fundamental concepts of Human Resources. Gain insights into effective recruitment and selection procedures. Grasp the essentials of training and development processes. Learn the dynamics of performance appraisal management. Comprehend the intricacies of employee relations. Understand motivation strategies and counselling methods. Be familiar with UK employment laws and regulations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The HR Administrator course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in HR Administrator. It is also great for professionals who are already working in HR Administrator and want to get promoted at work. Requirements To enrol in this HR Administrator course, all you need is a basic understanding of the English Language and an internet connection. Career path HR Administrator: £18K to £25K per year. Recruitment and Selection Specialist: £25K to £45K per year. Training and Development Officer: £28K to £42K per year. Performance Appraisal Manager: £35K to £60K per year. Employee Relations Specialist: £30K to £55K per year. HR Compliance Officer: £30K to £50K 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

HR Administrator Training
Delivered Online On Demand3 hours
£12

Compliance Manager

4.7(160)

By Janets

The Risk and Compliance Manager Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Risk and Compliance Manager Course consists of several modules that take around 5 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays 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 Mock exams Multiple-choice assessment 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. Course Content Module 1: Introduction to Compliance Introduction to Compliance 00:23:00 Module 2: Five basic elements of compliance Basic Elements of Effective Compliance 00:26:00 Module 3: Compliance Management System (CMS) Compliance Management System 00:23:00 Module 4: Compliance Audit Compliance Audit 00:34:00 Module 5: Compliance and Ethics Compliance and Ethics 00:36:00 Module 6: Risk and Types of Risk Further Risk Types 00:44:00 Module 7- Introduction to Risk Management Introduction to Risk Management 00:13:00 Module 8: Risk Management Process Risk Management Process 00:20:00 Module 9: Time Management Time Management 00:36:00 Module 10:Organisational Skills Organisational Skills 00:26:00 Module 11: Communication Skills Communication Skills 00:26:00 Mock Exam Mock Exam- Compliance Manager 00:20:00 Final Exam Final Exam- Compliance Manager 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Compliance Manager
Delivered Online On Demand5 hours 47 minutes
£25

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered OnlineFlexible Dates
£885