9769 Office courses

This course intends to introduce the factors which affect the proper undertaking of a meeting and explains what to do before, during and after meetings to get the desired outcomes rather than more meetings. In this course, you will understand the value of meetings as a management tool and identify the crucial planning steps that make the meetings more effective as well as productive. The modules include essential, proven tactics for dealing with disruptions and handling common obstacles related to meetings that mostly appear in workplaces. You will also discover foolproof tips that will enable you to consider a variety of meeting-related issues and design solutions to each. In just 2 Hours, 55 Minutes, you will: Understand the planning and preparation needed for setting up the meeting space Determine the roles and responsibilities of the participants Lead meetings efficiently and make the most of your meetings Be able to create useful minutes of meetings Obtain the maximum effectiveness, gain the desired goals in the minimum possible time Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 assessment 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. This qualification is ideal for: Minute Takers Secretaries Receptionists Managers Leaders Office Executives Assistant Managers Office Administrators Employees Course Content Meeting Management - Updated Version Planning and Preparation 00:17:00 Online Meeting Platforms Part - 01 01:04:00 Online Meeting Platforms Part - 02 00:44:00 Meeting Etiquette and Tips 00:15:00 Meeting Management - Old Version Meeting Management Module - One Getting Started 00:10:00 Module Two - Planning and Preparing (I) 00:10:00 Module Three - Planning and Preparing (II) 00:15:00 Module Four - Setting up the Meeting Space 00:15:00 Module Five - Electronic Options 00:10:00 Module Six - Meeting Roles and Responsibilities 00:10:00 Module Seven - Chairing a Meeting (I) 00:10:00 Module Eight - Chairing a Meeting (II) 00:10:00 Module Nine - Dealing with Disruptions 00:10:00 Module Ten - Taking Minutes 00:10:00 Module Eleven - Making the Most of Your Meeting 00:15:00 Module Twelve - Wrapping Up 00:10:00 Activities Meeting Management - Activities 00:00:00 Mock Exam Mock Exam - Meeting Management 00:20:00 Final Exam Final Exam - Meeting Management 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 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.

Duration 2 Days 12 CPD hours This course is intended for A Dynamics 365 for Finance and Operations Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements a solution using out of the box capabilities, codeless extensibility, application and service integrations. Overview This course provides the practical knowledge to Navigate and efficiently use search, filtering and queries Use operational workspaces Work with Business Document Management Work with record templates Integrate Power BI with Dynamics 365 Finance and Operations apps Personalize workspaces Run and analyze security reports Create and use workflow for approval Work with Organization Hierarchy and its purposes. How to use personalization feature Use Data Management workspace Create and use and entity templates Import and export data and manage data by using Office Integration Dynamics 365 Finance and Operations apps include, but are not limited to, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. This foundational course provides students with the important first steps in automating and modernizing both global financial and supply chain operations. USE COMMON FUNCTIONALITY AND IMPLEMENTATION TOOLS Introduction Identify and use common Dynamics 365 Finance and Operations apps features and functionality Describe use cases for Power Platform apps and services Module Summary CONFIGURE SECURITY, PROCESSES, AND OPTIONS Introduction Implement security Design and create workflows Configure Organization administration features Configure System administration features Module Summary MANAGE DYNAMICS 365 FINANCE AND OPERATION DATA Introduction Manage data in Dynamics 365 Finance and Operations apps Plan a migration strategy Prepare data for migration and migrate data Module Summary VALIDATE AND SUPPORT THE SOLUTION Introduction Test solutions in Dynamics 365 Finance and Operations apps Implement Lifecycle Services tools Module Summary Additional course details: Nexus Humans MB-300T00 Microsoft Dynamics 365: Core Finance and Operations 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 MB-300T00 Microsoft Dynamics 365: Core Finance and Operations 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.

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

