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

6599 Writing courses

PTLLS - Level 3 Award in Education and Training (RQF)

4.9(27)

By Apex Learning

Fully Online No Obligation for Attending Classes Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Everyone who remembers his own education remembers teachers, not methods and techniques. The teacher is the heart of the educational system. Education is our passport to the future, for tomorrow belongs to the people who prepare for it today. A recent study showed there is widespread concern about the shortage of teachers in the UK. In some regions and some subject areas or phases, finding & retaining appropriately qualified teaching staff is a major challenge for school leaders. But you don't need to worry as our AET: Level 3 Award in Education and Training AET (Formerly PTTLS) is just the perfect opportunity for you to get into the teaching profession. If you're aiming to become a person who educates students for a better future while securing a stable & successful career, then this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) online programme will help you achieve your goals. At the beginning of the AET: Level 3 Award in Education and Training AET (Formerly PTTLS) course, you'll be familiarised with the roles & responsibilities of a teacher also, Learn everything about classroom management and how to assess and provide effective feedback. Why is this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) is Perfect for You? Change Your Career: Join today and make a life-changing decision, get all the essential knowledge to transform your career. Advance Your Career: With our Regulated qualifications, you can move up to the next level in your organisation with expertise. Upgrade Your Skills: Add value to your current educational profile and gain the skill sets to compete in your job role. Enhance Your Credibility: The AET (former PTLLS) course is Ofqual, UK Govt. Regulated and Awarded by Focus which adds value to your educational profile. 20 Additional Courses: With a single payment, you will get access to AET (former PTLLS) along with 20 Additional courses. 100% Money-Back Guarantee: We are confident about our course quality and want to provide the best service to our invaluable learners. That's why we provide a 14-day Unconditional Full Money-Back Guarantee with this course to ensure a hassle-free purchase. What other courses are included with this AET: Level 3 Award in Education & Training AET (former PTLLS) Course?: With this AET: Level 3 Award in Education & Training AET (former PTLLS) Course, learners will get the 20 Premium courses absolutely FREE. Course 01: Education Management Course 02: Educational Psychology and Development Course 03: Advanced Teaching Assistant Diploma Course 04: Special Education Needs (SEN) Training - Level 2 Course 05: EYFS Teaching - Level 3 Course 06: Phonics Teaching Diploma Level 3 Course 07: Leadership in Teaching Course 08: Lesson Planning for Teaching Course 09: Remote Teaching Online Course 10: Classroom Behaviour Management Course 11: Performance Management Course 12: Office Skills and Administration Management Diploma Course 13: Report Writing Course 14: Domestic Violence and Abuse Awareness - Level 2 Course 15: Child Neglect Awareness Certificate Course Course 16: Level 3 Mental Health and Adolescent Course Course 17: Safeguarding Children Level 3 Course 18: Functional Skills English Practice Level 2 Course 19: Train the Trainer Course 20: Leadership & Management Diploma Enrol in this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Course to become certified at a nationally acceptable level. Benefits you will gain from this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Course: Buy 1 Get 20 Personal Development Courses absolutely FREE Premium quality, intensive e-learning course materials Find a well-defined website for learning 24/7 teacher assistance Step-by-step guidelines Budget-friendly price Earned recognition from the UK's top awarding bodies Study in a user-friendly, advanced student portal Convenient and Flexible time limit AET: Level 3 Award in Education and Training AET (Formerly PTTLS) The Level 3 Award in Education and Training - AET (Formerly PTTLS) course is comprised of three mandatory units. These are as follows: Understanding roles, responsibilities and relationships in education and training Understanding and using inclusive training and learning approaches in education and training Understanding assessment in education and training What skills will I gain from this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Course? Understand the underlying fundamentals of teaching and learning Make a practical approach to session planning Explore the various approaches to learning Determine the students' desires and long-term goals Implement strategies for assessing your students' potential You will become an expert in education and training You will gain knowledge in teacher expectations & attributions and much more... AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Qualification Purpose Achieving the Level 3 will award in education and training will enable the professionals to have the necessary knowledge and skills to prepare, plan, deliver and evaluate teaching and training sessions in a wide variety of teaching or training settings. AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Total Qualification Time It is an estimate of the total amount of time anticipated that a learner would spend to demonstrate mastery of all learning outcomes to achieve the award of the qualification. The whole qualification time is defined as GLH and an estimate of the time a learner will devote to preparation, study, and assessment. It does not underlie supervision by a lecturer, supervisor, or tutor. In the case of qualification, the credit value is defined by TQT, and one credit corresponds to ten hours of learning. Total Qualification Time for this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) qualification is 120 hours. The total credit value for this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) qualification is 12 AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Guided Learning Hours These hours comprise all real-time contact time, hours of lectures or tutorials or supervision of a learner, tutor, trainer or other education providers. GLH for this qualification is of this AET: Level 3 Award in Education and Training AET (Formerly PTTLS): 48 AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Method of Assessment: AET Unit 1: In Unit 1, you need to complete a variety of writing assignments AET Unit 2: In Unit 2, there should be an assessment taken in the workplace, primarily evaluating learners' work, professional discussions with audio-video evidence AET Unit 5: In Unit 5, you will be demonstrated through your delivered work items and audio-video evidence after evaluating learners in a training context. AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Video Assessment You have to plan many things, such as observation, questioning/ professional discussion, and inspection of supporting work product evidence. Detailed assignment instructions will be made available to you in the 'Guidance for Achieving the Unit' section of your learning portal with a careful and clear explanation. You have to submit all your assignments via the online portal Certification of AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Successful candidates will be awarded a AET: Level 3 Award in Education and Training AET (Formerly PTTLS) from Focus Awards. Progression of AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Level 4 Certificate in Education and Training Level 5 Diploma in Education and Training Level 3 Award in Understanding the Principles and Practices of Assessment Level 3 Award in Assessing Competence in the Work Environment Level 3 Award in Assessing Vocational Related Achievement Level 3 Certificate in Assessing Vocational Achievement Level 4 Award in Understanding the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice Level 4 Certificate in Leading the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in Learning and Development Level 4 Diploma in Learning and Development AET AET AET AET AET AET AET AET AET AET AET AET AET AET AET Who is this course for? AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student Requirements AET: Level 3 Award in Education and Training AET (Formerly PTTLS) This AET: Level 3 Award in Education and Training AET (Formerly PTTLS)course does not have any specific entry requirements for students. However, You must be at least 19 years old or above to register and undergo an initial assessment. Since it is a level 3 qualification, you must pass the minimum 1st level of the literacy assessment. Career path AET: Level 3 Award in Education and Training AET (Formerly PTTLS) You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student

