6128 Courses

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

🌟 Discover the Path to Workplace Wellness and Stress Reduction! 🌟   Welcome to our transformative online course: 'Workplace Wellness and Stress Reduction Program.' Are you ready to reclaim balance, enhance productivity, and foster a more fulfilling work-life? This course is your guide to achieving just that!   🚀 MODULE 01: Introduction Get started on your wellness journey as we lay the foundation for understanding the significance of workplace wellness and stress reduction. 🌟 MODULE 02: Calling Forward Your True Self to Lead Unlock your potential by tapping into your authentic self, empowering you to lead with confidence and purpose. 🔍 MODULE 03: Becoming Aware of Your Blind Spots (FEARS) Identify and address the blind spots that hinder your growth and success, focusing on overcoming fears that impede progress. 💪 MODULE 04: Preparing Your Body to Reduce Stress Explore techniques and practices to equip your body physically and mentally, fostering resilience against stressors. 🌻 MODULE 05: Taking Care of Your Blind Spots (FEARS) Dive deeper into strategies tailored to address and overcome your specific fears, promoting personal and professional growth. 🎯 MODULE 06: Blueprint to Manage Your Work Stress - Putting it All Together Construct a comprehensive blueprint to effectively manage work-related stress, synthesizing the knowledge gained throughout the course.   🌈 What You'll Gain: Strategies to mitigate stress in the workplace Techniques to enhance self-awareness and authenticity in leadership Methods to identify and overcome personal blind spots and fears Practical tools for physical and mental well-being A personalized blueprint to manage work stress effectively   🌟 Why Choose Us? Expert-led curriculum designed by industry professionals Actionable and practical modules for immediate implementation Engaging exercises, assessments, and resources for comprehensive learning Flexible learning schedule to suit your pace and commitments Supportive community for shared experiences and growth   🌟 Who Is This Course For? This course is perfect for professionals seeking to thrive in their careers while prioritizing their well-being. Whether you're a team leader, entrepreneur, or employee, this program equips you with invaluable skills for success and fulfillment. Don't let stress hold you back from achieving your true potential! Enroll now and embark on a journey towards workplace wellness, empowered leadership, and a more fulfilling work life. Start your transformation today! 🚀 Join our Workplace Wellness and Stress Reduction Program and take charge of your well-being and success! 🚀 Course Curriculum Module 01: Introduction Introduction 09:03 Module 02: Calling Forward Your True Self to Lead Calling Forward Your True Self to Leadx 23:41 Module 03: Becoming Aware of Your Blind Spots (FEARS) Becoming Aware of Your Blind Spots (FEARS) 15:41 Module 04: Preparing Your Body to Reduce Stress Preparing Your Body to Reduce Stress 22:03 Module 05: Taking Care of Your Blind Spots (FEARS) Taking Care of Your Blind Spots (FEARS) 37:17 Module 06: Blueprint to Manage Your Work Stress - Putting it All Together Blueprint to Manage Your Work Stress - Putting it All Together 21:18

