Data Analysis with Spreadsheets - DATA 110
Covers formulas, functions, tables, charts, filtering, pivot tables, descriptive statistics, and basic data analysis workflows.
Focused study of mutual funds, ETFs and pooled-investment structures.
Understanding Pooled Investments
Understanding Fund Objectives, Strategies, and Structures
Pooled Investments and NAV
How Mutual Funds and ETFs Are Structured
Evaluating a Fund Before Investing
Comparing Fund Costs in Context
Choosing a Fund That Fits
Calculating Fund NAV per Share
Understanding Fund Risk and Performance
Fund Objectives, Strategies, and Risks
Comparing Fund Costs and Tracking
Fund NAV, ETF Trading, and Liquidity
Assessing Fund Suitability
Investment Funds: Diversification, Costs, Performance, and Risk
Pooled Funds, NAV, and Fund Pricing
Mutual Fund and ETF Structure
U.S. Investment Funds: Regulation, Taxation, and Protections
Pooled Funds, NAV, and Market Prices
Fund Structure, NAV, and ETF Trading
Pooled Investments, NAV, and Fund Pricing
Fund Investing: Taxes, Protections, and Due Diligence
Mutual Fund Objectives and Strategies
Evaluating and Comparing Investment Funds
Fund NAV and ETF Trading
Investment Performance and Risk
Pooled Investment Funds
Comparing Fund Costs and Tax Effects