Skip to content Skip to site navigation Skip to service navigation

Excel Level 1 (Virtual Class)

Class Sessions

Date Cost
  • Tue May 28, 9:00 am to 4:00 pm
$250

Class Code

ITS-V0111

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

 

Charts

  • 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

  • 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.