19501 Step 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

24-Hour Flash Sale! Prices Reduced Like Never Before!! Stakeholder Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Stakeholders have the power to be either a threat or a benefit to an organisation. It's about maintaining relationships between an organisation and its stakeholders. Effective stakeholder management is critical to project success. According to the Project Management Institute (PMI), amongst those organisations considered to be highly effective communicators, 80% of projects meet original goals, 71% deliver projects on time and 76% are within budget. So take a step towards becoming a reliable communicator in the field of finance with this ultimate Stakeholder Management Bundle! Transform yourself into a master of influence and strategy for Stakeholder Management. This is a specially designed course covering everything from Strategic Management to advanced Financial Modelling and Cross-cultural Communication. This comprehensive suite of courses provides the skills to effectively manage and influence diverse groups and drive successful outcomes. Whether it's navigating Corporate Strategies, mastering Agile Methodologies, or crafting Impactful Marketing Plans, you'll gain the expertise to thrive in high-stakes environments. Courses Are Included in this Stakeholder Management Bundle: Course 01: Stakeholder Management: Tools and Strategies Course 02: Strategic Management and Leadership Development Course 03: Governance and Risk Management: Navigating Corporate Strategies Course 04: Strategic Planning and Analysis for Marketing Course 05: Corporate Relationship Goals for Success Course 06: Corporate Social Responsibility Diploma Course 07: Public Speaking: Presentations like a Boss Course 08: Diploma in Workplace Professionalism Course 09: Negotiation Skills Course 10: Raise Money and Valuation for Business Course 11: Credit Control Course 12: Learn to Read, Analyse and Understand Annual Reports Course 13: Financial Analysis for Finance Reports Course 14: Financial Modelling Using Excel Course 15: Microsoft Excel Complete Course Course 16: Craft Excel Pivot Tables for Data Reporting Course 17: Internal Audit Analyst Training Course 18: Internal Compliance Auditor Course 19: Budget & Forecast Course 20: Purchase & Procurement Course 21: Merchandising Course 22: Sales Manager Management Course 23: Marketing Course 24: Ecommerce Marketing Course 25: Agile Scrum Master Certification Course 26: Six Sigma Green Belt Diploma Course 27: Lean Leadership, Culture and Management - Online Diploma Course 28: Cross-Cultural Awareness Training Diploma Certificate Course 29: Human Resources Management Course 30: Project Management Course 31: Talent Management & Employee Retention Techniques Course 32: Motivational Mentorship: Inspiring Personal and Professional Growth Course 33: Employee Training Responsibilities: Effective Training Management Course 34: Employee Hiring and Termination Training Course 35: UK Employment Law Course 36: Performance Management Course 37: Team Management Course 38: Change Management Course 39: Middle Manager Management Course 40: Workplace Communication Management Step beyond the conventional and become the strategic mastermind your organisation needs. This bundle isn't just about learning-it's about leading change and crafting a career that stands out. Embrace the journey to becoming a pivotal force in your workplace by enroling in the Stakeholder Management bundle today. Your future as a leader awaits! Learning Outcomes of this Bundle: Master stakeholder identification, engagement, and communication strategies Managing stakeholders effectively in running a project or a business Learning different theories of stakeholder management Building and developing a solid, lasting relationship with the stakeholders Understanding the potential conflicts with stakeholders This Diploma in Stakeholder Management at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer Us? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPD QS. Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Stakeholder Management: Tools and Strategies Module 01: Introducing Module 02: Stakeholder Theories Module 03: Stakeholder Mapping Module 04: Building Strong Business Relationships With Stakeholders Module 05: Stakeholder Engagement Module 06: Stakeholder Engagement Through Effective Communication Module 07: Monitoring and Evaluating the Engagement Module 08: Managing Stakeholder Conflict Course 02: Strategic Management and Leadership Development Module 01: Introduction To Strategic Management Business Module 02: Strategy Formulation Module 03: Strategy Implementation Module 04: Evaluation And Control Module 05: Understanding Management And Leadership Module 06: Leadership Theories Module 07: Improving Management And Leadership Performance Course 03: Governance and Risk Management: Navigating Corporate Strategies Module 01: Introduction To Corporate Governance Module 02: Governance Structures And Mechanisms Module 03: Transparency, Disclosure, And Ethics Module 04: Corporate Governance In ESG Module 05: Introduction To Risk Management Module 06: Risk And Types Of Risk Module 07: Risk Management Process Module 08: Compliance And Ethics Module 09: Compliance Audit =========>>>>> And 37 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*40 = £520) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £99) CPD 510 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: Aspiring business leaders Project managers Financial analysts HR professionals Marketing executives Compliance officers Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Strategic Project Manager: £55,000 - £85,000 Financial Analyst: £35,000 - £60,000 HR Manager: £40,000 - £65,000 Marketing Director: £60,000 - £100,000 Compliance Manager: £50,000 - £75,000 Business Consultant: £50,000 - £90,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. 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 Stakeholder Management at QLS Level 4 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Affordable 8-week mindfulness course for beginners and those who want to start or resume their mindfulness practice.

