4456 Courses delivered On Demand

Are you ready to embark on an enlightening journey of wisdom with the Data Analysis bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analysis with SQL & Tableau for Data Analytics. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Introduction to Data Analytics with Tableau Course 2: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 3: Big Data Analytics with PySpark Power BI and MongoDB Course 4: Google Data Studio: Data Analytics Course 5: SQL for Data Science, Data Analytics and Data Visualization Course 6: Business Analysis Course Level 5 Course 7: Financial Analysis Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analysis with SQL & Tableau for Data Analytics bundle illuminate your path to wisdom. The Data Analysis with SQL & Tableau for Data Analytics bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analysis with SQL & Tableau for Data Analytics package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analysis bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analysis with SQL & Tableau for Data Analytics community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analysis with SQL & Tableau for Data Analytics Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analysis bundle. Establish robust bases across each course nestled within the Data Analysis bundle. Decipher intricate concepts through the articulate content of the Data Analysis bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analysis with SQL & Tableau for Data Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analysis bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analysis with SQL & Tableau for Data Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analysis bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analysis bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analysis journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analysis with SQL & Tableau for Data Analytics Bundle. Career path Armed with the Data Analysis with SQL & Tableau for Data Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analysis bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Are you ready to embark on an enlightening journey of wisdom with the Journalism bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Newspaper Journalism & Court Reporting. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Newspaper Journalism Course 02: Report Writing Course 03: Digital Journalism Course 04: Diploma in Effective Writing Skills Course 05: Proofreading & Copyediting Course 06: Ultimate Transcription and Captioning Course Course 07: Touch Typing Essentials Course 08: Document Control Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Newspaper Journalism & Court Reporting bundle illuminate your path to wisdom. The Newspaper Journalism & Court Reporting bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Newspaper Journalism & Court Reporting package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Journalism bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Newspaper Journalism & Court Reporting community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Journalism bundle. Establish robust bases across each course nestled within the Journalism bundle. Decipher intricate concepts through the articulate content of the Journalism bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Journalism bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Journalism bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Journalism bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Journalism bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Journalism bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Journalism journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Journalism bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Journalism bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Trouble sleeping? You’re not broken—you’re just overstimulated. Evening Yoga Rituals for Deep Sleep Training helps you quiet the chaos, release the day, and settle into the kind of rest your body actually needs. This course isn’t about productivity. It’s about peace. And once you try Evening Yoga Rituals for Deep Sleep Training, your nights—and mornings—may never be the same. Description If falling asleep feels like another task, you’re not alone. That’s why Evening Yoga Rituals for Deep Sleep Training focuses on what actually works: slowing your system down, not pushing it harder. This self-paced experience gently guides you toward deep, nourishing rest through intentional stillness. No routines to memorize. No strict timelines. Just simple rituals inside Evening Yoga Rituals for Deep Sleep Training that invite you to soften and let go. And the best part? You don’t need to commit to long hours or intensive sessions. Evening Yoga Rituals for Deep Sleep Training meets you in the space between “just got home” and “ready for rest.” Benefits ✅ Reclaim your nights with Evening Yoga Rituals for Deep Sleep Training. ✅ Simple, calming practices designed to guide you toward better sleep. ✅ A no-pressure way to signal “day over” to your nervous system. ✅ Sleep deeper and wake with more clarity. ✅ Say goodbye to scrolling before bed. ✅ Fits seamlessly into your evening without effort. ✅ Permanent access to Evening Yoga Rituals for Deep Sleep Training, so you can return whenever sleep feels far away. FAQ Q: Is this just meditation or full yoga sessions? Evening Yoga Rituals for Deep Sleep Training includes calming rituals—think less “fitness” and more “relaxation.” Q: Do I need to do this at the same time every night? Nope. Evening Yoga Rituals for Deep Sleep Training is flexible and forgiving—perfect for varied schedules. Q: What if I fall asleep during it? That’s a win. Evening Yoga Rituals for Deep Sleep Training is designed to ease you into sleep. Q: Is this suitable for beginners or people with low energy at night? Yes. Evening Yoga Rituals for Deep Sleep Training was made with low-energy evenings in mind. N:B: This is not a Naked Yoga Course

Elevate your career with our Receptionist course! Gain mastery in communication, front desk management, scheduling, and more. Become an office cornerstone. Enrol now!

