UsefulLinks
Business and Management
Finance and Accounting
Accounting
Spreadsheets for Finance and Accounting
1. Spreadsheet Environment and Setup
2. Data Entry and Basic Formatting
3. Formula Fundamentals
4. Essential Financial Functions
5. Data Organization and Management
6. Financial Model Design Principles
7. Three-Statement Financial Modeling
8. Valuation Modeling Techniques
9. Budgeting and Forecasting Models
10. Advanced Analysis Tools
11. Data Analysis and Visualization
12. Professional Reporting
3.
Formula Fundamentals
3.1.
Formula Structure and Syntax
3.1.1.
Formula Entry Methods
3.1.2.
Equal Sign Usage
3.1.3.
Formula Components
3.1.4.
Error Messages and Types
3.1.5.
Formula Auditing Tools
3.2.
Arithmetic Operations
3.2.1.
Addition
3.2.2.
Subtraction
3.2.3.
Multiplication
3.2.4.
Division
3.2.5.
Exponentiation
3.2.6.
Order of Operations
3.2.7.
Parentheses Usage
3.3.
Cell Reference Types
3.3.1.
Relative References
3.3.2.
Absolute References
3.3.3.
Mixed References
3.3.4.
Reference Behavior When Copying
3.3.5.
External References
3.3.6.
3D References
3.4.
Basic Built-in Functions
3.4.1.
SUM Function
3.4.2.
AVERAGE Function
3.4.3.
COUNT and COUNTA Functions
3.4.4.
MAX and MIN Functions
3.4.5.
Function Syntax Rules
3.4.6.
Nesting Functions
Previous
2. Data Entry and Basic Formatting
Go to top
Next
4. Essential Financial Functions