3939 Office Skills courses

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. Lesson 1: Navigating SharePoint Sites Topic A: Launch SharePoint Topic B: Gain Access to a Site You Didn't Create Topic C: Navigate Within a SharePoint Site Topic D: Access SharePoint from Your Mobile Device Lesson 2: Using Lists to Track Information Topic A: Add and Populate Lists Topic B: Change View Options Topic C: Create a Custom View Lesson 3: Using Document Libraries to Share and Organize Documents Topic A: Store Files in a Document Library Topic B: Create and Use Document Templates Lesson 4: Finding, Sharing, and Archiving Content Topic A: Search for Items in Lists or Libraries Topic B: Share Through Links Topic C: Move Files Offline Lesson 5: Authoring Documents as a Team Topic A: Work Together on Documents Topic B: Manage File Versions and Document Recovery Lesson 6: Automating Business Processes Topic A: Use Rule-Based Automation Topic B: Use Power Automate to Automate a Workflow

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Tailored in company 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS 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

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Speech & Language Therapy Online Training 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 30 course Speech & Language Therapy mega bundle that will exceed your expectations within your budget. The Speech & Language Therapy Online Training related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory Speech & Language Therapy bundle. This comprehensive Speech & Language Therapy Online Training bundle will help you build a solid foundation to become a proficient worker in the sector. This Speech & Language Therapy Online Training Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Speech & Language Therapy Course 2: Learning Disability Nursing Training Course 3: Dyslexia Course 4: Autism Awareness Course 5: ADHD Awareness Course 6: Psychology and Child Intellectual Development Training Course 7: Play Therapy, Mental Health and Child Psychology Diploma Course 8: Childcare, Nutrition and Development Course 9: Audiology Course 10: British Sign Language (BSL) Course Course 11: Deaf Awareness Course 12: Special Education Needs (SEN) Teaching Methodologies Course 13: Educational Psychology and Development Course 14: Safeguarding Children and Adolescents Course 15: Residential Childcare & Cognitive Development Training Course 16: Child Safeguarding Course 17: Family Support Worker Course 18: Child Attachment Diploma Course 19: Parenting Skills: Raising Healthy Kids Course 20: Internet Safety: Safeguarding Children Course 21: Child Playwork Course 22: Mental Health Care - MCA & DOLS Course 23: Positive Mental Health Course 24: Parental Mental Health & Child Protection Course 25: Autism Awareness 5 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 Learning Outcome of Speech & Language Therapy This tailor-made Speech & Language Therapy Online Training bundle will allow you to- 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 Speech & Language Therapy Online Training 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. Course 1: Speech & Language Therapy Gain a deep understanding of speech and language disorders, their causes, and assessment techniques. Learn evidence-based therapeutic interventions and strategies to improve communication skills. Develop the skills to work effectively with individuals of all ages who have speech and language difficulties. Course 2: Learning Disability Nursing Training Acquire comprehensive knowledge of learning disabilities, including their causes and prevalence. Learn nursing strategies to provide person-centred care and support to individuals with learning disabilities. Understand the legal and ethical considerations involved in learning disability nursing. Course 3: Dyslexia Explore the characteristics and challenges associated with dyslexia. Learn about assessment tools and techniques for identifying dyslexia. Develop strategies and interventions to support individuals with dyslexia in educational and workplace settings. Course 4: Autism Awareness Gain a deep understanding of autism spectrum disorders and their diagnostic criteria. Learn about evidence-based interventions and therapies for individuals with autism. Develop skills to create inclusive environments and support individuals with autism effectively. Course 5: ADHD Awareness Understand the nature and symptoms of Attention Deficit Hyperactivity Disorder (ADHD). Learn strategies for assessing and managing ADHD in children and adults. Explore techniques to support individuals with ADHD in educational and social settings. Course 6: Psychology and Child Intellectual Development Training Study the principles of child psychology, including cognitive, emotional, and social development. Learn how psychological theories apply to understanding and promoting healthy child development. Explore techniques for assessing and supporting children's intellectual growth. Course 7: Play Therapy, Mental Health and Child Psychology Diploma Gain expertise in play therapy techniques and their application in child mental health. Learn about various therapeutic approaches and their effectiveness in child psychology. Develop counselling and assessment skills for working with children facing psychological challenges. Course 8: Childcare, Nutrition and Development Understand the nutritional needs of children at different stages of development. Learn about healthy meal planning and dietary guidelines for children. Gain knowledge of child development milestones and how nutrition impacts growth. Course 9: Audiology Explore the field of audiology, including hearing assessment and hearing aid technology. Learn about common hearing disorders and their diagnostic procedures. Develop skills in audiological rehabilitation and communication strategies for individuals with hearing loss. Course 10: British Sign Language (BSL) Course Acquire proficiency in British Sign Language, including vocabulary and grammar. Learn about Deaf culture and the importance of cultural sensitivity in communication. Develop the ability to hold conversations and provide information using BSL. Course 11: Deaf Awareness Understand the challenges and barriers faced by Deaf individuals in society. Learn effective communication strategies when interacting with Deaf or hard-of-hearing people. Gain insights into Deaf culture and the importance of inclusivity and accessibility. Course 12: Special Education Needs (SEN) Teaching Methodologies Explore teaching strategies and accommodations for students with special educational needs. Learn to create inclusive lesson plans and adapt curriculum content for diverse learners. Develop skills to collaborate with parents, caregivers, and educational specialists to support SEN students. Course 13: Educational Psychology and Development Study the principles of educational psychology, including theories of learning and motivation. Learn about cognitive development in children and its impact on education. Gain insights into the psychological factors that influence teaching and learning processes. Course 14: Safeguarding Children and Adolescents Understand the legal and ethical responsibilities of safeguarding children and adolescents. Learn to recognize signs of abuse and neglect and how to report concerns appropriately. Develop strategies for creating safe and supportive environments for young people. Course 15: Residential Childcare & Cognitive Development Training Gain an understanding of residential childcare settings and their role in child development. Learn about cognitive development stages and their implications for caregiving. Develop practical skills for providing quality care and support to children in residential settings. Course 16: Child Safeguarding Explore the principles of child safeguarding, including risk assessment and prevention. Learn about the roles and responsibilities of professionals in safeguarding children. Understand the legal frameworks and policies related to child protection. Course 17: Family Support Worker Learn about the role of family support workers in assisting families facing various challenges. Develop communication and counselling skills for working with diverse families. Gain insights into community resources and services available to support families. Course 18: Child Attachment Diploma Explore the theory of attachment and its significance in child development. Learn about attachment styles and how they influence relationships and behaviour. Develop skills to promote healthy attachments between caregivers and children. Course 19: Parenting Skills: Raising Healthy Kids Gain practical parenting strategies for promoting children's physical and emotional well-being. Learn effective discipline and communication techniques for positive parent-child relationships. Understand the importance of parental self-care and stress management in raising healthy kids. Course 20: Internet Safety: Safeguarding Children Learn about online risks and dangers that children may encounter on the internet. Explore strategies to educate children about online safety and responsible digital citizenship. Develop skills to protect children from online threats and create a safer online environment. Course 21: Child Playwork Understand the principles and theories of playwork in promoting children's development. Learn how to plan and create engaging play environments that encourage exploration and creativity. Develop skills to observe and assess children's play, ensuring their safety and well-being. Certification After studying the complete Speech & Language Therapy training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course for free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Course 22: Mental Health Care - MCA & DOLS Gain knowledge of the Mental Capacity Act (MCA) and Deprivation of Liberty Safeguards (DoLS) in mental health care. Learn about the legal and ethical implications of decision-making and consent for individuals lacking capacity. Develop the skills to apply MCA and DoLS principles to protect the rights and well-being of vulnerable individuals. Course 23: Positive Mental Health Explore the concepts of positive mental health and well-being. Learn strategies to promote mental resilience, stress management, and emotional well-being. Understand the importance of early intervention and support in maintaining positive mental health. Course 24: Parental Mental Health & Child Protection Gain insights into the impact of parental mental health on children's well-being and development. Learn about risk assessment and safeguarding measures for families affected by parental mental health issues. Develop skills to provide support and guidance to parents while ensuring child protection. Course 25: Autism Awareness Deepen your understanding of autism spectrum disorders and associated challenges. Learn person-centred approaches and effective communication strategies when working with individuals with autism. Explore methods for creating inclusive and supportive environments for individuals with autism. Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Speech & Language Therapy Online Training bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this Speech & Language Therapy course, all you need is - A smart device A secure internet connection And a keen interest in Speech & Language Therapy Online Training Career path Upon completing this essential Speech & Language Therapy Bundle, you will discover a new world of endless possibilities. These Speech & Language Therapy courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Looking for a career with great earning potential? Consider becoming a personal assistant. With an average salary of £25,155 per year, personal assistants in the UK have the potential to earn up to £45,000 with experience and advanced skills. To excel in this role, it's essential to have the right skills and training. That's where our Personal Assistant Training bundle comes in. This bundle features eleven relevant and CPD-QS accredited courses that cover everything from office administration and receptionist skills to leadership and negotiation. By completing this comprehensive training, you will gain the expertise and confidence needed to excel in any administrative role. In addition, the first course in this bundle is QLS-endorsed and comes with a hardcopy certificate upon completion. This Certification is highly respected in the industry and will add an extra layer of credibility to your success, helping you stand out from other job candidates. By completing this comprehensive training package, you will gain the knowledge and skills necessary to excel in any administrative role. You'll learn effective communication techniques, organisational strategies, and time management tips that will help you stay on top of even the most demanding workload. Don't miss out on the opportunity to increase your earning potential and advance your career as a personal assistant. Enrol in our Personal Assistant Training bundle today. This PA - Personal Assistant Training Bundle Package includes: Course 01: Diploma in Personal Assistant at QLS Level 5 10 Premium Additional CPD QS Accredited Courses - Course 01: Office Admin and Receptionist Skills Course 02: Executive and Personal Assistant Training Course Course 03: Minute Taking Course 04: Diploma in Meeting Management Course 05: Strategic Planning Process Course 06: Organisational Skills Course for Administrator Course 07: Leadership Skills Course Course 08: Negotiation Skills Certificate Course 09: The Secrets of Body Language Course 10: Document Control Why Prefer This PA - Personal Assistant Training Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this PA - Personal Assistant Training bundle courses, you will be able to learn: Master communication skills for effective workplace communication Develop advanced organisational skills to enhance productivity Understand the strategic planning process and how to implement it successfully Gain leadership skills to help manage teams effectively Learn negotiation techniques to achieve successful outcomes in any situation Develop essential minute-taking skills for successful meetings Learn document control and management techniques to maintain efficiency in the workplace ***Curriculum breakdown of PA *** Module 01: Introduction to Personal Assistant 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 How is the PA - Personal Assistant TrainingBundle 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 successfully pass the exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course bundle is ideal for: Individuals interested in pursuing a career as a personal assistant Office administrators looking to enhance their skills and knowledge Receptionists seeking to develop their communication and organisational skills Professionals looking to advance their careers in the administrative field Career path Junior Personal Assistant: £18,000 - £24,000 per year Personal Assistant: £24,000 - £32,000 per year Executive Assistant: £32,000 - £40,000 per year Senior Executive Assistant: £40,000 - £50,000 per year Office Manager: £25,000 - £45,000 per year Operations Manager: £35,000 - £60,000 per year Note: The salary range mentioned here can vary depending on industry and experience. Certificates CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Personal Assistant at QLS Level 5 Hard copy certificate - Included