🌟 Unlock Your Full Leadership Potential with the Executive Leadership Mastery Program! 🌟 Are you ready to elevate your career to new heights and become the leader you were born to be? Introducing our exclusive online course - the Executive Leadership Mastery Program! Designed for ambitious professionals like you, this comprehensive program will equip you with the skills, strategies, and mindset necessary to thrive in the fast-paced world of executive leadership.   🚀 What You'll Master: 🌐 Introduction: Get ready to embark on a transformational journey! We'll lay the foundation for success by exploring the principles of effective executive leadership, setting the stage for your personal and professional growth. 🔥 Module 1: Leadership Skills Training Dive deep into the core of leadership excellence. Learn how to inspire and motivate your team, navigate challenges with resilience, and make strategic decisions that drive success. Uncover the secrets of renowned leaders and apply their proven techniques to your own leadership style. 🛠️ Module 2: Management Skills Training Discover the art of effective management. From project planning to resource allocation, you'll gain practical skills to streamline operations and boost productivity. Learn how to lead with confidence, ensuring that your team is not just meeting, but exceeding, organizational goals. 🌟 Module 3: Creating A Great Culture Explore the critical role of organizational culture in achieving sustained success. Discover how to foster a positive work environment that encourages innovation, collaboration, and employee satisfaction. Transform your workplace into a hub of creativity and excellence. 🤝 Module 4: Teamwork - Create High-Performance Teams Master the art of teamwork and collaboration. Learn strategies to build and lead high-performance teams that deliver outstanding results. From effective communication to conflict resolution, this module will empower you to cultivate a dynamic team that consistently achieves and surpasses expectations.   🎓 Why Choose Our Program: ✨ Expert Guidance: Learn from industry experts and thought leaders with a wealth of real-world experience. ✨ Flexibility: Access the course anytime, anywhere, and at your own pace, fitting seamlessly into your busy schedule. ✨ Practical Application: Our curriculum is designed for immediate application, ensuring you see results in your leadership style and team dynamics. ✨ Networking Opportunities: Connect with a community of like-minded professionals, fostering valuable relationships for your career advancement.   🚀 Elevate your leadership journey today! Don't miss this opportunity to join the ranks of successful executives who have transformed their careers with the Executive Leadership Mastery Program.   👉 Enroll Now and take the first step towards becoming the exceptional leader you are destined to be! 👈 Course Curriculum Introduction Introduction 00:00 Module 1: Leadership Skills Training Module 1: Leadership Skills Training 00:00 Module 2: Management Skills Training Module 2: Management Skills Training 00:00 Module 3: Creating A Great Culture Module 3: Creating A Great Culture 00:00 Module 4: Teamwork - Create High Performance Teams Module 4: Teamwork - Create High Performance Teams 00:00

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will help you build a solid foundation to become a proficient worker in the sector. This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : MS Word Diploma Course 02 : Proofreading & Copyediting Course 03 : PowerPoint Diploma Course 04 : Microsoft Excel Level 3 Course 05 : New Functions in Microsoft Excel 2021 Course 06 : Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07 : Microsoft Excel: Excel Sheet Comparison with VBA Course 08 : Microsoft Excel: Master Power Query in 120 Minutes! Course 09 : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10 : Excel Pivot Tables Course 11 : Data Analysis in Microsoft Excel Complete Training Course 12 : Excel Must know Formulas and Functions Course 13 : Excel spreadsheet for Beginner Course 14 : Excel Data Analysis Course 15 : Excel Vlookup, Xlookup, Match and Index Course 16 : Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17 : PowerBI Formulas Course 18 : Outlook Tips and tricks Course 19 : Excel PowerQuery and PowerPivot Course 20 : Complete Microsoft Power BI 2021 Course 21 : The Complete Microsoft Outlook Masterclass Course 22 : Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 23 : Microsoft Access Tables and Queries Course 24 : Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 27: Data Protection and Data Security Level 2 Course 28: Office Skills and Administration Management Diploma Course 29: Touch Typing Essentials Course 30: Document Control 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