Are you looking to enhance your Diploma for Business Administrators skills? If yes, then you have come to the right place. Our comprehensive course on Diploma for Business Administrators will assist you in producing the best possible outcome by mastering the Diploma for Business Administrators skills. The Diploma for Business Administrators is for those who want to be successful. In the Diploma for Business Administrators, you will learn the essential knowledge needed to become well versed in Diploma for Business Administrators. Our Diploma for Business Administrators starts with the basics of Diploma for Business Administrators and gradually progresses towards advanced topics. Therefore, each lesson of this Diploma for Business Administrators is intuitive and easy to understand. Why would you choose the Diploma for Business Administrators from Compliance Central: Lifetime access to Diploma for Business Administrators materials Full tutor support is available from Monday to Friday with the Diploma for Business Administrators Learn Diploma for Business Administrators skills at your own pace from the comfort of your home Gain a complete understanding of Diploma for Business Administrators Accessible, informative Diploma for Business Administrators learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Diploma for Business Administrators bundle Study Diploma for Business Administrators in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Diploma for Business Administrators Improve your chance of gaining in demand skills and better earning potential by completing the Diploma for Business Administrators Diploma for Business Administrators Curriculum Topics: Module 01: Introduction Module 02: Business Plan for Entrepreneurs Achieve Your Long- and Short-Term Goals Module 03: How a Business Plan Can Help with Long Term Success Module 04: Reasons You Need Module 05: The Elements Module 06: The Purpose Module 07: Things to Consider Before Starting Module 08: Who Are You Writing the Business Plan For CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Diploma for Business Administrators helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Diploma for Business Administrators. It is also great for professionals who are already working in Diploma for Business Administrators and want to get promoted at work. Requirements To enrol in this Diploma for Business Administrators, all you need is a basic understanding of the English Language and an internet connection. Career path The Diploma for Business Administrators will enhance your knowledge and improve your confidence. Administrative Assistant: £20,000 to £25,000 per year Office Administrator: £22,000 to £28,000 per year Personal Assistant (PA): £24,000 to £35,000 per year Executive Assistant: £28,000 to £40,000 per year Office Manager: £28,000 to £40,000 per year Human Resources Administrator: £25K to £32K per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Overview This comprehensive course on Financial Modeling Using Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Modeling Using Excel comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Financial Modeling Using Excel. It is available to all students, of all academic backgrounds. Requirements Our Financial Modeling Using Excel is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 9 lectures • 01:31:00 total length •Welcome to the Course! Get the Overview of What You'll Learn: 00:04:00 •Planning your Financial Model: 00:09:00 •Building a Model Template: 00:12:00 •Projecting the Income Statement: 00:13:00 •Projecting the Balance Sheet: 00:17:00 •Projecting Cash Flows: 00:14:00 •Advanced Financial Modeling: 00:14:00 •BONUS LESSON: Top 5 Excel Features for Financial Modellers: 00:08:00 •Resources - Financial Modeling Using Excel: 00:00:00

Overview This comprehensive course on Excel Pivot Tables will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Pivot Tables. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 18 lectures • 00:47:00 total length •Excel Pivot Tables: 00:03:00 •Overview about Store Dataset: 00:02:00 •Data Insights: 00:02:00 •Sales Profit Summary: 00:03:00 •Highlight the Data: 00:01:00 •Unprofitable Products: 00:02:00 •Create Crosstabs: 00:02:00 •Select Regions for Unprofitable Products: 00:04:00 •Real Time Analytics and Insights: 00:02:00 •Search Data for States with Slicers: 00:06:00 •Finding Trends: 00:02:00 •Find Data for Specific Date: 00:04:00 •Reporting Made Easy: 00:02:00 •Generate Reports with Pivot Tables: 00:04:00 •Marketing Analytics: 00:02:00 •Target Your Advertisements: 00:05:00 •Become Analyst: 00:01:00 •Assignment - Excel Pivot Tables: 00:00:00

