Видео

This video demonstrates how to use the QUERY function and include it in a Google Sheets data analytic dashboard.

This video shows how to create a scorecard chart and include it in a Google Sheets data analytic dashboard.

This video demonstrates how to include a pivot table with a bar chart in a Google Sheets data analytic dashboard.

This video demonstrates how to include a pie chart with slicers in a Google Sheets data analytic dashboard.

This video provides a general description of data analytics dashboards. It includes the definition, describes the main features, discusses different types of dashboards based on their purpose, explains the benefits of using dashboards, provides several examples of dashboards, lists multiple software for creating dashboards, and lists the criteria for selecting an effective software.

This video shows how to create geographic plots in Google Sheets.

This video demonstrates how to create boxplots in Google Sheets.

This video demonstrates how to create scatterplots in Google Sheets.

This video demonstrates how to create a histogram in Google Sheets.

This video demonstrates how to create a line graph in Google Sheets.

This video discusses the different types of variables and presents the types of graphical representations that should be used based on variable type and the purpose of the analyses. Specifically, it describes the use of pie charts, bar charts, histograms, stem and leaf plots, box plots, scatter plots, time plots, and geographical plots.

This video show hot to use pivot tables to aggregate and reorganize data in Google Sheets.

This tutorial demonstrates how to create pivot tables and bar charts in Google Sheets.

This tutorial shows how to create pivot tables and pie charts in Google Sheets.

Summary Statistics

UNIQUE COUNT COUNTIF COUNTUNIQUE Functions in Google Sheets

REGEX

CONCATENATE function

Removing Duplicate Observations in Google Sheets

Data Cleanup in Google Sheets

Data Validation in Google Sheets

The Query Function in Google Sheets

Conditional Formatting in Google Sheets

Freezing rows and columns in Google spreadsheets

Calculating a New Variable in Google Sheets

Sorting Data in Google Sheets

Wrapping Cells in Google Sheets

Importing Data from Excel into Google Sheets

Spreadsheets The Basics