11240 Guide courses

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Overview This comprehensive course on Office Assistant and Secretarial Diploma will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Assistant and Secretarial Diploma comes with accredited certification, 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 Assistant and Secretarial Diploma. It is available to all students, of all academic backgrounds. Requirements Our Office Assistant and Secretarial Diploma 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 36 lectures • 08:46:00 total length •Module One - Getting Started: 00:05:00 •Module Two - Working with Your Manager: 00:15:00 •Module Three - Administrative Soft Skills: 00:15:00 •Module Four - Effective Time Management: 00:20:00 •Module Five - Meeting Management: 00:17:00 •Module Six - Tools of the Trade (I): 00:17:00 •Module Seven - Tools of the Trade (II): 00:15:00 •Module Eight - Being an Effective Gatekeeper: 00:15:00 •Module Nine - Organizational Skills: 00:15:00 •Module Ten - Confidentiality Guidelines: 00:15:00 •Module Eleven - Special Tasks: 00:15:00 •Module Twelve - Wrapping Up: 00:05:00 •Module One - Getting Started: 00:05:00 •Module Two - Why Your Office Needs Administrative Procedures: 00:15:00 •Module Three - Gathering the Right Tools: 00:10:00 •Module Four - Identifying Procedures to Include: 00:15:00 •Module Five - Top Five Procedures to Record: 00:15:00 •Module Six - What to Include in Your Binder (I): 00:15:00 •Module Seven - What to Include in Your Binder (II): 00:15:00 •Module Eight - Organizing Your Binder: 00:15:00 •Module Nine - What Not to Include in the Procedure Guide: 00:15:00 •Module Ten - Share Office Procedure Guide: 00:10:00 •Module Eleven - Successfully Executing the Guide: 00:12:00 •Module Twelve - Wrapping Up: 00:05:00 •Module One - Getting Started: 00:10:00 •Module Two - Verbal Communication Skills: 00:20:00 •Module Three - Non-Verbal Communication Skills: 00:20:00 •Module Four - Making Small Talk and Moving Beyond: 00:20:00 •Module Five - Moving the Conversation Along: 00:25:00 •Module Six - Remembering Names: 00:15:00 •Module Seven - Influencing Skills: 00:20:00 •Module Eight - Bringing People to Your Side: 00:15:00 •Module Nine - Sharing Your Opinion: 00:15:00 •Module Ten - Negotiation Basics: 00:30:00 •Module Eleven - Making an Impact: 00:15:00 •Module Twelve - Wrapping Up: 00:05:00

A transformative coaching session in Wiltshire to help you grow your business, presented by Scaling Up coaches Dominic Monkhouse and Philip Rose.

Cognitive Behavioural Therapy (CBT) and REBT Diploma Unlock your mind's potential with Cognitive Behavioural Therapy (CBT). Address common conditions and phobias with our combined CBT and REBT Diploma. Elevate your therapeutic practice through cutting-edge CBT techniques. Learning Outcomes: Master key Cognitive Behavioural Therapy (CBT) techniques. Apply CBT to manage common psychological conditions. Navigate the Cognitive Behavioural Therapy (CBT) guide proficiently. Understand the fundamentals of REBT. Utilize REBT to treat phobias effectively. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Cognitive Behavioural Therapy (CBT) and REBT Diploma: Cognitive Behavioral Therapy (CBT) Techniques: Acquire and implement advanced Cognitive Behavioural Therapy (CBT) techniques in diverse therapeutic settings. CBT in Common Conditions: Explore the applicability and effectiveness of CBT for treating common psychological conditions. CBT Guide: Become adept at utilising the Cognitive Behavioural Therapy (CBT) guide for patient diagnosis and treatment planning. About REBT: Gain a comprehensive understanding of the Rational Emotive Behavior Therapy (REBT) framework. REBT in Nutshell: Grasp the essential tenets of REBT for efficient implementation in therapeutic contexts. REBT-for-Phobia: Develop specialised REBT approaches for treating phobias, amplifying your toolkit in Cognitive Behavioural Therapy (CBT).

