Spreadsheets for Finance and Accounting

  1. Data Entry and Basic Formatting
    1. Data Input Techniques
      1. Text Entry
        1. Number Entry
          1. Date and Time Entry
            1. Data Validation During Entry
              1. AutoFill and Series Creation
                1. Copy and Paste Operations
                2. Cell Formatting Fundamentals
                  1. Font Properties
                    1. Cell Alignment
                      1. Text Wrapping
                        1. Cell Borders
                          1. Fill Colors and Patterns
                            1. Merging Cells
                            2. Number Formatting for Finance
                              1. Currency Formatting
                                1. Accounting Number Format
                                  1. Percentage Formatting
                                    1. Decimal Places Control
                                      1. Thousands Separators
                                        1. Custom Number Formats
                                          1. Negative Number Display
                                          2. Row and Column Management
                                            1. Inserting and Deleting Rows
                                              1. Inserting and Deleting Columns
                                                1. Adjusting Row Heights
                                                  1. Adjusting Column Widths
                                                    1. Hiding and Unhiding Elements
                                                      1. Freezing Panes

                                                    Previous

                                                    1. Spreadsheet Environment and Setup

                                                    Go to top

                                                    Next

                                                    3. Formula Fundamentals