Weill Medical College of Cornell University · Courses
eCornell DYS
38 courses with the subject eCornell DYS, each shown exactly as we captured it from the college's catalog, with every element we hold. Where the wording looks broken, that is our reading of the catalog, not the college's text.
eCornell DYS511Managing People in a Healthcare Setting0
Managing people in a healthcare organization is all about effective communication and good leadership practices both of which will allow you to create a top-notch team. In this course, Dr. Karpman will share his expertise in medicine and business and give you a framework to evaluate yourself and the people you work with through the lens of your organization's mission, vision, and values. You'll also work to solve communication issues at both the organizational and individual levels. In the five-part course project, Dr. Karpman will challenge you to define goals and values, plan for performance management, find efficiencies by planning better meetings, refine your mediation skills, and evaluate organizational communication. Dr. Karpman will also talk to you about the importance of promoting a culture of safety, and using time-tested teamwork and performance strategies to improve your organization.
eCornell DYS512Assessing Your Organization's Finances0
To be an effective leader, healthcare professionals must be able to monitor, analyze, and make decisions about the financial status and growth of their organizations. In this course, Dr. Robert Karpman, a surgeon and entrepreneur, explores the basic elements and practices of financial monitoring and management. The course begins with a look at common financial statements. You will then examine financial ratios and determine how they can be used for benchmarking and performance management. Finally, you will look at financial projections and how they are used to support business plans. At the end of this course, healthcare professionals who have little or no financial experience will be able to analyze and work with their organization's financial reports. It is recommended to only take this course if you have completed Managing People in a Healthcare Setting or have equivalent experience.
eCornell DYS513Planning Healthcare Investments and Marketing0
To be a true leader in your healthcare organization, you must be able to give informed opinions on strategic investment opportunities. This means you must understand the basics behind capital building projects, new healthcare programs, or any other major initiatives that require critical analysis of investment versus returns, and consideration of funding options. In this course, Dr. Robert Karpman, a surgeon and entrepreneur, leads you through the processes used in cost-benefit and cost-effectiveness analyses. You will learn about return on investment (ROI), risk, the role of inflation, and how to compare investment opportunities against the returns expected from a simple cash investment. You will also become well-versed in healthcare marketing, another important form of investment. Included in this course is a five-part course project which will guide you in applying what you learned to your own career. You will also gain a set of tools and resources you can download for future use. It is recommended to only take this course if you have completed Managing People in a Healthcare Setting and Assessing Your Organization's Finances or have equivalent experience.
Healthcare in the United States is a business and, like most businesses, its leaders, staff, and advisors must be focused on revenue. However, there are opportunities unique to the healthcare industry that leaders need to be aware of to truly lead their practice to success. In this course, Dr. Robert Karpman, a seasoned medical professional, will guide you through must-know information when it comes to surveying the financial and economic opportunities within your organization. Much of the course will focus on becoming more profitable by reducing costs, evaluating contracts, improving processes, and maximizing reimbursements. In the course project, you will apply best practices and personal experience to real-world scenarios. You will walk away from this course equipped to make economically sound decisions in your organization while also keeping your patients' safety and care standards at the forefront. It is recommended to only take this course if you have completed Managing People in a Healthcare Setting, Assessing Your Organization's Finances, and Planning Healthcare Investments and Marketing or have equivalent experience.
eCornell DYS515Guiding Your Organization's Costs and Budgets0
Healthcare organizations today must pay as much attention to their financial performance and profitability as they do patient care. This means that healthcare leaders must have a firm grasp on cost accounting and budgeting. This course is designed to help you to use accounting and budgeting techniques to improve your organization's bottom line. It begins with a look at best practices in cost accounting, and then moves to broader, strategic steps you can take to implement managerial accounting. The latter half of the course focuses on budgeting, including different approaches to budgeting and the importance of addressing budget variances. The four-part course project helps you apply what you learn to your own situation, and a set of templates and downloadable tools provide resources designed to assist you as you implement key concepts in the course.
eCornell DYS516Improving Quality and Performance of Healthcare Services0
Patient care, outcomes and safety are of utmost importance in healthcare. This course will explore how to provide stellar service that focuses on safety and positive patient experiences while implementing new systems to enhance operational efficiency. This course focuses on the processes, standards, measures, and tools that enable you to improve both the quality and efficiency of your healthcare services. The course begins with a look at expectations and standards upheld by rating services and regulatory agencies, and then considers how inpatient and outpatient performance measures can be implemented. It moves on to address the use of root cause and failure mode analyses as well as efficiency improvement tools relevant to healthcare. The course concludes with specific steps you can take to improve patient satisfaction scores. The five-part course project helps you apply what you learn to your practice, and provides a set of templates and downloadable tools designed to assist you as you implement key concepts in the course. It is recommended to only take this course if you have completed Managing People in a Healthcare Setting, Assessing Your Organization's Finances, Planning Healthcare Investments and Marketing, Addressing Healthcare Economics, and Guiding Your Organization's Costs and Budgets or have equivalent experience.
eCornell DYS517Navigating the Healthcare Regulatory Environment0
With lives at stake, the healthcare industry is subject to many complex regulations. Understanding and navigating the government regulations is an important responsibility of all healthcare leaders. With a practical focus, this course outlines an approach designed to help you understand and comply with the essential requirements of regulatory agencies. The course begins with a look at regulations and the government bodies that issue them. It moves on to discuss the role of compliance officers within an organization and the steps an organization can take to ensure regulatory compliance. The course concludes with a discussion of healthcare liability and how organizations can reduce their exposure, routinely as well as in the case of medical error. The four-part course project helps you apply what you learn to your own situation, and a set of templates and downloadable tools provides resources designed to assist you as you implement key concepts in the course. It is recommended to only take this course if you have completed Managing People in a Healthcare Setting, Assessing Your Organization's Finances, Planning Healthcare Investments and Marketing, Addressing Healthcare Economics, Guiding Your Organization's Costs and Budgets, and Improving Quality and Performance of Healthcare Services or have equivalent experience.
eCornell DYS521Women in Leadership: Navigating the Double Bind0
Most women in a leadership role face a very common dilemma: If she's a strong, assertive leader, she's viewed as domineering and abrasive, encountering resistance as a result. If she isn't assertive enough, she's viewed as weak and a pushover, making it hard to get support within the organization. In this course, you will examine that very common double standard and identify strategies to deal with it. All leaders, regardless of gender, face conflict and resistance and have to work with people who think, act, and communicate differently from themselves. In this course, Deborah Streeter, the Bruce F. Failing, Sr., Professor of Personal Enterprise at Cornell, will show you how to recognize when there's gender bias at play and when there isn't, and how to address any issues that arise.
eCornell DYS522Women in Leadership: Negotiation Skills0
Many women say they would rather go to the dentist than negotiate for themselves. Why? Women are taught early to create equity in relationships. When you negotiate with someone and you feel that you're taking something away from them, that feels like a violation of the social contract with which you were raised. There's little wonder, then, that negotiation feels deeply uncomfortable for many women. Yet negotiating is a critical skill that everyone, especially women, has to practice and master in order to be an effective leader. In this course from Cornell Professor Deborah Streeter, you will practice key behaviors that help negotiations, including asking for what you want something most women are not taught to do. The course emphasizes the gender dimension of negotiation strategies and the critical skills on which women leaders in particular need to focus. This course will be most helpful for women leaders who are not already practiced and comfortable in negotiation settings, and those who find negotiating stressful, uncomfortable, and difficult. Negotiating is a routine part of daily life and leadership, and approaching it with confidence and skill signals that you know your worth.
eCornell DYS523Women in Leadership: Using Emotional Intelligence to Drive Results0
Research shows that emotional intelligence is a critical predictor of performance as well as a very strong driver of leadership and personal excellence. Those with high emotional intelligence can typically read a room quickly, clue into subterfuge, and more easily show respect and empathy. While soft skills such as those may not sound impressive, they can be imperative for a woman in a leadership role. You can be a top performer without any emotional intelligence, but the numbers are against you. In this course from Professor Deborah Streeter, women leaders can develop their emotional intelligence and learn how to use it to their advantage to manage their team to greater success.
eCornell DYS524Women in Leadership: Giving and Receiving Feedback0
Research shows that feedback is critical for leaders and that creating a culture of feedback is key to a team's success. The more successful a team is, the better an organization's bottom line. However, there is an art to giving and receiving feedback, and if not done properly, feedback can have a negative impact to morale. Conversely, teams who receive feedback in a positive, supportive way will strive to continue to do well. There can be a gender dimension to giving and receiving feedback that is critical for women in leadership roles to understand, as men and women react differently. In this course, Professor Deborah Streeter will examine the gender dimensions of giving and receiving feedback and explore strategies for working as effectively as possible to lead a high-performing team.
eCornell DYS525Women in Leadership: Outsmart the Work-Life Balance0
To maintain energy and positive focus, it's critical for women in leadership roles to cultivate a healthy and productive balance between their professional and personal lives. In this course, Professor Deborah Streeter examines the typical work-life balance conflicts that interfere with productivity and happiness. Students will also examine ways to create various checks to ensure they stay in balance, allowing them to move forward effectively and focus energy on the tasks that will have the greatest positive impact.
Research shows that both women and men equate being a leader with being male. Leadership itself is male gendered. How does that affect women's ability to advance to the highest levels of leadership? How does it impact the aspirations of women aspiring to top levels? Just look at any of the lists of 50 or 100 top leaders and you can count the number of women on one hand. Do an online search of leadership authors: They are mostly older (and mostly white) men. Both women and men inherently associate leadership power with men. Why is this so? For centuries, men have held the highest power in all kinds of organizations. This predominance of men as leaders has an impact on our concept of leadership. We associate leadership with stereotypically masculine traits: aggression, decisiveness, willingness to engage in conflict, strength, orientation towards action, and other masculine stereotypes. This remains true even though not all male leaders exhibit such traits. What we can say with certainty is that our mental map of leadership for many years has been dominated by white male role models. This gendering of leadership is true even though when researchers study the key aspects of leadership, there are no gender differences in effectiveness. In this course, co-authored by Cornell University's Deborah Streeter and Susan S. Fleming, students will assess their own organizations to determine the gender status and power dynamics present. They will use tactics to reduce gender bias in themselves and in the organization. They will identify strategies used to influence the workplace culture to be one of greater parity and use practical strategies to bring forward the contributions of both women and men in group settings. Leadership efforts are also personal: students will create an action plan for themselves, choosing among the recommended strategies to find those most appropriate for their specific context to enhance their own status and power.
eCornell DYS532Developing Executive Presence for Women Leaders0
The concept of "authentic leadership" has become very popular in recent times. In addition, much has been written about executive presence and how to cultivate it in yourself. Both of these things are affiliated with rising to the top. There is an inherent dilemma for women trying to apply these concepts. Everyone expects that to move up in leadership they will have to display the "right" professional identity and work style ones that "fit" with expectations. But what is right and fits is heavily influenced by the majority culture of the organization, which in most cases has been established by men (mostly white, mostly older). So on the one hand, the professional identity needed to succeed includes behaviors more prominent in male culture. On the other hand when women go too far in exhibiting those behaviors, they get pushback. As a result, in certain very traditional masculinized settings, women learn to alter, repress, or hide some of the characteristics of their identities (being a mom, caregiver, acting communally). In essence, some women in certain contexts find they have to restrain their personal style in order to fit in. In this course, designed for women in leadership positions, learners will examine strategies for incorporating being self-aware and genuine without suppressing their unique personal style.
eCornell DYS533Gender Bias and Negotiation Strategies0
Research indicates that women - even high-ranking women in leadership positions - face a fundamental obstacle when negotiating: women come to the negotiation table with lower perceived status and less power than men. Women must tread carefully in attempting to level the playing field, though, because negotiating with a stereotypically "male" style could result in social consequences that negatively affect the outcome of the negotiation. The burden is on women, therefore, to skillfully adapt their negotiation style to suit the styles of other negotiators and the context of the situation. As women in leadership roles ascend the ranks of their organizations, they face increased responsibilities to negotiate successfully for their teams and institutions as well as themselves. This course, designed specifically for women in leadership by Deborah Streeter, the Bruce F. Failing, Sr., Professor of Personal Enterprise at Cornell, challenges learners to evaluate their negotiation style through the lenses of gender and power and use their emotional intelligence to tailor their style to any situation. Learners will explore advanced negotiation techniques that help women capitalize on their strengths and avoid triggering the double bind in negotiations.
Leaders often ascribe different causes to their success in ascending to senior positions in their companies. Research shows that women are likely to point to the merit of their own work as the reason for promotion, whereas men tend to attribute upward mobility to their skill forging strategic relationships. In reality, strong professional networks - and the ability to leverage them to meet individual goals - are a crucial component of career advancement regardless of talent. Unfortunately, many potential women leaders undervalue or underutilize this critical tool. In this course, designed specifically for women in leadership by Deborah Streeter, the Bruce F. Failing, Sr., Professor of Personal Enterprise at Cornell, you will deconstruct your own professional network and how it is working - or not working - for you. By defining key roles and relationships, you will identify and address areas in your network that can be strengthened. This course will also provide you the tools to overcome common challenges to developing and maintaining networks that women face due to harassment or the double bind.
eCornell DYS535Decoding the Gender Gap in Board Membership0
Men overwhelmingly outnumber women on public boards of directors, but times are changing and more boards than ever are actively seeking qualified women to help steer their companies. For interested women, the challenge is that the typical path to board membership through the C-Suite is optimized for the male executives who often land senior leadership roles. This course, designed specifically for women with leadership experience by Deborah Streeter, the Bruce F. Failing, Sr., Professor of Personal Enterprise at Cornell, and Susan S. Fleming, a senior lecturer at the Cornell School of Hotel Administration, will demystify the journey to board membership for women and break down the responsibilities and opportunities that women can expect once on a board. In this course, you will prepare yourself for board membership by assessing your personal competencies and potential barriers to joining a board. You will write your own value proposition for what you could bring to a board and then identify potential boards and make a plan to approach them. You will also analyze how, as a woman, you can make a positive impact on a board, all while successfully navigating the double bind.
eCornell DYS541Getting Started with Spreadsheet Modeling and Business Analytics0
To successfully and quickly solve business problems you need more than just intuition; you need solutions based on data. Data analytics is essential for any successful business. It helps us frame problems, make comparisons, forecast outcomes, and make decisions. You can use simple but very effective tools to analyze your data and make better, more informed decisions. In this course, you will explore spreadsheet-modeling for applied decision making. You will work with data sets and navigate in an Excel 2016 Workbook. You will examine data cleaning and modeling concepts, practice core Excel skills, and explore ways to apply data management techniques to the spreadsheet system by using its math and logic capabilities to their full potential. By performing data management, you can improve the structure and usefulness of your data.
Organizations go to great lengths to collect data to inform business decisions. However, given the volume of data, it can become difficult to sift through and find the needed answers. In this course you will gain exposure to the challenges of working with data and learn how you can use Excel to efficiently harvest data to make business decisions. Using Excel as a tool you will be able to quickly answer business questions by applying criteria to your data using Excel's logic functions, quickly retrieve information from a large set of data, and visually enhance your data. The course Getting Started with Spreadsheet Modeling and Business Analytics is required to be completed prior to starting this course.
eCornell DYS543Visualizing and Communicating Insights In Excel0
When your audience can quickly and efficiently understand what the data is telling them without having to scour every row and column, they can gain insights from your analysis more efficiently. In this course, you will apply the power of Excel pivot tables to see your data from multiple perspectives, use data visualization techniques that effectively communicate your analysis to your audience, create charts that quickly and clearly visualize your analysis, and apply the principles of graphical integrity to your charts. The courses Getting Started with Spreadsheet Modeling and Business Analytics and Harvesting Spreadsheet Data are required to be completed prior to starting this course.
eCornell DYS544Making Predictions and Forecasts with Data0
In order to execute the most informed business analyses, we need the right tools for making predictions from data. Excel provides powerful predictive analytic tools that let the user forecast trends and make predictions with historical data. In this course, you will conduct financial analyses by comparing loan scenarios using financial functions, identifying what values are needed to achieve a desired result, and quickly identifying how changes in your data will impact outcomes. You will leave this course with the ability to leverage reliable historical data to generate simulations and make predictions. These courses are required to be completed prior to starting this course: Getting Started with Spreadsheet Modeling and Business Analytics Harvesting Spreadsheet Data Visualizing and Communicating Insights in Excel
eCornell DYS545Using Prescriptive Analytics in Excel0
Most decisions are made based on the desire to find the best way to do something. Solving complex business problems related to organizational goals can be a challenge. The ability to do this can be maximized with a little preparation and the power of Excel. When you use data in your analysis to prescribe what should happen next, you're performing prescriptive analytics. With this knowledge, you can build models and generate results that maximize outcomes by actually suggesting a course of action. In this course you will gain the skills needed to execute efficient and effective decisions backed by your data analysis. These courses are required to be completed prior to starting this course: Getting Started with Spreadsheet Modeling and Business Analytics Harvesting Spreadsheet Data Visualizing and Communicating Insights in Excel Making Predictions and Forecasts with Data
eCornell DYS546Creating and Sharing Interactive Data Models0
Have you ever had to do an analysis of data but found that the data you needed was not all in one place? It could be online, in separate Excel files, or you might find that it's in different formats. It could take hours to convert and organize everything you need. In this course you will learn Excel's options for data management and modeling to relate data from multiple sources quickly and create interactive dashboards that answer dozens of questions. You will be able to import data from different Excel workbook files into one file or even import data in different formats like Notepad for the web and different databases. These courses are required to be completed prior to starting this course: Getting Started with Spreadsheet Modeling and Business Analytics Harvesting Spreadsheet Data Visualizing and Communicating Insights in Excel Making Predictions and Forecasts with Data Using Prescriptive Analytics in Excel
At the heart of any business is the ability to track, invest, and manage money. Without the ability to do these three things successfully and honestly, a business will not survive, no matter how good their product or service is. A clear understanding of how money flows into and out of an organization allows us to attract investors, identify investment opportunities, decide with what organizations to form relationships or partnerships, and even manage your own personal finances. In this course, you will examine the different roles of accounting and finance and how each influences a business. You will analyze the financial documents used by accounting and finance in all businesses: the income statement and the balance sheet. Understanding the numbers on these documents will allow you to interpret financial information to inform decision making in numerous personal and professional capacities.
Marketing is more than just an advertisement; it is the intersection of numerous decisions that allow a product or service to exist in the world and be purchasable. Whether an organization plans to serve individual consumers or other businesses, they need a plan for how they are going to discover, keep, and grow their customer base. In this course, you will be introduced to a systematic way of thinking about marketing all products and services. You'll discover how to define your target market, how to focus on their needs and wants by providing the right kinds of value, and how to attract them (and retain them) as customers. A three-part course project to create a strategic marketing brief will give you practice in performing all of the valuable activities that enable you to discover, target, reach, acquire, and retain your customer base.
eCornell DYS553Strategic Business Planning and Forecasting0
As the saying goes, "A goal without a plan is just a wish." It's not enough to simply have a product or service worth buying; there are many factors you need to consider, such as: How many choices do customers have for a similar product? How many competitors do you have, and what are their strategies for competing with you? If you suddenly need a new supplier, will it interrupt production or force you to raise prices? How likely is it that new competitors enter your market? Answering these questions requires careful planning as well as a thorough understanding of your competition, your suppliers, and your customers. In this course, you will identify the three major strategies that your company can select as it competes in the marketplace, and you will examine the characteristics of companies that pursue each strategy. You will also identify the various activities involved in supporting your chosen strategy alongside the complexity of acquiring raw materials and converting them into products for the end customer. Additionally, you will conduct an analysis to help assess your company's strengths, weaknesses, opportunities, and threats. Finally, you will balance your planning against the often conflicting needs of a company's stakeholders, its shareholders, and the society in which it operates.
Operating as an organization takes coordinated effort. Companies need to structure themselves in a way that supports their goals. They need to describe job duties clearly so everyone knows how their role supports those goals. They need to attract and support the right talent, and determine how employees can best influence each other to achieve their common objectives. It takes a lot of work to get and stay organized. In this course, you will examine the various organizational methods that help support a chain of command. You will also analyze, describe, and specify a job position to help ensure that everyone knows how their role supports overall company goals. You will design an HR management process to recruit the right potential employees, identify the best candidates, welcome them to the organization, and support them as they work. You will describe the organizational culture of a company and determine its role in helping employees do their best work. Finally, you will describe the uses of power in organizations, as employees influence one another in pursuit of common goals. In the five-part project, you will develop an organizational brief that considers each step of organizing a firm so that you can better structure the inner workings of a company to support its goals.
Leadership is not just for leaders. Whether you have formal leadership authority or not, everyone faces leadership challenges. At heart, companies are people, and many challenges in the workplace come down to how to inspire, support, and reward people. In this course, you will explore several different strategies to help motivate and lead people. Initially, you will distinguish between factors that increase job satisfaction and factors that decrease job dissatisfaction, as research shows these are not always connected. You will also design strategies to influence motivation, effort, and job performance. You will identify the types of capital in a group or team and explain how this capital can help build and support high-performing teams. Finally, you will design conflict resolution strategies and employ negotiation tactics when conflict inevitably occurs in the workplace.
eCornell DYS556Navigating the Global Business Landscape0
Today's business world is dramatically different from what it was 20 years ago. We communicate faster, more frequently, and with more people than ever before. We're expected to sift through massive amounts of information in very little time, come up with valuable ideas constantly, bring them to market quickly, and solve problems rapidly. In this course, you will practice using the skills needed to succeed in changing global markets. Keeping up with change requires sharing good information with colleagues. This course will help you practice communicating formal and informal messages to various stakeholders in order to make sure that messages are clear and that misunderstanding is minimized. You will also create a personal networking strategy that helps focus your professional development. Additionally, you will explore the entrepreneurial process of ideation and describe the transformational power of disruptive technologies in industries, firms, and occupations. You will also select and categorize a business according to its stage of globalization and evaluate its strategy. Finally, you will examine various business actions according to different ethical frameworks.
eCornell DYS581Automating Processes With Macros and Excel VBA0
In this course, you will explore Excel automation techniques using Excel macros and Visual Basic for Applications (VBA) code. This practical course equips you with the knowledge to streamline repetitive tasks efficiently, whether you re an Excel novice or you re looking to enhance your existing Excel skills. Without any previous coding experience, you ll be able to write and utilize VBA code to perform tasks in Excel. You will discover how to record and run macros before delving into some of the limitations of recording macros. You ll then begin to enhance Excel functionality with VBA, manipulate ranges, and engage in hands-on projects. By the end of this course, you ll be well prepared with the basics of using Excel VBA to automate tasks, save time, and boost productivity. Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
eCornell DYS582Applying Logic for Efficient Task Processing0
Whether you re a curious learner, a beginner data analyst, or a seasoned Excel user, this course provides a solid foundation for streamlining repetitive tasks effectively. Combining two key components of efficient data manipulation, you will use conditional statements and loops to solve complex business problems that mirror real-world scenarios. Perhaps you re tasked with optimizing inventory management, calculating shipping costs, or handling customer inquiries. You will examine how to develop algorithms to solve such problems and practice breaking down the problem logically by converting your decision-making steps into VBA code. Now imagine that your task involves a vast dataset rows upon rows of transaction records, inventory levels, or customer feedback. How do you process this data systematically? By using various loop structures that execute tasks automatically and allow you to iterate through data. You will discover how using conditional statements and loops together can give powerful results that will improve accuracy and efficiency in performing repetitive tasks in Excel. Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course. Automating Processes With Macros and Excel VBA
eCornell DYS583Enhancing the Excel User Experience With VBA0
This course will provide you with the skills needed to create powerful and customized solutions within Excel that improve the user experience. You will discover how to write your own custom functions in VBA, allowing you to perform calculations and automate repetitive tasks that go beyond the built-in Excel functions. You ll then delve into importing data from external files, understanding how to access data from various sources. Practical examples will guide you through importing worksheets and handling multiple external files efficiently. You will also practice designing and coding interactive forms that communicate with users. From basic form design to retrieving information and handling user input with VBA code, you ll gain confidence in creating user-friendly solutions. Finally, you ll explore workbook settings, sheet navigation, and access restrictions, enabling you to zoom in on specific content, protect your workbook, or control user access. By the end of this course, you ll be equipped with the confidence to design user-friendly solutions. Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course. Automating Processes With Macros and Excel VBA. Applying Logic for Efficient Processing of Tasks
This course offers valuable insights and practical skills that will empower you to tackle complex tasks in Excel effectively. You will begin by immersing yourself in VBA events, where you ll discover how to automate actions based on specific triggers. You ll explore event triggers, brainstorm creative business solutions, and create event handlers. From workbook events to worksheet interactions, you ll gain the ability to respond dynamically to user actions. You will also examine Excel s new dynamic array functions and assess how they are different from traditional functions. While this is not specifically about VBA, it addresses essential Excel functionalities that can significantly enhance your projects. Finally, you will apply your VBA skills to a case study in which you ll design a comprehensive business solution for a small coffee shop. You ll determine how to create a user-friendly interface to manage daily operations and automate some repetitive tasks. This case study will serve as a practical summary of many of the foundational VBA concepts studied previously, allowing you to apply your knowledge to realistic situations. Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course. Automating Processes With Macros and Excel VBA. Applying Logic for Efficient Processing of Tasks Enhancing the Excel User Experience With VBA
eCornell DYS591Exploring Data Visualization Techniques0
In today's world, data fills every corner from business to science to our daily lives. Yet large swathes of data aren't practical or parseable for humans when presented in their native formats; we rely on faster and more intuitive ways of digesting complex data. One of these methods is data visualization, or the graphical representation of data in the form of charts, graphs, and diagrams. In this course, you will encounter myriad ways to visualize data and provide your audience with a clear understanding of the data's contents. You will explore the fundamental principles of data visualization through the lens of data types, audience analysis, and communication effectiveness. You'll categorize data and select compelling visualization methods while considering your intended audience and message objectives. You'll also gain insight into the strategic implementation of data visualization, including determining when visualization enhances communication and when alternative approaches might be more effective.
eCornell DYS592Creating Professional Data Visualizations0
Raw data rarely arrives in the perfect format for analysis and visualization. Before analysts can visualize meaningful insights from their data in Tableau, they must first transform their data into a structured, reliable foundation. In this course, you will prepare and load data into Tableau to construct your first data visualizations. You'll begin by exploring Tableau's interface and reviewing the requirements for analysis-ready data. To organize your data and workspace, you'll double-check data elements for proper formatting, connect multiple datasets, and identify and resolve common data preparation issues. You will further develop these foundational skills by constructing basic plot and chart visualizations then build on these visuals by computing additional custom values from your data, called calculated fields, to represent key business metrics. By practicing these techniques on a fictional financial dataset, you'll gain the skills to construct strong visualizations that communicate clear business insights to your audiences. System requirements: To complete this course, you will need to install Tableau Desktop Public on your local device. While this software is free, you'll need to create an online Tableau Public account to download the Tableau Desktop Public package. You will also need administrative privileges to install this software on your device. Refer to Tableau's System Requirements for up-to-date information on supported devices to check your device compatibility.
Advanced mapping techniques can unlock valuable insights, especially when you move beyond simple point-and-click mapping. From geographic visualizations showing regional sales performance and population distributions to tree maps and heat maps displaying data intensity patterns, the most compelling map visualizations combine multiple data layers with strategic enhancements to illuminate key patterns. In this course, you will begin by examining geographic elements of data and creating map-based visualizations. You'll generate maps with multiple data layers and enhance your data visualizations using borders, backgrounds, and animation features. Through hands-on practice with tree maps and heat maps, you'll analyze data intensity patterns and relative relationships across different dimensions. You'll also evaluate the effectiveness of various map enhancements and implement best practices for creating insightful geographic visualizations that communicate complex data relationships clearly and effectively. System requirements: To complete this course, you will need to install Tableau Desktop Public on your local device. While this software is free, you'll need to create an online Tableau Public account to download the Tableau Desktop Public package. You will also need administrative privileges to install this software on your device. Refer to Tableau's System Requirements for up-to-date information on supported devices to check your device compatibility.
As you move beyond basic charts and graphs, a world of sophisticated visualization techniques opens up exciting new ways to illuminate your data. From showing performance distributions to illustrating intricate data flows, advanced visualization techniques help you create visualizations that stick with your audience. In this course, you will use advanced visualizations to represent complex data relationships. You'll begin with visualizations that capture business performance, such as dot plots. Yet large or densely clustered datasets can make for congested dot plots, often obscuring key findings. To address this challenge, you'll review how applying sparklines and jittering techniques can help enhance and clarify your message. You will also build bullet charts, lollipop charts, word clouds, and slope graphs to represent data trends. Beyond developing the technical skills to build these charts, you'll analyze the most appropriate use of each one depending on the visualization's tone along with your business needs and audience. You'll decide when to use pie charts and Gantt charts, considering when alternative visualizations better serve your data and needs. System requirements: To complete this course, you will need to install Tableau Desktop Public on your local device. While this software is free, you'll need to create an online Tableau Public account to download the Tableau Desktop Public package. You will also need administrative privileges to install this software on your device. Refer to Tableau's System Requirements for up-to-date information on supported devices to check your device compatibility.
eCornell DYS595Creating Dashboards and Compelling Data Stories0
As an analyst, it's not always enough to create a visualization; sometimes, you need to weave together many elements to give your audience the whole picture. Whether it's creating an important presentation to persuade your clients or crafting a vital dashboard that enables decision making in real time, creating insightful and compelling data stories is essential to effective data visualization. In this course, you will explore the art of combining visualizations into powerful dashboards and compelling data stories. Beginning with dashboard fundamentals, you'll identify essential components and evaluate their effectiveness for different audiences. You'll then create interactive dashboards incorporating filters, actions, and navigation elements to enhance user experience. You'll also apply styling techniques, including color schemes, spacing, and show/hide features, to improve dashboard quality and impact. Finally, you'll develop data stories that effectively communicate insights and guide audiences through complex analytical narratives. System requirements: To complete this course, you will need to install Tableau Desktop Public on your local device. While this software is free, you'll need to create an online Tableau Public account to download the Tableau Desktop Public package. You will also need administrative privileges to install this software on your device. Refer to Tableau's System Requirements for up-to-date information on supported devices to check your device compatibility.
