Udemy

Google Sheets + MS Excel Course: Basic to Advance Level

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

課程資料

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

課程簡介

Google Sheets + MS Excel Course: Basic to Advance Level

Master Google Sheets & Excel - Learn Complex Data Analysis. Become an Expert: Learn Pivot Tables, QUERY & many more

When its come to open source cloud based Spreadsheet solution Google sheet has no competition, however in the desktop based scenario MS Excel has the dominance. Even though both are have many similarities, the differences also need attention and required training. In this 14 hours of training with 127 lectures videos, you will be taken through the fundamentals of Excel and Google sheets till the Expertise level.

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk or from your smartphone or tablet on the go Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.

In this course you will learn the fundamentals as advance topics of Google Sheets (much of which can be used in MS Excel as well). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like TEXT Function, LOGICAL Function, TEXT Function, LOOKUP Function and many more.

Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level in the version 2010.


課程章節

  • 10 個章節
  • 130 堂課
  • 第 1 章 Getting started in Google Sheets
  • 第 2 章 Google Sheets: Mathematical Operators and Functions
  • 第 3 章 Google Sheets: Logical Operators and Functions
  • 第 4 章 Google Sheets: Text Functions and Text to Column
  • 第 5 章 Google Sheets: Data Organizing and Formatting
  • 第 6 章 Google Sheets: Data Naming, Linking and Validating
  • 第 7 章 Google Sheets: Pivot Table and Chart Preparation
  • 第 8 章 Google Sheets: Lookup and Reference Functions
  • 第 9 章 Google Sheets: Date and Time Management
  • 第 10 章 Google Sheets - Financial Functions

課程內容

  • Good understanding of Google Sheets and Microsoft Excel at MIS level
  • Expertise in Text, Logical and Math Function
  • Expertise in Lookup and Reference Function
  • Expertise in Date and Time Function
  • Mastery in Pivot Table and Chart Preparation
  • Mastery in 'What if Analysis' tools
  • Data Validation, Filter and Conditional Formatting
  • Managing data protection and data sharing in Excel
  • Work with Macro Recording
  • Working with Named Ranges and Link
  • Working Knowledge of Financial Functions
  • Creating amazing Google Forms
  • Get to learn two most used Spreadsheet from basic to advance


評價

  • J
    Janani
    5.0

    This class is very useful for me

  • S
    Sunit Kushwaha
    4.0

    He delivered required information as it mentioned in course. He delivered use of functions from beginning to advance.

  • A
    Atharva Pandit
    4.0

    nice course

  • M
    Misheck Jim Mwamba
    4.5

    It is good and I am on it until I finish

立即關注瀏覽更多

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

我已閱讀及同意