Spreadsheets for Finance and Accounting

  1. Data Analysis and Visualization
    1. PivotTable Analysis
      1. PivotTable Creation
        1. Field Arrangement
          1. Data Summarization
            1. Grouping Techniques
              1. Calculated Fields
                1. Slicer Implementation
                  1. Timeline Usage
                  2. Chart Creation
                    1. Chart Type Selection
                      1. Data Series Management
                        1. Chart Formatting
                          1. Dynamic Charting
                            1. Combination Charts
                              1. Sparklines
                              2. Dashboard Development
                                1. Dashboard Design Principles
                                  1. Interactive Elements
                                    1. Key Performance Indicators
                                      1. Visual Hierarchy
                                        1. User Experience Design
                                        2. Conditional Formatting
                                          1. Rule Creation
                                            1. Data Bars
                                              1. Color Scales
                                                1. Icon Sets
                                                  1. Custom Formatting
                                                    1. Performance Indicators

                                                  Previous

                                                  10. Advanced Analysis Tools

                                                  Go to top

                                                  Next

                                                  12. Professional Reporting