9797 Office courses

Duco Digital Training's self study BCS International Diploma in Business Analysis course will help build your career as a business analyst, business architect, data analyst, enterprise analyst, management consultant...

Organising and Chairing Meetings Certification Meetings are a key mode of communication in most organisations. They are used to share new ideas, pass on important news about the business, organise complex projects and more besides. Although the common stereotype of a meeting is that of a dull gathering in the office, they are extremely useful when overseen by a competent chairperson. In this course, you will learn how to successfully arrange, oversee and chair meetings that enhance the performance of a business. You will learn how to keep the meeting on track and how to handle interpersonal tension or conflict. You Will Learn: What constitutes a business meeting and why they are necessary The main types of meetings you might have to chair, including decision-making and consultation meetings The role of the chairperson in a meeting and how they can facilitate rather than dominate proceedings What makes a good meeting agenda and how they should be used during meetings Benefits of Taking This Course: If you are responsible for chairing meetings as part of your job, you will benefit from the practical strategies in this course If you are responsible for taking minutes during meetings, this course will help you gain a broader appreciation of the context in which a meeting usually takes place This course will benefit anyone who needs to attend meetings but is unsure what to expect, as it provides an overview of how they are typically structured If you ever serve in a mediation role that requires diplomacy and tact, you will benefit from learning the communication skills outlined in this course

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who already have experience creating Modern SharePoint sites and populating them with content, who want to learn advanced features to extend SharePoint's capabilities, make information easier to find and manage, use SharePoint features to improve governance and compliance, and improve the security of information and services within the SharePoint environment. Overview In this course, you will perform advanced site-building and administration tasks. You will: Create a custom site template to reduce the time spent creating similarly configured SharePoint sites. Configure managed metadata, including custom term sets, content types, and metadata-based navigation. Control access through permissions. Improve overall security of sites, lists, libraries, folders, list items, and documents. Microsoft© SharePoint©, in conjunction with the Microsoft 365? productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location.Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance.Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration.This course focuses on these advanced site-building and administration tasks. Lesson 1: Creating Custom Site Templates Topic A: Prepare a Site Script Topic B: Generate and Use a Custom Site Template Lesson 2: Managing Content Services Topic A: Plan and Configure Managed Metadata Topic B: Create and Manage Content Types Topic C: Use Managed Metadata for Navigation and Filtering Lesson 3: Controlling Access Through Permissions Topic A: Assign Permissions Topic B: Manage Permissions Inheritance Lesson 4: Improving Security Topic A: Manage Access at the Site Level Topic B: Manage Access at the Tenant Level