Feed your curiosity and navigate the captivating world of crime investigation with our eight-course bundle. Break away from the shackles of ordinary knowledge and equip yourself with expertise that goes beyond the conventional! Unearth the fascinating realms of Endorsed Criminology, Forensic Science, and Criminal Psychology with our QLS-endorsed 3-course bundle. Dive into the complex world of crime, not just as an observer, but as a knowledgeable participant. This meticulously crafted curriculum explores the profound depths of criminal minds, revealing patterns, deciphering motives, and learning to navigate the winding roads of criminal law. Specially curated, our bundle includes three prime QLS-endorsed courses - Criminology, Forensic Science Level 3, and Criminal Psychology - Interrogation Techniques. Upon completion, you will be awarded hardcopy certificates, tangible tokens of your mastered knowledge. Key Features of the QLS Endorsed Criminology, Forensic Science and Criminal Psychology - 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our QLS Endorsed Criminology, Forensic Science and Criminal Psychology - 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Criminology QLS Course 02: Forensic Science Level 3 Course QLS Course 03: Criminal psychology - Interrogation Techniques 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Criminal Law Course 02: Criminal Investigation Course 03: Crime Scene Investigator Course 04: Accident investigation Course 05: Security Management Diploma In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our QLS Endorsed Criminology, Forensic Science and Criminal Psychology - 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Comprehensive understanding of the principles of Criminology, Forensic Science, and Criminal Psychology. Mastery of the latest techniques used in crime scene investigations. Detailed knowledge of criminal law and the skills needed for criminal investigations. Proficiency in accident investigation techniques and security management principles. Adeptness at interpreting and understanding the psychology behind criminal behaviors. Competence in using forensic science in practical criminal investigation scenarios. Proficiency in applying interrogation techniques derived from criminal psychology. Embark on a journey through the labyrinth of criminal minds with our eight-course bundle. Our QLS-endorsed courses in Criminology, Forensic Science, and Criminal Psychology guide you through the theoretical framework of crime investigation. Gain in-depth knowledge of forensic science and criminal law while simultaneously mastering the interrogation techniques used by professionals. Additionally, our CPD QS accredited courses supplement your learning, providing a comprehensive view of the crime investigation field. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in exploring the theoretical depths of criminology, forensic science, and criminal psychology. Law enforcement officers looking to enhance their knowledge base. Professionals in the field of security management seeking advanced training. Students studying criminal law or psychology who wish to specialize in criminal investigation. Career path Criminologist - Average salary in the UK: £35,000 - £39,000 per year. Forensic Scientist - Average salary in the UK: £35,000 - £40,000 per year. Criminal Psychologist - Average salary in the UK: £31,700 - £44,500 per year. Crime Scene Investigator - Average salary in the UK: £20,000 - £30,000 per year. Accident Investigator - Average salary in the UK: £25,000 - £35,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

***24 Hour Limited Time Flash Sale*** LOLER, PUWER & Construction Safety Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Introducing our premium bundle, "LOLER, PUWER & Construction Safety", your theoretical guide to a safer, more efficient construction site! Within this compilation, you'll find three QLS-endorsed courses focusing on LOLER Training, PUWER, and Construction Safety. These courses will expand your knowledge of the essential legal requirements in operating lifting equipment, the use of work equipment, and the critical safety protocols in construction. Each of these QLS-endorsed courses comes with a hardcopy certificate upon completion, a physical testament to your dedication. Additionally, enhance your learning journey with our five CPD QS accredited courses. Learn about Building Quantity Surveying, Construction Site Management, the Construction Industry Scheme (CIS), LEED V4.1 - Building Design and Construction, and the WELL Building Standard. A comprehensive grasp of these subjects will enable you to navigate the construction industry with confidence. Key Features of the LOLER, PUWER & Construction Safety Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our LOLER, PUWER & Construction Safety bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: LOLER Training QLS Course 02: PUWER QLS Course 03: Construction Safety 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Building Quantity Surveyor Course 02: Construction Site Management Course 03: Construction Industry Scheme (CIS) Course 04: LEED V4.1 - Building Design and Construction Course 05: WELL Building Standard In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our LOLER, PUWER & Construction Safety courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the legal requirements under LOLER and PUWER regulations. Gain knowledge about safety practices in the construction industry. Learn about the intricacies of Building Quantity Surveying. Understand the role and responsibilities in Construction Site Management. Familiarise with the Construction Industry Scheme (CIS). Understand the principles of LEED V4.1 - Building Design and Construction. Gain insight into the WELL Building Standard and its benefits. The "LOLER, PUWER & Construction Safety" bundle is a comprehensive collection of courses designed to build your theoretical understanding of key construction safety regulations and best practices. The three QLS-endorsed courses provide essential insights into LOLER, PUWER, and Construction Safety, serving as the pillars of your learning journey. Supplementing this foundational knowledge are five CPD QS accredited courses, each focusing on a crucial aspect of construction. From understanding the complexities of Building Quantity Surveying and Construction Site Management to getting a grip on the Construction Industry Scheme (CIS), the bundle also covers sustainable building practices through LEED V4.1 and the WELL Building Standard. With this bundle, equip yourself with the theoretical knowledge to improve your understanding of safety and efficiency in construction. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in the theoretical aspects of LOLER, PUWER, and Construction Safety. Aspiring professionals in the construction industry looking to enhance their knowledge base. Existing professionals wishing to gain an understanding of construction site management. Anyone interested in sustainable building practices and building quantity surveying. Career path Building Quantity Surveyor: Estimating costs and ensuring budget compliance (£30,000 - £60,000 per annum). Health and Safety Officer: Implementing safety standards as per LOLER and PUWER regulations (£25,000 - £50,000 per annum). Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Unlock your creative potential with our exclusive Writing Course Bundle. Immerse yourself in the art of storytelling, persuasive copywriting, and captivating scriptwriting. This comprehensive bundle includes not just one, but eight thought-provoking courses that will empower you to master the art of the written word. What sets this bundle apart is its exceptional quality. You'll gain access to three QLS-endorsed courses that carry the weight of recognized accreditation. Completing these courses grants you not only valuable knowledge but also a prestigious hardcopy certificate, a testament to your commitment and achievement. In addition to the QLS-endorsed courses, you'll receive five CPD QS-accredited courses that delve deep into the realm of creative writing. From crafting engaging short stories to composing your very own novel, our comprehensive curriculum covers every aspect of the writing process. Gain the expertise and skills needed to thrive in the world of writing, all at your own pace and convenience. Key Features of the Writing (Screenwriting, Scriptwriting, Copywriting & Creative Writing) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Writing (Screenwriting, Scriptwriting, Copywriting & Creative Writing) bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Screenwriting & Scriptwriting QLS Course 02: Copywriting Level 5 Diploma QLS Course 03: Creative Writing Training 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Certificate in Freelance Writing Course 02: Creative Writing : Start Writing Your Own Stories Course 03: Creative Writing Course - Novel Course 04: Content Management Course 05: Creative Writing Course - Short Stories In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Writing (Screenwriting, Scriptwriting, Copywriting & Creative Writing) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Master the art of screenwriting, scriptwriting, copywriting, and creative writing. Develop a deep understanding of storytelling techniques and narrative structure. Enhance your ability to craft compelling characters and captivating dialogue. Acquire advanced writing techniques for different mediums and genres. Gain proficiency in persuasive copywriting to engage and persuade audiences. Learn to create and manage content effectively for various platforms. Explore the world of freelance writing and discover avenues for professional growth. Ignite your creativity and transform your writing prowess with our exclusive Writing Course Bundle. This comprehensive package combines three QLS-endorsed courses and five CPD QS-accredited courses, covering the essential aspects of screenwriting, scriptwriting, copywriting, and creative writing. Whether you aspire to become a professional writer or simply want to enhance your writing skills, this bundle offers a wealth of knowledge and expertise to guide you on your writing journey. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring writers looking to master the art of storytelling Individuals seeking to enhance their writing skills and creativity Professionals aiming to excel in persuasive copywriting Anyone with a passion for crafting engaging narratives Career path Screenwriter: £25,000 - £70,000 per year Copywriter: £20,000 - £50,000 per year Content Manager: £25,000 - £50,000 per year Freelance Writer: Earnings vary based on projects and clients Novelist: £10,000 - £100,000+ per year (depending on success) Short Story Writer: Varies based on publications and submissions Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