🏥 Unlock Your Future in Healthcare with Medical Transcription Training! Are you ready to embark on a rewarding journey into the world of healthcare documentation? Look no further than our comprehensive Medical Transcription Training course! 🚀   What is Medical Transcription? Medical transcription is a vital component of the healthcare industry, involving the conversion of voice-recorded medical reports dictated by healthcare professionals into written text. These documents serve as crucial records for patient histories, diagnoses, treatments, and more.   Why Choose Medical Transcription Training? By enrolling in our course, you'll gain the essential skills and knowledge needed to excel in this specialized field. 📝 From mastering medical terminology to honing your typing speed and accuracy, we cover it all! Our expert instructors provide hands-on training, equipping you with the tools to transcribe accurately and efficiently.   Benefits of Our Course: Flexible Learning: Access our course materials online, allowing you to study at your own pace and convenience. Industry-Relevant Curriculum: Learn from real-world examples and scenarios, preparing you for the demands of the job. Career Advancement Opportunities: With a shortage of skilled medical transcriptionists, there's a high demand for qualified professionals in hospitals, clinics, and transcription companies. Work-Life Balance: Enjoy the flexibility of remote work, allowing you to achieve a better work-life balance. Competitive Earning Potential: Medical transcriptionists often enjoy competitive salaries and benefits, making it a financially rewarding career choice.   Who is this for? Our Medical Transcription Training course is perfect for anyone interested in a career in healthcare administration or those seeking a flexible work-from-home opportunity. Whether you're a recent graduate, a stay-at-home parent looking to re-enter the workforce, or someone looking for a career change, this course is tailored to meet your needs.   Career Path: Upon completion of our training program, you'll be well-equipped to pursue various career paths in medical transcription. Some potential roles include: Medical Transcriptionist: Work directly for healthcare facilities or transcription companies, transcribing medical reports accurately and efficiently. Editor/Proofreader: Ensure the accuracy and quality of transcribed documents by reviewing and editing them for errors. Medical Language Specialist: Specialize in specific medical fields such as radiology, pathology, or cardiology, becoming an expert in specialized terminology. Freelancer: Enjoy the flexibility of working as an independent contractor, providing transcription services to multiple clients.   Conclusion: Don't miss out on the opportunity to kickstart your career in healthcare with our Medical Transcription Training course! Whether you're passionate about healthcare or seeking a flexible and rewarding career, this course is your gateway to success. Enroll today and take the first step towards a brighter future! 💼👩‍️👨‍️   FAQs 1. What is Medical Transcription? Medical transcription is the process of converting voice-recorded medical reports dictated by healthcare professionals into written text. These transcribed documents serve as important records for patient care, including diagnoses, treatments, and other pertinent medical information. 2. What skills are required for Medical Transcription? To excel in medical transcription, individuals should possess strong typing skills, excellent grammar and punctuation proficiency, and a solid understanding of medical terminology. Attention to detail, time management, and the ability to work independently are also essential attributes for success in this field. 3. Is Medical Transcription a viable career option? Yes, medical transcription offers a range of career opportunities with the potential for growth and advancement. As the healthcare industry continues to expand, there is a consistent demand for skilled medical transcriptionists in hospitals, clinics, transcription companies, and as freelancers. 4. Can I work remotely as a Medical Transcriptionist? Absolutely! Many medical transcriptionists enjoy the flexibility of remote work, allowing them to transcribe medical documents from the comfort of their own homes. This remote work option provides greater flexibility and work-life balance for individuals seeking more control over their schedules. 5. How long does it take to complete Medical Transcription Training? The duration of Medical Transcription Training can vary depending on the program and individual learning pace. Generally, courses can range from several weeks to a few months. However, our flexible online training allows you to study at your own pace, ensuring that you grasp the material thoroughly before advancing. 6. What are the career advancement opportunities in Medical Transcription? Upon completing Medical Transcription Training, individuals can pursue various career paths within the field. These include roles such as medical transcriptionists, editors/proofreaders, medical language specialists, and freelancers. Additionally, continued education and specialization in specific medical fields can lead to further career advancement opportunities. 7. Is certification necessary for a career in Medical Transcription? While certification is not always mandatory, obtaining certification from recognized organizations can enhance your credibility and job prospects in the field of medical transcription. Certification programs typically require passing an examination and meeting specific educational and experience requirements. 8. How can I enroll in the Medical Transcription Training course? Enrolling in our Medical Transcription Training course is easy! Simply visit our website and follow the enrollment instructions. Once enrolled, you'll gain access to our comprehensive course materials and expert instruction, setting you on the path to a successful career in medical transcription. Course Curriculum Module 1_ Introduction to Medical Transcription. Introduction to Medical Transcription. 00:00 Module 2_ Medical Transcription Techniques and Methods. Medical Transcription Techniques and Methods. 00:00 Module 3_ Medical Transcription Troubleshooting and Problem-Solving. Medical Transcription Troubleshooting and Problem-Solving. 00:00 Module 4_ Medical Transcription Time and Task Management. Medical Transcription Time and Task Management. 00:00 Module 5_ Medical Transcription Review and Editing. Medical Transcription Review and Editing. 00:00