This unique Facilities Management offers a thorough introduction to one of the world's most in-demand specialized professions. Learn about the operations and goals of facilities management at an advanced level, gaining the skills and information you will need to pursue a fulfilling career for the rest of your life. The course content teaches numerous interconnected disciplines that create facilities management, with no prior knowledge or expertise required. This course ensures that an organization has the resources and infrastructure to fulfil its tasks successfully and efficiently, both in the public and private sectors. The Facilities Manager is in charge of everything from building maintenance and renovations to contract management, security, and sustainability. Management : Facilities Management is a dynamic and demanding field, which can also be quite rewarding for successful candidates. To operate as a successful organization, a business model requires effective facilities management. By taking this Facilities Management course and taking the required measures, you can gain the skills needed to manage a high-performing facility. Learning Outcomes After completing this course, you will be able to: Learn everything there is to know about facility management. Establish the significance of facility management. Investigate facility management strategies. Create a long-term project planning strategy. Learn how to manage space and services. Learn the fundamentals of risk management, change management, and human resource management. Recognize the UK's facilities management rules and regulations. Why Choose Level 7 Diploma in Management : Facilities Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. This Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this bundle Course Course 01: Management : Facilities Management Course 02: Workplace Stress Management Course 03: Anger Management ***Other Benefits of this Course 3 PDF Certificate Free Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam Expert Tutor Support [ Note: Free PDF certificate as soon as completing the course ] ***Management : Facilities Management*** Detailed course curriculum of the Management : Facilities Management Course: Module 01: Introduction to Facilities Management The Origins of Facilities Management (FM) Definitions of Facilities Management Functions of Facilities Managers The Facility Management Life Cycle Module 02: Developing a Strategy for Facilities Management Introduction Developing a Facilities Management Strategy Strategic Analysis of Facilities Requirements Developing Solutions Strategy Implementation Module 03: Facilities Planning Real Estate Management Space Management Design Briefing Post-occupancy Evaluations Real Estate Options Totally Serviced Workplaces Module 04: Managing Office WorkSpace Introduction Space and Service Management Design of the Workplace Workspace Remodelling to Optimise Performance Workplace Effectiveness Workplace Security Power Security Module 05: Vendor Management & Outsourcing Service Providers and Suppliers Types of Relationship What Kind of Relationship is Needed? Contractual Arrangements and Partnering Gain-sharing Continual Improvement Module 06: Managing Change Change in an Organisational Setting Communicating Change Responsibilities of Those Managing Change Resolving cultural Conflict Module 07: Managing Human Resources Appropriate Management Structure Employment Obligations Functions, Job Descriptions and Skills Performance Appraisal Module 08: Managing Risk Definition of Risk Types of Risks Impact of Risk on Organisation Principles and Aims of Risk Management Risk Management Standards Risk Control Techniques Module 09: Facilities Management Service Providers Preliminary Approach Managing Agent Managing Contractor Managed Budget Total Facilities Management Determining the Best Approach Module 10: Managing Specialist Services ICT Services Health Care Services Security and Protection Services Custodial Services Professional Services Risks, Insurance and Indemnities Module 11: Public-Private Partnerships and Facilities Management Public-private Partnerships (PPPs) Procurement and Contractual Approach Main types of Service Provided Payment Mechanisms Facilities Management and Private Sector Participation Relevance and Benefits of Private Investment and Partnership Problems with Private Investment and Partnership Module 12: Health, Safety, Environment and UK Law Sustainability and Environmental Issues Relevant Legislation General Policy Corporate Social Responsibility Organisation and Administration Workers' Rights Disability Discrimination Safety Rules and Practice ------------------------- ***Workplace Stress Management*** Module 01: Workplace Stress Module 02: Rational and Irrational Beliefs Module 03: The ABC Framework of REBT Module 04: Cognitive Therapy (CT) Module 05: Cognitive Behavioural Therapy (CBT) in the Workplace Module 06: Conclusion ------------------------- ***Anger Management*** Module 01: Introduction to Anger Module 02: The Process in Anger Module 03: Effect of Anger on Our Thinking Module 04: How to Manage Anger Assessment Method After completing each module of the Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Management : Facilities Management This course is perfect for - Students Fresh graduates Job Seekers Anyone interested in business analysis People who are already employed in related fields and wish to improve their knowledge and abilities. Requirements Management : Facilities Management Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Management : Facilities Management The course could prove instrumental in taking your career to the next level. Typical job titles and roles that fall within the field of FM include the following: Asset Manager Assistant Property Manager Construction Manager Director, Physical Plant Developer Energy Manager Certificates Certificate of completion Digital certificate - Included