PTLLS - Level 3 Award in Education and Training (RQF)
Delivered Online On Demand
£339

Conflict Resolution Training

By The Teachers Training

Overview News Writing: Journalism 101 Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this News Writing: Journalism 101 Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training: Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Understanding Conflict and How it Begins Understanding Conflict and How it Begins 00:07:00 Module 02: Dealing with Emotions and Decisions During Conflict Dealing with Emotions and Decisions During Conflict 00:07:00 Module 03: Standing Back and Reaching Better Outcomes Standing Back and Reaching Better Outcomes 00:08:00 Module 04: Effective Conflict Resolution Methods Effective Conflict Resolution Methods 00:08:00 Module 05: What to Look for in Mediation What to Look for in Mediation 00:09:00 Module 06: Aftermath of a Conflict Aftermath of a Conflict 00:07:00

Conflict Resolution Training
Delivered Online On Demand46 minutes
£27.99

Teaching Assistant, Remote teaching and Phonics Teaching

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Teaching Assistant, Remote teaching and Phonics Teaching 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 37 course mega bundle that will exceed your expectations within your budget. This Teaching Assistant, Remote teaching and Phonics Teaching Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Teaching Assistant Diploma Course 2: The Complete Guide To Getting A Teaching Job Course 3: SEND Teaching Assistant Course 4: EYFS Teaching Assistant Course 5: Phonics Teaching Certificate Course 6: Remote Teaching Course 7: Lesson Planning for Teaching Course 8: Learning Disability Nursing Course 9: Nursery Nurse Course 10: Mental Health Teaching Assistant Course 11: ADHD Awareness Course 12: Leadership in Teaching Course 13: Positive Handling in Schools Course 14: Learning to Learn - Super Learning Course 15: Educational Psychology Course 16: Education Management Course 17: Education and Pedagogy Course 18: Blended Learning Course for Teachers Course 19: Understanding Autism Level 3 Course 20: Health and Safety Training for School Administrators Course 21: Child Language Disorder (CLD) Course 22: Child Playwork Course 23: Child Neglect Awareness & Protection Course 24: Communication Skills Course 25: Team Management Course 26: Problem Solving Skills Course 27: Leadership Skills Course 28: Presentation Skills Course 29: Microsoft Office Course 30: Cross-Cultural Awareness Training 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome 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 Teaching Assistant, Remote teaching and Phonics Teaching 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 370 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 Teaching Assistant, Remote teaching and Phonics Teaching 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 Teaching Assistant, Remote teaching and Phonics Teaching 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.

