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.
This training is categorized as intermediate. It is aimed at users who want to learn about the commonly-used worksheet 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.
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.
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.
You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create Pivot Tables to improve your knowledge of Excel.
You don’t have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along. The training will be delivered using the latest version of Excel for Windows although much of the functionality is available in earlier versions of Excel.
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.