The guided imagery and visualisation techniques you will learn on this workshop are essential for helping people successfully overcome depression, addictions, anxiety and more…. Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) Why take this course This new workshop delves deeper into this essential therapeutic skill’s power and flexibility – you will learn a variety of guided imagery techniques that are highly effective at helping people move on from problem behaviours, reframe life circumstances, lower emotional arousal, make therapeutic lifestyle changes, increase resilience and more. Building on the skills learnt on Guided Imagery and Visualisation for therapeutic change (‘Day 1’), this second workshop focuses specifically on the techniques that allow clients to move forward from depression, overcome anxiety and combat addiction. We also look at how to introduce helpful new understandings to clients in a way that overcomes resistance. Strong emotions focus and lock attention keeping people trapped or stuck – so this hands-on training also gives you the opportunity to further develop your therapeutic abilities to help people rehearse in their imagination any desired change to their behaviours and/or feelings, which dramatically increases the likelihood of those changes taking place in ‘real life’, and then being maintained in the future. Guided imagery, as taught on Day 1 is one of the most powerful psychotherapeutic tools available to us; Day 2 will allow you to develop your ability to use it flexibly and successfully in a range of different client presentations. These are essential skills to have in your therapeutic ‘toolkit’. * Please Note: counter-conditioning was previously taught on our pre-2023 Stopping Addictions workshop. Ros has a lovely delivery style that’s very inspiring and left me with so many ideas going forward...MARY FLYNN, GUIDED IMAGERY AND VISUALISATION FOR THERAPEUTIC CHANGE What will you learn How to use the brain’s powerful internal ‘reality generator’ to enable clients to make desired change in their lives Invaluable ways to enable a client to approach situations with confidence and overcome situational anxiety Powerful ways of using this skill to help a client take the ‘first steps’ out of depression An effective technique (counter-conditioning*) which increases likelihood of success when working with clients struggling with addiction Understanding of how to use guided imagery effectively when supporting a client with behaviour change of any kind The use of metaphor within guided imagery; how to craft powerful extended metaphors which take into account a client’s individual model of reality Training and practice in using these techniques Greater confidence in working flexibly with this technique so as to respect each individual client’s model of reality Powerful ways to introduce helpful ideas to a resistant client without breaking rapport Supervised practice in specific techniques for work with a range of presentations How to use healing trance states to reframe difficult life circumstances and build hope using the client’s own resources Specific techniques that can be used to manage pain, or work with anxiety or any other strong state of distress Increased understanding of trance states and their role in everyday life A scientifically-sound knowledge of why the various techniques and skills you will gain are so valuable A range of ways to help people improve their performance – sports, public speaking etc. The opportunity to experience for yourself specific new techniques within guided imagery and visualisation Dates and venues Good to know To attend this course you need to have plenty of experience in using guided imagery and visualisation for relaxing clients or to have completed our Guided Imagery and visualisation for therapeutic change (Day 1) course. (If you are taking the HG Diploma, you will need to attend both days, as both count towards Part 1 of the Human Givens Diploma.) The additional skills you will learn on this second day are introduced on the following courses as integral to effective treatment for the conditions they cover: Stopping Addictions: effective treatment and recovery How to Lift Depression Overcoming Self-harm Please note: The counter-conditioning technique was previously taught on our ‘Stopping Addictions’ workshop. This changed from January 2023. Course Programme The ‘Guided Imagery and Visualisation Additional Techniques’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Reality Generator: a powerful way of rehearsing new behaviours and feelings 11.00am Discussion over tea/coffee 11.30am Introducing new, more helpful patterns and overcoming resistance 1.00pm Lunch (included) 1.45pm Working with addiction and behaviour change 2.45pm Discussion over tea/coffee 3.00pm Working with addiction and behaviour change – continued 4.00pm Day ends Who is this course suitable for? Anyone who has already attended Guided Imagery and Visualisation for Therapeutic Change (Day 1) or who has experience in using guided imagery and visualisation to induce a relaxed state in their clients Anyone, with the above skills, who wants to help people effectively and for the long-term, particularly those working in mental and physical healthcare, or with addictions or self harm Psychotherapists, counsellors and mental health workers (who also have the above skills) who work with a wide range of conditions and would like to ensure long-term behaviour change Trained hypnotherapists looking to add these techniques to their existing skillset. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Deal Price is Active! Offer Ends Soon; Hurry Up!! Do you often find yourself feeling lost during meetings, struggling to keep up with the conversation and missing important details? Or maybe you're responsible for taking minutes but feel unsure of what to include or how to structure them effectively? Look no further, as our Effective Minute Taking course has got you covered! With our comprehensive curriculum, you'll learn everything you need to know to become a confident and efficient minute taker. In Module 01, you'll gain a thorough understanding of the purpose and importance of minute writing. In Module 02, you'll learn how to prepare for meetings and gather the necessary information to create accurate and comprehensive minutes. Modules 03 and 04 will guide you through the meeting structure, including how to capture decisions and actions effectively. In Module 05, you'll discover the key roles and responsibilities of a minute taker, and in Module 06, you'll pick up useful tips and techniques to enhance your minute taking skills. Module 07 will explore the technology available to support minute taking, and finally, in Module 8, you'll build your confidence to ensure you can take on the role of minute taker with ease. By the end of this Effective Minute Taking course, you will have: Developed an understanding of the purpose and importance of minute writing Learned how to effectively prepare for meetings and gather the necessary information Gained knowledge of the meeting structure and how to capture decisions and actions accurately Identified the roles and responsibilities of a minute taker Acquired useful tips and techniques to enhance your minute taking skills Learned about technology available to support minute taking Start your learning journey straight away with this Effective Minute Taking course and take a step toward a brighter future! Why Prefer this Effective Minute Taking Course? Opportunity to earn a 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 the Effective Minute Taking Training course: Module 01: Introduction to Minute Writing Introduction Terms of Minute Taking The Cycle of Meeting The Stage in Cycle The Participants The Chairperson The Minute Taker Those Attending the Meeting Summary Module 02: Preparation for Minute Taking Write Meeting Minute Pre Meeting Preparation During Meeting Dealing with a Confused Situation Conversation Veers Off Track Use a Meeting Minutes Template to Save Time Post Meeting Summary Module 03: The Meeting Structure Introduction Apologies Declaration of Interest Committee Business Minutes of Previous Meeting Matter Arising Report Any Other Business Next Date of Meeting Summary Module 04: Minute Meeting, Decision, and Action The Purpose of Minute Taking Effective Minute Takers Importance of Writing The Action Triangle When There Is No Outcome Layout of Action Points When There Are Several Actions for One Minute Summary Module 05: Roles and Responsibility of Minute Taker Before Meeting During Meeting After Meeting Task Involved in Minute Taking Skills Required What Should Be Written (also add "More on what you write down" section Here) Sort Out the Basics A record at Every Meeting Keeping Clear Notes Producing the Finished Version Agreeing the Minutes Some Common Problem Some Solution Summary Module 06: Tips for Minute Taking Introduction Lay the Groundwork Know the Purpose Get the Agenda Choose Your Method All Systems Go Leave Space in Which to Work Here, Here Have a Seating Chart Know Everyone's Position Create a Minutes Template Listen with Care Just the Facts Keep it Clear and Simple Be Exact Noting Motions What's on Hold Adding Your Voice Summary Module 07: Technology in Minute Taking Introduction Taking Minute Manually is Time-Consuming Technology Solves Security Issues Technological Offerings for Boards Streamline Minute Taking Software Solution Summary Module 8: Building Confidence Creating the Right Impression Get to know everyone Coping with put-downs Know your place Summary Assessment Process Once you have completed all the modules in the course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Effective Minute Taking course is suitable for: Anyone who is responsible for taking minutes during meetings Individuals who frequently attend meetings and want to improve their note-taking abilities Managers and team leaders who want to ensure their staff are equipped with the necessary skills to take minutes accurately and efficiently Requirements Enrol in the Effective Minute Taking Training with no formal entry requirements! Career path Administrative Assistant: £18,000 - £24,000 per annum Executive Assistant: £25,000 - £35,000 per annum Personal Assistant: £22,000 - £32,000 per annum Project Coordinator: £20,000 - £30,000 per annum Office Manager: £24,000 - £38,000 per annum Secretary: £18,000 - £27,000 per annum Certificates Certificate Accredited by CPDQS Digital certificate - £10 Certificate Accredited by CPDQS Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Become a financial crime prevention superhero with LGCA’s help! Pick up everything you need to know to join a company’s AML function and start fighting crime with your newfound knowledge and skills. The Certificate in AML provides participants with a thorough understanding of what constitutes Money Laundering (ML) and how financial institutions should respond to increasingly complex attempts by criminal individuals and entities to process proceedings from illegal activities in a manner that enables them to enjoy such illegal proceedings. Study method Online, self-paced Duration 25 hours Access to content 360 days Certification Certificate in Anti Money Laundering (AML) Additional info Exam(s) / assessment(s) is included in price Description About the Certificate Participants will investigate what is ML, what constitutes a risk-based approach in dealing with ML and the relevant policies and procedures that may be adopted by a financial institution as part of a coherent AML Strategy. In addition, participants will be provided with an overall assessment of international economic sanctions and how these are valuable tools in combating ML. The Certificate also offers participants, a practical perspective of how AML attempts have been formally incorporated and have led to the creation of legal frameworks that aim to prevent ML practices. The knowledge obtained by undertaking this Certificate is an invaluable asset for professionals that seek to enhance their career prospects in AML which is becoming an increasingly significant issue for financial institutions. Topics covered • Money laundering methods, techniques, red flags, key risk areas and compliance best practices & checklists • KYC and CDD: Beneficial ownership, money laundering risks in gatekeeper roles, politically exposed persons, and much more • Economic Sanctions and relevant frameworks • Vulnerabilities of Financial Institutions • Legal Framework for AML – A practical perspective • Case Studies and analysis Expected Learning Outcomes • Identify ML-related risks and dangers that need to be dealt with through a rigid AML strategy • Understand ML risk assessment and management and learn how to design a comprehensive AML risk-based approach • Review the relevant processes and procedures that need to be adopted as part of an AML strategy • Gain a practical perspective through a review of the relevant legal framework that covers AML • Understand the importance of sanctions and how these can be utilised as a tool to combat ML Format • Register at any time • Study in your own time and at your own pace (you have up to 3 months to complete the Certificate) • Assessed by an online multiple-choice exam What is included • 25 hours of self-paced online interactive learning including analysis of 5 practical case studies • 1-year free AGRC membership • Online Exam and AGRC Certificate Completion Requirements • Success in all the unit tests. Each unit is allocated two, three or four Multiple Choice questions (MCQs). In total 33 MCQs with a pass mark of 70% and an unlimited number of attempts. Each unit test is 10 minutes. • Success in the final test of 40 MCQs for the completion and award of the Certificate in Anti Money Laundering, issued by the Association of Governance, Risk and Compliance (AGRC). The pass mark is 70% and two attempts are permitted. The final test is 60 minutes. Who is this course for? Individuals who aspire to a career in AML, staff with specific anti-money laundering duties and staff working in financial services who want a comprehensive training in AML. No previous knowledge or experience is required although it is assumed that participants have good knowledge of English and a sound education background. Requirements No previous knowledge or experience is required though it is assumed that participants have good knowledge of English and sound educational background. Career path AML Officer, MLRO, Head of Back Office, Compliance Officer, Risk Manager, Manager, Director

