Building Candlestick Charts with Microsoft Excel

Offered By
Coursera Project Network
In this Guided Project, you will:

Create candlestick chart

Format candlestick chart

Add refresh buttons to update data for candlestick chart

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will create a candlestick chart with open, high, low, and close data from the stock market, and you will also set up an auto-refresh function to get the live data. Your new skills will help you create an informative candlestick chart in Microsoft Excel to reflect trends in the stock market.

Skills you will develop

  • Microsoft Excel
  • Chart
  • Candlestick chart

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Analyze when to use a candlestick chart

  2. Collect data for candlestick chart

  3. Create candlestick chart

  4. Create refresh button

  5. Create chart button

How Guided Projects work

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

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.