Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Sheets - The Complete Google Sheets Course
Rating: 4.1 out of 5(202 ratings)
25,282 students
Created byClick Learning
Last updated 12/2023
English

What you'll learn

  • Create beautiful spreadsheets with amazing formatting tricks
  • Learn formulas that work in both Google sheets & Excel
  • Automate your work with Macros
  • All Lookup Functions
  • Create interactive & visually effective dashboards in Sheets
  • Use different types of functions for Data Cleaning and Data Analysis

Course content

1 section • 25 lectures • 2h 58m total length

  • User Interface Overview10:33
  • Find and replace4:44
  • Rivison History2:22
  • Creating, Renaming and Sharing5:32
  • Formatting Basic9:04

    Master basic formatting in Google Sheets, including font style and size, bold, italic, underline and strikethrough, text and fill colors, alignment, and currency and decimal controls.

  • Logical Functions (AND, OR IF)8:03
  • Math Functions (SUM, AVERAGE, MAX, MIN, COUNT )11:54
  • Text Functions (LOWER, UPPER, CONCATENATE, PROPER)11:38
  • Left and Right Function6:01
  • Introduction to Charts and Graphs11:16
  • Line Charts in Google Sheets5:35
  • Column Charts in Google Sheets6:05
  • Bar Charts in Google Sheets6:16
  • Pie Chart7:33

    Create and customize a pie chart in Google Sheets to visualize data as percentages, from preparing data to selecting chart options, customizing slices, and sharing or embedding.

  • Area Charts in Google Sheets6:33
  • Scatter Chart4:16
  • Tree Map Charts in Google Sheets5:25
  • Organizational Charts in Google Sheets6:13
  • Sort and Filter Data7:04
  • Data Import (Web and HTML Table)6:25
  • VLOOKUP6:34
  • HLOOKUP9:37
  • Xlookup Google Sheets5:51
  • Macros in Google Sheets6:52

    Learn how to automate repetitive tasks in Google Sheets by recording and applying macros. Create and manage macros to format data as tables, perform data cleaning, and generate consistent reports.

  • Freezing Rows and Columns7:29

    Learn how to freeze rows and columns in Google Sheets to keep headers visible while scrolling. Explore the view tab, zoom levels, and practical tips from a daily schedule example.

Requirements

  • You need only Google account

Description

Are you ready to master the art of data manipulation, analysis, and collaboration in the cloud using one of the most powerful spreadsheet tools available? Welcome to "Google Sheets - The Complete Google Sheets Course," your all-encompassing guide to becoming a Google Sheets expert.


Google Sheets is not just a spreadsheet program; it's a dynamic, collaborative, and data-driven tool that simplifies and enhances your ability to work with numbers, charts, and more. Whether you're a business professional, student, educator, or someone simply looking to supercharge your spreadsheet skills, this course is your key to mastering Google Sheets


Get to know the basics of Google Sheets, its interface, and its versatile applications in various fields. Learn to create, format, and organize data in Google Sheets, from simple to complex data sets.


Master the use of formulas, functions, and data analysis tools to derive meaningful insights from your data. Create visually compelling charts, graphs, and pivot tables to represent your data effectively.


Streamline your data management, analysis, and collaboration with Google Sheets. Enroll today in "Google Sheets - The Complete Google Sheets Course" and unlock the full potential of this versatile tool. Don't miss this opportunity to become a Google Sheets pro and revolutionize your data-driven work. Your journey to Google Sheets mastery begins now!

Who this course is for:

  • Learning and implementing Google Forms completely
  • Who are interested in creating online surveys and feedbacks for business

Report abuse