Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. Career path Career path Microsoft Office 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
Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office 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
This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing
Course Overview The Canine First Aid and CPR Course provides essential knowledge and skills to respond to emergencies involving dogs. It covers a range of critical topics, including first aid, CPR, and basic health assessments. This course is designed to empower learners with the confidence to act decisively in a variety of canine emergency situations, enhancing the safety and well-being of pets. Upon completion, learners will gain the ability to handle common canine injuries and medical emergencies, ensuring pets receive the care they need in times of distress. Course Description This course dives deep into key areas of canine health and emergency response. Learners will explore pet first aid, including injury management and common health issues, along with essential CPR techniques for dogs. The course also covers important aspects of pet business practices, giving those interested in the pet care industry a well-rounded understanding. With an engaging and thorough curriculum, learners will develop the skills required to provide immediate assistance to dogs in need, preparing them for any situation that may arise. The course is designed for all levels of learners, from beginners to professionals seeking to expand their knowledge in pet care. Course Modules: Module 01: Pet First Aid Key first aid procedures for dogs Identifying and treating common injuries Basic wound care and infection prevention Module 02: Pet CPR Techniques for canine CPR Recognising signs of cardiac arrest in dogs Step-by-step guide to performing CPR Module 03: Pet Business Essential business practices for pet care professionals Overview of pet care industry trends Marketing and client management for pet businesses (See full curriculum) Who is this course for? Individuals seeking to improve their dog care knowledge. Professionals aiming to expand their skill set in the pet care industry. Beginners with an interest in pet health and emergency care. Pet owners looking to become more confident in handling canine emergencies. Career Path Pet Care Professional Canine Health Advisor Dog Trainer or Behaviourist Veterinary Assistant Pet Business Owner
Course Overview This Sexual Harassment Awareness Training is designed to equip individuals with the knowledge and skills to recognise, address, and prevent sexual harassment in the workplace. Covering key concepts, legal frameworks, and organisational responsibilities, the course provides essential insights into maintaining a respectful and safe work environment. Participants will gain a thorough understanding of what constitutes sexual harassment, how to identify it, and how to manage such situations effectively. By completing this course, learners will be better prepared to contribute to a respectful and legally compliant workplace culture. Course Description This course delves into various aspects of sexual harassment, from definitions to workplace implications, and legal frameworks. It covers the different forms of harassment, employee rights, and employer obligations. Learners will explore how to effectively address and prevent incidents of harassment, ensuring worker protection through robust policies and procedures. The course also covers the process of dealing with incidents, including mediation and the aftermath, helping individuals recognise the importance of fostering a safe, respectful work environment. Upon completion, learners will have the skills to proactively contribute to creating a harassment-free workplace. Course Modules Module 01: What is Sexual Harassment? Module 02: Sexual Harassment in the Workplace Module 03: The Law and Sexual Harassment Module 04: Addressing Sexual Harassment Module 05: Worker Protection Module 06: Prevent Sexual Harassment at Work Module 07: Policies and Procedures Module 08: How to Deal with Sexual Harassment in the Workplace? Module 09: Mediation and the Aftermath (See full curriculum) Who is this course for? Individuals seeking to understand workplace dynamics and employee rights. Professionals aiming to enhance their knowledge of workplace law and ethical practices. Beginners with an interest in workplace relations and human resources. Any other individual interested in fostering a respectful workplace environment. Career Path HR Manager Equality and Diversity Officer Workplace Health and Safety Specialist Legal Advisor (Employment Law) Corporate Trainer or Consultant
Presentation Skills Course Overview This course on Presentation Skills is designed to help learners develop the confidence and techniques necessary to deliver engaging and effective presentations. It covers key aspects of presentation delivery, from understanding audience psychology to mastering various engagement techniques. Learners will be guided on how to structure content, use humour, and create a safe, welcoming environment for their audience. By the end of the course, participants will be equipped with the skills to deliver presentations that are not only informative but also captivating and memorable. Course Description Throughout this course, learners will explore the essential principles behind effective presentation techniques. The content includes creating a sense of security for the audience, fostering a positive atmosphere, and using humour to enhance engagement. Learners will also delve into methods of connecting with different audience types, ensuring their message is both clear and compelling. The course will include modules that focus on both verbal and non-verbal communication, giving learners the ability to present confidently in any setting. By the end of this course, participants will be prepared to present with impact, regardless of their experience level. Presentation Skills Curriculum Module 01: Introduction to Archetype Module 02: Make Your Audience Feel Safe Module 03: Make Your Audience Feel Good Module 04: Make Your Audience Laugh Module 05: Course Wrap Up (See full curriculum) Who is this course for? Individuals seeking to improve their public speaking skills. Professionals aiming to enhance their communication and presentation abilities. Beginners with an interest in presentation techniques. Anyone looking to build confidence when presenting to groups. Career Path Public Speaking Coach Corporate Trainer Event Speaker Communications Specialist Marketing and Sales Presentations
Ladder Safety Course Overview This course on "Ladder Safety" provides learners with essential knowledge and skills to ensure the safe use of ladders in various environments. It covers critical topics such as ladder classifications, risk assessments, pre-use safety checks, and the correct procedures for setting up and using ladders safely. Designed for both beginners and those looking to refresh their knowledge, the course aims to reduce the risks associated with ladder usage and promote safety in the workplace. By the end of the course, learners will be equipped to identify potential hazards, conduct safety inspections, and implement effective safety measures when using ladders. Course Description The "Ladder Safety" course explores key aspects of ladder use, focusing on ensuring safety in various work environments. Learners will delve into ladder classifications, pre-use safety inspections, and risk assessments to identify hazards. The course covers setting up ladders correctly, ensuring proper placement, and securing them to prevent accidents. Throughout the course, learners will gain an understanding of safe ladder usage techniques and the importance of conducting thorough risk assessments. The course provides an engaging learning experience that equips participants with the knowledge to make informed decisions about ladder safety and compliance with workplace regulations. Ladder Safety Curriculum Module 01: Introduction to Ladder Safety Module 02: Ladder Classifications and Uses Module 03: Pre-use Safety Inspections and Risk Assessment Module 04: Setting Up and Safe Use of Ladders Module 05: Placement Considerations and Securing a Ladder (See full curriculum) Who is this course for? Individuals seeking to enhance workplace safety Professionals aiming to improve their knowledge of health and safety regulations Beginners with an interest in workplace safety and risk management Anyone working in environments where ladder use is required Career Path Health and Safety Officer Construction Site Manager Facilities Management Professional Risk Assessment Specialist Safety Trainer in Various Industries
Martial Arts First Aid Course Course Overview The Martial Arts First Aid Course provides essential knowledge and skills to manage medical situations in martial arts environments. It equips learners with the necessary tools to assess and respond to both minor and major injuries effectively. The course is designed for anyone involved in martial arts, from instructors to enthusiasts, ensuring they can provide first aid with confidence and accuracy. Learners will gain an understanding of emergency procedures, common injuries, and the best approaches to safeguarding participants in martial arts settings. Course Description This course covers a range of crucial first aid topics, including the proper methods for initial assessment, CPR, managing common injuries, and handling major medical emergencies. Learners will gain a comprehensive understanding of martial arts-related injuries and how to manage them, from bruises and sprains to life-threatening conditions. The course also focuses on injury prevention strategies and the precautions needed to ensure safety during training. By completing this course, learners will be well-equipped to respond to emergency situations in a martial arts environment, supporting both immediate care and long-term recovery. Martial Arts First Aid Course Curriculum Module 01: Introduction to Martial Arts First Aid Module 02: Initial Assessment Module 03: CPR & Recovery Position Module 04: Common Injuries Module 05: Major Injuries Module 06: Medical Emergencies Module 07: Injury Prevention Module 08: Things to Keep in Mind (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of first aid in martial arts. Professionals aiming to improve safety measures in martial arts training. Beginners with an interest in martial arts and emergency response. Coaches and instructors wishing to ensure a safer environment for their students. Career Path Martial Arts Instructor First Aid Trainer Sports Therapist Safety Coordinator in Sports Emergency Medical Responder
Career Development and Passion Course Overview This course is designed to help individuals navigate their career development while staying true to their passions. It covers key aspects of career growth, self-improvement, and the strategic pursuit of personal interests to build a fulfilling professional life. Learners will explore how to harness their passion to fuel career success, develop essential skills, and adopt a positive mindset for achieving long-term professional goals. Upon completion, learners will be equipped to enhance their career trajectory, align their passion with their work, and achieve greater job satisfaction. Course Description In this course, learners will delve into various stages of career development, focusing on self-improvement, identifying and chasing one's passion, and mastering the mindset required for success. Topics such as aligning passion with career choices, improving skills, and navigating job hunting will be covered in-depth. Learners will gain insights into how passion can be a driving force behind career success and how to monetise skills and interests effectively. By mastering these topics, participants will be well-prepared to achieve personal and professional fulfilment in their chosen career path. Career Development and Passion Curriculum Module 01: Career Module 02: Self-Improvement Module 03: Passion Module 04: Chase the Passion Module 05: Be Good at Your Passion Module 06: Passion and Money Module 07: Master Your Mindset Module 08: Preparation for Success Module 09: Job Hunting Module 10: Acing Your Interview Module 11: Prosper in Career (See full curriculum) Who is this course for? Individuals seeking to align their career with their passion. Professionals aiming to enhance career growth and job satisfaction. Beginners with an interest in career development and personal growth. Anyone looking to improve their job hunting and interview skills. Career Path Career development coach HR specialist Business consultant Entrepreneur in passion-driven industries Motivational speaker or trainer Corporate strategist Freelance professional
"Self Care" - A Key To Happiness Course Overview: "Self Care: A Key To Happiness" is a comprehensive course designed to provide learners with essential strategies and techniques to improve their well-being and mental health. Focusing on the importance of self-care in maintaining happiness, this course equips participants with practical tools to manage stress, set boundaries, and enhance their emotional resilience. It explores various self-care practices, including mindfulness, relaxation techniques, and the significance of a balanced lifestyle. By the end of the course, learners will gain the ability to integrate self-care into their daily routines, leading to increased overall happiness, productivity, and life satisfaction. Course Description: This course delves deeper into the concept of self-care, exploring the connection between mental and physical health. Participants will learn effective methods for self-awareness, stress management, and emotional well-being. Key topics include mindfulness practices, relaxation exercises, understanding emotional triggers, and cultivating a positive mindset. The course also examines the role of nutrition, sleep, and exercise in maintaining a balanced and happy life. Learners will be guided on how to create personalised self-care plans tailored to their unique needs, ensuring long-term success. Upon completion, students will have gained valuable skills in self-regulation, resilience-building, and sustainable happiness. "Self Care" - A Key To Happiness Curriculum: Module 01: About this Course Module 02: Full Course Module 03: Next Steps Module 04: Extra Content for YOU (See full curriculum) Who is this course for? Individuals seeking to enhance their well-being and happiness Professionals aiming to improve their stress management and mental resilience Beginners with an interest in mental health and self-care Those seeking balance and mindfulness in their daily lives Career Path Mental Health Support Worker Wellness Coach Health and Well-being Consultant Personal Development Trainer Employee Wellness Program Manager