Spreadsheets for Finance and Accounting

Spreadsheets for Finance and Accounting focuses on the practical application of spreadsheet software, such as Microsoft Excel and Google Sheets, as a fundamental tool for financial professionals. This area involves mastering core functionalities to organize financial data, perform complex calculations using formulas, and build dynamic models for budgeting, forecasting, and valuation. Ultimately, these skills are used to create professional financial statements, dashboards, and charts that analyze business performance and communicate key insights to support strategic decision-making.

1. Spreadsheet Environment and Setup
   1. Spreadsheet Software Overview
      1. Microsoft Excel
      2. Google Sheets
      3. LibreOffice Calc
      4. Software Selection Criteria
   2. User Interface Components
      1. Ribbon and Menu Systems
      2. Quick Access Toolbar
      3. Formula Bar
      4. Status Bar
      5. Worksheet Tabs
      6. Scroll Bars and Navigation
   3. Workbook and Worksheet Management
      1. Creating New Workbooks
      2. Opening and Saving Files
      3. File Formats and Compatibility
      4. Adding and Deleting Worksheets
      5. Renaming and Organizing Worksheets
      6. Moving and Copying Worksheets
      7. Worksheet Protection
   4. Cell Structure and Navigation
      1. Cell References and Addressing
      2. Row and Column Headers
      3. Selecting Cells and Ranges
      4. Keyboard Navigation Shortcuts
      5. Name Box Usage
      6. Go To Function