- Call Us: +1 833 990 1500 (Toll Free) (Mon - Fri, 7am - 3pm EST)
- Email Us: info@medical-webinars.com
Menu
Learn Microsoft Excel – Webinars Bundle
Recorded Webinar
“How do I look up a value in list ONE and pick up a related value from list TWO”
“How do I avoid my lookup formula displaying an ugly error when it can’t find a match?”
“I’ve heard of VLOOKUP but what’s HLOOKUP and what’s XLOOKUP?”
These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel.
Why you should attend
VLOOKUP, HLOOKUP, XLOOKUP are some of the most well-known (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.
This training is categorized as intermediate and is aimed at users who want to learn about the Lookup functions in Excel. Although the training will be delivered using the latest version of Excel, this training is relevant for users of all versions of Excel.
Note: XLOOKUP is only available in certain versions of Excel.
Elevate your Excel prowess with this training. Aimed at users already versed in Excel’s core functions (SUM, X/VLOOKUP, COUNTIF etc), this course introduces users to some of the new innovative functions added since 2020, exclusively available to Microsoft 365 and Excel 2021 users.
These cutting-edge tools are designed to streamline your formula creation process, enhance your data interaction, and expand your analytical capabilities. Embrace the simplicity of extracting unique values, sorting and filtering datasets, creating dynamic, self-updating lists and much more!
Whether you’re looking to improve efficiency, accuracy, or both, these features will set you on a path to becoming an Excel ninja. Ensure your skill set remains at the forefront of technological advancements with these essential, transformative functions that redefine what’s possible in Excel.
Whether you need to build an Excel-based dashboard, perform some serious data analysis, or simply summarize data for a personal project, Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) toolkit.
With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarize, analyze, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on which you base your key business decisions.
Pivot Tables have a reputation for being complicated and scary but by attending this training, you’ll be pleasantly surprised at how easy it is to use and create them.
From global enterprises to early-stage startups and small businesses, people everywhere use Pivot Tables to summarize and understand their data. Learning how to create Pivot Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This training will provide you with a solid foundation that you can use to build your own pivot tables and reports.
Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a small set of functions that all Excel users should know, regardless of their job function, industry, or business sector. This webinar covers ten of Excel’s most popular productivity-boosting functions.
IMPORTANT: Several of the functions XLOOKUP, UNIQUE, SORT, FILTER are only available to Office 365 subscribers and users of Excel 2021). Please check that this training is relevant for your version of Excel.
Revolutionize the way you communicate data with this cutting-edge training on Excel visual storytelling. Discover the power of visual data representation to transform complex numerical information into compelling, insightful visual narratives. The era of simple bar and pie charts has moved on. Today’s data-driven environment demands more dynamic visualizations and infographics. Our session will guide you through Excel’s innovative non-chart tools, empowering you to captivate your audience with data.
Are you ready to embark on a journey that will revolutionize the way you work with data? Welcome to “Power BI Demystified: Transforming Data into Stunning Visuals”
Discover the power of Microsoft’s revolutionary application, Power BI. Designed for beginners, this comprehensive training session will introduce you to the world of data visualization and insights like never before.
Say goodbye to the days of relying on IT departments for subpar reports – with Power BI, you take the reins, becoming a self-service reporting pro.
Please note that Power BI Desktop is exclusively available for Windows and is not compatible with Mac or mobile devices.
Venue: Recorded Webinar
Are you new to Excel and struggling to understand formulas? Are you tired of manually calculating data in Excel spreadsheets? Do you want to learn how to use Excel formulas to streamline your work and save time? If so, this online training session is the perfect solution for you. Think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula. Once you’ve mastered formulas, you’ll be introduced to functions which are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula. Why you should attend Excel is an essential tool for anyone who works with data, from entry-level employees to professionals. Knowing how to use Excel formulas can help you streamline your work, increase accuracy, and save time. This training is designed for beginners, so you don't need any prior experience with Excel or formulas to attend. You will leave the session with a solid understanding of the fundamentals of Excel formulas and the confidence to use them in your work. Topics covered Creating basic formulas: addition, subtraction, division, multiplication Using parentheses in formulas - the what and why Copying a formula - the gotchas you need to know about Make formulas logical and understandable by assigning names to your important cells An introduction to functions: SUM, AVERAGE, COUNT and SUBTOTAL The SUMIF and COUNTIF function: Add up and count based on criteria Use TODAY, DATEDIF and NETWORKDAYS to calculate and manipulate dates Use CONCATENATE and TEXTJOIN to combine text from multiple cells Who should attend This training is perfect for beginners who are new to Excel or have limited experience with formulas. Whether you are a student, professional, or simply looking to improve your Excel skills, this training is for you. The training will be delivered using the latest version of Excel for Windows however all of the functionality is also available to users of earlier versions of Excel.
President Trump will appoint a Secretary of the Department of Health and Human Services and Director of the Office for Civil Rights (OCR) with missions to make significant modifications to the HIPAA Rules. Roger Severino, OCR Director in the first Trump administration, described proposed HIPAA modifications in the 2025 Presidential Transition Project. A particular focus will be the 2024 HIPAA Privacy Rule to Support Reproductive Health Care Privacy. The new HIPAA Privacy landscape will confuse and worry Health Care Providers, Business Associates and patients. You must know what to expect and thoughtfully plan how you will respond to protect your organization, staff and the people you serve. Areas Covered Expected HIPAA Modifications OCR strategies to make modifications effective quickly Constraints to quick HIPAA modifications Compliance options for HIPAA-regulated entities Strategies to delay or defeat HIPAA modifications Why You Should Attend This Webinar Attend this webinar to begin planning how you will respond to the Trump administration’s attempt to make significant modifications to the HIPAA Rules. Who Will Benefit Health Care Covered Entities Health Care Providers Health Care Providers of all types and sizes Hospitals Health Care Practices of all types and sizes Urgent Care Clinics Behavioral Therapist Health Plans Group Health Plan Administrators Third Party Group Health Plan Administrators Health Plan Administrators Personnel Executive Management – all Covered Entities Compliance Committee – Covered Entity Board of Trustees Practice Managers – Covered Entities Chief Compliance Officer – all Covered Entities HIPAA Compliance Officials – Privacy and Security Covered Entity Owners and Senior Management Attorneys for Covered Entities – In-house and Outside Counsel Vendors and Business Associates Practice Management Companies Medical Record storage and retrieval vendors Coding, billing and payment vendors Health Care Compliance Consultants Information Technology vendors Law Firms
Critical Access Hospitals (CAHs) must comply with the Centers for Medicare & Medicaid Services’ Conditions of Participation located in Appendix W in the manual. This eight-part webinar series will cover the CAH CoP manual. There were changes and new regulations for CAHs in 2020, including a change to all the tag numbers, some which do not include Interpretive Guidelines or Survey Procedures. Changes include infection prevention and control and antibiotic stewardship, QAPI and Swing Bed changes. This seminar will help CAHs comply with specific CoP problem areas, such as nursing care plans, necessary policies and procedures, medication administration and drug storage, and informed consent to name a few. Part Two of Eight: Emergency Services, Staffing and Responsibilities, Provision of Services, Emergency Procedures and EMTALA Objectives Describe staffing requirements and supervision Recall the required14 emergency department written policies that must be present Describe that CMS has a list of emergency drugs and equipment every CAH must have Recall that a CAH must comply with EMTALA requirements Emergency Services 14 Emergency department policies ED staffing Equipment, Supplies, and Medication Blood and Blood Products Staffing/Personnel Coordination with Emergency Response Systems Staffing and Responsibilities Staffing and responsibilities Physician supervision Transfer of patient Patient admissions Provision of Services Patient care policies Scope of services Emergency medical services Medical management Diagnostic and therapeutic services Supplies Outpatient services Outpatient director Inpatient services Census and Ensuring compliance EMTALA Physician lists Central log Medical Screening examination Admit or transfer Appendix and Resources
In today’s fast-paced and data-driven world, efficiency, accuracy, and innovation are more critical than ever. This 60-minute session will introduce you to the seamless integration of ChatGPT with Excel, showing how AI can dramatically boost your spreadsheet capabilities. Learn how to speed up data analysis, automate tedious tasks, and uncover deeper insights—all with the help of AI. Whether you’re building complex formulas or running data analysis, integrating ChatGPT into your workflow allows you to bypass manual processes, generate powerful insights faster, and make smarter business decisions. This course is designed to meet the needs of both seasoned Excel pros and beginners looking to enhance their skills with the power of artificial intelligence. Why You Should Attend This session is a must-attend for anyone looking to optimize their use of Excel by incorporating cutting-edge AI technology. Whether you're a data analyst, business professional, or anyone who regularly works with spreadsheets, this training will equip you with practical skills to enhance your efficiency and make more informed decisions. Don't miss out on the opportunity to stay ahead of the curve and learn how to harness the power of ChatGPT to simplify complex tasks and boost your productivity. Topics Covered Introduction to ChatGPT and its integration with Excel Automating repetitive tasks in Excel with AI Generating complex formulas and functions using ChatGPT Enhancing data analysis and visualization with AI-driven insights Best practices for maximizing the synergy between Excel and ChatGPT Real-world applications and case studies Who should attend This training is ideal for Excel users of all levels, including data analysts, financial professionals, business managers, and anyone interested in leveraging AI to improve their productivity in Excel. Whether you're looking to automate tedious tasks or gain deeper insights from your data, this session will provide you with the knowledge and tools to elevate your Excel skills with ChatGPT.