10262 Office courses

The Level 2 Certificate in Event Planning covers various aspects of event planning, including types of events, brainstorming techniques, managing support staff, technical staff, and vendors, organizational skills, post-event activities, as well as an introduction to hospitality management and the hotel industry. Learning Outcomes: Gain an understanding of different types of events and their unique requirements. Develop effective brainstorming skills to generate creative event ideas. Learn how to manage support staff, technical staff, and vendors to ensure smooth event operations. Acquire organizational skills to plan and execute events efficiently. Understand the post-event activities required for evaluation and feedback. Gain an overview of hospitality management and its relevance to event planning. Explore the hotel industry, including front office operations, food and beverage management, customer satisfaction, and the impact of technology on hospitality. Why buy this Level 2 Certificate in Event Planning? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Level 2 Certificate in Event Planning 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 the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Level 2 Certificate in Event Planning does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Level 2 Certificate in Event Planning was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Level 2 Certificate in Event Planning is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Types of Events Types of Events 00:08:00 Module 02: Brainstorming Brainstorming 00:07:00 Module 03: Support Staff Support Staff 00:06:00 Module 04: Technical Staff Technical Staff 00:06:00 Module 05: Vendors Vendors 00:06:00 Module 06: Get Organized Get Organized 00:06:00 Module 07: Post Event Activities Post Event Activities 00:06:00 Module 08: Introduction to Hospitality Management Introduction to Hospitality Management 00:24:00 Module 09: An Overview of Hotel Industry An Overview of Hotel Industry 00:18:00 Module 10: Management of Front Office Operations Management of Front Office Operations 00:19:00 Module 11: Management of Food and Beverage Operations Management of Food and Beverage Operations 00:20:00 Module 12: Customer Satisfaction Customer Satisfaction 00:23:00 Module 13: E-Hospitality and Technology E-Hospitality and Technology 00:22:00

Overview This comprehensive course on Dental Assistant will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Dental Assistant 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 Dental Assistant. It is available to all students, of all academic backgrounds. Requirements Our Dental Assistant 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 10 sections • 10 lectures • 05:34:00 total length •Introduction to Dental Assisting: 00:45:00 •General Dentistry Instruments: 00:23:00 •Dental Office Management: 00:28:00 •Oral Diagnosis, Treatment Planning and Dental Terminology: 00:29:00 •General Handling and Safety of Dental Materials in the Dental Office: 01:01:00 •Infection Control and Instruments: 00:24:00 •Dental Radiology: 00:35:00 •Paediatric Dentistry: 00:47:00 •The Professional Dental Assistant: 00:23:00 •Standards of Dental Practice in the UK: 00:19:00

Overview This comprehensive course on Dental Nurse will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Dental Nurse 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 Dental Nurse. It is available to all students, of all academic backgrounds. Requirements Our Dental Nurse 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 10 sections • 10 lectures • 05:34:00 total length •Introduction to Dental Assisting: 00:45:00 •General Dentistry Instruments: 00:23:00 •Dental Office Management: 00:28:00 •Oral Diagnosis, Treatment Planning and Dental Terminology: 00:29:00 •General Handling and Safety of Dental Materials in the Dental Office: 01:01:00 •Infection Control and Instruments: 00:24:00 •Dental Radiology: 00:35:00 •Paediatric Dentistry: 00:47:00 •The Professional Dental Assistant: 00:23:00 •Standards of Dental Practice in the UK: 00:19:00

