Class Notes

• A comment on the book and direction for the class.
• Chapters 4 and 5
  • Getting a data set
  • Basic Analaysis of the data set
  • Tidy Data
  • Tables
• Chapter 17
  • Introduction to Arrays
  • Generating a range of values in an array
  • Single Cell Array Formulas
• Chapter 13, counting
  • Counting
  • Counting II
• A little clean up
• Chapter 14, Lookup
  • Lookup and Index/match
• Proposal Presentation Schedule, 3/14
• Chapter 33 Pivot Tables.
  • Another A Cool Pivot Table exercise.
  • More Basic Pivot Tables.
• Databases
  • Introduction
  • Just Enough SQL
  • Excel and Access
  • The Query Manager
• More Pivot Tables
  • The Sheriff Sales Data
  • The End of Chapter 34
• Extending Excel through VBA
  • Introduction to VBA Part 1
  • Two types of macros
  • Sub functions
  • Chapter 40 and start of 41
  • UserForms part 1
• Starting 4/4 through 4/18 Sign up for a 5-10 minute progress report.

  • Date	Time	Presenter
    4/4	4:30	Lance Wagner
    	4:37	Brandon Eschborn
    4/9	4:30	Halie Lewis
    	4:37	Jordan Gregor
    4/11	3:30	Kevin Cox
    	3:40	Anthony Wagner
    	3:50	Neil Noyes
    4/16	3:30	John Kaul
    	3:40	Ethen Omer

• 4/23 Final Exam
• 4/25 Presentations

  • Time	Presenter
    3:30	Halie Lewis
    3:45	Lance Wagner

• 5/2 Presentations

  • 12:30	Jordan Gregor
    12:45	Brandon Eschborn
    1:00	Anthony Wagner
    1:15	Neil Noyes
    1:30	John Kaul
    1:45	TBD
    2:00	TBD

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