Catalog cursuri

Google Sheets

11200,00
RON
18700,00
RON
Trimite o cerere
Dive into Google Sheets, covering everything from fundamental concepts to advanced data analysis techniques. Designed for both beginners and experienced users, the course will enhance your ability to work efficiently with spreadsheets, analyze data effectively, and leverage Google Sheets' powerful tools for business applications. Through interactive lessons, practical exercises, and real-world scenarios, participants will gain the proficiency needed to use Google Sheets confidently in a professional setting.
Course Structure
Specifications

Course Structure

Module 1: Getting Started with Google Sheets (6 sessions)

  • Welcome to the Course: Get the Most Out of This Course
  • Course Resources: GET ALL COURSE FILES HERE
  • Pre-assessment Quiz: Check Your Current Knowledge
  • Google Sheets Essentials: Sheets Basics for a Smooth Start
  • Productivity Tips: File Sharing and Menu Navigation
  • Activity and Quiz: Test Your Knowledge - Getting Started

Module 2: Data Management and Basic Formulas (6 sessions)

  • Data Entry Techniques and Basic Formulas
  • Exploring Common Functions: Sum, Count, and Relative vs. Absolute Referencing
  • Productivity in Google Sheets: Tips and Shortcuts
  • Conditional Formatting and Data Validation
  • Working with External Data: Excel, CSV, and Importing
  • Quiz: Test Your Knowledge on Data Management

Module 3: Advanced Data Handling and Analysis (6 sessions)

  • Sorting, Filtering, and Cleaning Data
  • Advanced Functions: Unique, Sort, Sumifs, and Logical Functions
  • Error Management and Named Ranges
  • Using Array Formulas and Manipulating Arrays
  • The Power of Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP
  • Quiz: Advanced Data Handling and Analysis

Module 4: Visualizations and Reporting (5 sessions)

  • Creating and Customizing Charts to Impress
  • Advanced Chart Techniques: Combo and Gauge Charts
  • Using Google Sheets for Dashboards: Slicers and Sparklines
  • Pivot Tables: Basics to Advanced Uses
  • Final Challenge: Creating Comprehensive Reports and Dashboards

Module 5: Automation and Scripting (5 sessions)

  • Introduction to Google Sheets Apps Script and Macros
  • Recording and Using Macros in Google Sheets
  • Automating Tasks with Custom Scripts
  • Exploring Add-Ons and Integrations for Enhanced Functionality
  • Final Assessment: Automate a Routine Task Using Apps Script

Specifications

Format: 1:1 & Group

Recommended Sessions: 28

Level: Beginner

See also