Whether you're a tech-savvy novice or an experienced pro, this inclusive Coding with HTML, CSS, & JavaScript training course will provide the tools and techniques necessary to code like a professional. This Diploma in HTML, CSS, & Javascript Coding at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! With step-by-step tutorials that cover everything from basic styling and optimisation to advanced coding concepts and best practices, you'll be able to craft websites that look great and perform flawlessly. Then, with real-world examples and hands-on practice, we'll show you how to use Coding with HTML, CSS, and JavaScript to create stunning webpages, vibrant visuals, and powerful apps. You'll also get valuable insight into industry trends, emergent technologies, and cutting-edge development strategies. After completing the Coding with HTML, CSS, and JavaScript Training course, you'll have all the skills necessary to build complex projects from the ground up and make your mark as an expert coder. So enrol in the Coding with HTML, CSS, and JavaScript Training course to achieve your goal. What will you learn form this Coding with HTML, CSS, and JavaScript Training Course: Learn Standard HTML. Ability to build a straightforward website from scratch. The use of CSS on HTML pages. Discover CSS syntax. What CSS coding is. Fundamentals of JavaScript. JavaScript's usage in a game project. Acquire the fundamentals of JavaScript. Why Prefer This HTML, CSS, & Javascript Coding at QLS Level 4 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments. 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Coding with HTML, CSS, & Javascript at QLS Level 4 course: Welcome HTML 5 CSS 3 Bootstrap Project 1 - Design a Landing Page Project 2 - Business Website Project 3 - Portfolio Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in HTML, CSS, & Javascript Coding at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Coding with HTML, CSS, and JavaScript Training is ideal for the following: Anyone who wants to learn more about creating digital content Anyone interested in learning how to build websites Anyone who deals with online and digital content. Web developers and designers. Update for JavaScript programmers. Requirements No prior background or expertise is required. Career path You can explore popular and in-demand careers associated with this Coding with HTML, CSS, and JavaScript Training course after completing it. Some job fields you can look into are: Software Engineer & Developer Web Developer Full Stack Developer Java Script Developer Front End Developer Front End Engineer Explore each of the roles available and how you can start your career. Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in HTML, CSS, & Javascript Coding at QLS Level 4 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in HTML, CSS, & Javascript Coding at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

A career in Admin, Secretarial & PA can take you to places you never imagined! Successful personal assistants live a luxurious lifestyle that includes international travel and glamorous engagements. Take the first step towards a rewarding career as an Admin, Secretarial & PA by enrolling in our Level 7 QLS-endorsed Admin, Secretarial & PA course. This Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! The field of administration, secretarial, and personal assistant services is wide open for confident candidates with outgoing personalities and a keen eye for detail. Those who succeed in this field will have a fantastic long-term career. This Admin, Secretarial & PA course is designed by experts to give you a complete idea and provide you with all of the necessary knowledge for the related sector. Completing this Admin, Secretarial & PA course will help you advance your career. You will have all the knowledge and skills required to succeed in the field. Success as an Admin, Secretarial & PA is as much about personal qualities and character as it is about hard skills. If you consider yourself a responsible, hardworking individual with excellent time management skills, you are already ahead of the competition. Complete this Admin, secretarial & PA course to be one step closer to transforming your dreams into a rewarding reality. Enrol right now! Learning Outcome of this Admin, Secretarial & PA Course Gain professional time management and prioritisation skills Acquire advanced organisational skills Improved written and verbal communication skills Learn how to handle sensitive matters with discretion Improve accuracy and attention to detail Have self-confidence and general motivation The ability to remain calm under pressure Discover detailed knowledge of all key secretarial functions Tips for starting a career in Admin, Secretarial & PA Why Prefer This Admin, Secretarial & PA at QLS Level 7 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Admin, Secretarial & PA at QLS Level 7 course: Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language and Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 exams. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Admin, Secretarial & PA course will be beneficial to people of all backgrounds. It is especially ideal for those who want to pursue a career in the relevant fields or wants to switch career. Requirements No prior background or expertise is required. Career path After completing this Admin, Secretarial & PA course, you will have the knowledge and skills to pursue many occupations in the relative fields, such as; Office Administrator Executive Admin Personal Assistant Personal Executive Assistant Receptionist Secretary Support Secretary DE Clerk Office Manager An annual salary ranging from £28,000 to £55,000 in the UK. Certificates Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Admin, Secretarial & PA at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