24 Hour Flash Deal **25-in-1 Executive Assistant Advanced Diploma Mega Bundle** Executive Assistant Advanced Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Executive Assistant Advanced Diploma package online with Studyhub through our online learning platform. The Executive Assistant Advanced Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Executive Assistant Advanced Diploma course provides complete 360-degree training on Executive Assistant Advanced Diploma. You'll get not one, not two, not three, but twenty-five Executive Assistant Advanced Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Executive Assistant Advanced Diploma courses are yours for as long as you want them once you enrol in this course This Executive Assistant Advanced Diploma Bundle consists the following career oriented courses: Course 01: Executive Assistant Course 02: Contract Management Certification Course 03: Medical Secretary Certification Course 04: Legal Secretary Skills Diploma Course 05: Diploma in Minute Taking Training Course 06: Diary Management Course 07: Office Admin and Reception Course 08: Report Writing Skills: Crafting Effective Business Reports Course 09: Equality, Diversity and Discrimination Course 10: HR Management Course 11: UK Employment Law Course 12: Employee Hiring and Termination Training Course 13: Safer Recruitment Training Course 14: Performance Management Course 15: Employee Engagement and Retention Strategies Course 16: Governance and Risk Management: Navigating Corporate Strategies Course 17: Managing Online Meetings Course 18: Facilities Management Course 19: Motivation - Motivating Yourself & Others Course 20: Workplace Confidentiality Course 21: Data Protection and Data Security (GDPR) Training Certification Course 22: Organisation & People Management Course 23: Change Management Course 24: Team Management Course 25: Stakeholder Management The Executive Assistant Advanced Diploma course has been prepared by focusing largely on Executive Assistant Advanced Diploma career readiness. It has been designed by our Executive Assistant Advanced Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Executive Assistant Advanced Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Executive Assistant Advanced Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Executive Assistant Advanced Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Executive Assistant Advanced Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Executive Assistant Advanced Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Executive Assistant Advanced Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Executive Assistant Advanced Diploma lessons One to one assistance from Executive Assistant Advanced Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Executive Assistant Advanced Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Executive Assistant Advanced Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Executive Assistant Advanced Diploma certificate and transcript on the next working day Easily learn the Executive Assistant Advanced Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Executive Assistant Advanced Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Executive Assistant Advanced Diploma Requirements To participate in this Executive Assistant Advanced Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Executive Assistant Advanced Diploma Career path You will be able to kickstart your Executive Assistant Advanced Diploma career because this course includes various courses as a bonus. This Executive Assistant Advanced Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Executive Assistant Advanced Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

