Skip to main content
Back to course
Log in
Get started
Someone wanted to learn this too, so Grasp built them a personal learning path.
Create your own
Visualize financial market data
·
Module 1
Data Foundations in Excel
1
Importing Financial Data to Excel
Import financial data from CSV and web sources into Excel.
Import financial data from CSV and web sources into Excel.
2
Structuring Financial Data for Analysis
Format and structure financial data tables for analysis and visualization.
Format and structure financial data tables for analysis and visualization.
3
Cleaning Financial Data: Missing Values and Data Types
Clean financial data by handling missing values and correcting data types.
Clean financial data by handling missing values and correcting data types.
4
Excel Formulas for Financial Metrics
Use Excel formulas to calculate key financial metrics such as simple returns and moving averages.
Use Excel formulas to calculate key financial metrics such as simple returns and moving averages.
5
Highlighting Financial Data with Conditional Formatting
Apply conditional formatting to highlight key data patterns in financial tables.
Apply conditional formatting to highlight key data patterns in financial tables.
6
Dynamic Charting with Excel Tables
Organize data for charting using Excel Tables for dynamic updates.
Organize data for charting using Excel Tables for dynamic updates.
Previous module
Next module
Core Financial Charting in Excel