This course designed for the learner who already has a solid understanding of Excel's basic tools and functions. The course teaches learners some of the more advanced skills and features available in Excel, which may be useful in data analysis. These skills include style templates, conditional formatting, data validation, data manipulation, and pivot tables.
Whether you're just starting out in the workforce or changing careers, it is important to understand how the job you perform contributes to your sense of fulfillment in life. This course prompts you to examine various job settings and functions, comparing each against your own preferences, values, and expectations, in order to determine the best job fit for you.
Effective use of social media as a marketing tool is often essential for nonprofits to get attention in this digital world. This course introduces learners to the use of social media in communicating, marketing, public relations, and fundraising for nonprofits. It explores the major social media platforms (Facebook, LinkedIn, Twitter, YouTube, Pinterest) as vehicles for nonprofits to reach their members, volunteers, and donors.
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.