[vc_row][vc_column][vc_column_text] Description: Want to know how to develop self-discipline, resist temptations and reach your long-term goals? If you want to make positive changes in your life and achieve your life ambitions, this online course will teach you how to become a master at self-discipline. Self-Discipline is the key to success in life. Whether at school, in the workplace or at home, our life would fall into chaos and meaninglessness without discipline. This Mastering Self Discipline Course is the ultimate guide to self-discipline and will equip you with the practical skills you need to keep your life in order. In this course, you will learn how to organise your office, declutter your wardrobe, create an effective daily routine and add structure to your day-to-day life. You will also be introduced to time-saving strategies for the home and setting ground rules for your kids. Who is the course for? Individuals who are interested in bettering themselves Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be ages 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Mastering Self Discipline is a useful qualification to possess, and would be beneficial for the following careers: Entrepreneurs teacher sales manager call center manager. [/vc_column_text][/vc_column][/vc_row] Mastering Self Discipline Why Get Organized? 00:20:00 How To Get Rid Of Clutter 00:25:00 Cleaning Out Your Closets 00:25:00 The Importance Of Routines 00:20:00 Papers And Pictures 00:15:00 Helpful Gadgets That Make Home Organizing Easier 00:10:00 Top Ten Tips On Saving Time Every Day 00:25:00 How To Organize Your Office 00:15:00 Using The Computer To Help Staying Organized 00:20:00 Helping Your Kids To Stay Organized 00:20:00 Mock Exam Mock Exam- Mastering Self Discipline 00:20:00 Final Exam Final Exam- Mastering Self Discipline 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF 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 Microsoft Excel 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 Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel 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 Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum 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:10: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:23: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:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07: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:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19: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:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00

