Before each session, Tech Training will provide a Zoom link for live online classes, along with any required class materials.
Note: This class offers an option for online and in-classroom sessions. Participants attending an in-person class will need to adhere to the Stanford Health Check guidelines.
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 track updates and information visually
- 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