With a sharp focus on the scientific arena, our bundle, "Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed", amalgamates a range of meticulously designed courses that aim to cultivate a proficient understanding of lab procedures, chemical safety, and biochemistry. Two of these are QLS-endorsed, a marker of quality and relevancy in the learning field, and completion of these will earn you hardcopy certificates, tangible proof of your knowledge enhancement. An additional five courses, all CPD QS accredited, further expand the horizons of learning by including topics such as Microbiology, Basic Biology, and COSHH Training for Assessors, to name a few. These subjects are meticulously intertwined, providing comprehensive exposure to different facets of science and laboratory work. The bundle is meticulously tailored to cover different elements of the scientific sphere, ensuring the learner evolves with a robust and well-rounded understanding of the field. By completing this bundle, you enhance not only your knowledge base but also your employability with recognised qualifications. ey Features of the Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Laboratory Technician Level 7 QLS Course 02: Chemical Spill QLS Course 03: Biochemistry 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Microbiology Course 02: Basic Biology Course 03: Level 3 Diploma in Anatomy and Physiology of Human Body Course 04: Infection Prevention Training Course 05: COSHH Training for Assessors In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Lab Technician, Chemical Spill & Biochemistry- QLS Endorsed courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Advanced understanding of laboratory operations and safety protocols. Deepened knowledge of chemical spill handling and prevention. Mastery of the principles of biochemistry. Proficient understanding of microbiological principles and techniques. Foundational knowledge in basic biology and its applications. Comprehensive grasp of human anatomy and physiology. Improved skills in infection prevention and COSHH assessment. This invigorating bundle serves as a comprehensive guide for those who aspire to elevate their competency in the field of laboratory work and biochemistry. Covering an expansive range of subjects, from the essence of human anatomy to the practicalities of infection prevention, it is a cornucopia of learning that promises a profound enhancement of your scientific understanding. Designed to equip learners with a formidable scientific knowledge base, this bundle is the ideal solution for those eager to excel in laboratory environments and biochemistry domains. It bridges the gap between theoretical understanding and practical application, seamlessly integrating different facets of science and lab work. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring lab technicians seeking comprehensive knowledge. Individuals interested in biochemistry and laboratory safety. Those aiming to enhance their skills in microbiology and basic biology. Professionals looking to broaden their knowledge in infection prevention and COSHH assessment. Career path Lab Technician: Average salary £21,000 - £27,000 annually in the UK. Biochemist: Average salary £31,000 - £44,000 annually in the UK. Microbiologist: Average salary £26,500 - £38,000 annually in the UK. Biology Teacher: Average salary £24,000 - £41,000 annually in the UK. Infection Control Nurse: Average salary £26,000 - £35,000 annually in the UK. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Learn database-driven web development with Django and Python

Master frontend web development using HTML, CSS, CSS Flexbox, CSS Grid, and JavaScript