878 Courses

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Learn the Latest Skills | Acknowledged by CPD | MCQ Based Exam & Tutor Support | Interactive Video Training  If you are interested in gaining a position as a highly paid Office Administrator, Secretary, or Personal Assistant, then this lesson from Janets is the perfect opportunity. The course focuses on building practical knowledge so that upon successful completion you are fully prepared for work. Whether you are a complete beginner or have some experience, this course covers everything in a concise manner. Gain the confidence to excel in any office or commercial environment by gaining the necessary knowledge of administration, computer, and management techniques. This cutting-edge online course is taught by industry experts with continuing expert involvement, and it teaches you immediately applicable skills. Our Diploma can provide you with the insight, skills and knowledge you need to succeed in this busy career. What Will You Learn? Understand succession planning. Learn the basic computer software you need to know to perform at your best on a daily basis. How to work to a schedule to achieve the best results.. How to present documents and proofread. Organise effective meetings. How to categorise, sub-categorise and manage your filing system effectively. What classes are included in this package? Earn a digital certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This course is designed for those seeking senior secretarial or administrative jobs in an organization, as well as newcomers seeking their first job in an office setting. Although a good command of the English language is assumed, no prior experience or knowledge is required. Career Path Training offered by the Office Admin, Secretarial and PA could potentially benefit a range of roles, but would particularly enhance careers in: Office Administration Personal Assistant Receptionist Secretary Other administration roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement after the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the Office Admin, Secretarial and PA Diploma, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Office Admin, Secretarial and PA Diploma Microsoft Word Microsoft PowerPoint Microsoft Excel Recommended Reading Mock Exam Final Exam Recommended Materials Assignment

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked.  The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives  By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction

Getting Started The CMI Level 5 Award in Management and Leadership course is designed for practising or aspiring middle managers and leaders at operations, division, departmental or specialist level, who are typically accountable to a senior manager or business owner. Leading and managing individuals and teams to deliver in line with the organisational strategy is the primary role of a practising manager. The CMI Level 5 Award in Management and Leadership is a concise and shorter course focusing on improving your capabilities and core management skills to the next level. You'll develop the essential strategic skills and competencies required to manage teams and individuals effectively, enabling you to deliver long-lasting results. Achieving the CMI Level 5 Award in Management and Leadership qualification will enhance your credibility and enable you to outperform in demanding roles and situations. You'll have a wide range of modules to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits For Learners: Improve your capabilities and core management skills Develop the knowledge and skills required for managing and leading individuals and teams Provide an extensive knowledge of skills to excel in specific management areas For Organisations: Deliver aims and objectives in line with wider organisational strategy Provide you with a fully wider range of skills and knowledge required to be a manager as part of an organisation Focus on the areas that are most appropriate to your role and organisation Key Highlights Are you an aspiring Manager or Leader looking for career development? Then, the CMI Level 5 in Management and Leadership qualification offered by the School of Business and Technology London is the right solution for you. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 5 Management & Leadership can open many career pathways including, but not limited to: Operations Manager, with an estimated salary of £51,577 per annum Divisional Manager, with an estimated salary of £48,613 per annum Departmental Manager, with an estimated salary of £34,997 per annum Regional Manager, with an estimated salary of £51,372 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 6 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 3000 to 4,000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for current or aspiring mid-level managers. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 19 years of age and over Have some team leading or supervisory experience or managerial experience in the junior or middle management level Possess the ability to complete the Level 5 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression A possible progression route on successful completion of a CMI Level 5 in Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to level 6 or 7 Certificate) Why gain a CMI Qualification? This online CMI Level 5 Award in Management and Leadership course is perfect if you are a current or aspiring mid-level manager looking to advance in your career. The globally recognised CMI Level 5 Award is perfect for you if you want to increase your opportunities for obtaining a middle management position. The essential leadership skills and knowledge you'll develop with this course will be remarkably effective. Upon completing this course, you can progress to further learning within the suite of Level 5 courses in Management and Leadership - i.e. achieving an Award and topping up to a Certificate or Diploma. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 6 or Level 7 courses in Management and Leadership, with the goal of becoming a Chartered Manager. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 5 Award in Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must complete at least one unit to a minimum of 40 TUT hours, 4 credits to achieve this qualification. There is a barred combination of units - learners taking 502 cannot select 503, 505 or 511 and learners taking 526 cannot select 501 or 502. Learners cannot select unit 608 as part of this qualification. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Forming Successful Teams Reference No : CMI 505 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose and characteristics of successful teams. 2. Understand approaches to team formation. 3. Know how to analyse and respond to the challenges of team formation. UNIT2- Principles of Managing and Leading Individuals and Teams to Achieve Reference No : CMI 503 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand approaches to managing and leading teams. 2. Know how to achieve a balance of skills and experience in teams. 3. Know techniques for managing and leading individuals and teams to achieve success. UNIT3- Principles of Management and Leadership in an Organisational Context Reference No : CMI 501 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand factors which impact on an organisation's internal environment. 2. Understand the application of management and leadership theories. 3. Understand the knowledge, skills and behaviours to be effective in a management and leadership role UNIT4- Principles of Developing, Managing and Leading Individuals and Teams to Achieve Success Reference No : CMI 502 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand approaches to developing, managing and leading teams 2. Understand approaches to achieving a balance of skills and experience in teams. 3. Know techniques for leading individuals and teams to achieve success. UNIT5- Managing Performance Reference No : CMI 504 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the rationale for managing performance within organisations. 2. Know how to manage performance. 3. Understand frameworks, diagnostic and evaluation tools used for performance management. UNIT6- Principles of Delivering Coaching and Mentoring Reference No : CMI 507 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role and purpose of coaching and mentoring within an organisation. 2. Understand the use of models and processes used in workplace coaching and mentoring. 3. Know how to manage the delivery of effective coaching and mentoring. UNIT7- Managing Stakeholder Relationships Reference No : CMI 509 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the different types and value of stakeholder relationships. 2. Understand the frameworks for stakeholder management. 3. Know how to manage stakeholder relationships. UNIT8- Managing Conflict Reference No : CMI 510 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the types, causes, stages and impact of conflict within organisations. 2. Understand how to investigate conflict situations in the workplace. 3. Understand approaches, techniques, knowledge, skills and behaviours for managing conflict. UNIT9- Planning, Procuring and Managing Resources Reference No : CMI 516 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the importance of effective and efficient resource use in organisations. 2. Know how to plan resources to meet organisational objectives. 3. Know how to procure resources. UNIT10- Principles of Innovation Reference No : CMI 517 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role of innovation within organisations. 2. Understand the process of managing innovation in an organisation. UNIT11- Principles of Marketing Products and Services Reference No : CMI 523 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of marketing to support the achievement of organisational objectives. 2. Understand the factors in the organisation's marketing environment which impact on the marketing of a product or service. 3. Know how to market a product or service. UNIT12- Managing Finance Reference No : CMI 520 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand finance within organisations. 2. Know how to set and manage budgets. UNIT13- Using Data and Information for Decision Making Reference No : CMI 521 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the use of data and information in decision making. 2. Be able to interpret data and information to support decision making. 3. Know how to present data and information used for decision making. UNIT14- Managing Change Reference No : CMI 514 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for change in organisations. 2. Understand approaches to change management. 3. Understand how to initiate, plan and manage change in an organisation. UNIT15- Creating and Delivering Operational Plans Reference No : CMI 515 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the principles of operational planning in an organisation. 2. Know how to create an operational plan in line with organisational objectives. 3. Know how to manage and lead the delivery of an operational plan. UNIT16- Managing Equality, Diversity and Inclusion Reference No : CMI 506 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand legal and organisational approaches to equality, diversity and inclusion. 2. Understand the role and responsibilities of a manager in relation to equality, diversity and inclusion. 3. Know how to develop and implement plans which support equality, diversity and inclusion within an organisation. UNIT17- Principles of Developing a Skilled and Talented Workforce Reference No : CMI 508 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the benefits of developing a skilled and talented workforce. 2. Understand the factors which influence workforce development. 3. Understand the scope of learning and development as part of a workforce development strategy. UNIT18- Principles of Recruiting, Selecting and Retaining Talent Reference No : CMI 511 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the factors that impact on recruitment and selection. 2. Know how to plan for recruitment and selection. 3. Understand approaches to the recruitment and selection of a diverse and talented workforce. UNIT19- Workforce Planning Reference No : CMI 512 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the rationale for workforce planning. 2. Understand the principles and practices of workforce planning. UNIT20- Managing Projects to Achieve Results Reference No : CMI 513 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of projects in delivering organisational strategy. 2. Understand processes for initiating, planning and managing projects. 3. Understand the factors which contribute to effective project management. UNIT21- Managing Risk Reference No : CMI 518 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope of business risk management. 2. Understand the process for managing business risk. UNIT22- Managing Quality and Continuous Improvement Reference No : CMI 519 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope and purpose of quality management within organisations. 2. Understand approaches for managing quality. 3. Understand the application of continuous improvement within organisations. UNIT23- Managing the Customer Experience Reference No : CMI 522 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the principles of managing the customer experience. 2. Understand the customer journey in the context of an organisation. 3. Know how to manage the customer experience. UNIT24- Conducting a Management Project Reference No : CMI 524 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Know how to plan a management project. 2. Be able to conduct a management project. UNIT25- Using Reflective Practice to Inform Personal and Professional Development Reference No : CMI 525 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the value of reflective practice to inform personal and professional development. 2. Know how to apply reflective practice to inform personal and professional development. UNIT26- Strategic Corporate Social Responsibility and Sustainability Reference No : CMI 608 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand corporate social responsibility and sustainability in organisational contexts. 2. Know how corporate social responsibility and sustainability is applied in an organisational setting. UNIT27- Principles of Leadership Practice Reference No : CMI 526 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand leadership practice in an organisation. 2. Understand leadership styles 3. Understand the impact of leadership within organisations. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Overview Learn about Addiction and Mental Health - Dual Diagnosis from industry experts and boost your professional skill. This Addiction and Mental Health - Dual Diagnosis course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Addiction and Mental Health - Dual Diagnosis. You'll also gain the skills of Addiction and Mental Health - Dual Diagnosis to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of Addiction and Mental Health - Dual Diagnosis professionals and gain first-hand experience of Addiction and Mental Health - Dual Diagnosis problem-solving. The Addiction and Mental Health - Dual Diagnosis is self-paced. You can complete your course and submit the written assignment in your suitable schedule. After completing the Addiction and Mental Health - Dual Diagnosis, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This Addiction and Mental Health - Dual Diagnosis will provide you with the latest information and updates of Addiction and Mental Health - Dual Diagnosis. It will keep you one step ahead of others and increase your chances of growth. Why buy this Addiction and Mental Health - Dual Diagnosis? 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 Addiction and Mental Health - Dual Diagnosis 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Addiction and Mental Health - Dual Diagnosis does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Addiction and Mental Health - Dual Diagnosis 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 Addiction and Mental Health - Dual Diagnosis is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Addiction and Mental Health - Dual Diagnosis Promotional Video Promotional 5 minute video 00:06:00 SAMHI Dual Diagnosis Intro video SAMHI Dual Diagnosis Intro video and downloadable worksheet PowerPoint slides 00:04:00 Module 1 - Drugs and Effects Module 1 - Drugs and Effects: VIDEO PART 1 (content part 1 - 4) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 2 (content part 5 - 6) 00:19:00 Module 1 - Drugs and Effects: VIDEO PART 3 (content part 7 - 8) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 4 (content part 9) 00:15:00 Module 1 - Drugs and Effects: VIDEO PART 5 (content part 10) 00:10:00 Module 1 - Drugs and Effects: VIDEO PART 6 (content 10 - 12) 00:18:00 Module 1 - Drugs and Effects: VIDEO PART 7 (content part 13) 00:13:00 Module 1 - Drugs and Effects: VIDEO PART 8 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 9 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 10 (content part 15 - 18) 00:19:00 Module 2 - Addictions & Mental Health Module 2 Addictions & Mental Health: VIDEO PART 1 content part 1 - 2 00:16:00 Module 2 Addictions & Mental Health: VIDEO PART 2 content part 3 - 5 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 3 content part 6 - 7 00:13:00 Module 2 Addictions & Mental Health: VIDEO PART 4 content part 00:17:00 Module 2 Addictions & Mental Health: VIDEO PART 5 content part 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 6 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 7 content part 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 8 content part 00:12:00 Module 2 Addictions & Mental Health: VIDEO PART 9 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 10 content part 00:13:00 Module 3 - Harm Minimisation & Optimal Health Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 00:23:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 2 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 3 content part 00:09:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 4 content part 00:18:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 5 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 6 00:11:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 7 content part 7 00:12:00 Module 4 - Brain Works - Neurophysiology Module 4 Brain Works - Neurophysiology 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 1 content part 00:10:00 Module 4 Brain Works - Neurophysiology VIDEO PART 2 content part 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 3 content part 00:19:00 Module 4 Brain Works - Neurophysiology VIDEO PART 4 content part 00:16:00 Module 4 Brain Works - Neurophysiology VIDEO PART 5 content part 00:11:00 Module 5 - Trauma Model & Keys to Treatment Module 5 Trauma Model & Keys to Treatment VIDEO PART 1 content part 1 - 2a - 2f 00:20:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 2 content part 2g 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 3 content part 2h - 2i 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 4 content part 3 00:13:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 5 content part 4 00:12:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 6 content part 5 - 7 00:18:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content part 8 00:17:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 8 content part 9 - 10 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 9 content part 11 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 10 content part 12 00:19:00 Module 6 - Brief & Early Intervention and Tripod of Support Module 6 Brief & Early Intervention and Tripod of Support VIDEO 1 content part 1 00:18:00 Module 6 Brief & Early Intervention and Tripod of Support VIDEO 2 content part 2 00:20:00 Resources Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs 00:00:00

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Register on the Addiction and Mental Health - Dual Diagnosis today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Addiction and Mental Health - Dual Diagnosis is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Addiction and Mental Health - Dual Diagnosis Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Addiction and Mental Health - Dual Diagnosis, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Promotional Video Promotional 5 minute video 00:06:00 SAMHI Dual Diagnosis Intro video SAMHI Dual Diagnosis Intro video and downloadable worksheet PowerPoint slides 00:04:00 Module 1 - Drugs and Effects Module 1 - Drugs and Effects: VIDEO PART 1 (content part 1 - 4) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 2 (content part 5 - 6) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 3 (content part 7 - 8) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 4 (content part 9) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 5 (content part 10) 00:10:00 Module 1 - Drugs and Effects: VIDEO PART 6 (content 10 - 12) 00:18:00 Module 1 - Drugs and Effects: VIDEO PART 7 (content part 13) 00:13:00 Module 1 - Drugs and Effects: VIDEO PART 8 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 9 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 10 (content part 15 - 18) 00:19:00 Module 2 - Addictions & Mental Health Module 2 Addictions & Mental Health: VIDEO PART 1 content part 1 - 2 00:16:00 Module 2 Addictions & Mental Health: VIDEO PART 2 content part 3 - 5 00:19:00 Module 2 Addictions & Mental Health: VIDEO PART 3 content part 6 - 7 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 4 content part 00:17:00 Module 2 Addictions & Mental Health: VIDEO PART 5 content part 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 6 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 7 content part 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 8 content part 00:12:00 Module 2 Addictions & Mental Health: VIDEO PART 9 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 10 content part 00:13:00 Module 3 - Harm Minimisation & Optimal Health Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 00:23:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 2 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 3 content part 00:09:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 4 content part 00:18:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 5 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 6 00:11:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 7 content part 7 00:12:00 Module 4 - Brain Works - Neurophysiology Module 4 Brain Works - Neurophysiology 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 1 content part 00:10:00 Module 4 Brain Works - Neurophysiology VIDEO PART 2 content part 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 3 content part 00:19:00 Module 4 Brain Works - Neurophysiology VIDEO PART 4 content part 00:16:00 Module 4 Brain Works - Neurophysiology VIDEO PART 5 content part 00:11:00 Module 5 - Trauma Model & Keys to Treatment Module 5 Trauma Model & Keys to Treatment VIDEO PART 1 content part 1 - 2a - 2f 00:20:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 2 content part 2g 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 3 content part 2h - 2i 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 4 content part 3 00:13:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 5 content part 4 00:12:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 6 content part 5 - 7 00:18:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content part 8 00:17:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content partVIDEO PART 8 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 9 content part 11 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 10 content part 12 00:19:00 Module 6 - Brief & Early Intervention and Tripod of Support Module 6 Brief & Early Intervention and Tripod of Support VIDEO 1 content part 1 00:18:00 Module 6 Brief & Early Intervention and Tripod of Support VIDEO 2 content part 2 00:20:00 Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Office admin, the heart of an organization, plays a vital role in office administration. A good administrative skill enhances individual as well as organizational growth. Learn every single important aspect to kick-start your career in this field through our Office Admin and Customer Service Diploma course. The precise contents of the course teach you how to deal with administrative functions, different letter writing, documentation, reporting, recordkeeping, documentation. The course also teaches you how to manage customer, speak with them in a sound bite, and serve them with their demand. At the end of the course, you will become an efficient admin knowing all the lurid aspects of administrative procedures. Who is the course for? Professionals, employees or businessmen who want to improve the administration and customer service department of their company. People who want to know how administrative management and customer service work. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 00:05:00 Module Three - Getting Organized (II) 00:05:00 Module Four - Managing Time 00:05:00 Module Five - Getting It All Done On Time 00:05:00 Module Six - Special Tasks 00:05:00 Module Seven - Verbal Communication Skills 00:05:00 Module Eight - Non-Verbal Communication Skills 00:05:00 Module Nine - Empowering Yourself 00:05:00 Module Ten - The Team of Two 00:05:00 Module Eleven - Taking Care of Yourself 00:05:00 Module Twelve - Wrapping Up 00:05:00 Administrative Management Module One - Getting Started 00:05:00 Module Two - Why Your Office Needs Administrative Procedures 00:05:00 Module Three - Gathering the Right Tools 00:05:00 Module Four - Identifying Procedures to Include 00:05:00 Module Five - Top Five Procedures to Record 00:05:00 Module Six - What to Include in Your Binder (I) 00:05:00 Module Seven - What to Include in Your Binder (II) 00:05:00 Module Eight - Organizing Your Binder 00:05:00 Module Nine - What Not to Include in the Procedure Guide 00:05:00 Module Ten - Share Office Procedure Guide 00:05:00 Module Eleven - Successfully Executing the Guide 00:05:00 Module Twelve - Wrapping Up 00:05:00 Organisational Skills Module One - Getting Started 00:05:00 Module Two - Remove the Clutter 00:05:00 Module Three - Prioritize 00:05:00 Module Four - Scheduling Your Time 00:05:00 Module Five - To Do Lists 00:05:00 Module Six - Paper and Paperless Storage 00:05:00 Module Seven - Organization in Your Work Area 00:05:00 Module Eight - Tools to Fight Procrastination 00:05:00 Module Nine - Organizing Your Inbox 00:05:00 Module Ten - Avoid the Causes of Disorganization 00:05:00 Module Eleven - Discipline is the Key to Stay Organized 00:05:00 Module Twelve - Wrapping Up 00:05:00 Organisational Skills Course for Administrator- Activities 00:00:00 Customer Relations and Dealings Module One - Getting Started 00:05:00 Module Two - The Right Attitude Starts with You 00:05:00 Module Three - Stress Management (Internal Stressors) 00:05:00 Module Four - Stress Management (External Stressors) 00:05:00 Module Five - Transactional Analysis 00:05:00 Module Six - Why are Some Customers Difficult 00:05:00 Module Seven - Dealing with the Customer Over the Phone 00:05:00 Module Eight - Dealing with the Customer In Person 00:05:00 Module Nine - Sensitivity in Dealing with Customers 00:05:00 Module Ten - Scenarios of Dealing with a Difficult Customer 00:05:00 Module Eleven - Following up With a Customer Once You Have Addressed Their Issue 00:05:00 Module Twelve - Wrapping Up 00:05:00 Customer Service: Telephone Etiquette Module One - Getting Started 00:30:00 Module Two - Aspects of Phone Etiquette 01:00:00 Module Three - Using Proper Phone Language 01:00:00 Module Four - Eliminate Phone Distractions 01:00:00 Module Five - Inbound Calls 01:00:00 Module Six - Outbound Calls 01:00:00 Module Seven - Handling Rude or Angry Callers 01:00:00 Module Eight - Handling Interoffice Calls 01:00:00 Module Nine - Handling Voicemail Messages 01:00:00 Module Ten - Methods of Training Employees 01:00:00 Module Eleven - Correcting Poor Telephone Etiquette 01:00:00 Module Twelve - Wrapping Up 00:30:00 Customer Relationship Management Customer Relationship Management 00:10:00 What CRM Is and Who It Serves 00:15:00 Checklist for Success 00:15:00 Requirement Driven Product Selection 00:15:00 Considerations in Tool Selection 00:15:00 Strategies for Customer Retention 00:15:00 Building the Future 00:15:00 Homegrown vs. Application Service Provider 00:15:00 Evaluating and Reviewing Your Program 00:15:00 The Development Team 00:15:00 Microsoft Office Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Powerpoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam- Office Admin and Customer Service Diploma 00:30:00 Final Exam Final Exam- Office Admin and Customer Service Diploma 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 5 Days 30 CPD hours This course is intended for This course is intended for those who provide site collection and site administration and are power users or IT professionals who are tasked with supporting or working within the SharePoint 2016 environment on premise and/or in Office 365. Overview After completing this course, students will be able to: - Design and implement a company portal structure using SharePoint 2016 objects including sites, libraries, lists and pages - Explain the role of security and permissions throughout SharePoint 2016 - Implement guidelines for consistency in building a company portal to aid in the day-to-day administration of content in SharePoint 2016 - Enhance the design and content of a company portal using SharePoint 2016 pages and web parts - Explain the importance of governance for the planning and managing future growth of the - SharePoint 2016 implementation - Identify options to integrate data from other systems such as Microsoft Office, as well as preserve existing data - Explain the role of social networking in SharePoint 2016 and its impact on collaboration This course is intended for power users and IT professionals who are tasked with working within the SharePoint 2016 environment and conduct site collection and site administration. Getting Started with SharePoint 2016 Exploring SharePoint 2016 Site Collection and Site Administrator Roles Defining SharePoint Terminology Navigating a SharePoint Site Interacting with the Ribbon Creating and Editing Basic Content What is Metadata? Versions of SharePoint Standard Enterprise O365 Building a Site Collection with Apps The Structure of SharePoint Creating a Site What does a site template come with? Defining SharePoint Apps Customizing Lists and Libraries Creating/Managing Lists and Libraries through SharePoint Designer Explaining Views on Lists and Libraries Creating Views in Lists and Libraries Modifying Navigation Turning Site Features On/Off Reorganizing a Site using Site Content and Structure feature Lab 1: Creating a Structured Company Portal Lab 2: Creating a List Using SharePoint Designer (Optional) Creating Consistency across Sites Defining Site Columns Defining Content Types Implementing a Taxonomy Using Templates to Promote Consistency Lab 1: Creating Site Columns and Content Types Lab 2: Implementing a Taxonomy Lab 3: Configuring the Content Organizer SharePoint Permissions Explaining Permissions and Security in SharePoint Creating SharePoint Groups Managing Permissions within SharePoint Sharing versus Traditional Security Sharing as different permission levels Lab 1: Managing Permissions in SharePoint Working with Pages and Web Parts Changing the Appearance of the Portal Editing a Page wiki web part Working with Web Parts and App Parts App Parts Content Search Web Part Relevant Documents Content query Table of Contents Pictures Web Part Connections Filter web parts Web parts with Targeting Audience Lab 1: Adding and Configuring Web Parts Lab 2: Connecting Web Parts Lab 3: Applying Themes to Your Company Portal Document and Records Management Basic Content Approval Versioning Check In/Out Holds Retention Policy Document ID Content Organizer Compliance Policy Center Site Template EDiscovery Records Center Lab 1: Working with Advanced Document Management Features Lab 2: Leveraging Records Management to Preserve Data Workflow Alerts Out of the Box Workflow Activating Workflow Features Approval Workflow Creating a Workflow in SharePoint Designer Lab 1: Creating an Approval Workflow from SharePoint Lab 2: Creating a Custom Workflow in SharePoint Designer (Optional) Office Integration Outlook Calendar Contacts Excel Word PowerPoint OneDrive for Business OneNote Access Lab 1: Importing and Exporting Excel Data with SharePoint Lab 2: Linking Outlook and SharePoint Creating Publishing Sites Why use a publishing site? Publishing Pages Enabling Web Content Management Managing the Structure of Web Content Navigating a Site Using Managed Metadata Lab 1: Creating a Rich Publishing Sit Lab 2: Configuring a Publishing Approval Process Lab 3: Implementing a Managed Navigation Site Bridging the Social Gap My Sites Configuring Social Features in SharePoint Posts, Tags and Mentions Creating a Community Site Lab 1: Designing a Social Experience in SharePoint 2016 Lab 2: Creating a Community Site Finding Information Using Search Exploring the Search Features in SharePoint Configuring Search Settings Search Analytics Search Visibility Lab 1: Configuring an Advanced Search Center Planning a Company Portal Using SharePoint Defining SharePoint Governance Working with Information Architecture Implementing Site Hierarchies Discussing the Execution of Governance Site Collection Administrator Settings Exploring Settings for Site Collection Administrators Exploring Settings for Site Administrators Site Closure Policies Additional course details: Nexus Humans 55234 SharePoint 2016 Site Collections and Site Owner Administration 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 55234 SharePoint 2016 Site Collections and Site Owner Administration 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.

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams. Course overview Duration: 1 day (6.5 hours)  Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams. While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data. This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram. Objectives  By the end of the course you will be able to: Create and amend flowcharts Create cross functional (Swim Lane) process flows Produce organisation charts by importing data Add essential data to shapes Export diagram data reports to Excel Present, publish and print Visio diagrams Content Visio essentials Finding your way around Visio Using the ribbon and Quick Access toolbar Keyboard shortcuts Shapes and stencils explained What Visio can do for you Creating basic flowcharts Working with shapes Adding and deleting shapes Joining, aligning and sizing shapes Using Auto-Connect Labelling shapes and connectors Editing and improvinC flowcharts Amending shape and connector labels Using colours to emphasise Changing line styles Moving and copying objects Grouping diagram elements Quick ways of working Cross functional flowcharts Creating Cross-Functional Flowcharts Manipulating functional bands Creating off-page references within diagrams and hyperlinks to other documentation Organising charts and shape data Using the wizard to create an organisation Chart Importing existing Data into to create an organisation chart Modifying an organisation chart Shape Data Adding shape data to a shape Creating shape data sets Diagram reports Exporting data to a report in Excel Exporting to HTML Creating and customizing reports Presenting, publishing and printing Using Page Setup Print previewing Embedding backgrounds Adding headers and footers Converting your final documentation to PDF Saving as HTML Visio with PowerPoint