Get in Touch
 Duration 7 hours

Course Outline

Fundamentals of Smartsheets

  • Overview of Smartsheets: Definition and primary advantages for organizational use
  • Interface exploration: Menus, toolbars, sheets, and template structures
  • System navigation and initial sheet configuration
  • Summary of collaborative features available within the platform

Sheet Creation and Administration

  • Initializing new sheets from blank formats or pre-defined templates
  • Inserting and adjusting column parameters
  • Data management: Adding, modifying, and formatting row and cell content
  • Task administration: Assignment, status monitoring, and prioritization strategies
  • Implementation of filters and conditional formatting to enhance data clarity

Advanced Capabilities

  • Workflow automation: Configuration of reminders, approval chains, and system alerts
  • Application of formulas for computational tasks and data processing
  • Sheet interlinking: Cross-referencing mechanisms and VLOOKUP functions
  • Report generation: Consolidating data across multiple sheets

Collaboration and Distribution

  • Distribution of sheets, reports, and dashboards to authorized personnel
  • Management of user permissions and access controls
  • Utilization of commenting features for structured feedback and dialogue
  • Integration of files, hyperlinks, and annotations with specific tasks
  • Real-time collaboration and audit trails through cell history tracking

Dashboards and Reporting Metrics

  • Dashboard construction: Visual representation of project metrics and KPIs
  • Incorporation of charts, widgets, and reports into dashboard layouts
  • Customization of dashboard aesthetics to improve user interaction
  • Use of reports to synthesize data from various sheets

Operational Best Practices

  • Optimal organization of sheets, reports, and dashboards for project governance
  • Recommended protocols for team collaboration within Smartsheets
  • Strategies for enhancing productivity utilizing platform features
  • Inquiry handling and resolution of common technical challenges

Conclusion and Subsequent Actions

Requirements

  • Familiarity with foundational project management principles

Target Audience

  • End users

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories