51157 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 from our growing corporate clients 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 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. 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 Certificates Certificates Certificate of completion Digital certificate - Included

Our training programme will provide those involved at any stage of the process for procuring goods and/or services within their organisations with the knowledge and skillset to identify and mitigate the threat posed by the breadth and multi-layered complexity of procurement fraud, corruption and associated financial crime and money laundering.

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Safety and Project Management 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 33 course mega bundle that will exceed your expectations within your budget. The Construction Safety and Project Management 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 Construction Safety and Project Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Safety and Project Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Construction Management and Procurement Course 02:Construction Industry Scheme (CIS) Course 03:Construction Project Management Level 4 Course 04:Construction Site Management Level 4 Course 05:Construction Cost Estimation Diploma Course 06:Construction Safety Course 07:Domestic Plumbing, Installations and Repair Diploma Course 08:Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 09:Domestic Appliance Repairing Course Course 10:Functional Skills IT Course 11:Delegation Skills Course 12:Effective Communication Skills Course 13:Domestic Gas Engineer Course 14:Level 2 Domestic Gas Course Course 15:Oil and Gas Management Course 16:Domestic Gas Working Course Course 17:Gas Safety Course 18:Fire Safety | Online Course Course 19:Electrical Components And Circuits - Wiring & Busbars Course 20:Light Current Systems for Electrical Engineering Course 21:Electrical Machines for Electrical Engineering Course 22:Environmental Engineering Course 23:Sustainable Energy and Development Diploma Course 24:Environment Management Course 25:Power Electronics for Electrical Engineering Course 26:Engineering Management Course 27:Electric Circuits for Electrical Engineering Course 28:Trigonometry for Electrical Engineering Course 29:Electrical Technician Course 30:Electronic & Electrical Devices Maintenance 3 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 Learning Outcome This tailor-made Construction Safety and Project Management 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 Construction Safety and Project Management 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 330 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 Construction Safety and Project Management 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 Construction Safety and Project Management 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.

***24 Hour Limited Time Flash Sale*** Office Management, Minute Taking and Document Control-Endorsed Certificate Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In the fast-paced environment of the UK workplace, efficient office management is paramount. Did you know that, according to a recent survey, about 83% of UK businesses emphasised the need for skilled office managers to boost productivity? Are you prepared to enhance office efficiency and handle documentation like a pro? This Office Management bundle is designed to elevate your administrative and management skills, setting you apart in the professional world. You'll learn effective office management techniques, master the art of minute-taking, and gain expertise in document control. Develop strong communication skills to build successful teams and navigate complex projects. Additionally, gain a solid understanding of compliance and risk management to ensure your organization operates smoothly. Finally, learn strategies to conquer workplace disorganization and create a more productive environment. Key Features of the Office Management, Minute Taking and Document Control-Endorsed Certificate Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Office Management, Minute Taking and Document Control-Endorsed Certificate bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Office Management and Administration Diploma QLS Course 02: Minute Taking Executive Training Level 5 QLS Course 03: Document Control 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Team Building Masterclass Course 02: Communication Building Masterclass Course 03: Effective Communication with Better Email Course 04: Compliance and Risk Management Diploma Course 05: Mastering Organizational Chaos In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Office Management, Minute Taking and Document Control-Endorsed Certificate courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Don't miss this opportunity to enhance your professional profile and open doors to new career prospects. Enroll in the Office Management, Minute Taking, and Document Control Bundle today and unlock a world of possibilities! Learning Outcomes of Office Management Implement effective office management strategies and administrative best practices. Develop proficiency in minute-taking and accurate record-keeping. Establish robust document control systems for efficient information management. Foster strong team collaboration and effective communication skills. Analyze compliance and risk management principles for organizational success. Implement strategies to overcome organizational chaos and enhance productivity. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Office Management Get a free student ID card with Office Management Training program (£10 postal charge will be applicable for international delivery) The Office Management is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Office Management course materials The Office Management comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** QLS Course 01: Office Management and Administration Diploma Personal Assistant Admin Support Organisational Skills Telephone Etiquette Business Writing Time Management Body Language and Effective Communication Meeting Management QLS Course 02: Minute Taking Executive Training Level 5 Module 01: Introduction To Minute Writing Module 02: Preparation For Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision And Action Module 05: Roles And Responsibility Of Minute Taker Module 06: Tips For Minute Taking Module 07: Technology In Minute Taking Module 08: Building Confidence QLS Course 03: Document Control Module 1: Introduction To Document Control Module 2: Principles Of Document Control And Elements Of Document Control Environment Module 3: Document Control Lifecycle Module 4: Document Control Strategies And Instruments Module 5: Document Management Module 6: Quality Assurance And Controlling Quality Of Documents Module 7: Project Document Control Module 8: Electronic Document Management Systems And Soft Copy Documentation =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*13 = £168) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Course: Previously it was £119*3 =357) CPD 450 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: Professionals seeking to enhance their office management and administration skills. Individuals interested in developing expertise in minute-taking and executive training. Document control professionals aiming to strengthen their knowledge and skills. Team leaders and managers looking to improve team dynamics and communication. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Office Manager: £25,000 - £45,000 per year Executive Assistant: £28,000 - £45,000 per year Document Controller: £23,000 - £40,000 per year Compliance Officer: £30,000 - £50,000 per year Team Leader: £25,000 - £40,000 per year Communications Specialist: £25,000 - £45,000 per year Certificates Certificate in Document Control at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Certificate in Office Management at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. 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. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Diploma in Minute Taking at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

QA Level 3 Award In Paediatric First Aid (RQF) Two day course HSE highly recommends this course for those who work with children in a childcare setting Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering Course Contents: The Roles and Responsibilities of an Emergency Paediatric First Aider Assessing an Emergency Situation Accident Recording Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Infant and Child Recovery Position Infant and Child CPR Infant and Child Safe Use of an AED (Automated External Defibrillator) Choking Anaphylaxis Seizures Wounds and Bleeding Hypovolaemic Shock Head, Neck and Back Injuries Sprains, strains, dislocations and fractures Meningitis Asthma Diabetes Eye, Ear and Nose Conditions Poisoning Electric Shock Bites and Stings Hot and Cold Temperatures Benefits of this course: Would you know what to do if you saw a child in need of First Aid? Children are prone to minor injuries, but suffer from serious injuries also In 2014, 2,269 children in the UK were so badly bitten by an animal they had to be admitted to hospital More than 2 million children have accidents in the home for which they're taken to A&E - every year, with Under 5s accounting for 7% of all hospital emergency treatments Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering. This QA Level 3 Award in Paediatric First Aid (RQF) qualification is ideal for: - Parents/carers or family members who want to learn key paediatric first aid skills - those who work with, or intend to work with children in a childcare setting as it is designed to fulfill Ofsted’s First Aid requirements for early years teachers, nursery workers and childminders (as defined within the Statutory Framework for the Early Years Foundation Stage (EYFS) 2014 and within the Child Care Register guide) Childcare settings who are working towards Millie’s Mark We also run a Paediatric Annual Refresher to keep those life-saving skills up to date Accredited, Ofqual regulated qualification: Our Paediatric First Aid at Work course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies). The Ofqual Register number for this course is 603/0785/7

If you want to start installing independently or with an electrical contractor look no further as this course will give you the skills and knowledge required. This package which will allow you to become a fully qualified domestic installer and enable you to join a Competent Person Self-Certification Scheme and certify your own domestic work.

Overview This course is specially designed to enhance the skills required to analyse risk and crisis and the cause behind this. It will feed you with the necessary skills to minimise the chances of risk and in case it happens able to manage the situation in order to keep the business in a stable position. The course content will cover different crises caused due to internal or external issues and different ways to manage them. It will help the professionals to gain skills in planning beforehand various techniques to overcome risk and crisis and implementing the plan during that phase.

Overview This course is specially designed to enhance the skills required to analyse risk and crisis and the cause behind this. It will feed you with the necessary skills to minimise the chances of risk and in case it happens able to manage the situation in order to keep the business in a stable position. The course content will cover different crises caused due to internal or external issues and different ways to manage them. It will help the professionals to gain skills in planning beforehand various techniques to overcome risk and crisis and implementing the plan during that phase.

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