***24 Hour Limited Time Flash Sale*** IT Support Technical Skills Bootcamp Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter As digital transformation accelerates, demand for qualified IT support technicians surges in the UK. The IT industry is booming, with an expected growth of 12% by 2027, creating over 1 million new jobs. Do you have an interest in maintaining networks, securing systems, and providing technical support? This IT Support Technical Skills Bootcamp bundle delivers the well-rounded expertise today's IT teams need. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our IT Support Technical Skills Bootcamp bundle is a comprehensive programme that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in IT Support Technical Skills Bootcamp Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this IT Support Technical Skills Bootcamp Career Bundle: Course 01: Advanced Diploma in IT Support Technician at QLS Level 7 Course 02: Network Security and Risk Management Course 03: CompTIA Network Course 04: Information Management Course 05: Web Application Penetration Testing Course Course 06: CompTIA Cloud+ (CV0-002) Course 07: ASP.Net MVC and Entity Framework Course Course 08: Computer Operating System and Troubleshooting Course 09: PLC Programming Diploma Course 10: Learn Spring & Angular Material with a Full Web Application Course 11: SQL Server 101: Microsoft SQL Server for Absolute Beginners Course 12: JavaScript Course 13: Python Course Course 14: Learn Ethical Hacking with Kali Linux Course 15: Building Your Own Computer Course Course 16: Ruby on Rails Web Application Framework Course 17: Create Your First Responsive Website Course 18: Data Science and Visualisation with Machine Learning Course 19: Cisco ASA Firewall Training Course Course 20: SQL For Data Analytics & Database Development Course 21: TypescriptU&P AI - Natural Language Processing (NLP) with Python Course 22:C# (C-Sharp) Course 23:MS Word Essentials - The Complete Word Course - Level 3 Course 24: Web Design (HTML, CSS, Bootstrap) Complete Course Course 25: Website Hacking From Scratch Course 26: Diploma in Front-End Web Development (HTML, CSS, & Bootstrap) Course 27: Data Protection (GDPR) Practitioner Course 28: SQL Database Administrator Course 29: Cisco ASA Firewall Training Course Course 30: IT: Ethical Hacking & IT Security With IT Support Technical Skills Bootcamp, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes of IT Support Technical Skills Diagnose and troubleshoot IT hardware and software issues. Implement network security best practices and manage risks. Gain industry-recognized CompTIA certifications. Develop web applications using popular frameworks and languages. Automate tasks with scripting and programming skills. Build a strong foundation for further specialization in IT. Enrol in IT Support Technical Skills Bootcamp today and take the first step towards achieving your goals and dreams. Why buy this IT Support Technical Skills Bootcamp? Get a Free CPD Accredited Certificate upon completion of the course Get a free student ID card with this training program The course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the course materials The training program comes with 24/7 tutor support Start your learning journey straightaway with our IT Support Technical Skills Bootcamp Training! IT Support Technical Skills Bootcamp premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of IT Support Technical Skills Bootcamp is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the IT Support Technical Skills Bootcamp course. After passing the course exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 480 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Support Technical Skills Bootcamp course is ideal for: Students seeking mastery in IT Support Technical Skills Bootcamp Professionals seeking to enhance IT Support Technical Skills Bootcamp skills Individuals looking for an IT Support Technical Skills Bootcamp-related career. Requirements This IT Support Technical Skills Bootcamp doesn't require prior experience and is suitable for diverse learners. Career path This IT Support Technical Skills Bootcamp bundle will allow you to kickstart or take your career in the related sector to the next stage. IT Support Specialist Network Administrator Cloud Engineer Web Developer Security Analyst Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Overview: Materials Handling Safety Training   In today's industrial and warehouse environments, the efficient and safe handling of materials is paramount. The 'Materials Handling Safety Training' course is designed to equip participants with the knowledge and skills necessary to navigate various hazards and challenges associated with material handling operations. From loading docks to forklift operations, this comprehensive training program focuses on promoting a culture of safety and adherence to best practices.   Module 1: Introduction to Loading Dock Safety Equipment and Maintenance Understanding the importance of loading dock safety Identifying loading dock hazards Proper maintenance and inspection of loading dock equipment Safety protocols for loading and unloading procedures Module 2: Safe Forklift Operations and Hazardous Materials Handling Forklift operation fundamentals Pre-operation inspection and maintenance procedures Techniques for safe maneuvering and load handling Handling hazardous materials safely and responsibly Module 3: Fall Protection and Fire Safety Recognizing fall hazards in the workplace Implementing fall prevention measures and equipment Fire prevention and extinguishing techniques Emergency evacuation procedures Module 4: Material Handling and Traffic Management Efficient material handling techniques Traffic management in busy warehouse environments Pedestrian safety protocols Organizing and optimizing material flow for productivity and safety Module 5: Hazard Communication and Security Awareness Understanding chemical hazards and safety data sheets Proper labeling and storage of hazardous materials Recognizing and reporting security threats Protocols for handling suspicious packages or activities Module 6: Incident Reporting and Safety Culture Importance of incident reporting and investigation Procedures for documenting and reporting accidents or near misses Promoting a culture of safety and accountability in the workplace Continuous improvement and feedback mechanisms for enhancing safety practices   Course Format: Each module consists of interactive presentations, case studies, and practical exercises. Participants will have access to online resources and materials for further learning. Assessments and quizzes will be conducted to ensure understanding and retention of key concepts. Experienced instructors will be available for guidance and clarification throughout the course.   Who Should Attend: Warehouse workers Material handlers Forklift operators Safety officers Supervisors and managers overseeing material handling operations   By completing this course, participants will not only enhance their own safety awareness but also contribute to creating a safer and more efficient work environment for themselves and their colleagues. Course Curriculum Module 1 Introduction to Loading Dock Safety Equipment and Maintenance Introduction to Loading Dock Safety Equipment and Maintenance 00:00 Module 2 Safe Forklift Operations and Hazardous Materials Handling Safe Forklift Operations and Hazardous Materials Handling 00:00 Module 3 Fall Protection and Fire Safety Fall Protection and Fire Safety 00:00 Module 4 Material Handling and Traffic Management Material Handling and Traffic Management 00:00 Module 5 Hazard Communication and Security Awareness Hazard Communication and Security Awareness 00:00 Module 6 Incident Reporting and Safety Culture Incident Reporting and Safety Culture 00:00