**Prerequisite: Class #1: Excel Intro or equivalent experience. Importance of Absolute vs. Relative references. Common: SUM, AVERATE, MAX, MIN. Logical: IF, AND, SUMIF, COUNTIF. Class held in-person McConnell Center Computer Lab, Room 301   (more…)

In-Person Class, McConnell Center Computer Lab, Rm. 301 Shortcuts for managing large Excel databases. Sorting & filtering data, easy subtotals and outlines Excel tables to manage & summarize data. (more…)

Calculate data across worksheets. Use shortcuts for modifying data in multiple sheets. Use formulas to consolidate, separate, or modify text imported from your ERP. (more…)

Ever wonder how apps and websites are made? You’ll explore algorithms, coding structures, and web pages & apps with HTML, CSS, and JavaScript. Hear from developers and educators in the industry and learn about career opportunities. This class will meet online using Zoom on Mondays from 5:00 – 7:00 pm. No Class on Columbus Day (more…)

**Prerequisite – Class#1: Excel Intro or equivalent experience. Review of Excel Tables, Intro to Pivot Tables, Intro to Charts & Slicers, Intro to Conditional Formatting. This class is in-person McConnell Center Rm. 301 (more…)

**Prerequisite – Intro to Pivot Tables & Charts or equivalent experience Various ways to summarized data. Review of slicers, Calculating within a pivot table, custom grouping, intro to Dashboards. This class is in-person McConnell Center Rm. 301 (more…)

Prerequisite: Excel Formulas Data validation, Nested IF & IFS (IFS avail in Office 365 subscription or 2019 only), VLOOKUP with data validation, INDEX & MATCH functions, more as time allows! McConnell Center Computer Lab, Room 301   (more…)

*Must be comfortably familiar with a keyboard and mouse. Navigate the Excel workbook using the ribbon and keyboard shortcuts, create a basic worksheet using simple formulas, prepare a sheet or workbook for printing. McConnell Center Computer Lab, Room 301   (more…)

**Prerequisite: Class #1: Excel Intro or equivalent experience. Importance of Absolute vs. Relative references. Common: SUM, AVERATE, MAX, MIN. Logical: IF, AND, SUMIF, COUNTIF. Class held in-person McConnell Center Computer Lab, Room 301   (more…)

In-Person Class, McConnell Center Computer Lab, Rm. 301 Shortcuts for managing large Excel databases. Sorting & filtering data, easy subtotals and outlines Excel tables to manage & summarize data. (more…)