Spreadsheets for Finance and Accounting

  1. Data Organization and Management
    1. Sorting Techniques
      1. Single Column Sorting
        1. Multi-Level Sorting
          1. Custom Sort Orders
            1. Sorting by Color or Icon
              1. Maintaining Data Relationships
              2. Filtering Methods
                1. AutoFilter Setup
                  1. Filter by Values
                    1. Filter by Color
                      1. Filter by Icon
                        1. Advanced Filter
                          1. Criteria Ranges
                            1. Extract Unique Records
                            2. Data Validation
                              1. Input Restrictions
                                1. Date Constraints
                                  1. Number Ranges
                                    1. Text Length Limits
                                      1. Custom Validation Rules
                                        1. Input Messages
                                          1. Error Alerts
                                          2. Named Ranges
                                            1. Creating Named Ranges
                                              1. Managing Named Ranges
                                                1. Using Names in Formulas
                                                  1. Dynamic Named Ranges
                                                    1. Scope Management
                                                    2. Table Structures
                                                      1. Converting Ranges to Tables
                                                        1. Table Formatting Options
                                                          1. Structured References
                                                            1. Calculated Columns
                                                              1. Total Rows
                                                                1. Table Expansion
                                                                  1. Converting Tables to Ranges

                                                                Previous

                                                                4. Essential Financial Functions

                                                                Go to top

                                                                Next

                                                                6. Financial Model Design Principles