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:


Printer Friendly Version (pdf)

excel and your data

Transforming data into information

GCF Learn Free

To learn more about Microsoft Excel 2016, check out GCFLearnFree. This non-profit organization provides excellent tutorials and video on Excel and much more.