Level 3 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user.  ✔ A complete course that covers all of Excel’s most advanced functions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

Microsoft Teams Microsoft Teams is a cooperation instrument intended to unite individuals, correspondence and substance in a solitary interface. This course is focused on any individual who needs to make and work with the Microsoft Teams application. You might be a Microsoft Team proprietor needed to make and deal with a Teams territory for partners, or somebody who will utilize Teams to work with associates What you Will Learn: Explore around the Microsoft Teams App Make a Microsoft Team Add and Manage Owners and Members Make Channels Set Team and Channel Options Utilize the Conversation Tools Organize Teams Meetings Add Content utilizing Apps

Microsoft Mail Merge Certificate Mail blend is one of Microsoft's most remarkable Office highlights, particularly for the individuals who work in workplaces or who manage mailings in their everyday lives. Without it, you need to type various names and postage information, gambling mistakes or different blunders. These kinds of mistakes may imply that your expected beneficiary never gets the record or correspondence. In a most dire outcome imaginable, it might even imply that a crucial message goes to some unacceptable customer, prompting secrecy issues. Figuring out how to utilize mail consolidate appropriately can save you a ton of time, while likewise ensuring you against accidental security breaks. This course expounds on the best way to utilize the most widely recognized and reasonable highlights of this important instrument, which is incorporated into all adaptations of Microsoft Office. We start by acquainting you with the overall things you need to realize while setting up a mailing list, including how to utilize Excel and Outlook contacts for your mail consolidate list. Then, we proceed onward to giving you a bit by bit direct on the best way to utilize mail converge for names and envelopes, just as applying it to further developed undertakings like mass messages or letters. You Will Learn: Instructions to utilize Excel to set up your mailing list Instructions to utilize the mail blend include for customized messages containing a similar fundamental substance What you need to remember when utilizing mail converge with Outlook The most effective method to make a mass letter with modified data for various customers Instructions to make mail combine one stride further Advantages of Taking this Course Figuring out how to utilize mail converge to abstain from copying your work or committing errors Seeing how to utilize mail converge for an assortment of valuable capacities, including marks, envelopes, letters and messages Why mail combine is a fundamental instrument that any individual who works in an office ought to learn Tips on the most ideal approach to begin incorporating a mailing rundown and which program is the least demanding one to utilize when doing this errand Figuring out how to profit by an underused instrument in a bit by bit way, making it simple to consolidate into your next mailing