| Course Name |
Hours |
List Price |
Content |
| Data Analysis with Google Sheets |
7.00 |
$325.00 |
|
Description: In this course, you will cover creating and modifying table elements, adding and deleting records and fields, and using Data forms and Slicers with table data. You will import data from Access and Excel objects as well as text file types. Proper data management will be discussed to determine structure requirements, sorting, filtering, using flash fill, auto filter and advanced filtering features. The database functions will allow the user to extract data from a large list of content with precision based on specific criteria. Finally, the data modeling features will examine how to take spreadsheet data and create one to many relationships which will expand the functionality of a pivot table for a greater understanding of the data.
# of Days:
Setting:
|
| Pivot Tables with Google Sheets |
4.00 |
$219.00 |
|
Description: In this course you will learn how to create, modify, and protect Pivot Tables and Charts, as well as how to filter, sort and format individual fields as well as groups of data. Explore the intuitive interface to arrange, view, and calculate data to unlock brand new understandings that a simple table would struggle to display. Understanding how to work with PivotTables and Charts to achieve the results you want is one of the most powerful tools in Data Analysis.
# of Days:
Setting:
|
| Storytelling with Data Using Google Sheets |
7.00 |
$399.00 |
|
Description: The Storytelling with Data course teaches you the fundamentals of data visualization and how to communicate effectively with data. Youll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examplesready for immediate application to your next graph or presentation.
Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal dont make it any easier. This course demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story.
Specifically, youll learn how to:
Understand the importance of context
Determine the appropriate type of graph
Recognize and eliminate the clutter
Direct your audiences attention
Think like a designer when visualizing data
Leverage the power of storytelling to help your message resonate with your audience
|