Excel Training
Time: 10:30AM - 12:00PM
Location: 136 Kokosing Hall (In-Person Space is limited to 30 individuals; Virtual on Zoom unlimited)
Feb. 18: Session I Excel Introductory (Limit 30)
Feb. 25: Session II Excel Intermediate (Limit 30)
Mar. 11: Session III Excel Advanced (Limit 30)
Mar. 18: Session IV Excel Open Office Hours (Limit 30)
Feb 18: Introductory skills
Session I
- open and saving files
- formatting
- freeze top row
- freeze panes
- inserting columns and rows
- copy paste
- data validation
- filtering
- sorting
- concatenate
- text to columns
- conditional formatting
- remove duplicates
Feb 25: Intermediate skills
Session II
- formulas (adding cells (math), sum, counta, count blanks)
- named ranges i.e. (average, mode, median)
- absolute cell reference (countif, sumif)
Mar 11: Intermediate skills
Session III
- vlookup
- hlookup
- index match
- xlookup
- Charts (bar chart, pie chart sparklines, pivot tables)
- Automation
- GenAI
March 18: Open Office Hour
Session IV
- open office
- bring your own exact problems and we point you in the right direction