YoVDO

Google Sheets Advanced Tutorial

Offered By: Learnit Training via YouTube

Tags

Google Sheets Courses Data Analysis Courses Data Sorting Courses Data Filtering Courses Pivot Tables Courses Macros Courses VLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Master advanced techniques in Google Sheets with this comprehensive tutorial designed for anyone looking to enhance their data management and analysis skills. Learn to navigate the application, create and share spreadsheets, and perform complex calculations using functions and formulas. Explore data manipulation through filtering, sorting, and pivot tables. Dive into advanced features such as AutoFill, VLOOKUP, macros, and real-time collaboration. Create visually appealing charts, use conditional formatting, and leverage add-ons to extend functionality. Gain hands-on experience with popular functions like IF, SUMIF, AVERAGEIF, and CONCATENATE. Discover the power of Google Apps Scripts for automation and customization. By the end of this 1-hour 11-minute tutorial, you'll have the skills to efficiently gather, format, and interpret data in Google's free, web-based spreadsheet application.

Syllabus

Start
Introduction
List, Format, and Sort
Multi-Column Sort
Filters
Conditional Filters and Filtered Views
Creating Charts
Editing Charts
Removing and Deleting Chart Data
Sparklines
Formatting with Alternating Row Colors
Pivot Tables
Pivot Charts
Named Ranges
IF Functions
Nested Functions
VLOOKUP
SUMIF and AVERAGEIF
SUMIFS
AVERAGEIFS
IFERROR
LEFT and RIGHT
CONCATENATE
Sharing Files
Real-Time Authoring
Google Sheets Add-Ons
Introduction to Google Apps Scripts
Conclusion


Taught by

Learnit Training

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX
Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera
Data Processing and Analysis with Excel
Rochester Institute of Technology via edX
Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera
Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera