- Email Us: info@webinarinstitute.com
Menu
Excel – Master These 10 Functions to Skyrocket Your Productivity + Excel – Pivot Tables – The Key To Modern Data Analysis and Reporting – Recorded Webinar (Combo)
Recorded Webinar
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
Pivot Tables are one of Excel’s most powerful and misunderstood tools but once you know how to use them, they can transform how you analyse and report on data. In just a few clicks, you can summarise thousands of rows into meaningful, dynamic reports - no formulas required. This session will show you how to quickly create and customise Pivot Tables to reveal trends, answer questions, and support better decision-making. You’ll also discover how to turn your Pivot Table into a visual dashboard using built-in charting tools, slicers, and layout options. If you've ever looked at a Pivot Table and thought, “I should really learn that”, this is your moment. Why you should attend Manually building summaries and reports from Excel data is time-consuming and error-prone. Pivot Tables eliminate the guesswork, automate the process, and give you instant insights. This session is perfect if you want to save time, reduce complexity, and finally get confident with one of Excel’s most powerful (but underused) features. Topics covered How to structure your source data for best results Creating Pivot Tables in just a few clicks Summarising data with totals, counts, and percentages Formatting your Pivot Table for clarity and impact Sorting and filtering with built-in tools and slicers Visualising data using Pivot Charts Understanding and using (or avoiding) GETPIVOTDATA Who should attend This session is for anyone who wants to level up their Excel skills and gain confidence with Pivot Tables. It’s ideal for professionals in admin, finance, HR, operations, or anyone who builds regular reports. You should be comfortable with basic Excel tasks like entering data, using copy/paste, and applying simple formatting. The training is delivered using Excel for Windows (Microsoft 365), but most techniques also apply to earlier versions and Excel for Mac.
Whether your employer is a clinic, a hospital, home health, or long term care; whether you are an MD, RN, an occupational therapist, a receptionist, or in the C-Suite, approximately 5% - 10% of your patients may be gay, lesbian, or bisexual. Additional patients may be transgender, intersex, or questioning their gender identity or sexual orientation. The healthcare needs of GLBT patients may appear to be the same as other patients’, but institutionalized heterosexism in healthcare is a real barrier to quality care. Healthcare providers acknowledge they are serving more GLBT patients, and that they want to provide quality GLBT care, but aren’t sure how to best create and implement the policies, procedures, and practices to ensure best patient outcomes. GLBT patients face a multitude of barriers to equitable care such as: refusals of care, delayed or substandard care, mistreatment, inequitable policies and practices, end-of-life issues, and limits on visitation. The challenges begin from the beginning of the health professionals’ relationship with their GLBT patient—starting from asking them to identify if they are male or female, married or single, on their intake form. Objectives To list relevant laws, regulations and standards required for health equity and patient-centered care of GLBT patients To identify key policy, procedure and practice issues related to GLBT patients and their families to incorporate into already existing policies, procedures and practices To discuss opportunities to collect GLBT – relevant data and information during the healthcare encounter To identify or revise strategic community outreach efforts to the GLBT population To name a variety of resources Who should Attend? HR Management Nurses Other Health Professionals
Everyone makes decisions, but of course some decisions are more important and complex than others. Whether it is a decision about what to wear to work to deciding on a merger, the decision making process is generally the same. Most decision making by management is convoluted with much fuzziness and backtracking. Research suggests that managers put little thought into the decision making process such as—analysis of the risk, what values are poignant, the alternatives evaluated, quantitative and qualitative data, identifying the stakeholders, bias, and the impact of the decision on the system, to name a few. Decision making is the basic foundation of the process of management. Yet most management training and development tactics ignore this essential skill. Learning Objectives To examine the “act of choice” To analyze roadblocks to effective decision making To discuss 10 decision making/problem solving tools To list the various models of decision making Analyze how managers make decisions Who should Attend? HR Management Any Employee
It is our nature to think—we all do it, obviously. However, a good share of our thinking is biased, distorted, or incomplete. Critical thinking is an essential skill for both managers and employees. Few of us are effective critical thinkers though research suggests that leaders believe they think quite well. Critical thinking ensures we pose the right questions, view others’ viewpoints with merit, and challenge assumptions in strategic thinking, decision making and problem solving. Non-critical thinkers shoot down ideas before they are understood, or take action based on faulty assumptions resulting in a business disaster. Teams, as well as individuals, must learn to think critically which requires a work atmosphere that is conducive to challenging others’ perspectives. Critical thinking enables teams to develop positive insights and ideas that lead to effective action. It focuses on reframing and rethinking issues so that the right problems are addressed, and requires challenging conventional wisdom. Using the process of critical thinking leads to reasoned conclusions, better decisions, fewer mistakes, and improves collaboration among team members. Learning Objectives Define critical thinking List characteristics of critical thinkers Examine the critical thinking process Explore the elements of reasoning Discuss critical thinking techniques Identify organizational, team, and individual critical thinking barriers Who should Attend? HR Management Any Employee