This course provides a thorough introduction to creativity and innovation and delivers a firm understanding of how the creative process works and how ideas are generated by using creative thinking techniques. In this course, you will learn how to be more creative through developing the right environment and how creativity and innovation lead to success in business. The course modules also explain how to use and apply creative thinking techniques to develop new perspectives, generate new ideas and resolve practical problems. In just 2 Hours, 35 Minutes, you will: Understand the creative process and how to think and work more creatively Be able to generate new perspectives and ideas Solve real problems and enhance decision making Maximise innovative thinking and creativity Learn the tricks that make it easier to be more innovative every single day Encourage creativity and innovation in the workplace and beyond Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 assessment 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. This qualification is ideal for: Managers Team Leaders Office Executives Office Administrators Employees Businesspeople Secretaries Receptionists Course Content Creative Thinking and Innovation Course Overview 00:05:00 What Is Creativity and Innovation? 00:05:00 Individual Creativity 00:10:00 Developing the Right Environment for Creativity 00:10:00 Creativity and Innovation in Business 00:05:00 Where Does Creativity Fit Into the Problem-Solving Process? 00:15:00 Defining the Problem 00:15:00 Creative Techniques 00:25:00 Encouraging Creativity In A Team 00:20:00 Putting It All Together 00:05:00 Mock Exam Mock Exam - Creative Thinking and Innovation 00:20:00 Final Exam Final Exam - Creative Thinking and Innovation 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 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.

