Section outline

    • Student or business person working with printed charts and spreadsheets

       

      Welcome to the Excel Course

      This lecture will take place online, with the link provided below. Please make sure you have the Excel exercise file open beforehand so we can work through it together in real time.

      The idea of the course is to introduce you to the basics of working with Excel. We will cover:

      1. Cells, Ranges & Addressing
      2. Worked Example: Computing Growth
      3. Relative References
      4. Absolute References
      5. Mixed References
      6. Naming Cells and Ranges
      7. IF & Nested IF
      8. Conditional Aggregation (SUMIF, COUNTIF, AVERAGEIF)
      9. Rounding & Number Functions (ROUND, ROUNDUP, ROUNDDOWN, ABS, INT)
      10. Sort & Filter
      11. Lookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
      12. Data Validation
      13. Data Cleaning
      14. Scatter Plots & Trendlines
      15. PivotTables
      16. Descriptive Statistics
      17. Histograms & Correlation
      18. t-Tests
      19. Regression

    • Pre-sessional for Excel Recording Page
    • Course material Book