With this workplace safety training, ensure your workplace wellness in the quickest possible time and make your workstation a better place. This workplace safety training program is a comprehensive guide for learning the essential topics thoroughly and gaining the necessary skills at a very affordable price. This Award in Workplace Safety at QLS Level 2 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 60 CPD points) to make your skill development and career progression related to Workplace Safety substantial and easier than ever! Approximately 141 million working days are lost in the UK each year due to accidents, injuries, and illness at the workplace. Regardless of industry or sector, employers and managers must ensure a safe working environment that is free of hazards at all times. In the workplace safety training, you will learn what challenges and how to identify risks to safety in the working environment and the legal responsibilities of both employers and employees. This workplace safety training course is ideal for managers who are responsible for training staff to ensure they are working in compliance with UK laws. This comprehensive workplace safety training program includes case studies and audio-visual guidance, taking you through all areas of health and safety compliance in the workplace. It covers HSE guidelines, safety planning, key legislation, hazard analysis, common injuries, illnesses, and accidents, how to report incidents, and implementing an effective management system for your organisation. After completion of this workplace safety training, you will be able to: Gain an in-depth understanding of the workplace safety and health regulations enforced by OSHA and HSE Learn the key principles of The Occupational Health and Safety Act of 1970 Understand the legal requirements of both employers and employees in ensuring safety Now how to record illness and injuries, identify hazards and protect employees who report violations Identify the common accidents, injuries, and illnesses that can challenge Ensure workplace safety environment at all times by implementing an effective safety management system Understand the steps to effective safety planning and know what plan should include Take steps to become an expert health & safety officer with this accredited proficiency. Start your learning journey straight away with this workplace safety training and take a step toward a brighter future! Why Prefer This Workplace Safety Training? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another certificate that is accredited by CPDQS. 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. Skills You Will Gain Compliance with UK workplace safety and accident investigations laws Competency Workplace Safety planning Hazard analysis Risk mitigation *** Course Curriculum *** Here is the curriculum breakdown of workplace safety training: Module One: An Overview Module Two: Types of Hazards Module Three: Managers Role Module Four: Workplace Safety Training Module Five: Stress Management Module Six: Workplace Violence Module Seven: Identifying Your Company Hazards Module Eight: Drug & Alcohol Abuse Module Nine: Writing the Workplace Safety Plan Module Ten: Implement the workplace safety Plan 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 Award in Workplace Safety at QLS Level 2 exams. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about this subject should take this course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements You will not need any prior background or expertise. All you need to take this course is - A smart device. A secure internet connection. Being over the age of 16. And a strong drive for learning and literacy. Certificates Certificate Accredited by CPDQS Digital certificate - £10 Award in Workplace Safety at QLS Level 2 Hard copy certificate - £59 Show off Your New Skills with a Certificate of Completion After successfully completing the Award in Workplace Safety at QLS Level 2 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 59 GBP inside the UK 69 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS Upon finishing the course, you will receive a CPD accredited certificate that is recognised all over the UK and also internationally. The pricing schemes are - 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)
Do you want to understand the fundamental elements of health and safety management system? Do you want to figure out how to Develop and Implement an Effective H&S Management System that Will Protect People and Work Environment? If yes, then join now and build a management system that increases the safety and effectiveness of your organisation. Description: Health and Safety are composed endeavours and procedures for recognising work environment hazards and reducing accidents and exposure to unsafe circumstances and substances. It additionally incorporates preparing of faculty in accident prevention, accident reaction, crisis readiness, and utilisation of protective clothing and equipment. By the end of this course, students will gain learning of work environment well-being and security prerequisites and master risk management and will build up the abilities to end up plainly a fire and crisis superintendent in the workplace. It also gives proficient advancement chances to those officially utilised as chiefs to meet their authoritative commitments as people responsible for a position of work. Who is the course for? Managers, supervisors, and staff from various types of organisations who need a broad understanding of health and safety issues. Students and business professionals who are interested in knowing more about the field of health and safety. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Level 2 Certificate in Health and Safety is a useful qualification to possess, and would be beneficial for the following professionals Health and Safety Advisor. Health and Safety Consultant. Health & Safety Executive. Health & Safety Regulator. Level 2 Certificate in Health and Safety - Updated Version Module 01 : Health and Safety at Work and the Laws 00:23:00 Module 02 : Managing for Health and Safety 00:31:00 Module 03 : Risk Assessment and Common Risks 00:21:00 Module 04 : Workplace Health, Safety and Welfare 00:19:00 Module 05 : Accidents and Ill Health at Work 00:17:00 Module 06 : Electrical, Fire and Gas Safety 00:25:00 Module 07 : Safety in Different Work Settings 00:21:00 Module 08 : Work Equipment Hazards and Risk Control 00:22:00 Module 09 : Other Health and Safety Hazards at Work 00:23:00 Level 2 Certificate in Health and Safety - Old Version Health and Safety Introduction 01:00:00 Health and Safety Related Accidents and ill-health 00:30:00 Health and Safety in The workplace 00:30:00 Workplace Hazards 01:00:00 Managing health and safety in Workplace 01:00:00 Legal Responsibilities and Requirements 00:30:00 RIDDOR - Reporting of accidents and incidents 00:30:00 Conclusion 00:15:00 Developing a Safety Manual Setting the Stage 00:15:00 Safety Procedures Basics 00:15:00 Flowcharting 00:30:00 Gathering Information 00:30:00 Procedure Writing 00:15:00 Honing the Draft Procedure 00:30:00 Some Other Methods 00:15:00 Workplace Safety General fire safety 00:30:00 Work at height 01:00:00 Building work 01:00:00 Machinery safety 01:00:00 Lifting and handling 01:00:00 Noise, Vibration 01:00:00 Electricity 01:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 2 Certificate in Health and Safety 00:30:00 Final Exam Final Exam- Level 2 Certificate in Health and Safety 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Acquiring knowledge about Building Surveying can lead to success in the UK, where the building sector is seeing rapid growth. Building surveyors are in more demand as a result of a 15% increase in construction projects and a 20% increase in building refurbishments across the country. With an average annual salary of £40,000, learning building surveying not only opens doors for a rewarding career but also for personal and professional development. Don't pass up the opportunity to contribute to this thriving sector and create a secure and lucrative future for yourself. Enrol in our Building Surveying Diploma course NOW! Key Features: CPD QS Certified Building Surveying Diploma course Free Certificate Developed by Specialist Lifetime Access Why Choose Our Course? By choosing our Building Surveying Diploma course is a smart investment in your professional future. Our Building Surveying Diploma course is designed by industry professionals to stay ahead of trends, offering the most current and relevant content. This Building Surveying Diploma course provides you with the tools and knowledge needed to excel in today's competitive landscape. With flexible learning options and a commitment to your success, our Building Surveying Diploma course is the key to unlocking your potential and advancing your professional journey. Course Curriculum Building Surveying Diploma - CPD Certified Course Module 01: Introduction to Building Surveying Module 02: Principles of Building Law Module 03: Building Procurement and Contract Management Module 04: Building Information Modeling (BIM) Module 05: Building Technology Fundamentals Module 06: Process of Building Survey and Historic Building Surveys Module 07: Initial Survey Phase: Foundation Inspection and In-Depth Wall Surveys Module 08: Ground Level Investigation: Flooring and Elevated Inspection: Roofs and Chimneys Module 09: Examination of Joinery and Woodwork Module 10: Finishing and Surface Analysis of Buildings Module 11: Inspection of Building Services Module 12: Building Pathology Exploration Module 13: Building Adaptation Techniques Module 14: Understanding Work Breakdown Structure (WBS) Module 15: Techniques for Effective Report Writing Module 16: Legal Considerations in Building Surveying Learning Outcomes: Building Surveying Diploma - CPD Certified Course Analyse building structures applying principles of building law and procurement. Implement Building Information Modeling (BIM) for effective construction management. Demonstrate expertise in historic building surveys and building pathology exploration. Conduct comprehensive inspections, including foundation, roofing, and joinery examinations. Apply building technology fundamentals for effective building adaptation techniques. Develop skills in legal considerations and produce concise, effective survey reports. Certification After completing this Building Surveying Diploma - CPD Certified course, you will get a free Certificate.. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? This Building Surveying Diplomacourse is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Building Surveying. Moreover, this course is ideal for: Professionals in construction and Building Surveying Individuals aspiring to enhance skills in Building Surveying Architects can enroll this Building Surveying Course. engineers can enroll this Building Surveying Course. project managers interested in construction law and management. Building surveyors and technicians can enroll this Building Surveying Course. Those pursuing expertise in historic building surveying and adaptation techniques. Requirements There are no requirements needed to enrol into this Building Surveying Diplomacourse. We welcome individuals from all backgrounds and levels of experience to enrol into this Building Surveying Diploma course. Career path After finishing this Building Surveying course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Building Surveying are Building Information Modeler - £20K to £40K/year Historic Building Consultant - £35K to £50K/year Building Surveyor - £30K to £50K/year Construction Manager - £35K to £60K/year Building Control Surveyor - £35K to £55K/year Certificates Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Overview With this Advanced Diploma in Copywriting, you may jumpstart a dynamic career in producing words that inspire engagement and grow businesses. Just the expert techniques you need to create attractive, unique content that takes readers in and produces results-no complexity.Imagine your words sparking advertisements and websites, attracting viewers, and propelling brands to new levels. With the help of this course, you will be able to use SEO and gripping storytelling to produce 'eye-catching' content that turns clicks into revenue. It's not just about grammar; it's also about developing interpersonal abilities and becoming the copywriter that every company wants.Are you prepared to 'Gain the ability to write anything'? Enrol now to develop your copywriting skills. How will I get my certificate? Upon successful completion of the Advanced Diploma in Copywriting course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is this course for? There is no experience or previous qualifications required for enrolment in this Advanced Diploma in Copywriting. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in Copywriting course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. Career path Having this qualification will enhance your CV and open you up to multiple sectors, such as : Copywriter: £25k - £50k per year Content Strategist: £30k - £60k per year Brand Copy Specialist: £35k - £70k per year Digital Marketing Copywriter: £40k - £80k per year Creative Director: £45k - £90k+ per year Note: Salaries vary based on experience, location, and industry. Course Curriculum 2 sections • 15 lectures • 07:11:00 total length •Module 1: Introduction to Copywriting: 00:14:00 •Module 2: Basics of Copywriting: 00:35:00 •Module 3: Eye-Catching Headlines: 00:28:00 •Module 4: Attention-Grabbing Advertisements: 00:29:00 •Module 5: Essential Copywriting Skills: 01:07:00 •Module 6: Online Copywriting: 00:42:00 •Module 7: Press Related Copywriting: 00:34:00 •Module 8: Print Media Copywriting: 00:33:00 •Module 9: Copywriting for Mainstream Media: 00:16:00 •Module 10: Copywriting for Other Media: 00:25:00 •Module 11: How to Write Better Copy: 00:25:00 •Module 12: Making an Impact with Creative Copy: 00:28:00 •Module 13: So You Want to be a Copywriter?: 00:27:00 •Module 14: Final Tips: 00:23:00 •Assignment - Advanced Diploma in Copywriting: 00:05:00
***Transform Yourself: From Beginner to Legal Secretary in One Course*** Did you know according to a recent report, the demand for Legal Secretaries is expected to grow by 5% in the next few years? This essential role provides the foundation for a successful legal career. If you're looking to step into the exciting world of law, this legal course comprehensive course equips you with the knowledge and skills to thrive as a Legal Secretary. This Legal Secretary - Legal Office Administration and Support course is designed to provide a theoretical grounding in all the key areas a Legal Secretary needs to excel. Through a series of engaging modules, you'll gain a thorough understanding of English Law, legal terminology, and essential secretarial practices. Learning Outcomes By the end of this Legal Secretary - Legal Office Administration and Support course, you will be able to: Gain a thorough understanding of the legal secretary's role and responsibilities within a legal practice. Develop a strong foundation in English Law and the legal systems that govern the UK. Master the fundamentals of contract law, tort law, wills & probate, property law, criminal law, and family law. Hone your skills in professional writing, document creation, proofreading, and editing. Learn effective meeting management, minute-taking techniques, and data management practices. Develop a comprehensive understanding of human rights and their application in legal contexts. Key Highlights for Legal Secretary - Legal Office Administration and Support Course: CPD QS Accredited Proficiency with this Legal Secretary course. After successfully completing the Legal Secretary course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Legal Secretary course. The online test with immediate results You can study and complete the Legal Secretary course at your own pace. Study for the Legal Secretary course using any internet-connected device, such as a computer, tablet, or mobile device. This Legal Secretary - Legal Office Administration and Support course is your gateway to a fulfilling career as a Legal Secretary. Throughout the course, you'll delve into various legal areas, including contract law, tort law, wills & probate, property law, criminal law, family law, and business law. You'll gain insights into the legal systems within the UK and explore the intricacies of legal documents. The Legal Secretary course also emphasizes the importance of communication, interpersonal skills, and organization, all essential for success as a Legal Secretary. Furthermore, you'll develop proficiency in document proofreading, editing, and minute-taking, ensuring accuracy and efficiency in your daily tasks. The Legal secretary course also covers essential secretarial skills like data management, record-keeping, and meeting management, equipping you to provide exceptional support to lawyers and legal teams. Curriculum Breakdown of the Legal Secretary - Legal Office Administration and Support Course Module 01: Introduction to Legal Secretary Module 02: English Law & Legal Systems Module 03: Law of Contract & Law of Tort Module 04: Wills, Probate, Estate Law Module 05: Property Law & Conveyancing Practice Module 06: Criminal Law Module 07: Understanding Criminal Psychology Module 08: Contract & Business Law Module 09: Family Law and Insurance Practice Module 10: Conflict and Conflict Resolution Module 11: Professional Writings and Documents Module 12: Document Proofreading and Editing Module 13: Meeting Management & Minute Taking Module 14: Data Management and Record-Keeping Module 15: Other Essential Skills for Secretarial Role Module 16: Human Rights CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Legal Secretary - Legal Office Administration and Support course is suitable for: Individuals with an interest in a career in law. Those seeking to become a Legal Secretary. Professionals looking to enhance their legal knowledge and secretarial skills. Graduates seeking entry-level positions in the legal sector. Career changers interested in transitioning into the legal field. Anyone who wants to gain a foundational understanding of the legal system. Requirements There are no specific prerequisites for this Legal Secretary - Legal Office Administration and Support However, a basic understanding of legal terminology and strong written communication skills will be beneficial. Career path This Legal Secretary - Legal Office Administration and Support course provides a strong foundation for a fulfilling career as : Paralegal Legal Assistant Solicitor (with further qualifications) Legal Compliance Officer Legal Consultant Legal Case Manager ***Enroll today and take the first step towards becoming a successful Legal Secretary!*** Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each
Overview This comprehensive course on Treating Post Traumatic Stress Disorder will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Treating Post Traumatic Stress Disorder comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Treating Post Traumatic Stress Disorder. It is available to all students, of all academic backgrounds. Requirements Our Treating Post Traumatic Stress Disorder is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 57 lectures • 04:23:00 total length •Introduction: 00:04:00 •The approach of the course: 00:03:00 •Section Overview: 00:01:00 •What Is Trauma?: 00:09:00 •What Is PTSD? Diagnosis of PTSD: 00:10:00 •How Are Traumatic Memories Processed?: 00:09:00 •Physical and Health Issues Associated with Trauma: 00:08:00 •Thinking about Coping with PTSD & Trauma: 00:06:00 •Integrating CBT, DBT, ACT Overview: 00:01:00 •What is Cognitive Behavioral Therapy (CBT)?: 00:03:00 •ABC Model - Thought, Emotions & Behavior: 00:04:00 •Understanding Feedback Loops: 00:04:00 •Behavioral Coping: 00:02:00 •Exposure Therapy for PTSD & Trauma: 00:07:00 •Stress Inoculation Training (SIT) for PTSD & Trauma: 00:03:00 •Cognitive Processing Therapy (CPT) PTSD & Trauma: 00:03:00 •What is Dialectical Behavior Therapy (DBT)?: 00:08:00 •What is Acceptance and Commitment Therapy (ACT)?: 00:03:00 •ACT in Action! 6 Core Processes: 00:12:00 •Common Elements of CBT, DBT & ACT: 00:05:00 •Building a Strong Foundation: Breathing: 00:06:00 •Abdominal Breathing for Anxiety: 00:05:00 •PMR Progressive Muscle Relaxation a CBT Technique for Anxiety & PTSD: 00:07:00 •Relaxation without Tension a CBT Technique for Anxiety & PTSD: 00:02:00 •Cue Controlled Relaxation a CBT Technique for Anxiety & PTSD: 00:02:00 •Using Your Mind to Relax and Develop Awareness: 00:03:00 •Decreasing the Power of Negative Thoughts: 00:06:00 •Section Conclusion: 00:03:00 •Section Introduction: 00:02:00 •Self-help: Effects of PTSD on Goals and Values: 00:15:00 •Self-help: Creating a Change: 00:10:00 •Self-help: Facing Feared Situation: 00:10:00 •Self-help: Everyday Mindfulness Exercise: 00:05:00 •Self-help: Connecting with Others: 00:10:00 •Self-help: Emotion Diary Cards: 00:05:00 •Self-help: Identifying Emotions: 00:05:00 •Decreasing PTSD Symptoms through Writing: 00:05:00 •8 Limited Thinking Patterns from CBT: 00:01:00 •Filtering: 00:02:00 •Polarized Thinking: 00:02:00 •Overgeneralization: 00:02:00 •Mind Reading: 00:02:00 •Catastrophizing: 00:01:00 •Magnifying: 00:02:00 •Personalization: 00:01:00 •Shoulds: 00:02:00 •Composing Balanced Alternative Thoughts: 00:08:00 •Focusing on Your Thoughts: 00:07:00 •Invalidating Thoughts: 00:06:00 •Mindfulness and Grounding: 00:05:00 •Imagery Rehearsal for Nightmares: 00:02:00 •Developing Wise Mind: 00:04:00 •Do You Need Professional Help?: 00:04:00 •Do You Need Therapist?: 00:04:00 •Conclusion: 00:02:00 •Resource - Treating Post Traumatic Stress Disorder: 00:00:00 •Assignment - Treating Post Traumatic Stress Disorder: 00:00:00
Overview This comprehensive course on Office Admin and Reception will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Admin and Reception comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Office Admin and Reception. It is available to all students, of all academic backgrounds. Requirements Our Office Admin and Reception is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00