Ready to discover the magic of a clean home and a clear mind? Our course, "Benefits of Housecleaning," is your ultimate guide to transforming your space into a sanctuary. From kitchen cleaning to organising a kid's room, this course covers everything you need to know to keep your home spotless and your mind clutter-free. Enrol today and start reaping the benefits of a clean home and a clear mind! Learning outcomes: Understand the importance of housekeeping for physical and mental health. Learn about the different cleaning equipment and ingredients required for efficient house cleaning. Gain knowledge on cleaning techniques for various areas of the home, such as the kitchen, bedroom, living room, bathroom, and home office. Discover tips and tricks for organising and decluttering your space to reduce stress and anxiety. Develop a routine for maintaining a clean and organised home. Appreciate the positive impact of a clean home on overall well-being. Are you tired of living in a messy and cluttered home? Our "Benefits of Housecleaning" course is here to help! This comprehensive course is designed to teach you everything you need to know about housekeeping and its benefits for physical and mental health. The course comprises eight modules covering a range of topics, including cleaning equipment, ingredients, and techniques for various areas of the home. You'll learn how to clean and organise a kid's room, home office, bathroom, and more. Plus, you'll gain insight into the positive impact of a clean and organised home on reducing stress and anxiety. By the end of the course, you'll have the skills and knowledge needed to maintain a clean and clutter-free home. And the best part? You'll experience the mental and physical benefits of a clean home, such as increased productivity, improved sleep, and reduced stress. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone looking to improve their physical and mental well-being through a clean and organised home. Those who want to learn about housekeeping techniques and routines for maintaining a clean home. Individuals who struggle with clutter and disorganisation. People who want to reduce stress and anxiety in their home environment. Career path Housekeeper (£14,000 - £22,000 per year) Cleaner (£8,000 - £19,000 per year) Housekeeping supervisor (£18,000 - £25,000 per year) Hotel housekeeping (£16,000 - £22,000 per year) Private household cleaner (£10 - £15 per hour) Domestic assistant (£13,000 - £18,000 per year)