• Home
  • OS Excel Workshops - New and Improved!

OS Excel Workshops - New and Improved!

OS is offering a set of Excel workshops in November exclusively for OS students. The set will consist of a 1-hour basic topics course and a 2-hour advanced topics course. Students are welcome to take one or both workshops.



OS Excel Workshop: Basic Topics

OS is offering a series of Excel workshops in September and November exclusively for OS students. September series is perfect for students looking to acquire new skills before hitting the job market or internship search. November series is perfect for the students in OS410 to refresh their excel skills. Each series will consist of a 1-hour basic course and a 2-hour advanced course. Students are welcome to take one or both workshops.

Session 1: Basic Topics

Session Is Over
-
ISS, MLB 2001A, PC-LAB
Select
Selected
Deselect

Session 2: Basic Topics

Session Is Over
-
ISS, MLB 2001A, PC-LAB
The Basic Topics include:
Number formatting - Dates, decimals, currency, phone numbers, etc.
Format painter
Basic formulas & functions - Importance of using cell references, simple calculations, SUM, other basic functions
Cut & paste vs. insert cut cells
AutoFill
Freeze panes
Multiple sheets - Rename, move/copy, delete, etc.
*Please note: Students enrolled in OS410 have priority registration for this session
Select
Selected
Deselect

Session 2: Advanced Topics

Session Is Over
-
ISS, MLB 2001A, PC-LAB
Conditional formatting
Calculations across multiple sheets
Print Formatting - Set print area, repeating headers, controlling print size, gridlines, headers & footers
Advanced Functions - AutoFill, Date & Time, VLOOKUP, IF, text functions
Data Analysis - Sorting, filtering, subtotals, pivot tables
Charts - bar and pie charts, scatter plots
Statistic functions - ttest, etc.
*Please note: Students enrolled in OS410 have priority registration for this session
Select
Selected
Deselect
For questions or contact information click here
You May Choose A Session From Each Set