Data Analysis with Spreadsheets

  1. Data Visualization and Chart Creation
    1. Visualization Principles
      1. Chart Selection Criteria
        1. Data Type Considerations
          1. Message Communication
            1. Audience Appropriateness
            2. Design Best Practices
              1. Clarity and Simplicity
                1. Color Usage Guidelines
                  1. Avoiding Chart Junk
                    1. Accessibility Considerations
                  2. Basic Chart Types
                    1. Column and Bar Charts
                      1. Clustered Charts
                        1. Stacked Charts
                          1. 100% Stacked Charts
                            1. 3D Chart Variations
                            2. Line Charts
                              1. Simple Line Charts
                                1. Multiple Series Lines
                                  1. Stacked Line Charts
                                    1. Line with Markers
                                    2. Pie and Doughnut Charts
                                      1. Basic Pie Charts
                                        1. Exploded Pie Charts
                                          1. Doughnut Charts
                                            1. Pie of Pie Charts
                                            2. Area Charts
                                              1. Simple Area Charts
                                                1. Stacked Area Charts
                                                  1. 100% Stacked Area Charts
                                                2. Advanced Chart Types
                                                  1. Scatter Plots
                                                    1. XY Scatter Charts
                                                      1. Bubble Charts
                                                        1. Trend Analysis
                                                          1. Correlation Visualization
                                                          2. Statistical Charts
                                                            1. Histogram Charts
                                                              1. Box and Whisker Plots
                                                                1. Pareto Charts
                                                                2. Specialized Charts
                                                                  1. Waterfall Charts
                                                                    1. Funnel Charts
                                                                      1. Sunburst Charts
                                                                        1. Treemap Charts
                                                                      2. Chart Formatting and Customization
                                                                        1. Chart Elements
                                                                          1. Chart Titles
                                                                            1. Axis Titles
                                                                              1. Legend Formatting
                                                                                1. Data Labels
                                                                                  1. Gridlines
                                                                                  2. Data Series Formatting
                                                                                    1. Color Schemes
                                                                                      1. Line Styles
                                                                                        1. Marker Options
                                                                                          1. Fill Patterns
                                                                                          2. Axis Formatting
                                                                                            1. Scale Settings
                                                                                              1. Number Formatting
                                                                                                1. Axis Position
                                                                                                  1. Tick Marks
                                                                                                  2. Chart Layout
                                                                                                    1. Chart Size and Position
                                                                                                      1. Plot Area Formatting
                                                                                                        1. Chart Background
                                                                                                      2. Trendlines and Analysis
                                                                                                        1. Trendline Types
                                                                                                          1. Linear Trendlines
                                                                                                            1. Exponential Trendlines
                                                                                                              1. Polynomial Trendlines
                                                                                                                1. Moving Average Trendlines
                                                                                                                2. Trendline Options
                                                                                                                  1. R-squared Values
                                                                                                                    1. Equation Display
                                                                                                                      1. Forecasting
                                                                                                                        1. Intercept Settings
                                                                                                                      2. Conditional Formatting
                                                                                                                        1. Rule-Based Formatting
                                                                                                                          1. Highlight Cell Rules
                                                                                                                            1. Top/Bottom Rules
                                                                                                                              1. Data Bars
                                                                                                                                1. Color Scales
                                                                                                                                  1. Icon Sets
                                                                                                                                  2. Custom Conditional Formatting
                                                                                                                                    1. Formula-Based Rules
                                                                                                                                      1. Multiple Condition Rules
                                                                                                                                        1. Conditional Formatting Management
                                                                                                                                        2. Advanced Formatting Techniques
                                                                                                                                          1. Heat Maps
                                                                                                                                            1. Progress Indicators
                                                                                                                                              1. Status Dashboards
                                                                                                                                            2. Sparklines and In-Cell Charts
                                                                                                                                              1. Sparkline Types
                                                                                                                                                1. Line Sparklines
                                                                                                                                                  1. Column Sparklines
                                                                                                                                                    1. Win/Loss Sparklines
                                                                                                                                                    2. Sparkline Formatting
                                                                                                                                                      1. Color Options
                                                                                                                                                        1. Marker Settings
                                                                                                                                                          1. Axis Scaling
                                                                                                                                                          2. Sparkline Groups
                                                                                                                                                            1. Creating Sparkline Groups
                                                                                                                                                              1. Group Formatting
                                                                                                                                                                1. Individual Sparkline Editing
                                                                                                                                                              2. Dashboard Creation
                                                                                                                                                                1. Dashboard Design Principles
                                                                                                                                                                  1. Layout Planning
                                                                                                                                                                    1. Visual Hierarchy
                                                                                                                                                                      1. Information Flow
                                                                                                                                                                        1. User Experience
                                                                                                                                                                        2. Interactive Elements
                                                                                                                                                                          1. Slicer Integration
                                                                                                                                                                            1. Form Controls
                                                                                                                                                                              1. Dynamic Titles
                                                                                                                                                                              2. Dashboard Components
                                                                                                                                                                                1. Key Performance Indicators
                                                                                                                                                                                  1. Summary Tables
                                                                                                                                                                                    1. Chart Combinations
                                                                                                                                                                                      1. Status Indicators

                                                                                                                                                                                  Previous

                                                                                                                                                                                  6. Pivot Table Analysis

                                                                                                                                                                                  Go to top

                                                                                                                                                                                  Next

                                                                                                                                                                                  8. What-If Analysis and Scenario Planning