Description Discover your imagination with all these step-by-step watercolor methods, and develop your artistic talents! We're going to concentrate on

Women in Healthcare Leadership Workshop Our Aims For This Workshop: Become clear about your leadership style and philosophy. Understanding how to navigate yourself and your team in a VUCA environment. How to communicate with presence and impact. Topic 1 Foundations For Effective Leadership Develop your leadership story – (know yourself) Your values, influences and leadership philosophy Clear vision and purpose as a leader Adapting style to suit the context Topic 2 Leading Through Rapid Change (Uncertainty) Exploring the VUCA environment (Volatile, Uncertain, Complex, Ambiguous) Understanding the psychological process of change Resilience and stress management Topic 3 Communication Skills For Influential Leaders How to prepare to be present so you have a presence Explore and understand your own innate communication style Importance of voice, pace, trust, and rapport THE FACILITATOR Ruth Sangale Ruth has 20 years HR and OD experience in the public and private sectors, leaving the NHS in 2012 to set up her own business “Enjoy Work” and specialise in Creative Leadership development and executive coaching. She works internationally coaching and running residential leadership programs for global organisations such as UNICEF, WHO, UN Women, and PLAN International and charitable NGOs in a range of countries including, Afghanistan, Brazil, India, Kenya, and Belize. In the UK she designs and delivers workshops for mostly the NHS, on topics such as career development, resilience and positive psychology, feedback skills, coaching skills for leaders and team development. She is an ICF-accredited coach and has an M Sc in Innovation, Creativity and Leadership. In her work she uses creative tools such as drama, visualization, drawing, mindfulness and storytelling to stimulate creative thinking and develop leadership capability. She has two daughters and in her free time loves hiking, climbing mountains and salsa dancing. THE PANEL Sam Foster - Chief Nursing Officer - Oxford University Teaching Hospitals Sam joined the Board of Oxford University Hospitals NHSFT in September 2017 as an experienced Chief Nurse who previously worked at the Heart of England NHS Foundation Trust where she held the role of Chief Nurse for four years. Sam has also worked in a number of Trusts in clinical, operational and educational roles. Sam's portfolio includes the professional leadership and education of over 5,000 Nurses, Midwives and AHPs. In addition to the Executive leadership of the Trust Facilities and PFI Services, she is accountable for the Estates and delivery of the capital program. Sam leads the Urgent Care program across the Oxfordshire system. Avey Bhatia - Chief Nursing Officer - Guys & St Thomas’ NHS Trust Avey Bhatia is Chief Nurse at Guy’s and St Thomas’ Trust. Avey returned to the Trust as Chief Nurse in November 2020, having trained as a critical care nurse at St Thomas’ in the early part of her career. Avey qualified in 1991 and her clinical experience includes theatres, general intensive care, coronary care and cardiothoracic nursing. She held various staff nurse and sister posts at hospitals in London before becoming Chief Nurse and Director of Infection Prevention and Control at St George's University Hospitals NHS Foundation Trust in 2017.  Avey holds a postgraduate diploma in health services management and a Masters in Public Administration. She is also the Trust’s Director of Patient Experience, and the executive lead for adults’ and children’s safeguarding, and for infection, prevention and control. Beyond Guy’s and St Thomas’, Avey is Vice President for the Florence Nightingale Foundation and Honorary Vice President of The Nightingale Fellowship. She is a Trustee for the St John of Jerusalem Eye Hospital Group.  Caroline Alexander CBE - Group Chief Nurse - Barts NHS Trust Caroline graduated as a nurse in 1987 from Edinburgh University (BSc/RGN) and has an MSc in Nursing Studies from South Bank University (2001). From 1987 to 1993 she specialised in nursing older people in Edinburgh and then London at Guy’s Hospital as a ward sister. Caroline then worked for the Foundation of Nursing Studies for three years supporting nurses to use research in practice. In 1998 Caroline returned to the NHS and worked in Tower Hamlets in a range of roles within older people’s services. In 2005, Caroline took up her first Director post, as Director of Nursing and Therapies within Tower Hamlets PCT. With the clustering of PCTs in London in 2011, she took on the Director of Nursing and Quality within NHS East London and the City initially and then within NHS North East London when the clusters merged in 2012. until she joined NHS England as Regional Chief Nurse for London in April 2013. Caroline took up her current role of Chief Nurse for Barts Health in March 2016. Caroline was a 2008 Florence Nightingale Leadership Scholar and has been awarded Honorary Doctorates from City, University of London in 2017, Middlesex University in 2018 and University of East London in 2021. She is a Trustee of the Foundation of Nursing Studies. In 2020 she was made a CBE in the Queen’s Birthday Honours. Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in health care and wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centered group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code? 

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step