Microsoft Excel® in Depth (In-Person) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Course Overview: About 87% of global consumers use at least one computer or device to access the internet daily. Mastering the essentials of computer and the internet is crucial in today’s digital age. The Learning Computer and Internet Level 2 course provides an in-depth exploration of computer systems, internet functionalities, and software applications, offering you the knowledge to navigate the digital world with ease. This course covers a wide range of computer-related topics, from fundamental operating systems and hardware to advanced concepts like cybersecurity and data protection. With engaging, interactive content, you’ll gain practical skills and insights that enhance your computer proficiency and digital competence. Embark on an enlightening journey through the digital landscape. Enrol in Learning Computer and Internet Level 2 today and elevate your computer skills to thrive in a connected world! Key Features of the Course: FREE Learning Computer and Internet Level 2 CPD-accredited certificate Get a free student ID card with Learning Computer and Internet Level 2 training (£10 applicable for international delivery) Lifetime access to the Learning Computer and Internet Level 2 course materials The Learning Computer and Internet Level 2 program comes with 24/7 tutor support Get instant access to this Learning Computer and Internet Level 2 course Learn Learning Computer and Internet Level 2 training from anywhere in the world The Learning Computer and Internet Level 2 training is affordable and simple to understand The Learning Computer and Internet Level 2 training is entirely online Who is This Course For? This course is designed for individuals seeking to build upon foundational knowledge of computer and the internet. Whether a student, professional, or enthusiast, this course will elevate your proficiency. Learning Outcome Grasp the intricacies of various operating systems and their configurations. Understand the diverse range of applications and their functionalities. Navigate through storage solutions, network components, and software tools. Comprehend the concept of licensing and its implications. Become adept in word processing, spreadsheets, and creating presentations. Learn the terminologies of networking, ensuring smooth connectivity. Safeguard yourself online and understand the fundamentals of digital security. Acquire skills to use browsers, e-mails, and collaborative platforms effectively. Why Enrol in This Course: Enrolling in "Learning Computer and Internet Level 2" is your gateway to a world of opportunities and possibilities. You will develop essential skills in high demand across various industries, making you a valuable asset in the job market. Our course is top-reviewed, recently updated to reflect the latest trends, and aligns with the evolving digital landscape, ensuring you stay ahead in the digital race. Requirements: Enrolling in this Learning Computer and Internet Level 2 course requires a basic understanding of computer usage. No prior technical knowledge is needed, making it accessible to beginners and those looking to refresh their skills. Career Path: Upon completing this Learning Computer and Internet Level 2 course, you'll be well-equipped to pursue various professions in the digital domain. Here are seven course-related professions in the UK, along with their average salaries: IT Support Specialist: £25,000 - £40,000 per year Data Entry Clerk: £18,000 - £25,000 per year Digital Marketing Assistant: £20,000 - £30,000 per year Office Administrator: £18,000 - £25,000 per year Cybersecurity Analyst: £30,000 - £50,000 per year Web Developer: £25,000 - £45,000 per year Database Administrator: £30,000 - £50,000 per year Certification: Upon completing the Learning Computer and Internet Level 2 course, learners will be awarded a CPD certificate, validating their enhanced knowledge of computer and the Internet. Course Curriculum 6 sections • 81 lectures • 22:23:00 total length •What is an Operating System: 00:48:00 •Configuring the Operating System: 00:06:00 •What is an Application: 00:10:00 •Using Control Panel: 00:18:00 •Hardware and Peripherals: 00:07:00 •Storage: 00:12:00 •Connectivity Devices: 00:05:00 •Network Components: 00:09:00 •Software and Concepts: 00:11:00 •Licensing: 00:06:00 •Using Software: 00:07:00 •Software Tools: 00:10:00 •Software: 00:14:00 •Hardware, Devices, and Peripherals: 00:05:00 •Backup and Restore: 00:03:00 •Application Features: 01:21:00 •Working with Word Processing: 00:44:00 •Working with Spreadsheets: 00:49:00 •Making a Presentation: 01:08:00 •Databases: 00:34:00 •Collaboration: 00:03:00 •Course Introduction: 00:02:00 •Web Browsers: 00:46:00 •Networking Terminology: 00:35:00 •E-mail: 00:38:00 •Communicating in the Modern World: 00:14:00 •Protecting Yourself: 00:15:00 •Web Searching: 00:31:00 •Protecting Yourself: 00:31:00 •Identify Components of a Personal Computer IPU: 00:08:00 •Sign In to Windows 8: 00:07:00 •Signing In to Windows 8 and Managing Tiles: 00:08:00 •Navigate the Start Screen: 00:18:00 •Using the Account ID Menu: 00:02:00 •Access and Identify the Charms: 00:03:00 •Viewing the Charms: 00:02:00 •Modern Apps and Common Navigation Features: 00:03:00 •Navigating a Modern App: 00:07:00 •Multitasking with Apps: 00:05:00 •Working with Multiple Apps: 00:05:00 •Navigate the Desktop IPU: 00:07:00 •Navigating The desktop: 00:07:00 •Manage Files and Folders with File Explorer IPU: 00:09:00 •Managing Files and Folders: 00:15:00 •Elements of a Desktop Window: 00:12:00 •Working with the Elements of a Desktop Window: 00:10:00 •Creating and Modifying Files with Wordpad: 00:14:00 •Printing a Document: 00:05:00 •Navigate Internet Explorer 10: 00:08:00 •Navigating Internet Explorer 10: 00:09:00 •Browse the Web: 00:12:00 •Using Internet Explorer and Share: 00:08:00 •Customize the Start Screen: 00:07:00 •Creating Groups on the Start Screen: 00:03:00 •Changing PC Setting: 00:07:00 •Customize the Desktop IPU: 00:09:00 •Personalizing the Desktop: 00:11:00 •Set Privacy Levels and Passwords: 00:05:00 •Changing Your Password: 00:05:00 •Use Windows Defender IPU: 00:05:00 •Changing Windows Defender Settings: 00:06:00 •Store and Share Files with SkyDrive: 00:03:00 •What Makes Windows 10 Different?: 00:14:00 •Primary Feature Overview: 00:14:00 •Navigating and Using Windows 10: 00:36:00 •Course Overview: 00:13:00 •Types of Security Threats: 00:29:00 •Social Engineering: 00:30:00 •Identity Theft: 00:29:00 •Data Classification: 00:28:00 •Types of Classifications: 00:18:00 •Protecting Your Digital Information: 00:45:00 •Password Management: 00:13:00 •Malware: 00:17:00 •Software Detection: 00:28:00 •Security from End-to-End: 00:26:00 •Secure E-mail Use: 00:21:00 •Secure Web Browsing: 00:29:00 •Piracy: 00:16:00 •Security Policies: 00:18:00 •Moving Forward: 00:12:00

