Skip to content Skip to site navigation Skip to service navigation

Excel Level 1 (Virtual Class)

Class Sessions

No classes match your filter. Remove or modify some filters to try again.

Class Code


Class Description

​​Learn how to create and develop Excel worksheets and workbooks in order to work with and analyze data.

Topics covered include: 

  • Get started with Microsoft Office Excel 
  • Perform calculations 
  • Modify a worksheet 
  • Format a worksheet 
  • Print workbooks 
  • Manage workbooks


Create, Open and Save Workbooks

  • What is Excel? 
  • Create a New Blank Workbook 
  • Create a Workbook From a Template 
  • Open Excel Files 
  • Get Help 
  • Save Workbooks 
  • Navigate a Workbook


Explore the User Interface

  • Backstage View 
  • Ribbon Overview 
  • Mini Toolbar 
  • Status Bar 
  • Shortcut Key Tips 
  • Contextual Tabs 


Work with Data

  • Enter, Edit and Delete Data
  • Data Selection Methods
  • Use Autofill and Autocomplete
  • Cut, Copy, Paste and Paste Special
  • Resize Columns and Rows
  • Insert and Delete Columns, Rows, Cells
  • Use Undo, Redo and Repeat
  • Spellcheck and AutoCorrect
  • Use Find, Replace and Go To
  • Use Basic Functions
  • Use SmartTags and Options Buttons
  • Add, Edit, and Remove Comments


Format A Workbook

  • Format Using the Home Ribbon
  • Format Using the Mini-Toolbar
  • Format Using Dialog Boxes
  • Use and Modify Conditional Formatting
  • Use the Format Painter
  • Create and Modify Styles
  • Add, Name, Move, Delete and Colour Sheets



  • Create and Format a Chart
  • Modify Chart Layout and Structure
  • Change Chart Types, Options, Location and
  • Data Source
  • Save a Chart as a Template


Printing and Viewing A Workbook

  • Use the View Ribbon
  • Split and Freeze
  • Manage Multiple Windows
  • Use Page Layout, Print Preview and Basic
  • Print Options
  • Add Headers and Footers



  • Customize the Quick Access Toolbar
  • Show/Hide the Ribbon


University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.