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 in terms that everyone can understand, and helps you discover 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. In the last part of the course, he shares ideas on how organizations should think about managing, monitoring, and measuring data governance efforts. As data science grows in its importance in the 21st century, so does the demand for data governance expertise. 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. Data visualization allows you to make the complex simple, the abstract tangible, and the invisible visible. 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 open Google Sheets and create a new spreadsheet; add, import, sort, and filter data; apply formatting to cells, rows, columns, and tabs; and perform calculations and visualize data for stakeholders and teams. Along the way, get tips on managing sharing options and permissions, and discover how to collaborate in Google Sheets using comments and action items, tracking changes and managing versions as you go. In the final section, test out your new skills in the business challenge to get ready for the next course Google Sheets: Advanced Topics.

Take your skills to the next level with Google Sheets. In this course, continue to develop your data analytics capabilities, building on the lessons learned in the previous course Introduction to Google Sheets.

Learn how to apply and customize themes and a wide variety of conditional formatting options before getting started with advanced formulas and functions. Get an overview of how to reference and validate your data in a Google Sheet, which holds millions of numbers, formulas, and text. Find out how to make your data more accessible to nontechnical stakeholders using charts and pivot tables as well as other data visualization options built into the app. Along the way, discover how easy it is to integrate Google Sheets with 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 exactly the 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, the world's most popular spreadsheet program. 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 to people with disabilities. 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 in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions. 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. And despite common practice, a long, heavy sigh is not officially part of any recommended Excel workflow. 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 takes you through the robust features set of Power Query. Dave 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. Once your data is cleaned up, you can more easily create formulas, PivotTables, charts, and generally get on with your business.

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. Instead of focusing on pure analysis (forecasting, running regressions, etc.), Oz covers how to use built-in Excel tools to prepare your data for analysis and extract the information that supports your mission.

Oz dedicates the first portion of the course to an often-overlooked part of data analysis: checking data quality. He then steps through how to prepare your data for analysis by setting it up into sortable, filterable columns and rows. Next, 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 the newest features in Excel, including Power Query and dynamic arrays, which make it so much easier to get what you need from your data without clumsy, complicated, and delicate formulas. With these techniques, you'll be prepared to quickly and effectively extract important information from even your largest spreadsheets.