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 tutorial, 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).
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
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
Your workspace is a cloud desktop right in your browser, no download required
In a split-screen video, your instructor guides you step-by-step
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.
Very informational and useful. Wish it was a little bit more detailed for first timer.
This Course is Unique and very useful. I loved it.
Are Guided Tutorials available on desktop and mobile?
Because your workspace contains a cloud desktop that is sized for a laptop or desktop computer, Guided Tutorials are not available on your mobile device.
Who are the instructors for Guided Tutorials?
Guided Tutorial instructors are subject matter experts who have experience in the skill, tool or domain of their project and are passionate about sharing their knowledge to impact millions of learners around the world.
Can I download the work from my Guided Tutorial after I complete it?
You can download and keep any of your created files from the Guided Tutorial. To do so, you can use the “File Browser” feature while you are accessing your cloud desktop.
How much experience do I need to do this Guided Tutorial?
At the top of the page, you can press on the experience level for this Guided Tutorial to view any knowledge prerequisites. For every level of Guided Tutorial, your instructor will walk you through step-by-step.
Can I complete this Guided Tutorial right through my web browser, instead of installing special software?
Yes, everything you need to complete your Guided Tutorial will be available in a cloud desktop that is available in your browser.
What is the learning experience like with Guided Tutorials?
You'll learn by doing through completing tasks in a split-screen environment directly in your browser. On the left side of the screen, you'll complete the task in your workspace. On the right side of the screen, you'll watch an instructor walk you through the project, step-by-step.
More questions? Visit the Learner Help Center.