Workshop Dates

Excel Essentials: November 16, 2017 at 2 pm, classroom B02, Raether Library

  • Tables vs Ranges
  • Subtotals
  • Text functions
  • Advanced functions (IF, VLOOKUP, COUNTIF, Goal Seek, Solver)
  • Date conversions

Data Visualization in Excel: November 30, 2017 at 2 pm, classroom B02, Raether

  • How to work with multiple worksheets
  • How to build graphs and traditional charts
  • Line-bar combination charts and interactive charts
  • Pivot tables to create summaries
  • Integrating multiple data sources in a dashboard
  • Creating basic infographics
  • (Prerequisite:  Proficiency manipulating data in Excel or the Excel Essentials workshop)

Introduction to Excel: no workshops Fall 2017

  • Workbook vs. worksheet
  • File management
  • Navigation and toolbars
  • Cells – references and formatting
  • Simple formulas and autofill
  • Sorting (and tables)
  • Filtering
  • Find and replace
  • Conditional formatting
  • Data validation