- Discover CSUB
- |
- Academics
- |
- Admissions
- |
- Student Life
- ASI (Student Government)
- Antelope Valley Campus
- Bookstore
- Campus Dining
- Campus Programming
- Career Education and Community Engagement (CECE)
- Children's Center
- Counseling Center
- Graduate Student Center
- Health Center
- Housing and Residence Life
- Services for Students with Disabilities
- Student Financial Services
- Student Organizations
- Student Recreation Center
- Student Rights and Responsibilities
- Student Union
- Vice President for Student Affairs
- Wellness
- |
- Athletics
- |
- News & Information
Excel 2016 and Student Data
In this session, you will create a new workbook, use basic formulas, and apply formatting. Additionally, you will download data from myCSUB and perform various formula and functions.
Session Length: 2 Hours
Intended Audience: Any CSUB Staff or Faculty
Prerequisites: Familiarity with Microsoft Word 2016
Format: Presentation and Hands-on activities
Covers:
- Basic Excel Concepts
- Query Data
- Formatting Data
- Basic Formulas and Functions
- Sorting Columns
- Hiding Columns
- Freezing Panes
- Filtering Data
- Conditional Formatting
- Sub-totaling
- Pivot Tables
- Printing
Session Documents:
- Training Handout (.pdf)
- Quick Start Guide
- Donations (.xlsx)
- Students (.xlsx)
- Final Document (.xlsx)
Printer Friendly Version (pdf)
To learn more about Microsoft Excel 2016, check out GCFLearnFree. This non-profit organization provides excellent tutorials and video on Excel and much more.