Skip to content Skip to site navigation Skip to service navigation

Smartsheet Essentials: Collaborate and Manage Spreadsheets and Projects

Class Sessions

Date Location Cost
  • Wed Oct 9, 9:00 am to 12:00 pm
Birch Hall 107 (Birch Lab B) $280
  • Mon Dec 9, 9:00 am to 12:00 pm
Birch Hall 105 (Birch Lab A) $280

Class Code

ITS-2040

Class Description

This course is designed for new users who wish to gain a foundational understanding of the Smartsheet collaborative environment.

This class will explore the basics of creating and managing work within a single sheet. You will be introduced to cell linking, reporting, and automated alerts and actions. You will explore the different Smartsheet views and how these views can maximize engagement and organization. You will also find out more about the many ways to collaborate inside of Smartsheet through sharing, sending, publishing, and update requests to internal and external collaborators.

Discover how Smartsheets can help increase work agility and collaboration by providing a powerful platform for planning, organizing, managing, reporting, and automating work.

Pre-requisites:

Students should have a basic knowledge of Excel.

 

Upon completion, participants should be able to:

- Implement organizational best practices to increase readability

- Use the appropriate Smartsheet features to collaborate effectively

- Visualize your work by leveraging all the views in Smartsheet

 

Course Content: 

Create

- Maneuver Smartsheet environment by learning how to create and organize your work

- Organize work with hierarchies 

- Edit columns to improve sheet functionality

- Increase efficiency with different formatting and viewing

- Centralize communication with the use of comments and attachments

- Create basic formulas

- Introduction to the views: Gantt, Calendar & Card

- Fundamentals of Project Management in Smartsheet

 

Collaboration

- Use update requests to obtain information from external collaborators

- Build conditional formatting rules to visually track updates and information

- Set up automated alerts and actions to notify collaborators

- Set row and sheet level reminders

 

Communication

- Send work via sending a row and sending a sheet

- Share work by inviting collaborators and assigning permission levels

- Print and publish sheets to allow greater audiences to view your work

- Cell link an individual cell across sheets

- Create a report based off of single criteria
 


 

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.