Skip to main content

Smartsheet Bootcamp for Proficiency Certification

Before each live online session, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

This bootcamp provides in-depth training on Smartsheet's capabilities, including project management, collaboration, workflow automation, reporting, and strategic application of tools, to prepare participants for the Smartsheet Proficiency Certification.

Program Description

Objective:
Equip learners with the knowledge and skills to confidently use Smartsheet for project management, collaboration, data organization, and strategic reporting. Prepare learners for the Technology Training proficiency certification exam and practical exercise.

This Smartsheet Proficiency Certification Bootcamp comprehensively explores Smartsheet's functionality, from foundational tools to advanced features. Participants will gain hands-on experience managing projects, streamlining workflows, and creating strategic reports and dashboards while considering best practices for effective data presentation and communication. The course concludes with a certification exam and practical exercise to showcase proficiency.

Whether managing team projects or implementing Smartsheet for organizational success, this course ensures participants have the skills and confidence to apply Smartsheet effectively in real-world scenarios. The course also covers important soft skills for Smartsheet use, such as assessing needs before building a report or dashboard, best practices for data presentation, and fostering trust and transparency when sharing information.

Learning Objectives

Learning Objectives
By the end of this course, participants will have the opportunity to:

1. Build Smartsheet projects with Gantt charts, milestones, and task dependencies.
2. Design reports and dashboards to present data visually and communicate insights effectively, considering the audience and data presentation best practices.
3. Implement secure collaboration using permissions, notifications, and update requests, promoting trust and transparency.
4. Configure automated workflows to optimize efficiency and ensure task tracking.
5. Apply advanced Smartsheet features like forms, cross-sheet references, and integrations.

Topic Outline

List of Topics
Introduction to Smartsheet
- Overview of key features and applications
- Navigating the interface and understanding sheet views

Creating and Managing Sheets
- Exploring sheet types: Grid, Card, Gantt, and Calendar
- Configuring columns, using formulas, and setting up cross-sheet references

Collaboration and Sharing
- Managing permissions and secure sharing options
- Using comments, notifications, and update requests
- Best practices for sharing and publishing (web, PDF, etc.)

Project Management Essentials
- Creating and updating Gantt charts with task dependencies
- Tracking resource allocation and identifying the Critical Path

Reporting and Dashboards
- Generating actionable reports with dynamic filters
- Pre-planning and Needs Assessment
- Questions to consider before creating a report/summary.
- Crafting interactive dashboards with widgets and metrics
- Best practices for dashboard presentation

Workflows and Data Collecting
- Setting up automation workflows for task updates and reminders
- Capturing data with Smartsheet forms

Proficiency Certification Preparation
- Reviewing key concepts and practical applications
- Completing the certification exam and work on the practical exercise

Additional Resources
- Course materials (PDFs, templates, and quick-reference guides).
- Access to Smartsheet¿s Learning Center and Community Forums.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training.

Special Group Rates

For groups of 5 or more, special rates are available. Please contact techtraining@stanford.edu for more details.


University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.