From the course: Excel PivotTables: Real-World Case Studies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Stock market data

Stock market data - Microsoft Excel Tutorial

From the course: Excel PivotTables: Real-World Case Studies

Start my 1-month free trial

Stock market data

“

- [Instructor] All right, our next case study is using stock market data. And we have a pretty simple dataset to work with here. It's a three month sample with stock market data for about 500 different publicly traded companies. And looking at the screenshot to the right here, we've got 29,440 observations with just a few simple dimensions and measures. So the only dimensions that we'll work with here are date and symbol. And then for measures, pretty standard financial stock market measures. We've got the open price, high and low prices for today, the close price and the trading volume. And the concepts that we'll cover in this kickoff include some basic sorting and filtering. I'll really focus on conditional formatting here, to really use visualizations to tell a story. We'll practice highlight cell rules, we'll do some really cool demos with data bars and then we'll wrap up with some value settings, like percent difference from, which is a great tool to show day-over-day gains and…

Contents