Teaching Assistant, Remote teaching and Phonics Teaching
Delivered Online On Demand8 days
£370

Essentials in UX and HCD Management (CPUX-M)

By Bunnyfoot

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Essentials in UX and HCD Management (CPUX-M)
Delivered OnlineFlexible Dates
£895

PA, Office Skills & Administration Diploma (Online) - QLS Endorsed

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever dreamed of becoming the backbone of a successful organisation? Administrative professionals are crucial to 98% of UK businesses, with over 2.5 million employed across various industries. If you're looking for a rewarding and versatile career path, this PA, Office Skills & Administration bundle is your perfect starting point. Our meticulously crafted bundle aims to teach you about Admin, Secretarial & PA, and Office Administration & Skills, ensuring you are equipped with the highest level of administrative knowledge. Additionally, specialised courses in Hospitality Management for Receptionists, Effective Minute-Taking, and Meeting Management will refine your skills in specific, crucial areas of corporate administration. These courses share essential theoretical knowledge providing you with a robust skillset that meets the demands of modern businesses. This Executive PA, Office Skills & Administration Bundle Contains 5 of Our Premium Courses for One Discounted Price: Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Course 02: Advanced Diploma in Office Administration & Skills at QLS Level 7 Course 03: Hospitality Management for Receptionist Course 04: Effective Minute-Taking Training Course 05: Meeting Management Learning Outcomes of PA, Office Skills & Administration Confidently handle scheduling, filing, correspondence, and more. Organise and manage effective meetings that achieve goals. Provide exceptional support to executives and teams. Understand and navigate compliance regulations in your field. Capture key information accurately and concisely. Build strong relationships and collaborate effectively. Advance your career by mastering the art of administration with our comprehensive training bundle. Whether you aim to climb the corporate ladder, enhance your current job performance, or secure a prestigious new position, our courses offer the expertise you need. Don't miss the opportunity to stand out in the job market. Enrol today and transform your professional future! Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course 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: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 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 Course 02: Advanced Diploma in Office Administration & Skills at QLS Level 7 Module 01: Introduction to Office Administration Module 02: Skills of an Effective Administrator Module 03: Business Etiquette Module 04: Business Telephone Skills Module 05: Representing Your Boss and Company Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Organising Meetings and Conferences Module 09: Time Management Module 10: Record Keeping and Filing Systems Module 11: Business Writing Skills Module 12: Organisational Skills Module 13: Communication Skills Module 14: Customer Service Module 15: Effective Planning and Scheduling Module 16: Invoicing Petty Cash Course 03: Office Admin and Receptionist Skills Module 01: Introduction To Reception And Receptionist Module 02: Business Telephone Skills Module 03: Representing Your Boss And Company Module 04: Mail Services And Shipping Module 05: Travel Arrangements Module 06: Organising Meeting And Conferences Module 07: Time Management Module 08: Record Keeping And Filing Systems Module 09: Business Writing Skills Module 10 :Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning And Scheduling Module 14: Invoicing/Petty Cash Module 15: Business Environment Module 16: Advanced MS Excel =========>>>>> And 2 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*5 = £65) CPD Hard Copy Certificate: Free (For The Title Course: Previously it was £29.99) CPD 240 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 Executive PAs Office Administrators Receptionists Secretarial Staff Career Changers Office Managers Note: This PA, Office Skills & Administration Bundle is not a regulated course. To qualify, you may choose any of the following: Level 1 Certificate in Business Administration Level 2 Certificate - Business Administration Level 2 Certificate in Principles of Business Administration (RQF) Level 2 Certificate in Principles of Business Administration (VRQ) Level 2 Certificate in Principles of Business and Administration (RQF) Level 3 Certificate in Principles of Business (RQF) Administration BTEC Business Level 2 Diploma in Business Administration Level 4 Diploma in Business Administration Level 6 Diploma in Business Administration Level 2 Diploma in Business Administration (RQF) Requirements You will not need any prior background or expertise to enrol on this PA, Office Skills & Administration Diploma Course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Personal Assistant - £35,000 Office Manager - £30,000 Senior Administrator - £28,000 Receptionist Team Leader - £25,000 Meeting and Events Coordinator - £24,000 Administrative Assistant - £22,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 - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - £129 Please note that International students have to pay an additional £10 as a shipment fee.

