Spreadsheets for Finance and Accounting

  1. Formula Fundamentals
    1. Formula Structure and Syntax
      1. Formula Entry Methods
        1. Equal Sign Usage
          1. Formula Components
            1. Error Messages and Types
              1. Formula Auditing Tools
              2. Arithmetic Operations
                1. Addition
                  1. Subtraction
                    1. Multiplication
                      1. Division
                        1. Exponentiation
                          1. Order of Operations
                            1. Parentheses Usage
                            2. Cell Reference Types
                              1. Relative References
                                1. Absolute References
                                  1. Mixed References
                                    1. Reference Behavior When Copying
                                      1. External References
                                        1. 3D References
                                        2. Basic Built-in Functions
                                          1. SUM Function
                                            1. AVERAGE Function
                                              1. COUNT and COUNTA Functions
                                                1. MAX and MIN Functions
                                                  1. Function Syntax Rules
                                                    1. Nesting Functions

                                                  Previous

                                                  2. Data Entry and Basic Formatting

                                                  Go to top

                                                  Next

                                                  4. Essential Financial Functions