This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace.
In today's professional landscape, PowerPoint presentations can be effective platforms for sharing information and garnering audience interest and support. At the same time, a poorly designed PowerPoint slideshow can quickly turn an audience away. By focusing on how to apply basic design principles to slideshow creation, this course will help learners use Microsoft's PowerPoint 365 software to build visually engaging slideshow presentations. Learners will consider how to select images and photographs for use in slides, the importance of arrangement and placement of images, the use of tools like Shapes and SmartArt, methods for presenting data, and the selection of colors and fonts that increase the readability of content.
As technology continues to change the way that we engage in business communications, the art of presenting has also undergone a shift. No longer can presenters rely solely on their spoken words to deliver their messages. Now, audiences expect to see multimedia slideshows that both inform and entertain. This course will consider how to plan and design effective slideshow presentations using Microsoft's PowerPoint software. It includes practical tips and examples for mapping the presentation, incorporating research, using templates, selecting visual elements, and delivering the presentation.
Managing today can require good instincts. However, instinct is not enough to manage the huge amounts of available data and the complex variables of the business world. Statistics can help managers and leaders make sense of these complexities, back-up their assertions, and feel confident about when to take the risks and when to pump the breaks. This intermediate-level course examines statistics as a managerial tool. It also looks at common graphical representations of data and how these can be effective tools to explain situations and support persuasive arguments for a course of action.
There are a number of statistical tools and techniques that are commonly used by organizations to inform decision-making. These tools span numerous business functions and support many different objectives. This intermediate-level course describes, evaluates, and analyzes different statistical techniques and their real-world limitations and benefits. The course features crossover analysis, break-even analysis, cluster analysis, decision tree analysis as well as an introduction to regression.
Statistical Process Control is all about boosting quality. Quality management can not only deliver value to customers and stakeholders, it can also enable data-driven decision making that helps organizations gain a competitive advantage in the marketplace. This intermediate-level course will introduce the basics of quality management, explaining the difference between quality control and quality assurance, providing methods for application of analysis, showing different applications of the Seven Basic Quality Tools. It all culminates in a brief case study, which illustrates the concepts covered.
How are data-driven decisions put into practice in the real world? How do these decisions differ when applied to different sectors, such as health care, education and government? This intermediate-level course will provide answers to these questions as well as recommendations for decision-making based on data analytics for each sector. The course will begin with an introduction of Big Data, then continue into a deeper dive on its implications within each sector. Industry case studies make the concepts applicable in the real-world.
This course introduces learners to basic artificial intelligence concepts and trends. Artificial Intelligence plays an increasingly important role in many industries. The emergence of this new technology promises to bring unprecedented efficiencies for organizations and enhance business performance. In today's global economy, managers will need to know how AI can be leveraged to keep their organizations competitive, as well as understand the potential ethical issues associated with employing AI technologies such as deep learning, machine learning, and the various AI-enabled recognition technologies.
When using data analysis to improve organizational performance, it's vital to employ the tools that bring the data to life and keep people engaged in the process. Organizations in both the public and private sectors often use tools and frameworks to deliver the data, and the information the data might suggest, to its staff. This intermediate-level course will explain some of these measures and tools, describe some specific measurements, and explain the relationship between assessment and strategy. Summarizing the data with the correct tool can be the gating factor to reaching staff and effecting changes that spur performance improvement.
Whatever your profession. Whatever your field. As a professional, and certainly as a leader, you will be asked to make a decision based on data. This course will introduce the different types of decisions made in an organizational setting, why quantitative analytics is important, and how data quality can affect decision making. Since quantitative analytics is used in various settings, this intermediate-level course also offers insight into how research is used in different sectors. From a management perspective, the course highlights appropriate quantitative methods and ways to ensure quality and accuracy through research design.