🌟 Unlock Your Potential with the Medical Receptionist Course! 🌟 Are you ready to embark on a rewarding career in the healthcare industry? Look no further! Our comprehensive Medical Receptionist Course equips you with the essential skills and knowledge needed to thrive in this dynamic field. Whether you're a seasoned professional looking to enhance your expertise or a newcomer eager to break into the healthcare sector, this course is your gateway to success.   Why Choose the Medical Receptionist Course? 👩‍️ In-Demand Skills: Medical receptionists play a crucial role in healthcare facilities, serving as the first point of contact for patients and visitors. By enrolling in our course, you'll learn how to effectively manage front desk operations, handle patient inquiries, schedule appointments, and maintain organized medical records. 💼 Career Advancement: With healthcare facilities continually seeking skilled professionals to manage their administrative tasks, completing our Medical Receptionist Course opens up a world of opportunities. Whether you aspire to work in hospitals, clinics, or specialized medical practices, this course provides you with the credentials and confidence to excel in your career. 📚 Comprehensive Curriculum: Our course covers a wide range of topics, including medical terminology, appointment scheduling software, patient confidentiality laws, and customer service best practices. Taught by industry experts, you'll gain practical insights and real-world experience that are invaluable in the healthcare field. 💡 Flexible Learning Options: We understand that balancing work, family, and education can be challenging. That's why our Medical Receptionist Course offers flexible learning options, allowing you to study at your own pace and from the comfort of your own home. Whether you prefer to learn through interactive modules, video lectures, or written assignments, we've got you covered. 🎓 Industry-Recognized Certification: Upon successful completion of the course, you'll receive a prestigious certificate that demonstrates your proficiency as a medical receptionist. This credential not only enhances your credibility but also increases your chances of landing your dream job in the healthcare industry.   Who is this for? Our Medical Receptionist Course is perfect for individuals who are passionate about healthcare and possess strong interpersonal and organizational skills. Whether you're a recent high school graduate exploring career options or a professional seeking a career change, this course provides you with the necessary foundation to thrive in the medical field.   Career Path Upon completing the Medical Receptionist Course, you'll be well-equipped to pursue various career paths within the healthcare industry. Some potential roles include: 🏥 Medical Receptionist: Work in hospitals, clinics, or medical offices, where you'll greet patients, schedule appointments, and manage administrative tasks. 💼 Medical Administrative Assistant: Assist healthcare professionals with administrative duties, such as billing, coding, and insurance processing. 👩‍💼 Patient Services Representative: Serve as a liaison between patients and healthcare providers, ensuring their needs are met and concerns addressed. 📋 Medical Records Technician: Maintain accurate and confidential medical records, ensuring compliance with regulatory standards and privacy laws. With the demand for skilled medical receptionists on the rise, now is the perfect time to invest in your future and embark on a rewarding career in healthcare. Enroll in our Medical Receptionist Course today and take the first step towards a brighter tomorrow! FAQs Q: Is previous experience required to enroll in the Medical Receptionist course? A: No prior experience is necessary to enroll in the course. Our program is designed to cater to individuals at all skill levels, from beginners to experienced professionals. Q: How long does it take to complete the course? A: The duration of the course may vary depending on the learning format and individual pace. Typically, students can complete the program within a few months with full-time study or opt for part-time options to fit their schedule. Q: Will I receive a certification upon completion of the course? A: Yes, upon successfully completing the Medical Receptionist course, you will receive a certification that demonstrates your proficiency in medical office procedures, patient management, and healthcare administration. Q: Can I pursue further education after completing the Medical Receptionist course? A: Absolutely! Our course provides a solid foundation for those interested in advancing their career in healthcare administration. Many students choose to pursue additional certifications or degrees to enhance their skills and qualifications. Course Curriculum Module 1 Understanding the Role of a Medical Receptionist Understanding the Role of a Medical Receptionist 00:00 Module 2 Medical Terminology and Anatomy Medical Terminology and Anatomy 00:00 Module 3 Patient Data Management and Confidentiality Patient Data Management and Confidentiality 00:00 Module 4 Customer Service and Patient Care Customer Service and Patient Care 00:00 Module 5 Interpersonal Skills and Communication Interpersonal Skills and Communication 00:00

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type