Updates to the Google Sheets Training Courses

Sep 18 announcement: Whew! This was a big task, but today I’m proud to announce that my video training courses are bang up-to-date! I sent out emails to students earlier today, announcing updates to 40 videos in my Google Sheets training courses.

Specifically:

Read on for more details.

UPDATED: Build Dashboards with Google Sheets and Data Studio

Dashboard on monitor screen

I launched the Google Sheets dashboard course in early 2017 and since then Google has updated the Pivot Table UX and the Chart Tool UX. The underlying functionality hasn’t changed, but things look a bit different now.

Today I’m happy to announce that I’ve updated 26 of the videos in this course to reflect these changes.

  • Lessons 9 – 15, 17 – 19, 27, 30 – 37, 41 – 44 and 54 have been updated to show the dashboard build process with the new Pivot Tables and Chart Editor tool. The material is the same and the changes are purely cosmetic.
  • Lesson 20, on how to share your dashboard, has been updated to show the new Print menu options and to show that sparklines now work in Sheets published to the web.
  • Lesson 70 has been updated to show the Apps Script triggers menu, which moved from under the Resources menu to the Edit menu in the Apps Script editor window.

Check out the updated Dashboard course here >>

Happy Dashboarding!

UPDATED: Data Cleaning and Pivot Table in Google Sheets

Data Cleaning in Google Sheets

I launched the Data Cleaning and Pivot Table in Google Sheets course in mid-2017 and since then Google has updated the Pivot Table UX and the Chart Tool UX. The underlying functionality hasn’t changed, but things look a bit different now.

Today I’m happy to announce that I’ve updated 14 of the videos in this course to reflect these changes:

  • Lessons 22 – 35 have all been updated to show the new Pivot Tables and Chart Editor tool. The materials are the same.

In addition:

  • Lesson 26 shows how to use the new date grouping feature in Pivot Tables, which obviates the tedious workflow of creating a helper column to calculate the grouping manually.
  • Lesson 27 shows how to do percentage calculations in Pivot Tables using the new functionality.
  • Lesson 28, on formatting Pivot Tables, has been completely updated to reflect the new Pivot Tables and best practices.

Check out the updated Data Cleaning and Pivot Tables course here >>

Happy learning!

Leave a Reply

Your email address will not be published. Required fields are marked *