All in One Bundle Special Discount Offer Are you looking to enhance your Biochemist - CPD Accredited Course skills? If yes, then you have come to the right place. Our comprehensive courses on Biochemist - CPD Accredited Course will assist you in producing the best possible outcome by learning the Biochemist - CPD Accredited Course skills. CPD Accredited courses you will get: Course 01: Biochemistry Course 02: Time Management Skills Course 03: Office Skills The Biochemist - CPD Accredited Course bundle is for those who want to be successful. In the Biochemist - CPD Accredited Course bundle, you will learn the essential knowledge needed to become well versed in Biochemist - CPD Accredited Course . Our Biochemist - CPD Accredited Course bundle starts with the basics of Biochemist - CPD Accredited Course and gradually progresses towards advanced topics. Therefore, each lesson of this Biochemist - CPD Accredited Course is intuitive and easy to understand. Why would you choose the Biochemist - CPD Accredited Course course from Compliance Central: Lifetime access to Biochemist - CPD Accredited Course courses materials Full tutor support is available from Monday to Friday with the Biochemist - CPD Accredited Course course Learn Biochemist - CPD Accredited Course skills at your own pace from the comfort of your home Gain a complete understanding of Biochemist - CPD Accredited Course course Accessible, informative Biochemist - CPD Accredited Course learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Biochemist - CPD Accredited Course bundle Study Biochemist - CPD Accredited Course in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Biochemist - CPD Accredited Course Course Improve your chance of gaining in demand skills and better earning potential by completing the Biochemist - CPD Accredited Course Curriculum of Course 01: Biochemistry Module 01: Introduction to Biochemistry Module 02: Introduction to Cells Module 03: Organic Chemist Module 04: Biomolecules Module 05: Protein Module 06: Biomolecules of Nucleic Acids Module 07: Genetics Module 08: Metabolism Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Biochemist - CPD Accredited Course bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Biochemist - CPD Accredited Course . It is also great for professionals who are already working in Biochemist - CPD Accredited Course and want to get promoted at work. Requirements To enrol in this Biochemist - CPD Accredited Course course, all you need is a basic understanding of the English Language and an internet connection. Career path The Biochemist - CPD Accredited Course course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Biochemist - CPD Accredited Course. Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Get 3 CPD accredited PDF certificate for Free. Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Most of the standard white-collar jobs nowadays depend on the fastest skills and that most importantly includes the typing speed skill ranging from 35-200 words per minute. So, if you're facing problems with your typing speed and your job is highly dependent on that, we have the right solution for you in this Touch Typing Masterclass course. This Certificate in Touch Typing Masterclass course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 40 CPD points) to make your skill development & career progression more accessible than ever! Typing the wrong letters can be frustrating, especially when you're in a hurry. With the help of this touch typing course, you will be able to memorise the location of letters, numbers, and other characters on the keyboard. As a result, you will be able to type faster and more accurately. This touch typing course creates the ability for you to understand typing rules and how you should be placing your finger on the keyboard. Upon completing this touch typing course, you will develop the perception of proficiency in touch typing the alphabet, and how to type sentences of any length using signs, dash, and parenthesis. Moreover, you will be able to learn about keyboard shortcuts and many secrets for accelerating your typing speed. What will I learn from this Touching Typing Masterclass? Learn to touch-type in the most efficient way Correct placement of the hand on the keyboard How to type faster spelling accuracy Best way to practice capital letters Typing with all the fingers Typing without continuously referring to your keyboard This touch typing masterclass certificate will also help you to create an impression of self-reliance and dedication that will surely attract prospective employers to give priority to your job application. Enrol in this touch typing masterclass course today to open and build enchanting career opportunities ahead. Take a step toward a brighter future! Why Prefer this Touch Typing Masterclass Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate 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. *** Course Curriculum *** Here is the curriculum breakdown of this course: *** Touch Typing Masterclass - Updated Version *** Module 1: Introduction Module 2: How to Set up Your Computer Module 3: How to type the letters F and J Module 4: How to type the letters D and K Module 5: How to type the letters S and L Module 6: How to type the letter A and ; (semicolon) Module 7: How to type the letters E and I Module 8: How to type the letters R and U Module 9: How to type the letters T and O Module 10: How to type CAPITAL letters Module 11: How to type the letter C and, (Comma) Module 12: How to type the letters G and H Module 13: How to type the letters N and V Module 14: How to type the letters W and M Module 15: How to type the letters Q and P Module 16: How to type the letters B and Y Module 17: How to type the letters Z and X Module 18: How to type Colon and Semicolon Module 19: How to type Full Stop and Comma Module 20: How to type Question Mark and Exclamation Mark Module 21: How to type Dash, Parentheses and Quotation Marks *** Touch Typing Masterclass - Old Version *** Module 1: Getting Started Module 2: DRILL 1 the home keys Module 3: DRILL 2 e and i, g and h Module 4: DRILL 3 o and n, shift keys and t Module 5: DRILL 4 extra practice . and y Module 6: DRILL 5, and w Module 7: DRILL 6 m and u Module 8: DRILL 7 v and x Module 9: DRILL 8-sentence drills Module 10: DRILL 9 figures Module 11: DRILL 10 alphabetical paragraphs Module 12: Recap Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Certificate in Touch Typing Masterclass exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? In the present era, typing is an essential skill for anyone who sees themselves working with a computer. Besides, this touch typing masterclass course is preferable for students, programmers, content writers, bloggers, researchers, and data entry operators. The touch typing masterclass course doesn't require any academic background and is open to everyone. HOW TO USE RESOURCES: To use the resources, just download them and open them using a browser. You can use Google Chrome to open them, but Safari or any other browser can also be used. Just make sure to enable javascript in the browsers for the automatic correction/ highlights. Requirements You will not need any prior background or expertise to enrol in this course. Career path Enroling on this Touch Typing Masterclass can lead to the following career paths: Data Entry Operator Customer Service Executives Email Marketing Executives Personal Assistant Administrative Executive And many more office job roles requiring you to type fast! Certificates CPDQS Accredited Certificate Digital certificate - £10 Certificate in Touch Typing Masterclass at QLS Level 1 Hard copy certificate - £59 Show off Your New Skills with a Certification of Completion After successfully completing the Certificate in Touch Typing Masterclass at QLS Level 1, 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 CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Duration 5 Days 30 CPD hours This course is intended for The audience for this course includes enterprise-level messaging administrators on Exchange Server. IT generalists and helpdesk professionals who want to learn about Exchange Server may also take this course. Students taking this course are expected to have at least two years of experience working in the IT field-typically in the areas of Windows Server administration, network administration, helpdesk, or system administration. They are also expected to have some experience with Exchange Server concepts but previous experience managing Exchange Server is not a requirement. Overview After completing this course, students will be able to: Deploy Exchange Server. Plan and configure storage for Exchange Server. Create and manage various recipient objects in Exchange Server. Perform recipient management and Exchange server management tasks by using Exchange Server cmdlets. Deploy Client Access services in Exchange Server. Manage high availability in Exchange Server. Implement disaster recovery for Exchange Server. Configure and manage message transport in Exchange Server. Configure message security in Exchange Server. Monitor and troubleshoot Exchange Server. Configure Exchange Server role-based access control permissions and configure audit logging for both administrators and users. Implement and manage integration with Exchange Online. This course teaches IT professionals how to administer and support Exchange Server. The course covers how install and configure Exchange Server. It also covers how to manage mail recipients and public folders, including how to perform bulk operations by using Exchange Management Shell. In addition, the course covers how to manage client connectivity, message transport and hygiene, and highly available Exchange Server deployments. It also covers how to implement disaster recovery solutions. Finally, the course covers how to maintain and monitor an Exchange Server deployment and how to administer Exchange Online in a Office 365 deployment. Deploying Microsoft Exchange Server 2016 Overview of Exchange Server Exchange Server architecture Requirements for Exchange Server Deploying Exchange Server Exchange Server Exchange Server Management Tools Lab : Deploying Exchange Server Managing Exchange Server 2016 storage Exchange Server mailbox databases Exchange Server storage Configuring Exchange Server mailbox databases and storage Lab : Configuring Exchange Server storage Managing recipient objects Managing user mailboxes Managing other types of mailboxes Managing other recipients objects Configuring policies and address lists Lab : Managing recipient objects Lab : Configuring address lists and policies Managing recipients and Exchange servers by using Exchange Server cmdlets Overview of the Exchange Management Shell Managing Exchange Servers by using Exchange Management Shell cmdlets Managing Exchange servers by using scripts Lab : Managing Exchange Server and recipient objects by using Exchange Management Shell Implementing client connectivity Configuring client access services Managing client access services Client connectivity in Exchange Server Configuring Outlook on the web Configuring mobile messaging Lab : Configuring client access services Lab : Deploying and configuring client access services on Exchange Server Managing high availability in Exchange Server High availability on Exchange Server Configuring highly available mailbox databases Configuring high availability of Client Access services Lab : Implementing DAGs Lab : Implementing and testing high availability Implementing disaster recovery for Exchange Server Implementing Exchange Server backup Implementing Exchange Server recovery Lab : Backing up Exchange Server data Lab : Restoring Exchange Server data Configuring and managing message transport Overview of message transport Configuring message transport Managing transport rules Lab : Configuring and managing message transport Configuring message security Deploying and managing an Edge Transport server for message security Implementing an antivirus solution for Exchange Server Implementing an antispam solution for Exchange Server Lab : Configuring message security in Exchange Server Monitoring and troubleshooting Exchange Server Monitoring Exchange Server Troubleshooting Exchange Server Lab : Monitoring and troubleshooting Exchange Server Securing and maintaining Exchange Server Securing Exchange Server by using RBAC Configuring audit logging in Exchange Server Maintaining Exchange Server Lab : Securing and maintaining Exchange Server Implementing and managing Exchange Online deployments Overview of Exchange Online and Office 365 Managing Exchange Online Implementing the migration to Exchange Online Managing a hybrid environment Lab : Managing Exchange Online Additional course details: Nexus Humans 20345-1 Administering Microsoft Exchange Server 2016/2019 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 20345-1 Administering Microsoft Exchange Server 2016/2019 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Cybersecurity Specialist Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Cybersecurity Specialist Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Cybersecurity Specialist Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Cybersecurity Specialist Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Cybersecurity Specialist? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Cybersecurity Specialist there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Cybersecurity Specialist course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Cybersecurity Specialist does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Cybersecurity Specialist was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Cybersecurity Specialist is a great way for you to gain multiple skills from the comfort of your home.   Module 1: Introduction to Cyber Security Introduction to Cyber Security 00:20:00 Module 2: Cyber Security and Data Breaches Cyber Security and Data Breaches 00:15:00 Module 3: Cyber Attacks Cyber Attacks 00:20:00 Module 4: Cybercrimes Cybercrimes 00:20:00 Module 5: Device Management Device Management 00:20:00 Module 6: Internet Browsing Internet Browsing 00:15:00 Module 7: Office and Remote Work Security Office and Remote Work Security 00:15:00 Module 8: Password Management Password Management 00:20:00 Module 9: Preventative Measures Preventative Measures 00:15:00

Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel Complete Course - Beginner Intermediate & Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel Complete Course - Beginner Intermediate & Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel Complete Course - Beginner Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting A Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working With Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working With Multiple Worksheets And Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines And Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00

