Class Notes

Class notes will be placed here.
The course outline includes:
  1. Review of spreadsheet techniques
    1. Basic computations
    2. Naming cells and ranges
    3. Functions vs. formulas
    4. Working with multi-worksheet spreadsheets
  2. Functions
    1. Finding and using new functions
    2. Review of lookup functions
    3. Review of logical functions
    4. Text manipulation
    5. Dates and times
    6. Conditional functions (e.g., sumif)
  3. Pivot tables
    1. Building pivot tables
    2. Calculations in a pivot table
    3. Relation manager
    4. Pivot charts
    5. Slicers and customized user interfaces
  4. Graphs and data visualization
    1. Review of graph types
    2. Advance graph configuration
    3. Communicating effectively with graphs
  5. Advanced spreadsheet features
    1. Importing and cleaning data
    2. Data validation
    3. What if analysis
    4. Solvers and Goal Seek
    5. Data analysis packages
  6. Interacting with databases
    1. Overview of databases
    2. Introduction to the Structured Query Language (SQL)
    3. Constructing single table databases
    4. Interfacing spreadsheets with database engines
  7. Extending spreadsheets with macros and scripting languages
    1. Creating custom worksheet functions
    2. Creating and employing user forms
    3. Dealing with events
    4. Interfacing with other applications