Smartsheet Project Management Online Bootcamp: Data Modeling + Dashboards

Learn how to extract data from a database using SQL

This Bootcamp is live and instructor led
Price $149
What the heck is Smartsheet?
Smartsheet is the new kid in school for project management. It's the steroid version of Excel for project managers. In Smartsheet, users can create various project management reports and dashboards to present various project management KPIs.
This Bootcamp is best for those in the project management field or who want to learn more about project management. Because Smartsheet and Excel have many similarities (though Smartsheet is way more efficient and user friendly!), all students are required to have intermediate Excel skills in the following functions: Vlookup, if statements, sumifs, averageifs, countifs.

Taught by: Whitney Pettis, MBA


Course Schedule
Course Dates: February 7th - February 17th
Days of the week: Weeknights (Mondays - Thursdays)
Time (EST): 800p - 900p EST

Course 1: Data Importing + Modeling

Monday, February 7th | 8:00p - 9:00p

  • Import data from Excel
  • Model imported data with formulas
    • Vlookup
    • If Statements
    • Aggregate If Statements

Course 2: Summary KPIs

Tuesday, February 8th | 8:00p - 9:00p

  • Calculate sheet KPIs with summaries and formulas

Course 3: Reports 

Wednesday, February 9th | 8:00p - 9:00p

  • Reports vs. sheets
  • Gantt view

Course 4: Dashboard Formatting (Part 1)

Thursday, February 10th | 8:00p - 9:00p

  • Overview of chart types and formatting

Course 5: Dashboard Formatting (Part 2)

Tuesday, February 15th | 8:00p - 9:00p

  • Reports vs. Embeds

Course 6: Dashboard Formatting (Part 3)

Wednesday, February 16th | 8:00p - 9:00p


Course 7: Sharing Options

Thursday, February 17th | 8:00p - 9:00p

  • Overview of various sharing options
    • Workspaces

 

 

Course materials (including installation guides), access codes, and reminders will be sent 7 days prior to the start of the first course of the Bootcamp.

 

What's Included:

Certificate of Completion
You will receive a certificate of completion upon individual completion and submission of all homework assignments and portfolio by the specified deadline.

 

 

 

Refund Policy: No refunds and/or transfers

 

$149.00