Udemy

I Heart Google Sheets: Training for Skills Employers Want

立即報名
  • 418 名學生
  • 更新於 2/2016
4.4
(27 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
3 小時 35 分鐘
教學語言
英語
授課導師
Jon Chu
評分
4.4
(27 個評分)
3次瀏覽

課程簡介

I Heart Google Sheets: Training for Skills Employers Want

Comprehensive Beginner's Course to Google Sheets, a Powerful Online Cloud Alternative to Microsoft Excel

Google Sheet is an extremely powerful alternative to Microsoft's Excel spreadsheet software. Jon will teach you step-by-step how to create a basic spreadsheet and analyze the. This course covers all the essentials that will help you manipulate and analyze large sets of data. Of course, you will learn the fundamentals such as the basic calculations, formulas, creating charts, and tips & tricks that will get you started quickly.

By the end of this introductory course, you will feel confident maneuvering around Google Sheets and gain instincts to use it effectively for data analysis, and ultimately adding value to your company or to your own personal life.

In this course you will learn how to:

  • Effectively and efficiently navigate around Google Sheets
  • Enter and edit data in Google Sheets
  • Adjust the way data and information are displayed in Google Sheets
  • Write formulas quickly and easily
  • Leverage data with Vlookup, Hlookup, Index, and Pivot Tables
  • Use relative, absolute, and mixed references in Google Sheets
  • Create powerful calculations with Google Sheets functions
  • Visually represent your data with charts and graphs in Google Sheets
  • Use data tools like sorting, filtering, and filter views
  • Utilize freeze panes in Google Sheets
  • Format worksheets in Google Sheets for impact and appeal
  • Learn shortcuts, tips, and tricks
  • Learn how to use commenting and sharing in Google Sheets

  • As a fun bonus material, you will also learn how to create art with Google Sheets!

    Enroll today in this course! We are 100% confident that you will learn


課程章節

  • 9 個章節
  • 44 堂課
  • 第 1 章 Welcome!
  • 第 2 章 Menu Items & Tool Bar
  • 第 3 章 Basic Formulas
  • 第 4 章 Lookup Functions & Data Manipulation
  • 第 5 章 Charts
  • 第 6 章 Other Functions and Know-Hows!
  • 第 7 章 Common Uses for Google Sheets & Templates!
  • 第 8 章 Bonus
  • 第 9 章 Graduation

課程內容

  • Students will be become familiar of the capabilities of Google Sheets and have competencies to build their own worksheets and create their own calculations
  • Students will be able to harness their new found abilities to manipulate, analyze, and visualize data intelligibly
  • Students will be able to deconstruct and build upon already-made spreadsheets and add value in their workplace


評價

  • B
    Brianna Wilson
    5.0

    Thanks! It was a good introduction to Google Sheets for beginners.

  • E
    Eric Balthaser
    4.0

    The beginning does go over some things I am familiar with but helps explain them a little more in depth.

  • A
    Amanda
    4.0

    I enjoyed it and came away with some good understanding on how Microsoft Sheets works.

  • H
    Harlie Rose
    2.0

    The teachers presentation on lesson 3 has a toolbar blocking the main toolbar view for the student.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意