Understand how stock exchange information can be visualized from a spreadsheet
Understand Google Finance syntax within Google Sheets
Perform analysis and produce data visualization elements of the data set
Showcase this hands-on experience in an interview
Have you ever wondered how to capture the always-changing stock prices of various companies into a concise dashboard? Global stock markets are ecosystems containing many changing data such as company stock prices, volumes, and currencies. Traders, bankers, investors and many more watch how these markets interact with changing news, which can ultimately impact their investment portfolios. By the end of this project, you will be able to create a stock dashboard using Google Sheets. You will use Google Sheets inbuilt formulas to come up with recent data that was traded in the New York Stock Exchange (NYSE), and use data visualization to summarize multiple data points into charts and infographics to make it easy to understand how particular stocks performed over a given period. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
Familiarity with the stock market, Google Sheets, or any other spreadsheet software (not required, but preferred).
在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:
Introduction and access Google Sheets
Identify key Google Finance formulas and its parameters
Create a data source of information
Analyze the data set and create charts of the analyzed data
Create a summarized dashboard of charts and infographics
您的工作空間就是瀏覽器中的雲桌面,無需下載
在分屏視頻中,您的授課教師會為您提供分步指導
i had hard time because i was busy at my job and at the same time listening to the video sample which made it harder for me. I hope you extend more time in using the tools. thank you for new learning.
As a first time learner at coursera i feel i am such a great platform to learn and groom our resume.
This Course is Unique and very useful. I loved it.
指導項目可在台式設備和移動設備上學習嗎?
由於您的工作空間包含適合筆記本電腦或台式計算機使用的雲桌面,因此指導項目不在移動設備上提供。
指導項目的講師是誰?
指導項目講師是特定領域的專家,他們在項目的技能、工具或領域方面經驗豐富,並且熱衷於分享自己的知識以影響全球數百萬的學生。
我能在完成指導項目後從中下載作品嗎?
您可以從指導項目中下載並保留您創建的任何文件。為此,您可以在訪問云桌面時使用‘文件瀏覽器’功能。
我需要具備多少經驗才能做這個指導項目?
您可在頁面頂部點按此指導項目的經驗級別,查看任何知識先決條件。對於指導項目的每個級別,您的講師會逐步為您提供指導。
我能直接通過 Web 瀏覽器來完成此指導項目,而不必安裝特殊軟件嗎?
是,您可以在瀏覽器的雲桌面中獲得完成指導項目所需的一切。
指導項目的學習體驗如何?
您可以直接在瀏覽器中於分屏環境下完成任務,以此從做中學。在屏幕的左側,您將在工作空間中完成任務。在屏幕的右側,您將看到有講師逐步指導您完成項目。
還有其他問題嗎?請訪問 學生幫助中心。