Description
Google Sheets for Beginners with AI is a hands-on project focused on solving practical trainings needs. Throughout the training, students will build complete Google Sheets demos using real-world scenarios and datasets. At the completion of training, students will have developed tangible demos for work portfolios as well as improved technical skillsets in Google Sheets and enhanced conceptional understandings of data science.
Benefits
• Tangible demos for work portfolios
• Technical skillsets in Formatting, Data Validations, Sorting, Filtering, Functions, Charts, and Conditional Formatting
• Conceptual understandings of data preparations, data transformations, data analytics, data visualizations, and AI
• Self paced trainings
• AI Solutions Hub
Topics
• Module 1 – Build, organize, and format a spreadsheet using Google Sheets:
1.1. Introduction to Module 1
1.2. Duplicate Your Sheet and Add New Data
1.3. Format and Organize Spreadsheet Data
1.4. Continue Formatting and Organizing
1.5. Add Data Validation to Limit Options
1.6. Sort Your Data
1.7. Wrap-Up
Try with AI – Sorting
• Module 2 – Evaluate and interpret data with different spreadsheet functions, filters, and charts using Google Sheets:
2.1. Introduction to Module 2
2.2. Create Filters and Use Filter Views
2.3. Use Filters to Count, Add, and Summarize Data in a Table
2.4. Use the SUM Function to Analyze Data
2.5. Display Data in a Chart
2.6. Use COUNTIF to Generate Numeric Data with Text Values
2.7. Share and Collaborate
2.8. Wrap-Up
Try with AI – Functions
• Module 3 – Use advanced functions and conditional formatting in Google Sheets:
3.1. Introduction to Module 3
3.2. Copy Sheets Into Your Spreadsheet
3.3. Use Functions to Calculate Cost and Current Sales
3.4. Use Functions to Summarize Data and Calculate Profit
3.5. Use the MIN, MAX, and AVERAGE Functions to Analyze Sales Data
3.6. Add Conditional Formatting to Emphasize Data
3.7. Insert Links, Images, and Drawings
3.8. Wrap-Up
Try with AI – Image to Text
Deliverables
• Access to Google Classroom with Scenarios, Datasets, Tutorials, Demos, and AI Solutions Hub
Requirements
• Google Classroom, Google Sheets, Google Drive
Policies
• Cancellation Policy – Ineligible for exchange or refund