PA, Office Skills & Administration Diploma (Online) - QLS Endorsed
Delivered Online On Demand25 hours
£35

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

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

Microsoft Excel Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550

Microsoft Excel Macros & VBA - classroom

By Microsoft Office Training

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

Microsoft Excel Macros & VBA - classroom
Delivered In-Person in LondonFlexible Dates
£550

Research in Adult Care

4.8(9)

By Skill Up

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

Research in Adult Care
Delivered Online On Demand1 hour 42 minutes
£25

Construction Engineering: Cost Estimation, Legislation & Construction Safety

4.9(27)

By Apex Learning

Overview Construction engineering brings together technical skills, safety measures, and cost management to turn projects into reality. Our Construction Engineering: Cost Estimation, Legislation & Construction Safety Bundle is designed to provide you with the expertise you need to excel in this field. With courses focused on cost estimation, construction management, legislation, and safety, you’ll build a strong understanding of key areas such as building surveying, quantity surveying, property law and industry safety standards. This bundle includes a variety of premium courses, such as diplomas in Construction Management, Quantity Surveying, and Building Surveying. You’ll also learn how to use cost estimation tools like RSMeans and Xactimate, gain knowledge of LEED and WELL Building Standards, and explore topics like Construction Safety, Fire Safety, and Emergency First Aid. You’ll also improve your professional development, CV writing, and job interview skills with extra career-focused courses to help you stand out. Our Construction Engineering: Cost Estimation, Legislation & Construction Safety Bundle consists of the following premium courses: Course 01: Read Construction & Structural Drawing Like Expert Course 02: Diploma in Construction Management Course 03: Quantity Surveyor Diploma Course 04: Building Surveyor Course 05: Land Surveying Course 06: Bricklaying Course 07: Construction Cost Estimation Diploma Course 08: Construction Estimation using RSMeans Course 09: Construction Cost Estimation Using Xactimate Course 10: Cost Estimation for Multiplex Building Using Xactimate Course 11: Property Law and Legislation Course 12: Construction Industry Scheme (CIS) Course 13: WELL Building Standard Course 14: LEED V4: Building Design and Construction Course 15: LEED Green Associate Course 16: Architectural Studies Course 17: AutoCAD Programming using C# with Windows Forms Course 18: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 19: Autocad Electrical Design Course 20: Rendering AutoCAD Drawings in Photoshop Course 21: Solidworks Foundation Training Course 22: Interior Design Professional Diploma Course 23: Professional Interior Design & Construction Course 24: Construction Safety Course 25: Fire Safety | Online Course Course 26: Emergency First Aid and Incident Management at Work Course 27: RIDDOR Training Course 28: LOLER Training Course 29: COSHH Training and Safety - Level 2 Course 30: DSEAR Training Moreover, this Construction Engineering: Cost Estimation, Legislation & Construction Safety bundles include 10 career-focused courses: 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 Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. Certificate: PDF Certificate: Free for all 40 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) So don't overthink! Enroll Construction Engineering: Cost Estimation, Legislation & Construction Safety today. Certificates Certificate of completion: Digital certificate - Included Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Read Construction & Structural Drawing Like Expert) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for anyone looking to start or grow a career in construction. It’s perfect for future construction managers, quantity surveyors, building surveyors, and those interested in cost estimation, safety, and construction law. If you want to build your skills in the construction industry, this course is for you. Requirements The Construction Engineering: Cost Estimation, Legislation & Construction Safety courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path Completing this course can open up a variety of career opportunities in the construction industry: Construction Administrator – £22,000 to £30,000 Quantity Surveyor – £30,000 to £45,000 Building Surveyor – £35,000 to £50,000 Cost Estimator – £35,000 to £55,000 Construction Manager – £40,000 to £60,000 Health & Safety Officer – £30,000 to £45,000 Project Manager – £45,000 to £65,000 Senior Construction Manager – £55,000 to £80,000 Construction Director – £70,000 to £100,000+

Construction Engineering: Cost Estimation, Legislation & Construction Safety
Delivered Online On Demand1 hour
£150

OpenGL and GLSL Fundamentals with C++ (practical course)

By Packt

Master the OpenGL and GLSL shading language - by writing code! Illustrated theory and practice (from basics to advanced)

OpenGL and GLSL Fundamentals with C++ (practical course)
Delivered Online On Demand2 hours 22 minutes
£22.99