Skip to content Skip to site navigation Skip to service navigation

Excel Basics: Workbooks, Worksheets, and Manipulating Cell Data

Class Code

ITS-1201

Class Description

Effective immediately in response to COVID-19, most Technology Training classes will be delivered online until further notice.

In advance of each session, Tech Training will provide you with a Zoom link to your class, along with any required class materials.
 


This class covers several key skills and concepts new Excel users should be without. Discover the crucial basics of Excel: how to create and format spreadsheets, how to use simple formulas and functions, and much more.
 

Topics covered include:

  • How to create, save, and manage Excel workbooks.
  • The most essential Excel shortcuts for you to use.
  • How to create, rename, modify, and manage Excel worksheets.
  • Two techniques to move or copy worksheets within and between workbooks.
  • How and why to hide and unhide worksheets.
  • The best practices to enter data in Excel.
  • Intricacies of the fill-series tool to copy and fill data efficiently.
  • The magic of the FlashFill command -- one of the simplest ways to transform data.
  • Understand the power behind Excel formulas.
  • Create simple formulas with standard arithmetic operators.
  • Relative, absolute, and mixed cell references and why they are important for you to understand.
  • Get started with Excel functions - understand their "anatomy" and why they are so powerful.
  • Create formulas to summarize numbers with SUM, AVERAGE, MAX, MIN functions.
  • The subtle differences between COUNT, COUNTA, and COUNTBLANK functions.
  • How to format your spreadsheets quickly and easily.
  • Secrets of number formatting in Excel.
  • How to use Search and Replace in Excel.
  • Extremely useful tips and tricks to help you get more efficient and productive.
  • And much more.

 

Prerequisites

Participants should already have some exposure to Microsoft Office programs and should be comfortable using a computer. Ideally, participants will already be using Excel as part of their job.

 


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

University IT Technology Training classes are only available to Stanford University staff, faculty, students, and Stanford Hospitals & Clinics employees, including Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health. A valid SUNet ID is needed to enroll in a class.