Thinking about a job as a Digital Product Manager? The BCS Practitioner Certificate in Digital Product Management encourages individuals in both technical and non-technical product-related roles to develop the practical behaviours required to succeed in leading a product project or team.

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Dental nursing stands out as a pivotal field, blending patient care with technical expertise. There are over 40,000 registered dental nurses, playing a vital role in supporting dentists and ensuring patients receive optimal oral care. If you're passionate about patient care and have an interest in the dental field, this comprehensive Dental Nurse bundle could be your perfect gateway to a rewarding career. This Dental Nurse Bundle empowers you to become a qualified Dental Nurse, encompassing core dental principles, Dental Radiography skills, patient care techniques for Nursing Assistants, infection control best practices, and Medical Transcription tools. Invest in your healthcare career and have a positive impact on patients' oral health. This Dental Nurse Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Dental Nurse Course 02: Dental Radiography Course 03: Nursing Assistant Diploma Course 04: Medical Transcription Stepping into the role of a dental nurse is a journey filled with opportunities to have a significant impact on patient health and wellbeing. By completing the "Dental Nurse - CPD Accredited" course bundle, you not only enhance your employability but also join a community of healthcare professionals dedicated to excellence in dental care. Take the first step today and enrol in this comprehensive Dental Nurse Bundle! Learning Outcomes of Dental Nurse Bundle: Understand oral anatomy, physiology, and common dental conditions. Learn sterilisation techniques, instrument preparation, and chairside assistance. Develop expertise in dental radiography: take, process, and interpret dental X-rays. Understand community health initiatives and their role in oral healthcare. Learn medical terminology and effectively document patient care. Gain practical skills in patient care and clinical procedures. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Curriculum Breakdown Course 01: Dental Nurse Module 01: Introduction to Dental Assisting Module 02: General Dentistry Instruments Module 03: Dental Office Management Module 04: Oral Diagnosis, Treatment Planning and Dental Terminology Module 05: General Handling and Safety of Dental Materials in the Dental Office Module 06: Infection Control and Instruments Module 07: Dental Radiology Module 08: Paediatric Dentistry Module 09: The Professional Dental Assistant Module 10: Standards of Dental Practice in the UK Course 02: Dental Radiography Module 01: An Introduction To Radiographic Science Module 02: Dental Radiography Module 03: Radiological Physics Module 04: Radiobiology Module 05: Radiation Protection Module 06: The Digital Radiographic Image Course 03: Nursing Assistant Diploma Module 01: Introduction to Nursing Module 02: Working in Different Healthcare Settings Module 03: Legal, Standards and Professional Aspects of Ethical Practice: Part – 1 Module 04: Legal, Standards and Professional Aspects of Ethical Practice: Part – 2 Module 05: Effective Communication in Nursing Module 06: Health and Safety in Nursing Module 07: Hygiene in Nursing Module 08: Infection Control Module 09: Asepsis in Nursing Module 10: Medication Administration in Nursing Module 11: Understanding the Immune System in Nursing Module 12: Rest and Sleep Management in Nursing Module 13: Mobility and Immobility Issues of Patients in Nursing Module 14: Pain Management for Nurses Module 15: Nutrition in Nursing Module 16: Fluid and Electrolyte Balance Module 17: Assisting with Elimination Module 18: Oxygenation in Nursing Course 04: Medical Transcription Module 01: Introduction to Medical Transcription Module 02: The What, How, Who and Why of Medical Transcription Module 03: Understanding Medical Reports Module 04: Medical Language Boot Camp Module 05: Formatting: The Basics Module 06: Data Protection How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £52) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 45 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring dental nurses Nursing assistants Healthcare workers Career changers Dental staff Medical transcriptionists Please note: This course doesn't entitle you to practice as a professional in this specific field. Rather, this course will assist you in understanding the fundamentals so that you can improve your knowledge in the relevant field. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Dental Nurse - £18,000 to £25,000 Radiography Technician - £25,000 to £35,000 Nursing Assistant - £17,000 to £23,000 Medical Transcriptionist - £20,000 to £25,000 Dental Practice Manager - £24,000 to £40,000 Healthcare Administrator - £19,000 to £27,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Essential self-care for helping professionals New research gives us practical ways to prevent overwhelm or burnout in ourselves and others, manage workplace stress, avoid ‘compassion fatigue’ and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Really interesting and engaging online course with lots of tips to support ourselves and our clientsCOMPLEMENTARY THERAPIST Live Online Training – Join Emily Gajewski on Thursday 11th April 2024 to take some important time out for yourself, or to help those you support. Once you’ve booked your place we will email you confirmation and you will receive details of how to join the Zoom workshop the day before the event. Bonus Recording – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Can’t make this date? Then please register your interest below – and we’ll email you when a new date is available. To help others effectively, we need to have enough ‘spare capacity’, which means looking after our own wellbeing too – new research shows us how… Why you should take this course When our day-to-day jobs involve continually listening to other people’s emotional difficulties, how do we avoid being overwhelmed by them ourselves or succumbing to compassion fatigue? We are the ‘tool’ of our trade. It could be argued that we have a duty to those we work with to prioritise our own mental health and wellbeing so that we can give them the best possible service. This live online training events shows you how. ‘Burnout’ is commonly defined as a physical and emotional state caused by excessive or overwhelming workplace stress. This is often specifically related to work but of course feelings of burnout can be impacted or compounded by other life events and caring roles too. Even if we know good stress management techniques, this often isn’t enough. Burnout is a very common phenomena in the ‘helping professions’, A 2018 research review paper published in the Journal of Clinical Psychology analysed 30 years of research on this topic, involving 9,000 psychotherapists. Over half of the therapists they sampled reported “moderate-high levels of stress and burnout”. The good news is that burnout, overwhelm and empathy fatigue are not a given of working in roles where we are consistently exposed to others’ emotional pain. New research and insights into ‘buffering’ the impact of this work mean that we can consciously choose to put in safeguards to our own mental wellbeing, whilst also remaining connected and present with our clients. Emily Gajewski’s online course draws on her extensive experience of working as a therapist and clinical supervisor, in the NHS and privately, for over 20 years. Throughout the day she examines the many ways working in the caring professions can impact us personally and gives you a wealth of practical steps you can take to mitigate them. She also covers the most up-to-date guidance on keeping ourselves well and thriving in caring roles and will help you develop a realistic plan for your own continuing wellbeing. Excellent online training…. very insightful and thought provokingHILARY KEARNS, ACUPUNCTURIST What you will learn The latest research on how to prevent burnout in your working life How to identify burnout in ourselves and others – the warning signs you need to look out for Easy, practical steps to protect yourself in stressful work situations How to avoid ‘compassion fatigue’ Evidence based ‘top tips’ for optimal working practices to maintain your own wellbeing The Cycle of Stress – how to ‘work with it’ for optimal health An understanding of vicarious trauma – and how to avoid it Techniques to calm yourself in client sessions when you are ‘triggered’ by something they bring up Understanding the difference between compassion fatigue and empathy fatigue Reducing your own risk of depression when you’re worried about your clients The joy of creating ‘flow’ in our working life Constructive ways to manage difficult feelings that arise as a result of your work Practical techniques for grounding and ‘letting go’ of clients How to safely explore our own areas of vulnerability Useful tips for ongoing stress management What you need to maintain your own mental health How to re-ground yourself if you’re feeling overwhelmed or derailed by a client An opportunity for you to reflect on your own practice and wellbeing, take some time to step back, learn what works for you and how you can create more spare capacity Time to relax, try out techniques and refresh your tools to support your wellbeing and build resilience How to utilise what you’ve learnt to create your own realistic wellbeing plan. Very useful and practical. The term ‘burnout’ is become as over-used as ‘wellbeing’ and ‘stress’. This online course provides clarity on what the term ‘burnout’ means in reality ... with strategies to counter the effectsHEADTEACHER SUPPORT SERVICE COUNSELLOR Course Programme The ‘How to avoid burnout’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding Burnout and how to halt the journey towards it 11.00am Comfort break and discussion 11.30am Exploring practical self-care steps that can work for YOU! 1.00pm Lunch break 1.45pm How to manage difficult feelings that arise as a result of our work 2.45pm Comfort break and discussion 3.00pm Creating a plan for your own wellbeing 4.00pm Day ends Who this workshop is suitable for Anyone who works within a role that involves caring for others – including: medical professionals – including GPs and nurses health and social care professionals therapists and mental health workers counsellors educators, teachers professional carers (foster carers and non-paid carers) social workers occupational therapists outreach workers volunteers holistic practitioners etc. 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.