Data 101

In the era of big data and data science, data governance has the ability to help all types of organizations and individuals become more successful. In this course, Dr. Jonathan Reichental introduces the topic of data governance and reviews why your organization may benefit from data governance, how it's implemented, and why it is essential in compliance and risk reduction efforts. Jonathan also covers the role of data governance in emerging technology areas such as knowledge graphs, artificial intelligence, and the Internet of Things. With the scientific growth of the 21st century, the demand for expertise in data governance is high. Start here for your first look at this in-demand skill.

Got a big idea? You need to get it across quickly and efficiently, or modern audiences will move on to the next story clamoring for their attention. In this course, Bill Shander shows how to think about your data, your audience, and your goals to create visuals that maximize impact. Plus, learn about human visual perception and chart selection strategies, which make all the difference when visualizing data.

With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. In this course, get an introduction to using Google Sheets, the cloud-based spreadsheet editor included with Google Workspace that integrates seamlessly with other Google apps. Learn how to add, import, sort, and filter data; apply formatting to cells, rows, columns, and tabs; and perform calculations and visualize data for stakeholders and teams within Google Sheets. Along the way, discover how to collaborate in Google Sheets using comments and action items, tracking changes and managing versions as you go. FInally, apply your new skills in the business challenge.

Take your skills to the next level with Google Sheets. Learn how to apply custom themes and a wide variety of conditional formatting options. Get an overview of how to reference and validate your data in a Google Sheet with a variety of formulas and functions. Discover how to make your data accessible to nontechnical stakeholders using charts and pivot tables as well as other data visualization options. Review the integration process of Google Sheets and Google Forms to create and collect data from online surveys for quick analysis. Test out your new skills with Sheets and Forms in the hands-on business challenge offered at the end of the course.

Google Sheets users can leverage pivot tables to create useful summaries to gain insights into their business data. Follow along with Curt Frye as he shows how to summarize and rearrange data dynamically with pivot tables. Learn how to lay out your data, create the pivot table, edit the data source, add custom calculated fields, and sort and filter data to display the exact information you need.

Many beginning and intermediate Google Sheets users are familiar with basic functions and formulas but have no experience with the more advanced calculations the program offers. In this course, Curt Frye walks through the intermediate and advanced functions for summarizing data, performing statistics, analyzing financial data, and more. Learn how to use references and named ranges; apply mathematical functions to multiply, round, and count values; identify outliers and rank values; calculate investments and loan payments; determine dates and times; look up values based on multiple criteria; and summarize arrays of data.

Get up to speed with Microsoft Excel. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Plus, check out Excel’s newly revamped Accessibility Checker that helps you adjust fonts and colors to be more readable and add alt-text for images to make your workbooks more accessible. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, print in Excel, use Microsoft Copilot with Excel, and more.

Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work and offers grounding when working with formulas and functions. Next, a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and other formulas are presented. Oz provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. The course concludes with a series of challenges so you can test your knowledge.

If even a small part of your job entails using Microsoft Excel, there’s a good chance that at some point you’ve received a spreadsheet where the data is unorganized, disconnected, or generally not in great shape. Rather than pull your hair out at the mess of data you see before you, you can use Power Query in Excel to help you import and clean data into something easier to work with. In this course, Excel expert Dave Ludwig shows you how to use Power Query to connect to your data source, filter data, and create conditional columns of data. He also shows off the significant cleansing capabilities of Power Query. 

Ready to start working with spreadsheets like a pro? Join Excel MVP Oz du Soleil as he shares how to clean, organize, and analyze large amounts of data with ease using commands, features, and functions within Microsoft Excel. Oz dedicates the first portion of the course to checking data quality. He then steps through how to prepare your data for analysis by setting it up into sortable, filterable columns and rows. Oz shares how to work with multiple data sets at once; sort and filter data; and use functions to isolate and analyze data. Plus, learn how to work with other features in Excel, including Power Query and dynamic arrays, to easily refine and organize data. With these techniques, you'll be prepared to quickly and effectively extract important information from even your largest spreadsheets.