– a psychotherapy skills masterclass The language we use has a huge impact on others – on this practical, inspiring course you will learn how to combine solution-focused techniques and effective language skills to help relieve distress and improve outcomes, as quickly as possible… Accredited CPD Certificate : 12 hours Length 2 days (9:30am - 4:00pm) Excellent course! I’ve learnt so much and been inspired so much. Gareth has a wonderful style of delivery...MARY FLYNN This course is suitable for anyone working with adults, teens or children – the knowledge and skills you will gain have a wide range of applications in addition to therapy and counselling, including coaching, healthcare, teaching, motivation, overcoming resistance, emotional turmoil and much more. You will leave with a powerful toolkit of precisely-targeted and creative therapeutic language skills, as well as a range of effective brief therapy strategies. These can be easily tailored to any individual and used to successfully help people resolve a wide range of conditions and problems as quickly as possible. If you want to be more effective in what you do, these are core skills to have… Denise Winn previously taught this course, it is now delivered by Gareth Hughes Why take this course Language is key to everything we do – being aware of the power of language to help or do harm is essential when we’re trying to help people. Knowing how to use it well can make all the difference to a successful therapeutic outcome. Paying attention to the language we use is central to the human givens approach to therapy and counselling: our choice of words is crucial in building rapport with people, learning more about someone – their unique qualities and abilities – in listening and responding, in providing motivation and in collaborating to agree goals and strategies for the effective resolution of their problems. The careful use of language is essential for other areas of life too: at work, home, with family and friends – and this 2-day course is accessible to all. It can be taken as part of the Human Givens Diploma or as a stand-alone course. You will gain a solid foundation in the most effective brief solution-focused strategies and language skills that are essential if you want to be able to help people as quickly as possible. By distilling the essence of proven brief therapy approaches and working in tune with the givens of human nature, outcomes can be dramatically improved and suffering successfully reduced. You will also learn how any team of professional healthcare workers can safely incorporate brief therapy techniques into their work with patients suffering from depression, anxiety, panic attacks, PTSD, anger, OCD, eating disorders, addiction and relationship/marital/family problems, thereby improving outcomes and reducing suffering on an even wider scale. Good to know This course gives you essential skills that are used in the successful treatment of a wide range of conditions, such as anxiety disorders, depression, addictions, self-harm, OCD and the rewind technique for treating trauma and phobias. They are also fundamental skills to have when using guided imagery and visualisation. This course is an essential component of Part 1 of the HG Diploma. I feel very excited and energised. I can't wait to start using these techniques...OCCUPATIONAL THERAPIST What will you learn The essential skills needed for successful brief therapy New information about the APET™ model – why it is so important to construct therapy that is in tune with our how brains work (our emotional reactions come first) – this speeds up therapy and explains why purely cognitive and behavioural approaches can take so long An ability to get to the root of the matter quickly by establishing which innate needs are not being met and why (the essence of effective brief therapy) Quick rapport building skills How to use the RIGAAR™ structure to improve therapy outcomes Reflective listening and reflective reframing How to use therapeutic language skills directly and indirectly to initiate change Ways to use solution-focused questioning to create a framework for change How to identify and use your client’s own life resources An understanding of why the human givens approach dramatically increases the likelihood of therapy being brief, regardless of the presenting problem A range of psychological interventions to use with common psychiatric problems: anxiety, panic attacks, depression, intrusive thoughts, relationship difficulties and so on Promoting cooperation by developing realistic and achievable goals How to identify exceptions (when the problem doesn’t occur) and get the patient to take credit for them How to generate motivation for change in your patients Separating the patient’s core identity from their problem How to minimise or overcome resistance How not to be drawn in to a client’s negative self-view Great use of case histories to illustrate the skills covered How to use the psychological laws of positive expectancy and concentrated attention An understanding of why taking this collaborative human givens stance, reduces stress and pressure on you Plenty of opportunity to consolidate what you are learning by practising the skills yourself How is the course structured? Held over two consecutive days, this skills-based practical workshop combines a blend of talks, demonstrations and exercises. Each day starts at 9.30pm and finishes at 4.00pm, with 2 breaks for networking and refreshment and 45 minutes for lunch. Course notes, refreshments and lunch are included on both days. Who is this course suitable for? You and your patients will benefit enormously from you attending these two days. If you are a counsellor, psychotherapist, clinical psychologist, mental health nurse, GP, doctor, nurse, OT, physiotherapist, youth worker, social worker, health visitor, support worker or any other caring professional, and wish to be more effective in what you do, this course gives you the perfect opportunity to discover new, subtle but highly effective skills with plenty of time to practise to help you assimilate them into your own work. Many other professions – such as educational and business professionals – also find the skills and information covered highly applicable to and beneficial for their own work. It is also suitable for anyone who is thinking of a career in this field as these are core skills needed for successful brief, solution-focused psychotherapy. This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

PA Telephone Skills Certification Learning PA telephone skills is absolutely essential for current and aspiring personal assistants looking to refine their craft and sharpen their telephone skills. It is also important for managers and supervisors who are looking for tips to improve the overall performance of their PAs. This course provides a comprehensive guide to essential PA telephone skills, such as making the best first impressions, taking messages effectively, and being organised and calm under pressure. From the most professional greetings to use, having the right timing and how to be genuinely charming, to the ways of taking and delivering messages properly, this course covers everything you need to know about effective PA telephone skills. You Will Learn: How to make the best first impression by using the right greetings and being charming The perfect timing when taking calls How to be organised and efficient when taking and delivering messages How to be calm and professional under pressure Benefits of Taking This Course: You will have the skills to help you in your PA role You could improve your chances of receiving a promotion You will improve your relationship with your boss and ensure a smooth office process You will avoid the potentially devastating consequences of jeopardising important company relationships