UsefulLinks
Business and Management
Finance and Accounting
Accounting
Spreadsheets for Finance and Accounting
1. Spreadsheet Environment and Setup
2. Data Entry and Basic Formatting
3. Formula Fundamentals
4. Essential Financial Functions
5. Data Organization and Management
6. Financial Model Design Principles
7. Three-Statement Financial Modeling
8. Valuation Modeling Techniques
9. Budgeting and Forecasting Models
10. Advanced Analysis Tools
11. Data Analysis and Visualization
12. Professional Reporting
11.
Data Analysis and Visualization
11.1.
PivotTable Analysis
11.1.1.
PivotTable Creation
11.1.2.
Field Arrangement
11.1.3.
Data Summarization
11.1.4.
Grouping Techniques
11.1.5.
Calculated Fields
11.1.6.
Slicer Implementation
11.1.7.
Timeline Usage
11.2.
Chart Creation
11.2.1.
Chart Type Selection
11.2.2.
Data Series Management
11.2.3.
Chart Formatting
11.2.4.
Dynamic Charting
11.2.5.
Combination Charts
11.2.6.
Sparklines
11.3.
Dashboard Development
11.3.1.
Dashboard Design Principles
11.3.2.
Interactive Elements
11.3.3.
Key Performance Indicators
11.3.4.
Visual Hierarchy
11.3.5.
User Experience Design
11.4.
Conditional Formatting
11.4.1.
Rule Creation
11.4.2.
Data Bars
11.4.3.
Color Scales
11.4.4.
Icon Sets
11.4.5.
Custom Formatting
11.4.6.
Performance Indicators
Previous
10. Advanced Analysis Tools
Go to top
Next
12. Professional Reporting