6124 Courses

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

Duration 1 Days 6 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 Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. 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 Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

In today's interconnected world, the ability to conduct efficient remote video meetings is indispensable. Our course, 'Remote Video Meeting,' ushers you into the realm of virtual communication, starting from a simple welcome, easing into the basics, and then delving deeply into advanced strategies. As you manoeuvre through the curriculum, you'll grasp how to handle situations during the meeting and walk away armed with bonus tips, wrapping up your journey fully equipped to master virtual collaborations. Learning Outcomes Understand the fundamentals and etiquette of remote video communication. Acquire techniques for effective virtual engagement and participation. Navigate through challenges that arise during video meetings. Apply bonus strategies to enhance communication and ensure meeting productivity. Consolidate knowledge and best practices for future remote video interactions. Why buy this Remote Video Meeting course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Remote Video Meeting there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Remote Video Meeting course for? Professionals transitioning to remote or hybrid work environments. Team leaders aiming to streamline virtual team interactions. Students or educators wanting to optimise online classroom sessions. Businesses seeking to connect seamlessly with global clients. Individuals looking to improve their virtual communication acumen. Prerequisites This Remote Video Meeting does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Remote Video Meeting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Remote Team Coordinator: £30,000 - £45,000 Virtual Event Manager: £35,000 - £50,000 Online Communication Consultant: £40,000 - £60,000 Digital Collaboration Specialist: £45,000 - £65,000 E-Learning Developer: £30,000 - £47,000 Virtual Sales Representative: £28,000 - £52,000 Course Curriculum Section 01: Welcome Jennifer Flaa Bio 00:01:00 Welcome 00:02:00 Before We Begin 00:01:00 Section 02: Quick Start Dos 00:01:00 Don'ts 00:01:00 Behind the Scene 00:01:00 Top 3 Mistakes You Are Making in Video Meeting 00:01:00 Section 03: Deep Dive The Reasons for Dos and Don'ts 00:01:00 What Should I Wear on Video? 00:01:00 What's Behind You 00:01:00 Pulling Focus Away from You 00:01:00 Glare in Your Glasses 00:01:00 Practice Tips 00:01:00 Section 04: During the Video Meeting How to Start and End Your Video Meeting 00:01:00 Distractions 00:02:00 #1 Why to Bore Your Viewer 00:01:00 Section 05: Bonus Tips 4 Tips 00:01:00 Your Eyes Communicate Too 00:02:00 Water 00:01:00 Video Meeting Checklist 00:01:00 Section 06: Wrap Up Jenn's Thought 00:01:00 Assignment Assignment - Remote Video Meeting 00:00:00

Begin your career as an HR manager by enrolling in Course Cave's HR Management course. This course will help you pursue your goals and develop your knowledge, competence, and skill, whether you are a novice or a seasoned professional. It covers a wide range of topics to assist you in developing your HR management knowledge and skills. It provides step-by-step directions for hiring and selecting employees, improving employee relationships at work, and motivating and rewarding staff for better productivity. This HR manager course also provides in-depth knowledge of the various HR processes and functions. After completing this course, learners will be able to build the necessary HR skills and knowledge and manage an organization's HR functions. Upon registration, you will receive full course access and will be able to access the course materials from anywhere in the world, at any time, and on any internet-enabled device. Learning Outcomes You will be able to do the following at the end of the course: Examine the importance of human resources and their management in businesses. Describe HRM Models. Implement new employee recruitment and selection procedures in your business. Recognise the significance of a positive employee partnership. Create and execute a successful workplace training program. Inspire and empower your staff. Promote equality and manage diversity in your organisation Examine current health and safety legislation and regulations and workplace health and safety management and risk assessment. Talk about common employee complaints, disciplinary issues, and professional dismissal procedures. Improve your communication abilities. Prevent abuse and discrimination in the workplace. Taking easy anti-Covid-19 precautions that will help protect your employees and your business. Why Choose HR Management Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ****HR MANAGEMENT 9 COURSES BUNDLED INFO**** Main Course: HR Management Course *** 9 HR Management Bundle Additional Courses*** Course 01: Level 7 Business Management Course Course 02: Level 7 Diploma in Leadership & Management Course 03: Level 7 Diploma in Facilities Management Course Course 04: Level 5 Retail Management Course Course 05: Level 5 Report Writing Course Course 06: Level 4 Minute Taking Course Course 07: Level 3 Business Administration Course 08: Communication Skills Course [ Note: Free PDF certificate will provide as soon as completing the HR Management course ] Course Curriculum *** HR Management *** Module 1: Introduction Module 2: Recruitment and Selection Module 3: Employee Relationship Module 4: Performance Management Module 5: The Necessity of Training & Development in the Workplace Module 6: Motivating and Rewarding Employees Module 7: Equality and Diversity Module 8: Health and Safety of Employees Module 9: Talent Management Module 10: Succession Planning Module 11: Absence Management and Attendance Module 12: Handling Grievance, Discipline, Termination and Dismissal Module 13: Communication Techniques for the Workplace Module 14: Preventing Workplace Violence and Harassment Module 15: Conflict Resolution Module 16: Occupational Health Safety, Hygiene and Workplace Wellbeing of Employees Module17: COVID-19 and the Workplace Assessment Method After completing each module of the Manual Handling Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This HR Management course is highly recommended for anyone considering a career in human resources. This is something that existing HR workers who are desperate for promotion should think about. This course is open to business management students and anybody looking to improve their resume and career opportunities. Requirements There are no specific requirements for this HR Management course because it does not require any advanced knowledge or skills. Students who intend to enrol in this HR Management course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this HR Management course, you will be capable of applying for a variety of positions. After completing this course, you can continue your education with our updated version of HR Management if you want to keep up with your colleagues and peers or advance in your profession. Certificates Certificate of completion Digital certificate - Included

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user.  ✔ A complete course that covers all of Excel’s most advanced functions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

