Pivot Tables and Pivot Charts
Data Cleaning
SEM
Lookups & Advanced Excel
Excel for KPI Dashboard
This Inclusive Internet Index spreadsheet demonstrates the use of Pivot Tables and Privot Charts for exploring data relationships.
This data cleaning example uses a number of complex formulas to clean data prior to use. Click the button below to view a guide I developed for my classes for data cleaning in excel.
This search engine marketing (SEM) spreadsheet is designed to calculate absolute profit. Click the button below to view a guide I developed for calculating CPM
This cost estimating spreadsheet uses Vlookups and Hlookups to return values off several two-dimensional "named" tables. Error-handling and conditional formatting are used to help users know when data are correctly input.
In 2018-2019 as the Graphic Communications Education Association (GCEA) President, I chaired and served as lead author of their 5-year Strategic Plan, available by clicking on the button below. As part of this plan, our team developed KPIs to measure the Executive Board's performance, shown in the image below.