Duration 1 Days 6 CPD hours This course is intended for The target students for this course are office professionals with a foundational understanding of Adobe Acrobat Pro DC who want to use the advanced productivity features and the creative features of Acrobat Pro DC. Overview In this course you will create and manage PDF documents.Students will: ?Customize the Acrobat Pro DC workspace.?Create PDFs from technical documents.?Enhance PDF documents.?Create interactive PDF forms.?Finalize PDF files for commercial printing. In this course, students will use Adobe Acrobat Pro DC to convert technical documents to PDF files, enhance PDF documents, create interactive PDF forms, and prepare PDF files for commercial printing. Customizing the Acrobat Pro DC Workspace Customize the Toolbars Create Custom Tool Sets Creating PDFs from Technical Documents Create PDF Documents by Using Autodesk AutoCAD Measure Technical Drawings Create PDF Documents by Using Autodesk AutoCAD Embed Multimedia Enhance PDF Document Accessibility Use Actions Manage the Security of PDF Documents Creating Interactive PDF Forms Create a PDF Form Compile and Manage PDF Form Data Finalizing PDF Files for Commercial Printing Apply Color Management Settings Preview Printed Effects Perform Preflight on a PDF Document Create PDF/X, PDF/A, and PDF/E Compliant Files Create a Composite and Color Separations Export a PDF Document to Other Formats

Food safety combines a number of practices to reduce health hazards. These include premises hygiene, personal hygiene, risk control, pest control and waste management. This level 1 course is about minimising the level of potential hazards in a food catering setting.

In today’s dynamic business landscape, effective leadership is essential for guiding teams, managing change, and driving organisational success. This Advanced Diploma course offers a thorough exploration of leadership principles and management strategies tailored for those aiming to elevate their influence within organisations. From understanding foundational leadership theories to mastering communication and negotiation techniques, the course covers a broad spectrum of skills necessary to inspire high-performance teams and foster a positive workplace culture. Participants will also gain insight into critical areas such as talent management, succession planning, and risk management, ensuring a well-rounded grasp of leadership responsibilities. Alongside developing emotional intelligence and conflict management capabilities, learners will refine their ability to handle office politics tactfully and maintain ethical standards within a corporate environment. Practical modules on business process management and essential software tools further support participants in enhancing organisational efficiency and decision-making. This course is designed for professionals keen to advance their leadership expertise with content that is accessible and relevant in today’s digital and evolving work environment. Key Features CPD Certified Organisational Leadership - Advanced Diploma course Instant e-certificate Fully online, interactive Organisational Leadership - Advanced Diploma course with audio voiceover Developed by professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discover the nuances of motivation, the alchemy of high-performance teams, and the orchestration of change. From mastering the delicate dance of communication to navigating the tumultuous waters of conflict, every aspect of organisational leadership finds its rightful place in our curriculum. Moreover, we don't just scratch the surface; we dive into the very heart of organisational leadership excellence. Explore the realms of emotional intelligence, risk management, and corporate responsibility. And as a cherry on top, immerse yourself in the realm of digital proficiency with modules covering Microsoft Word, Excel, and PowerPoint. With our programme, you don't just learn about organisational leadership; you become the embodiment of it, ready to carve your path in the ever-evolving landscape of organisational leadership brilliance Course Curriculum Module 01: Understanding Management and Leadership Module 02: Leadership Theories Module 03: Improving Management and Leadership Performance Module 04: High Performance Teams Module 05: Motivating Employees Module 06: Organisational Skills Module 07: Talent Management Module 08: Succession Planning Module 09: Business Process Management Module 10: Communication Skills Module 11: Negotiation Techniques Module 12: Managing Meetings and Giving Feedback Module 13: Managing Change Module 14: Time Management Module 15: Stress Management Module 16: Emotional Intelligence in Leadership Module 17: Managing Conflict Module 18: Dealing with Office Politics Module 19: Risk Management Module 20: Corporate Responsibility and Ethics Module 21:Microsoft Word, Excel, PowerPoint Learning Outcomes: Understand key concepts in management and organisational leadership theories comprehensively. Enhance performance through improved management techniques and organisational leadership strategies effectively. Develop high-performance teams and motivate employees efficiently for productivity. Demonstrate effective communication, negotiation, and conflict resolution skills adeptly. Implement organisational change, risk management, and corporate responsibility ethically. Utilise Microsoft Office tools proficiently for business process management. Accreditation All of our courses, including this Organisational Leadership - Advanced Diploma course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Organisational Leadership. Certification Once you've successfully completed Organisational Leadershipyour course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Organisational Leadership course certification has no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Organisational Leadership - Advanced Diploma course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Organisational Leadership - Advanced Diploma course is ideal for: Entry-level managers seeking advanced leadership skills development. Mid-career professionals aiming to enhance managerial and leadership competencies. Aspiring leaders in various industries looking to advance their careers. Individuals interested in developing skills in talent management and succession planning. Those wishing to excel in communication, negotiation, and conflict resolution. Requirements Learners do not require any prior qualifications to enrol on this Organisational Leadership course. You just need to have an interest in Organisational Leadership. Career path After completing this Organisational Leadership - Advanced Diploma Course you will have a variety of careers to choose from. The following job sectors of Organisational Leadership - Advanced Diploma are: Team Leader Human Resources Manager Project Manager Operations Manager Business Development Executive Corporate Social Responsibility Officer Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

🌟 Unleash Your Potential with 'Mindset Mastery: Fortifying Your Will' Online Course! 🌟 Are you ready to break free from limitations, tap into your inner strength, and achieve unparalleled success in every facet of your life? Welcome to 'Mindset Mastery: Fortifying Your Will' - the transformative online course designed to empower you with the mindset tools and techniques to conquer challenges and excel beyond boundaries! 🚀 What You'll Gain: Powerful Mindset Strategies: Learn how to cultivate a resilient mindset that overcomes obstacles and turns setbacks into stepping stones for growth. Willpower Enhancement: Strengthen your willpower muscle and learn how to stay focused, motivated, and driven towards your goals even in the face of adversity. Positive Habits Formation: Develop empowering habits that propel you forward, enhance productivity, and foster a winning mentality. Self-Discovery & Confidence Boost: Discover your inner strengths, unlock hidden potentials, and build unshakable self-confidence to navigate challenges with ease. Goal Achievement Mastery: Master the art of setting and achieving ambitious goals by aligning your mindset with your aspirations.   🌈 What's Included: Engaging Video Lessons Interactive Exercises & Worksheets Guided Meditations Exclusive Community Support Bonus Resources & Tools   💡 Who Is This Course For? Whether you're an aspiring entrepreneur, a professional aiming for career advancement, a student striving for academic excellence, or simply someone eager to unleash their full potential, 'Mindset Mastery: Fortifying Your Will' is your gateway to unlocking the pinnacle of success in every aspect of life. 🔥 Don't let a limited mindset hold you back from realizing your dreams! Join the ranks of countless individuals who've transformed their lives through mastering their mindset. Ready to take charge of your destiny? Enroll now and embark on a life-changing journey towards mastering your mindset and fortifying your will! Course Curriculum Module- 1 Sample 00:00 Module- 2 00:00 Module- 3 00:00 Module- 4 00:00 Module- 5 00:00 Module- 6 00:00 Module- 7 00:00 Module- 8 00:00 Module- 9 00:00 Module- 10 00:00 Module- 11 00:00

CPD Certified Diploma| 35-in-1 Premium Bundle| Free PDF & Transcript Certificates| Lifetime Access